Ejemplo n.º 1
0
        /// <summary>
        /// Sql分页查询
        /// </summary>
        /// <typeparam name="TEntity">返回结果</typeparam>
        /// <param name="sql">sql语句</param>
        /// <param name="where">where条件</param>
        /// <param name="page">当前页</param>
        /// <param name="pageSize">每页显示记录数</param>
        /// <param name="order">排序,例如:name desc,nickname desc</param>
        /// <returns></returns>
        public PagedResult <TEntity> SqlPage <TEntity>(string sql, WhereCondition where, int page, int pageSize,
                                                       string order) where TEntity : class, new()
        {
            string whereSql = where.BuildSql();

            return(this.SqlPage <TEntity>(sql, whereSql, page, pageSize, order));
        }