private bool KTMaSuaChua(string masuachua)
{
bool kt = true;
try
{
SqlDataReader dr = PhieuSuaChuaBUS.PhieuSuaChua_KTMaSuaChua();
while (dr.Read())
{
string msc = "";
msc = dr[0].ToString();
if (msc == masuachua)
{
kt = false;
return(kt);
}
else if (msc != masuachua)
{
kt = true;
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
SQLDataProvider.connection.Close();
}
return(kt);
}
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 void btnLapPhieu_Click(object sender, EventArgs e)
{
if (!fMainForm.cNullTB(cboBienSo.Text) && !fMainForm.cNullTB(txtSoPhieuSuaChua.Text))
{
string MaPhieuSuaChua = txtSoPhieuSuaChua.Text.Trim();
string BienSo = cboBienSo.SelectedValue.ToString();
DateTime NgaySuaChua = dtmNgaySuaChua.Value;
Decimal _TongTien = int.Parse(txtTongTien.Text);
if (!PhieuSuaChuaBUS.checkPK(MaPhieuSuaChua))
{
PhieuSuaChuaDTO PhieuSuaChua = new PhieuSuaChuaDTO(MaPhieuSuaChua, BienSo, NgaySuaChua, _TongTien);
PhieuSuaChuaBUS.addPhieuSuaChua(PhieuSuaChua);
for (int i = 0; i < dgvPhieuSuaChua.Rows.Count - 1; i++)
{
string NoiDung = dgvPhieuSuaChua.Rows[i].Cells["NoiDung"].Value.ToString();
string MaVatTuPhuTung = dgvPhieuSuaChua.Rows[i].Cells["VatTuPhuTung"].Value.ToString();
int SoLuongSuaChua = int.Parse(dgvPhieuSuaChua.Rows[i].Cells["SoLuong"].Value.ToString());
int TienCong = int.Parse(dgvPhieuSuaChua.Rows[i].Cells["TienCong"].Value.ToString());
Decimal ThanhTien = int.Parse(dgvPhieuSuaChua.Rows[i].Cells["ThanhTien"].Value.ToString());
ChiTietPhieuSuaChuaDTO CTPhieuSuaChua = new ChiTietPhieuSuaChuaDTO(MaPhieuSuaChua, NoiDung, MaVatTuPhuTung,
SoLuongSuaChua, TienCong, ThanhTien);
ChiTietPhieuSuaChuaBUS.addChiTietPhieuSuaChua(CTPhieuSuaChua);
VatTuPhuTungBUS.decreaseSoLuongVatTu(MaVatTuPhuTung, SoLuongSuaChua);
}
KhachSuaXeDAO.addTienNo(BienSo, _TongTien);
dgvLichSuLapPhieu.DataSource = PhieuSuaChuaBUS.selectAllPhieuSuaChua();
#region Clear dgvTable
reset = true;
rownum = 1;
this.dgvPhieuSuaChua.Rows.Clear();
TongTien = 0;
txtTongTien.Text = TongTien.ToString();
reset = false;
#endregion
}
else
{
MessageBox.Show("Dữ liệu vừa nhập vào không hợp lệ, do bị trùng khóa chính.");
}
}
else
{
MessageBox.Show("Bạn chưa nhập vào đủ dữ liệu xin vui lòng nhập lại.");
}
}
private void TongTien(string MSC, string BienSo)
{
try
{
if (MSC != "")
{
DataTable dt = new DataTable();
dt = PhieuSuaChuaBUS.PhieuSuaChua_GetTongTien(MSC, BienSo);
foreach (DataRow r in dt.Rows)
{
txtThanhTien.Text = r["TongTien"].ToString();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void btnLichSuLapPhieu_Click(object sender, EventArgs e)
{
dgvLichSuLapPhieu.DataSource = PhieuSuaChuaBUS.selectAllPhieuSuaChua();
}
