private void buttonX3_Click(object sender, EventArgs e) { string deletecommand = "delete * from SpareTime_Data"; string selectcommand = "select * from SpareTime_Data"; DataTable dt = help.getDs(selectcommand, "SpareTime_Data").Tables[0]; if (dt.Rows.Count != 0) { if (help.Oledbcommand(deletecommand) > 0) { try { Placement selecttime = new Placement(); selecttime.AutoSelectSpareTime(progressBar1); if (progressBar1.Value == progressBar1.Maximum) { MessageBox.Show("自动填补成功"); progressBar1.Value = 0; listView1.Items.Clear(); ListSupervisor.Clear(); week.Clear(); strweek.Clear(); frmSpareTime_Load(sender, e); } else { } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } else { MessageBox.Show("请手动删除当前数据表数据"); } } else { try { Placement selecttime = new Placement(); selecttime.AutoSelectSpareTime(progressBar1); if (progressBar1.Value == progressBar1.Maximum) { MessageBox.Show("自动填补成功"); progressBar1.Value = 0; listView1.Items.Clear(); ListSupervisor.Clear(); week.Clear(); strweek.Clear(); frmSpareTime_Load(sender, e); } else { } } catch (Exception ex) { MessageBox.Show(ex.ToString()); } } }
private void buttonX1_Click(object sender, EventArgs e) { SqlHelper help = new SqlHelper(); DataTable dtsparetime = help.getDs("select * from SpareTime_Data", "SpareTime_Data").Tables[0]; DataTable dtclass = help.getDs("select * from Classes_Data", "Classes_Data").Tables[0]; DataTable dtteacher = help.getDs("select * from Teachers_Data", "Teachers_Data").Tables[0]; if (checkType()) { if (cnumpeo_max >= cnumpeo_min) { if (dtsparetime.Rows.Count != 0 && dtclass.Rows.Count != 0 && dtteacher.Rows.Count != 0) { Main.fm.SetStatusText("正在工作中,请耐心等待~~", 1); //MessageBox.Show("OK"); PlacementConfig pc = new PlacementConfig(cbegin_week, cbegin_day, cnumclass_week, cnumpeo_max, cnumpeo_min, proportion); Placement doplacement = new Placement(); doplacement.MakePlacement(pc); } else { MessageBox.Show("请导入数据后重试"); } } else { MessageBox.Show("最大人数不能小于最小人数"); } } }