private static IDataReader GetListPages_SPPT(DbHelperBase DB, string sTableName, int PageSize, int PageIndex, string strFields, string KeyField, string OrderBy, string strWhere, out int totalRecords, string TablePrefix) { DbHelperBase base2 = DB; sTableName = TablePrefix + sTableName; if (string.IsNullOrEmpty(strFields)) { strFields = "*"; } SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@Tables", SqlDbType.VarChar, 0x3e8), new SqlParameter("@PrimaryKey", SqlDbType.VarChar, 10), new SqlParameter("@Sort", SqlDbType.VarChar, 200), new SqlParameter("@CurrentPage", SqlDbType.Int, 4), new SqlParameter("@PageSize", SqlDbType.Int, 4), new SqlParameter("@Fields", SqlDbType.VarChar, 0x3e8), new SqlParameter("@Filter", SqlDbType.VarChar, 0x3e8) }; commandParameters[0].Value = sTableName; commandParameters[1].Value = KeyField; commandParameters[2].Value = OrderBy.Trim(); commandParameters[3].Value = PageIndex; commandParameters[4].Value = PageSize; commandParameters[5].Value = strFields; commandParameters[6].Value = strWhere.Trim(); IDataReader reader = base2.ExecuteReader(CommandType.StoredProcedure, string.Format("{0}SplitPages", TablePrefix), commandParameters); string commandText = string.Format("select count(*) from {0} {1} ", sTableName, string.IsNullOrEmpty(strWhere) ? "" : (" Where " + strWhere)); object objA = base2.ExecuteScalar(CommandType.Text, commandText); totalRecords = 1; if (!object.Equals(objA, null)) { totalRecords = int.Parse(objA.ToString()); } return(reader); }
public static IDataReader GetListPagesSql2005(DbHelperBase DB, string sTableName, int PageSize, int PageIndex, string Fileds, string strWhere, string oderby, out int RecordCount) { string commandText = string.Format("select count(*) from {0} {1} ", sTableName, string.IsNullOrEmpty(strWhere) ? "" : (" Where " + strWhere)); object objA = DB.ExecuteScalar(CommandType.Text, commandText); RecordCount = 1; if (!object.Equals(objA, null)) { RecordCount = int.Parse(objA.ToString()); } string str2 = GetListPagesSql2005(sTableName, PageIndex, PageSize, Fileds, strWhere, oderby); return(DB.ExecuteReader(CommandType.Text, str2)); }