/// <summary>
/// Page分页（DataTable.js）
/// </summary>
/// <param name="search">search</param>
/// <returns></returns>
public TablePage <T> GetQueryPage(Search search)
{
try
{
Page <T> pageModel;
object[] args;
string strWhere = search.GetConditonByDapper(out args);
pageModel = ReadDataBase.Page <T>(search.CurrentPageIndex, search.PageSize, Sql.Builder.Select(search.SelectedColums).From(search.TableName).Where(strWhere, args).OrderBy(search.SortField));
TablePage <T> tablePage = new TablePage <T>();
if (pageModel != null)
{
tablePage.draw = search.sEcho;
tablePage.recordsTotal = pageModel.TotalItems;
tablePage.recordsFiltered = pageModel.TotalItems;
tablePage.aaData = pageModel.Items;
}
return(tablePage);
}
catch (Exception ex)
{
LogHelper.Error(ex);
ReadDataBase.CloseSharedConnection();
return(null);
}
finally
{
ReadDataBase.CloseSharedConnection();
}
}
/// <summary>
/// Page分页
/// </summary>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">页容量</param>
/// <param name="sqlwhere">条件</param>
/// <param name="orderby">排序</param>
/// <returns></returns>
public Page <T> GetQueryPage(int pageIndex, int pageSize, string sqlwhere, string orderby)
{
try
{
if (string.IsNullOrEmpty(sqlwhere))
{
sqlwhere = "1=1";
}
if (string.IsNullOrEmpty(orderby))
{
orderby = "id desc";
}
Page <T> pageModel = ReadDataBase.Page <T>(pageIndex, pageSize, Sql.Builder.Select("*").From(TableName).Where(sqlwhere).OrderBy(orderby));
return(pageModel);
}
catch (Exception ex)
{
LogHelper.Error(ex);
ReadDataBase.CloseSharedConnection();
return(null);
}
finally
{
ReadDataBase.CloseSharedConnection();
}
}
/// <summary>
/// 单表分页 单表查询
/// </summary>
/// <returns></returns>
public Page <T> GetPage(int pageIndex, int pageSize)
{
try
{
return(ReadDataBase.Page <T>(1, 10, Sql.Builder.Select("*").From(TableName)));
}
catch (Exception ex)
{
log.Info("GetPage(pageIndex,pageSize):" + ex);
}
finally
{
ReadDataBase.CloseSharedConnection();
}
return(null);
}
/// <summary>
/// Page分页
/// </summary>
/// <param name="pageIndex">当前页</param>
/// <param name="pageSize">页容量</param>
/// <returns></returns>
public Page <T> GetQueryPage(int pageIndex, int pageSize)
{
try
{
Page <T> pageModel = ReadDataBase.Page <T>(pageIndex, pageSize, Sql.Builder.Select("*").From(TableName));
return(pageModel);
}
catch (Exception ex)
{
LogHelper.Error(ex);
ReadDataBase.CloseSharedConnection();
return(null);
}
finally
{
ReadDataBase.CloseSharedConnection();
}
}
/// <summary>
/// Page分页（手机版）todo：（弃用）
/// </summary>
/// <param name="search">search</param>
/// <returns></returns>
public Page <T> Page(Search search)
{
try
{
Page <T> pageModel;
object[] args;
string strWhere = search.GetConditonByDapper(out args);
pageModel = ReadDataBase.Page <T>(search.CurrentPageIndex, search.PageSize, Sql.Builder.Select(search.SelectedColums).From(search.TableName).Where(strWhere, args).OrderBy(search.SortField));
return(pageModel);
}
catch (Exception ex)
{
LogHelper.Error(ex);
ReadDataBase.CloseSharedConnection();
return(null);
}
finally
{
ReadDataBase.CloseSharedConnection();
}
}
