/// <summary>
/// 获取EasyUIRequest对应的分页数据
/// </summary>
/// <param name="request"></param>
/// <param name="args"></param>
/// <param name="sql"></param>
/// <returns></returns>
public MVCPagerData GetPagerData(MVCRequest request, object args, string sql)
{
ExecSqlQuery queryEr = MVCNHibernateHelp.BuildPager(request, args, sql);
queryEr.Sql = sql;
return(GetPagerData(request, queryEr));
}
/// <summary>
/// 获取所有数据
/// </summary>
/// <param name="request"></param>
/// <param name="queryEr"></param>
/// <param name="sql"></param>
/// <returns></returns>
public IList GetAllData(MVCRequest request, IDictionary <string, object> args, string sql)
{
ExecSqlQuery queryEr = MVCNHibernateHelp.BuildSqlQuery(args, sql);
SqlPart sqlPart = MVCNHibernateHelp.RefactorToSqlPart(request, sql);
return(GetData(queryEr, sqlPart));
}
/// <summary>
/// Build一个分页用的Pager
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public static ExecSqlQuery BuildPager(MVCRequest request)
{
SqlPager queryEr = new SqlPager();
queryEr.FirstResult = request.Offset;
queryEr.MaxResults = request.Rows;
return(queryEr);
}
/// <summary>
/// 将sql+request表达的部分，重新构建sql，考虑NHibernate参数为:的情况
/// </summary>
/// <param name="request"></param>
/// <param name="sql"></param>
/// <returns></returns>
public static SqlPart RefactorToSqlPart(MVCRequest request, string sql)
{
string sqlCopy = sql.Replace(":", "@");
SqlPart sqlPart = MVCRequestHelp.RefactorToSqlPart(request, sqlCopy);
sqlPart = ConvertSqlPart(sqlPart);
return(sqlPart);
}
/// <summary>
/// 获取EasyUIRequest对应的分页数据
/// </summary>
/// <param name="request"></param>
/// <param name="queryEr"></param>
/// <returns></returns>
public MVCPagerData GetPagerData(MVCRequest request, ExecSqlQuery queryEr)
{
#region 数据部分
string sql = queryEr.Sql;
SqlPart sqlPart = MVCNHibernateHelp.RefactorToSqlPart(request, sql);
IList listData = GetData(queryEr, sqlPart);
#endregion
#region count行数部分
//默认行数
int total = GetCount(queryEr, sqlPart);
#endregion
return(new MVCPagerData {
rows = listData, total = total
});
}
/// <summary>
/// Build一个分页用的Pager
/// </summary>
/// <param name="request"></param>
/// <param name="args"></param>
/// <param name="sql"></param>
/// <param name="queryEr">默认是一个分页的SqlPager类型</param>
/// <returns></returns>
public static ExecSqlQuery BuildPager(MVCRequest request, object args, string sql = null)
{
ExecSqlQuery queryEr = BuildPager(request);
return(BuildSqlQuery(args, sql, queryEr));
}