/// <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());
}
