public static DataTable GetPageWithSp(ProcCustomPage pcp, out int recordCount)
{
using (var conn = new SqlConnection(cs))
{
using (var cmd = conn.CreateCommand())
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = pcp.Sp_PagerName;
cmd.InjectFrom(new SetParamsValues().IgnoreFields("sp_pagername"), pcp);
SqlParameter outputPara = new SqlParameter("@RecordCount", SqlDbType.Int);
outputPara.Direction = ParameterDirection.Output;
cmd.Parameters.Add(outputPara);
conn.Open();
using (var da = new SqlDataAdapter(cmd))
{
DataSet ds = new DataSet();
da.Fill(ds);
cmd.Parameters.Clear();
recordCount = PublicMethod.GetInt(outputPara.Value);
conn.Close();
return(ds.Tables[0]);
}
}
}
}
public DataTable GetPageWithSp(ProcCustomPage pcp, out int recordCount)
{
return(DbUtils.GetPageWithSp(pcp, out recordCount));
}