public ActionResult List(Models.SysUserLog.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new
{
searchText = vm.SearchText,
dateSearchFrom = vm.DateSearchFrom,
dateSearchTo = vm.DateSearchTo,
pageIndex = vm.Page.PageIndex,
pageSize = vm.Page.PageSize,
pageOrderBy = vm.Page.PageOrderBy,
pageOrderDesc = vm.Page.PageOrderDesc
})));
}
public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.SysUserLog.List();
if (string.IsNullOrEmpty(vm.DateSearchFrom))
{
vm.DateSearchFrom = Code.Common.DateMonthFirst.ToString(Code.Common.StringToDate);
vm.DateSearchTo = Code.Common.DateMonthLast.ToString(Code.Common.StringToDate);
}
var fromDate = DateTime.Parse(vm.DateSearchFrom);
var toDate = DateTime.Parse(vm.DateSearchTo).AddDays(1);
var tb = from p in db.Table <Sys.Entity.tbSysUserLog>()
.Include(d => d.tbSysUser)
where p.ActionDate >= fromDate &&
p.ActionDate < toDate
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.ActionContent.Contains(vm.SearchText) || d.tbSysUser.UserCode.Contains(vm.SearchText) || d.tbSysUser.UserName.Contains(vm.SearchText));
}
if (string.IsNullOrEmpty(vm.Page.PageOrderBy))
{
//默认排序
tb = tb.OrderByDescending(d => d.ActionDate);
}
else
{
tb = Code.LinqSort.OrderBy(tb, vm.Page.PageOrderBy + " " + vm.Page.PageOrderDesc);
}
vm.UserLogList = (from p in tb
select p).ToPageList(vm.Page);
return(View(vm));
}
}
