yl
2024-03-29 9c634fd767aec36ef97c3a814bf7a29c67d20ee1
VueWebApi/obj/Release/Package/PackageTmp/log4net.config
@@ -37,54 +37,57 @@
         </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>