private void btnMuon_Click(object sender, EventArgs e) { btnMuon.Enabled = false; btnTra.Enabled = true; btnGiaHan.Enabled = true; panel3.Enabled = true; PhieuMuonDAO pm = new PhieuMuonDAO(); string maphieumuon = txtCTMaPhieuMuon.Text; string madg = (cbMaDGMuon.SelectedItem as DocGia).MaDG; DateTime ngaymuon = dateTimeCTMuonMuon.Value; DateTime ngaytra = dateTimeCTTraMuon.Value; string manhanvien = LoginAccount.MaNhanVien; int trangthai = 0; string masach = (cbMaSachMuon.SelectedItem as Book).MaSach; int soluong = (int)numSLMuon.Value; BookDAO book = new BookDAO(); if (book.CheckBookNumberByMaSach(masach) < soluong) { MessageBox.Show("Sách không đủ"); } else { if (pm.InsertPhieuMuon(maphieumuon, madg, ngaymuon, ngaytra, manhanvien, trangthai, masach, soluong)) { MessageBox.Show("Thêm Thành công"); ShowMuon(); } else { MessageBox.Show("Có lỗi khi thêm"); } } }
int PhanTrang() { PhieuMuonDAO pm = new PhieuMuonDAO(); int sodong = 0; if (ckhQuaHan.Checked == false) { string query = "Select count(*) from PhieuMuon Where TrangThaiTong=0"; sodong = pm.GetSoLuong(query); } else if (ckhQuaHan.Checked == true) { DateTime dt = DateTime.Now; string query = "Select count(*) from PhieuMuon Where TrangThaiTong=0 and NgayTra < '" + dt.ToString() + "'"; sodong = pm.GetSoLuong(query); } int sotrang = sodong / 10; if (sodong % 10 != 0) { sotrang += 1; } return(sotrang); }
string TaoMoiMaPhieu() { PhieuMuonDAO pm = new PhieuMuonDAO(); string old = pm.GetMaxMaPhieu(); old = old.TrimStart('P'); int newCode = int.Parse(old); newCode += 1; string code = "P"; if (newCode < 10) { code = code + "00" + newCode; } else if (newCode < 100) { code = code + "0" + newCode; } else { code = code + newCode; } return(code); }
public static void MakeLoan(string idDocGia, DateTime ngayMuon, string[] idSachs) { int idPhieuMuon = PhieuMuonDAO.AddPhieuMuon(Int32.Parse(idDocGia), ngayMuon); foreach (string idSach in idSachs) { CT_PhieuMuonBUS.AddCT_PhieuMuon(idPhieuMuon, Int32.Parse(idSach)); SachBUS.UpdateTinhTrangSach(Int32.Parse(idSach), true); } }
private void txtSearchMuon_TextChanged(object sender, EventArgs e) { PhieuMuonDAO pm = new PhieuMuonDAO(); if (radMaDGMuon.Checked == true) { dgvMuon.DataSource = pm.GetListPhieuMuonByMaDG(txtSearchMuon.Text); } if (radMaPhieuMuon.Checked == true) { dgvMuon.DataSource = pm.GetListPhieuMuonByMaPhieu(txtSearchMuon.Text); } }
private void ckbChuaTra_CheckedChanged(object sender, EventArgs e) { txtPage.Text = "1"; PhieuMuonDAO pm = new PhieuMuonDAO(); if (ckhQuaHan.Checked == false) { listTK.DataSource = pm.GetListPhieuMuonbyPage(1, 0); } else if (ckhQuaHan.Checked == true) { listTK.DataSource = pm.GetListPhieuMuonbyPage(1, 1); } }
private void txtCTMaPhieuMuon_TextChanged(object sender, EventArgs e) { try { PhieuMuonDAO pm = new PhieuMuonDAO(); DateTime dt = new DateTime(); dt = pm.GetTimeNgayMuonByMaPhieu(txtCTMaPhieuMuon.Text); dateTimeCTMuonMuon.Value = dt; dt = pm.GetTimeNgayTraByMaPhieu(txtCTMaPhieuMuon.Text); dateTimeCTTraMuon.Value = dt; } catch { } }
private void XoaNV_Click(object sender, EventArgs e) { string manv = txtMaNV.Text; PhieuMuonDAO pm = new PhieuMuonDAO(); NhanVienDAO nv = new NhanVienDAO(); pm.DeletePhieuMuonByMaNV(manv); if (nv.DeleteNhanVien(manv)) { MessageBox.Show("Xóa thành công"); ShowNhanVien(); } else { MessageBox.Show("có lỗi khi xóa nv"); } }
private void txtPage_TextChanged(object sender, EventArgs e) { PhieuMuonDAO pm = new PhieuMuonDAO(); if (ckhQuaHan.Checked == false) { PhanTrang(); int nowPage = int.Parse(txtPage.Text); listTK.DataSource = pm.GetListPhieuMuonbyPage(nowPage, 0); } else if (ckhQuaHan.Checked == true) { PhanTrang(); int nowPage = int.Parse(txtPage.Text); listTK.DataSource = pm.GetListPhieuMuonbyPage(nowPage, 1); } }
private void btnGiaHan_Click(object sender, EventArgs e) { string maphieu = txtCTMaPhieuMuon.Text; DateTime giahan = dateTimeCTTraMuon.Value.AddMonths(1); if (MessageBox.Show(string.Format("Bạn có muốn Gia hạn thêm cho Mã phiếu: {0} đến ngày: {1}", maphieu, giahan.ToString()), "Thông báo", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK) { PhieuMuonDAO pm = new PhieuMuonDAO(); if (pm.GiaHan(maphieu, giahan)) { MessageBox.Show("Gia Hạn thành công"); ShowMuon(); } else { MessageBox.Show("Gia hạn không thành công"); } } }
void SearchByMaSV(string masv) { PhieuMuonDAO pm = new PhieuMuonDAO(); addColumPhieuMuon(); List <PhieuMuon> list = pm.GetListPhieuMuonByMaSV(masv); foreach (PhieuMuon item in list) { ListViewItem lsv = new ListViewItem(item.MaPhieuMuon.ToString()); lsv.SubItems.Add(item.MaDG.ToString()); lsv.SubItems.Add(item.MaSach.ToString()); lsv.SubItems.Add(item.SoLuong.ToString()); lsv.SubItems.Add(item.NgayMuon.ToString()); lsv.SubItems.Add(item.NgayTra.ToString()); lvSearch.Items.Add(lsv); } taohang(); }
private void btnTra_Click(object sender, EventArgs e) { string maphieu = txtCTMaPhieuMuon.Text; string madg = (cbMaDGMuon.SelectedItem as DocGia).MaDG; int soluong = (int)numSLMuon.Value; string masach = txtMaSachMuon.Text; PhieuMuonDAO pm = new PhieuMuonDAO(); if (MessageBox.Show(string.Format("Bạn có muốn trả cuốn sách: {0} của độc giả: {1} ,SL:{2}", masach, madg, soluong.ToString()), "Thông báo", MessageBoxButtons.OKCancel) == System.Windows.Forms.DialogResult.OK) { if (pm.TraSach(masach, maphieu, soluong)) { MessageBox.Show("Trả thành công"); ShowMuon(); } else { MessageBox.Show("Có lỗi khi trả"); } } }
void showTkMuonAll() { PhieuMuonDAO pm = new PhieuMuonDAO(); listTK.DataSource = pm.GetListPhieuMuonbyPage(1, 0); string query = "Select count(*) from PhieuMuon Where TrangThaiTong=0"; DateTime dt = DateTime.Now; string query1 = "Select count(*) from PhieuMuon Where TrangThaiTong=0 and NgayTra < '" + dt.ToString() + "'"; int sodongquahan = pm.GetSoLuong(query1); int sodong = pm.GetSoLuong(query); thanhtrangthai.Items[0].Text += sodong.ToString(); thanhtrangthai.Items[1].Text += sodongquahan.ToString(); foreach (DataGridViewRow row in dgvThongKe.Rows) { if (row.Cells[7].Value.ToString() == "Quá hạn") { row.DefaultCellStyle.BackColor = Color.Red; } } }
public static IList LocPhieuMuonByIDDocGia(int idDocGia) { return(PhieuMuonDAO.LocPhieuMuonByIDDocGia(idDocGia)); }
public static IList LocPhieuMuon(int idDocGia, DateTime ngayMuon) { return(PhieuMuonDAO.LocPhieuMuon(idDocGia, ngayMuon)); }
public static IList LoadPhieuMuon() { return(PhieuMuonDAO.LoadPhieuMuon()); }
public static DataTable LayTTSach(string MaSach) { return(PhieuMuonDAO.LayTTSach(MaSach)); }
void ShowMuon() { PhieuMuonDAO pm = new PhieuMuonDAO(); listMuon.DataSource = pm.GetListPhieuMuon(); }
public static int XoaPhieuMuon(int MaPhieu) { return(PhieuMuonDAO.XoaPhieuMuon(MaPhieu)); }
public static int XoaChiTiet(int MaPhieu) { return(PhieuMuonDAO.XoaChiTiet(MaPhieu)); }
public void Insert(PhieuMuonDTO phMuon) { PhieuMuonDAO.Insert(phMuon); }
public static IList LocPhieuMuonByNgay(DateTime ngayMuon) { return(PhieuMuonDAO.LocPhieuMuonByNgay(ngayMuon)); }
public static DataTable LayData(string proc, string SoThe) { return(PhieuMuonDAO.LayData(proc, SoThe)); }
public static DataTable LayTTDG(string SoThe) { return(PhieuMuonDAO.LayTTDG(SoThe)); }
public static int ThemPhieuMuon(string SoThe, DateTime NgayMuon, DateTime NgayTra, string MaTT) { return(PhieuMuonDAO.ThemPhieuMuon(SoThe, NgayMuon, NgayTra, MaTT)); }
public static int ThemChiTiet(int Macs, int MaPhieu) { return(PhieuMuonDAO.ThemChiTiet(Macs, MaPhieu)); }
public static DataTable GetBook(int MaDG) { return(PhieuMuonDAO.GetBook(MaDG)); }
public static DataTable LoadDgvSach(string SoThe, string MaPhieu) { return(PhieuMuonDAO.LoadDgvSach(SoThe, MaPhieu)); }
public static DataTable KiemTraNgayTra(string SoThe) { return(PhieuMuonDAO.KiemTraNgayTra(SoThe)); }
public static int SuaPhieuMuon(int MaPhieu, string SoThe, DateTime NgayMuon, DateTime NgayTra, string MaTT) { return(PhieuMuonDAO.SuaPhieuMuon(MaPhieu, SoThe, NgayMuon, NgayTra, MaTT)); }