From c56015c5c73861b5f794cac48064d0394f8fd37d Mon Sep 17 00:00:00 2001
From: pansen <pansen626@sina.com>
Date: 星期二, 02 四月 2019 15:48:39 +0800
Subject: [PATCH] 对抓拍记录的picMaxUrl字段赋值(大图路径)
---
QiaoJiaSystem/DataManagerServer/vss/dao/BaseSqliteDao.h | 56 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 56 insertions(+), 0 deletions(-)
diff --git a/QiaoJiaSystem/DataManagerServer/vss/dao/BaseSqliteDao.h b/QiaoJiaSystem/DataManagerServer/vss/dao/BaseSqliteDao.h
index 88ae76a..e30ed59 100644
--- a/QiaoJiaSystem/DataManagerServer/vss/dao/BaseSqliteDao.h
+++ b/QiaoJiaSystem/DataManagerServer/vss/dao/BaseSqliteDao.h
@@ -18,6 +18,62 @@
BaseSqliteDao::m_pModel = lDBTool->get_m_pModel();
BaseSqliteDao::m_mutexVisit = lDBTool->get_m_mutexVisit();
}
+ static string getColumnNames(std::map<std::string, std::string>& columns) {
+ string columnNames;
+ auto size = columns.size();
+ int i = 0;
+ for (auto column : columns) {
+ columnNames.append(column.first);
+ if (i != size - 1) {
+ columnNames.append(",");
+ }
+ i++;
+ }
+ return columnNames;
+ }
+ static string getColumnValues(std::map<std::string, std::string>& columns) {
+ string columnValues;
+ auto size = columns.size();
+ int i = 0;
+ for (auto column : columns) {
+ columnValues.append("'"+column.second+"'");
+ if (i != columns.size() - 1) {
+ columnValues.append(",");
+ }
+ i++;
+ }
+ return columnValues;
+ }
+ static string getColumnNameValuePair(std::map<std::string, std::string>& columns) {
+ string columnNameValuePair;
+ auto size = columns.size();
+ int i = 0;
+ for (auto column : columns) {
+ columnNameValuePair.append(column.first);
+ columnNameValuePair.append("=");
+ columnNameValuePair.append("'"+column.second+"'");
+
+ if (i != size - 1) {
+ columnNameValuePair.append(",");
+ }
+ i++;
+ }
+ return columnNameValuePair;
+ }
+ static string getWhereColumnNameValuePair(std::map<std::string, std::string>& columns) {
+ string columnNameValuePair;
+ auto size = columns.size();
+ int i = 0;
+ for (auto column : columns) {
+ columnNameValuePair.append(" and ");
+ columnNameValuePair.append(column.first);
+ columnNameValuePair.append("=");
+ columnNameValuePair.append("'"+column.second+"' ");
+
+ i++;
+ }
+ return columnNameValuePair;
+ }
};
LDBTool* BaseSqliteDao::lDBTool = nullptr;
--
Gitblit v1.8.0