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)); } }