fabu

zs

2024-11-14 1aeba205ca41da0f9c31bb7c0e3c0d8534f69e61

fabu

 .vs/DataCapture_MA/FileContentIndex/078b827e-e811-4b21-9c78-ac0b0fcaf5d6.vsidx

Binary files differ

 .vs/DataCapture_MA/FileContentIndex/09c4e198-10c7-4930-83c6-5ce03874c0b2.vsidx

Binary files differ

 .vs/DataCapture_MA/FileContentIndex/2b8b063f-48e9-40f7-bbdb-02f2106c336c.vsidx

Binary files differ

 .vs/DataCapture_MA/FileContentIndex/3b9f25c5-74f0-4423-ab88-e1d1016c53ab.vsidx

Binary files differ

 .vs/DataCapture_MA/FileContentIndex/d6bdff65-f4da-4af0-b65a-6b5732f132d3.vsidx

Binary files differ

 .vs/DataCapture_MA/FileContentIndex/fe92793f-cdfd-46a1-b5b7-ad08c792c142.vsidx

Binary files differ

 .vs/DataCapture_MA/v17/.suo

Binary files differ

 DataCapture_MA/DataCapture_MA.csproj

@@ -191,6 +191,7 @@
    <Compile Include="AutoMapperConfig\MapperConfiguration.cs" />
    <Compile Include="Const\CacheWarningDict.cs" />
    <Compile Include="Const\DictMapping.cs" />
    <Compile Include="DataHnadle\AutoDeleteHistoryDate.cs" />
    <Compile Include="DataHnadle\ReceiveDataHandle.cs" />
    <Compile Include="Entity\DbModel.cs" />
    <Compile Include="Entity\HttpRequestRecord.cs" />

 DataCapture_MA/DataHnadle/AutoDeleteHistoryDate.cs

¶Ô±ÈÐÂÎļþ
@@ -0,0 +1,44 @@
using DataCapture_MA.Entity;
using DataCapture_MA.log4Net;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading;
using System.Threading.Tasks;

namespace DataCapture_MA.DataHnadle
{
    /// <summary>
    /// è‡ªåŠ¨åˆ é™¤æ•°æ®
    /// </summary>
    public class AutoDeleteHistoryDate
    {
        public static void Handler()
        {
            while (true)
            {
                try
                {
                    using(DbModel dbModel = new DbModel())
                    {
                        var beforeMonth = DateTimeOffset.Now.AddDays(-30).ToUnixTimeSeconds();
                        var oldDate = dbModel.RobotInfo.Where(x => x.CreateStamp < beforeMonth).ToList();
                        if (oldDate.Count > 0)
                        {
                            dbModel.RemoveRange(oldDate);
                            dbModel.SaveChanges();
                        }
                    }
                }
                catch (Exception e)
                {
                    Log4NetHelper.WriteInfoLog(LogType.PushMes, "删除数据异常：" + JsonConvert.SerializeObject(e));
                }

                Thread.Sleep(1000*60*60);
            }
        }
    }
}

 DataCapture_MA/DataHnadle/ReceiveDataHandle.cs

@@ -193,10 +193,10 @@
                    messageAnalysis.Warnings = warringList;
                    Log4NetHelper.WriteInfoLog(LogType.Receive,"报警信息："+ JsonConvert.SerializeObject(warringList));
                }
                // æŽ¨é€mes
                _ = Task.Run(() => SendWarnForMes(messageAnalysis));
                _ = Task.Run(() => SendEquipmentStatusForMes(messageAnalysis));
                _ = Task.Run(() => SendEquipmentInfoForMes(messageAnalysis));
                //// æŽ¨é€mes
                //_ = Task.Run(() => SendWarnForMes(messageAnalysis));
                //_ = Task.Run(() => SendEquipmentStatusForMes(messageAnalysis));
                //_ = Task.Run(() => SendEquipmentInfoForMes(messageAnalysis));

                // Sqlite数据库保存一份
                _ = Task.Run(() => SaveDataForSqlite(messageAnalysis));

 DataCapture_MA/Form1.cs

@@ -41,6 +41,9 @@
            AutoMapper.Mapper.Initialize((cfg) => {
                cfg.AddProfile<MapperConfiguration>();
            });

            // åˆ é™¤ä¸€ä¸ªæœˆå‰çš„数据
            new Thread(AutoDeleteHistoryDate.Handler).Start();
        }

        private void ReceiveHandle()

 DataCapture_MA/bin/DaataCapture/DataCapture_MA.exe

Binary files differ

 DataCapture_MA/bin/DaataCapture/DataCapture_MA.pdb

Binary files differ

 DataCapture_MA/bin/Debug/AutoMapper.dll

