From cd1171d5897e1803ab8f52920537b5bee34a075d Mon Sep 17 00:00:00 2001
From: zzr99 <1940172413@qq.com>
Date: 星期四, 13 一月 2022 19:15:59 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API

---
 WebAPI/DLL/ClsSb_MouldRepairWorkBill.cs                    |    4 +-
 WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs |   63 +++++++++++++++++++++++++++++++
 2 files changed, 65 insertions(+), 2 deletions(-)

diff --git a/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs b/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs
index f24d16c..b60a652 100644
--- a/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs
+++ b/WebAPI/Controllers/Sc_MouldRepairSendWorkBillController.cs
@@ -20,6 +20,7 @@
         private json objJsonResult = new json();
         SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
         DataSet ds;
+        DLL.ClsSb_MouldRepairWorkBill oBill = new DLL.ClsSb_MouldRepairWorkBill();
 
         #region 鍣ㄥ叿缁翠慨娲惧伐鍗曟煡璇�
         [Route("Sc_MouldRepairSendWorkBill/GetMouldRepairSendWorkBillList")]
@@ -219,5 +220,67 @@
         }
 
         #endregion
+
+        #region 鍣ㄥ叿缁翠慨娲惧伐鍗� 鍒犻櫎  
+        [Route("Sc_MouldRepairSendWorkBill/MouldDeleteBill")]
+        [HttpGet]
+        public object MouldDeleteBill(long HInterID, string User, string ModRightNameDelete)
+        {
+            try
+            {
+                //鍒ゆ柇鏉冮檺
+                //if (!DBUtility.ClsPub.Security_Log(ModRightNameDelete, 1, true, User))
+                //{
+                //    objJsonResult.code = "0";
+                //    objJsonResult.count = 0;
+                //    objJsonResult.Message = "娌℃湁鍒犻櫎鏉冮檺";
+                //    objJsonResult.data = null;
+                //    return objJsonResult;
+                //}
+                oBill.ShowBill(HInterID, ref DBUtility.ClsPub.sExeReturnInfo);
+
+                if (oBill.omodel.HBillStatus > 1)
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 1;
+                    objJsonResult.Message = "鍗曟嵁褰撳墠澶勪簬涓嶈兘鍒犻櫎鐨勭姸鎬�";
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
+                if (oBill.omodel.HChecker != "")
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 1;
+                    objJsonResult.Message = "鍗曟嵁褰撳墠宸插鏍�";
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
+                if (oBill.DeleteBill(oBill.omodel.HInterID, ref DBUtility.ClsPub.sExeReturnInfo))
+                {
+                    objJsonResult.code = "1";
+                    objJsonResult.count = 1;
+                    objJsonResult.Message = "鍒犻櫎鎴愬姛";
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
+                else
+                {
+                    objJsonResult.code = "0";
+                    objJsonResult.count = 1;
+                    objJsonResult.Message = "鍒犻櫎澶辫触";
+                    objJsonResult.data = null;
+                    return objJsonResult;
+                }
+            }
+            catch (Exception e)
+            {
+                objJsonResult.code = "0";
+                objJsonResult.count = 0;
+                objJsonResult.Message = "鏃犳潈闄愬垹闄�";
+                objJsonResult.data = null;
+                return objJsonResult;
+            }
+        }
+        #endregion
     }
 }
\ No newline at end of file
diff --git a/WebAPI/DLL/ClsSb_MouldRepairWorkBill.cs b/WebAPI/DLL/ClsSb_MouldRepairWorkBill.cs
index b26a167..d277ac7 100644
--- a/WebAPI/DLL/ClsSb_MouldRepairWorkBill.cs
+++ b/WebAPI/DLL/ClsSb_MouldRepairWorkBill.cs
@@ -157,7 +157,7 @@
             {
                 //鏌ヨ涓昏〃
                 DataSet Ds ;
-                Ds = oCn.RunProcReturn("Select * from Sc_MouldRepairWorkBillMain Where HInterID=" + lngBillKey.ToString(), "Sc_MouldRepairWorkBillMain");
+                Ds = oCn.RunProcReturn("Select * from Sc_MouldRepairSendWorkBill Where HInterID=" + lngBillKey.ToString(), "Sc_MouldRepairSendWorkBill");
                 if(Ds.Tables[0].Rows.Count==0)
                 {
                     sReturn = "鍗曟嵁鏈壘鍒帮紒";
@@ -213,7 +213,7 @@
                 
                 //寰幆
                 DataSet DsSub ;
-                DsSub = oCn.RunProcReturn("Select * from Sc_MouldRepairWorkBillSub Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ", "Sc_MouldRepairWorkBillSub");
+                DsSub = oCn.RunProcReturn("Select * from Sc_MouldRepairSendWorkBillSub Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ", "Sc_MouldRepairSendWorkBillSub");
                 DetailColl.Clear();//娓呯┖
                 for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
                 {

--
Gitblit v1.9.1