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