From d91966256d4b507b3f49d9f1b231b258e52a019b Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期四, 07 九月 2023 18:03:22 +0800
Subject: [PATCH] 1.仓库、仓位功能 1.设备类型、设备功能
---
VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs | 367 ++++++++++++++++++++++++++++++++++++++++++++++++----
1 files changed, 336 insertions(+), 31 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs b/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
index 5f3f5aa..ae634a7 100644
--- a/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
@@ -764,7 +764,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗙粍缁�:"+ OrganCode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗙粍缁�:" + OrganCode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鏂板鎿嶄綔鎴愬姛!";
@@ -862,7 +862,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗙粍缁�:"+ OrganCode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗙粍缁�:" + OrganCode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "淇敼鎿嶄綔鎴愬姛!";
@@ -922,7 +922,7 @@
if (cont > 0)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鏂板", "鍒犻櫎浜嗙粍缁�:"+orgcode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鍒犻櫎浜嗙粍缁�:" + orgcode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
@@ -1032,7 +1032,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗗矖浣�:"+ postcode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗗矖浣�:" + postcode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鏂板鎿嶄綔鎴愬姛!";
@@ -1083,7 +1083,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗗矖浣�:"+ postcode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗗矖浣�:" + postcode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "淇敼鎿嶄綔鎴愬姛!";
@@ -1134,7 +1134,7 @@
if (cont > 0)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗗矖浣�:"+ postcode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗗矖浣�:" + postcode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
@@ -1325,7 +1325,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗙敤鎴�:"+ usercode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗙敤鎴�:" + usercode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鏂板鎿嶄綔鎴愬姛!";
@@ -1369,7 +1369,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗙敤鎴�:"+usercode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗙敤鎴�:" + usercode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "淇敼鎿嶄綔鎴愬姛!";
@@ -1411,7 +1411,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗙敤鎴�:"+ usercode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗙敤鎴�:" + usercode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鍒犻櫎鐢ㄦ埛鎴愬姛!";
@@ -1520,7 +1520,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗙彮缁�:"+ groupcode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗙彮缁�:" + groupcode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鏂板鎿嶄綔鎴愬姛!";
@@ -1571,7 +1571,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗙彮缁�:"+ groupcode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗙彮缁�:" + groupcode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "淇敼鎿嶄綔鎴愬姛!";
@@ -1622,7 +1622,7 @@
if (cont > 0)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗙彮缁�:"+ groupcode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗙彮缁�:" + groupcode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
@@ -1750,7 +1750,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗚鑹�:"+ ((List<string>)mes.data)[0].ToString(), us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗚鑹�:" + ((List<string>)mes.data)[0].ToString(), us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鎴愬姛!";
@@ -1839,7 +1839,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗚鑹插悕绉�:"+ rolecode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗚鑹插悕绉�:" + rolecode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鎴愬姛!";
@@ -1896,7 +1896,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗚鑹�:"+ rolecode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗚鑹�:" + rolecode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鎴愬姛!";
@@ -2044,7 +2044,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鍙栨秷", "鍙栨秷浜嗚鑹插叧鑱旂殑鐢ㄦ埛:"+ string.Join(",", user), us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鍙栨秷", "鍙栨秷浜嗚鑹插叧鑱旂殑鐢ㄦ埛:" + string.Join(",", user), us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鎴愬姛!";
@@ -2177,7 +2177,7 @@
//鏌ヨ鎵�鏈夐粯璁よ彍鍗曞強鎸夐挳銆佹暟鎹�
sql = @"select menucode,menuname,parent_id,buttoncodelist
from TMenu
- where Type=@type";
+ where is_show='Y' and Type=@type ";
dynamicParams.Add("@type", type);
var data = DapperHelper.selectdata(sql, dynamicParams);
if (data.Rows.Count > 0)
@@ -2256,7 +2256,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鍒嗛厤", "鍒嗛厤浜嗚鑹叉潈闄�:"+"-->瑙掕壊:"+rolecode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鍒嗛厤", "鍒嗛厤浜嗚鑹叉潈闄�:" + "-->瑙掕壊:" + rolecode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鎴愬姛!";
@@ -2375,7 +2375,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗗線鏉ュ崟浣嶅垎绫�:"+ customerclasscode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗗線鏉ュ崟浣嶅垎绫�:" + customerclasscode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鏂板鎿嶄綔鎴愬姛!";
@@ -2423,7 +2423,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗗線鏉ュ崟浣嶅垎绫�:"+ customerclasscode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗗線鏉ュ崟浣嶅垎绫�:" + customerclasscode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "淇敼鎿嶄綔鎴愬姛!";
@@ -2484,7 +2484,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗗線鏉ュ崟浣嶅垎绫�:"+ string.Join(",", classcode), us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗗線鏉ュ崟浣嶅垎绫�:" + string.Join(",", classcode), us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "淇敼鎿嶄綔鎴愬姛!";
@@ -2616,7 +2616,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗗線鏉ュ崟浣�:"+ customercode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗗線鏉ュ崟浣�:" + customercode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鏂板鎿嶄綔鎴愬姛!";
@@ -2668,7 +2668,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗗線鏉ュ崟浣�:"+ customercode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗗線鏉ュ崟浣�:" + customercode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "淇敼鎿嶄綔鎴愬姛!";
@@ -2719,7 +2719,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗗線鏉ュ崟浣�:"+ customercode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗗線鏉ュ崟浣�:" + customercode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
@@ -2735,7 +2735,7 @@
}
catch (Exception e)
{
-
+
mes.code = "300";
mes.count = 0;
mes.Message = e.Message;
@@ -2774,9 +2774,9 @@
search += "and S.ishasPosition=@ishasPosition ";
dynamicParams.Add("@ishasPosition", ishasPosition);
}
- sql = @"select S.code,S.name,S.status,S.ishasPosition,S.description,S.lm_user as usercode,U.username,S.data_sources
+ sql = @"select S.code,S.name,S.status,S.ishasPosition,S.description,S.lm_user as usercode,U.username,S.lm_date,S.data_sources
from TSecStck S
- left join TUser U on C.lm_user=U.usercode
+ left join TUser U on S.lm_user=U.usercode
where 1=1 " + search;
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
@@ -2853,7 +2853,7 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗕粨搴�:"+ stckcode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗕粨搴�:" + stckcode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鏂板鎿嶄綔鎴愬姛!";
@@ -2883,7 +2883,7 @@
return mes;
}
//鏇存柊浠撳簱
- sql = @"update TCustomer set name=@name,status=@status,ishasPosition=@ishasPosition,description=@description,lm_user=@lm_user,lm_date=@lm_date
+ sql = @"update TSecStck set name=@name,status=@status,ishasPosition=@ishasPosition,description=@description,lm_user=@lm_user,lm_date=@lm_date
where code=@code";
list.Add(new
{
@@ -2899,11 +2899,26 @@
lm_date = DateTime.Now.ToString()
}
});
+ if (status == "1") //浠撳簱鍋滅敤鏃�,涓嬮潰鎵�鏈夌殑浠撲綅鍋滅敤
+ {
+ //鏇存柊搴撲綅鐘舵�佷负绂佺敤
+ sql = @"update TSecLoca set status=@status where idwarehouse=@code";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ status = status,
+ code = stckcode
+ }
+ });
+ }
+
bool aa = DapperHelper.DoTransaction(list);
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗕粨搴�:"+ stckcode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗕粨搴�:" + stckcode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "淇敼鎿嶄綔鎴愬姛!";
@@ -2964,7 +2979,297 @@
if (aa)
{
//鍐欏叆鎿嶄綔璁板綍琛�
- LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗕粨搴�:"+ stckcode, us.usertype);
+ LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗕粨搴�:" + stckcode, 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 TSecLocaTree()
+ {
+ string sql = "";
+ 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 ";
+ var data = DapperHelper.selecttable(sql);
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ catch (Exception e)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = e.Message;
+ mes.data = null;
+ }
+ return mes;
+ }
+ #endregion
+
+ #region[浠撲綅淇℃伅鍒楄〃]
+ public static ToMessage TSecLocaData(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)
+ {
+ 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);
+ }
+ if (locacode != "" && locacode != null)
+ {
+ search += "and C.code like '%'+@locacode+'%' ";
+ dynamicParams.Add("@locacode", locacode);
+ }
+ if (locaname != "" && locaname != null)
+ {
+ search += "and C.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
+ 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;
+ // --------------鏌ヨ鎸囧畾鏁版嵁--------------
+ var total = 0; //鎬绘潯鏁�
+ 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 TSecStckAddUpdate(string data_sources, string locacode, string locaname, string stckcode, string parentlocacode, string status, string description, string OperType, User us)
+ {
+ string sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ if (OperType == "Add")
+ {
+ //鍒ゆ柇浠撲綅缂栫爜鏄惁閲嶅
+ sql = @"select * from TSecLoca where code=@locacode";
+ dynamicParams.Add("@locacode", locacode);
+ 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 = @"select * from TSecLoca where name=@locaname";
+ dynamicParams.Add("@locaname", locaname);
+ var data1 = DapperHelper.selectdata(sql, dynamicParams);
+ if (data1.Rows.Count > 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ 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)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = locacode,
+ name = locaname,
+ idwarehouse = stckcode,
+ idparent = parentlocacode,
+ status = status,
+ description = description,
+ lm_user = us.usercode,
+ lm_date = DateTime.Now.ToString(),
+ data_sources = data_sources
+ }
+ });
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ //鍐欏叆鎿嶄綔璁板綍琛�
+ LogHelper.DbOperateLog(us.usercode, "鏂板", "鏂板浜嗕粨浣�:" + locacode, 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")
+ {
+ //鍒ゆ柇寰�鏉ュ崟浣嶅悕绉版槸鍚﹂噸澶�
+ sql = @"select * from TSecLoca where code<>@code and name=@name";
+ dynamicParams.Add("@code", locacode);
+ dynamicParams.Add("@name", locaname);
+ var data1 = DapperHelper.selectdata(sql, dynamicParams);
+ if (data1.Rows.Count > 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "浠撲綅鍚嶇О宸插瓨鍦�,璇烽噸鏂拌緭鍏�!";
+ mes.data = null;
+ return mes;
+ }
+ //鏇存柊瀛樿揣鍒嗙被
+ sql = @"update TSecLoca set name=@name,idwarehouse=@idwarehouse,idparent=@idparent,status=@status,description=@description,lm_user=@lm_user,lm_date=@lm_date
+ where code=@code";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = locacode,
+ name = locaname,
+ idwarehouse = stckcode,
+ idparent = parentlocacode,
+ status = status,
+ description = description,
+ lm_user = us.usercode,
+ lm_date = DateTime.Now.ToString()
+ }
+ });
+ if (status == "1") //浠撲綅鍋滅敤鏃�,涓嬮潰鎵�鏈夌殑浠撲綅鍋滅敤
+ {
+ //鏇存柊搴撲綅鐘舵�佷负绂佺敤
+ sql = @"update TSecLoca set status=@status where idparent=@code";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ status = status,
+ code = locacode
+ }
+ });
+ }
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ //鍐欏叆鎿嶄綔璁板綍琛�
+ LogHelper.DbOperateLog(us.usercode, "淇敼", "淇敼浜嗕粨浣�:" + locacode, 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 TSecLocaDelete(string data_sources, string locacode, User us)
+ {
+ string sql = "";
+ List<object> list = new List<object>();
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //鍒ゆ柇褰撳墠浠撲綅涓嬫槸鍚︽湁瀛愰」
+ sql = @"select * from TSecLoca where idparent=@locacode";
+ dynamicParams.Add("@locacode", locacode);
+ 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 TSecLoca where code=@code and data_sources=@data_sources";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ code = locacode,
+ data_sources = data_sources
+ }
+ });
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ //鍐欏叆鎿嶄綔璁板綍琛�
+ LogHelper.DbOperateLog(us.usercode, "鍒犻櫎", "鍒犻櫎浜嗕粨浣�:" + locacode, us.usertype);
mes.code = "200";
mes.count = 0;
mes.Message = "鍒犻櫎鎿嶄綔鎴愬姛!";
--
Gitblit v1.9.3