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