public void CreateLotterySerialNo() { string LotteryID = cmbLotteryName.SelectedValue.ToString(); LotteryBasicInfo info = infos.FirstOrDefault(p => p.LotteryTypeID.ToString() == LotteryID); if (info != null) { List<LotterySerialNo> serialNos = new List<LotterySerialNo>(); DateTime startTime = DateTime.Parse(info.StartSaleTime); int i = info.SerialNoStartIndex; for (DateTime time = startTime; time < DateTime.Now; time = time.AddDays(1)) { if (time.Year > startTime.Year) { startTime = time; i = 1; } if (info.OpenTimeOfWeek.ToList().Contains((int)time.DayOfWeek)) { LotterySerialNo no = new LotterySerialNo() { LotteryTypeID = info.LotteryTypeID, OpenTime = time.ToString(), }; no.SerailNo = time.Year.ToString().Substring(info.StartSerialNo.Length == 5 ? 2 : 0, info.StartSerialNo.Length - 3) + "" + i.ToString().PadLeft(3, '0'); serialNos.Add(no); i += 1; } } LotteryDataUtils.InsertLotterySerialNoListToDB(serialNos); } }
public void GetLotteryOriginData() { string LotteryID = cmbLotteryName.SelectedValue.ToString(); LotteryBasicInfo info = infos.FirstOrDefault(p => p.LotteryTypeID.ToString() == LotteryID); if (info != null) { string baseUrl = @"http://baidu.lecai.com/lottery/draw/ajax_get_detail.php?lottery_type={0}&phase={1}"; SQLiteDataReader Reader = DBHelper.Query("select * from LotterySerialNo where lotterytypeid = " + info.LotteryTypeID); List<LotterySerialNo> numList = new List<LotterySerialNo>(); List<LotteryOriginData> dataList = new List<LotteryOriginData>(); while (Reader.Read()) { LotterySerialNo num = new LotterySerialNo() { RowID = Reader.GetInt32(0), SerailNo = Reader.GetString(1), LotteryTypeID = Reader.GetInt32(2), OpenTime = Reader.GetString(3), }; numList.Add(num); } foreach (var num in numList) { string url = String.Format(baseUrl, num.LotteryTypeID, num.SerailNo); string res = NetHelper.GetByUrl(url); if (!String.IsNullOrWhiteSpace(res) && !res.StartsWith("<")) { LotteryOriginData data = new LotteryOriginData() { LotteryTypeID = num.LotteryTypeID, OriginData = res, DataUrl = url, Time = num.OpenTime, SerialNo = num.SerailNo, }; dataList.Add(data); } } LotteryDataUtils.InsertLotteryOriginDataListToDB(dataList); } }