/// <summary>
/// 根据当前筛选条件，获得不分页的数据
/// </summary>
/// <returns></returns>
public DataTable GetAllData()
{
ExecSqlQuery queryEr = new ExecSqlQuery();
DataTable dt = GetData(queryEr);
return(dt);
}
/// <summary>
///
/// </summary>
/// <param name="pageSize"></param>
/// <param name="pageIndex"></param>
/// <returns></returns>
public PagerData GetPagerData(int pageSize, int pageIndex)
{
SqlPager queryEr = new SqlPager();
queryEr.FirstResult = pageSize * pageIndex;
queryEr.MaxResults = pageSize;
DataTable dt = GetData(queryEr);
ExecSqlQuery countQuery = new ExecSqlQuery();
if (SimpleCount)
{
countQuery.Sql = @"select count(1) as total " + FromSqlPart + " " + WhereAndOtherExpress;
}
else
{
countQuery.Sql = @"select count(1) as total " + string.Format(" from ({0}) t22 ", @"select 1 as id23 " + FromSqlPart + " " + WhereAndOtherExpress);
}
countQuery.ParamerList.AddRange(queryEr.ParamerList);
IList listCountData = Ht.ExecuteFind(countQuery);
int total = dt.Rows.Count;
if (listCountData != null && listCountData.Count > 0)
{
int.TryParse(Convert.ToString((listCountData[0] as Hashtable)["total"]), out total);
}
PagerData returnData = new PagerData {
Data = dt, Total = total
};
return(returnData);
}
/// <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>
/// 获取所有数据
/// </summary>
/// <param name="queryEr"></param>
/// <param name="sql"></param>
/// <returns></returns>
public IList GetAllData(object args, string sql)
{
ExecSqlQuery queryEr = MVCNHibernateHelp.BuildSqlQuery(args, sql);
SqlPart sqlPart = MVCNHibernateHelp.RefactorToSqlPart(sql);
return(GetData(queryEr, sqlPart));
}
/// <summary>
/// 获取数据
/// </summary>
/// <param name="queryEr"></param>
/// <param name="sqlPart"></param>
/// <returns></returns>
public IList GetData(ExecSqlQuery queryEr, SqlPart sqlPart)
{
queryEr.Sql = SqlPartHelp.ConvertToSqlString(sqlPart);
IList listData = Ht.ExecuteFind(queryEr);
return(listData);
}
/// <summary>
/// 把sql和条件装载到queryEr，然后执行queryEr上的方法获得数据
/// </summary>
/// <param name="queryEr"></param>
/// <returns></returns>
public DataTable GetData(ExecSqlQuery queryEr)
{
//下面查询是导案板中的一条记录*一个卡主一条记录
queryEr.Sql = FieldsSqlPart + " " + FromSqlPart + " " + WhereAndOtherExpress + " " + OrderSqlPart;
queryEr.ParamerList.AddRange(this.ParamerList);
IList listData = Ht.ExecuteFind(queryEr);
DataTable dt = HashTableListToDataTable.ToDataTable(listData);
return(dt);
}
/// <summary>
/// 获取行数
/// </summary>
/// <param name="queryEr"></param>
/// <param name="sqlPart"></param>
/// <returns></returns>
public int GetCount(ExecSqlQuery queryEr, SqlPart sqlPart)
{
int total = 0;
ExecSqlQuery countQuery = new ExecSqlQuery();
countQuery.Sql = SqlPartHelp.GetCountSql(sqlPart);
countQuery.ParamerList.AddRange(queryEr.ParamerList);
IList listCountData = Ht.ExecuteFind(countQuery);
if (listCountData != null && listCountData.Count > 0)
{
int.TryParse(Convert.ToString((listCountData[0] as Hashtable)["total"]), out total);
}
return(total);
}
/// <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));
}
/// <summary>
/// 将request、args、sql所代表的属性赋值给queryEr
/// </summary>
/// <param name="request"></param>
/// <param name="args"></param>
/// <param name="sql"></param>
/// <param name="queryEr">有可能是ExecSqlQuery或SqlPager类型</param>
/// <returns></returns>
public static ExecSqlQuery BuildSqlQuery(object args, string sql, ExecSqlQuery queryEr)
{
queryEr.ParamerList.AddRange(MVCNHibernateHelp.ConvertToParamerList(args, sql));
return(queryEr);
}
/// <summary>
/// 如果需要不分页的数据，调用这个函数
/// </summary>
/// <param name="request"></param>
/// <param name="args"></param>
/// <param name="sql"></param>
/// <returns></returns>
public static ExecSqlQuery BuildSqlQuery(object args, string sql = null)
{
ExecSqlQuery queryEr = new ExecSqlQuery();
return(BuildSqlQuery(args, sql, queryEr));
}
/// <summary>
/// 如果需要不分页的数据，调用这个函数
/// </summary>
/// <param name="request"></param>
/// <param name="args"></param>
/// <param name="sql"></param>
/// <returns></returns>
public static ExecSqlQuery BuildSqlQuery(IDictionary <string, object> args, string sql = null)
{
ExecSqlQuery queryEr = new ExecSqlQuery();
return(BuildSqlQuery(args, sql, queryEr));
}
