/// <summary> /// 调用存储过程分页 /// </summary> /// <param name="WhereClause"></param> /// <param name="OrderBy"></param> /// <param name="PageIndex"></param> /// <param name="PageSize"></param> /// <param name="TotalRows"></param> /// <param name="StoredProcedure">存储过程名称</param> /// <returns></returns> public DataTable GetPager(string WhereClause, string OrderBy, int PageIndex, int PageSize, ref int TotalRows, string StoredProcedure) { SqlParameter[] parms = new SqlParameter[] { new SqlParameter("@WhereClause", SqlDbType.VarChar, 2000), new SqlParameter("@OrderBy", SqlDbType.VarChar, 2000), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@TotalRows", SqlDbType.Int), }; parms[0].Value = WhereClause; parms[1].Value = OrderBy; parms[2].Value = PageIndex; parms[3].Value = PageSize; parms[4].Direction = ParameterDirection.Output; DataTableCollection tables = SQLHelper.DataSet(BS.Components.Data.Config.ConnConfig.getConn, StoredProcedure, CommandType.StoredProcedure, parms).Tables; if (tables.Count > 0) { DataTable dt = tables[0]; TotalRows = Convert.ToInt32(parms[4].Value != DBNull.Value ? parms[4].Value : 0); return(dt); } return(null); }