private void LoadMaPhieuThanhLy() { QuanLyThanhLySachBUS quanLyThanhLySachBUS = new QuanLyThanhLySachBUS(); string MaMoi = quanLyThanhLySachBUS.LayMaPhieuLonNhat(); txtMaPhieu.Text = MaMoi; }
private void btnHoanTat_Click(object sender, EventArgs e) { PhieuThanhLySachDTO phieuThanhLySachDTO = new PhieuThanhLySachDTO(); phieuThanhLySachDTO.MaPhieuthanhLy = txtMaPhieu.Text; phieuThanhLySachDTO.MaNV = cbbNhanVien.SelectedValue.ToString(); phieuThanhLySachDTO.NgayThanhLy = dtNgayThanhLy.Value.ToString("MM-dd-yyyy"); QuanLyThanhLySachBUS quanLyThanhLySachBUS = new QuanLyThanhLySachBUS(); quanLyThanhLySachBUS.ThemPhieuThanhLySach(phieuThanhLySachDTO); foreach (DataGridViewRow row in dgvChiTietPhieuThanhLy.Rows) { if (row.Index == dgvChiTietPhieuThanhLy.Rows.Count - 1) { break; } ChiTietPhieuThanhLySachDTO ChiTiet = new ChiTietPhieuThanhLySachDTO(); ChiTiet.MaPhieuThanhLy = txtMaPhieu.Text; ChiTiet.MaSach = row.Cells["MaSach"].Value.ToString(); ChiTiet.MaLyDoThanhLy = row.Cells["LyDoThanhLy"].Value.ToString(); quanLyThanhLySachBUS.ThemChiTietPhieuThanhLySach(ChiTiet); quanLyThanhLySachBUS.XoaSach(ChiTiet.MaSach); } MessageBox.Show("Lập phiếu thanh lý sách thành công"); LoadMaPhieuThanhLy(); LamMoiForm(); }
private void btnXoaLyDo_Click(object sender, EventArgs e) { try { DialogResult result = MessageBox.Show("Bạn chắc chắn muốn xóa ??", "Xóa lý do ", MessageBoxButtons.YesNo); switch (result) { case DialogResult.No: break; case DialogResult.Yes: QuanLyThanhLySachBUS quanLyThanhLySachBUS = new QuanLyThanhLySachBUS(); quanLyThanhLySachBUS.XoaQuanLyThanhLySach(txtMaLyDo.Text); MessageBox.Show("Xóa thành công"); Tai_Thong_Tin_Ly_Do(); break; default: break; } } catch (Exception ex) { MessageBox.Show("Xóa thất bại - Lỗi :" + ex.ToString()); } }
private void Tai_Thong_Tin_Ly_Do() { QuanLyThanhLySachBUS quanLyThanhLySachBUS = new QuanLyThanhLySachBUS(); DataTable dsLyDo = quanLyThanhLySachBUS.LayDanhSachLyDoThanhLy(); dgvLyDoThanhLySach.DataSource = dsLyDo; }
private void LoadThongTinSach(int Rowindex, int Colindex) { if (dgvChiTietPhieuThanhLy.Rows[Rowindex].Cells[1].Value == null) { BeginInvoke(new MethodInvoker(delegate { if (Rowindex != dgvChiTietPhieuThanhLy.Rows.Count - 1) { dgvChiTietPhieuThanhLy.Rows.RemoveAt(Rowindex); } })); return; } string MaSach = dgvChiTietPhieuThanhLy[Colindex, Rowindex].Value.ToString(); if (KiemTraTrungMaSach(MaSach, Rowindex)) { MessageBox.Show("Mã sách đã được nhập"); BeginInvoke(new MethodInvoker(delegate { if (Rowindex != dgvChiTietPhieuThanhLy.Rows.Count - 1) { dgvChiTietPhieuThanhLy.Rows.RemoveAt(Rowindex); } })); return; } QuanLyThanhLySachBUS quanLyThanhLySachBUS = new QuanLyThanhLySachBUS(); DataTable dtSach = quanLyThanhLySachBUS.LayThongTinSach(MaSach); if (dtSach.Rows.Count < 1) // kiểm tra sách có được tìm thấy hay không { MessageBox.Show("Không tìm thấy sách với mã " + MaSach); BeginInvoke(new MethodInvoker(delegate { if (Rowindex != dgvChiTietPhieuThanhLy.Rows.Count - 1) { dgvChiTietPhieuThanhLy.Rows.RemoveAt(Rowindex); } })); return; } dgvChiTietPhieuThanhLy[3, Rowindex].Value = dtSach.Rows[0]["TenSach"].ToString(); dgvChiTietPhieuThanhLy[4, Rowindex].Value = dtSach.Rows[0]["TenTheLoai"].ToString(); dgvChiTietPhieuThanhLy[5, Rowindex].Value = dtSach.Rows[0]["TenTacGia"].ToString(); }
private void LoadLyDoThanhLy(int i) { QuanLyThanhLySachBUS quanLyThanhLySachBUS = new QuanLyThanhLySachBUS(); DataTable dtDSLyDo = quanLyThanhLySachBUS.LayDanhSachLyDoThanhLy(); dtDSLyDo.Columns["MoTa"].DefaultValue = "Mất"; var CellLyDoThanhLy = (DataGridViewComboBoxCell)dgvChiTietPhieuThanhLy.Rows[i].Cells[2]; CellLyDoThanhLy.DataSource = dtDSLyDo; CellLyDoThanhLy.DisplayMember = "MoTa"; CellLyDoThanhLy.ValueMember = "MaLyDoThanhLy"; CellLyDoThanhLy.Value = dtDSLyDo.Rows[0]["MaLyDoThanhLy"]; }
private void btnSuaLyDo_Click(object sender, EventArgs e) { try { QuanLyThanhLySachBUS quanLyThanhLySachBUS = new QuanLyThanhLySachBUS(); quanLyThanhLySachBUS.SuaQuanLyThanhLySach(txtMoTa.Text, txtMaLyDo.Text); MessageBox.Show("Cập nhật thành công"); Tai_Thong_Tin_Ly_Do(); } catch (Exception ex) { MessageBox.Show("Cập nhật thất bại - Lỗi :" + ex.ToString()); } }