改成LinQ的方式 List<MIW000522SpecialDiscount> inserList = new…
- User
改成LinQ的方式 List<M_IW000522_SpecialDiscount> inserList = new List<M_IW000522_SpecialDiscount>(); List<M_IW000522_SpecialDiscount> updateList = new List<M_IW000522_SpecialDiscount>();
var items = JsonHelper.DeserializeObject<List<M_IW000522_SpecialDiscount>>(itemsJson); var listDiscount = _M_IW000522_SpecialDiscountFacade.GetList(); foreach (var dataItem in items) { //如果数据库中包含导入的MaterialCode,则进行更新 if (listDiscount.Where(x => x.MaterialCode == dataItem.MaterialCode).Count() > 0) { updateList.Add(dataItem); } else { inserList.Add(dataItem); } } - Assistant
var inserList = new List<M_IW000522_SpecialDiscount>(); var updateList = new List<M_IW000522_SpecialDiscount>();
var items = JsonHelper.DeserializeObject<List<M_IW000522_SpecialDiscount>>(itemsJson); var listDiscount = _M_IW000522_SpecialDiscountFacade.GetList(); inserList = items.Where(x => !listDiscount.Any(y => y.MaterialCode == x.MaterialCode)).ToList(); updateList = items.Where(x => listDiscount.Any(y => y.MaterialCode == x.MaterialCode)).ToList();
- User
改成LinQ的方式
//有更新的情况进行更新 if (updateList.Count > 0) { foreach (var dbModel in updateList) { dbModel.CreatedDate = DateTime.Now; dbModel.CreatedBy = WebEngine.CurrentUser.ADAccount; _M_IW000522_SpecialDiscountFacade.Update(dbModel); } } //进行插入数据 if (updateList.Count > 0) { foreach (var dbModel in inserList) { dbModel.CreatedDate = DateTime.Now; dbModel.CreatedBy = WebEngine.CurrentUser.ADAccount; _M_IW000522_SpecialDiscountFacade.Insert(dbModel); } } - Assistant
if (updateList.Any()) { updateList.ForEach(x => { x.CreatedDate = DateTime.Now; x.CreatedBy = WebEngine.CurrentUser.ADAccount; _M_IW000522_SpecialDiscountFacade.Update(x); }); }
if (inserList.Any()) { inserList.ForEach(x => { x.CreatedDate = DateTime.Now; x.CreatedBy = WebEngine.CurrentUser.ADAccount; _M_IW000522_SpecialDiscountFacade.Insert(x); }); }