public static DataTable ExecuteTable(DbConnection connection, CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { try { DbCommand cmd = Provider.CreateCommand(); PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters); DbDataAdapter ap = Provider.CreateDataAdapter(); ap.SelectCommand = cmd; DataSet st = new DataSet(); ap.Fill(st, "Result"); cmd.Parameters.Clear(); return(st.Tables["Result"]); } catch (Exception ex) { if (connection != null && !string.IsNullOrEmpty(connection.ConnectionString)) { string conStr = connection == null ? "dbConnection为空" : string.IsNullOrEmpty(connection.ConnectionString) == true ? "ConnectionString为空" : connection.ConnectionString; string errorMsg = string.Format("{0};{1};{2};{3};{4};{5}", cmdText, commandParameters.GetParamKeyValues(), connection == null ? conStr : conStr.Substring(0, Regex.Matches(conStr, ";")[1].Index), ex.Message, ex.Source, ex.StackTrace); Logger.Fatal(errorMsg, ex); DBLog.Process("", "", ClientHelper.GetClientIP(), "", "", "sql_exception", errorMsg); } throw ex; } }
public static int ExecuteNonQuery(DbTransaction trans, CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { try { DbCommand cmd = Provider.CreateCommand(); PrepareCommand(cmd, trans.Connection, trans, cmdType, cmdText, commandParameters); int val = cmd.ExecuteNonQuery(); if (cmdType == CommandType.StoredProcedure) { val = (int)cmd.Parameters[cmd.Parameters.Count - 1].Value; } cmd.Parameters.Clear(); return(val); } catch (Exception ex) { IDbConnection connection = trans.Connection; if (connection != null && !string.IsNullOrEmpty(connection.ConnectionString)) { string conStr = connection == null ? "dbConnection为空" : string.IsNullOrEmpty(connection.ConnectionString) == true ? "ConnectionString为空" : connection.ConnectionString; string errorMsg = string.Format("{0};{1};{2};{3};{4};{5}", cmdText, commandParameters.GetParamKeyValues(), connection == null ? conStr : conStr.Substring(0, Regex.Matches(conStr, ";")[1].Index), ex.Message, ex.Source, ex.StackTrace); Logger.Fatal(errorMsg, ex); DBLog.Process("", "", ClientHelper.GetClientIP(), "", "", "sql_exception", errorMsg); } throw ex; } }
public static DataSet ExecuteDataset(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters) { try { SqlCommand command = new SqlCommand(); PrepareCommand(command, connection, null, commandType, commandText, commandParameters); SqlDataAdapter adapter = new SqlDataAdapter(command); DataSet dataSet = new DataSet(); adapter.Fill(dataSet); command.Parameters.Clear(); return(dataSet); } catch (Exception ex) { if (connection != null && !string.IsNullOrEmpty(connection.ConnectionString)) { string conStr = connection == null ? "dbConnection为空" : string.IsNullOrEmpty(connection.ConnectionString) == true ? "ConnectionString为空" : connection.ConnectionString; string errorMsg = string.Format("{0};{1};{2};{3};{4};{5}", commandText, commandParameters.GetParamKeyValues(), connection == null ? conStr : conStr.Substring(0, Regex.Matches(conStr, ";")[1].Index), ex.Message, ex.Source, ex.StackTrace); Logger.Fatal(errorMsg, ex); DBLog.Process("", "", ClientHelper.GetClientIP(), "", "", "sql_exception", errorMsg); } throw ex; } }
public static object ExecuteScalar(string connectionString, CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { DbCommand cmd = Provider.CreateCommand(); try { using (DbConnection connection = Provider.CreateConnection()) { connection.ConnectionString = connectionString; PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters); return(cmd.ExecuteScalar()); } } catch (Exception ex) { if (!string.IsNullOrEmpty(connectionString)) { string conStr = connectionString; string errorMsg = string.Format("{0};{1};{2};{3};{4};{5}", cmdText, commandParameters.GetParamKeyValues(), conStr.Substring(0, Regex.Matches(conStr, ";")[1].Index), ex.Message, ex.Source, ex.StackTrace); Logger.Fatal(errorMsg, ex); DBLog.Process("", "", ClientHelper.GetClientIP(), "", "", "sql_exception", errorMsg); } throw ex; } finally { if (cmd != null && cmd.Parameters != null) { cmd.Parameters.Clear(); } } }
internal void ProcessWatchedEvent(WatchedEvent @event) { try { if (@event.Type == EventType.NodeChildrenChanged || @event.Type == EventType.NodeDataChanged || @event.Type == EventType.NodeDeleted) { DBLog.SyncLogServerEvent.Reset(); DBLog.InitThriftServer(); DBLog.SyncLogServerEvent.Set(); } zk.GetChildren(ZKServerInfo.ZKLogCenterRootPath, true); } catch (Exception ex) { m_localLog.Error("ProcessWatchedEvent失败", ex); } }
public static DbDataReader ExecuteReader(DbConnection connection, CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { try { DbCommand cmd = Provider.CreateCommand(); PrepareCommand(cmd, connection, null, cmdType, cmdText, commandParameters); DbDataReader rdr = cmd.ExecuteReader(CommandBehavior.CloseConnection); cmd.Parameters.Clear(); return(rdr); } catch (Exception ex) { if (connection != null && !string.IsNullOrEmpty(connection.ConnectionString)) { string conStr = connection == null ? "dbConnection为空" : string.IsNullOrEmpty(connection.ConnectionString) == true ? "ConnectionString为空" : connection.ConnectionString; string errorMsg = string.Format("{0};{1};{2};{3};{4};{5}", cmdText, commandParameters.GetParamKeyValues(), connection == null ? conStr : conStr.Substring(0, Regex.Matches(conStr, ";")[1].Index), ex.Message, ex.Source, ex.StackTrace); Logger.Fatal(errorMsg, ex); DBLog.Process("", "", ClientHelper.GetClientIP(), "", "", "sql_exception", errorMsg); } throw ex; } }
public static int ExecuteNonQuery(string connectionString, CommandType cmdType, string cmdText, params DbParameter[] commandParameters) { try { DbCommand cmd = Provider.CreateCommand(); using (DbConnection conn = Provider.CreateConnection()) { conn.ConnectionString = connectionString; return(ExecuteNonQuery(conn, cmdType, cmdText, commandParameters)); } } catch (Exception ex) { if (!string.IsNullOrEmpty(connectionString)) { string conStr = connectionString; string errorMsg = string.Format("{0};{1};{2};{3};{4};{5}", cmdText, commandParameters.GetParamKeyValues(), conStr.Substring(0, Regex.Matches(conStr, ";")[1].Index), ex.Message, ex.Source, ex.StackTrace); Logger.Fatal(errorMsg, ex); DBLog.Process("", "", ClientHelper.GetClientIP(), "", "", "sql_exception", errorMsg); } throw ex; } }