private void button3_Click(object sender, EventArgs e) { FrmGoodsSupplier fgs = new FrmGoodsSupplier(); fgs.Show(); }
private void btn_SSubmit_Click(object sender, EventArgs e) { MySqlConnection myconn = BaseClass.DBConn.MyConn(); myconn.Open(); string sql = "select count(*) from tb_GoodsSupplier where GSName=@gsname"; MySqlCommand mycmd = new MySqlCommand(sql, myconn); mycmd.Parameters.Add("@gsname", MySqlDbType.VarChar, 20).Value = gsname; int n = Convert.ToInt32(mycmd.ExecuteScalar()); if (n > 0) { //修改 sql = "update tb_GoodsSupplier set GSName=@gsname,GSPName=@gspname,GSTel=@gstel,GSAddress=@gsaddress,GSNotes=@gsnotes where GSID=@gsid"; mycmd = new MySqlCommand(sql, myconn); mycmd.Parameters.Add("@gsname", MySqlDbType.VarChar, 20).Value = txtbox_GSName.Text.Trim(); mycmd.Parameters.Add("@gspname", MySqlDbType.VarChar, 20).Value = txtbox_GSPName.Text.Trim(); mycmd.Parameters.Add("@gstel", MySqlDbType.VarChar, 20).Value = txtbox_GSTel.Text.Trim(); mycmd.Parameters.Add("@gsaddress", MySqlDbType.VarChar, 50).Value = txtbox_GSAddress.Text.Trim(); mycmd.Parameters.Add("@gsnotes", MySqlDbType.VarChar, 50).Value = richtxtbox_GSNotes.Text.Trim(); mycmd.Parameters.Add("@gsid", MySqlDbType.Int32, 20).Value = gsid; mycmd.ExecuteNonQuery(); myconn.Close(); FrmGoodsSupplier s = (FrmGoodsSupplier)this.Owner;//委托父窗体 s.BindData(); MessageBox.Show("供应商'" + gsname + "'修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } else { sql = "select count(*) from tb_GoodsSupplier where GSName=@gsname"; mycmd = new MySqlCommand(sql, myconn); mycmd.Parameters.Add("@gsname", MySqlDbType.VarChar, 20).Value = txtbox_GSName.Text; n = Convert.ToInt32(mycmd.ExecuteScalar()); if (n > 0) { MessageBox.Show("供应商'" + txtbox_GSName.Text + "'已存在!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning); txtbox_GSName.Focus(); } else { //添加 sql = "insert into tb_GoodsSupplier(GSName,GSPName,GSTel,GSAddress,GSNotes) values(@gsname,@gspname,@gstel,@gsaddress,@gsnotes)"; mycmd = new MySqlCommand(sql, myconn); mycmd.Parameters.Add("@gsname", MySqlDbType.VarChar, 20).Value = txtbox_GSName.Text.Trim(); mycmd.Parameters.Add("@gspname", MySqlDbType.VarChar, 20).Value = txtbox_GSPName.Text.Trim(); mycmd.Parameters.Add("@gstel", MySqlDbType.VarChar, 20).Value = txtbox_GSTel.Text.Trim(); mycmd.Parameters.Add("@gsaddress", MySqlDbType.VarChar, 50).Value = txtbox_GSAddress.Text.Trim(); mycmd.Parameters.Add("@gsnotes", MySqlDbType.VarChar, 50).Value = richtxtbox_GSNotes.Text.Trim(); mycmd.ExecuteNonQuery(); myconn.Close(); FrmGoodsSupplier s = (FrmGoodsSupplier)this.Owner;//委托父窗体 s.BindData(); MessageBox.Show("供应商'" + txtbox_GSName.Text + "'添加成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); } } }
private void tsbtn_GSSet_Click(object sender, EventArgs e) { FrmGoodsSupplier fgs = new FrmGoodsSupplier(); fgs.Show(); }