From fecc633f3a7fd0c49fccfb7b6198b402f66574e0 Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 30 八月 2022 13:35:45 +0800
Subject: [PATCH] 日常保养,提交接口
---
VueWebApi/DLL/DAL/AppDeviceManageDAL.cs | 139 +++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 136 insertions(+), 3 deletions(-)
diff --git a/VueWebApi/DLL/DAL/AppDeviceManageDAL.cs b/VueWebApi/DLL/DAL/AppDeviceManageDAL.cs
index e37816c..54f4c58 100644
--- a/VueWebApi/DLL/DAL/AppDeviceManageDAL.cs
+++ b/VueWebApi/DLL/DAL/AppDeviceManageDAL.cs
@@ -67,7 +67,7 @@
try
{
//鑾峰彇瀵瑰簲璁惧鍏宠仈鐨勭偣妫�椤圭洰
- sql = @"select S.seq,S.code,S.name,chkdesc,isscan,cycle
+ sql = @"select S.seq,S.code,S.name,S.chkdesc,S.isscan,S.cycle
from TEqpchk_Eqp A
inner join TEqpchk_Main B on A.eqpchkmain_code=B.code
inner join TEqpchk_Deta S on B.code=S.eqpchk_main_code
@@ -199,10 +199,12 @@
try
{
//鑾峰彇瀵瑰簲璁惧鍙婃墍灞炶溅闂�
- sql = @"select A.code,A.name,T.org_code as wksp_code,T.org_name as wksp_name,E.eqpchkmain_code
+ sql = @"select A.code,A.name,T.org_code as wksp_code,T.org_name as wksp_name,
+ E.eapmai_code,M.name as eapmai_name,M.main_cycle
from TEqpInfo A
left join TOrganization T on A.wksp_code=T.org_code
- left join TEqpchk_Eqp E on A.code=E.eqp_code
+ left join TEqpmai_Eqp E on A.code=E.eqp_code
+ left join TEqpmai_Main M on E.eapmai_code=M.code
where A.code=@eqpcode and A.enable='Y' and T.description='W'";
dynamicParams.Add("@eqpcode", eqpcode);
var data = DapperHelper.selectdata(sql, dynamicParams);
@@ -229,5 +231,136 @@
return mes;
}
#endregion
+
+ #region[鏃ュ父淇濆吇,閫夋嫨鎵爜璁惧鍒楄〃甯﹀嚭淇濆吇椤筣
+ public static ToMessage RepairSelectScanDeviceQrCodeItem(string eqpcode)
+ {
+ string sql = "";
+ var dynamicParams = new DynamicParameters();
+ try
+ {
+ //鑾峰彇瀵瑰簲璁惧鍏宠仈鐨勪繚鍏婚」鐩�
+ sql = @"select S.seq,S.code,S.name,S.chk_desc,S.isscan,B.main_cycle
+ from TEqpmai_Eqp A
+ inner join TEqpmai_Main B on A.eapmai_code=B.code
+ inner join TEqpmai_Deta S on B.code=S.eapmai_code
+ where A.eqp_code=@eqpcode
+ order by S.seq asc";
+ dynamicParams.Add("@eqpcode", eqpcode);
+ var data = DapperHelper.selectdata(sql, dynamicParams);
+ if (data.Rows.Count > 0)
+ {
+ mes.code = "200";
+ mes.Message = "鏌ヨ鎴愬姛!";
+ mes.data = data;
+ }
+ else
+ {
+ mes.code = "300";
+ 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 AppDeviceRepairSave(string username,string maintcyc, AppDevicecCheck json)
+ {
+ var sql = "";
+ string djwo = "";
+ List<object> list = new List<object>();
+ try
+ {
+ list.Clear();
+ mes = SeachEncode.EncodingSeach("1037"); //鐢熸垚鍗曞彿
+ if (mes.code == "300")
+ {
+ return mes;
+ }
+ else
+ {
+ djwo = mes.data.GetType().GetProperty("Encode").GetValue(mes.data, null).ToString(); //鑾峰彇鍗曞彿
+ }
+ if (json == null || json.children.Count <= 0)
+ {
+ mes.code = "300";
+ mes.count = 0;
+ mes.Message = "淇濆吇椤逛俊鎭笉鑳戒负绌�!";
+ mes.data = null;
+ return mes;
+ }
+
+ //鍐欏叆淇濆吇璁板綍涓昏〃
+ sql = @"insert into TEqpmaint_Proc_Main(bywo,eqp_code,eqpmaint_code,maint_cyc,maint_result,maint_user,maint_date)
+ values(@djwo,@eqp_code,@eqpmaint_code,@maintcyc,@maint_result,@lm_user,@lm_date)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ djwo = djwo,
+ eqp_code = json.code,
+ eqpmaint_code = json.standcode,
+ maintcyc= maintcyc,
+ lm_user = username,
+ lm_date = DateTime.Now.ToString(),
+ maint_result = json.result
+ }
+ });
+ //寰幆鍐欏叆淇濆吇璁板綍瀛愯〃
+ for (int i = 0; i < json.children.Count; i++)
+ {
+ sql = @"insert into TEqpmaint_Proc_Deta(seq,bywo,eqpmaideta_code,result,maint_cyc,maint_value)
+ values(@seq,@djwo,@eqpmaideta_code,@maint_cyc,@result,@maint_value)";
+ list.Add(new
+ {
+ str = sql,
+ parm = new
+ {
+ seq = json.children[i].seq,
+ djwo = djwo,
+ eqpmaideta_code = json.children[i].itemcode,
+ maint_cyc = json.children[i].cycle,
+ result = json.children[i].result,
+ maint_value = json.children[i].value
+ }
+ }); ;
+ }
+
+ bool aa = DapperHelper.DoTransaction(list);
+ if (aa)
+ {
+ 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
}
}
\ No newline at end of file
--
Gitblit v1.9.3