/// <summary>
/// 多表存储过程查询
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="tblName"></param>
/// <param name="strGetFields"></param>
/// <param name="OrderfldName"></param>
/// <param name="strWhere"></param>
/// <param name="PageSize"></param>
/// <param name="PageIndex"></param>
/// <param name="OrderType"></param>
/// <returns></returns>
public ProcDataAndTotal <T> GetProcData <T>(string tblName, string strGetFields, string OrderfldName, string strWhere, int PageSize, int PageIndex, bool OrderType) where T : class, new()
{
using (IDbConnection conn = new SqlConnection()
{
ConnectionString = connectionString
})
{
DynamicParameters param = new DynamicParameters();
param.Add("@tblName", tblName);
param.Add("@strGetFields", strGetFields);
param.Add("@OrderfldName", OrderfldName);
param.Add("@strWhere", strWhere);
param.Add("@PageSize", PageSize);
param.Add("@PageIndex", PageIndex);
param.Add("@OrderType", OrderType);
param.Add("@doCount", 0, DbType.Int32, ParameterDirection.Output);
//返回的类
ProcDataAndTotal <T> dataAndTotal = new ProcDataAndTotal <T>()
{
ProcData = conn.Query <T>("Proc_MultipleTablesPager", param, commandType: CommandType.StoredProcedure).ToList(),
Total = param.Get <int>("@doCount"),
};
return(dataAndTotal);
}
}
/// <summary>
/// 单表存储过程查询
/// </summary>
/// <typeparam name="T">接收数据的类</typeparam>
/// <param name="TableName">要查询的表名</param>
/// <param name="ReFieldsStr">显示的字段</param>
/// <param name="OrderString">排序的字段</param>
/// <param name="WhereString">查询的条件</param>
/// <param name="PageSize">页数</param>
/// <param name="PageIndex">页码</param>
/// <returns></returns>
public ProcDataAndTotal <T> GetProcData <T>(string TableName, string ReFieldsStr, string OrderString, string WhereString, int PageSize, int PageIndex) where T : class, new()
{
using (IDbConnection conn = new SqlConnection()
{
ConnectionString = connectionString
})
{
DynamicParameters param = new DynamicParameters();
param.Add("@TableName", TableName);
param.Add("@ReFieldsStr", ReFieldsStr);
param.Add("@OrderString", OrderString);
param.Add("@WhereString", WhereString);
param.Add("@PageSize", PageSize);
param.Add("@PageIndex", PageIndex);
param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.Output);
//返回的类
ProcDataAndTotal <T> dataAndTotal = new ProcDataAndTotal <T>()
{
ProcData = conn.Query <T>("Proc_SingleTablePager", param, commandType: CommandType.StoredProcedure).ToList(),
Total = param.Get <int>("@TotalRecord"),
};
return(dataAndTotal);
}
}
