From c4ebb18dbe5440cca49be542982f356d2dfbb044 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期一, 14 十一月 2022 11:33:10 +0800
Subject: [PATCH] 设备保养项，设备保养标准导入接口开发
---
VueWebApi/DLL/DAL/BasicSettingDAL.cs | 63 ++++++++++++++++++++-----------
1 files changed, 40 insertions(+), 23 deletions(-)
diff --git a/VueWebApi/DLL/DAL/BasicSettingDAL.cs b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
index 9031232..ecee0df 100644
--- a/VueWebApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebApi/DLL/DAL/BasicSettingDAL.cs
@@ -1873,7 +1873,7 @@
left join (
select B.usercode from TAnDon_Roul_ConFig A
inner join TAnDon_Roul_ConFigUser B on A.id=B.ando_cogfigid
- where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode and A.enable='Y'
+ where A.wkshp_code=@wkshopcode and A.andotype_code=@calltypecode
) B on A.usercode=B.usercode
where A.userclassid='0'";
dynamicParams.Add("@wkshopcode", wkshopcode);
@@ -1920,30 +1920,19 @@
dynamicParams.Add("@wkshopcode", wkshopcode);
dynamicParams.Add("@calltypecode", calltypecode);
var data = DapperHelper.selectdata(sql, dynamicParams);
- mid = Convert.ToInt32(data.Rows[0]["ID"].ToString());
- if (json == null || json.Rows.Count <= 0)
+ if (data.Rows.Count > 0)
{
- //娓呴櫎瀹夌伅銆佽澶囦换鍔￠厤缃〃鏁版嵁
- sql = @"delete TAnDon_Roul_ConFig where id=@mid";
- list.Add(new { str = sql, parm = new { mid = mid } });
+ mid = Convert.ToInt32(data.Rows[0]["ID"].ToString());
//娓呴櫎瀹夌伅銆佽澶囦换鍔￠厤缃叧鑱斾汉鍛樿〃鏁版嵁
sql = @"delete TAnDon_Roul_ConFigUser where ando_cogfigid=@mid";
list.Add(new { str = sql, parm = new { mid = mid } });
}
- else
+ else
{
- //娓呴櫎瀹夌伅銆佽澶囦换鍔￠厤缃〃鏁版嵁
- sql = @"delete TAnDon_Roul_ConFig where id=@mid";
- list.Add(new { str = sql, parm = new { mid = mid } });
- //娓呴櫎瀹夌伅銆佽澶囦换鍔￠厤缃叧鑱斾汉鍛樿〃鏁版嵁
- sql = @"delete TAnDon_Roul_ConFigUser where ando_cogfigid=@mid";
- list.Add(new { str = sql, parm = new { mid = mid } });
-
-
//鑾峰彇涓昏〃鏈�澶D
- sql = @"select ISNULL(IDENT_CURRENT('TK_Wrk_Record')+1,1) as id";
+ sql = @"select ISNULL(IDENT_CURRENT('TAnDon_Roul_ConFig')+1,1) as id";
var dt = DapperHelper.selecttable(sql);
-
+ mid = Convert.ToInt32(dt.Rows[0]["ID"].ToString());
//鍐欏叆瀹夌伅銆佽澶囦换鍔￠厤缃〃鏁版嵁
sql = @"insert into TAnDon_Roul_ConFig(wkshp_code,andotype_code,lm_user,lm_date,enable) values(@wkshp_code,@andotype_code,@lm_user,@lm_date,@enable)";
list.Add(new
@@ -1958,12 +1947,12 @@
enable = enable
}
});
- //寰幆鍐欏叆瀹夌伅銆佽澶囦换鍔￠厤缃叧鑱斾汉鍛樿〃
- for (int i = 0; i < json.Rows.Count; i++)
- {
- sql = @"insert into TAnDon_Roul_ConFigUser(ando_cogfigid,user_code) values(@usercode,@role_code)";
- list.Add(new { str = sql, parm = new { ando_cogfigid = mid, role_code = json.Rows[i]["CODE"].ToString() } });
- }
+ }
+ //寰幆鍐欏叆瀹夌伅銆佽澶囦换鍔￠厤缃叧鑱斾汉鍛樿〃
+ for (int i = 0; i < json.Rows.Count; i++)
+ {
+ sql = @"insert into TAnDon_Roul_ConFigUser(ando_cogfigid,usercode) values(@ando_cogfigid,@role_code)";
+ list.Add(new { str = sql, parm = new { ando_cogfigid = mid, role_code = json.Rows[i]["CODE"].ToString() } });
}
bool aa = DapperHelper.DoTransaction(list);
if (aa)
@@ -2095,5 +2084,33 @@
return mes;
}
#endregion
+
+
+ #region[閫氳繃杞﹂棿缂栫爜鏌ユ壘璁惧淇℃伅]
+ public static ToMessage WhkspIsEqpSearch(string wkshpcode)
+ {
+ string sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //鑾峰彇璁惧涓嬫媺妗嗘暟鎹�
+ sql = @"select code as eqp_code,name as eqp_name
+ from TEqpInfo where wksp_code=@wkshpcode and enable='Y' ";
+ dynamicParams.Add("@wkshpcode", wkshpcode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ 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
}
}
\ No newline at end of file
--
Gitblit v1.9.3