多码合一

llj

8 天以前 2bf6de5d4748d28f7f3a098af25503d6a0c619d1

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

@@ -468,14 +468,14 @@
                var model = oMain["model"].ToString();
                LogService.Write("1" + model);
                //反序列化
                model = "[" + model + "]";
                //model = "[" + model + "]";
                List<Gy_MateNumRelation_Sec> lsmain = Newtonsoft.Json.JsonConvert.DeserializeObject<List<Gy_MateNumRelation_Sec>>(model);
                string sql = string.Empty;              
                oCN.BeginTran();
                foreach (var item in lsmain)
                {
                    // ä½¿ç”¨å½“前item的HItemID删除
                    sql = $"delete from  Gy_MateNumRelation_Sec where HItemID = {item.HItemID}";
                    sql = $"delete from  Gy_MateNumRelation_Sec where HItemID = {item.HItemID} and HMaterID={item.HMaterID} ";
                    oCN.RunProc(sql);                  
                    // å¼€å¯identity_insert
                    sql = "set identity_insert Gy_MateNumRelation_Sec on";
@@ -483,28 +483,29 @@

                    LogService.Write("客户物料对应表" + @"Insert Into Gy_MateNumRelation_Sec " +
                          "(HItemID,HCusID,HCusRelationNumber,HCusRelationName,HMaterID" +
                          ",HUsed,HCREATEORGID,HUSEORGID,HRemark,HMakeDate,HMaker" +
                          ",HUsed,HCREATEORGID,HUSEORGID,HRemark,HMakeDate,HMaker,HShopID" +
                          ") " +
                          " values('" + item.HItemID + "','" + item.HCusID + "','" + item.HCusRelationNumber + "','" + item.HCusRelationName + "','" + item.HMaterID + "'," +
                          "'" + item.HUsed + "','" + item.HUSEORGID + "','" + item.HUSEORGID + "','" + item.HRemark + "',getdate(),'" + item.HMaker +
                          "'" + item.HUsed + "','" + item.HUSEORGID + "','" + item.HUSEORGID + "','" + item.HRemark + "',getdate(),'" + item.HMaker + "','" + item.HShopID + 
                          "') ");

                    // æ’入当前item的记录
                    sql = "Insert Into Gy_MateNumRelation_Sec " +
                          "(HItemID,HCusID,HCusRelationNumber,HCusRelationName,HMaterID" +
                          ",HUsed,HCREATEORGID,HUSEORGID,HRemark,HMakeDate,HMaker" +
                          ",HUsed,HCREATEORGID,HUSEORGID,HRemark,HMakeDate,HMaker,HShopID" +
                          ") " +
                          " values('" + item.HItemID + "','" + item.HCusID + "','" + item.HCusRelationNumber + "','" + item.HCusRelationName + "','" + item.HMaterID + "'," +
                          "'" + item.HUsed + "','" + item.HUSEORGID + "','" + item.HUSEORGID + "','" + item.HRemark + "',getdate(),'" + item.HMaker +
                          "'" + item.HUsed + "','" + item.HUSEORGID + "','" + item.HUSEORGID + "','" + item.HRemark + "',getdate(),'" + item.HMaker + "','" + item.HShopID +
                         "') ";
                    oCN.RunProc(sql);                   
                    // å…³é—­identity_insert
                    sql = "set identity_insert Gy_MateNumRelation_Sec off";
                    oCN.RunProc(sql);

                    // æäº¤å½“前事务
                    oCN.Commit();
                }

                // æäº¤å½“前事务
                oCN.Commit();
                objJsonResult.code = "1";
                objJsonResult.count = 1;
                objJsonResult.Message = "新增单据成功！";