private void btnXoa_Click(object sender, EventArgs e)
{
try
{
int r = tablePhieuSuaChua.CurrentRow.Index;
string msc = tablePhieuSuaChua.Rows[r].Cells[0].Value.ToString();
string noidung = tablePhieuSuaChua.Rows[r].Cells[2].Value.ToString();
string mavt = tablePhieuSuaChua.Rows[r].Cells[1].Value.ToString();
CT_PhieuSuaChuaBUS.CT_PhieuSuaChua_Delete(msc, noidung, mavt);
MessageBox.Show("Xóa thành công!", "Xóa", MessageBoxButtons.OK, MessageBoxIcon.Information);
txtDonGia.Text = "";
txtSoLuong.Text = "";
txtThanhTien.Text = "";
txtTienCong.Text = "";
cbVTPT.Text = "";
cbNoiDung.Text = "";
lbcSoLuongTon.Text = "";
txtSoLuong.Text = "";
txtMaPhieu.Text = "";
LoadDSxeTheoBienSo(cbBienSo.Text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
btnXoa.Enabled = false;
btnIn.Enabled = false;
}
private void LoadDSxeTheoBienSo(string BienSo)
{
try
{
tablePhieuSuaChua.DataSource = CT_PhieuSuaChuaBUS.CT_PhieuSuaChua_GetByBienSo(BienSo);
}
catch (Exception e)
{
MessageBox.Show(e.Message);
}
}
private void btnLapPhieu_Click(object sender, EventArgs e)
{
try
{
if (KiemTraSoLuongTon())
{
if (KTMaSuaChua(txtMaPhieu.Text))
{
if (KTNhapXuat())
{
PhieuSuaChua psc = new PhieuSuaChua();
CT_PhieuSuaChua ct_psc = new CT_PhieuSuaChua();
psc.MaPhieuSuaChua = txtMaPhieu.Text;
psc.NgaySuaChua = dtpNgaySuaChua.Text;
psc.BienSo = cbBienSo.Text;
psc.TongTien = double.Parse(txtThanhTien.Text);
PhieuSuaChuaBUS.PhieuSuaChua_Insert(psc);
ct_psc.MaPhieuSuaChua = txtMaPhieu.Text;
ct_psc.MaVatTuPhuTung = cbVTPT.Text;
ct_psc.NoiDungSuaChua = cbNoiDung.Text;
ct_psc.SoLuong = int.Parse(txtSoLuong.Text);
ct_psc.DonGia = double.Parse(txtDonGia.Text);
ct_psc.TienCong = double.Parse(txtTienCong.Text);
ct_psc.ThanhTien = TinhTien();
CT_PhieuSuaChuaBUS.CT_PhieuSuaChua_Insert(ct_psc);
LoadDSxeTheoBienSo(cbBienSo.Text);
lbcSoLuongTon.Text = VatTuPhuTungBUS.VatTuPhuTung_GetSoLuongTon(cbVTPT.Text).ToString();
MessageBox.Show("Lập phiếu thành công!");
DoanhSo_Insert();
}
}
else
{
MessageBox.Show("Mã sửa chữa đã có");
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
SQLDataProvider.connection.Close();
}
btnIn.Enabled = false;
btnXoa.Enabled = false;
}
private bool KTnoidungsuachua(string msc, string noidung)
{
bool kt = false;
if (CT_PhieuSuaChuaBUS.CT_PhieuSuaChua_KiemTra(msc, noidung).Rows.Count == 0)
{
kt = true;
SQLDataProvider.connection.Close();
}
else
{
kt = false;
}
return(kt);
}
