blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
yusijie
2022-09-21 ed80467e957a5ae62f2e7a4df1e794a24eb36af3 
 WebAPI/Controllers/SCGL/Èռƻ®¹ÜÀí/Sc_WorkBillSortBillController.cs


@@ -11,7 +11,7 @@


{


    public class Sc_WorkBillSortBillController : ApiController


    {


        private json objJsonResult = new json();


        private json objJsonResult = new json();    


        public DataSet ds = new DataSet();


        public WebServer webserver = new WebServer();


        SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();


@@ -35,7 +35,7 @@


                    return objJsonResult;


                }




                ds = oCN.RunProcReturn("select * from  h_v_JIT_Sc_WorkBillSortBillList where 1=1" + sWhere + "order by hmainid desc ", "h_v_JIT_Sc_WorkBillSortBillList");


                ds = oCN.RunProcReturn("select * from  h_v_JIT_Sc_WorkBillSortBillList where 1=1" + sWhere + " order by å•æ®å· desc ", "h_v_JIT_Sc_WorkBillSortBillList");




                objJsonResult.code = "1";


                objJsonResult.count = 1;


@@ -87,12 +87,11 @@


            string msg2 = sArray[0].ToString();


            string msg3 = sArray[1].ToString();




            int hentryid = int.Parse(sArray[2].ToString());//子表的顺序id


            int OperationType = int.Parse(sArray[3].ToString());//数据类型 1添加 3修改


            string user = sArray[4].ToString();


            int OperationType = int.Parse(sArray[2].ToString());//数据类型 1添加 3修改


            string user = sArray[3].ToString();


            try


            {


                if (!DBUtility.ClsPub.Security_Log("JIT_ComplementGoodBill_Edit", 1, false, user))


                if (!DBUtility.ClsPub.Security_Log("Sc_WorkBillSortBill_Edit", 1, false, user)) 


                {


                    objJsonResult.code = "0";


                    objJsonResult.count = 0;


@@ -103,7 +102,11 @@




                omdelMian = Newtonsoft.Json.JsonConvert.DeserializeObject<Sc_WorkBillSortBillMain>(msg2);


                string BillType = "4610";




                ds = ds = oCN.RunProcReturn($"select * from  h_v_JIT_Sc_WorkBillSortBillList where hmainid={omdelMian.HInterID} and  å•æ®å·='{omdelMian.HBillNo}'", "h_v_JIT_Sc_WorkBillSortBillList");


                if (ds.Tables[0].Rows.Count > 0)


                {


                    OperationType = 3;


                }




                if (OperationType == 1)//新增


                {


@@ -137,6 +140,18 @@


                }


                else if (OperationType == 3)


                {




                    ds = oCN.RunProcReturn($"select * from  Sc_WorkBillSortBillMain where HMainSourceInterID={omdelMian.HMainSourceInterID}" +


                      $" and HMainSourceEntryID={omdelMian.HMainSourceEntryID} and HICMOBillNo='{omdelMian.HICMOBillNo}' and HICMOEntrySEQ={omdelMian.HICMOEntrySEQ} and HSourceID={omdelMian.HSourceID}", "Sc_WorkBillSortBillMain");


                    if ((ds.Tables[0].Rows.Count == 1 && ds.Tables[0].Rows[0]["HInterID"].ToString() != omdelMian.HInterID.ToString()))


                    {


                        objJsonResult.code = "0";


                        objJsonResult.count = 0;


                        objJsonResult.Message = "生产资源有重复,请修改!";


                        objJsonResult.data = null;


                        return objJsonResult;


                    }




                    //修改


                    oCN.RunProc($"update Sc_WorkBillSortBillMain set HDate='{omdelMian.HDate}',HUpDater='{omdelMian.HMaker}',HUpDateDate=GETDATE()" +


                                  $", HRemark='{omdelMian.HRemark}', HPrintQty={(omdelMian.HPrintQty == null ? 0 : omdelMian.HPrintQty)}" +


@@ -168,7 +183,7 @@


                                  $", HHangUp='{(omdelMian.HHangUp == true ? 1 : 0)}' where HInterID={omdelMian.HInterID}");


                }


                //保存子表


                objJsonResult = AddBillSub(msg3, hentryid);


                objJsonResult = AddBillSub(msg3);


                if (objJsonResult.code == "0")


                {


                    objJsonResult.code = "0";


@@ -194,24 +209,21 @@


            }


        }




        public json AddBillSub(string msg3, int hentryid)


        public json AddBillSub(string msg3)


        {


            //获取表格数据


            ds = oCN.RunProcReturn($"select * from  h_v_JIT_Sc_WorkBillSortBillList where å•æ®å·='{omdelMian.HBillNo}'", "h_v_JIT_Sc_WorkBillSortBillList");




            //删除子表


            oCN.RunProc("delete from Sc_WorkBillSortBillSub where HInterID='" + omdelMian.HInterID.ToString() + "' and HEntryID='" + hentryid + "'");


            oCN.RunProc("delete from Sc_WorkBillSortBillSub where HInterID='" + omdelMian.HInterID.ToString() + "'");




            omodelsub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Sc_WorkBillSortBillSub>>(msg3);


            int i = 1;


            //插入子表


            foreach (Models.Sc_WorkBillSortBillSub oSub in omodelsub)


            {


                oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HEntryID,HRemark,HMasterDate,HQty" +


                oCN.RunProc("insert into Sc_WorkBillSortBillSub(HInterID,HSEQ,HRemark,HMasterDate,HQty" +


                            ", HRptFinishQty, HTimes, HUseTimes, HBTimes, HETimes" +


                            ", HDateSub, HCloseMan, HEntryCloseDate, HCloseTypeSub, HColumn" +


                            ", HLockedSub, HComplete, HStatusTag, HIsHandModify)" +


                            $"values({omdelMian.HInterID}, {(hentryid == -1 ? i : omodelsub.Count==1? hentryid:i==1? hentryid:(i+ds.Tables[0].Rows.Count-1))}, '{oSub.HRemark}', '{oSub.HMasterDate}', {(oSub.HQty == null ? 0: oSub.HQty)}" +


                            $"values({omdelMian.HInterID}, {i}, '{oSub.HRemark}', '{oSub.HMasterDate}', {(oSub.HQty == null ? 0: oSub.HQty)}" +


                            $", {(oSub.HRptFinishQty == null ? 0: oSub.HRptFinishQty)}, {(oSub.HTimes == null ? 0: oSub.HTimes)}, {(oSub.HUseTimes == null ? 0: oSub.HUseTimes)}, '{oSub.HBTimes}', '{oSub.HETimes}'" +


                            $", '{oSub.HDateSub}', '{oSub.HCloseMan}', '{oSub.HEntryCloseDate}', {(oSub.HCloseTypeSub == true ? 1 : 0)}, '{oSub.HColumn}'" +


                            $", '{(oSub.HLockedSub == true ? 1 : 0)}', '{oSub.HComplete}', '{(oSub.HStatusTag == true ? 1 : 0)}', '{(oSub.HIsHandModify == true ? 1 : 0)}')");