From b4cae676b169c4894cfe30ac6a18462dbd3af13e Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期五, 19 十二月 2025 17:00:27 +0800
Subject: [PATCH] 来料检验单 出厂检验单 生产入库检验单 添加 不良原因保存

---
 WebAPI/Controllers/QC_POStockInCheckBillController.cs |   68 +++++++++++++++++++++++++++++-----
 1 files changed, 58 insertions(+), 10 deletions(-)

diff --git a/WebAPI/Controllers/QC_POStockInCheckBillController.cs b/WebAPI/Controllers/QC_POStockInCheckBillController.cs
index f861f2d..b10e2d8 100644
--- a/WebAPI/Controllers/QC_POStockInCheckBillController.cs
+++ b/WebAPI/Controllers/QC_POStockInCheckBillController.cs
@@ -971,8 +971,12 @@
             string OperationType = sArray[2].ToString().Trim();
             string user = sArray[3].ToString();
             string Value = sArray[4].ToString();
-            string BadReason = sArray[5].ToString();
-            if(String.IsNullOrWhiteSpace(BadReason) == true)
+            string BadReason = null;
+            if (sArray.Length > 4)
+            {
+                BadReason = sArray[5].ToString();
+            }
+            if (String.IsNullOrWhiteSpace(BadReason) == true)
             {
                 BadReason = "[]";
             }
@@ -1122,14 +1126,6 @@
 
                         BillNew.DetailCol1_BadReason.Add(oSub);
                     }
-                    else
-                    {
-                        objJsonResult.code = "0";
-                        objJsonResult.count = 0;
-                        objJsonResult.Message = "鏃犳槑缁嗚淇℃伅!";
-                        objJsonResult.data = null;
-                        return objJsonResult;
-                    }
                 }
 
 
@@ -1192,6 +1188,58 @@
         }
         #endregion
 
+        #region [妫�楠屽崟鑾峰彇 涓嶈壇鍘熷洜]
+        [Route("QC_POStockInCheckBill_BadReason/getBadReasonList")]
+        [HttpGet]
+        public object getBadReasonList(Int64 HInterID, string user)
+        {
+            DataSet ds;
+            try
+            {
+                SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+                List<object> columnNameList = new List<object>();
+
+                ds = oCN.RunProcReturn("select * from QC_POStockInCheckBillSub_BadReason  where  HInterID=" + HInterID, "QC_POStockInCheckBillSub_BadReason");
+
+                //娣诲姞鍒楀悕
+                foreach (DataColumn col in ds.Tables[0].Columns)
+                {
+                    Type dataType = col.DataType;
+                    string ColmString = "{\"ColmCols\":\"" + col.ColumnName + "\",\"ColmType\":\"" + dataType.Name + "\"}";
+                    columnNameList.Add(JsonConvert.DeserializeObject(ColmString));//鑾峰彇鍒癉ataColumn鍒楀璞$殑鍒楀悕
+                }
+
+                if (ds.Tables[0].Rows.Count > 0)
+                {
+                    objJsonResult.code = "1";
+                    objJsonResult.count = 1;
+                    objJsonResult.Message = "Sucess锛�";
+                    objJsonResult.data = ds.Tables[0];
+                    objJsonResult.list = columnNameList;
+                    return objJsonResult;
+                }
+                else
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 0;
+                    objJsonResult.Message = "鏃犱笉鑹師鍥犳暟鎹紒";
+                    objJsonResult.data = ds.Tables[0];
+                    return objJsonResult;
+                }
+
+
+            }
+            catch (Exception e)
+            {
+                objJsonResult.code = "0";
+                objJsonResult.count = 0;
+                objJsonResult.Message = "娌℃湁杩斿洖浠讳綍涓嶈壇鍘熷洜璁板綍锛�" + e.ToString();
+                objJsonResult.data = null;
+                return objJsonResult;
+            }
+        }
+        #endregion
+
         #region [鏉ユ枡鍏ュ簱妫�楠屽崟]
         /// <summary>
         /// 杩斿洖鍒楄〃

--
Gitblit v1.9.1