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("最大人数不能小于最小人数");
}
}
}
