add models, daos and controllers for tables.

xuxiuxi

2019-03-04 93fcc2eb2db5038ca1944acde9f4c8b751aca930

 QiaoJiaSystem/DataManagerServer/vss/controller/VssLocalSettingTblController.h

@@ -68,34 +68,34 @@
       

          Json::Value iDJsonValue = requestJsonValue[VssLocalSettingTbl_ID];

            if (iDJsonValue.type() != Json::ValueType::nullValue) {

                vssLocalSettingTblBuilder.addID(iDJsonValue.asInt());

                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());

@@ -107,7 +107,7 @@
        }

        return responseJsonValue.toStyledString();

    }

    


    /** 删除本地国标配置 */

    std::string delVssLocalSettingTbl(std::string ip, unsigned int port, std::string content, PResponse &response) {

        Json::Reader requestJsonReader;

@@ -121,11 +121,11 @@
              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;

@@ -135,52 +135,49 @@
        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());

                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();

                if (iDValue.size() > 0 && VssLocalSettingTblSqliteDao::instance()->updateVssLocalSettingTbl(vssLocalSettingTblBuilder.buildVssLocalSettingTblMap(), "ID", iDValue)) {

                 responseJsonValue["success"] = "true";

                 responseJsonValue["message"] = "更新成功！";

               }

                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;

@@ -190,48 +187,48 @@
        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());

                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["data"] = VssLocalSettingTblSqliteDao::instance()->findJsonArray(string("select * from ") + VSSLocalSettingTbl_TABLE_NAME + " where 1 = 1 limit 1");

            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;

@@ -241,10 +238,10 @@
        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());

                vssLocalSettingTblBuilder.addID(std::stoi(iDJsonValue.asString()));

            }

       

          Json::Value serverIpJsonValue = requestJsonValue[VssLocalSettingTbl_ServerIp];

@@ -278,7 +275,7 @@
            }

           responseJsonValue["message"] = "查询成功！";

           responseJsonValue["success"] = "true";

          responseJsonValue["data"] = VssLocalSettingTblSqliteDao::instance()->findJsonArray(string("select * from ") + VSSLocalSettingTbl_TABLE_NAME + " where 1 = 1");

          responseJsonValue = VssLocalSettingTblSqliteDao::instance()->findVssLocalSettingTblList(vssLocalSettingTblBuilder.buildVssLocalSettingTblMap());



        }

        return responseJsonValue.toStyledString();