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