| | |
| | | </layout> |
| | | </appender> |
| | | |
| | | <!--将日记写入数据库--> |
| | | <!--此处将操作记录写入数据库,日志同理--> |
| | | <appender name="AdoNetAppender" type="log4net.Appender.AdoNetAppender"> |
| | | <bufferSize value="-1" /> |
| | | <connectionType value="System.Data.SqlClient.SqlConnection, System.Data, Version=1.0.3300.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" /> |
| | | <connectionString value="data source=121.196.36.24,1533;initial catalog=vmes;persist security info=True;user id=sa;password=xkd@20230101;MultipleActiveResultSets=True;" /> |
| | | <commandText value="INSERT INTO T_Log ([Date],[Thread],[Level],[Logger],[Message],[Exception]) VALUES (@log_date, @thread, @log_level, @logger, @message, @exception)" /> |
| | | <commandText value="insert into T_Take ([op_type],[op_content],[actionclick],[ippath],[lm_user],[lm_date]) |
| | | values (@op_type, @op_content, @actionclick, @ippath, @lm_user, @lm_date)" /> |
| | | <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" /> |
| | | <parameterName value="@op_type" /> |
| | | <dbType value="String" /> |
| | | <size value="50" /> |
| | | <layout type="log4net.Layout.PatternLayout"> |
| | | <conversionPattern value="%level" /> |
| | | <layout type="VueWebApi.Log4net.ActionLayoutPattern"> |
| | | <conversionPattern value="%actionInfo{op_type}"/> |
| | | </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" /> |
| | | <parameterName value="@op_content" /> |
| | | <dbType value="String" /> |
| | | <size value="4000" /> |
| | | <layout type="log4net.Layout.PatternLayout"> |
| | | <conversionPattern value="%message" /> |
| | | <layout type="VueWebApi.Log4net.ActionLayoutPattern"> |
| | | <conversionPattern value="%actionInfo{op_content}"/> |
| | | </layout> |
| | | </parameter> |
| | | <parameter> |
| | | <parameterName value="@exception" /> |
| | | <parameterName value="@actionclick" /> |
| | | <dbType value="String" /> |
| | | <size value="2000" /> |
| | | <layout type="log4net.Layout.ExceptionLayout" /> |
| | | <size value="100" /> |
| | | <layout type="VueWebApi.Log4net.ActionLayoutPattern"> |
| | | <conversionPattern value="%actionInfo{actionclick}"/> |
| | | </layout> |
| | | </parameter> |
| | | <parameter> |
| | | <parameterName value="@ippath" /> |
| | | <dbType value="String" /> |
| | | <size value="100" /> |
| | | <layout type="VueWebApi.Log4net.ActionLayoutPattern"> |
| | | <conversionPattern value="%actionInfo{ippath}"/> |
| | | </layout> |
| | | </parameter> |
| | | <parameter> |
| | | <parameterName value="@lm_user" /> |
| | | <dbType value="String" /> |
| | | <size value="50" /> |
| | | <layout type="VueWebApi.Log4net.ActionLayoutPattern"> |
| | | <conversionPattern value="%actionInfo{lm_user}"/> |
| | | </layout> |
| | | </parameter> |
| | | <parameter> |
| | | <parameterName value="@lm_date" /> |
| | | <dbType value="DateTime" /> |
| | | <layout type="log4net.Layout.RawTimeStampLayout" /> |
| | | </parameter> |
| | | </appender> |
| | | |