62,046
社区成员
发帖
与我相关
我的任务
分享
/// <summary>
/// 分页方法
/// </summary>
/// <param name="tblName">表名</param>
/// <param name="fldName">排序字段名</param>
/// <param name="strGetFields">读取的字段</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageIndex">页索引</param>
/// <param name="orderType">排序方式,true=正序</param>
/// <param name="strWhere">where子句,不必加'where'</param>
/// <param name="Count">记录总数</param>
/// <returns></returns>
public static DataSet GetPageList(string tblName, string fldName, string strGetFields, int PageSize, int PageIndex, bool orderType, string strWhere, ref int Count)
{
SqlParameter[] pars = new SqlParameter[]{
new SqlParameter("@tblName",tblName),
new SqlParameter("@fldName",fldName),
new SqlParameter("@strGetFields",strGetFields),
new SqlParameter("@PageSize",PageSize),
new SqlParameter("@PageIndex",PageIndex),
new SqlParameter("@orderType",orderType?0:1),
new SqlParameter("@strWhere",strWhere),
new SqlParameter("@Count",Count)
};
pars[7].Direction = ParameterDirection.Output;
return RunProcedure("up_DataPage", pars, "ds");
}
/// <summary>
/// 分页方法
/// </summary>
/// <param name="tblName">表名</param>
/// <param name="fldName">排序字段名</param>
/// <param name="strGetFields">读取的字段</param>
/// <param name="PageSize">页大小</param>
/// <param name="PageIndex">页索引</param>
/// <param name="orderType">排序方式,true=正序</param>
/// <param name="strWhere">where子句,不必加'where'</param>
/// <param name="Count">记录总数</param>
/// <returns></returns>
public static DataSet GetPageList(string tblName, string fldName, string strGetFields, int PageSize, int PageIndex, bool orderType, string strWhere, out int Count)
{
Count=0;
SqlParameter[] pars = new SqlParameter[]{
new SqlParameter("@tblName",tblName),
new SqlParameter("@fldName",fldName),
new SqlParameter("@strGetFields",strGetFields),
new SqlParameter("@PageSize",PageSize),
new SqlParameter("@PageIndex",PageIndex),
new SqlParameter("@orderType",orderType?0:1),
new SqlParameter("@strWhere",strWhere),
new SqlParameter("@Count",Count)
};
pars[7].Direction = ParameterDirection.Output;
DataSet ds=new DataSet ();
ds=RunProcedure("up_DataPage", pars, "ds");
int.TryParse(pars[7].ToString(),out Count)
return ds;
}
上面调用这个函数的也把ref int Count 换成 out int Count
试试。