/// <summary>
/// 执行语句
/// </summary>
/// <param name="ado">数据库访问对象</param>
/// <param name="cmdType">命令类型</param>
/// <param name="cmdText">命令</param>
/// <param name="models">模型</param>
/// <returns></returns>
public async static Task <int> ExecuteNonQueryWithModelsAsync(this IAdo ado, System.Data.CommandType cmdType, string cmdText, params object[] models)
{
var parameters = models.GetParametersFromModels();
var result = await ado.ExecuteNonQueryAsync(cmdType, cmdText, parameters.AllParameters);
models.SetOutputParametersValueToModels(parameters.OutputParameters);
return(result);
}
/// <summary>
/// 执行语句
/// </summary>
/// <param name="ado">数据库访问对象</param>
/// <param name="cmdType">命令类型</param>
/// <param name="cmdText">命令</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public async static Task <int> ExecuteNonQueryAsync(this IAdo ado, System.Data.CommandType cmdType, string cmdText, params DbParameter[] parameters)
{
return(await ado.ExecuteNonQueryAsync(cmdType, cmdText, parameters));
}
/// <summary>
/// 执行存储过程
/// </summary>
/// <param name="ado">数据库访问对象</param>
/// <param name="name">存储过程名称</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public async static Task <int> ExecuteStoredProcedureAsync(this IAdo ado, string name, params DbParameter[] parameters)
{
return(await ado.ExecuteNonQueryAsync(System.Data.CommandType.StoredProcedure, name, parameters));
}
/// <summary>
/// 执行语句
/// </summary>
/// <param name="ado">数据库访问对象</param>
/// <param name="name">存储过程名称</param>
/// <param name="parameters">参数</param>
/// <returns></returns>
public static int ExecuteNonQuery(this IAdo ado, string name, params DbParameter[] parameters)
{
return(ado.ExecuteNonQueryAsync(name, parameters).GetAwaiter().GetResult());
}
