public List <Exchange> getExchangeList(ForPaging Paging, string Currency)
{
try
{
IQueryable <Exchange> SearchData;
SearchData = db.Exchanges.Where(p => p.Currency.Equals(Currency));
if (String.IsNullOrEmpty(Currency) || SearchData.Count() == 0)
{
List <Exchange> nullExchange = new List <Exchange>();
Paging.MaxPage = 1;
Paging.SetRightPage();
return(nullExchange);
}
else
{
Paging.MaxPage = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(SearchData.Count() / Paging.ItemNum)));
Paging.SetRightPage();
return(SearchData.OrderByDescending(p => p.QuotedDate).Skip((Paging.NowPage - 1) * Paging.ItemNum).Take(Paging.ItemNum).ToList());
}
}
catch (System.IO.IOException e)
{
logger.Error(LogUtility.GetExceptionDetails(e));
return(null);
}
}
//根據分頁以及搜尋來取得資料陣列的方法
public List <Invoices> GetDataList(ForPaging Paging, string Search, string DateSearch, string sortOrder)
{
//宣告要接受全部搜尋資料的物件
IQueryable <Invoices> SearchData;
//判斷搜尋是否為空或Null，用於決定要呼叫取得搜尋資料
SearchData = GetAllDataList(Paging, Search, DateSearch, sortOrder);
//先排序再根據分頁來回傳所需部分的資料陣列
return(SearchData.OrderByDescending(p => p.InvoicesDate)
.Skip((Paging.NowPage - 1) *
Paging.ItemNum).Take(Paging.ItemNum).ToList());
}
public List <Libor> getLiborList()
{
try
{
IQueryable <Libor> SearchData;
SearchData = db.Libors;
return(SearchData.OrderByDescending(p => p.QuotedDate).ToList());
}
catch (System.IO.IOException e)
{
logger.Error(LogUtility.GetExceptionDetails(e));
return(null);
}
}
public List <Guestbooks> GetDataList(ForPaging Paging, string Search)
{
//宣告要接受全部搜尋資料的物件
IQueryable <Guestbooks> SearchData;
//判斷搜尋是否為空或Null，用於決定要呼叫取得搜尋資料
if (String.IsNullOrEmpty(Search))
{
SearchData = GetAllDataList(Paging);
}
else
{
SearchData = GetAllDataList(Paging, Search);
}
//先排序再根據分頁來回傳所需部分的資料陣列
return(SearchData.OrderByDescending(p => p.Id).Skip((Paging.NowPage - 1) * Paging.ItemNum).Take(Paging.ItemNum).ToList());
}
//搜尋專案|定義分頁資料筆數
public List <Projects> GetSearchProject(Paging Paging, string Search, string UserName)
{
IQueryable <Projects> SearchData;
Users data = userservice.FindUser(UserName);
//判斷是否有搜尋資料
if (string.IsNullOrEmpty(Search))
{
//無搜尋資料
SearchData = GetAllDataList(Paging, data.UserId);
}
else
{
//有搜尋資料
SearchData = GetAllDataList(Paging, Search, data.UserId);
}
return(SearchData.OrderByDescending(p => p.ProjectId).Skip((Paging.NowPage - 1) * (Paging.ItemNum)).Take(Paging.ItemNum).ToList());
}
//根據分頁以及搜尋來取得資料陣列的方法
public List <Article> GetDataList(ForPaging Paging, string Search)
{
//設定要接受全部搜尋資料的物件
IQueryable <Article> SearchData;
//判斷搜尋是否為空或Null，以決定要呼叫設定搜尋資料
if (String.IsNullOrEmpty(Search))
{
SearchData = GetAllDataList(Paging);
}
else
{
SearchData = GetAllDataList(Paging, Search);
}
//先排序再根據分頁來回傳所需的部分資料陣列
return(SearchData.OrderByDescending(p => p.A_Id)
.Skip((Paging.NowPage - 1) * Paging.ItemNum)
.Take(Paging.ItemNum).ToList());
}
public List <Guestbooks> GetDataList(ForPaging Paging, string Search)
{
try
{
IQueryable <Guestbooks> SearchData;
if (String.IsNullOrEmpty(Search))
{
SearchData = GetAllDataList(Paging);
}
else
{
SearchData = GetAllDataList(Paging, Search);
}
return(SearchData.OrderByDescending(p => p.Id).Skip((Paging.NowPage - 1) * Paging.ItemNum).Take(Paging.ItemNum).ToList());
}
catch (System.IO.IOException e)
{
logger.Error(LogUtility.GetExceptionDetails(e));
return(null);
}
}
//根據搜尋來取得資料陣列的方法
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());
}