//無搜尋值的搜尋資料方法
public List <Products> GetAllDataList(ForPaging Paging)
{
//宣告要回傳的搜尋資料為資料庫中的Guestbooks資料表
IQueryable <Products> Data = db.Products;
//計算所需的總頁數
Paging.MaxPage = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(Data.Count()) / Paging.ItemNum));
//重新設定正確的頁數，避免有不正確值傳入
Paging.SetRightPage();
//回傳搜尋資料
return(Data.OrderByDescending(p => p.ProductID).Skip((Paging.NowPage - 1) * Paging.ItemNum).Take(Paging.ItemNum).ToList());
}
//根據搜尋來取得資料陣列的方法
public List <Products> GetDataList(ForPaging Paging, ProductsView searchCondition)
{
//宣告要接受全部搜尋資料的物件
IQueryable <Products> SearchData;
SearchData = db.Products;
string productID = "";
string productName = "";
if (searchCondition.ProductID != null)
{
productID = searchCondition.ProductID.ToString().Trim();
}
if (searchCondition.ProductName != null)
{
productName = searchCondition.ProductName.Trim();
}
if (String.IsNullOrEmpty(productID) == false)
{
SearchData = SearchData.Where(p => p.ProductID.ToString().Contains(productID));
}
if (String.IsNullOrEmpty(productName) == false)
{
SearchData = SearchData.Where(p => p.ProductName.ToString().Contains(productName));
}
//計算所需的總頁數
Paging.MaxPage = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(SearchData.Count()) / Paging.ItemNum));
//重新設定正確的頁數，避免有不正確值傳入
Paging.SetRightPage();
//先排序再根據分頁來回傳所需部分的資料陣列
return(SearchData.OrderByDescending(p => p.ProductID).Skip((Paging.NowPage - 1) * Paging.ItemNum).Take(Paging.ItemNum).ToList());
}