public IEnumerable<ManagerComment> Search(ManagerCommentCondition condition)
{
using (var db = new Entities())
{
var id = CurrentUserBiz.CurrentUser.ID;
IQueryable<ManagerComment> query = db.ManagerComment.Include(q => q.UserInfo).Where(q => q.UserID == id);
if (condition.StartDate.HasValue)
{
var date = condition.StartDate.Value.Date;
query = query.Where(q => q.ModifyDate >= date);
}
if (condition.EndDate.HasValue)
{
var date = condition.EndDate.Value.Date.AddDays(1).AddMilliseconds(-1);
query = query.Where(q => q.ModifyDate <= date);
}
var result = query.OrderByDescending(q => q.ModifyDate).DoPage(condition.Pager).ToList();
foreach (var item in result)
{
item.CreateUser = db.UserInfo.FirstOrDefault(q => q.Status == (int)StatusEnum.Valid && q.ID == item.CreateUserID);
item.ModifyUser = db.UserInfo.FirstOrDefault(q => q.Status == (int)StatusEnum.Valid && q.ID == item.ModifyUserID);
}
return result;
}
}
// GET: LeanManage/ManageComment
public ActionResult Index(ManagerCommentCondition condition)
{
var datas = ManagerCommentBiz.Search(condition);
var model = PDM.Create(datas, condition);
return View(model);
}
