1

chenhaozhe

2025-10-27 24e9887e71f02998624c63a9e2afa024a898efd3

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

@@ -33,18 +33,31 @@
                oCN.BeginTran();
                LogService.Write("折扣表 å®¡æ ¸åŒæ­¥: " + sMainSub.ToString());

                // foreach (var oSub in sMainSub["model"]["FENTRY"])
                // {
                //     oSub["hendflag"] = string.Equals(oSub["hendflag"].ToString(), "1");
                //     oSub["hstopflag"] = string.Equals(oSub["hstopflag"].ToString(), "1");
                //     oSub["hisuse"] = string.Equals(oSub["hisuse"].ToString(), "1");
                // }

                sMainSub["model"]["hendflag"] = string.Equals(sMainSub["model"]["hendflag"].ToString(), "1");
                sMainSub["model"]["hstopflag"] = string.Equals(sMainSub["model"]["hstopflag"].ToString(), "1");
                // sMainSub["model"]["hisuse"] = string.Equals(sMainSub["model"]["hisuse"].ToString(), "1");

                var sMain = "[" + sMainSub["model"].ToString() + "]";


                
                List<Model.ClsGy_DiscountList> lsmain = new List<Model.ClsGy_DiscountList>();
                lsmain = oListModels.getObjectByJson_Gy_DiscountList(sMain);
                lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_DiscountList>>(sMain);
                // lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Model.ClsGy_DiscountList>>(sMain);
                var sql = string.Empty;
                foreach (var oMain in lsmain)
                {
                    sql = $@"delete from Gy_DiscountList where HItemID = {oMain.HItemID}";
                    oCN.RunProc(sql);

                    sql = $@"insert into Gy_DiscountList
                    sql = $@"
                        set identity_insert Gy_DiscountList on
                        insert into Gy_DiscountList
                            (HItemID,HNumber,HName,HShortNumber,HParentID,HLevel
                            ,HEndFlag,HStopflag,HRemark,HUseFlag,HCREATEORGID,HUSEORGID
                            ,HMakeEmp,HMakeTime,HCheckEmp,HCheckTime
@@ -61,8 +74,10 @@
                                '{oMain.HPRICETYPE}', '{oMain.HDISCOUNTOBJECT}', '{oMain.HDISCOUNTREASON}',
                                {oMain.HDEFDISCOUNTLISTID}
                        )
                    )

                        set identity_insert Gy_DiscountList off
                    ";
                    LogService.Write(sql);
                    oCN.RunProc(sql);

                }