/// <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; }