using System; using System.Collections.Generic; using System.Linq.Expressions; namespace CommonUtil.Db { /// /// 数据库操作扩展接口 /// public interface IDbSet where T : class, new() { #region Avg函数 /// /// Avg函数 /// /// 返回值 /// avg函数表达式 /// TResult Avg(Expression> avg); /// /// Avg函数 /// /// 返回值 /// where函数表达式 /// avg函数表达式 /// TResult Avg(Expression> where, Expression> avg); /// /// Avg函数 /// /// 返回值 /// 表名 /// avg函数表达式 /// TResult Avg(string tableName, Expression> avg); /// /// Avg函数 /// /// 返回值 /// 表名 /// where函数表达式 /// avg函数表达式 /// TResult Avg(string tableName, Expression> where, Expression> avg); /// /// Avg函数 /// /// 返回值 /// 库名 /// 表名 /// avg函数表达式 /// TResult Avg(string storeName, string tableName, Expression> avg); /// /// Avg函数 /// /// 返回值 /// 库名 /// 表名 /// where函数表达式 /// avg函数表达式 /// TResult Avg(string storeName, string tableName, Expression> where, Expression> avg); #endregion #region Sum函数 /// /// Sum函数 /// /// /// /// /// TResult Sum(Expression> where, Expression> sum); /// /// Sum函数 /// /// /// /// /// TResult Sum(string tableName, Expression> sum); /// /// Sum函数 /// /// /// /// /// /// TResult Sum(string tableName, Expression> where, Expression> sum); /// /// Sum函数 /// /// /// /// /// /// TResult Sum(string storeName, string tableName, Expression> sum); /// /// Sum函数 /// /// /// /// /// /// /// TResult Sum(string storeName, string tableName, Expression> where, Expression> sum); #endregion #region Min函数 /// /// Min函数 /// /// /// /// TResult Min(Expression> min); /// /// Min函数 /// /// /// /// /// TResult Min(Expression> where, Expression> min); /// /// Min函数 /// /// /// /// /// TResult Min(string tableName, Expression> min); /// /// Min函数 /// /// /// /// /// /// TResult Min(string tableName, Expression> where, Expression> min); /// /// Min函数 /// /// /// /// /// /// TResult Min(string storeName, string tableName, Expression> min); /// /// Min函数 /// /// /// /// /// /// /// TResult Min(string storeName, string tableName, Expression> where, Expression> min); #endregion #region Max函数 /// /// Max函数 /// /// /// /// TResult Max(Expression> max); /// /// Max函数 /// /// /// /// /// TResult Max(Expression> where, Expression> max); /// /// Max函数 /// /// /// /// /// TResult Max(string tableName, Expression> max); /// /// Max函数 /// /// /// /// /// /// TResult Max(string tableName, Expression> where, Expression> max); /// /// Max函数 /// /// /// /// /// /// TResult Max(string storeName, string tableName, Expression> max); /// /// Max函数 /// /// /// /// /// /// /// TResult Max(string storeName, string tableName, Expression> where, Expression> max); #endregion #region Count函数 /// /// Count函数 /// /// /// int Count(Expression> where); /// /// Count函数 /// /// /// int Count(string tableName); /// /// Count函数 /// /// /// /// int Count(string tableName, Expression> where); /// /// Count函数 /// /// /// /// int Count(string storeName, string tableName); /// /// Count函数 /// /// /// /// /// int Count(string storeName, string tableName, Expression> where); #endregion #region IsExist函数 /// /// 是否存在,IsExist函数 /// /// /// bool IsExist(Expression> where); /// /// IsAny函数 /// /// /// /// bool IsExist(string tableName, Expression> where); /// /// IsAny函数 /// /// /// /// /// bool IsExist(string storeName, string tableName, Expression> where); #endregion #region 根据主键查询 /// /// 根据主键查询 /// /// /// T GetById(long id); /// /// 根据主键查询 /// /// /// /// T GetById(long id, string tableName); /// /// 根据主键查询 /// /// /// /// /// T GetById(long id, string storeName, string tableName); /// /// 根据主键查询 /// /// /// T GetById(string id); /// /// 根据主键查询 /// /// /// /// T GetById(string id, string tableName); /// /// 根据主键查询 /// /// /// /// /// T GetById(string id, string storeName, string tableName); #endregion #region 查询单条,多条会抛出异常 /// /// 查询单条,多条会抛出异常 /// /// /// T GetSingle(Expression> where); /// /// 查询单条,多条会抛出异常 /// /// /// /// T GetSingle(Expression> where, string tableName); /// /// 查询单条,多条会抛出异常 /// /// /// /// /// T GetSingle(Expression> where, string storeName, string tableName); #endregion #region 查询第一条 /// /// 查询第一条 /// /// /// T GetFirst(Expression> where); /// /// 查询第一条 /// /// /// T GetFirst(string tableName); /// /// 查询第一条 /// /// /// /// T GetFirst(Expression> order, DbEnum.OrderType? orderBy); /// /// 查询第一条 /// /// /// /// T GetFirst(string tableName, Expression> where); /// /// 查询第一条 /// /// /// /// T GetFirst(string storeName, string tableName); /// /// 查询第一条 /// /// /// /// /// T GetFirst(Expression> where, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询第一条 /// /// /// /// /// T GetFirst(string tableName, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询第一条 /// /// /// /// /// T GetFirst(string storeName, string tableName, Expression> where); /// /// 查询第一条 /// /// /// /// /// /// T GetFirst(string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询第一条 /// /// /// /// /// /// T GetFirst(string storeName, string tableName, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询第一条 /// /// /// /// /// /// /// T GetFirst(string storeName, string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy); #endregion #region 查询全部 /// /// 查询全部 /// /// /// List ListGet(Expression> groupBy); /// /// 查询全部 /// /// /// List ListGet(Expression> where); /// /// 查询全部 /// /// /// List ListGet(string tableName); /// /// 查询全部 /// /// /// /// List ListGet(Expression> groupBy, Expression> having); /// /// 查询全部 /// /// /// /// List ListGet(Expression> where, Expression> groupBy); /// /// 查询全部 /// /// /// /// List ListGet(string tableName, Expression> groupBy); /// /// 查询全部 /// /// /// /// List ListGet(Expression> order, DbEnum.OrderType? orderBy); /// /// 查询全部 /// /// /// /// List ListGet(string tableName, Expression> where); /// /// 查询全部 /// /// /// /// List ListGet(string storeName, string tableName); /// /// 查询全部 /// /// /// /// /// List ListGet(string tableName, Expression> groupBy, Expression> having); /// /// 查询全部 /// /// /// /// /// List ListGet(string tableName, Expression> where, Expression> groupBy); /// /// 查询全部 /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> groupBy); /// /// 查询全部 /// /// /// /// /// List ListGet(Expression> where, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询全部 /// /// /// /// /// List ListGet(string tableName, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询全部 /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> where); /// /// 查询全部 /// /// /// /// /// /// List ListGet(Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); /// /// 查询全部 /// /// /// /// /// /// List ListGet(string tableName, Expression> where, Expression> groupBy, Expression> having); /// /// 查询全部 /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> groupBy, Expression> having); /// /// 查询全部 /// /// /// /// /// /// List ListGet(Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy); /// /// 查询全部 /// /// /// /// /// /// List ListGet(string tableName, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy); /// /// 查询全部 /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> where, Expression> groupBy); /// /// 查询全部 /// /// /// /// /// /// List ListGet(string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询全部 /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询全部 /// /// /// /// /// /// /// List ListGet(Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); /// /// 查询全部 /// /// /// /// /// /// /// List ListGet(string tableName, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); /// /// 查询全部 /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> where, Expression> groupBy, Expression> having); /// /// 查询全部 /// /// /// /// /// /// /// List ListGet(string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy); /// /// 查询全部 /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy); /// /// 查询全部 /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询全部 /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); /// /// 查询全部 /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); /// /// 查询全部 /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy); /// /// 查询全部 /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); #endregion #region 分页查询全部 /// /// 分页查询全部 /// /// /// /// /// List ListPageGet(int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// List ListPageGet(Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// List ListPageGet(Expression> where, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// List ListPageGet(string tableName, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// List ListPageGet(Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// List ListPageGet(Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// List ListPageGet(Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> where, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// List ListPageGet(Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// List ListPageGet(Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// List ListPageGet(Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> where, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询全部 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); #endregion #region 查询指定列 /// /// 查询指定列 /// /// /// /// /// List ListGet(Expression> select, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// List ListGet(Expression> select, Expression> where); /// /// 查询指定列 /// /// /// /// /// List ListGet(string tableName, Expression> select); /// /// 查询指定列 /// /// /// /// /// /// List ListGet(Expression> select, Expression> groupBy, Expression> having); /// /// 查询指定列 /// /// /// /// /// /// List ListGet(Expression> select, Expression> where, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// /// List ListGet(Expression> select, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询指定列 /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> where); /// /// 查询指定列 /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select); /// /// 查询指定列 /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> groupBy, Expression> having); /// /// 查询指定列 /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> where, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询指定列 /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询指定列 /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> where); /// /// 查询指定列 /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); /// /// 查询指定列 /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> where, Expression> groupBy, Expression> having); /// /// 查询指定列 /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> groupBy, Expression> having); /// /// 查询指定列 /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> where, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询指定列 /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询指定列 /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); /// /// 查询指定列 /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); /// /// 查询指定列 /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> where, Expression> groupBy, Expression> having); /// /// 查询指定列 /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy); /// /// 查询指定列 /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); /// /// 查询指定列 /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); /// /// 查询指定列 /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy); /// /// 查询指定列 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having); #endregion #region 分页查询指定列 /// /// 分页查询指定列 /// /// /// /// /// /// /// List ListPageGet(Expression> select, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> where, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> where, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, Expression> select, string tableName, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> where, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount); /// /// 分页查询指定列 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount); #endregion #region 联表查询指定列,简写 /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> where) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> where, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); #endregion #region 联表查询指定列,自定义 /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> where) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> where, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy) where T1 : class, new() where T2 : class, new(); /// /// 联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having) where T1 : class, new() where T2 : class, new(); #endregion #region 分页联表查询指定列,简写 /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, Expression> select, Expression> join, string tableName, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,简写 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); #endregion #region 分页联表查询指定列,自定义 /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, Expression> select, Expression> join, string tableName, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); #endregion #region 分页三表联表查询指定列,自定义 /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, Expression> select, Expression> join, string tableName, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); /// /// 分页三表联表查询指定列,自定义 /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// /// List ListPageGet(string storeName, string tableName, Expression> select, Expression> join, Expression> where, Expression> order, DbEnum.OrderType? orderBy, Expression> groupBy, Expression> having, int pageIndex, int pageSize, ref int totalCount) where T1 : class, new() where T2 : class, new(); #endregion /// /// Update函数 /// /// /// /// /// int Update(T t, Expression> update, Expression> where); /// /// Update函数 /// /// /// /// /// /// int Update(T t, string tableName, Expression> update, Expression> where); /// /// Update函数 /// /// /// /// /// /// /// int Update(T t, string storeName, string tableName, Expression> update, Expression> where); /// /// Update函数 /// /// /// /// int Update(Expression> set, Expression> where); /// /// Update函数 /// /// /// /// /// int Update(string tableName, Expression> set, Expression> where); /// /// Update函数 /// /// /// /// /// /// int Update(string storeName, string tableName, Expression> set, Expression> where); /// /// Delete函数 /// /// /// bool Delete(long id); /// /// Delete函数 /// /// /// /// bool Delete(string tableName, long id); /// /// Delete函数 /// /// /// /// /// bool Delete(string storeName, string tableName, long id); /// /// Delete函数 /// /// /// /// /// int DeleteReturnCommand(string storeName, string tableName, long id); /// /// Delete函数 /// /// /// /// /// int DeleteRange(string storeName, string tableName, IEnumerable id); /// /// Delete函数 /// /// /// bool Delete(string id); /// /// Delete函数 /// /// /// /// bool Delete(string tableName, string id); /// /// Delete函数 /// /// /// /// /// bool Delete(string storeName, string tableName, string id); /// /// Delete函数,返回行数结果 /// /// /// /// /// int DeleteReturnCommand(string storeName, string tableName, string id); /// /// Delete函数 /// /// /// /// /// int DeleteRange(string storeName, string tableName, IEnumerable id); /// /// Delete函数 /// /// /// int Delete(Expression> where); /// /// Delete函数 /// /// /// /// int Delete(string tableName, Expression> where); /// /// Delete函数 /// /// /// /// /// int Delete(string storeName, string tableName, Expression> where); /// /// Insert函数 /// /// /// bool Insert(T t); /// /// Insert函数 /// /// /// /// bool Insert(string tableName, T t); /// /// Insert函数 /// /// /// /// /// bool Insert(string storeName, string tableName, T t); /// /// Insert函数 /// /// /// T InsertReturnEntity(T t); /// /// Insert函数 /// /// /// /// T InsertReturnEntity(string tableName, T t); /// /// Insert函数 /// /// /// /// /// T InsertReturnEntity(string storeName, string tableName, T t); /// /// Insert函数 /// /// /// /// /// /// /// int Insert(string storeName, string tableName, T t, Expression> insertColumns, Expression> ignoreColumns); /// /// Insert函数 /// /// /// /// /// /// /// T InsertReturnEntity(string storeName, string tableName, T t, Expression> insertColumns, Expression> ignoreColumns); /// /// Insert函数 /// /// /// /// /// /// /// int InsertRange(string storeName, string tableName, IEnumerable t, Expression> insertColumns, Expression> ignoreColumns); /// /// Insert函数 /// /// 实体集合 /// int InsertRange(IEnumerable t); /// /// Insert函数 /// /// 表名 /// 实体集合 /// int InsertRange(string tableName, IEnumerable t); /// /// Insert函数 /// /// 库名 /// 表名 /// 实体集合 /// int InsertRange(string storeName, string tableName, IEnumerable t); /// /// Insert函数 /// /// 实体集合 /// 插入列 /// int InsertRange(IEnumerable t, Expression> insertColumns); /// /// Insert函数 /// /// 表名 /// 实体集合 /// 插入列 /// int InsertRange(string tableName, IEnumerable t, Expression> insertColumns); /// /// Insert函数 /// /// 库名 /// 表名 /// 实体集合 /// 插入列 /// int InsertRange(string storeName, string tableName, IEnumerable t, Expression> insertColumns); /// /// Insert函数 /// /// 实体集合 /// 插入列 /// 忽略列 /// int InsertRange(IEnumerable t, Expression> insertColumns, Expression> ignoreColumns); /// /// Insert函数 /// /// 表名 /// 实体集合 /// 插入列 /// 忽略列 /// int InsertRange(string tableName, IEnumerable t, Expression> insertColumns, Expression> ignoreColumns); /// /// 执行sql /// /// 库名 /// sql语句 /// 参数 /// 影响行数 int ExecuteCommand(string storeName, string sql, object parameters); /// /// 执行sql /// /// sql语句 /// 参数 /// 影响行数 int ExecuteCommand(string sql, object parameters); /// /// 执行sql /// /// 库名 /// sql语句 /// 可变参数 /// 影响行数 int ExecuteCommand(string storeName, string sql, params SqlSugar.SugarParameter[] parameters); /// /// 执行sql /// /// sql语句 /// 可变参数 /// 影响行数 int ExecuteCommand(string sql, params SqlSugar.SugarParameter[] parameters); /// /// 执行sql /// /// 库名 /// sql语句 /// 参数集合 /// 影响行数 int ExecuteCommand(string storeName, string sql, List parameters); /// /// 执行sql /// /// sql语句 /// 参数集合 /// 影响行数 int ExecuteCommand(string sql, List parameters); /// /// sql查询 /// /// 结果类型 /// 库名 /// sql语句 /// 参数 /// 结果类型集合 List SqlQuery(string storeName, string sql, object parameters); /// /// sql查询 /// /// 结果类型 /// sql语句 /// 参数 /// 结果类型集合 List SqlQuery(string sql, object parameters); /// /// sql查询 /// /// 结果类型 /// 库名 /// sql语句 /// 可变参数 /// 结果类型集合 List SqlQuery(string storeName, string sql, params SqlSugar.SugarParameter[] parameters); /// /// sql查询 /// /// 结果类型 /// sql语句 /// 可变参数 /// 结果类型集合 List SqlQuery(string sql, params SqlSugar.SugarParameter[] parameters); /// /// 执行sql /// /// 库名 /// sql语句 /// 参数集合 /// 影响行数 List SqlQuery(string storeName, string sql, List parameters); /// /// 执行sql /// /// sql语句 /// 参数集合 /// 影响行数 List SqlQuery(string sql, List parameters); /// /// sql分页查询 /// /// 结果类型 /// 库名 /// sql语句 /// 页码 /// 页大小 /// 总数 /// 参数 /// 结果类型集合 List SqlQuery(string storeName, string sql, int pageIndex, int pageSize, ref int totalCount, params SqlSugar.SugarParameter[] parameters) where TResult : class, new(); /// /// sql分页查询 /// /// 结果类型 /// sql语句 /// 页码 /// 页大小 /// 总数 /// 参数 /// 结果类型集合 List SqlQuery(string sql, int pageIndex, int pageSize, ref int totalCount, params SqlSugar.SugarParameter[] parameters) where TResult : class, new(); /// /// sql分页查询 /// /// 结果类型 /// 库名 /// sql语句 /// 页码 /// 页大小 /// 总数 /// 参数 /// 结果类型集合 List SqlQuery(string storeName, string sql, int pageIndex, int pageSize, ref int totalCount, object parameters) where TResult : class, new(); /// /// sql分页查询 /// /// 结果类型 /// sql语句 /// 页码 /// 页大小 /// 总数 /// 参数 /// 结果类型集合 List SqlQuery(string sql, int pageIndex, int pageSize, ref int totalCount, object parameters) where TResult : class, new(); /// /// sql分页查询 /// /// 结果类型 /// 库名 /// sql语句 /// 页码 /// 页大小 /// 总数 /// 参数 /// 结果类型集合 List SqlQuery(string storeName, string sql, int pageIndex, int pageSize, ref int totalCount, List parameters) where TResult : class, new(); /// /// sql分页查询 /// /// 结果类型 /// sql语句 /// 页码 /// 页大小 /// 总数 /// 参数 /// 结果类型集合 List SqlQuery(string sql, int pageIndex, int pageSize, ref int totalCount, List parameters) where TResult : class, new(); /// /// 使用事务 /// /// 执行委托 /// SqlSugar.DbResult UseTran(Action action); /// /// 使用事务 /// /// 执行委托 /// 错误回调委托 /// SqlSugar.DbResult UseTran(Action action, Action errorCallBack); } }