VueWebApi/obj/Release/Package/PackageTmp/log4net.config
@@ -8,11 +8,11 @@
   <log4net>
      <!--写入到文件-->
      <appender name="LogFileAppender" type="log4net.Appender.RollingFileAppender,log4net">
      <!--<appender name="LogFileAppender" type="log4net.Appender.RollingFileAppender,log4net">
         <!--文件路径,如果RollingStyle为Composite或Date,则这里设置为目录,文件名在DatePattern里设置,其他则这里要有文件名。已经扩展支持虚拟目录-->
         --><!--文件路径,如果RollingStyle为Composite或Date,则这里设置为目录,文件名在DatePattern里设置,其他则这里要有文件名。已经扩展支持虚拟目录--><!--
         <param name="File" value="Logs\" />
         <!--将日记写入到跟目录下面的Logs文件夹下面的yyyy-MM-dd.TXT文件中-->
         --><!--将日记写入到跟目录下面的Logs文件夹下面的yyyy-MM-dd.TXT文件中--><!--
         <param name="AppendToFile" value="true" />
@@ -25,66 +25,69 @@
         <param name="RollingStyle" value="Date" />
         <param name="DatePattern" value="yyyy-MM-dd.TXT" />
         <!--TXT后缀必须是大写的,否则有问题-->
         --><!--TXT后缀必须是大写的,否则有问题--><!--
         <param name="CountDirection" value="-1" />
         <!--log4net记录错误的格式(即:用什么样的格式(布局)来记录错误)-->
         --><!--log4net记录错误的格式(即:用什么样的格式(布局)来记录错误)--><!--
         <layout type="log4net.Layout.PatternLayout">
            <param name="ConversionPattern" value=" 【时间】:%d%n 【级别】:%p%n 【类名】:%c%n 【线程ID】: %thread %n 【文件地址】:%F 第%L行%n 【日志内容】:%m%n 【日记详细】:%exception %n---------------------------------------------------------------------------------------------------------------%n" />
         </layout>
      </appender>
      </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>