From 2cea3c0d7cb988f28b9c296457cd89a34ea1d0e8 Mon Sep 17 00:00:00 2001 From: zzr99 <1940172413@qq.com> Date: 星期二, 16 八月 2022 16:24:11 +0800 Subject: [PATCH] 设备履历+器具履历 --- WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs | 76 ++++++++++++++++++++++++++++++++++++++ 1 files changed, 76 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs b/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs index ef10199..88da647 100644 --- a/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs +++ b/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs @@ -385,5 +385,81 @@ } } #endregion + + #region[璁惧灞ュ巻(鐐瑰嚮涓昏〃甯﹀嚭浠庤〃)] + [Route("Gy_EquipFileMain/Sb_EquipFileBillResumeDate")] + [HttpGet] + public object Sb_EquipFileBillResumeDate(string HInterID) + { + + DataTable ds,ds1; + long HInterID1 = long.Parse(HInterID); + List<object> list = new List<object>(); + try + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + //鑾峰彇閰嶄欢椤圭洰缂栬緫鏁版嵁 + string sql1 = string.Format($"exec h_p_Gy_EquipRecord {HInterID1}"); + ds = oCN.RunProcReturn(sql1, "h_p_Gy_EquipRecord").Tables[0]; + ds1 = oCN.RunProcReturn(sql1, "h_p_Gy_EquipRecord").Tables[1]; + + list.Add(ds);//鏃ュ父璁板綍 + list.Add(ds1);//缁翠慨璁板綍 + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.list = list; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + } + return objJsonResult; + } + #endregion + + #region[鍣ㄥ叿灞ュ巻(鐐瑰嚮涓昏〃甯﹀嚭浠庤〃)] + [Route("Gy_EquipFileMain/Gy_MouldFileBillResumeDate")] + [HttpGet] + public object Gy_MouldFileBillResumeDate(string HInterID) + { + + DataTable ds,ds1,ds2,ds3; + + long HInterID1 = long.Parse(HInterID); + List<object> list = new List<object>(); + try + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + //鑾峰彇閰嶄欢椤圭洰缂栬緫鏁版嵁 + string sql1 = string.Format($"exec h_p_Gy_MouldRecord {HInterID1}"); + ds = oCN.RunProcReturn(sql1, "h_p_Gy_MouldRecord").Tables[0]; + ds1 = oCN.RunProcReturn(sql1, "h_p_Gy_MouldRecord").Tables[1]; + ds2 = oCN.RunProcReturn(sql1, "h_p_Gy_MouldRecord").Tables[2]; + ds3 = oCN.RunProcReturn(sql1, "h_p_Gy_MouldRecord").Tables[3]; + + list.Add(ds);//鍑哄叆搴撹褰� + list.Add(ds1);//鍣ㄥ叿鑰楃敤璁板綍 + list.Add(ds2);//鏃ュ父璁板綍 + list.Add(ds3);//缁翠慨璁板綍 + + objJsonResult.code = "0"; + objJsonResult.count = 1; + objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�"; + objJsonResult.list = list; + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + e.ToString(); + objJsonResult.data = null; + } + return objJsonResult; + } + #endregion } } -- Gitblit v1.9.1