Exemple #1
0
        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="strColumn">查询的字段名,空则返回全部</param>
        /// <param name="pageSize">每页记录数</param>
        /// <param name="currentPage">当前页数</param>
        /// <param name="strWhere">查询条件</param>
        /// <param name="orderBy">排序字段</param>
        /// <param name="pageCount">返回页数总数</param>
        /// <param name="recordCount">返回记录总数</param>
        /// <returns></returns>
        public List <T> GetAllByPage(string strColumn, int pageSize, int currentPage, string strWhere, string orderBy, out int pageCount, out int recordCount)
        {
            pageCount = 1;
            List <T> allLog = ExecSqlConn.GetTableList <T>(tableName, strColumn, orderBy, "Ld", pageSize, currentPage, strWhere, sqlConn, out recordCount);

            pageCount = CFun.pagecount(recordCount);
            return(allLog);
        }