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