增加凯贝装箱单

zrg

2025-11-05 4c7cb8434be52f1de8557c069ebf82dfbfd8d6ee

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

@@ -32,28 +32,34 @@
                oCN.BeginTran();
                LogService.Write("业务组 å®¡æ ¸åŒæ­¥: " + sMainSub.ToString());

                var sMain = sMainSub["model"]["FENTRY"].ToString();
                List<Model.ClsGy_OperatorGroup> lsmain = new List<Model.ClsGy_OperatorGroup>();
                lsmain = oListModels.getObjectByJson_Gy_OperatorGroup(sMain);
                var sql = string.Empty;
                foreach(var oMain in lsmain)
                foreach (var oSub in sMainSub["model"]["FENTRY"])
                {
                    sql = $@"delete from Gy_OperatorGroup where HItemID = {oMain.HItemID}";
                    oCN.RunProc(sql);

                    sql = $@"insert into Gy_OperatorGroup(HItemID
                    oSub["hendflag"] = string.Equals(oSub["hendflag"].ToString(), "1");
                    oSub["hstopflag"] = string.Equals(oSub["hstopflag"].ToString(), "1");
                    oSub["hisuse"] = string.Equals(oSub["hisuse"].ToString(), "1");
                }
                var sMain = sMainSub["model"]["FENTRY"].ToString() ;
                List<Model.ClsGy_OperatorGroup> lsmain = new List<Model.ClsGy_OperatorGroup>();
                lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_OperatorGroup>>(sMain);
                var sql = string.Empty;
                sql = $@"delete from Gy_OperatorGroup where HItemID = {lsmain[0].HItemID}";
                oCN.RunProc(sql);
                foreach (var oMain in lsmain)
                {
                    sql = $@"
                    set identity_insert Gy_OperatorGroup on
                    insert into Gy_OperatorGroup(HItemID
                            ,HNumber ,HName,HShortNumber,HParentID,HLevel,HEndFlag
                            ,HStopflag,HRemark,HHelpCode,HUseFlag,HUSEORGID
                            ,HOperatorGroupId,HOperatorGroupType,HIsUse)
                    values({oMain.HItemID}, '{oMain.HNumber}', '{oMain.HName}', '{oMain.HShortNumber}',
                            {oMain.HParentID}, '{oMain.HLevel}', '{oMain.HEndFlag}', '{oMain.HStopflag}'
                            {oMain.HParentID}, '{oMain.HLevel}', '{oMain.HEndFlag}', '{oMain.HStopflag}',
                            '{oMain.HRemark}', '{oMain.HHelpCode}' ,'{oMain.HUseFlag}', '{oMain.HUSEORGID}',
                            '{oMain.HOperatorGroupId}','{oMain.HOperatorGroupType}', '{oMain.HIsUse}'
                    )
                    set identity_insert Gy_OperatorGroup off
                    ";

                    oCN.RunProc(sql);
                    
                }

                oCN.Commit();