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