public List<LotterySerialNo> CreateSerialNo(LotteryBasicInfo info) { 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 = 0; } 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; } } return serialNos; }
public static List<LotteryOriginData> LoadLotteryOriginData(LotteryBasicInfo info, List<LotteryOriginData> dataList) { SQLiteDataReader Reader = DBHelper.Query("select * from LotteryOriginData where lotterytypeid = " + info.LotteryTypeID); while (Reader.Read()) { LotteryOriginData data = new LotteryOriginData() { RowID = Reader.GetInt32(0), LotteryTypeID = Reader.GetInt32(1), OriginData = Reader.GetString(2), DataUrl = Reader.GetString(3), SerialNo = Reader.GetString(4), Time = Reader.GetString(5), }; dataList.Add(data); } return dataList; }
public List<LotterySerialNo> CreateSerialNo(LotteryBasicInfo info) { List<LotterySerialNo> serialNos = new List<LotterySerialNo>(); return serialNos; }