fix：优化了，屏蔽机号不再从数据库获取记录

wzp

2025-11-25 1366efbab53c89fdb5fbca271cf4ecf652176e1f

 Rdream.Core/DataHandler/SendMsgByAccessControlRecord.cs

@@ -109,6 +109,7 @@

        //时间段及屏蔽机号
        public static string[] shieldDoor = System.Configuration.ConfigurationManager.AppSettings["shieldDoor"].Split(',');
        public static string shieldDoorStr = System.Configuration.ConfigurationManager.AppSettings["shieldDoor"];
        public static string swichTime = System.Configuration.ConfigurationManager.AppSettings["swichTime"];
        //人脸图片第二路径
        public static string[] FacePathDoor = System.Configuration.ConfigurationManager.AppSettings["FacePathDoor"].Split(',');
@@ -293,7 +294,14 @@
            {
                sql += SQL_IF_One + timeDelay + SQL_IF_One_a + _seconds + SQL_IF_One_b;
            }
            sql += SQL_Six + SQL_Seven + SQL_Eight + SQL_Nine;

            //sql += SQL_Six + SQL_Seven + SQL_Eight + SQL_Nine;

            //直接屏蔽宿舍号，不获取宿舍的记录
            string sqlWhere = $" where aa.door_id not in({shieldDoorStr})";

            sql += SQL_Six + SQL_Seven + SQL_Eight + sqlWhere + SQL_Nine;

            //log4netService.Debug("_seconds" + _seconds);
            //log4netService.Debug("sql：" + sql);
            //log4netService.Debug($"测试SQL={sql}");
@@ -353,10 +361,16 @@
                                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);
                                    try
                                    {
                                        UpdateDataSycFlag(int.Parse(dt.Rows[i]["id"].ToString()), 2);

                                    }
                                    catch (Exception ex) { }
                                    dt.Rows[i].Delete();

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

                                    try
                                    {
                                        UpdateDataSycFlag(Convert.ToInt32(dt.Rows[i]["id"]), 3);
                                    }
                                    catch(Exception ex) { }
                                    dt.Rows[i].Delete();


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

                            try
                            {
                                UpdateDataSycFlag(int.Parse(dt.Rows[i]["id"].ToString()), 2);
                            }
                            catch (Exception ex) { }
                            dt.Rows[i].Delete();

                        }
                    }
                    catch (Exception ex)