public WinPrizeShowForm(DateTime openTime, string connStr) { InitializeComponent(); this.connStr = connStr; startTimeTP.CustomFormat = "yyyy-MM-dd HH:mm:ss"; endTimeTP.CustomFormat = "yyyy-MM-dd HH:mm:ss"; startTimeTP.Value = openTime; endTimeTP.Value = DateTime.Now; winPrizes = new WinPrizeCollection(connStr); winPrizes.ReadDB(startTimeTP.Value, endTimeTP.Value); }
public DrawPrizeForm(PersonCollection persons, Config config, PrizeCollection prizes, ImageDB imgdb, DateTime filterTime, int drawType) { InitializeComponent(); this.config = config; this.persons = persons; this.prizes = prizes; this.imdb = imgdb; this.drawType = drawType; openTime = filterTime; wps = new WinPrizeCollection(config.Connstr); wps.ReadDB(openTime); noprizePersons = new PersonDrawCollection(); RefreshDrawPerson(); }
private void SaveWinDB() { WinPrizeCollection twps = new WinPrizeCollection(config.Connstr); WinPrize pr = new WinPrize(prizes.GetPrize(prizeCB.SelectedIndex)); pr.DrawTime = DateTime.Now; foreach (var item in winList) { pr.Persons.Add(item); } twps.Add(pr); twps.SaveDB(); wps.ReadDB(openTime); RefreshDrawPerson(); }
private void searchBt_Click(object sender, EventArgs e) { winPrizes.ReadDB(startTimeTP.Value, endTimeTP.Value); this.RefreshPrize(); }