From 17675f1c6447b6e014b520608ce6d5f1f2e9707a Mon Sep 17 00:00:00 2001
From: xuxiuxi <554325746@qq.com>
Date: 星期一, 04 三月 2019 16:28:42 +0800
Subject: [PATCH] add models, daos and controllers for tables.

---
 QiaoJiaSystem/DataManagerServer/vss/controller/VssLocalSettingTblController.h |  593 +++++++++++++++++++++++++++++-----------------------------
 1 files changed, 295 insertions(+), 298 deletions(-)

diff --git a/QiaoJiaSystem/DataManagerServer/vss/controller/VssLocalSettingTblController.h b/QiaoJiaSystem/DataManagerServer/vss/controller/VssLocalSettingTblController.h
index 3afd070..13c8d09 100755
--- a/QiaoJiaSystem/DataManagerServer/vss/controller/VssLocalSettingTblController.h
+++ b/QiaoJiaSystem/DataManagerServer/vss/controller/VssLocalSettingTblController.h
@@ -1,298 +1,295 @@
-#ifndef VSSLOCALSETTINGTBL_CONTROLLER_H
-#define VSSLOCALSETTINGTBL_CONTROLLER_H
-
-#include <string>
-#include <DataManagerServer/http_configserver.h>
-#include "vss/dao/VssLocalSettingTblDao.h"
-#include "vss/dao/VssLocalSettingTblSqliteDao.h"
-#include "vss/model/VssLocalSettingTblBuilder.h"
-#include "vss/model/VssLocalSettingTbl.h"
-#include "VssBaseController.h"
-#include <mysql++.h>
-
-using namespace std;
-
-/**
- * 鏈湴鍥芥爣閰嶇疆
- */
-class VssLocalSettingTblController : public VssBaseController {
-private:
-	/** 鏈湴鍥芥爣閰嶇疆鏋勯�犲嚱鏁� */
-	VssLocalSettingTblController() {}
-public:
-	/** 鏈湴鍥芥爣閰嶇疆鍗曚緥妯″紡 */
-    static VssLocalSettingTblController* instance() {
-        static VssLocalSettingTblController instance;
-        return &instance;
-    }
-public:
-	/** 娉ㄥ唽{label}http鏈嶅姟 */
-    void registerHttpServices(HttpSrvRetRecieve& _HttpSrvRetRecieve) {
-
-	    _HttpSrvRetRecieve.setInfo("^/addVssLocalSettingTbl$", "POST",
-	                               std::bind(&VssLocalSettingTblController::addVssLocalSettingTbl, this,
-	                                         std::placeholders::_1, std::placeholders::_2,
-	                                         std::placeholders::_3, std::placeholders::_4));
-	
-	    _HttpSrvRetRecieve.setInfo("^/delVssLocalSettingTbl$", "POST",
-	                               std::bind(&VssLocalSettingTblController::delVssLocalSettingTbl, this,
-	                                         std::placeholders::_1, std::placeholders::_2,
-	                                         std::placeholders::_3, std::placeholders::_4));
-	
-	    _HttpSrvRetRecieve.setInfo("^/updateVssLocalSettingTbl$", "POST",
-	                               std::bind(&VssLocalSettingTblController::updateVssLocalSettingTbl, this,
-	                                         std::placeholders::_1, std::placeholders::_2,
-	                                         std::placeholders::_3, std::placeholders::_4));
-	
-	    _HttpSrvRetRecieve.setInfo("^/findVssLocalSettingTbl$", "POST",
-	                               std::bind(&VssLocalSettingTblController::findVssLocalSettingTbl, this,
-	                                         std::placeholders::_1, std::placeholders::_2,
-	                                         std::placeholders::_3, std::placeholders::_4));
-	
-	    _HttpSrvRetRecieve.setInfo("^/findVssLocalSettingTblList$", "POST",
-	                               std::bind(&VssLocalSettingTblController::findVssLocalSettingTblList, this,
-	                                         std::placeholders::_1, std::placeholders::_2,
-	                                         std::placeholders::_3, std::placeholders::_4));
-
-    }
-public:
-	/** 娣诲姞鏈湴鍥芥爣閰嶇疆 */
-    std::string addVssLocalSettingTbl(std::string ip, unsigned int port, std::string content, PResponse &response) {
-        Json::Reader requestJsonReader;
-        Json::Value requestJsonValue;
-        Json::Value responseJsonValue;
-        responseJsonValue["message"] = "娣诲姞澶辫触锛�";
-        responseJsonValue["success"] = "false";
-        if (requestJsonReader.parse(content, requestJsonValue)) {
-            VssLocalSettingTblBuilder vssLocalSettingTblBuilder;
-	    
-	    	Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];
-            if (iDJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addID(iDJsonValue.asInt());
-            }
-	    
-	    	Json::Value serverIpJsonValue = requestJsonValue[VssLocalSettingTbl_ServerIp];
-            if (serverIpJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerIp(serverIpJsonValue.asString());
-            }
-	    
-	    	Json::Value serverPortJsonValue = requestJsonValue[VssLocalSettingTbl_ServerPort];
-            if (serverPortJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerPort(serverPortJsonValue.asString());
-            }
-	    
-	    	Json::Value serverIdJsonValue = requestJsonValue[VssLocalSettingTbl_ServerId];
-            if (serverIdJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerId(serverIdJsonValue.asString());
-            }
-	    
-	    	Json::Value userAuthIdJsonValue = requestJsonValue[VssLocalSettingTbl_UserAuthId];
-            if (userAuthIdJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addUserAuthId(userAuthIdJsonValue.asString());
-            }
-	    
-	    	Json::Value passwordJsonValue = requestJsonValue[VssLocalSettingTbl_Password];
-            if (passwordJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addPassword(passwordJsonValue.asString());
-            }
-	    
-	    	Json::Value updateTimeJsonValue = requestJsonValue[VssLocalSettingTbl_UpdateTime];
-            if (updateTimeJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addUpdateTime(updateTimeJsonValue.asString());
-            }
-	    	auto keyValuesToAdd = vssLocalSettingTblBuilder.buildVssLocalSettingTblMap();
-	    	if (keyValuesToAdd.size() > 0) {
-                responseJsonValue = VssLocalSettingTblSqliteDao::instance()->addVssLocalSettingTbl(keyValuesToAdd);
-            }
-        }
-        return responseJsonValue.toStyledString();
-    }
-    
-    /** 鍒犻櫎鏈湴鍥芥爣閰嶇疆 */
-    std::string delVssLocalSettingTbl(std::string ip, unsigned int port, std::string content, PResponse &response) {
-        Json::Reader requestJsonReader;
-        Json::Value requestJsonValue;
-        Json::Value responseJsonValue;
-        responseJsonValue["message"] = "鍒犻櫎澶辫触锛�";
-        responseJsonValue["success"] = "false";
-        if (requestJsonReader.parse(content, requestJsonValue)) {
-        	Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];
-        	if (iDJsonValue.type() != Json::ValueType::nullValue) {
-        		string iDValue = iDJsonValue.asString();
-        		responseJsonValue = VssLocalSettingTblSqliteDao::instance()->deleteByColumn("ID", iDValue);
-            }
-            
-        }
-        return responseJsonValue.toStyledString();
-    }
-    
-    /** 鏇存柊鏈湴鍥芥爣閰嶇疆 */
-    std::string updateVssLocalSettingTbl(std::string ip, unsigned int port, std::string content, PResponse &response) {
-        Json::Reader requestJsonReader;
-        Json::Value requestJsonValue;
-        Json::Value responseJsonValue;
-        responseJsonValue["message"] = "鏇存柊澶辫触锛�";
-        responseJsonValue["success"] = "false";
-        if (requestJsonReader.parse(content, requestJsonValue)) {
-            VssLocalSettingTblBuilder vssLocalSettingTblBuilder;
-	    
-	    	Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];
-            if (iDJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addID(iDJsonValue.asInt());
-            }
-	    
-	    	Json::Value serverIpJsonValue = requestJsonValue[VssLocalSettingTbl_ServerIp];
-            if (serverIpJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerIp(serverIpJsonValue.asString());
-            }
-	    
-	    	Json::Value serverPortJsonValue = requestJsonValue[VssLocalSettingTbl_ServerPort];
-            if (serverPortJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerPort(serverPortJsonValue.asString());
-            }
-	    
-	    	Json::Value serverIdJsonValue = requestJsonValue[VssLocalSettingTbl_ServerId];
-            if (serverIdJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerId(serverIdJsonValue.asString());
-            }
-	    
-	    	Json::Value userAuthIdJsonValue = requestJsonValue[VssLocalSettingTbl_UserAuthId];
-            if (userAuthIdJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addUserAuthId(userAuthIdJsonValue.asString());
-            }
-	    
-	    	Json::Value passwordJsonValue = requestJsonValue[VssLocalSettingTbl_Password];
-            if (passwordJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addPassword(passwordJsonValue.asString());
-            }
-	    
-	    	Json::Value updateTimeJsonValue = requestJsonValue[VssLocalSettingTbl_UpdateTime];
-            if (updateTimeJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addUpdateTime(updateTimeJsonValue.asString());
-            }
-        	if (iDJsonValue.type() != Json::ValueType::nullValue) {
-        		string iDValue = iDJsonValue.asString();
-                if (iDValue.size() > 0 && VssLocalSettingTblSqliteDao::instance()->updateVssLocalSettingTbl(vssLocalSettingTblBuilder.buildVssLocalSettingTblMap(), "ID", iDValue)) {
-        			responseJsonValue["success"] = "true";
-        			responseJsonValue["message"] = "鏇存柊鎴愬姛锛�";
-	            }
-            }
-        }
-        return responseJsonValue.toStyledString();
-    }
-    
-    /** 鏌ユ壘鍗曚釜鏈湴鍥芥爣閰嶇疆 */
-    std::string findVssLocalSettingTbl(std::string ip, unsigned int port, std::string content, PResponse &response) {
-        Json::Reader requestJsonReader;
-        Json::Value requestJsonValue;
-        Json::Value responseJsonValue;
-        responseJsonValue["message"] = "鏌ヨ澶辫触锛�";
-        responseJsonValue["success"] = "false";
-        if (requestJsonReader.parse(content, requestJsonValue)) {
-            VssLocalSettingTblBuilder vssLocalSettingTblBuilder;
-	    
-	    	Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];
-            if (iDJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addID(iDJsonValue.asInt());
-            }
-	    
-	    	Json::Value serverIpJsonValue = requestJsonValue[VssLocalSettingTbl_ServerIp];
-            if (serverIpJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerIp(serverIpJsonValue.asString());
-            }
-	    
-	    	Json::Value serverPortJsonValue = requestJsonValue[VssLocalSettingTbl_ServerPort];
-            if (serverPortJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerPort(serverPortJsonValue.asString());
-            }
-	    
-	    	Json::Value serverIdJsonValue = requestJsonValue[VssLocalSettingTbl_ServerId];
-            if (serverIdJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerId(serverIdJsonValue.asString());
-            }
-	    
-	    	Json::Value userAuthIdJsonValue = requestJsonValue[VssLocalSettingTbl_UserAuthId];
-            if (userAuthIdJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addUserAuthId(userAuthIdJsonValue.asString());
-            }
-	    
-	    	Json::Value passwordJsonValue = requestJsonValue[VssLocalSettingTbl_Password];
-            if (passwordJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addPassword(passwordJsonValue.asString());
-            }
-	    
-	    	Json::Value updateTimeJsonValue = requestJsonValue[VssLocalSettingTbl_UpdateTime];
-            if (updateTimeJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addUpdateTime(updateTimeJsonValue.asString());
-            }
-	        responseJsonValue["message"] = "鏌ヨ鎴愬姛锛�";
-	        responseJsonValue["success"] = "true";
-	    	responseJsonValue["data"] = VssLocalSettingTblSqliteDao::instance()->findJsonArray(string("select * from ") + VSSLocalSettingTbl_TABLE_NAME + " where 1 = 1 limit 1");
-        }
-        return responseJsonValue.toStyledString();
-    }
-    
-    /** 鏌ユ壘鏈湴鍥芥爣閰嶇疆鍒楄〃 */
-    std::string findVssLocalSettingTblList(std::string ip, unsigned int port, std::string content, PResponse &response) {
-        Json::Reader requestJsonReader;
-        Json::Value requestJsonValue;
-        Json::Value responseJsonValue;
-        responseJsonValue["message"] = "鏌ヨ澶辫触锛�";
-        responseJsonValue["success"] = "false";
-        if (content == "" || requestJsonReader.parse(content, requestJsonValue)) {
-            VssLocalSettingTblBuilder vssLocalSettingTblBuilder;
-	    
-	    	Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];
-            if (iDJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addID(iDJsonValue.asInt());
-            }
-	    
-	    	Json::Value serverIpJsonValue = requestJsonValue[VssLocalSettingTbl_ServerIp];
-            if (serverIpJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerIp(serverIpJsonValue.asString());
-            }
-	    
-	    	Json::Value serverPortJsonValue = requestJsonValue[VssLocalSettingTbl_ServerPort];
-            if (serverPortJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerPort(serverPortJsonValue.asString());
-            }
-	    
-	    	Json::Value serverIdJsonValue = requestJsonValue[VssLocalSettingTbl_ServerId];
-            if (serverIdJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addServerId(serverIdJsonValue.asString());
-            }
-	    
-	    	Json::Value userAuthIdJsonValue = requestJsonValue[VssLocalSettingTbl_UserAuthId];
-            if (userAuthIdJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addUserAuthId(userAuthIdJsonValue.asString());
-            }
-	    
-	    	Json::Value passwordJsonValue = requestJsonValue[VssLocalSettingTbl_Password];
-            if (passwordJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addPassword(passwordJsonValue.asString());
-            }
-	    
-	    	Json::Value updateTimeJsonValue = requestJsonValue[VssLocalSettingTbl_UpdateTime];
-            if (updateTimeJsonValue.type() != Json::ValueType::nullValue) {
-                vssLocalSettingTblBuilder.addUpdateTime(updateTimeJsonValue.asString());
-            }
-	        responseJsonValue["message"] = "鏌ヨ鎴愬姛锛�";
-	        responseJsonValue["success"] = "true";
-	    	responseJsonValue["data"] = VssLocalSettingTblSqliteDao::instance()->findJsonArray(string("select * from ") + VSSLocalSettingTbl_TABLE_NAME + " where 1 = 1");
-
-        }
-        return responseJsonValue.toStyledString();
-    }
-};
-
-
-
-
-
-
-#endif //VSSLOCALSETTINGTBL_CONTROLLER_H
-
-
-
-
-
+#ifndef VSSLOCALSETTINGTBL_CONTROLLER_H
+#define VSSLOCALSETTINGTBL_CONTROLLER_H
+
+#include <string>
+#include <DataManagerServer/http_configserver.h>
+#include "vss/dao/VssLocalSettingTblDao.h"
+#include "vss/dao/VssLocalSettingTblSqliteDao.h"
+#include "vss/model/VssLocalSettingTblBuilder.h"
+#include "vss/model/VssLocalSettingTbl.h"
+#include "VssBaseController.h"
+#include <mysql++.h>
+
+using namespace std;
+
+/**
+ * 鏈湴鍥芥爣閰嶇疆
+ */
+class VssLocalSettingTblController : public VssBaseController {
+private:
+	/** 鏈湴鍥芥爣閰嶇疆鏋勯�犲嚱鏁� */
+	VssLocalSettingTblController() {}
+public:
+	/** 鏈湴鍥芥爣閰嶇疆鍗曚緥妯″紡 */
+    static VssLocalSettingTblController* instance() {
+        static VssLocalSettingTblController instance;
+        return &instance;
+    }
+public:
+	/** 娉ㄥ唽{label}http鏈嶅姟 */
+    void registerHttpServices(HttpSrvRetRecieve& _HttpSrvRetRecieve) {
+
+	    _HttpSrvRetRecieve.setInfo("^/addVssLocalSettingTbl$", "POST",
+	                               std::bind(&VssLocalSettingTblController::addVssLocalSettingTbl, this,
+	                                         std::placeholders::_1, std::placeholders::_2,
+	                                         std::placeholders::_3, std::placeholders::_4));
+	
+	    _HttpSrvRetRecieve.setInfo("^/delVssLocalSettingTbl$", "POST",
+	                               std::bind(&VssLocalSettingTblController::delVssLocalSettingTbl, this,
+	                                         std::placeholders::_1, std::placeholders::_2,
+	                                         std::placeholders::_3, std::placeholders::_4));
+	
+	    _HttpSrvRetRecieve.setInfo("^/updateVssLocalSettingTbl$", "POST",
+	                               std::bind(&VssLocalSettingTblController::updateVssLocalSettingTbl, this,
+	                                         std::placeholders::_1, std::placeholders::_2,
+	                                         std::placeholders::_3, std::placeholders::_4));
+	
+	    _HttpSrvRetRecieve.setInfo("^/findVssLocalSettingTbl$", "POST",
+	                               std::bind(&VssLocalSettingTblController::findVssLocalSettingTbl, this,
+	                                         std::placeholders::_1, std::placeholders::_2,
+	                                         std::placeholders::_3, std::placeholders::_4));
+	
+	    _HttpSrvRetRecieve.setInfo("^/findVssLocalSettingTblList$", "POST",
+	                               std::bind(&VssLocalSettingTblController::findVssLocalSettingTblList, this,
+	                                         std::placeholders::_1, std::placeholders::_2,
+	                                         std::placeholders::_3, std::placeholders::_4));
+
+    }
+public:
+	/** 娣诲姞鏈湴鍥芥爣閰嶇疆 */
+    std::string addVssLocalSettingTbl(std::string ip, unsigned int port, std::string content, PResponse &response) {
+        Json::Reader requestJsonReader;
+        Json::Value requestJsonValue;
+        Json::Value responseJsonValue;
+        responseJsonValue["message"] = "娣诲姞澶辫触锛�";
+        responseJsonValue["success"] = "false";
+        if (requestJsonReader.parse(content, requestJsonValue)) {
+            VssLocalSettingTblBuilder vssLocalSettingTblBuilder;
+	    
+	    	Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];
+            if (iDJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addID(std::stoi(iDJsonValue.asString()));
+            }
+
+	    	Json::Value serverIpJsonValue = requestJsonValue[VssLocalSettingTbl_ServerIp];
+            if (serverIpJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerIp(serverIpJsonValue.asString());
+            }
+
+	    	Json::Value serverPortJsonValue = requestJsonValue[VssLocalSettingTbl_ServerPort];
+            if (serverPortJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerPort(serverPortJsonValue.asString());
+            }
+
+	    	Json::Value serverIdJsonValue = requestJsonValue[VssLocalSettingTbl_ServerId];
+            if (serverIdJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerId(serverIdJsonValue.asString());
+            }
+
+	    	Json::Value userAuthIdJsonValue = requestJsonValue[VssLocalSettingTbl_UserAuthId];
+            if (userAuthIdJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addUserAuthId(userAuthIdJsonValue.asString());
+            }
+
+	    	Json::Value passwordJsonValue = requestJsonValue[VssLocalSettingTbl_Password];
+            if (passwordJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addPassword(passwordJsonValue.asString());
+            }
+
+	    	Json::Value updateTimeJsonValue = requestJsonValue[VssLocalSettingTbl_UpdateTime];
+            if (updateTimeJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addUpdateTime(updateTimeJsonValue.asString());
+            }
+	    	auto keyValuesToAdd = vssLocalSettingTblBuilder.buildVssLocalSettingTblMap();
+	    	if (keyValuesToAdd.size() > 0) {
+                responseJsonValue = VssLocalSettingTblSqliteDao::instance()->addVssLocalSettingTbl(keyValuesToAdd);
+            }
+        }
+        return responseJsonValue.toStyledString();
+    }
+
+    /** 鍒犻櫎鏈湴鍥芥爣閰嶇疆 */
+    std::string delVssLocalSettingTbl(std::string ip, unsigned int port, std::string content, PResponse &response) {
+        Json::Reader requestJsonReader;
+        Json::Value requestJsonValue;
+        Json::Value responseJsonValue;
+        responseJsonValue["message"] = "鍒犻櫎澶辫触锛�";
+        responseJsonValue["success"] = "false";
+        if (requestJsonReader.parse(content, requestJsonValue)) {
+        	Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];
+        	if (iDJsonValue.type() != Json::ValueType::nullValue) {
+        		string iDValue = iDJsonValue.asString();
+        		responseJsonValue = VssLocalSettingTblSqliteDao::instance()->deleteByColumn("ID", iDValue);
+            }
+
+        }
+        return responseJsonValue.toStyledString();
+    }
+
+    /** 鏇存柊鏈湴鍥芥爣閰嶇疆 */
+    std::string updateVssLocalSettingTbl(std::string ip, unsigned int port, std::string content, PResponse &response) {
+        Json::Reader requestJsonReader;
+        Json::Value requestJsonValue;
+        Json::Value responseJsonValue;
+        responseJsonValue["message"] = "鏇存柊澶辫触锛�";
+        responseJsonValue["success"] = "false";
+        if (requestJsonReader.parse(content, requestJsonValue)) {
+            VssLocalSettingTblBuilder vssLocalSettingTblBuilder;
+
+	    	Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];
+            if (iDJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addID(std::stoi(iDJsonValue.asString()));
+            }
+
+	    	Json::Value serverIpJsonValue = requestJsonValue[VssLocalSettingTbl_ServerIp];
+            if (serverIpJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerIp(serverIpJsonValue.asString());
+            }
+
+	    	Json::Value serverPortJsonValue = requestJsonValue[VssLocalSettingTbl_ServerPort];
+            if (serverPortJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerPort(serverPortJsonValue.asString());
+            }
+
+	    	Json::Value serverIdJsonValue = requestJsonValue[VssLocalSettingTbl_ServerId];
+            if (serverIdJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerId(serverIdJsonValue.asString());
+            }
+
+	    	Json::Value userAuthIdJsonValue = requestJsonValue[VssLocalSettingTbl_UserAuthId];
+            if (userAuthIdJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addUserAuthId(userAuthIdJsonValue.asString());
+            }
+
+	    	Json::Value passwordJsonValue = requestJsonValue[VssLocalSettingTbl_Password];
+            if (passwordJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addPassword(passwordJsonValue.asString());
+            }
+
+	    	Json::Value updateTimeJsonValue = requestJsonValue[VssLocalSettingTbl_UpdateTime];
+            if (updateTimeJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addUpdateTime(updateTimeJsonValue.asString());
+            }
+        	if (iDJsonValue.type() != Json::ValueType::nullValue) {
+        		string iDValue = iDJsonValue.asString();
+                responseJsonValue = VssLocalSettingTblSqliteDao::instance()->updateVssLocalSettingTbl(vssLocalSettingTblBuilder.buildVssLocalSettingTblMap(), "ID", iDValue);
+            }
+        }
+        return responseJsonValue.toStyledString();
+    }
+
+    /** 鏌ユ壘鍗曚釜鏈湴鍥芥爣閰嶇疆 */
+    std::string findVssLocalSettingTbl(std::string ip, unsigned int port, std::string content, PResponse &response) {
+        Json::Reader requestJsonReader;
+        Json::Value requestJsonValue;
+        Json::Value responseJsonValue;
+        responseJsonValue["message"] = "鏌ヨ澶辫触锛�";
+        responseJsonValue["success"] = "false";
+        if (requestJsonReader.parse(content, requestJsonValue)) {
+            VssLocalSettingTblBuilder vssLocalSettingTblBuilder;
+
+	    	Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];
+            if (iDJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addID(std::stoi(iDJsonValue.asString()));
+            }
+
+	    	Json::Value serverIpJsonValue = requestJsonValue[VssLocalSettingTbl_ServerIp];
+            if (serverIpJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerIp(serverIpJsonValue.asString());
+            }
+
+	    	Json::Value serverPortJsonValue = requestJsonValue[VssLocalSettingTbl_ServerPort];
+            if (serverPortJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerPort(serverPortJsonValue.asString());
+            }
+
+	    	Json::Value serverIdJsonValue = requestJsonValue[VssLocalSettingTbl_ServerId];
+            if (serverIdJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerId(serverIdJsonValue.asString());
+            }
+
+	    	Json::Value userAuthIdJsonValue = requestJsonValue[VssLocalSettingTbl_UserAuthId];
+            if (userAuthIdJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addUserAuthId(userAuthIdJsonValue.asString());
+            }
+
+	    	Json::Value passwordJsonValue = requestJsonValue[VssLocalSettingTbl_Password];
+            if (passwordJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addPassword(passwordJsonValue.asString());
+            }
+
+	    	Json::Value updateTimeJsonValue = requestJsonValue[VssLocalSettingTbl_UpdateTime];
+            if (updateTimeJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addUpdateTime(updateTimeJsonValue.asString());
+            }
+	        responseJsonValue["message"] = "鏌ヨ鎴愬姛锛�";
+	        responseJsonValue["success"] = "true";
+            responseJsonValue = VssLocalSettingTblSqliteDao::instance()->findVssLocalSettingTblList(vssLocalSettingTblBuilder.buildVssLocalSettingTblMap());
+        }
+        return responseJsonValue.toStyledString();
+    }
+
+    /** 鏌ユ壘鏈湴鍥芥爣閰嶇疆鍒楄〃 */
+    std::string findVssLocalSettingTblList(std::string ip, unsigned int port, std::string content, PResponse &response) {
+        Json::Reader requestJsonReader;
+        Json::Value requestJsonValue;
+        Json::Value responseJsonValue;
+        responseJsonValue["message"] = "鏌ヨ澶辫触锛�";
+        responseJsonValue["success"] = "false";
+        if (content == "" || requestJsonReader.parse(content, requestJsonValue)) {
+            VssLocalSettingTblBuilder vssLocalSettingTblBuilder;
+
+	    	Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];
+            if (iDJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addID(std::stoi(iDJsonValue.asString()));
+            }
+	    
+	    	Json::Value serverIpJsonValue = requestJsonValue[VssLocalSettingTbl_ServerIp];
+            if (serverIpJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerIp(serverIpJsonValue.asString());
+            }
+	    
+	    	Json::Value serverPortJsonValue = requestJsonValue[VssLocalSettingTbl_ServerPort];
+            if (serverPortJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerPort(serverPortJsonValue.asString());
+            }
+	    
+	    	Json::Value serverIdJsonValue = requestJsonValue[VssLocalSettingTbl_ServerId];
+            if (serverIdJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addServerId(serverIdJsonValue.asString());
+            }
+	    
+	    	Json::Value userAuthIdJsonValue = requestJsonValue[VssLocalSettingTbl_UserAuthId];
+            if (userAuthIdJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addUserAuthId(userAuthIdJsonValue.asString());
+            }
+	    
+	    	Json::Value passwordJsonValue = requestJsonValue[VssLocalSettingTbl_Password];
+            if (passwordJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addPassword(passwordJsonValue.asString());
+            }
+	    
+	    	Json::Value updateTimeJsonValue = requestJsonValue[VssLocalSettingTbl_UpdateTime];
+            if (updateTimeJsonValue.type() != Json::ValueType::nullValue) {
+                vssLocalSettingTblBuilder.addUpdateTime(updateTimeJsonValue.asString());
+            }
+	        responseJsonValue["message"] = "鏌ヨ鎴愬姛锛�";
+	        responseJsonValue["success"] = "true";
+	    	responseJsonValue = VssLocalSettingTblSqliteDao::instance()->findVssLocalSettingTblList(vssLocalSettingTblBuilder.buildVssLocalSettingTblMap());
+
+        }
+        return responseJsonValue.toStyledString();
+    }
+};
+
+
+
+
+
+
+#endif //VSSLOCALSETTINGTBL_CONTROLLER_H
+
+
+
+
+

--
Gitblit v1.8.0