From 14a48ba934fabee90b5d52471ca47883f6007732 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期三, 20 七月 2022 11:40:39 +0800
Subject: [PATCH] Excel 角色清单导入，工序检验扫码
---
VueWebApi/DLL/DAL/SystemSettingDAL.cs | 16 ++++++++++++++--
1 files changed, 14 insertions(+), 2 deletions(-)
diff --git a/VueWebApi/DLL/DAL/SystemSettingDAL.cs b/VueWebApi/DLL/DAL/SystemSettingDAL.cs
index 2c398be..b9dfafc 100644
--- a/VueWebApi/DLL/DAL/SystemSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/SystemSettingDAL.cs
@@ -45,7 +45,7 @@
var total = 0; //鎬绘潯鏁�
var sql = @"select A.right_code,A.right_name,B.prefix,B.filingdate,B.incbit from TRight A
left join T_CodeRules B on A.right_code=B.rightcode
- where "+search+" and A.Type='PC' and A.parent_id<>'0' order by A.right_code,A.right_seq ";
+ where A.Type='PC' and A.parent_id<>'0' and A.is_delete<>'1' " + search + "";
var data = DapperHelper.GetPageList<object>(sql, dynamicParams, prop, order, startNum, endNum, out total);
mes.code = "200";
mes.Message = "鏌ヨ鎴愬姛!";
@@ -55,7 +55,9 @@
catch (Exception e)
{
mes.code = "300";
+ mes.count = 0;
mes.Message = e.Message;
+ mes.data = null;
}
return mes;
}
@@ -74,7 +76,7 @@
var data = DapperHelper.selectdata(sql, dynamicParams);
if (data.Rows.Count > 0)
{
- sql = @"update T_CodeRules set prefix=@prefix,filingdate=@filingdate,incbit=@incbit,lm_user=@lm_user,lm_date=@CreateDate where right_code=@rightcode";
+ sql = @"update T_CodeRules set prefix=@prefix,filingdate=@filingdate,incbit=@incbit,lm_user=@lm_user,lm_date=@CreateDate where rightcode=@rightcode";
dynamicParams.Add("@prefix", prefix);
dynamicParams.Add("@filingdate", filingdate);
dynamicParams.Add("@incbit", incbit);
@@ -85,12 +87,16 @@
if (cont > 0)
{
mes.code = "200";
+ mes.count = 0;
mes.Message = "鎿嶄綔鎴愬姛!";
+ mes.data = null;
}
else
{
mes.code = "300";
+ mes.count = 0;
mes.Message = "鎿嶄綔澶辫触!";
+ mes.data = null;
}
}
else
@@ -116,19 +122,25 @@
if (cont > 0)
{
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;
}
--
Gitblit v1.9.3