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