fix: 修复因数据库死锁导致过滤失效的问题

wzp

2024-09-30 4ae8b1c91036a89f7b8921921826e37e0df1a656

fix: 修复因数据库死锁导致过滤失效的问题

 Rdream.Core/DataHandler/SendMsgByAccessControlRecord.cs

@@ -353,10 +353,11 @@
                                if (subDeviceId == dicDoorSwitch[doorIdTemp])
                                {
                                    //剔除屏蔽的记录
                                    Console.WriteLine($"剔除屏蔽门禁{dt.Rows[i]["door_id"]}");
                                    Console.WriteLine($"单向门屏蔽剔除屏蔽门禁{dt.Rows[i]["door_id"]}");
                                    log4netService.Debug($"剔除屏蔽门禁{dt.Rows[i]["door_id"]}");
                                    UpdateDataSycFlag(int.Parse(dt.Rows[i]["id"].ToString()), 2);
                                    dt.Rows[i].Delete();
                                    UpdateDataSycFlag(int.Parse(dt.Rows[i]["id"].ToString()), 2);

                                    continue;
                                }
                                
@@ -374,10 +375,12 @@
                                else
                                {
                                    string str = $"因温度或屏蔽门禁过滤数据ID：{dt.Rows[i]["id"]}";
                                    UpdateDataSycFlag(Convert.ToInt32(dt.Rows[i]["id"]), 3);
                                    log4netService.Debug(str);
                                    Console.WriteLine(str);
                                    dt.Rows[i].Delete();

                                    UpdateDataSycFlag(Convert.ToInt32(dt.Rows[i]["id"]), 3);

                                }
                            }
                        }
@@ -386,8 +389,9 @@
                            //剔除屏蔽的记录
                            Console.WriteLine($"剔除屏蔽门禁{dt.Rows[i]["door_id"]}");
                            log4netService.Debug($"剔除屏蔽门禁{dt.Rows[i]["door_id"]}");
                            UpdateDataSycFlag(int.Parse(dt.Rows[i]["id"].ToString()), 2);
                            
                            dt.Rows[i].Delete();
                            UpdateDataSycFlag(int.Parse(dt.Rows[i]["id"].ToString()), 2);
                        }
                    }
                    catch (Exception ex)

 TimedTaskService/TimedTaskService.csproj

@@ -11,6 +11,21 @@
    <TargetFrameworkVersion>v4.5</TargetFrameworkVersion>
    <FileAlignment>512</FileAlignment>
    <Deterministic>true</Deterministic>
    <PublishUrl>publish\</PublishUrl>
    <Install>true</Install>
    <InstallFrom>Disk</InstallFrom>
    <UpdateEnabled>false</UpdateEnabled>
    <UpdateMode>Foreground</UpdateMode>
    <UpdateInterval>7</UpdateInterval>
    <UpdateIntervalUnits>Days</UpdateIntervalUnits>
    <UpdatePeriodically>false</UpdatePeriodically>
    <UpdateRequired>false</UpdateRequired>
    <MapFileExtensions>true</MapFileExtensions>
    <ApplicationRevision>0</ApplicationRevision>
    <ApplicationVersion>1.0.0.%2a</ApplicationVersion>
    <IsWebBootstrapper>false</IsWebBootstrapper>
    <UseApplicationTrust>false</UseApplicationTrust>
    <BootstrapperEnabled>true</BootstrapperEnabled>
  </PropertyGroup>
  <PropertyGroup Condition=" '$(Configuration)|$(Platform)' == 'Debug|AnyCPU' ">
    <PlatformTarget>AnyCPU</PlatformTarget>
@@ -68,5 +83,12 @@
      <Name>2.Rdream.Core</Name>
    </ProjectReference>
  </ItemGroup>
  <ItemGroup>
    <BootstrapperPackage Include="Microsoft.Net.Framework.3.5.SP1">
      <Visible>False</Visible>
      <ProductName>.NET Framework 3.5 SP1</ProductName>
      <Install>false</Install>
    </BootstrapperPackage>
  </ItemGroup>
  <Import Project="$(MSBuildToolsPath)\Microsoft.CSharp.targets" />
</Project>