/// <summary>
/// 查询总条数
/// </summary>
/// <param name="queryPageModel"></param>
/// <param name="sqlParameters"></param>
/// <returns></returns>
public static int QueryTotalCount <T>(QueryPageModel queryPageModel, T model)
{
string sqlBase = string.Format(@"(select count(*) from {0}", queryPageModel.QuerySql);
int count = DapperDBHelper.Instance.ExcuteScalarQuery <T>(sqlBase, model);
return(count);
}
/// <summary>
/// 查询总数
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="queryPageModel"></param>
/// <param name="model"></param>
/// <returns></returns>
public static IList <T> QueryWithPage <T>(QueryPageModel queryPageModel, T model)
{
string sqlBase = @"select * from (select *,row_number()over(order by {0}) as rownmber from
{1} result
where result.rownmber>{2} and result.rownmber<= {3}";
string finalSql = string.Format(sqlBase, queryPageModel.OrderBy, queryPageModel.QuerySql, queryPageModel.PageIndex * queryPageModel.PageSize, (queryPageModel.PageIndex + 1) * queryPageModel.PageSize);
//用dapperDbHelper 查询数据
IList <T> result = DapperDBHelper.Instance.ExcuteQuery <T>(finalSql, model);
return(result);
}
