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