From a2a845c7ca4ba4aa08fde7f63d5b24975bcd294c Mon Sep 17 00:00:00 2001
From: 小驴在此and <2154553021@qq.com>
Date: 星期四, 07 十一月 2024 15:09:08 +0800
Subject: [PATCH] Merge branch 'master' of ssh://115.28.86.8:29418/~admin/昆仑_1025
---
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