From 3ab8acb38e1e853d7002836f681a8b7a3ee96b5a Mon Sep 17 00:00:00 2001
From: wyb <1qaz@123>
Date: 星期二, 25 五月 2021 17:43:58 +0800
Subject: [PATCH] 不良原因设置增删改

---
 WebAPI/Service/LuBaoSevice.cs |   21 +++++++++++++++++++++
 1 files changed, 21 insertions(+), 0 deletions(-)

diff --git a/WebAPI/Service/LuBaoSevice.cs b/WebAPI/Service/LuBaoSevice.cs
index 2be8d64..57fc797 100644
--- a/WebAPI/Service/LuBaoSevice.cs
+++ b/WebAPI/Service/LuBaoSevice.cs
@@ -175,5 +175,26 @@
             return dataSet;
         }
 
+
+        /// <summary>
+        /// 涓嶈壇鍘熷洜鏍规嵁id鑾峰彇淇℃伅
+        /// </summary>
+        public static ApiResult<DataSet> GetGy_BadReasonBillDetail(string HID)
+        {
+            if (string.IsNullOrEmpty(HID))
+                return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" };
+            var dataSet = GetGy_BadReasonDb(HID);
+            if (dataSet == null || dataSet.Tables[0].Rows.Count == 0)
+                return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄤ笉鑹師鍥犳暟鎹�" };
+            return new ApiResult<DataSet> { code = 1, msg = "鏌ヨ鎴愬姛", data = dataSet };
+        }
+
+        public static DataSet GetGy_BadReasonDb(string HID)
+        {
+            SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+            var dataSet = oCN.RunProcReturn("select top 1 * from h_v_IF_Edit_BadReasonList  where HItemID= " + HID + " ", "h_v_IF_Edit_BadReasonList");
+            return dataSet;
+        }
+
     }
 }
\ No newline at end of file

--
Gitblit v1.9.1