/// <summary> /// 获取实体列表数据 /// </summary> /// <param name="sql">SQL 对象</param> /// <returns></returns> public IEnumerable <TDto> GetList <TDto>(Sql sql) { UnitOfWork.GetOpenConnection(); var results = UnitOfWork.DbConnection.Query <TDto>( sql.SQL, GetParams(sql.Arguments)); return(results); }
/// <summary> /// 获取实体列表数据 /// </summary> /// <param name="sql">SQL 对象</param> /// <returns></returns> public IList <TDto> GetList <TDto>( Sql sql) { UnitOfWork.GetOpenConnection(); var results = UnitOfWork.DbConnection.Query <TDto>( sql.SQL, GetParams(sql.Arguments), UnitOfWork.DbTransaction); return(results.ToList()); }
/// <summary> /// 执行SQL 并获取结果值 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="sql">SQL</param> public T Query <T>(Sql sql) { UnitOfWork.GetOpenConnection(); return(UnitOfWork.DbConnection.Query <T>( sql.SQL, GetParams(sql.Arguments), UnitOfWork.DbTransaction, true, null, CommandType.Text).FirstOrDefault()); }