/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="tablesql">要执行的sql语句</param>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
StringBuilder tablesql = new StringBuilder();
tablesql.Append("select * ");
tablesql.Append(" FROM dbo.[OperationLog] ");
return(BWJSLogHelperSQL.GetPageList(tablesql.ToString(), where.ToString(), pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}
/// <summary>
/// 分页获得数据列表
/// </summary>
/// <param name="where">查询条件</param>
/// <param name="pageIndex">当前页索引</param>
/// <param name="pageSize">页尺寸</param>
/// <param name="orderBy">排序字段&排序方向</param>
/// <param name="sql">返回完整的的可执行sql</param>
/// <param name="zys">总页数</param>
/// <param name="sumcount">总记录数</param>
/// <returns>DataTable</returns>
public DataTable GetList(string tablesql, string where, int pageIndex, int pageSize, string orderBy, ref string sql, ref int zys, ref int sumcount)
{
return(BWJSLogHelperSQL.GetPageList(tablesql, where, pageIndex, pageSize, orderBy, ref sql, ref zys, ref sumcount));
}