/// <param name=”Group”>分组依据，可以为空，不用填 group by</param>
/// <param name=”order”>排序，可以为空，为空默认按主键升序排列，不用填 order by</param>
/// <returns></returns>
public static DataTable Pagedlist(string Name, string pk, string fields, int pagesize, int CurrentPage, string Filter, string Group, string order)
{
CurrentPage = CurrentPage – 1;
DataTable dt = GetDataSet(CommandType.StoredProcedure, “fenye”,
new SqlParameter(“@TableNames”, Name),
new SqlParameter(“@PrimaryKey”, pk),
new SqlParameter(“@Fields”, fields),
new SqlParameter(“@PageSize”, pagesize),
new SqlParameter(“@CurrentPage”, CurrentPage),
new SqlParameter(“@Filter”, Filter),
new SqlParameter(“@Group”, Group),
new SqlParameter(“@Order”, order)
);
return dt;
}
public static int fenye_num(string Name, string Filter)
{
return (int)ExecuteScalar(CommandType.StoredProcedure, “fenye_num”,
new SqlParameter(“@TableNames”, Name),
new SqlParameter(“@Filter”, Filter));
}
/// <summary>
///
/// </summary>
/// <param name=”Name”>需要分页的表明</param>
/// <param name=”pk”>主键名</param>
/// <param name=”fields”>需要取出的字段,留空则为*</param>
/// <param name=”pagesize”>每页的记录数</param>
/// <param name=”CurrentPage”>当前页</param>
/// <param name=”Filter”>条件，可以为空，不用填 where</param>
/// <param name=”Group”>分组依据，可以为空，不用填 group by</param>
/// <param name=”order”>排序，可以为空，为空默认按主键升序排列，不用填 order by</param>
/// <param name=”objanp”>传递aspnetpager控件</param>
/// <returns></returns>
public static DataTable Paged(string Name, string pk, string fields, int pagesize, int CurrentPage, string Filter, string Group, string order, AspNetPager objanp)
{
CurrentPage = CurrentPage – 1;
DataTable dt = GetDataSet(CommandType.StoredProcedure, “fenye”,
new SqlParameter(“@TableNames”, Name),
new SqlParameter(“@PrimaryKey”, pk),
new SqlParameter(“@Fields”, fields),
new SqlParameter(“@PageSize”, pagesize),
new SqlParameter(“@CurrentPage”, CurrentPage),
new SqlParameter(“@Filter”, Filter),
new SqlParameter(“@Group”, Group),
new SqlParameter(“@Order”, order)
);
objanp.RecordCount = fenye_num(Name, Filter);
return dt;
}
}
}
以及页面调用方式
