public ActionResult Index()
{
SheetQueryParameter parameter = new SheetQueryParameter
{
Name = Identity.Name,
Deleted = false
};
var list = Core.SheetManager.GetSheets(parameter).OrderByDescending(e => e.Time).ToList();
ViewBag.List = list;
ViewBag.RollBackList = list.Where(e => e.Status == Status.RollBack).Take(10).ToList();
return(View());
}
public ActionResult CashCheck(string name = null)
{
var parameter = new SheetQueryParameter
{
Status = Status.Cash
};
var list = Core.SheetManager.GetSheets(parameter);
var users = list.GroupBy(e => e.Name).Select(e => e.Key).ToList();
ViewBag.Users = users;
if (!string.IsNullOrEmpty(name))
{
list = list.Where(e => e.Name.ToLower() == name.ToLower()).ToList();
}
else
{
list = list.OrderByDescending(e => e.Name).ToList();
}
ViewBag.Name = name;
ViewBag.List = list;
return(View());
}
public List <Sheet> GetSheets(SheetQueryParameter parameter)
{
var list = GetSheets();
var query = list.AsQueryable();
if (!string.IsNullOrEmpty(parameter.Name))
{
query = query.Where(e => e.Name == parameter.Name);
}
if (!string.IsNullOrEmpty(parameter.Controler))
{
query = query.Where(e => e.Controler == parameter.Controler);
}
if (parameter.Deleted.HasValue)
{
query = query.Where(e => e.Deleted == parameter.Deleted.Value);
}
if (parameter.Status.HasValue)
{
query = query.Where(e => e.Status == parameter.Status.Value);
}
return(query.ToList());
}
