Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0301· OpenAIAi2 WildChat-4.8M (AI2)

改成LinQ的方式 List<MIW000522SpecialDiscount> inserList = new…

  1. 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);
                }
            }
    
  2. 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();

  3. 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);
                }
            }
    
  4. 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); }); }