//保存条码配置 保存配置数据
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();
}
