在项目中经常会遇到几个表join之后 取出一些数据,并不是所有数据,每个表可能抽一部分出来
这个时候就需要去定义一个我们需要的页面使用的viewmodel 来接收我们需要的数据。
1:先join查出来我们需要的数据源信息
2:convertAll 将数据源信息转化成ViewModel
public List<ReviewInfo> GetReviewAndStar(string tourCode, int languagesId)
{
var query1 = DbContext.ReviewsInfo.Where(a => a.Tourcode == tourCode && a.LanguagesId == languagesId && a.Active).AsQueryable();
var query2 = DbContext.FeedBackCityofTypeList.Where(a => a.CityOrType.ToUpper() == "OVERALL PRICE & VALUE").AsQueryable();
var query = from t in query1
join y in query2 on t.FeedBackId equals y.FeedBackId
select new
{
FeedBackId = t.FeedBackId,
Tourcode = t.Tourcode,
ReviewComment = t.ReviewComment,
GuideComment = t.GuideComment,
FirstName = t.FirstName,
LastName = t.LastName,
Star = y.Value,
Order=t.Order,
NickName=t.NickName
};
List<ReviewInfo> list = query.ToList().ConvertAll<ReviewInfo>(item => new ReviewInfo()
{
FeedBackId = item.FeedBackId,
Tourcode = item.Tourcode,
ReviewComment = item.ReviewComment,
GuideComment = item.GuideComment,
FirstName = item.FirstName,
LastName = item.LastName,
Star = item.Star,
Order = item.Order,
NickName=item.NickName
});
return list;
}