| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | if (str_tableUuid.size() > 0) { |
|---|
| | | // QString sql = QString::fromStdString( |
|---|
| | | // "Select b.uuid as id,b.faceUrl as img,a.idCard as idcard,a.enable,a.monitorLevel from '" + str_tableUuid + |
|---|
| | | // "' as a, '" + str_tableUuid + "_fea' As b where a.uuid = b.uuid and ( a.del_flag=0 AND b.del_flag=0);"); |
|---|
| | | QString sql = QString::fromStdString( |
|---|
| | | "Select b.uuid as id,b.faceUrl as img,a.idCard as idcard,a.enable,a.monitorLevel from '" + str_tableUuid + |
|---|
| | | "Select b.uuid as id,b.faceUrl as img,a.idCard as idcard from '" + str_tableUuid + |
|---|
| | | "' as a, '" + str_tableUuid + "_fea' As b where a.uuid = b.uuid and ( a.del_flag=0 AND b.del_flag=0);"); |
|---|
| | | QSqlQuery query(g_syncDbFile); |
|---|
| | | query.prepare(sql); |
|---|
| | |
|---|
| | | t_feature_info.id = query.value(0).toString().toStdString(); |
|---|
| | | t_feature_info.img = query.value(1).toString().toStdString(); |
|---|
| | | t_feature_info.idcard = query.value(2).toString().toStdString(); |
|---|
| | | t_feature_info.enable = query.value(3).toString().toStdString(); |
|---|
| | | t_feature_info.monLevel = query.value(4).toString().toStdString(); |
|---|
| | | // t_feature_info.enable = query.value(3).toString().toStdString(); |
|---|
| | | // t_feature_info.monLevel = query.value(4).toString().toStdString(); |
|---|
| | | |
|---|
| | | dataCache.insert(std::make_pair(t_feature_info.id, t_feature_info)); |
|---|
| | | } |
|---|
