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