private void btLuu_Click(object sender, EventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { bool tmt = false; var ListMaTG = from kq in qltv.TacGias select kq.MaTacGia; foreach (var item in ListMaTG) { if (cbbMaTG.Text == item) { tmt = true; } } if (tmt == true) { try { qltv.Database.ExecuteSqlCommand($"exec ThemSangTac '{QuanLyDauSach.MaDS}','{cbbMaTG.Text}',{txbViTriVaiTro.Text}"); MessageBox.Show("Them thanh cong tac gia"); Load_TacGia(); TrangThaiBanDau(); } catch (Exception) { MessageBox.Show("Tac gia nay da ton tai"); } } else { qltv.Database.ExecuteSqlCommand($"exec ThemTacGia '{cbbMaTG.Text}',N'{txbTenTG.Text}','{dTP_NgaySinhTG.Text}'"); qltv.Database.ExecuteSqlCommand($"exec ThemSangTac '{QuanLyDauSach.MaDS}','{cbbMaTG.Text}',{txbViTriVaiTro.Text}"); MessageBox.Show("Them thanh cong tac gia"); Load_TacGia(); TrangThaiBanDau(); } } }
public void load_MuonTra() { Model_QuanLi_ThuVien MtV1 = new Model_QuanLi_ThuVien(); var lstMuonTra = MtV1.ThongTinMuons.SqlQuery("select * from ThongTinMuon").ToList(); dtgrdView_Muon.DataSource = lstMuonTra; }
private void dtgv_loadDG_CellClick(object sender, DataGridViewCellEventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { TrangThaiBanDau(); int i = e.RowIndex; txbMaDG.Text = dtgv_loadDG.Rows[i].Cells[0].Value.ToString(); txbTenDG.Text = dtgv_loadDG.Rows[i].Cells[1].Value.ToString(); dtpNgaySinhDG.Text = dtgv_loadDG.Rows[i].Cells[2].Value.ToString(); txbDonViDG.Text = dtgv_loadDG.Rows[i].Cells[3].Value.ToString(); txbSdtDG.Text = dtgv_loadDG.Rows[i].Cells[4].Value.ToString(); dtpNgayDK.Text = dtgv_loadDG.Rows[i].Cells[5].Value.ToString(); dtpNgayHH.Text = dtgv_loadDG.Rows[i].Cells[6].Value.ToString(); TaiKhoanDG TK = qltv.TaiKhoanDGs.Where(p => p.MaDocGia == txbMaDG.Text).FirstOrDefault(); txbTaiKhoanDG.Text = TK.TenDangNhap; txbMatKhauDG.Text = TK.MatKhau; if (dtgv_loadDG.Rows[i].Cells[7].Value == null) { txbLoaiDG.Text = "NULL"; } else { txbLoaiDG.Text = dtgv_loadDG.Rows[i].Cells[7].Value.ToString(); } } }
private void giaHanSach() { if (Hieusongay(dtpNgayMuon.Text, dtpNgayTra.Text) > 0) { //---- tiến hành up date ngày tháng luôn Model_QuanLi_ThuVien MtV2 = new Model_QuanLi_ThuVien(); SqlParameter[] idParam = { new SqlParameter { ParameterName = "NgayMuon", Value = dtpNgayMuon.Text }, new SqlParameter { ParameterName = "NgayHanTra", Value = dtpNgayTra.Text }, new SqlParameter { ParameterName = "MaMuonTra", Value = MaMT } }; int i = MtV2.Database.ExecuteSqlCommand("exec GiaHan @NgayMuon,@NgayHanTra,@MaMuonTra", idParam); if (i < 0) { MessageBox.Show("Xảy ra lỗi , thông tin mượn trả không có trong hệ thống.", "Thông Báo"); } else { MessageBox.Show("Gia hạn thành công.", "Thông Báo"); this.Close(); } } else { MessageBox.Show("Xem lại thời gian cho mượn.", "Thông Báo"); } }
public ReportViPham(string lydo, int sotien, string MaDG) { InitializeComponent(); // đặt chế độ hiển thị ở Local reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Local; reportViewer1.LocalReport.ReportEmbeddedResource = "Quan_Ly_Thu_Vien.XuLyViPham.rdlc"; // chế độ xem report reportViewer1.SetDisplayMode(Microsoft.Reporting.WinForms.DisplayMode.PrintLayout); reportViewer1.ZoomMode = Microsoft.Reporting.WinForms.ZoomMode.Percent; reportViewer1.ZoomPercent = 100; //// import dữ liệu tên độc giả và đơn vị Model_QuanLi_ThuVien MtV1 = new Model_QuanLi_ThuVien(); SqlParameter idParam = new SqlParameter { ParameterName = "MaDocGia", Value = MaDG }; var lstMuonTra = MtV1.ThongTinDocGias.SqlQuery("ThongTinCaNhan @MaDocGia", idParam).ToList(); /// fill data vào trong báo cáo Microsoft.Reporting.WinForms.ReportParameter[] rParrams = new Microsoft.Reporting.WinForms.ReportParameter[] { new Microsoft.Reporting.WinForms.ReportParameter("HoTen", lstMuonTra[0].TenDocGia.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("DonVi", lstMuonTra[0].DonVi.ToString()), new Microsoft.Reporting.WinForms.ReportParameter("LyDo", lydo), new Microsoft.Reporting.WinForms.ReportParameter("SoTien", sotien.ToString()) }; reportViewer1.LocalReport.SetParameters(rParrams); reportViewer1.RefreshReport(); }
void Load_ThongKeDG() { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { int SoLuongDG_DangMuon = 0; var listDG = qltv.DocGias.ToList(); txbSoLuongDG.Text = listDG.Count.ToString(); var listMuonTra = from kq in qltv.MuonTras where kq.DaTra == false select kq.MaDocGia; //var listMuonTraQuaHan = from kq in qltv.MuonTras where kq.DaTra == false && kq. select kq.MaDocGia; foreach (var itemlistDG in listDG) { foreach (var itemlistMuonTra in listMuonTra) { if (itemlistDG.MaDocGia == itemlistMuonTra) { SoLuongDG_DangMuon++; break; } } } txbSoLuongDG_DangMuon.Text = SoLuongDG_DangMuon.ToString(); var listViPham = from kq in qltv.XuLyViPhams select kq.MaDocGia; txbSoLuotViPham.Text = listViPham.ToList().Count.ToString(); } }
private void txtNDTimKiem_TextChanged(object sender, EventArgs e) { setControlsMuon(false); btnNhap.Enabled = false; btnChoMuon0.Enabled = false; btnHuy0.Enabled = false; if (radMaDG.Checked) { SqlParameter idParam = new SqlParameter { ParameterName = "NoiDung", Value = txtNDTimKiem.Text }; Model_QuanLi_ThuVien MtV1 = new Model_QuanLi_ThuVien(); var lstTimkiemDocGia = MtV1.ThongTinMuonTras.SqlQuery("TimKiemMaDG @NoiDung", idParam).ToList(); dtgrdView_Muon.DataSource = lstTimkiemDocGia; dtgrdView_Muon.AutoGenerateColumns = false; } else if (radMaSach.Checked) { SqlParameter idParam = new SqlParameter { ParameterName = "NoiDung", Value = txtNDTimKiem.Text }; Model_QuanLi_ThuVien MtV1 = new Model_QuanLi_ThuVien(); var lstTimkiemSach = MtV1.ThongTinMuonTras.SqlQuery("TimKiemMaSach @NoiDung", idParam).ToList(); dtgrdView_Muon.DataSource = lstTimkiemSach; dtgrdView_Muon.AutoGenerateColumns = false; } }
private void cbbMaVT_TextChanged(object sender, EventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { bool tmt = false; var listMaVT = from kq in qltv.ViTriSaches select kq.MaViTri; foreach (var item in listMaVT) { if (cbbMaVT.Text == item) { tmt = true; } } if (tmt == true) { ViTriSach VTS = qltv.ViTriSaches.Where(p => p.MaViTri == cbbMaVT.Text).SingleOrDefault(); txbTenGiaSach.Text = VTS.TenGiaSach; txbTang.Text = VTS.Tang; txbNgan.Text = VTS.Ngan; txbTenGiaSach.Enabled = false; txbTang.Enabled = false; txbNgan.Enabled = false; } else { txbTenGiaSach.Text = ""; txbTang.Text = ""; txbNgan.Text = ""; txbTenGiaSach.Enabled = true; txbTang.Enabled = true; txbNgan.Enabled = true; } } }
private void btnChoMuon0_Click(object sender, EventArgs e) { { Model_QuanLi_ThuVien MtV2 = new Model_QuanLi_ThuVien(); SqlParameter[] idParam = { new SqlParameter { ParameterName = "MaSach", Value = txbMaCuonSach.Text }, new SqlParameter { ParameterName = "MaDocGia", Value = txbMaDG.Text }, new SqlParameter { ParameterName = "MaNVMuon", Value = Login.MaNguoiDung }, new SqlParameter { ParameterName = "NgayMuon", Value = dtpNgayMuon.Text }, new SqlParameter { ParameterName = "NgayHanTra", Value = dtpNgayTra.Text }, }; // int Check_Sach = MtV2.Database.ExecuteSqlCommand("MuonMoiSach @MaSach,@MaDocGia,@MaNVMuon,@NgayMuon,@NgayHanTra", idParam); int Check_Sach = MtV2.Database.ExecuteSqlCommand("MuonMoiSach @MaSach,@MaDocGia,@MaNVMuon,@NgayMuon,@NgayHanTra", idParam); if (Check_Sach >= 0) { MessageBox.Show("cho mượn sách thành công "); load_TTmuon(); } btnChoMuon0.Enabled = false; } }
private void btLuu_Click(object sender, EventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { bool tmt = false; var ListMaTL = from kq in qltv.TheLoais select kq.MaTheLoai; foreach (var item in ListMaTL) { if (cbbMaTheLoai.Text == item) { tmt = true; } } if (tmt == true) { try { qltv.Database.ExecuteSqlCommand($"exec ThemTheLoaiDauSach '{QuanLyDauSach_NV.MaDS}','{cbbMaTheLoai.Text}',{txbViTriVaiTro.Text}"); MessageBox.Show("Them thanh cong The Loai"); Load_TheLoai(); TrangThaiBanDau(); } catch (Exception) { MessageBox.Show("The loai da ton tai!"); } } else { qltv.Database.ExecuteSqlCommand($"exec ThemTheLoai '{cbbMaTheLoai.Text}',N'{txbTenTheLoai.Text}'"); qltv.Database.ExecuteSqlCommand($"exec ThemTheLoaiDauSach '{QuanLyDauSach_NV.MaDS}','{cbbMaTheLoai.Text}',{txbViTriVaiTro.Text}"); MessageBox.Show("Them thanh cong The Loai"); Load_TheLoai(); TrangThaiBanDau(); } } }
private void cbbMaTG_TextChanged(object sender, EventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { bool tmt = false; var ListMaTG = from kq in qltv.TacGias select kq.MaTacGia; foreach (var item in ListMaTG) { if (cbbMaTG.Text == item) { tmt = true; } } if (tmt == true) { TacGia TG = qltv.TacGias.Where(p => p.MaTacGia == cbbMaTG.Text).SingleOrDefault(); var ViTri = from kq in qltv.SangTacs where kq.MaDauSach == QuanLyDauSach.MaDS && kq.MaTacGia == cbbMaTG.Text select kq.ViTriVaiTro; txbTenTG.Text = TG.TenTacGia; dTP_NgaySinhTG.Text = TG.NgaySinh.ToString(); txbViTriVaiTro.Text = ""; dTP_NgaySinhTG.Enabled = false; txbTenTG.Enabled = false; } else { txbTenTG.Enabled = true; dTP_NgaySinhTG.Enabled = true; txbTenTG.Text = ""; txbViTriVaiTro.Text = ""; dTP_NgaySinhTG.Value = DateTime.Now; } } }
private void cbbMaTheLoai_TextChanged(object sender, EventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { var listMaTheLoai = from kq in qltv.TheLoais select kq.MaTheLoai; bool tmt = false; foreach (var item in listMaTheLoai) { if (cbbMaTheLoai.Text == item) { tmt = true; } } if (tmt == true) { TheLoai TL = qltv.TheLoais.Where(p => p.MaTheLoai == cbbMaTheLoai.Text).SingleOrDefault(); txbTenTheLoai.Enabled = false; txbTenTheLoai.Text = TL.TenTheLoai; txbViTriVaiTro.Text = ""; } else { txbTenTheLoai.Enabled = true; txbTenTheLoai.Text = ""; txbViTriVaiTro.Text = ""; } } }
void Load_ChucVu() { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { var TenCV = from kq in qltv.ChucVus select kq.TenChucVu; cbbChucVu.DataSource = TenCV.ToList(); } }
void Load_DauSach() { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { var ListDS = qltv.ThongTinDauSaches.SqlQuery("exec LoadThongTinDauSach"); dtGV_DauSach.DataSource = ListDS.ToList(); } }
void Load_DSMuon() { Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien(); var lstMuonTra = qltv.ThongTinMuons.SqlQuery("select * from ThongTinMuon").ToList(); dtgrdView_Tra.DataSource = lstMuonTra; txtNDTimKiem.Text = ""; }
public void Load_DG() { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { var listDG = qltv.Database.SqlQuery <ThongTinDocGia>($"exec LoadThongTinDocGia"); dtgv_loadDG.DataSource = listDG.ToList(); } }
private void cbbChucVu_MouseClick(object sender, MouseEventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { var listChucVu = from kq in qltv.ChucVus select kq.TenChucVu; cbbChucVu.DataSource = listChucVu.ToList(); } }
void Load_MaTheLoai() { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { var listMaTheLoai = from kq in qltv.TheLoais select kq.MaTheLoai; cbbMaTheLoai.DataSource = listMaTheLoai.ToList(); } }
void Load_ThongKeDS() { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { var ThongKe = qltv.Database.SqlQuery <ThongKeDauSach>("exec show_ThongKeDauSach "); dtgv_ThongKeDS.DataSource = ThongKe.ToList(); } }
void Load_MaTG() { using (var qltv = new Model_QuanLi_ThuVien()) { var ListMaTG = from kq in qltv.TacGias select kq.MaTacGia; cbbMaTG.DataSource = ListMaTG.ToList(); } }
private void txbTimKiemCS_TextChanged(object sender, EventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { var ListCS = qltv.Database.SqlQuery <TT_CuonSach>($"exec TimKiemCuonSach @MaDauSach='{QuanLyDauSach_NV.MaDS}', @MaSach='{txbTimKiemCS.Text}'"); dtGV_CuonSach.DataSource = ListCS.ToList(); } }
void Load_MaViTri() { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { var listMaVT = from kq in qltv.ViTriSaches select kq.MaViTri; cbbMaVT.DataSource = listMaVT.ToList(); } }
void Load_CuonSach() { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { var ListCS = qltv.Database.SqlQuery <TT_CuonSach>($"exec LoadThongTinCuonSach @MaDauSach='{QuanLyDauSach_NV.MaDS}'"); dtGV_CuonSach.DataSource = ListCS.ToList(); } }
private void btXoa_Click(object sender, EventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { qltv.Database.ExecuteSqlCommand($"exec XoaTheLoai '{QuanLyDauSach_NV.MaDS}','{cbbMaTheLoai.Text}'"); MessageBox.Show("Xoa thanh cong the loai"); Load_TheLoai(); } }
private void btXoa_Click(object sender, EventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { qltv.Database.ExecuteSqlCommand($"exec XoaSangTac '{QuanLyDauSach.MaDS}','{cbbMaTG.Text}'"); MessageBox.Show("Xoa thanh cong tac gia"); Load_TacGia(); } }
void Load_SachDangMuon() { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { SqlParameter param = new SqlParameter { ParameterName = "MaDocGia", Value = Login.MaNguoiDung }; var listCuonSachDangMuon = qltv.Database.SqlQuery <TT_MuonSach_DocGia>($"exec Show_SoSachDocGiaDangMuon @MaDocGia", param); dtGV_SachChoMuon.DataSource = listCuonSachDangMuon.ToList(); } }
private void btLuu_Click(object sender, EventArgs e) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { ChucVu cv = qltv.ChucVus.Where(p => p.TenChucVu == cbbChucVu.Text).FirstOrDefault(); qltv.Database.ExecuteSqlCommand($"exec SuaNhanVien '{txbMaNV.Text}',N'{txbTenNV.Text}','{dTP_NgaySinhNV.Text}','{txbSDTNV.Text}','{cv.MaChucVu}'"); MessageBox.Show("Thay đổi thành công !!!"); btHuy.Visible = false; btLuu.Visible = false; } }
void Load_TacGia() { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { btLuu.Enabled = false; btThem.Enabled = true; btXoa.Enabled = true; var listTg = qltv.Database.SqlQuery <TT_TacGia_DauSach>($"exec LoadThongTinTacGia_CuaDauSach '{QuanLyDauSach.MaDS}'"); dtGV_TacGia.DataSource = listTg.ToList(); } }
void Load_NvChoMuon(string MaNV) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { txbMaNV_Muon.Text = MaNV; NhanVien NV = qltv.NhanViens.Where(p => p.MaNhanVien == MaNV).FirstOrDefault(); ChucVu CV = qltv.ChucVus.Where(p => p.MaChucVu == NV.MaChucVu).FirstOrDefault(); txbTenNV_Muon.Text = NV.HoTen; txbSDTNV_Muon.Text = NV.SDT; txbChucVuNV_Muon.Text = CV.TenChucVu; } }
void Load_CsDangMuon(string MaCS) { using (Model_QuanLi_ThuVien qltv = new Model_QuanLi_ThuVien()) { txbMaSach.Text = MaCS; CuonSach CS = qltv.CuonSaches.Where(p => p.MaSach == MaCS).FirstOrDefault(); DauSach DS = qltv.DauSaches.Where(p => p.MaDauSach == CS.MaDauSach).FirstOrDefault(); txbTenSach.Text = DS.TenDauSach; txbGiaTien.Text = DS.GiaTien.ToString(); ptbAnhCS.Image = ByteToImage((byte[])DS.HinhAnh); } }