public bool deleteXK(DTO.XuatKho xk)
{
string sql = "DELETE FROM tb_exportwarehouse WHERE id_xk=@id";
MySqlConnection con = dc.getConnection();
try
{
cmd = new MySqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("id", MySqlDbType.VarChar).Value = xk.id_xk;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{
return(false);
}
return(true);
}
public bool insertXK(DTO.XuatKho xk)
{
string sql = "INSERT INTO tb_exportwarehouse(id_hh, namecommodity,number,time) VALUES (@id_hh,@namecommodity,@number,@time)";
MySqlConnection con = dc.getConnection();
try
{
cmd = new MySqlCommand(sql, con);
con.Open();
cmd.Parameters.Add("id_hh", MySqlDbType.VarChar).Value = xk.id_hh;
cmd.Parameters.Add("namecommodity", MySqlDbType.VarChar).Value = xk.namecommodity;
cmd.Parameters.Add("number", MySqlDbType.VarChar).Value = xk.number;
cmd.Parameters.Add("time", MySqlDbType.VarChar).Value = xk.time;
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception)
{
return(false);
}
return(true);
}
private void btnDeletrExport_Click(object sender, EventArgs e)
{
if (id1 != 0)
{
DialogResult result = MessageBox.Show("Xác nhân xóa thông tin xuất kho", "THÔNG BÁO", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button1);
if (result == DialogResult.Yes)
{
DTO.XuatKho xk = new DTO.XuatKho();
xk.id_xk = id1;
bll.deleteXK(xk);
reset();
dgvExportWarehouse.DataSource = bll.getAllXuatKho();
}
else
{
MessageBox.Show("Hủy xóa thông tin xuất kho", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
else
{
MessageBox.Show("Chưa chọn thông tin cần xóa", "THÔNG BÁO", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public bool deleteXK(DTO.XuatKho xk)
{
return(dalk.deleteXK(xk));
}
public bool insertXK(DTO.XuatKho xk)
{
return(dalk.insertXK(xk));
}
