From 5b1bbf6117cc6fbd9840013d6096ce60c9b6b3c6 Mon Sep 17 00:00:00 2001
From: jhz <jinghz@oceic.com>
Date: 星期四, 20 十月 2022 12:29:48 +0800
Subject: [PATCH] 增加根据条形码返回设备信息的接口

---
 WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs |   32 ++++++++++++++++++++++++++++++++
 1 files changed, 32 insertions(+), 0 deletions(-)

diff --git a/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs b/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs
index da480d9..fd4b567 100644
--- a/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs
+++ b/WebAPI/Controllers/SBGL/Gy_EquipFileMainController.cs
@@ -464,5 +464,37 @@
             return objJsonResult;
         }
         #endregion
+
+        #region[鏍规嵁鏉$爜杩斿洖璁惧淇℃伅]
+        [Route("Gy_EquipFileMain/Gy_MouldFileBillBarCodeInfo")]
+        [HttpGet]
+        public object Gy_MouldFileBillBarCodeInfo(string HBarCode)
+        { 
+            DataTable ds; 
+            List<object> list = new List<object>();
+            try
+            {
+                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+                //鑾峰彇閰嶄欢椤圭洰缂栬緫鏁版嵁
+                string sql1 = string.Format($"exec h_p_Gy_EquipFileGetInfoByBarCode {HBarCode}");
+                ds = oCN.RunProcReturn(sql1, "h_p_Gy_EquipFileGetInfoByBarCode").Tables[0]; 
+
+                list.Add(ds);//璁惧妗f 
+
+                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