/// <summary> /// 查询并且返回集合(游标分页) /// </summary> /// <param name="sql">要查询的SQL语句</param> /// <param name="lstParam">参数集合</param> /// <param name="objPage">分页对象</param> /// <param name="oper">数据库对象</param> /// <returns></returns> public static IDataReader Query(string sql, ParamList lstParam, PageContent objPage, DataBaseOperate oper, Dictionary <string, bool> cacheTables) { objPage.TotleRecords = CutPageSqlCreater.GetTotleRecord(lstParam, oper, sql, objPage.MaxSelectRecords, cacheTables); long totlePage = (long)Math.Ceiling((double)objPage.TotleRecords / (double)objPage.PageSize); objPage.TotlePage = totlePage; if (objPage.CurrentPage >= objPage.TotlePage - 1) { objPage.CurrentPage = objPage.TotlePage - 1; } IDataReader reader = null; string qsql = GetCursorPageSql(sql, objPage); reader = oper.Query(qsql, lstParam, cacheTables); return(reader); }
/// <summary> /// 查询并且返回DataSet(游标分页) /// </summary> /// <param name="sql">要查询的SQL语句</param> /// <param name="lstParam">参数集合</param> /// <param name="objPage">分页对象</param> /// <param name="oper">数据库对象</param> /// <param name="curType">映射的实体类型(如果用回数据库的原列名,则此为null)</param> /// <returns></returns> public static DataTable QueryDataTable(string sql, ParamList lstParam, PageContent objPage, DataBaseOperate oper, Type curType, Dictionary <string, bool> cacheTables) { objPage.TotleRecords = CutPageSqlCreater.GetTotleRecord(lstParam, oper, sql, objPage.MaxSelectRecords, cacheTables); long totlePage = (long)Math.Ceiling((double)objPage.TotleRecords / (double)objPage.PageSize); objPage.TotlePage = totlePage; if (objPage.CurrentPage >= objPage.TotlePage - 1) { objPage.CurrentPage = objPage.TotlePage - 1; } if (objPage.CurrentPage >= objPage.TotlePage - 1) { objPage.CurrentPage = objPage.TotlePage - 1; } DataTable ret = new DataTable(); IDataReader reader = null; try { string qsql = GetCursorPageSql(sql, objPage); reader = oper.Query(qsql, lstParam, cacheTables); if (curType == null) { ret = CacheReader.GenerateDataTable(reader, "newDt", false); } else { ret = CacheReader.GenerateDataTable(reader, "newDt", curType, false); } } finally { reader.Close(); //oper.CloseDataBase(); } return(ret); }
/// <summary> /// 生成分页SQL语句 /// </summary> /// <param name="list">参数列表</param> /// <param name="oper">连接对象</param> /// <param name="objCondition">条件对象</param> /// <param name="objPage">分页记录类</param> /// <returns></returns> public string CreatePageSql(ParamList list, DataBaseOperate oper, SelectCondition objCondition, PageContent objPage, bool useCache) { return(CutPageSqlCreater.CreatePageSql(list, oper, objCondition, objPage, useCache)); }