#region linq方式(待优化)
if (RoleTyp == 3)//大农户
{
if (IsClosed == 0)//进行中
{
IList demandList =
(from d in dbContext.T_FARMER_PUBLISHED_DEMAND
join u in dbContext.T_USER
on d.CreateUserId equals u.Id
join s in dbContext.T_SYS_DICTIONARY on d.DemandTypeId equals s.Code
where d.PublishStateId == 0
orderby d.CreateTime descending
select new PublishedDemandRepositoryModel
{
Name = s.DisplayName,
PublishedDate = d.CreateTime,
Status = d.PublishStateId,
Address = d.Province + "" + d.City + "" + d.Region + "" + d.Township + "" + d.Village,
DetailAddress = d.DetailedAddress,
RequirementType = s.DisplayName,
PhoneNumber = u.PhoneNumber,
Remark = d.Brief
}).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
return demandList;
}
else//已关闭
{
IList demandList = (from d in dbContext.T_FARMER_PUBLISHED_DEMAND
join u in dbContext.T_USER
on d.CreateUserId equals u.Id
join s in dbContext.T_SYS_DICTIONARY on d.DemandTypeId equals s.Code
where d.PublishStateId != 0
orderby d.CreateTime descending
select new PublishedDemandRepositoryModel
{
Name = s.DisplayName,
PublishedDate = d.CreateTime,
Status = d.PublishStateId,
Address = d.Province + "" + d.City + "" + d.Region + "" + d.Township + "" + d.Village,
DetailAddress = d.DetailedAddress,
RequirementType = s.DisplayName,
PhoneNumber = u.PhoneNumber,
Remark = d.Brief
}).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
return demandList;
}
}
else if (RoleTyp == 5) //产业商
{
if (IsClosed == 0)//进行中
{
IList<PublishedDemandRepositoryModel> demandList =
(from d in dbContext.T_BUSINESS_PUBLISHED_DEMAND
join u in dbContext.T_USER
on d.CreateUserId equals u.Id
join s in dbContext.T_SYS_DICTIONARY on d.DemandTypeId equals s.Code
where d.PublishStateId == 0
orderby d.CreateTime descending
select new PublishedDemandRepositoryModel
{
Name = s.DisplayName,
PublishedDate = d.CreateTime,
Status = d.PublishStateId,
Address = d.Province + "" + d.City + "" + d.Region + "" + d.Township + "" + d.Village,
DetailAddress = d.DetailedAddress,
RequirementType = s.DisplayName,
PhoneNumber = u.PhoneNumber,
Remark = d.Brief
}).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
return demandList;
}
else//已关闭
{
IList<PublishedDemandRepositoryModel> demandList = (from d in dbContext.T_BUSINESS_PUBLISHED_DEMAND
join u in dbContext.T_USER
on d.CreateUserId equals u.Id
join s in dbContext.T_SYS_DICTIONARY on d.DemandTypeId equals s.Code
where d.PublishStateId !=0
orderby d.CreateTime descending
select new PublishedDemandRepositoryModel
{
Name = s.DisplayName,
PublishedDate = d.CreateTime,
Status = d.PublishStateId,
Address = d.Province + "" + d.City + "" + d.Region + "" + d.Township + "" + d.Village,
DetailAddress = d.DetailedAddress,
RequirementType = s.DisplayName,
PhoneNumber = u.PhoneNumber,
Remark = d.Brief
}).Skip((PageIndex - 1) * PageSize).Take(PageSize).ToList();
return demandList;
}
}
else
{
return null;
}
#endregion