循环继续选择相同的记录 [英] Loop keep picking the same records

问题描述

我通过传递3个参数在数据库中保存记录，传递number参数以从一个表到另一个表中选择记录数。然而，在从贴纸分发表插入之前，循环继续插入相同数量的记录，而不是在另一个IntermediaryAssignment表中检查现有的stickercode。foreach语句似乎不能很好地工作，特别是

隐藏复制代码

I'm saving a record in my database by passing 3 parameters, the number parameter is passed to pick the number of records from one table to another table. However the loop keep inserting the same number of records instead of checking for existing stickercodes in another IntermediaryAssignment table before inserting from sticker distribution table.the foreach statement seems not to be working well expecially
Hide Copy Code

if (dbSet.Any(s => s.StickerCode != sticker.StickerCode))

请帮助。也不会更新IntermediaryDispatched



我尝试过的方法：

Kindly help.Also it doesn't update the IntermediaryDispatched as well

What I have tried:

public async Task<bool> Save(string company, int number,string
registrationNumber)
  {

      using (var trans = _dbContext.Database.BeginTransaction())
      {
          var db = new DatabaseContext();
         var dbSet = _dbContext.Set<IntermediaryAssignment>();

          // set the database
          var check =await  (from s in db.StickerDistributions
                       join i in db.IntermediaryAssignment
                       on s.CompanyCode equals i.CompanyCode
                       where s.Dispatched == false && s.CompanyCode == company
                        && s.StickerCode != i.StickerCode
                       select s).ToListAsync();

          var datas = await (from s in db.StickerDistributions
                            where s.Dispatched == false && s.CompanyCode ==
                            company && s.IntermediaryDispatched == false
                             select s).ToListAsync();

          var data = await (from s in db.StickerDistributions
                            where s.Dispatched == false && s.CompanyCode ==
                            company &&
                            s.IntermediaryDispatched == false
                            select s).Take(number).ToListAsync();

              var intermediary = (await _repo.FindBy(s => s.RegistrationNumber
             == registrationNumber && s.Status ==
              EntityStatus.Active)).FirstOrDefault();
       foreach (var sticker in data)
          {
              if (dbSet.Any(s => s.StickerCode != sticker.StickerCode))
              {
                  var entity = new IntermediaryAssignment();

                  entity.CompanyCode = sticker.CompanyCode;
                  entity.StickerCode = sticker.StickerCode;
                  entity.RegistrationNumber = intermediary.RegistrationNumber;
                  entity.Status = EntityStatus.Active;
                  entity.CreatedDate = DateTime.Now;
                  entity.Dispatched = false;
                  entity.IntermediaryType = intermediary.IntermediaryType;
                  // entity.Sticker.Id = sticker.Sticker.Id;
                  sticker.IntermediaryDispatched = true;
                  dbSet.Add(entity);
              }

          }
          Task results =  _dbContext.SaveChangesAsync() ;
           trans.Commit();
          return  true ;
      }

  }

推荐答案

看起来像滥用EF。



应该使用存储过程和JOIN。

Looks like abuse of EF.

Should be using a stored procedure and JOINs.

这篇关于循环继续选择相同的记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！