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