public void Test()
{
{
UserActionOptLogConfig config = UserActionOptLogConfig.GetUserActionOptLogConfig();
config.ConnectionType = "System.Data.SqlClient.SqlConnection, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089";
config.ConnectionString = "Data Source=.;Initial Catalog=SWERP_ORDER;User ID=sa;Password=sa@2008;";
config.CommandText = @"INSERT INTO [SWERP_ORDERSYS_ERRORLOG]([Date],[Thread],[Level],[Logger],[Message],[Exception])
VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)";
config.Parameters.Add("@log_date", "log_date");
config.Parameters.Add("@thread", "thread");
config.Parameters.Add("@log_level", "log_level");
config.Parameters.Add("@logger", "logger");
config.Parameters.Add("@message", "message");
config.Parameters.Add("@exception", "exception");
config.Parameters.Add(new UserActionOptLogParameterElement("Parametertest3", "Parametervalue4")
{
ParameterType = typeof(DateTime).FullName, Format = "yyyy-mm-dd hh:MM:ss"
});
config.Save();
}
{
var config = UserActionOptLogConfig.GetUserActionOptLogConfig();
Console.WriteLine($"连接类型： {config.ConnectionType}");
Console.WriteLine($"连接配置字符串： {config.ConnectionString}");
Console.WriteLine($"执行SQL： {config.CommandText}");
foreach (UserActionOptLogParameterElement item in config.Parameters)
{
Console.WriteLine($"参数名：{item.ParameterName}；参数类型：{item.ParameterType}；参数值：{item.ParameterValue}；格式：{item.Format}");
}
}
}
public static UserActionOptLogConfig GetUserActionOptLogConfig()
{
Configuration config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
object obj = config.Sections[sectionName];
UserActionOptLogConfig section = null;
if (obj == null)
{
section = new UserActionOptLogConfig(config);
config.Sections.Add(sectionName, section);
}
else
{
section = obj as UserActionOptLogConfig;
}
return(section);
}