<?xml version="1.0"?>
|
<configuration>
|
<configSections>
|
<!--<section name="log4net" type="System.Configuration.IgnoreSectionHandler"/>-->
|
<section name="log4net" type="log4net.Config.Log4NetConfigurationSectionHandler, log4net"/>
|
</configSections>
|
<log4net>
|
<!--定义输出到文件中-->
|
<appender name="LogFileAppender" type="log4net.Appender.FileAppender">
|
<!--定义文件存放位置-->
|
<file value="D:\\log4netfileWebService.txt" />
|
<appendToFile value="true" />
|
<rollingStyle value="Date" />
|
<datePattern value="yyyyMMdd-HH:mm:ss" />
|
<layout type="log4net.Layout.PatternLayout">
|
<!--每条日志末尾的文字说明-->
|
<footer value="by Liuxp" />
|
<!--输出格式-->
|
<!--样例:2008-03-26 13:42:32,111 [10] INFO Log4NetDemo.MainClass [(null)] - info-->
|
<conversionPattern value="记录时间:%date 线程ID:[%thread] 日志级别:%-5level 出错类:%logger property:[%property{NDC}] - 错误描述:%message%newline" />
|
</layout>
|
</appender>
|
<!--定义输出到控制台命令行中-->
|
<appender name="ConsoleAppender" type="log4net.Appender.ConsoleAppender">
|
<layout type="log4net.Layout.PatternLayout">
|
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
|
</layout>
|
</appender>
|
<!--定义输出到windows事件中-->
|
<appender name="EventLogAppender" type="log4net.Appender.EventLogAppender">
|
<layout type="log4net.Layout.PatternLayout">
|
<conversionPattern value="%date [%thread] %-5level %logger [%property{NDC}] - %message%newline" />
|
</layout>
|
</appender>
|
<appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender">
|
<!--BufferSize为缓冲区大小,只有日志记录超1条才会一块写入到数据库-->
|
<bufferSize value="1" />
|
<connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" />
|
<!--连接数据库字符串-->
|
<connectionString value="Data Source=192.168.1.99\CYSQL;Initial Catalog=PrintEC;Persist Security Info=True;User ID=sa;Password=cysql2008" />
|
<!--插入到表Log-->
|
<commandText value="INSERT INTO Log ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" />
|
<!--日志记录时间,RawTimeStampLayout为默认的时间输出格式 -->
|
<parameter>
|
<parameterName value="@log_date" />
|
<dbType value="DateTime" />
|
<layout type="log4net.Layout.RawTimeStampLayout" />
|
</parameter>
|
<parameter>
|
<parameterName value="@thread" />
|
<dbType value="String" />
|
<size value="255" />
|
<layout type="log4net.Layout.PatternLayout">
|
<conversionPattern value="%thread" />
|
</layout>
|
</parameter>
|
<parameter>
|
<parameterName value="@log_level" />
|
<dbType value="String" />
|
<size value="50" />
|
<layout type="log4net.Layout.PatternLayout">
|
<conversionPattern value="%level" />
|
</layout>
|
</parameter>
|
<parameter>
|
<parameterName value="@logger" />
|
<dbType value="String" />
|
<size value="255" />
|
<layout type="log4net.Layout.PatternLayout">
|
<conversionPattern value="%logger" />
|
</layout>
|
</parameter>
|
<parameter>
|
<parameterName value="@message" />
|
<dbType value="String" />
|
<size value="4000" />
|
<layout type="log4net.Layout.PatternLayout">
|
<conversionPattern value="%message" />
|
</layout>
|
</parameter>
|
<parameter>
|
<parameterName value="@exception" />
|
<dbType value="String" />
|
<size value="2000" />
|
<layout type="log4net.Layout.ExceptionLayout" />
|
</parameter>
|
</appender>
|
<!--定义日志的输出媒介,下面定义日志以四种方式输出。也可以下面的按照一种类型或其他类型输出。-->
|
<root>
|
<level value="ALL" />
|
<appender-ref ref="AdoNetAppender" />
|
</root>
|
|
</log4net>
|
<connectionStrings>
|
<!--<add name="SqlConnection" connectionString="Data Source=192.168.1.99\CYSQL;Initial Catalog=PrintECTest;User ID=sa;Password=cysql2008" providerName="System.Data.SqlClient" />-->
|
<add name="SqlConnection" connectionString="Data Source=.;Initial Catalog=ECTest;User ID=sa;Password=123456" providerName="System.Data.SqlClient" />
|
</connectionStrings>
|
<appSettings>
|
<!--间隔时间-->
|
<add key="Interval" value="10000"/>
|
<add key="LoggerName" value="AdoNetAppender"/>
|
<add key="NumberOfResultsPerPage" value=""/>
|
<add key="QueryTimeOut" value="10000"/>
|
<add key="DALPath" value="CY.SQLDAL"/>
|
<add key="RootConfigPath" value=""/>
|
<add key="LoginURL" value=""/>
|
<add key="OrderOverDays" value="3"/>
|
<add key="RecruitmentsOverDays" value="7"/>
|
</appSettings>
|
</configuration>
|