c# - 如何在 LinQ 的 IQueryable 查询中添加序列号？

Question

这是我返回IQueryable查询的方法。我想根据记录数生成序列号。

public IQueryable<CompanyModel> GetCompanyData()
{

   var query = (from e in Context.tblCompany
                         where e.Cmp_Id == this.CompanyId
                         && e.TenantId == this.TenantId
                         select new CompanyModel()
                         {
                             CmpId = e.Cmp_Id,
                             SrNo = 0,
                         });
   return query;
}

标签： c#asp.net-mvclinq

Answer 1

你可以试试下面的代码可能对你有帮助

public IQueryable<CompanyModel> GetCompanyData()
{

List<CompanyModel> query = (from e in Context.tblCompany
                         where e.Cmp_Id == this.CompanyId
                         && e.TenantId == this.TenantId
                         select new CompanyModel()
                         {
                             CmpId = e.Cmp_Id,
                             SrNo = 0,
                         }).ToList();

 int counter=0;
 query.Foreach(x=>x.SrNo = counter++);

return query;
}