public static int ExecuteNonQuery(SqlTransaction trans, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters) { try { SqlCommand cmd = new SqlCommand(); PrepareCommand(cmd, trans.Connection, trans, cmdType, cmdText, commandParameters); int val = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return(val); } catch (Exception ex) { MessageLog.AddErrorLogDbSql("DbHelperSql", "ExecuteNonQuery:" + ex.Message); return(-1); } }
public static int ExecuteScalar(SqlConnection connection, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters) { try { SqlCommand cmd = new SqlCommand(); PrepareCommand(cmd, connection, cmdType, cmdText, commandParameters); object obj = cmd.ExecuteScalar(); cmd.Parameters.Clear(); return(ObjectToInt32(obj)); } catch (Exception ex) { MessageLog.AddErrorLogDbSql("DbHelperSql", "ExecuteScalar:" + ex.Message); return(-1); } }
private static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params SqlParameter[] commandParameters) { try { SqlCommand cmd = new SqlCommand(); cmd.CommandTimeout = 60; using (SqlConnection connection = new SqlConnection(connectionString)) { PrepareCommand(cmd, connection, cmdType, cmdText, commandParameters); int num = cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); return(num); } } catch (Exception ex) { MessageLog.AddErrorLogDbSql("DbHelperSql", "ExecuteNonQuery:" + ex.Message); return(-1); } }