public virtual TEntity Get <TEntity>(Expression <Func <TEntity, bool> > where, Expression <Func <TEntity, Columns> > select = null, string connectionString = null) { return(DMContext.Query <TEntity>().Where(where).Select(select).SetConnectionString(connectionString).Single()); }
public virtual List <TEntity> GetAll <TEntity>(Expression <Func <TEntity, Columns> > order = null, Expression <Func <TEntity, Columns> > select = null, string connectionString = null) { return(DMContext.Query <TEntity>().OrderBy(order).Select(select).SetConnectionString(connectionString).ToList()); }
/// <summary> /// 分页获取记录集合 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> /// <param name="pageIndex">第几页</param> /// <param name="pageSize">每页大小</param> /// <param name="where">条件表达式 Get(p => p.ID == 100 && p.Name == "hhahh2011") 或者使用Spec</param> /// <returns>符合条件的记录集合</returns> protected virtual PageList <TEntity> DMSelectPageList <TEntity>(int pageIndex, int pageSize, Expression <Func <TEntity, bool> > where = null) { return(DMContext.Query <TEntity>().Where(where).ToPageList(pageIndex, pageSize)); }
/// <summary> /// 分页获取记录集合 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> /// <param name="pageIndex">第几页</param> /// <param name="pageSize">每页大小</param> /// <returns>符合条件的记录集合</returns> protected virtual PageList <TEntity> DMSelectPageList <TEntity>(int pageIndex, int pageSize) { return(DMContext.Query <TEntity>().ToPageList(pageIndex, pageSize)); }
/// <summary> /// 获取记录集合 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> /// <param name="top">要查询多少条记录</param> /// <returns>符合条件的记录集合</returns> protected virtual List <TEntity> DMSelectList <TEntity>(int top) { return(DMContext.Query <TEntity>().ToList(top)); }
/// <summary> /// 分页获取记录集合 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> /// <param name="pageIndex">第几页</param> /// <param name="pageSize">每页大小</param> /// <param name="where">条件表达式 Get(p => p.ID == 100 && p.Name == "hhahh2011") 或者使用Spec</param> /// <param name="order">选择排序列表达式 Get(p => new Columns(p.ID.Desc(), p.Name.Asc()))</param> /// <param name="select">选择列表达式 Get(p => new Columns(p.ID, p.Name))</param> /// <returns>符合条件的记录集合</returns> protected virtual PageList <TEntity> DMSelectPageList <TEntity>(int pageIndex, int pageSize, Expression <Func <TEntity, bool> > where = null, Expression <Func <TEntity, Columns> > order = null, Expression <Func <TEntity, Columns> > select = null) { return(DMContext.Query <TEntity>().Where(where).OrderBy(order).Select(select).ToPageList(pageIndex, pageSize)); }
/// <summary> /// 获取记录集合 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> /// <param name="top">要查询多少条记录</param> /// <param name="where">条件表达式 Get(p => p.ID == 100 && p.Name == "hhahh2011") 或者使用Spec</param> /// <param name="order">选择排序列表达式 Get(p => new Columns(p.ID.Desc(), p.Name.Asc()))</param> /// <param name="select">选择列表达式 Get(p => new Columns(p.ID, p.Name))</param> /// <returns>符合条件的记录集合</returns> protected virtual List <TEntity> DMSelectList <TEntity>(int top, Expression <Func <TEntity, bool> > where, Expression <Func <TEntity, Columns> > order, Expression <Func <TEntity, Columns> > select) { return(DMContext.Query <TEntity>().Where(where).OrderBy(order).Select(select).ToList(top)); }
/// <summary> /// 查询 /// </summary> /// <typeparam name="T1">查询参数类型1</typeparam> /// <typeparam name="T2">查询参数类型2</typeparam> /// <typeparam name="T3">查询参数类型3</typeparam> /// <typeparam name="T4">查询参数类型4</typeparam> /// <typeparam name="T5">查询参数类型5</typeparam> /// <typeparam name="TResult">查询结果类型</typeparam> /// <returns>查询器</returns> protected virtual Query <T1, T2, T3, T4, T5, TResult> DMQuery <T1, T2, T3, T4, T5, TResult>() { return(DMContext.Query <T1, T2, T3, T4, T5, TResult>()); }
/// <summary> /// 获取所有记录集合 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> /// <param name="order">选择排序列表达式 Get(p => new Columns(p.ID.Desc(), p.Name.Asc()))</param> protected virtual List <TEntity> DMSelectAll <TEntity>(Expression <Func <TEntity, Columns> > order) { return(DMContext.Query <TEntity>().OrderBy(order).ToList()); }
/// <summary> /// 获取所有记录集合 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> protected virtual List <TEntity> DMSelectAll <TEntity>() { return(DMContext.Query <TEntity>().ToList()); }
/// <summary> /// 获取所有记录集合 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> /// <param name="order">选择排序列表达式 Get(p => new Columns(p.ID.Desc(), p.Name.Asc()))</param> /// <param name="select">选择列表达式 Get(p => new Columns(p.ID, p.Name))</param> /// <param name="connectionString">自定义连接</param> /// <returns>符合条件的记录集合</returns> protected virtual List <TEntity> DMSelectAll <TEntity>(Expression <Func <TEntity, Columns> > order, Expression <Func <TEntity, Columns> > select, string connectionString) { return(DMContext.Query <TEntity>().OrderBy(order).Select(select).SetConnectionString(connectionString).ToList()); }
/// <summary> /// 获取一条记录 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> /// <param name="where">条件表达式 Get(p => p.ID == 100 && p.Name == "hhahh2011") 或者使用Spec</param> /// <returns>一条记录 或者 null</returns> protected virtual TEntity DMSelect <TEntity>(Expression <Func <TEntity, bool> > where) { return(DMContext.Query <TEntity>().Where(where).Single()); }
/// <summary> /// 获取一条记录 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> /// <param name="where">条件表达式 Get(p => p.ID == 100 && p.Name == "hhahh2011") 或者使用Spec</param> /// <param name="select">选择列表达式 Get(p => new Columns(p.ID, p.Name))</param> /// <param name="connectionString">自定义连接</param> /// <returns>一条记录 或者 null</returns> protected virtual TEntity DMSelect <TEntity>(Expression <Func <TEntity, bool> > where, Expression <Func <TEntity, Columns> > select, string connectionString) { return(DMContext.Query <TEntity>().Where(where).Select(select).SetConnectionString(connectionString).Single()); }
public virtual List <TEntity> GetList <TEntity>(int top, Expression <Func <TEntity, bool> > where = null, Expression <Func <TEntity, Columns> > order = null, Expression <Func <TEntity, Columns> > select = null, string connectionString = null) { return(DMContext.Query <TEntity>().Where(where).OrderBy(order).Select(select).SetConnectionString(connectionString).ToList(top)); }
/// <summary> /// 获取记录集合 /// </summary> /// <typeparam name="TEntity">实体类型</typeparam> /// <param name="top">要查询多少条记录</param> /// <param name="where">条件表达式 Get(p => p.ID == 100 && p.Name == "hhahh2011") 或者使用Spec</param> /// <returns>符合条件的记录集合</returns> protected virtual List <TEntity> DMSelectList <TEntity>(int top, Expression <Func <TEntity, bool> > where) { return(DMContext.Query <TEntity>().Where(where).ToList(top)); }
public virtual PageList <TEntity> GetPageList <TEntity>(int pageIndex, int pageSize, Expression <Func <TEntity, bool> > where = null, Expression <Func <TEntity, Columns> > order = null, Expression <Func <TEntity, Columns> > select = null, string connectionString = null) { return(DMContext.Query <TEntity>().Where(where).OrderBy(order).Select(select).SetConnectionString(connectionString).ToPageList(pageIndex, pageSize)); }
/// <summary> /// 查询 /// </summary> /// <typeparam name="T">查询参数类型</typeparam> /// <returns>查询器</returns> protected virtual Query <T> DMQuery <T>() { return(DMContext.Query <T>()); }