private void frmDocGia_Load(object sender, EventArgs e) { tblDocGia = new XLDocGia(); rdTheoMa.Checked = true; daDocGia = new SqlDataAdapter("Select * from DOCGIA", XLDocGia.cnnStr); try { daDocGia.Fill(tblDocGia); } catch (SqlException ex) { MessageBox.Show(ex.ToString()); } var cmb = new SqlCommandBuilder(daDocGia); txtMaDG.DataBindings.Add("text", tblDocGia, "MaDG", true); txtTenDG.DataBindings.Add("text", tblDocGia, "TenDG", true); txtDiaChi.DataBindings.Add("text", tblDocGia, "DiaChi", true); txtSDT.DataBindings.Add("text", tblDocGia, "SDT", true); dtNgaySinh.DataBindings.Add("text", tblDocGia, "NgaySinh", true); rdNam.DataBindings.Add("checked", tblDocGia, "GioiTinh", true); pDocGia.DataBindings.Add("Image", tblDocGia, "Hinh", true); DSDG = this.BindingContext[tblDocGia]; enabledButton(); dgvTTDocGia.AutoGenerateColumns = false; dgvTTDocGia.DataSource = tblDocGia; }
private void frmThongKeDocGia_Load(object sender, EventArgs e) { string a = "Select count(*) from DOCGIA"; var m = XLDocGia.Thuc_hien_lenh_tinh_toan(a); txtSLDG.Text = m.ToString(); string b = "Select count(distinct MaDG) from PHIEUMUON"; var n = XLPhieuMuon.Thuc_hien_lenh_tinh_toan(b); txtSLDGDM.Text = n.ToString(); string c = "Select Count(distinct MaDG) from PHIEUMUON where DATEDIFF(day,NgayTra,getdate())>0 and TrangThai='False'"; var o = XLPhieuMuon.Thuc_hien_lenh_tinh_toan(c); txtSLDGQH.Text = o.ToString(); string d = "Select count(*) from DOCGIA where MaDG not in (Select distinct MaDG from PHIEUMUON)"; var p = XLDocGia.Thuc_hien_lenh_tinh_toan(d); //Ve bieu do ChDG.Series["Số Lượng Độc Giả"].Points.AddXY("Đã Mượn", txtSLDGDM.Text); ChDG.Series["Số Lượng Độc Giả"].Points.AddXY("Mượn Quá Hạn", txtSLDGQH.Text); ChDG.Series["Số Lượng Độc Giả"].Points.AddXY("Chưa Mượn", p.ToString()); string query = "select PHIEUMUON.MaPM,PHIEUMUON.MaDG,DOCGIA.TenDG,sum(CTPHIEUMUON.SoLuong) as TongSoLuong,datediff(day,PHIEUMUON.NgayTra,GETDATE()) as SoNgayQH from PHIEUMUON inner join CTPHIEUMUON on PHIEUMUON.MaPM = CTPHIEUMUON.MaPM inner join DOCGIA on DOCGIA.MaDG = PHIEUMUON.MaDG where PHIEUMUON.TrangThai = 'False' and datediff(day, PHIEUMUON.NgayTra, GETDATE())> 0 group by PHIEUMUON.MaPM,PHIEUMUON.MaDG,DOCGIA.TenDG,PHIEUMUON.NgayTra"; tblDGQuaHan = new DataTable(); rdTheoMDG.Checked = true; SqlDataAdapter da = new SqlDataAdapter(query, XLBang.cnnStr); try { da.Fill(tblDGQuaHan); } catch (SqlException ex) { MessageBox.Show(ex.ToString()); } DSDGQH = this.BindingContext[tblDGQuaHan]; dgvDSDGQH.AutoGenerateColumns = false; dgvDSDGQH.DataSource = tblDGQuaHan; }
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; }