public static List <Order> ListOfOrders(int page, int pageSize, string searchValue, string customer, int employee, int shipper, out int rowCount)
{
if (page < 1)
{
page = 1;
}
if (pageSize < 0)
{
pageSize = 20;
}
rowCount = OrderDB.Count(searchValue, customer, employee, shipper);
return(OrderDB.List(page, pageSize, searchValue, customer, employee, shipper));
}
/// <summary>
/// Lay ra danh sach hóa đơn co phan trang so trang va dem so dong
/// </summary>
/// <param name="page"></param>
/// <param name="pageSize"></param>
/// <param name="searchValue"></param>
/// <param name="rowCount"></param>
/// <returns></returns>
public static List <Order> ListOfOrder(int page, int pageSize, string searchValue, out int rowCount)
{
if (page < 1)
{
page = 1;
}
if (pageSize < 0)
{
pageSize = 20;
}
rowCount = OrderDB.Count(searchValue);
return(OrderDB.List(page, pageSize, searchValue));
}
public static List <Order> ListOfOrder(
int page,
int pageSize,
out int rowCount,
string country,
string category,
string employee,
string shipper
)
{
rowCount = OrderDB.Count(country, category, employee, shipper);
return(OrderDB.List(page, pageSize, country, category, employee, shipper));
}
public static int Order_Count(int page, int pageSize, string customerID, int employeeID, int shippID)
{
return(OrderDB.Count(page, pageSize, customerID, employeeID, shippID));
}
/// <summary>
/// Đếm số truy vấn tìm kiếm được
/// </summary>
/// <param name="searchValue">Giá trị cần tìm kiếm</param>
/// <param name="customerId">Mã khách hàng</param>
/// <param name="employeeId">Mã nhân viên</param>
/// <param name="shipperId">Mã người giao hàng</param>
/// <returns>Số kết quả tìm được</returns>
public static int Order_Count(string searchValue, string customerId, int employeeId, int shipperId)
{
return(OrderDB.Count(searchValue, customerId, employeeId, shipperId));
}
public static List <Order> ListOfOrder(int page, int pageSize, string searchValue, out int rowCount)
{
rowCount = OrderDB.Count(searchValue);
return(OrderDB.List(page, pageSize, searchValue));
}