//保存条码配置 保存配置数据 public static void SaveBarCode(CodeConfig cctem) { using (SQLiteConnection conn = GetConnection())//调用连接数据库的函数 { //使用事务删除 DbTransaction trans = conn.BeginTransaction(); try { DbCommand cmd = conn.CreateCommand(); cmd.Connection = conn; cmd.CommandText = string.Format("INSERT INTO ConfigCode(strScaner,strTestMachine,strPLC) VALUES('{0}','{1}','{2}')", cctem.m_Scaner_COM_config, cctem.m_TestMachine_Config, cctem.m_PLC_IP_config); cmd.ExecuteNonQuery(); int k = 0; } catch (Exception ex) { trans.Rollback();//回滚 return; } trans.Commit();//提交 } }
private void button1_Click(object sender, EventArgs e) { DBManage.CodeConfig cctem = new DBManage.CodeConfig(); cctem.m_Scaner_COM_config = textBox1.Text; cctem.m_TestMachine_Config = textBox2.Text; cctem.m_PLC_IP_config = textBox3.Text; DBManageHelper.SaveBarCode(cctem); temp.loadfile(); cctem.m_Scaner_COM_config = temp.m_Scaner_COM_config; cctem.m_TestMachine_Config = temp.m_TestMachine_Config; cctem.m_PLC_IP_config = temp.m_PLC_IP_config; textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); }