Binary files differ

 DataCapture_MA/bin/Debug/AutoMapper.xml

 DataCapture_MA/bin/Debug/DataCapture_MA.exe

Binary files differ

 DataCapture_MA/bin/Debug/DataCapture_MA.exe.config

 DataCapture_MA/bin/Debug/DataCapture_MA.pdb

Binary files differ

 DataCapture_MA/bin/Debug/EntityFramework.SqlServer.dll

Binary files differ

 DataCapture_MA/bin/Debug/EntityFramework.SqlServer.xml

 DataCapture_MA/bin/Debug/EntityFramework.dll

Binary files differ

 DataCapture_MA/bin/Debug/EntityFramework.xml

 DataCapture_MA/bin/Debug/Microsoft.Bcl.AsyncInterfaces.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Bcl.AsyncInterfaces.xml

 DataCapture_MA/bin/Debug/Microsoft.Bcl.HashCode.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Bcl.HashCode.xml

 DataCapture_MA/bin/Debug/Microsoft.Data.Sqlite.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Data.Sqlite.xml

 DataCapture_MA/bin/Debug/Microsoft.DotNet.PlatformAbstractions.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.DotNet.PlatformAbstractions.xml

 DataCapture_MA/bin/Debug/Microsoft.EntityFrameworkCore.Abstractions.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.EntityFrameworkCore.Abstractions.xml

 DataCapture_MA/bin/Debug/Microsoft.EntityFrameworkCore.Design.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.EntityFrameworkCore.Design.xml

 DataCapture_MA/bin/Debug/Microsoft.EntityFrameworkCore.Relational.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.EntityFrameworkCore.Relational.xml

 DataCapture_MA/bin/Debug/Microsoft.EntityFrameworkCore.Sqlite.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.EntityFrameworkCore.Sqlite.xml

 DataCapture_MA/bin/Debug/Microsoft.EntityFrameworkCore.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.EntityFrameworkCore.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Caching.Abstractions.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Caching.Abstractions.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Caching.Memory.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Caching.Memory.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Configuration.Abstractions.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Configuration.Abstractions.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Configuration.Binder.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Configuration.Binder.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Configuration.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Configuration.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.DependencyInjection.Abstractions.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.DependencyInjection.Abstractions.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.DependencyInjection.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.DependencyInjection.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.DependencyModel.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.DependencyModel.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Logging.Abstractions.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Logging.Abstractions.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Logging.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Logging.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Options.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Options.xml

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Primitives.dll

Binary files differ

 DataCapture_MA/bin/Debug/Microsoft.Extensions.Primitives.xml

 DataCapture_MA/bin/Debug/MySqlConnector.dll

Binary files differ

 DataCapture_MA/bin/Debug/MySqlConnector.xml

 DataCapture_MA/bin/Debug/Newtonsoft.Json.dll

Binary files differ

 DataCapture_MA/bin/Debug/Newtonsoft.Json.xml

 DataCapture_MA/bin/Debug/Pomelo.EntityFrameworkCore.MySql.dll

Binary files differ

 DataCapture_MA/bin/Debug/Pomelo.JsonObject.dll

Binary files differ

 DataCapture_MA/bin/Debug/SQLitePCLRaw.batteries_v2.dll

Binary files differ

 DataCapture_MA/bin/Debug/SQLitePCLRaw.core.dll

Binary files differ

 DataCapture_MA/bin/Debug/SQLitePCLRaw.nativelibrary.dll

Binary files differ

 DataCapture_MA/bin/Debug/SQLitePCLRaw.provider.dynamic_cdecl.dll

Binary files differ

 DataCapture_MA/bin/Debug/System.Buffers.dll

Binary files differ

 DataCapture_MA/bin/Debug/System.Buffers.xml

 DataCapture_MA/bin/Debug/System.Collections.Immutable.dll

Binary files differ

 DataCapture_MA/bin/Debug/System.Collections.Immutable.xml

 DataCapture_MA/bin/Debug/System.ComponentModel.Annotations.dll

Binary files differ

 DataCapture_MA/bin/Debug/System.Diagnostics.DiagnosticSource.dll

Binary files differ

 DataCapture_MA/bin/Debug/System.Diagnostics.DiagnosticSource.xml

 DataCapture_MA/bin/Debug/System.Memory.dll

Binary files differ

 DataCapture_MA/bin/Debug/System.Memory.xml

 DataCapture_MA/bin/Debug/System.Numerics.Vectors.dll

Binary files differ

 DataCapture_MA/bin/Debug/System.Numerics.Vectors.xml

 DataCapture_MA/bin/Debug/System.Runtime.CompilerServices.Unsafe.dll

Binary files differ

 DataCapture_MA/bin/Debug/System.Runtime.CompilerServices.Unsafe.xml

 DataCapture_MA/bin/Debug/System.Threading.Tasks.Extensions.dll

