/// <summary>
/// 操作Column表 分页查询数据
/// </summary>
/// <param name="pageSize">每页数据条数</param>
/// <param name="currentPage">当前页数</param>
/// <param name="sWhere">查询条件</param>
/// <param name="resultNum">查询结果总数</param>
/// <returns>返回的查询数据集</returns>
public DataTable GetColumn(int pageSize,int currentPage,string sWhere,out int resultNum)
{
SqlParameter[] parms = {
new SqlParameter("@pageSize",SqlDbType.Int,4),
new SqlParameter("@currentPage",SqlDbType.Int,4),
new SqlParameter("@sWhere",SqlDbType.VarChar,4000),
new SqlParameter("@resultNum",SqlDbType.Int,4)
};
parms[0].Value = pageSize;
parms[1].Value = currentPage;
parms[2].Value = sWhere;
parms[3].Direction = ParameterDirection.Output;
DataTable dt = new DataTable();
CommandDal cmddal = new CommandDal();
resultNum = cmddal.RunProc("zcms_column_dal",parms,out dt);
return dt;
}
/// 操作Column表 分页查询数据
/// </summary>
/// <param name="pageSize">每页数据条数</param>
/// <param name="currentPage">当前页数</param>
/// <param name="sWhere">查询条件</param>
/// <param name="resultNum">查询结果总数</param>
/// <returns>返回的查询数据集</returns>
public DataTable GetColumn(int pageSize,int currentPage,string sWhere,out int resultNum)
{
SqlParameter[] parms = {
new SqlParameter("@pageSize",SqlDbType.Int,4),
new SqlParameter("@currentPage",SqlDbType.Int,4),
new SqlParameter("@sWhere",SqlDbType.VarChar,4000),
new SqlParameter("@resultNum",SqlDbType.Int,4)
};
parms[0].Value = pageSize;
parms[1].Value = currentPage;
parms[2].Value = sWhere;
parms[3].Direction = ParameterDirection.Output;
DataTable dt = new DataTable();
CommandDal cmddal = new CommandDal();
resultNum = cmddal.RunProc("zcms_column_dal",parms,out dt);
return dt;
}
//其中输出参数 @resultNum 需要设置属性 parms[3].Direction = ParameterDirection.Output;