Winfrom 添加窗体和保存数据到数据库
1.fMain界面点击按钮跳转窗体到fMainadad
private void barButtonItem5_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
fMainadd fma = new fMainadd();
//Data(material_no);
if (fma.ShowDialog() == DialogResult.OK)
{
barButtonItem5_ItemClick(sender, e);
}
}
2.fMainadad添加保存数据到数据库
private void button1_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(txt_FG_MATERIAL_NO.Text.Trim()) || string.IsNullOrEmpty(txt_IS_MUST.Text.Trim()) || string.IsNullOrEmpty(txt_IS_BATCH.Text.Trim()))
{
MessageBox.Show("请填写完成信息！", "提示");
return;
}
SYS_COMMON_PROXY COM_PROXY = new SYS_COMMON_PROXY();
string sql = @"insert into EPM_PROCESS_KEY_PART_CONTROL(FG_MATERIAL_NO,PROCESS_CODE,RM_MATERIAL_NO,BARCODE_PARASER_CONFIG,IS_MUST,USED_QTY,IS_BATCH) values('" + txt_FG_MATERIAL_NO.Text.Trim() + "','" + txt_PROCESS_CODE.Text.Trim() + "','" + txt_RM_MATERIAL_NO.Text.Trim() + "','" + txt_BARCODE_PARASER_CONFIG.Text.Trim() + "','" + txt_IS_MUST.Text.Trim() + "','" + txt_USED_QTY.Text.Trim() + "','" + txt_IS_BATCH.Text.Trim() + "') "; --数据库语句
int RES = COM_PROXY.ExecuteNonQuery(sql);
COM_PROXY.CloseChannel();
if (RES > 0)
{
MessageBox.Show("保存成功", "提示");
this.Close();
}
}