public int InsertTaskConfig(TaskConfig task)
{
string insert = String.Format("insert into TaskConfig values('{0}','{1}','{2}',{3},{4})", task.ID, task.Name, task.Status, task.BeginNum, task.EndNum);
Conn.Open();
SqlCommand CMD = new SqlCommand(insert, Conn);
int result;
try
{
result = CMD.ExecuteNonQuery();
}
catch
{
result = 0;
}
Conn.Close();
return(result);
}
private void btn_Save_Click(object sender, EventArgs e)
{
try
{
templetDAO.CreateTaskConfigTable();
int max = templetDAO.SelectMaxAreaCode();
int number = max / 5;
int i, range1 = 0, range2 = 0;
TaskConfig task = new TaskConfig();
for (i = 1; i <= number; i++)
{
range1 = 5 * i - 4;
range2 = 5 * i;
task.BeginNum = range1;
task.EndNum = range2;
task.ID = i.ToString();
task.Name = "工位" + i.ToString();
task.Status = "是";
templetDAO.InsertTaskConfig(task);
}
task.BeginNum = range2 + 1;
task.EndNum = max;
task.ID = i.ToString();
task.Name = "工位" + i.ToString();
task.Status = "是";
templetDAO.InsertTaskConfig(task);
MessageBox.Show("导入成功！");
btn_Display.Enabled = true;
dataGridView1.AutoGenerateColumns = true;
dataGridView1.DataSource = templetDAO.SelectAll_();
ChangeColumnNames_();
IniFile ini = new IniFile("D://record.ini");
ini.IniWriteValue("table_", "exist_", "true");
//table_初始状态为false，导入成功后改为true
}
catch
{
MessageBox.Show("导入失败！");
}
btn_Save.Enabled = false;
return;
}
