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; }