public override IDataReader GetByPage(object tableName, string fieldList, FilterObject[] filterObjects, OrderObject[] orderObjects, int pageNum, int pageSize, ref int pageCount, ref int totalRowCount)
{
string filter = PagingHelper.CreateSafeFilter(filterObjects);
try
{
totalRowCount = (int)SqlHelper.ExecuteScalar(_connectionString, StoredProcedureName.TotalRowCount, tableName, filter);
}
catch
{
totalRowCount = 0;
}
if (totalRowCount == 0)
{
pageCount = 0;
return(null);
}
if (pageSize <= 0 || totalRowCount <= pageSize)
{
pageCount = 1;
}
else
{
pageCount = (totalRowCount + pageSize - 1) / pageSize;
}
if (pageNum < 1 || pageNum > pageCount)
{
return(null);
}
return(SqlHelper.ExecuteReader(_connectionString, StoredProcedureName.GetByPage, tableName, fieldList, filter,
PagingHelper.CreateOrder(orderObjects), pageNum, pageSize, pageCount));
}
public static List <NhanVienInfo> GetAll()
{
if (Cache)
{
List <NhanVienInfo> list = DataCache.GetCache(Key) as List <NhanVienInfo>;
if (list == null)
{
list = CBO.FillCollection <NhanVienInfo>(DataProvider.Instance().GetAll(
Table.NhanVien,
PagingHelper.CreateOrder(new OrderObject(TableNhanVien.MaNV, SortOrder.Desc))));
list.TrimExcess();
DataCache.SetCache(Key, list);
}
return(list);
}
return(CBO.FillCollection <NhanVienInfo>(DataProvider.Instance().GetAll(
Table.NhanVien,
PagingHelper.CreateOrder(new OrderObject(TableNhanVien.MaNV, SortOrder.Desc)))));
}
public static List <Customer_ContractInfo> GetAll()
{
if (Cache)
{
List <Customer_ContractInfo> list = DataCache.GetCache(Key) as List <Customer_ContractInfo>;
if (list == null)
{
list = CBO.FillCollection <Customer_ContractInfo>(DataProvider.Instance().GetAll(
Table.Customer_Contract,
PagingHelper.CreateOrder(new OrderObject(TableCustomer_Contract.ID, SortOrder.Desc))));
list.TrimExcess();
DataCache.SetCache(Key, list);
}
return(list);
}
return(CBO.FillCollection <Customer_ContractInfo>(DataProvider.Instance().GetAll(
Table.Customer_Contract,
PagingHelper.CreateOrder(new OrderObject(TableCustomer_Contract.ID, SortOrder.Desc)))));
}
public static List <Monitoring_Seed_QuantityInfo> GetAll()
{
if (Cache)
{
List <Monitoring_Seed_QuantityInfo> list = DataCache.GetCache(Key) as List <Monitoring_Seed_QuantityInfo>;
if (list == null)
{
list = CBO.FillCollection <Monitoring_Seed_QuantityInfo>(DataProvider.Instance().GetAll(
Table.Monitoring_Seed_Quantity,
PagingHelper.CreateOrder(new OrderObject(TableMonitoring_Seed_Quantity.ID, SortOrder.Desc))));
list.TrimExcess();
DataCache.SetCache(Key, list);
}
return(list);
}
return(CBO.FillCollection <Monitoring_Seed_QuantityInfo>(DataProvider.Instance().GetAll(
Table.Monitoring_Seed_Quantity,
PagingHelper.CreateOrder(new OrderObject(TableMonitoring_Seed_Quantity.ID, SortOrder.Desc)))));
}
public static List <ChiTietTraHangInfo> GetAll()
{
if (Cache)
{
List <ChiTietTraHangInfo> list = DataCache.GetCache(Key) as List <ChiTietTraHangInfo>;
if (list == null)
{
list = CBO.FillCollection <ChiTietTraHangInfo>(DataProvider.Instance().GetAll(
Table.ChiTietTraHang,
PagingHelper.CreateOrder(new OrderObject(TableChiTietTraHang.MaPhieuTra, SortOrder.Desc))));
list.TrimExcess();
DataCache.SetCache(Key, list);
}
return(list);
}
return(CBO.FillCollection <ChiTietTraHangInfo>(DataProvider.Instance().GetAll(
Table.ChiTietTraHang,
PagingHelper.CreateOrder(new OrderObject(TableChiTietTraHang.MaPhieuTra, SortOrder.Desc)))));
}