From b7041949338728f4f8b7cc96f4ed6a92b40fda36 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期五, 05 一月 2024 12:30:56 +0800
Subject: [PATCH] 1.Startup.cs 文件中增加授权.apk文件 2.Excel下载方法中增加.net core直接下载wwwroot下的文件代码(暂时不用，先注释掉)
---
VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs | 668 +++++++++++++++++++++++++++++++++++++-----------------
1 files changed, 454 insertions(+), 214 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs b/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
index ae634a7..8b4db5a 100644
--- a/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
@@ -67,7 +67,7 @@
where A.is_delete<>'1' " + search;
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data.ToList();
}
@@ -75,7 +75,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -97,7 +97,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鎿嶄綔澶辫触,缂栫爜閲嶅!";
+ mes.message = "鎿嶄綔澶辫触,缂栫爜閲嶅!";
mes.data = null;
return mes;
}
@@ -116,14 +116,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.message = "鏂板鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.message = "鏂板鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -143,14 +143,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.message = "淇敼鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -159,7 +159,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -182,7 +182,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "澶栧崗渚涙柟宸插叧鑱斿鍗忓伐搴�,涓嶅厑璁稿垹闄�!";
+ mes.message = "澶栧崗渚涙柟宸插叧鑱斿鍗忓伐搴�,涓嶅厑璁稿垹闄�!";
mes.data = null;
return mes;
}
@@ -194,14 +194,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鍒犻櫎鎴愬姛!";
+ mes.message = "鍒犻櫎鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎澶辫触!";
+ mes.message = "鍒犻櫎澶辫触!";
mes.data = null;
}
}
@@ -209,7 +209,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -247,14 +247,14 @@
where parent.is_delete<>'1' " + search;
var data = DapperHelper.selectdata(sql, dynamicParams);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.data = data;
}
catch (Exception e)
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -273,7 +273,7 @@
where is_delete<>'1' ";
var data = DapperHelper.selecttable(sql);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data;
}
@@ -281,7 +281,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -318,14 +318,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鎿嶄綔鎴愬姛!";
+ mes.message = "鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鎿嶄綔澶辫触!";
+ mes.message = "鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -333,7 +333,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -357,7 +357,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "褰撳墠鍛煎彨绫诲瀷宸插叧鑱斿懠鍙厤缃�,涓嶅厑璁稿垹闄�!";
+ mes.message = "褰撳墠鍛煎彨绫诲瀷宸插叧鑱斿懠鍙厤缃�,涓嶅厑璁稿垹闄�!";
mes.data = null;
}
else
@@ -369,14 +369,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鍒犻櫎鎴愬姛!";
+ mes.message = "鍒犻櫎鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎澶辫触!";
+ mes.message = "鍒犻櫎澶辫触!";
mes.data = null;
}
}
@@ -385,7 +385,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -409,7 +409,7 @@
mes.code = "200";
mes.count = 0;
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.data = data;
}
@@ -417,7 +417,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -446,14 +446,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.data = data;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏆傛棤鍝嶅簲浜哄憳!";
+ mes.message = "鏆傛棤鍝嶅簲浜哄憳!";
mes.data = null;
}
}
@@ -461,7 +461,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -522,14 +522,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鎿嶄綔鎴愬姛!";
+ mes.message = "鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鎿嶄綔澶辫触!";
+ mes.message = "鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -537,7 +537,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -571,14 +571,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鎿嶄綔鎴愬姛!";
+ mes.message = "鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎澶辫触!";
+ mes.message = "鍒犻櫎澶辫触!";
mes.data = null;
}
}
@@ -586,7 +586,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -626,14 +626,14 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鍒犻櫎鎴愬姛!";
+ mes.message = "鍒犻櫎鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎澶辫触!";
+ mes.message = "鍒犻櫎澶辫触!";
mes.data = null;
}
}
@@ -641,7 +641,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -662,14 +662,14 @@
dynamicParams.Add("@wkshpcode", wkshpcode);
var data = DapperHelper.selectdata(sql, dynamicParams);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.data = data;
}
catch (Exception e)
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -680,7 +680,7 @@
#region[缁勭粐鏋舵瀯,鏌ヨ缁勭粐淇℃伅]
- public static ToMessage STorgData(string storg_code, string storg_name, int startNum, int endNum, string prop, string order)
+ public static ToMessage STorgData(string storg_code, string storg_name)
{
var dynamicParams = new DynamicParameters();
string search = "";
@@ -696,24 +696,22 @@
search += "and T.torg_name like '%'+@storg_name+'%' ";
dynamicParams.Add("@storg_name", storg_name);
}
- // --------------鏌ヨ鎸囧畾鏁版嵁--------------
- var total = 0; //鎬绘潯鏁�
var sql = @"select T.id,T.parent_id,T.torg_code,T.torg_name,T.status,T.leve,T.torg_seq,
T.lm_user as usercode,U.username,T.lm_date
from TOrganization T
left join TUser U on T.lm_user=U.usercode
- where 1=1" + search + "";
- var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
+ where 1=1" + search + " order by T.lm_date desc";
+ var data = DapperHelper.selectdata(sql, dynamicParams);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
- mes.count = total;
- mes.data = data.ToList();
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.count = data.Rows.Count;
+ mes.data = data;
}
catch (Exception e)
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -737,7 +735,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触,缂栫爜閲嶅!";
+ mes.message = "鏂板鎿嶄綔澶辫触,缂栫爜閲嶅!";
mes.data = null;
return mes;
}
@@ -767,14 +765,14 @@
LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗙粍缁�:" + OrganCode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.message = "鏂板鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.message = "鏂板鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -791,7 +789,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂伴�夋嫨鐨勬墍灞炵粍缁囧凡浣跨敤涓嶅厑璁镐慨鏀�!";
+ mes.message = "鏂伴�夋嫨鐨勬墍灞炵粍缁囧凡浣跨敤涓嶅厑璁镐慨鏀�!";
mes.data = null;
return mes;
}
@@ -814,7 +812,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "褰撳墠鍘熸湁缁勭粐鎴栧瓙绾ц浣跨敤涓嶅厑璁镐慨鏀�!";
+ mes.message = "褰撳墠鍘熸湁缁勭粐鎴栧瓙绾ц浣跨敤涓嶅厑璁镐慨鏀�!";
mes.data = null;
return mes;
}
@@ -865,14 +863,14 @@
LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗙粍缁�:" + OrganCode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.message = "淇敼鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -881,7 +879,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -902,7 +900,7 @@
if (data0.Rows.Count > 0)
{
mes.code = "300";
- mes.Message = "褰撳墠缁勭粐鏈変笅绾у叧鑱�,璇峰厛鍒犻櫎涓嬬骇缁勭粐!";
+ mes.message = "褰撳墠缁勭粐鏈変笅绾у叧鑱�,璇峰厛鍒犻櫎涓嬬骇缁勭粐!";
return mes;
}
sql = @"select * from TUser where storg_code=@orgcode";
@@ -912,7 +910,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "璇ョ粍缁囦笅鏈夊叧鑱旂殑鐢ㄦ埛,涓嶅厑璁稿垹闄�!";
+ mes.message = "璇ョ粍缁囦笅鏈夊叧鑱旂殑鐢ㄦ埛,涓嶅厑璁稿垹闄�!";
mes.data = null;
return mes;
}
@@ -925,14 +923,14 @@
LogHelper.DbOperateLog(us.usercode, "鏂板", "鍒犻櫎浜嗙粍缁�:" + orgcode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
+ mes.message = "鍒犻櫎鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔澶辫触!";
+ mes.message = "鍒犻櫎鎿嶄綔澶辫触!";
mes.data = null;
}
@@ -941,7 +939,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -975,7 +973,7 @@
where 1=1 " + search + "";
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data.ToList();
}
@@ -983,7 +981,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1007,7 +1005,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触,缂栫爜閲嶅!";
+ mes.message = "鏂板鎿嶄綔澶辫触,缂栫爜閲嶅!";
mes.data = null;
return mes;
}
@@ -1035,14 +1033,14 @@
LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗗矖浣�:" + postcode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.message = "鏂板鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.message = "鏂板鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -1058,7 +1056,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "璇ュ矖浣嶆湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿仠鐢�!";
+ mes.message = "璇ュ矖浣嶆湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿仠鐢�!";
mes.data = null;
return mes;
}
@@ -1086,14 +1084,14 @@
LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗗矖浣�:" + postcode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.message = "淇敼鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -1102,7 +1100,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1124,7 +1122,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "璇ュ矖浣嶆湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿垹闄�!";
+ mes.message = "璇ュ矖浣嶆湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿垹闄�!";
mes.data = null;
return mes;
}
@@ -1137,14 +1135,14 @@
LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗗矖浣�:" + postcode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
+ mes.message = "鍒犻櫎鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔澶辫触!";
+ mes.message = "鍒犻櫎鎿嶄綔澶辫触!";
mes.data = null;
}
@@ -1153,7 +1151,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1213,7 +1211,7 @@
left join TUser S on U.lm_user=S.usercode " + search + "";
var data = DapperHelper.GetPagedDataWith<object>(withsql, sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data.ToList();
}
@@ -1221,7 +1219,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1294,7 +1292,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触,缂栫爜閲嶅!";
+ mes.message = "鏂板鎿嶄綔澶辫触,缂栫爜閲嶅!";
mes.data = null;
return mes;
}
@@ -1328,14 +1326,14 @@
LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗙敤鎴�:" + usercode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.message = "鏂板鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.message = "鏂板鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -1372,14 +1370,14 @@
LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗙敤鎴�:" + usercode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.message = "淇敼鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -1388,7 +1386,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1414,14 +1412,14 @@
LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗙敤鎴�:" + usercode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鍒犻櫎鐢ㄦ埛鎴愬姛!";
+ mes.message = "鍒犻櫎鐢ㄦ埛鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎鐢ㄦ埛澶辫触!";
+ mes.message = "鍒犻櫎鐢ㄦ埛澶辫触!";
mes.data = null;
}
}
@@ -1429,7 +1427,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1463,7 +1461,7 @@
where 1=1 " + search + "";
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data.ToList();
}
@@ -1471,7 +1469,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1495,7 +1493,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触,缂栫爜閲嶅!";
+ mes.message = "鏂板鎿嶄綔澶辫触,缂栫爜閲嶅!";
mes.data = null;
return mes;
}
@@ -1523,14 +1521,14 @@
LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗙彮缁�:" + groupcode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.message = "鏂板鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.message = "鏂板鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -1546,7 +1544,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "璇ョ彮缁勬湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿仠鐢�!";
+ mes.message = "璇ョ彮缁勬湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿仠鐢�!";
mes.data = null;
return mes;
}
@@ -1574,14 +1572,14 @@
LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗙彮缁�:" + groupcode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.message = "淇敼鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -1590,7 +1588,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1612,7 +1610,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "璇ョ彮缁勬湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿垹闄�!";
+ mes.message = "璇ョ彮缁勬湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿垹闄�!";
mes.data = null;
return mes;
}
@@ -1625,14 +1623,14 @@
LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗙彮缁�:" + groupcode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
+ mes.message = "鍒犻櫎鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔澶辫触!";
+ mes.message = "鍒犻櫎鎿嶄綔澶辫触!";
mes.data = null;
}
@@ -1641,7 +1639,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1681,7 +1679,7 @@
where 1=1 " + search + "";
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data.ToList();
}
@@ -1689,7 +1687,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1721,7 +1719,7 @@
if (data.Rows.Count > 0)
{
mes.code = "300";
- mes.Message = "鍚屽悕瑙掕壊宸插瓨鍦�!";
+ mes.message = "鍚屽悕瑙掕壊宸插瓨鍦�!";
mes.data = null;
return mes;
}
@@ -1753,14 +1751,14 @@
LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗚鑹�:" + ((List<string>)mes.data)[0].ToString(), us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鎴愬姛!";
+ mes.message = "鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "澶辫触!";
+ mes.message = "澶辫触!";
mes.data = null;
}
}
@@ -1776,7 +1774,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "璇ヨ鑹叉湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿仠鐢�!";
+ mes.message = "璇ヨ鑹叉湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿仠鐢�!";
mes.data = null;
return mes;
}
@@ -1842,14 +1840,14 @@
LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗚鑹插悕绉�:" + rolecode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鎴愬姛!";
+ mes.message = "鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "澶辫触!";
+ mes.message = "澶辫触!";
mes.data = null;
}
}
@@ -1858,7 +1856,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1882,7 +1880,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "璇ヨ鑹叉湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿垹闄�!";
+ mes.message = "璇ヨ鑹叉湁鍏宠仈鐨勭敤鎴�,涓嶅厑璁稿垹闄�!";
mes.data = null;
return mes;
}
@@ -1899,14 +1897,14 @@
LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗚鑹�:" + rolecode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鎴愬姛!";
+ mes.message = "鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "澶辫触!";
+ mes.message = "澶辫触!";
mes.data = null;
}
}
@@ -1914,7 +1912,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -1997,7 +1995,7 @@
where 1=1 and U.status='Y' and U.role_code<>'' " + search + "";
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data.ToList();
}
@@ -2005,7 +2003,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2047,14 +2045,14 @@
LogHelper.DbOperateLog(us.usercode, "鍙栨秷", "鍙栨秷浜嗚鑹插叧鑱旂殑鐢ㄦ埛:" + string.Join(",", user), us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鎴愬姛!";
+ mes.message = "鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "澶辫触!";
+ mes.message = "澶辫触!";
mes.data = null;
}
@@ -2064,7 +2062,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2102,14 +2100,14 @@
LogHelper.DbOperateLog(us.usercode, "娣诲姞", "娣诲姞浜嗚鑹插叧鑱旂殑鐢ㄦ埛:" + string.Join(",", user), us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鎴愬姛!";
+ mes.message = "鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "澶辫触!";
+ mes.message = "澶辫触!";
mes.data = null;
}
@@ -2119,7 +2117,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2145,14 +2143,14 @@
{
mes.code = "200";
mes.count = list.Count;
- mes.Message = "鏌ヨ瑙掕壊鎴愬姛锛�";
+ mes.message = "鏌ヨ瑙掕壊鎴愬姛锛�";
mes.data = list;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏆傛棤瑙掕壊锛�";
+ mes.message = "鏆傛棤瑙掕壊锛�";
mes.data = null;
}
}
@@ -2160,7 +2158,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2184,7 +2182,7 @@
{
mes.code = "200";
mes.count = 0;
- mes.Message = "鏌ヨ鎴愬姛锛�";
+ mes.message = "鏌ヨ鎴愬姛锛�";
mes.data = data;
return mes;
}
@@ -2192,7 +2190,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏆傛棤鑿滃崟锛�";
+ mes.message = "鏆傛棤鑿滃崟锛�";
mes.data = null;
return mes;
}
@@ -2201,7 +2199,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2222,7 +2220,7 @@
var data = DapperHelper.selectdata(sql, dynamicParams);
mes.code = "200";
mes.count = 0;
- mes.Message = "鏌ヨ鎴愬姛锛�";
+ mes.message = "鏌ヨ鎴愬姛锛�";
mes.data = data;
return mes;
}
@@ -2230,7 +2228,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2259,14 +2257,14 @@
LogHelper.DbOperateLog(us.usercode, "鍒嗛厤", "鍒嗛厤浜嗚鑹叉潈闄�:" + "-->瑙掕壊:" + rolecode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鎴愬姛!";
+ mes.message = "鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "澶辫触!";
+ mes.message = "澶辫触!";
mes.data = null;
}
}
@@ -2274,7 +2272,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2293,14 +2291,14 @@
sql = @"select code,name,idparent,data_sources from TCustomerType ";
var data = DapperHelper.selecttable(sql);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.data = data;
}
catch (Exception e)
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2324,7 +2322,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "寰�鏉ュ崟浣嶅垎绫讳笂绾т笉鑳芥槸宸叉湁寰�鏉ュ崟浣嶇殑鍒嗙被锛岃閲嶆柊杈撳叆锛�";
+ mes.message = "寰�鏉ュ崟浣嶅垎绫讳笂绾т笉鑳芥槸宸叉湁寰�鏉ュ崟浣嶇殑鍒嗙被锛岃閲嶆柊杈撳叆锛�";
mes.data = null;
return mes;
}
@@ -2339,7 +2337,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "寰�鏉ュ崟浣嶅垎绫荤紪鐮佸凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
+ mes.message = "寰�鏉ュ崟浣嶅垎绫荤紪鐮佸凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
@@ -2351,7 +2349,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "寰�鏉ュ崟浣嶅垎绫诲悕绉板凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
+ mes.message = "寰�鏉ュ崟浣嶅垎绫诲悕绉板凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
@@ -2378,14 +2376,14 @@
LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗗線鏉ュ崟浣嶅垎绫�:" + customerclasscode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.message = "鏂板鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.message = "鏂板鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -2400,7 +2398,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "寰�鏉ュ崟浣嶅垎绫诲悕绉板凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
+ mes.message = "寰�鏉ュ崟浣嶅垎绫诲悕绉板凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
@@ -2426,14 +2424,14 @@
LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗗線鏉ュ崟浣嶅垎绫�:" + customerclasscode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.message = "淇敼鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -2442,7 +2440,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2466,7 +2464,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "褰撳墠寰�鏉ュ崟浣嶅垎绫绘垨涓嬬骇琚紩鐢ㄤ笉鍏佽鍒犻櫎锛�";
+ mes.message = "褰撳墠寰�鏉ュ崟浣嶅垎绫绘垨涓嬬骇琚紩鐢ㄤ笉鍏佽鍒犻櫎锛�";
mes.data = null;
return mes;
}
@@ -2487,14 +2485,14 @@
LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗗線鏉ュ崟浣嶅垎绫�:" + string.Join(",", classcode), us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.message = "淇敼鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -2502,7 +2500,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2543,7 +2541,7 @@
var total = 0; //鎬绘潯鏁�
data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data.ToList();
}
@@ -2551,7 +2549,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2576,7 +2574,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "寰�鏉ュ崟浣嶇紪鐮佸凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
+ mes.message = "寰�鏉ュ崟浣嶇紪鐮佸凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
@@ -2588,7 +2586,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "寰�鏉ュ崟浣嶅悕绉板凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
+ mes.message = "寰�鏉ュ崟浣嶅悕绉板凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
@@ -2619,14 +2617,14 @@
LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗗線鏉ュ崟浣�:" + customercode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.message = "鏂板鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.message = "鏂板鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -2641,7 +2639,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "寰�鏉ュ崟浣嶅悕绉板凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
+ mes.message = "寰�鏉ュ崟浣嶅悕绉板凡瀛樺湪,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
@@ -2671,14 +2669,14 @@
LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗗線鏉ュ崟浣�:" + customercode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.message = "淇敼鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -2687,7 +2685,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2722,14 +2720,14 @@
LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗗線鏉ュ崟浣�:" + customercode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
+ mes.message = "鍒犻櫎鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔澶辫触!";
+ mes.message = "鍒犻櫎鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -2738,7 +2736,7 @@
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2782,7 +2780,7 @@
var total = 0; //鎬绘潯鏁�
data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data.ToList();
}
@@ -2790,7 +2788,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2815,7 +2813,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "浠撳簱缂栫爜宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
+ mes.message = "浠撳簱缂栫爜宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
@@ -2827,7 +2825,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "浠撳簱鍚嶇О宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
+ mes.message = "浠撳簱鍚嶇О宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
@@ -2856,14 +2854,14 @@
LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗕粨搴�:" + stckcode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.message = "鏂板鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.message = "鏂板鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -2878,7 +2876,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "浠撳簱鍚嶇О宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
+ mes.message = "浠撳簱鍚嶇О宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
@@ -2921,14 +2919,14 @@
LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗕粨搴�:" + stckcode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.message = "淇敼鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -2937,7 +2935,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -2960,7 +2958,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "浠撳簱宸插惎鐢ㄨ揣浣�,涓嶅厑璁稿垹闄�!";
+ mes.message = "浠撳簱宸插惎鐢ㄨ揣浣�,涓嶅厑璁稿垹闄�!";
mes.data = null;
return mes;
}
@@ -2982,14 +2980,14 @@
LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗕粨搴�:" + stckcode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
+ mes.message = "鍒犻櫎鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔澶辫触!";
+ mes.message = "鍒犻櫎鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -2998,7 +2996,7 @@
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -3013,20 +3011,20 @@
try
{
//鑾峰彇寮�鍚粨浣嶇鎺х殑浠撳簱淇℃伅
- sql = @"select S.code,S.name,'-1' as idparent from TSecStck S where S.ishasPosition='1'
- union all
- select L.code,L.name,case when L.idparent is NULL or L.idparent='' then L.idwarehouse else L.idparent end as idparent
- from TSecLoca L ";
+ sql = @"select code,name,'-1' as idparent,'' as warhouse,'0' as depth from TSecStck where ishasPosition='1'
+ union all
+ select code,name,case when L.idparent is NULL or L.idparent='' then '-1' else L.idparent end as idparent,idwarehouse,depth
+ from TSecLoca L ";
var data = DapperHelper.selecttable(sql);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.data = data;
}
catch (Exception e)
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -3034,44 +3032,59 @@
#endregion
#region[浠撲綅淇℃伅鍒楄〃]
- public static ToMessage TSecLocaData(string stckcode, string locacode, string locaname, int startNum, int endNum, string prop, string order)
+ public static ToMessage TSecLocaData(string flag, string stckcode, string locacode, string locaname, int startNum, int endNum, string prop, string order)
{
var dynamicParams = new DynamicParameters();
string search = "", sql = "";
IEnumerable<object> data;
try
{
- if (stckcode != "" && stckcode != null)
+ if (flag == "-1" && stckcode == null)
{
- string[] classcode = Array.ConvertAll<string, string>(stckcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
- search += "and C.idparent in @classcode ";
- dynamicParams.Add("@classcode", classcode);
+ mes.code = "200";
+ mes.count = 0;
+ mes.message = "鏆傛棤鏁版嵁!";
+ mes.data = null;
+ return mes;
+ }
+ string[] classcode = Array.ConvertAll<string, string>(stckcode.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries), s => s.ToString()); //string鍒嗗壊杞瑂tring[]
+ switch (flag)
+ {
+ case "-1": //鍏ㄩ儴
+ search += " and L.idparent is null or L.idparent='' and L.idwarehouse in @idwarehouse ";
+ dynamicParams.Add("@idwarehouse", classcode);
+ break;
+ case "0": //浠撳簱
+ search += " and L.depth='1' and L.idwarehouse in @idwarehouse ";
+ dynamicParams.Add("@idwarehouse", classcode);
+ break;
+ default: //浠撲綅
+ search += " and L.idparent in @idparent";
+ dynamicParams.Add("@idparent", classcode);
+ break;
}
if (locacode != "" && locacode != null)
{
- search += "and C.code like '%'+@locacode+'%' ";
+ search += "and L.code like '%'+@locacode+'%' ";
dynamicParams.Add("@locacode", locacode);
}
if (locaname != "" && locaname != null)
{
- search += "and C.name like '%'+@locaname+'%' ";
+ search += "and L.name like '%'+@locaname+'%' ";
dynamicParams.Add("@locaname", locaname);
}
- sql = @"select C.code,C.name,C.status,C.description,C.idwarehouse as stckcode,T.name as stckname,C.idparent as parentcode,L.name as parentname,
- C.lm_user as usercode,U.username,C.lm_date,C.data_sources
- from (
- select L.code,L.name,L.idwarehouse,L.status,L.description,L.lm_user,L.lm_date,L.data_sources,case when L.idparent is NULL or L.idparent='' then L.idwarehouse else L.idparent end as idparent
+ sql = @"select L.code,L.name,L.status,L.description,L.idwarehouse as stckcode,T.name as stckname,
+ L.idparent as parentcode,S.name as parentname,L.data_sources,L.lm_user as usercode,U.username,L.lm_date
from TSecLoca L
- ) as C
- left join TSecStck T on C.idwarehouse=T.code
- left join TSecLoca L on C.idparent=L.code
- left join TUser U on C.lm_user=U.usercode
- where 1=1 " + search;
+ left join TSecStck T on L.idwarehouse=T.code
+ left join TSecLoca S on L.idparent=S.code
+ left join TUser U on L.lm_user=U.usercode
+ where 1=1 " + search;
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
- mes.Message = "鏌ヨ鎴愬姛!";
+ mes.message = "鏌ヨ鎴愬姛!";
mes.count = total;
mes.data = data.ToList();
}
@@ -3079,7 +3092,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -3087,7 +3100,7 @@
#endregion
#region[浠撲綅淇℃伅鏂板/缂栬緫淇濆瓨]
- public static ToMessage TSecStckAddUpdate(string data_sources, string locacode, string locaname, string stckcode, string parentlocacode, string status, string description, string OperType, User us)
+ public static ToMessage TSecLocaAddUpdate(string data_sources, string locacode, string locaname, string stckcode, string parentlocacode, string depth, string status, string description, string OperType, User us)
{
string sql = "";
List<object> list = new List<object>();
@@ -3104,7 +3117,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "浠撲綅缂栫爜宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
+ mes.message = "浠撲綅缂栫爜宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
@@ -3116,13 +3129,17 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "浠撲綅宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
+ mes.message = "浠撲綅宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
- //鍐欏叆寰�鏉ュ崟浣�
- sql = @"insert into TSecLoca(code,name,idwarehouse,idparent,status,description,lm_user,lm_date,data_sources)
- values(@code,@name,@idwarehouse,@idparent,@status,@description,@lm_user,@lm_date,@data_sources)";
+ if (depth == "1") //灞傜骇涓�1鏃�,缃┖涓婄骇缂栫爜
+ {
+ parentlocacode = "";
+ }
+ //鍐欏叆浠撲綅
+ sql = @"insert into TSecLoca(code,name,idwarehouse,idparent,status,description,lm_user,lm_date,data_sources,depth)
+ values(@code,@name,@idwarehouse,@idparent,@status,@description,@lm_user,@lm_date,@data_sources,@depth)";
list.Add(new
{
str = sql,
@@ -3136,7 +3153,8 @@
description = description,
lm_user = us.usercode,
lm_date = DateTime.Now.ToString(),
- data_sources = data_sources
+ data_sources = data_sources,
+ depth = depth
}
});
bool aa = DapperHelper.DoTransaction(list);
@@ -3146,19 +3164,28 @@
LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗕粨浣�:" + locacode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.message = "鏂板鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鏂板鎿嶄綔澶辫触!";
+ mes.message = "鏂板鎿嶄綔澶辫触!";
mes.data = null;
}
}
if (OperType == "Update")
{
+ //鍒ゆ柇涓婄骇璐т綅缂栫爜鏄惁绛変簬璐т綅缂栫爜
+ if (locacode == parentlocacode)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = "涓婄骇璐т綅涓嶈兘鏄簱浣嶆湰韬紒";
+ mes.data = null;
+ return mes;
+ }
//鍒ゆ柇寰�鏉ュ崟浣嶅悕绉版槸鍚﹂噸澶�
sql = @"select * from TSecLoca where code<>@code and name=@name";
dynamicParams.Add("@code", locacode);
@@ -3168,12 +3195,16 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "浠撲綅鍚嶇О宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
+ mes.message = "浠撲綅鍚嶇О宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
mes.data = null;
return mes;
}
+ if (depth == "1") //灞傜骇涓�1鏃�,缃┖涓婄骇缂栫爜
+ {
+ parentlocacode = "";
+ }
//鏇存柊瀛樿揣鍒嗙被
- sql = @"update TSecLoca set name=@name,idwarehouse=@idwarehouse,idparent=@idparent,status=@status,description=@description,lm_user=@lm_user,lm_date=@lm_date
+ sql = @"update TSecLoca set name=@name,idwarehouse=@idwarehouse,idparent=@idparent,depth=@depth,status=@status,description=@description,lm_user=@lm_user,lm_date=@lm_date
where code=@code";
list.Add(new
{
@@ -3184,6 +3215,7 @@
name = locaname,
idwarehouse = stckcode,
idparent = parentlocacode,
+ depth = depth,
status = status,
description = description,
lm_user = us.usercode,
@@ -3211,14 +3243,14 @@
LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗕粨浣�:" + locacode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "淇敼鎿嶄綔澶辫触!";
+ mes.message = "淇敼鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -3227,7 +3259,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
@@ -3250,7 +3282,7 @@
{
mes.code = "300";
mes.count = 0;
- mes.Message = "褰撳墠浠撲綅涓嬪瓨鍦ㄥ瓙椤�,涓嶅厑璁稿垹闄�!";
+ mes.message = "褰撳墠浠撲綅涓嬪瓨鍦ㄥ瓙椤�,涓嶅厑璁稿垹闄�!";
mes.data = null;
return mes;
}
@@ -3272,14 +3304,14 @@
LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗕粨浣�:" + locacode, us.usertype);
mes.code = "200";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
+ mes.message = "鍒犻櫎鎿嶄綔鎴愬姛!";
mes.data = null;
}
else
{
mes.code = "300";
mes.count = 0;
- mes.Message = "鍒犻櫎鎿嶄綔澶辫触!";
+ mes.message = "鍒犻櫎鎿嶄綔澶辫触!";
mes.data = null;
}
}
@@ -3288,11 +3320,219 @@
mes.code = "300";
mes.count = 0;
- mes.Message = e.Message;
+ mes.message = e.Message;
mes.data = null;
}
return mes;
}
#endregion
+
+
+ #region[宸ュ簭鏌ヨ]
+ public static ToMessage StepSearch(string stepcode, string stepname, string enable, string steptypecode, int startNum, int endNum, string prop, string order)
+ {
+ var dynamicParams = new DynamicParameters();
+ string search = "";
+ try
+ {
+ if (stepcode != "" && stepcode != null)
+ {
+ search += "and A.stepcode like '%'+@stepcode+'%' ";
+ dynamicParams.Add("@stepcode", stepcode);
+ }
+ if (stepname != "" && stepname != null)
+ {
+ search += "and A.stepname like '%'+@stepname+'%' ";
+ dynamicParams.Add("@stepname", stepname);
+ }
+ if (enable != "" && enable != null)
+ {
+ search += "and A.enable=@enable ";
+ dynamicParams.Add("@enable", enable);
+ }
+ if (steptypecode != "" && steptypecode != null)
+ {
+ search += "and A.flwtype=@steptypecode ";
+ dynamicParams.Add("@steptypecode", steptypecode);
+ }
+ if (search == "")
+ {
+ search = "and 1=1 ";
+ }
+ // --------------鏌ヨ鎸囧畾鏁版嵁--------------
+ var total = 0; //鎬绘潯鏁�
+ var sql = @"select A.id,A.stepcode,A.stepname,A.flwtype,A.enable,A.descr,U.username as lm_user,A.lm_date
+ from TStep A
+ left join TUser U on A.lm_user=U.usercode
+ where A.is_delete<>'1' " + search;
+ var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
+ mes.code = "200";
+ mes.message = "鏌ヨ鎴愬姛!";
+ mes.count = total;
+ mes.data = data.ToList();
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[宸ュ簭鏂板缂栬緫]
+ public static ToMessage AddUpdateStep(string stepid, string stepcode, string stepname, string steptypecode, string enable, string description, User us, string operType)
+ {
+ var dynamicParams = new DynamicParameters();
+ List<object> list = new List<object>();
+ var sql = "";
+ try
+ {
+ if (operType == "Add")
+ {
+ sql = @"select * from TStep where stepcode=@stepcode";
+ dynamicParams.Add("@stepcode", stepcode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = "鎿嶄綔澶辫触,缂栫爜閲嶅!";
+ mes.data = null;
+ return mes;
+ }
+ sql = @"insert into TStep(stepcode,stepname,flwtype,enable,descr,lm_user,lm_date)
+ values(@stepcode,@stepname,@steptypecode,@enable,@description,@username,@CreateDate)";
+ dynamicParams.Add("@stepcode", stepcode);
+ dynamicParams.Add("@stepname", stepname);
+ dynamicParams.Add("@steptypecode", steptypecode);
+ dynamicParams.Add("@enable", enable);
+ dynamicParams.Add("@description", description);
+ dynamicParams.Add("@username", us.usercode);
+ dynamicParams.Add("@CreateDate", DateTime.Now.ToString());
+ int cont = DapperHelper.SQL(sql, dynamicParams);
+ if (cont > 0)
+ {
+ //鍐欏叆鎿嶄綔璁板綍琛�
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗗伐搴�:" + stepcode, us.usertype);
+ mes.code = "200";
+ mes.count = 0;
+ mes.message = "鏂板鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = "鏂板鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ if (operType == "Update")
+ {
+ list.Clear();
+ //濡傛灉褰撳墠宸ュ簭浣跨敤鐘舵�佷綅N(鏈惎鐢�),闇�鍒ゆ柇褰撳墠宸ュ簭鏄惁琚伐鍗曞紩鐢�
+ if (enable == "N")
+ {
+ var sql0 = @"select * from TK_Wrk_Step A where A.step_code=@stepcode";
+ dynamicParams.Add("@stepcode", stepcode);
+ var data = DapperHelper.selectdata(sql0, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = "宸ュ簭鏈夊叧鑱斿伐鍗�,涓嶅厑璁镐慨鏀�!";
+ mes.data = null;
+ return mes;
+ }
+ }
+ sql = @"update TStep set stepname=@stepname,flwtype=@steptypecode,enable=@enable,descr=@description,
+ lm_user=@username,lm_date=@CreateDate where id=@stepid";
+ list.Add(new { str = sql, parm = new { stepid = stepid, stepname = stepname, steptypecode = steptypecode, enable = enable, description = description, username = us.usercode, CreateDate = DateTime.Now.ToString() } });
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ //鍐欏叆鎿嶄綔璁板綍琛�
+ LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗗伐搴�:" + stepcode, us.usertype);
+ mes.code = "200";
+ mes.count = 0;
+ mes.message = "淇敼鎿嶄綔鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = "淇敼鎿嶄綔澶辫触!";
+ mes.data = null;
+ }
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[宸ュ簭鍒犻櫎]
+ public static ToMessage DeleteStep(string stepcode, User us)
+ {
+ var sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ list.Clear();
+ //褰撳墠宸ュ簭鏄惁鍏宠仈宸ュ崟
+ sql = @"select * from TK_Wrk_Step A where A.step_code=@stepcode";
+ dynamicParams.Add("@stepcode", stepcode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = "宸ュ簭鏈夊叧鑱斿伐鍗�,涓嶅厑璁稿垹闄�!";
+ mes.data = null;
+ return mes;
+ }
+ //鍒犻櫎宸ュ簭
+ sql = @"delete TStep where stepcode=@stepcode";
+ list.Add(new { str = sql, parm = new { stepcode = stepcode } });
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ //鍐欏叆鎿嶄綔璁板綍琛�
+ LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗗伐搴�:" + stepcode, us.usertype);
+ mes.code = "200";
+ mes.count = 0;
+ mes.message = "鍒犻櫎鎴愬姛!";
+ mes.data = null;
+ }
+ else
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = "鍒犻櫎澶辫触!";
+ mes.data = null;
+ }
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
}
}
--
Gitblit v1.9.3