public ActionResult QueryNumber6(int page = 1) { // 進入搜尋頁面 不主動撈取資料 HkLot49ViewModel viewModel = new HkLot49ViewModel(); // 從資料庫撈資料 List <LotNumber6> DBdata = _HkLot49Services.GetNumber6Services(); viewModel.LotNumber6 = DBdata.OrderByDescending(x => x.開獎日期).ToPagedList(page, PageSize); return(View(viewModel)); }
public ActionResult QueryNumber6(HkLot49ViewModel data) { // 從資料庫撈資料 List <LotNumber6> DBdata = _HkLot49Services.GetNumber6Services(); data.Page = data.Page == 0 ? 2 : data.Page + 1; // 當日期符合開始與結束日期 if (!string.IsNullOrWhiteSpace(data.StartDate) && !string.IsNullOrWhiteSpace(data.EndDate)) { data.LotNumber6 = DBdata.Where(p => p.開獎日期.CompareTo(data.StartDate) >= 0 && p.開獎日期.CompareTo(data.EndDate) <= 0).OrderByDescending(m => m.開獎日期).ToPagedList(data.Page > 0 ? data.Page - 1 : 0, PageSize); } else { data.LotNumber6 = DBdata.OrderByDescending(x => x.開獎日期).ToPagedList(data.Page > 0 ? data.Page - 1 : 0, PageSize); } return(View(data)); }