/// <summary> /// 查询数据列表 /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="search"></param> /// <returns></returns> public IEnumerable <TEntity> Query <TEntity>(SearchSqlBuilder search) { //return default(TEntity); var _sqlTmpl = search.Build <TEntity>(this.DataContext); return(DataContext.Query <TEntity>(_sqlTmpl)); }
/// <summary> /// 分页查询列表 /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="search">查询条件中必须指定Order字段</param> /// <returns></returns> public Page <TEntity> QueryPage <TEntity>(SearchSqlBuilder search) { var _sqlTmpl = search.Build <TEntity>(this.DataContext); if (search.Pageing == null) { search.Pageing = search.DefaultPageInfo; } return(DataContext.Page <TEntity>(search.Pageing.PageIndex, search.Pageing.PageSize, _sqlTmpl)); }
/// <summary> /// 通过指定条件获取单一实体 /// 多于一条则报错,不确定有且仅有一条时请使用 First /// </summary> /// <typeparam name="TEntity"></typeparam> /// <param name="search">查询条件</param> /// <returns></returns> public TEntity Single <TEntity>(SearchSqlBuilder search) { var _sqlTmpl = search.Build <TEntity>(this.DataContext); return(DataContext.SingleOrDefault <TEntity>(_sqlTmpl)); }