public ActionResult List() { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.AttendanceLog.List(); var tb = from p in db.Table <Attendance.Entity.tbAttendanceLog>() select p; if (string.IsNullOrEmpty(vm.SearchText) == false) { tb = tb.Where(d => d.CardNumber.Contains(vm.SearchText)); } if (string.IsNullOrWhiteSpace(vm.FromTime)) { vm.FromTime = Code.DateHelper.MonthFirstDay.ToString(Code.Common.StringToDate); } if (string.IsNullOrWhiteSpace(vm.ToTime)) { vm.ToTime = Code.DateHelper.MonthLastDay.ToString(Code.Common.StringToDate); } var fromTime = vm.FromTime.ConvertToDateTime(); var toTime = vm.ToTime.ConvertToDateTime(); tb = tb.Where(d => d.AttendanceDate > fromTime && d.AttendanceDate < toTime); vm.DataList = (from p in tb orderby p.No select p).ToPageList(vm.Page); return(View(vm)); } }
public ActionResult List(Models.AttendanceLog.List vm) { return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, FromTime = vm.FromTime, ToTime = vm.ToTime, pageIndex = vm.Page.PageIndex, pageSize = vm.Page.PageSize }))); }