C#彩票遗留期数计算

            LotteryDBEntities LotteryDB = new LotteryDBEntities();
            var AllSSQ = LotteryDB.L_SSQ.OrderByDescending(o => o.LotteryDate).ToList();
            List<L_SSQ> SSQList = new List<L_SSQ>();
            SSQList.AddRange(AllSSQ);
            foreach (var ssq in AllSSQ)
            {
                var _SSQMiss = LotteryDB.L_SSQ_Miss.Where(o => o.PeriodNumber == ssq.PeriodNumber).FirstOrDefault();
                if (_SSQMiss == null) { 
                L_SSQ_Miss SSQMiss = new L_SSQ_Miss();
                SSQMiss.PeriodNumber = ssq.PeriodNumber;
                SSQMiss.OneNum = ssq.OneNum;
                SSQMiss.TowNum = ssq.TowNum;
                SSQMiss.ThreeNum = ssq.ThreeNum;
                SSQMiss.FourNum = ssq.FourNum;
                SSQMiss.FiveNum = ssq.FiveNum;
                SSQMiss.SixNum = ssq.SixNum;
                SSQMiss.SevenNum = ssq.SevenNum;
                SSQMiss.LotteryDate = ssq.LotteryDate;
                ///循环1~33红球
                for (int i = 1; i <=33; i++)
                {
                    int count = 0;
                    foreach (var item in SSQList)
                    {

                        if (item.OneNum == i |
                            item.TowNum == i |
                            item.ThreeNum == i |
                            item.FourNum == i |
                            item.FiveNum == i |
                            item.SixNum == i)
                        {

                            SSQMiss.GetType().GetProperty("R" + i.ToString()).SetValue(SSQMiss, count, null);
                            break;
                        }
                        else
                        {
                            count++;
                            SSQMiss.GetType().GetProperty("R" + i.ToString()).SetValue(SSQMiss, count, null);

                        }
                    }

                }
                ///循环1~16篮球
                for (int i = 1; i <= 16; i++)
                {
                    int count = 0;
                    foreach (var item in SSQList)
                    {

                        if (item.SevenNum == i)
                        {
                            SSQMiss.GetType().GetProperty("B" + i.ToString()).SetValue(SSQMiss, count, null);
                            break;
                        }
                        else
                        {
                            count++;
                            SSQMiss.GetType().GetProperty("B" + i.ToString()).SetValue(SSQMiss, count, null);
                        }
                    }
                }


                LotteryDB.L_SSQ_Miss.Add(SSQMiss);
                LotteryDB.SaveChanges();
                }
                ///计算后再删除
                SSQList.Remove(ssq);
            }

 最前几期无法计算遗漏