加日志

yangle

2025-04-09 5898d7f62ec4b29f313a018c7526ce100e9d30a6

 WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/Sc_WorkBillSortBillController.cs

@@ -18,6 +18,7 @@
        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
        Sc_WorkBillSortBillMain omdelMian = new Sc_WorkBillSortBillMain();
        List<Sc_WorkBillSortBillSub> omodelsub = new List<Sc_WorkBillSortBillSub>();
        Pub_Class.ClsXt_SystemParameter oSystemParameter = new Pub_Class.ClsXt_SystemParameter();

        #region æ—¥è®¡åˆ’工单 åˆ—表
        [Route("Sc_WorkBillSortBill/Sc_WorkBillSortBillList")]
@@ -309,21 +310,14 @@
                {
                    var NumData = HInterID.Split(',');

                    //获取系统参数
                    string sReturn = "";
                    oSystemParameter.ShowBill(ref sReturn);                   

                    for (int i = 0; i < NumData.Length; i++)
                    {
                        ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1 and hmainid=" + NumData[i], "h_v_JIT_Sc_WorkBillSortBillList");

                        if (ds.Tables[0].Rows.Count > 0)
                        if (oSystemParameter.omodel.WMS_CampanyName == "添康科技")
                        {
                            if (ds.Tables[0].Rows[0]["单据状态"].ToString() != "1")
                            {
                                objJsonResult.code = "0";
                                objJsonResult.count = 0;
                                objJsonResult.Message = "当前单据不能删除！";
                                objJsonResult.data = null;
                                return objJsonResult;
                            }

                            oCN.BeginTran();//开启事务

                            oCN.RunProc($"delete from Sc_WorkBillSortBillSub where HInterID={ NumData[i]}");
@@ -331,6 +325,29 @@

                            oCN.Commit();//结束事务
                        }
                        else
                        {
                            ds = oCN.RunProcReturn("select * from h_v_JIT_Sc_WorkBillSortBillList where 1=1 and hmainid=" + NumData[i], "h_v_JIT_Sc_WorkBillSortBillList");

                            if (ds.Tables[0].Rows.Count > 0)
                            {
                                if (ds.Tables[0].Rows[0]["单据状态"].ToString() != "1")
                                {
                                    objJsonResult.code = "0";
                                    objJsonResult.count = 0;
                                    objJsonResult.Message = "当前单据不能删除！";
                                    objJsonResult.data = null;
                                    return objJsonResult;
                                }

                                oCN.BeginTran();//开启事务

                                oCN.RunProc($"delete from Sc_WorkBillSortBillSub where HInterID={ NumData[i]}");
                                oCN.RunProc($"delete from Sc_WorkBillSortBillMain where HInterID={ NumData[i]}");

                                oCN.Commit();//结束事务
                            }
                        }                        
                    }
                    objJsonResult.code = "1";
                    objJsonResult.count = 1;