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(); } } }