1

wtt

2025-11-03 6a2a02e183b0c0a8b01bebd0452bd0ac0bbed445

 WebAPI/Controllers/»ù´¡×ÊÁÏ/»ù´¡×ÊÁÏ/Gy_AssistantDataEntryController.cs

@@ -30,39 +30,42 @@
            {
                oCN.BeginTran();
                LogService.Write("销售退货原因/退货类型 å®¡æ ¸åŒæ­¥: " + sMainSub.ToString());

                var sMain = "[" + sMainSub["model"].ToString() + "]";
                foreach (var oSub in sMainSub["model"]["FENTRY"])
                {
                    oSub["hstopflag"] = string.Equals(oSub["hstopflag"].ToString(), "1");
                }
                var sMain = sMainSub["model"].ToString();
                var sSub = sMainSub["model"]["FENTRY"].ToString();

                List<Model.ClsGy_AssistantData> lsmain = new List<Model.ClsGy_AssistantData>();
                List<Model.ClsGy_AssistantDataEntry> lssub = new List<Model.ClsGy_AssistantDataEntry>();
                lsmain = oListModels.getObjectByJson_Gy_AssistantData(sMain);
                lssub = oListModels.getObjectByJson_Gy_AssistantDataEntry(sSub);
                lssub = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_AssistantDataEntry>>(sSub);
                var sql = string.Empty;
                foreach (var oMain in lsmain)
                {
                    // åˆ é™¤ä¸»è¡¨æ•°æ®
                    sql = $@"delete from Gy_AssistantData where HID = {oMain.HID}";
                    sql = $@"delete from Gy_AssistantData where HID = '{oMain.HID}'";
                    oCN.RunProc(sql);
                    // åˆ é™¤å­è¡¨æ•°æ®
                    sql = $@"delete from Gy_AssistantDataEntry where HID = {oMain.HID}";
                    sql = $@"delete from Gy_AssistantDataEntry where HID = '{oMain.HID}'";
                    oCN.RunProc(sql);

                    sql = $@"insert into Gy_AssistantData
                        (HID,HNumber,HName,HRemark,HLOCALEID)
                        values({oMain.HID}, '{oMain.HNumber}', '{oMain.HName}', '{oMain.HRemark}',
                                {oMain.HLOCALEID}
                        values('{oMain.HID}', '{oMain.HNumber}', '{oMain.HName}', '{oMain.HRemark}',
                                '{oMain.HLOCALEID}'
                        )
                    )
                    ";
                    oCN.RunProc(sql);

                    foreach(var oSub in lssub)
                    foreach (var oSub in lssub)
                    {
                        sql = $@"insert into Gy_AssistantDataEntry
                        (HID,HEntryID,HNumber,HName,HStopflag,HRemark
                        ,HMakeTime,HMakeEmp,HCheckTime,HCheckEmp,HModifyTime,HModifyEmp
                        ,HLOCALEID,HUSEORGID,HCREATEORGID)
                        values({oSub.HID}, '{oSub.HEntryID}', '{oSub.HNumber}', '{oSub.HName}',
                        values('{oSub.HID}', '{oSub.HEntryID}', '{oSub.HNumber}', '{oSub.HName}',
                                '{oSub.HStopflag}',  '{oSub.HRemark}', '{oSub.HMakeTime}',
                                '{oSub.HMakeEmp}', '{oSub.HCheckTime}',  '{oSub.HCheckEmp}', 
                                '{oSub.HModifyTime}',  '{oSub.HModifyEmp}','{oSub.HLOCALEID}',