private void btnAdd_Click(object sender, EventArgs e)
{
int roleProductId = Convert.ToInt32(this.cbRoleProductId.SelectedValue);
int productId = Convert.ToInt32(this.tbProductId.Text);
RoleProduct roleProduct = new RoleProduct();
roleProduct.RPId = roleProductId;
roleProduct.RPProductId = productId;
if (RoleProductAccess.AddRoleProduct(roleProduct))
{
MessageBox.Show("角色产品添加成功！");
}
else
{
MessageBox.Show("角色产品添加失败！");
}
}
public static bool AddRoleProduct(RoleProduct roleProduct)
{
SqlConnection con = DBConnect.DBOpen();
SqlCommand cmd = new SqlCommand("insert into " + DBConfig.RoleProduct + "([RPId],[RPProductId],[RPProductName])" +
"values(@RPId,@RPProductId,@RPProductName)", con);
cmd.Parameters.AddWithValue("@RPId", roleProduct.RPId);
cmd.Parameters.AddWithValue("@RPProductId", roleProduct.RPProductId);
cmd.Parameters.AddWithValue("@RPProductName", roleProduct.RPProductName);
int count = cmd.ExecuteNonQuery();
if (count == 1)
{
DBConnect.DBClose();
return(true);
}
DBConnect.DBClose();
return(false);
}
