public static int ExecuteNonQuery(DatabaseEnum database, CommandType cmdType, string cmdText, params DbParameter[] commandParameters)
{
DbCommand cmd = Provider.CreateCommand();
using (DbConnection conn = Provider.CreateConnection())
{
conn.ConnectionString = ConnectionStringFactory.CreateConnectionString(database);
return(ExecuteNonQuery(conn, cmdType, cmdText, commandParameters));
}
}
public static object ExecuteDataObject(DatabaseEnum databaseName, CommandType commandType, string commandText, params SqlParameter[] parms)
{
DataSet ds = ExecuteDataset(ConnectionStringFactory.CreateConnectionString(databaseName), commandType, commandText, parms);
if (ds != null &&
ds.Tables[0] != null)
{
return(ds.Tables[0].Rows[0][0]);
}
return("");
}
public static DataSet ExecuteDataset(DatabaseEnum databaseName, string spName, params object[] parameterValues)
{
string connectionString = ConnectionStringFactory.CreateConnectionString(databaseName);
if ((parameterValues != null) && (parameterValues.Length > 0))
{
return(ExecuteDataset(connectionString, CommandType.StoredProcedure, spName, (SqlParameter[])parameterValues));
}
else
{
return(ExecuteDataset(connectionString, CommandType.StoredProcedure, spName));
}
}
public static DataTable QueryLogDB(string sql)
{
try
{
DataSet dataset = new DataSet();
SqlConnection conn = new SqlConnection(ConnectionStringFactory.CreateConnectionString(DatabaseEnum.Log4Net_CMD));
SqlCommand command = conn.CreateCommand();
command.CommandText = sql;
SqlDataAdapter adapter = new SqlDataAdapter(command);
adapter.Fill(dataset);
return(dataset.Tables[0]);
}
catch
{
return(null);
}
}
private int InsertInternal(DataTable table, bool isHandle)
{
int count = 0;
string tableName = "";
try
{
using (SqlBulkCopy bult =
new SqlBulkCopy(ConnectionStringFactory.CreateConnectionString(DatabaseEnum.Log4Net_CMD))
{
BatchSize = 800
})
{
tableName = "dbo.tbl_Interface_ProcessLog";
if (isHandle)
{
tableName = "dbo.tbl_Interface_HandleLog";
}
tableName = string.Format("{0}{1}", tableName, GetLogTableSuffix());
bult.ColumnMappings.Add("IKey", "ikey");
bult.ColumnMappings.Add("Username", "username");
bult.ColumnMappings.Add("LogTime", "logtime");
bult.ColumnMappings.Add("ClientIP", "clientip");
bult.ColumnMappings.Add("Module", "module");
bult.ColumnMappings.Add("OrderNo", "orderno");
bult.ColumnMappings.Add("LogType", "logtype");
bult.ColumnMappings.Add("Content", "content");
bult.ColumnMappings.Add("ServerIP", "ServerIP");
bult.ColumnMappings.Add("Keyword", "KeyWord");
bult.DestinationTableName = tableName;
bult.WriteToServer(table);
count = table.Rows.Count;
Logger.Info(string.Format("批量成功往{0}-{1}表插入{2}条数据", tableName, table.TableName, count));
}
}
catch (Exception ex)
{
count = 0;
Logger.Error(ex.ToString());
}
return(count);
}
public static DataSet ExecuteDataset(DatabaseEnum databaseName, CommandType commandType, string commandText, params SqlParameter[] parames)
{
return(ExecuteDataset(ConnectionStringFactory.CreateConnectionString(databaseName), commandType, commandText, parames));
}
public static DataTable ExecuteTable(DatabaseEnum database, CommandType cmdType, string cmdText, params DbParameter[] commandParameters)
{
return(ExecuteTable(ConnectionStringFactory.CreateConnectionString(database), cmdType, cmdText, commandParameters));
}
