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