/// <summary>
/// 获取审核列表
/// </summary>
/// <param name="reviewCondition"></param>
/// <returns></returns>
public ActionResult GetReviewList(ReviewCondition reviewCondition)
{
var rt = ReviewUtils.GetReviewList(this.dbContext, reviewCondition);
var json = Newtonsoft.Json.JsonConvert.SerializeObject(rt, new CustomNullableDateTimeConverter());
return(Content(json));
}
public static Dictionary<string, object> GetReviewList(EFDbContext dbContext, ReviewCondition rCdts)
{
var query = (from c in dbContext.CapturedInfo
where
(rCdts.status.Contains(c.Status) || (rCdts.status.Contains(ReviewStatusTypes.pending) ? string.IsNullOrEmpty(c.Status) : true)) &&
rCdts.catagory.Contains(c.Catagory)
select new ReviewItem
{
SourceID = c._ID.ToString(),
Title = c.Title,
Content = c.Content,
Catagory = c.Catagory,
Date = c.CapturedTime,
SourceType = "自动抓取",
Geometry = string.Empty,
Link = c.Link
})
.Union
(from r in dbContext.ReportInfo
where
rCdts.status.Contains(r.Status)
select new ReviewItem
{
SourceID = r.ID,
Title = r.Title,
Content = r.Content,
Catagory = string.Empty,
Date = r.ReportTime,
SourceType = "用户上报",
Geometry = r.Geometry,
Link = string.Empty
})
.Where(
p =>
p.Date >= rCdts.beginDate &&
p.Date <= rCdts.endDate &&
(rCdts.keyWord == null ? true : p.Content.Contains(rCdts.keyWord)) &&
rCdts.sourceType.Contains(p.SourceType)
);
//var t = (from c in dbContext.CapturedInfo
// where
// rCdts.status.Contains(c.Status)
// &&
// rCdts.catagory.Contains(c.Catagory)
// select c
// //select new ReviewItem
// //{
// // SourceID = c._ID.ToString(),
// // Title = c.Title,
// // Content = c.Content,
// // Catagory = c.Catagory,
// // Date = c.CapturedTime,
// // SourceType = "自动抓取",
// // Geometry = string.Empty
// //}
// ).ToList();
//var t = query.ToList();
var items = query.OrderByDescending(p => p.Date).Skip((rCdts.page - 1) * rCdts.rows).Take(rCdts.rows).ToList();
var dict = new Dictionary<string, object>();
dict["total"] = query.Count();
dict["rows"] = items;
return dict;
}
