/// <summary>
/// 执行 SQL 语句，并返回受影响的行数。
/// </summary>
/// <param name="cmdType">执行命令的类型（存储过程或T-SQL，等等）</param>
/// <param name="cmdText">存储过程名称或者T-SQL命令行</param>
/// <param name="parameters">执行命令所需的sql语句对应参数</param>
/// <returns></returns>
public static async Task <int> ExecuteNonQuery(CommandType cmdType, string cmdText, params DbParameter[] parameters)
{
int num = 0;
try
{
DbCommand cmd = DbFactory.CreateDbCommand();
using (DbConnection conn = DbFactory.CreateDbConnection(ConnectionString))
{
await PrepareCommand(cmd, conn, null, cmdType, cmdText, parameters);
num = await cmd.ExecuteNonQueryAsync();
cmd.Parameters.Clear();
}
}
catch (Exception ex)
{
num = -1;
}
return(num);
}
/// <summary>
/// 执行 SQL 语句，并返回受影响的行数。
/// </summary>
/// <param name="cmdType">执行命令的类型（存储过程或T-SQL，等等）</param>
/// <param name="cmdText">存储过程名称或者T-SQL命令行</param>
/// <param name="parameters">执行命令所需的sql语句对应参数</param>
/// <returns></returns>
public static int ExecuteNonQuery(CommandType cmdType, string cmdText, params DbParameter[] parameters)
{
int num = 0;
try
{
DbCommand cmd = DbFactory.CreateDbCommand();
using (DbConnection conn = DbFactory.CreateDbConnection(ConnectionString))
{
PrepareCommand(cmd, conn, null, cmdType, cmdText, parameters);
num = cmd.ExecuteNonQuery();
cmd.Parameters.Clear();
//log.Debug(cmdText);
}
}
catch (Exception ex)
{
num = -1;
//log.Error(ex.Message);
}
return(num);
}
