/// <summary>
/// 公用分页存储过程调用
/// </summary>
/// <param name="tableName">表名</param>
/// <param name="fields">表中的字段，可以使用*代替</param>
/// <param name="orderField">要排序的字段</param>
/// <param name="sqlWhere">WHERE子句</param>
/// <param name="pageSize">分页的大小</param>
/// <param name="pageIndex">要显示的页的索引</param>
/// <param name="totalPage">返回的总页数</param>
/// <param name="recordCount">返回的总记录数</param>
/// <returns>返回DataSet</returns>
public static DataTable GetPageProBll(string tableName, string fields, string orderField, string sqlWhere, int pageSize, int pageIndex, out int totalPage, out int recordCount)
{
totalPage = 0;
recordCount = 0;
DataSet ds = new ProcUtility().GetPagePro(tableName, fields, orderField, sqlWhere, pageSize, pageIndex, out totalPage, out recordCount);
return(ds.Tables[0]);
//return DataTableToList(ds.Tables[0]);
}
/// <summary>
/// 公用更新存储过程 调用
/// </summary>
/// <param name="tableName">传入表名</param>
/// <param name="fields">传入需要更新的字段</param>
/// <param name="where">传入更新的条件</param>
/// <returns></returns>
public static bool Pro_ModifyBll(string tableName, string fields, string where)
{
int n = new ProcUtility().Pro_Modify(tableName, fields, where);
if (n > 0)
{
return(true);
}
else
{
return(false);
}
}