Binary files differ

 DataCapture_MA/bin/Debug/System.Threading.Tasks.Extensions.xml

 DataCapture_MA/bin/Debug/WZ.Useful.Commons.dll

Binary files differ

 DataCapture_MA/bin/Debug/log4net.dll

Binary files differ

 DataCapture_MA/bin/Debug/log4net.pdb

Binary files differ

 DataCapture_MA/bin/Debug/log4net.xml

 DataCapture_MA/bin/Debug/log4net_iWare.config

 DataCapture_MA/bin/Debug/runtimes/win-arm/native/e_sqlite3.dll

Binary files differ

 DataCapture_MA/bin/Debug/runtimes/win-x64/native/e_sqlite3.dll

Binary files differ

 DataCapture_MA/bin/Debug/runtimes/win-x86/native/e_sqlite3.dll

Binary files differ

 DataCapture_MA/bin/MA/DataCapture_MA.exe

Binary files differ

 DataCapture_MA/bin/MA/DataCapture_MA.exe.config

@@ -6,7 +6,9 @@
  </configSections>
  <connectionStrings>
    <!-- SQLite è¿žæŽ¥å­—符串 -->
    <add name="DbModel" connectionString="Data Source=./EntitydataCapture.db" providerName="Microsoft.Data.Sqlite" />
    <!--<add name="DbModel" connectionString="Data Source=./EntitydataCapture.db" providerName="Microsoft.Data.Sqlite" />-->
  <add name="DbModel" connectionString="Server=localhost;Database=dataCapture;User=root;Password=123abc.com;Port=3306;" providerName="Pomelo.EntityFrameworkCore.MySql" />

  </connectionStrings>
  <startup>
    <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.8" />
@@ -69,6 +71,18 @@
        <assemblyIdentity name="Microsoft.Extensions.Logging" publicKeyToken="adb9793829ddae60" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-3.1.32.0" newVersion="3.1.32.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Microsoft.EntityFrameworkCore.Relational" publicKeyToken="adb9793829ddae60" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-3.1.8.0" newVersion="3.1.8.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="Newtonsoft.Json" publicKeyToken="30ad4fe6b2a6aeed" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-11.0.0.0" newVersion="11.0.0.0" />
      </dependentAssembly>
      <dependentAssembly>
        <assemblyIdentity name="System.Buffers" publicKeyToken="cc7b13ffcd2ddd51" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-4.0.3.0" newVersion="4.0.3.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
  <entityFramework>

 DataCapture_MA/bin/MA/DataCapture_MA.pdb

Binary files differ

 DataCapture_MA/bin/MA/EntitydataCapture.db

Binary files differ

 DataCapture_MA/bin/MA/EntitydataCapture.db-shm

Binary files differ

 DataCapture_MA/bin/MA/EntitydataCapture.db-wal

Binary files differ

 DataCapture_MA/bin/MA/Microsoft.EntityFrameworkCore.Relational.dll

Binary files differ

 DataCapture_MA/bin/MA/MySqlConnector.dll

copy from DataCapture_MA/bin/DaataCapture/MySqlConnector.dll
copy to DataCapture_MA/bin/MA/MySqlConnector.dll
Binary files differ

 DataCapture_MA/bin/MA/MySqlConnector.xml

copy from DataCapture_MA/bin/DaataCapture/MySqlConnector.xml
copy to DataCapture_MA/bin/MA/MySqlConnector.xml

 DataCapture_MA/bin/MA/Newtonsoft.Json.dll

Binary files differ

 DataCapture_MA/bin/MA/Newtonsoft.Json.xml

ÎļþÌ«´ó

 DataCapture_MA/bin/MA/Pomelo.EntityFrameworkCore.MySql.dll

copy from DataCapture_MA/bin/DaataCapture/Pomelo.EntityFrameworkCore.MySql.dll
copy to DataCapture_MA/bin/MA/Pomelo.EntityFrameworkCore.MySql.dll
Binary files differ

 DataCapture_MA/bin/MA/Pomelo.JsonObject.dll

copy from DataCapture_MA/bin/DaataCapture/Pomelo.JsonObject.dll
copy to DataCapture_MA/bin/MA/Pomelo.JsonObject.dll
Binary files differ

 DataCapture_MA/obj/Debug/DataCapture_MA.csproj.CoreCompileInputs.cache

@@ -1 +1 @@
5953916c56fd4681ca9232a4694591aea9299991
6064dbc37bd8ca20521ed122cb3e75424b37d635

 DataCapture_MA/obj/Debug/DataCapture_MA.exe

Binary files differ

 DataCapture_MA/obj/Debug/DataCapture_MA.pdb

Binary files differ