private void frmCTPhieuMuon_Load(object sender, EventArgs e) { tblSach = new XLSach(); tblPhieuMuon = new XLPhieuMuon(); tblCTPhieuMuon = new XLCTPhieuMuon(); rdTheoMaPM.Checked = true; daCTPM = new SqlDataAdapter("Select * from CTPHIEUMUON", XLCTPhieuMuon.cnnStr); try { daCTPM.Fill(tblCTPhieuMuon); } catch (SqlException ex) { MessageBox.Show(ex.ToString()); } loadPM(); loadMaSach(); cbMaPM.DataBindings.Add("SelectedValue", tblCTPhieuMuon, "MaPM", true); cbMaSach.DataBindings.Add("SelectedValue", tblCTPhieuMuon, "MaSach", true); nudSL.DataBindings.Add("text", tblCTPhieuMuon, "SoLuong", true); var cmb = new SqlCommandBuilder(daCTPM); DSCTPM = this.BindingContext[tblCTPhieuMuon]; enabledButton(); dgvCTPM.AutoGenerateColumns = false; dgvCTPM.DataSource = tblCTPhieuMuon; }
private void frmSach_Load(object sender, EventArgs e) { tblSach = new XLSach(); tblNCC = new XLNhaCungCap(); loadCTSach(); loadNCC(); rdTheoMa.Checked = true; daSach = new SqlDataAdapter("Select * from SACH", XLSach.cnnStr); daNCC = new SqlDataAdapter("Select * from NHACUNGCAP", XLNhaCungCap.cnnStr); try { daSach.Fill(tblSach); daNCC.Fill(tblNCC); } catch (SqlException ex) { MessageBox.Show(ex.ToString()); } var cmb = new SqlCommandBuilder(daSach); txtMaSach.DataBindings.Add("text", tblSach, "MaSach", true); txtNXB.DataBindings.Add("text", tblSach, "NXB", true); txtTacGia.DataBindings.Add("text", tblSach, "TacGia", true); txtTenSach.DataBindings.Add("text", tblSach, "TenSach", true); txtTheLoai.DataBindings.Add("text", tblSach, "TheLoai", true); nudSLTon.DataBindings.Add("value", tblSach, "SLTon", true); pSach.DataBindings.Add("Image", tblSach, "Hinh", true); cbNCC.DataBindings.Add("SelectedValue", tblSach, "MaNCC", true); DSSach = this.BindingContext[tblSach]; enabledButton(); dgvTTSach.AutoGenerateColumns = false; dgvTTSach.DataSource = tblSach; }
private void frmThongKeSach_Load(object sender, EventArgs e) { string a = "Select count(MaSach) from SACH"; var m = XLSach.Thuc_hien_lenh_tinh_toan(a); txtDauSach.Text = m.ToString(); string b = "Select count(Distinct TheLoai) from SACH"; var n = XLSach.Thuc_hien_lenh_tinh_toan(b); txtTheLoai.Text = n.ToString(); string c = "Select sum(SLTon) from SACH"; var o = XLSach.Thuc_hien_lenh_tinh_toan(c); txtSLSach.Text = o.ToString(); string d = "Select sum(SoLuong) from CTPHIEUMUON"; var p = XLCTPhieuMuon.Thuc_hien_lenh_tinh_toan(d); txtSLSachMuon.Text = p.ToString(); string f = "select a.sa-b.ctpm from(select sum(SLTon) as sa from SACH) as a,(select sum(SoLuong) as ctpm from CTPHIEUMUON) as b"; var q = XLSach.Thuc_hien_lenh_tinh_toan(f); txtSLConLai.Text = q.ToString(); string g = "Select sum(SoLuong) from CTPHIEUMUON inner join PHIEUMUON on CTPHIEUMUON.MaPM=PHIEUMUON.MaPM where datediff(day,PHIEUMUON.NgayTra,Getdate())>0 and PHIEUMUON.TrangThai='False' "; var w = XLPhieuMuon.Thuc_hien_lenh_tinh_toan(g); txtSachQuaHan.Text = w.ToString(); //Ve Bieu Do chSach.Series["Số Lượng Sách"].Points.AddXY("Đầu Sách", txtDauSach.Text); chSach.Series["Số Lượng Sách"].Points.AddXY("Thể Loại", txtTheLoai.Text); chSach.Series["Số Lượng Sách"].Points.AddXY("Tổng Sách", txtSLSach.Text); chSach.Series["Số Lượng Sách"].Points.AddXY("Đã Mượn", txtSLSachMuon.Text); chSach.Series["Số Lượng Sách"].Points.AddXY("Còn Lại", txtSLConLai.Text); chSach.Series["Số Lượng Sách"].Points.AddXY("Quá Hạn", txtSachQuaHan.Text); string query = "select PHIEUMUON.MaPM,PHIEUMUON.MaDG,CTPHIEUMUON.MaSach,SACH.TenSach,CTPHIEUMUON.SoLuong,datediff(day,PHIEUMUON.NgayTra,GETDATE()) as SoNgayQH from PHIEUMUON inner join CTPHIEUMUON on PHIEUMUON.MaPM = CTPHIEUMUON.MaPM inner join SACH on CTPHIEUMUON.MaSach = SACH.MaSach where PHIEUMUON.TrangThai = 'False' and datediff(day, PHIEUMUON.NgayTra, GETDATE())> 0"; tblSachQuaHan = new DataTable(); rdTheoMS.Checked = true; SqlDataAdapter da = new SqlDataAdapter(query, XLBang.cnnStr); try { da.Fill(tblSachQuaHan); } catch (SqlException ex) { MessageBox.Show(ex.ToString()); } DSPM = this.BindingContext[tblSachQuaHan]; dgvDSSQH.AutoGenerateColumns = false; dgvDSSQH.DataSource = tblSachQuaHan; }
private void frmMuonTra_Load(object sender, EventArgs e) { tblPhieuMuon = new XLPhieuMuon(); tblCTPhieuMuon = new XLCTPhieuMuon(); tblNhanVien = new XLNhanVien(); tblDocGia = new XLDocGia(); tblSach = new XLSach(); rdTheoMaDG.Checked = true; loadDocGia(); loadNhanVien(); daPhieuMuon = new SqlDataAdapter("Select * from PHIEUMUON", XLPhieuMuon.cnnStr); daCTPhieuMuon = new SqlDataAdapter("Select * from CTPHIEUMUON", XLCTPhieuMuon.cnnStr); daDocGia = new SqlDataAdapter("Select * from DOCGIA", XLDocGia.cnnStr); daNhanVien = new SqlDataAdapter("Select * from NHANVIEN", XLNhanVien.cnnStr); daSach = new SqlDataAdapter("Select * from SACH", XLSach.cnnStr); try { daCTPhieuMuon.Fill(tblCTPhieuMuon); } catch (SqlException ex) { MessageBox.Show(ex.ToString()); } var cmb = new SqlCommandBuilder(daPhieuMuon); cbMaDG.DataBindings.Add("SelectedValue", tblPhieuMuon, "MaDG", true); cbMaNV.DataBindings.Add("SelectedValue", tblPhieuMuon, "MaNV", true); txtMaPM.DataBindings.Add("text", tblPhieuMuon, "MaPM", true); dtMuon.DataBindings.Add("text", tblPhieuMuon, "NgayMuon", true); dtTra.DataBindings.Add("text", tblPhieuMuon, "NgayTra", true); rdDaTra.DataBindings.Add("checked", tblPhieuMuon, "TrangThai", true); DSPM = this.BindingContext[tblPhieuMuon]; enabledButton(); dgvDSPM.AutoGenerateColumns = false; dgvDSPM.DataSource = tblPhieuMuon; }