智云MES后端API代码
blame | 历史 | 补丁 | 提交 | 提交对比 | ignore whitespace
chenhaozhe
2025-10-20 7cff82da32a694368779bfff7c67e7d7827b957a 
 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";


@@ -502,9 +502,10 @@


                    sql = "set identity_insert Gy_MateNumRelation_Sec off";


                    oCN.RunProc(sql);




                    // æäº¤å½“前事务


                    oCN.Commit();


                }




                // æäº¤å½“前事务


                oCN.Commit();


                objJsonResult.code = "1";


                objJsonResult.count = 1;


                objJsonResult.Message = "新增单据成功！";