/// <summary>
/// ��ҳ��ȡ���������б�
/// </summary>
public PageList<Model.PersonInPositionView> GetPageList(PageInfo pi)
{
pi.RecordCount = GetCount();
pi.Compute();
PageList<Model.PersonInPositionView> pl = new PageList<Model.PersonInPositionView>(pi);
using (DbDataReader dr = dbHelper.ExecuteReader(CommandType.Text, "SELECT * FROM PersonInPositionView", null))
{
pl.List = GetPageList(dr, pi.FirstIndex, pi.PageSize);
}
return pl;
}
/// <summary>
/// 分页获取泛型数据列表
/// </summary>
public PageList<ZSystem.Model.t_Operation> GetPageList(PageInfo pi)
{
pi.RecordCount = GetCount();
pi.Compute();
PageList<ZSystem.Model.t_Operation> pl = new PageList<ZSystem.Model.t_Operation>(pi);
using (DbDataReader dr = dbHelper.ExecuteReader(CommandType.Text, "SELECT * FROM t_Operation", null))
{
pl.List = GetPageList(dr, pi.FirstIndex, pi.PageSize);
}
return pl;
}
/// <summary>
/// ��ҳ��ȡ���������б�
/// </summary>
public PageList<Model.C_PersonnelDocumentsClass> GetPageList(PageInfo pi)
{
pi.RecordCount = GetCount();
pi.Compute();
PageList<Model.C_PersonnelDocumentsClass> pl = new PageList<Model.C_PersonnelDocumentsClass>(pi);
using (DbDataReader dr = dbHelper.ExecuteReader(CommandType.Text, "SELECT * FROM C_PersonnelDocumentsClass", null))
{
pl.List = GetPageList(dr, pi.FirstIndex, pi.PageSize);
}
return pl;
}
