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