var LiShiSCJG_SPAQNianDuDengjiPDB = _ioc.Query<SCJG_SPAQNianDuDengjiPDB>(false)
              //查找出不是本年度的记录
              .ToList();
            for(var i = 0; i < LiShiSCJG_SPAQNianDuDengjiPDB.Count(); i++)
            {
                var jianChaJiLu = _ioc.Query<SCJG_JianChaJiLu>(false)
             .Where(e => e.JianChaLeiBie == "食品经营日常检查" && !string.IsNullOrEmpty(e.JianChaJieGuo))
              .Where(e => !string.IsNullOrEmpty(e.XuKeZhengHao))
              .Where(e => e.XuKeZhengHao == LiShiSCJG_SPAQNianDuDengjiPDB[i].XuKeZhengHao)
              .FirstOrDefault();
                if (jianChaJiLu==null)
                {
                    LiShiSCJG_SPAQNianDuDengjiPDB[i].Delete().SaveToDBAsync().Wait();
                }
                else
                {
                    if (string.IsNullOrEmpty(LiShiSCJG_SPAQNianDuDengjiPDB[i].RiChangJianDuGuanLiJiGou))
                    {

                        LiShiSCJG_SPAQNianDuDengjiPDB[i].RiChangJianDuGuanLiJiGou = jianChaJiLu.JianGuanPianOu;
                        LiShiSCJG_SPAQNianDuDengjiPDB[i].Update().SaveToDBAsync().Wait();
                    }


                }


            }
01-16 18:22