public ActionResult History(CheckStatus status = CheckStatus.All, int page = 1)
{
var filter = new DataBookFilter
{
Name = sAMAccountName,
Status = status,
Page = new Page(page)
};
ViewBag.List = Core.DataBookManager.Get(filter);
ViewBag.Page = filter.Page;
return View();
}
//审批历史
public ActionResult CHistory(bool? Label, CheckStatus status = CheckStatus.All, string Name = null, string GroupName = null, int page = 1)
{
var filter = new DataBookFilter
{
Status = status,
Checker = sAMAccountName,
Name = Name,
GroupName = GroupName,
Label = Label,
Page = new Page(page)
};
ViewBag.List = Core.DataBookManager.Get(filter);
ViewBag.Page = filter.Page;
var list = Core.DataBookManager.GetList(sAMAccountName);
ViewBag.NList = list.GroupBy(e => e.Name).Select(e => e.Key).ToList();
ViewBag.GList = list.GroupBy(e => e.GroupName).Select(e => e.Key).ToList();
return View();
}
public List<DataBook> Get(DataBookFilter Filter)
{
using (var db = GetJURDataContext())
{
var query = db.DataBooks.AsQueryable();
switch (Filter.Status)
{
case CheckStatus.Agree:
case CheckStatus.Disagree:
case CheckStatus.Wait:
query = query.Where(e => e.Status == Filter.Status);
break;
case CheckStatus.All:
default:
break;
}
if (!string.IsNullOrEmpty(Filter.Name))
{
query = query.Where(e => e.Name == Filter.Name);
}
if (!string.IsNullOrEmpty(Filter.Checker))
{
query = query.Where(e => e.Checker == Filter.Checker);
}
if (!string.IsNullOrEmpty(Filter.GroupName))
{
query = query.Where(e => e.GroupName == Filter.GroupName);
}
if (Filter.Label.HasValue)
{
query = query.Where(e => e.Label == Filter.Label.Value);
}
if (Filter.Page != null)
{
Filter.Page.RecordCount = query.Count();
query = query.OrderBy(e => e.ID).Skip(Filter.Page.PageSize * (Filter.Page.PageIndex - 1)).Take(Filter.Page.PageSize);
}
return query.ToList();
}
}
