谁能提供 linq 查询

Question

现在我想LINQ查询，如果像以下compIds是0001或技术，然后我可以检查与条件divisionCode ，如果compIds是0005或0006则不需要检查与divisionCode这样任何人都可以提供suggetioncompId可能增加取决于需求string[] compID = new string[] { "0002", "0001", "0005", "0006" };string[] divisionCode = new string[] { "01021159", "02013350", "02013483", "02013804", "02013375", "02013374", "02013380", "02013398", "02017379", "02013391", "02013444", "02013353", "02004458", "02013394" };var ACM = (from t1 in Entity.ApprovedContracts          join t2 in Entity.ApprovedResources          on t1.ApprovedResourceId equals t2.ResourceGeneralId          where compID.Contains(t1.OpuCode) && divisionCode.Contains(t1.DivisionCode)          select new          {                t1.OpuCode,                t1.DivisionCode,                t2.EnterpriseId,                t2.ResourceEmail          }).ToList();here

Answer 1

我认为只需要添加更多条件......应该是这样的......

string[] compID = new string[] { "0002", "0001", "0005", "0006" };

string[] divisionCode = new string[] { "01021159", "02013350", "02013483", "02013804", "02013375", "02013374", "02013380", "02013398", "02017379", "02013391", "02013444", "02013353", "02004458", "02013394" };

var ACM = (from t1 in Entity.ApprovedContracts

      join t2 in Entity.ApprovedResources

      on t1.ApprovedResourceId equals t2.ResourceGeneralId

      where compID.Contains(t1.OpuCode) && (t1.OpuCode == "0005" || t1.OpuCode == "0006" || divisionCode.Contains(t1.DivisionCode)

      select new

      {

            t1.OpuCode,

            t1.DivisionCode,

            t2.EnterpriseId,

            t2.ResourceEmail

      }).ToList();