public Task <T> GetValueAsync <T>(ISqlParam sqlParam, T defValue = default(T))
{
return(SpeedTest("GetValueAsync", sqlParam.Name, CommandType.Text, sqlParam.Sql.ToString(), sqlParam.Param, async() => await _dbExecutor.GetValueAsync(sqlParam, defValue)));
}
/// <summary>
/// 返回返回泛型集合
/// </summary>
/// <param name="sqlParam">SQL语句与参数</param>
public List <TEntity> ToList <TEntity>(ISqlParam sqlParam) where TEntity : class, new()
{
var param = sqlParam.Param?.ToArray();
return(SqlExtend.ToList <TEntity>(DataBase.GetReader(CommandType.Text, sqlParam.Sql.ToString(), param)));
}
public Task <DataTable> ToTableAsync(ISqlParam sqlParam) => SpeedTest(sqlParam, async() => await _dbExecutor.ToTableAsync(sqlParam));
TEntity IExecuteSql.ToEntity <TEntity>(ISqlParam sqlParam) => SpeedTest(sqlParam, () => _dbExecutor.ToEntity <TEntity>(sqlParam));
/// <summary> 写入日志 </summary>
private void WriteException(Exception ex, ISqlParam sqlParam)
{
new SqlErrorLog(ex, sqlParam.Name, CommandType.Text, sqlParam.Sql.ToString(), sqlParam.Param ?? new List <DbParameter>()).Write();
}
public Task <int> ExecuteAsync(ISqlParam sqlParam) => SpeedTest(sqlParam, async() => await _dbExecutor.ExecuteAsync(sqlParam));
public Task <TEntity> ToEntityAsync <TEntity>(ISqlParam sqlParam) where TEntity : class, new()
{
return(SpeedTest("ToEntityAsync", sqlParam.Name, CommandType.Text, sqlParam.Sql.ToString(), sqlParam.Param, async() => await _dbExecutor.ToEntityAsync <TEntity>(sqlParam)));
}
/// <summary>
/// 返回影响行数
/// </summary>
/// <param name="sqlParam">SQL语句与参数</param>
public int Execute(ISqlParam sqlParam)
{
var param = sqlParam.Param?.ToArray();
return(sqlParam.Sql.Length < 1 ? 0 : DataBase.ExecuteNonQuery(CommandType.Text, sqlParam.Sql.ToString(), param));
}
public List <TEntity> ToList <TEntity>(ISqlParam sqlParam) where TEntity : class, new()
{
return(SpeedTest("ToList", sqlParam.Name, CommandType.Text, sqlParam.Sql.ToString(), sqlParam.Param, () => _dbExecutor.ToList <TEntity>(sqlParam)));
}
TEntity IExecuteSql.ToEntity <TEntity>(ISqlParam sqlParam)
{
return(SpeedTest("ToEntity", sqlParam.Name, CommandType.Text, sqlParam.Sql.ToString(), sqlParam.Param, () => _dbExecutor.ToEntity <TEntity>(sqlParam)));
}
public Task <DataTable> ToTableAsync(ISqlParam sqlParam)
{
return(SpeedTest("ToTableAsync", sqlParam.Name, CommandType.Text, sqlParam.Sql.ToString(), sqlParam.Param, async() => await _dbExecutor.ToTableAsync(sqlParam)));
}
public DataTable ToTable(ISqlParam sqlParam)
{
return(SpeedTest("ToTable", sqlParam.Name, CommandType.Text, sqlParam.Sql.ToString(), sqlParam.Param, () => _dbExecutor.ToTable(sqlParam)));
}
public int Execute(ISqlParam sqlParam)
{
return(SpeedTest("Execute", sqlParam.Name, CommandType.Text, sqlParam.Sql.ToString(), sqlParam.Param, () => _dbExecutor.Execute(sqlParam)));
}
/// <summary>
/// 返回返回泛型集合
/// </summary>
/// <param name="sqlParam">SQL语句与参数</param>
public async Task <List <TEntity> > ToListAsync <TEntity>(ISqlParam sqlParam) where TEntity : class, new()
{
var param = sqlParam.Param?.ToArray();
return(SqlExtend.ToList <TEntity>(await DataBase.GetReaderAsync(CommandType.Text, sqlParam.Sql.ToString(), param)));
}
public override int Execute(ISqlParam sqlParam)
{
return(SpeedTest(sqlParam.Name, sqlParam.Sql.ToString(), sqlParam.Param, () => base.Execute(sqlParam)));
}
/// <summary>
/// 返回影响行数
/// </summary>
/// <param name="sqlParam">SQL语句与参数</param>
public async Task <int> ExecuteAsync(ISqlParam sqlParam)
{
var param = sqlParam.Param?.ToArray();
return(sqlParam.Sql.Length < 1 ? 0 : await DataBase.ExecuteNonQueryAsync(CommandType.Text, sqlParam.Sql.ToString(), param));
}
public override DataTable ToTable(ISqlParam sqlParam)
{
return(SpeedTest(sqlParam.Name, sqlParam.Sql.ToString(), sqlParam.Param, () => base.ToTable(sqlParam)));
}
/// <summary>
/// 返回DataTable
/// </summary>
/// <param name="sqlParam">SQL语句与参数</param>
public DataTable ToTable(ISqlParam sqlParam)
{
var param = sqlParam.Param?.ToArray();
return(DataBase.GetDataTable(CommandType.Text, sqlParam.Sql.ToString(), param));
}
public override TEntity ToEntity <TEntity>(ISqlParam sqlParam)
{
return(SpeedTest(sqlParam.Name, sqlParam.Sql.ToString(), sqlParam.Param, () => base.ToEntity <TEntity>(sqlParam)));
}
public int Execute(ISqlParam sqlParam) => SpeedTest(sqlParam, () => _dbExecutor.Execute(sqlParam));
public override T GetValue <T>(ISqlParam sqlParam, T defValue = default(T))
{
return(SpeedTest(sqlParam.Name, sqlParam.Sql.ToString(), sqlParam.Param, () => base.GetValue(sqlParam, defValue)));
}
public DataTable ToTable(ISqlParam sqlParam) => SpeedTest(sqlParam, () => _dbExecutor.ToTable(sqlParam));
public T GetValue <T>(ISqlParam sqlParam, T defValue = default(T)) => SpeedTest(sqlParam, () => _dbExecutor.GetValue(sqlParam, defValue));
public List <TEntity> ToList <TEntity>(ISqlParam sqlParam) where TEntity : class, new() => SpeedTest(sqlParam, () => _dbExecutor.ToList <TEntity>(sqlParam));
/// <summary>
/// 返回DataTable
/// </summary>
/// <param name="sqlParam">SQL语句与参数</param>
public async Task <DataTable> ToTableAsync(ISqlParam sqlParam)
{
var param = sqlParam.Param?.ToArray();
return(await DataBase.GetDataTableAsync(CommandType.Text, sqlParam.Sql.ToString(), param));
}
public Task <TEntity> ToEntityAsync <TEntity>(ISqlParam sqlParam) where TEntity : class, new() => SpeedTest(sqlParam, async() => await _dbExecutor.ToEntityAsync <TEntity>(sqlParam));
public T GetValue <T>(ISqlParam sqlParam, T defValue = default(T))
{
return(SpeedTest("GetValue", sqlParam.Name, CommandType.Text, sqlParam.Sql.ToString(), sqlParam.Param, () => _dbExecutor.GetValue(sqlParam, defValue)));
}
