From e2d0f5a72f4a8e72e9c289eadfd6517b9f44f38d Mon Sep 17 00:00:00 2001
From: zhuhang <729713003@qq.com>
Date: 星期六, 09 十一月 2024 15:56:15 +0800
Subject: [PATCH] 总结
---
Client/姜可庚/code/2024kunlun_project_permisson/syncdatatodb.cpp | 52 ++++++++++++++++++++++++++--------------------------
1 files changed, 26 insertions(+), 26 deletions(-)
diff --git "a/Client/\345\247\234\345\217\257\345\272\232/code/2024kunlun_project_permisson/syncdatatodb.cpp" "b/Client/\345\247\234\345\217\257\345\272\232/code/2024kunlun_project_permisson/syncdatatodb.cpp"
index 96ca144..47d836c 100644
--- "a/Client/\345\247\234\345\217\257\345\272\232/code/2024kunlun_project_permisson/syncdatatodb.cpp"
+++ "b/Client/\345\247\234\345\217\257\345\272\232/code/2024kunlun_project_permisson/syncdatatodb.cpp"
@@ -23,17 +23,17 @@
{
string sql = "SELECT * FROM user_info AS u, employee_permisson AS e WHERE u.role_id=e.id";
- if(!param.getUserNo().empty()){
- sql += " and u.user_no='" + param.getUserNo() + "'";
- }
+// if(!param.getUserNo().empty()){
+// sql += " and u.user_no='" + param.getUserNo() + "'";
+// }
- if(!param.getName().empty()){
- sql += " and u.name='" + param.getName()+ "'";
- }
+// if(!param.getName().empty()){
+// sql += " and u.name='" + param.getName()+ "'";
+// }
- if(!param.getPermissonType().empty()){
- sql += " and e.permission_type='" + param.getPermissonType()+ "'";
- }
+// if(!param.getPermissonType().empty()){
+// sql += " and e.permission_type='" + param.getPermissonType()+ "'";
+// }
qDebug() << "sql璇彞" << QString::fromStdString(sql);
@@ -56,16 +56,16 @@
string sql = "update employee_permisson";
// 鍙洿鏀硅亴浣�
- if(!param.getPermissonType().empty()){
- sql.append(" set permission_type='" + param.getPermissonType())+ "'";
- }else{
- sql.append(" set query_history=") + to_string(param.getQueryHistory());
- sql.append(",logger_search=") + to_string(param.getLoggerSearch());
- sql.append(",map_mark=") + to_string(param.getMapMark());
- sql.append(",dev_manage=") + to_string(param.getDevManage());
- sql.append(",product_plan=") + to_string(param.getProductPlan());
- }
- sql.append(" where e.id=" + param.getRoleId());
+// if(!param.getPermissonType().empty()){
+// sql.append(" set permission_type='" + param.getPermissonType())+ "'";
+// }else{
+// sql.append(" set query_history=") + to_string(param.getQueryHistory());
+// sql.append(",logger_search=") + to_string(param.getLoggerSearch());
+// sql.append(",map_mark=") + to_string(param.getMapMark());
+// sql.append(",dev_manage=") + to_string(param.getDevManage());
+// sql.append(",product_plan=") + to_string(param.getProductPlan());
+// }
+ //sql.append(" where e.id=" + param.getRoleId());
mysql_real_query(&mysql, sql.c_str(), sql.size());
mysql_store_result(&mysql);
@@ -76,13 +76,13 @@
void SyncDataToDB::setPmsResult(PmsQueryResult &res, char **row)
{
- res.setName(string(row[1]));
- res.setUserNo(string(row[5]));
- res.setStartDateTime(string(row[2]));
- res.setEndDateTime(string(row[3]));
- res.setRoleId(stoi(string(row[4])));
+// res.setName(string(row[1]));
+// res.setUserNo(string(row[5]));
+// res.setStartDateTime(string(row[2]));
+// res.setEndDateTime(string(row[3]));
+// res.setRoleId(stoi(string(row[4])));
- res.setPermissonType(string(row[8]));
+ // res.setPermissonType(string(row[8]));
res.setQueryHistory(stoi(string(row[9])));
res.setLoggerSearch(stoi(string(row[10])));
res.setMapMark(stoi(string(row[11])));
@@ -90,5 +90,5 @@
res.setProductPlan(stoi(string(row[13])));
- qDebug() << QString::fromStdString(res.getUserNo());
+ //qDebug() << QString::fromStdString(res.getUserNo());
}
--
Gitblit v1.8.0