private void textBoxX3_TextChanged(object sender, EventArgs e)
{
string TimKiemTS = @"select TenSach,TacGia,NXB from SACH where TenSach LIKE N'%" + textBoxX3.Text + "%'";
DataTable dt = DatabaseService.getDataTable(TimKiemTS);
dataSach.DataSource = dt;
}
// Load Sách
public void Load_DataSach()
{
string str = @"select TenSach,TacGia,NXB from SACH";
DataTable dt = DatabaseService.getDataTable(str);
dataSach.DataSource = dt;
}
private void btnDangNhap_Click(object sender, EventArgs e)
{
if (txtTaiKhoan.Text == "" || txtMatKhau.Text == "")
{
MessageBox.Show("Bạn chưa nhập tên đăng nhập hoặc mật khẩu!", "Thông báo");
return;
}
DataTable dt = DatabaseService.getDataTable("Select * from NGUOIDUNG where ID = '" + txtTaiKhoan.Text + "' and Password = '******'");
if (dt.Rows.Count > 0)
{
MessageBox.Show("Xin chào: " + txtTaiKhoan.Text + "!\nBạn đã đăng nhập thành công!", "Thông báo");
this.Hide();
Form main = new frmMain("admin", "admin");
main.Show();
}
else
{
MessageBox.Show("Đăng nhập không thành công!", "Thông báo");
txtTaiKhoan.Clear();
txtMatKhau.Clear();
txtTaiKhoan.Focus();
}
}
// Load Ngày Mượn
public void Load_Ngay()
{
string sqlcboxSup_ = "select * from CHITIETHOADON where MaPM='" + cboxMaPM.Text + "'"; // tới đây!!
cboxNgayMuon.DisplayMember = "NgayThue";
cboxNgayMuon.DataSource = DatabaseService.getDataTable(sqlcboxSup_);
}
// Load ĐG
public void Load_cboxDG()
{
string dt = "select * from DOCGIA";
cboxMaDG.DisplayMember = "MaDG";
cboxMaDG.DataSource = DatabaseService.getDataTable(dt);
}
private void txtTim_TextChanged(object sender, EventArgs e)
{
string TimKiemTS = @"select * from TACGIA where TenTG LIKE N'%" + txtTim.Text + "%'";
DataTable dt = DatabaseService.getDataTable(TimKiemTS);
dataTacGia.DataSource = dt;
}
// Load ĐG
public void Load_cboxTenDG()
{
string dt = "select * from DOCGIA where MaDG='" + cboxMaDG.Text + "'";
cboxTenDG.DisplayMember = "TenDG";
cboxTenDG.DataSource = DatabaseService.getDataTable(dt);
}
private void textBoxX2_TextChanged(object sender, EventArgs e)
{
string TimKiemTS = @"select TenTL from THELOAI where TenTL LIKE N'%" + textBoxX2.Text + "%'";
DataTable dt = DatabaseService.getDataTable(TimKiemTS);
dataTheLoai.DataSource = dt;
}
public void Load_Data()
{
string str = @"select * from TACGIA";
DataTable dt = DatabaseService.getDataTable(str);
dataTacGia.DataSource = dt;
}
private void txtTim_TextChanged(object sender, EventArgs e)
{
string TimKiemTS = @"select * from NGUOIDUNG where ID LIKE N'%" + txtTim.Text + "%'";
DataTable dt = DatabaseService.getDataTable(TimKiemTS);
dataNguoiDung.DataSource = dt;
}
public void Load_Data()
{
string str = @"select * from NGUOIDUNG";
DataTable dt = DatabaseService.getDataTable(str);
dataNguoiDung.DataSource = dt;
}
public void Load_Data()
{
string str = @"select * from NXB";
DataTable dt = DatabaseService.getDataTable(str);
dataNXB.DataSource = dt;
}
// Load TL Sách
public void Load_dataTL()
{
string str = @"select TenTL from THELOAI";
DataTable dt = DatabaseService.getDataTable(str);
dataTheLoai.DataSource = dt;
}
// Load Mã Phiếu Mượn
public void Load_cboxPM()
{
string dt = "select * from HOADON where MaDG='" + cboxMaDG.Text + "'";
cboxMaPM.DisplayMember = "MaPM";
cboxMaPM.DataSource = DatabaseService.getDataTable(dt);
}
public void Load_Muon()
{
//string Muon = @"select MaSach,TenSach from tblSach where MaSach=(select MaSach from tblChiTietMuon where tblChiTietMuon.MaPM='"+cboxMaPM.Text+"' and tblChiTietMuon.NgayThue='"+cboxNgayMuon.Text+"')";
string Muon = @"select MaSach,TenSach from SACH where MaSach=( select MaSach from CHITIETHOADON where (CHITIETHOADON.MaPM='" + cboxMaPM.Text + "' and CHITIETHOADON.NgayThue='" + cboxNgayMuon.Text + "' and SACH.MaSach=CHITIETHOADON.MaSach))";
//MessageBox.Show(Muon);
DataTable dt = DatabaseService.getDataTable(Muon);
dataSach.DataSource = dt;
}
private void frmRPDSSach_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt = DatabaseService.getDataTable("select * from sach");
RPDSSach rp = new RPDSSach();
rp.SetDataSource(dt);
crystalReportViewer1.ReportSource = rp;
}
private void dataTheLoai_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e)
{
string s = "";
try
{
DataGridViewRow row = new DataGridViewRow();
row = dataTheLoai.Rows[e.RowIndex];
s = row.Cells[0].Value.ToString();
//MessageBox.Show(s);
string str = @"select TenSach,TacGia,NXB from SACH where TheLoai=N'" + s + "'";
DataTable dt = DatabaseService.getDataTable(str);
dataSach.DataSource = dt;
}
catch (Exception) { }
}
private void btnTheLoai_Click(object sender, EventArgs e)
{
string MaPM;
string sql = " select MaPM from HOADON";
DataTable tb = DatabaseService.getDataTable(sql);
int s = tb.Rows.Count;
if (tb.Rows.Count < 1)
{
MaPM = "PM0001";
}
else
{
MaPM = sinhMa();
}
txtMaPM.Text = MaPM;
}
private void buttonX1_Click(object sender, EventArgs e)
{
string currTime = DateTime.Now.Date.ToShortDateString();
if (Convert.ToString(listBox1.SelectedItem) == "Báo cáo tên 10 đầu sách được mượn nhiều nhất.")
{
string str = @"SELECT TOP(10) MaSach,TenSach,TacGia,NXB,SLMuon FROM SACH ORDER BY SLMuon DESC;";
DataTable dt = DatabaseService.getDataTable(str);
dataHienThi.DataSource = dt;
}
//
if (Convert.ToString(listBox1.SelectedItem) == "Danh mục sách không được mượn lần nào.")
{
string str = @"SELECT MaSach,TenSach,TacGia,NXB,SLMuon FROM SACH where SLMuon=0";
DataTable dt = DatabaseService.getDataTable(str);
dataHienThi.DataSource = dt;
}
//
if (Convert.ToString(listBox1.SelectedItem) == "Danh mục sách đang được mượn.")
{
try
{
string str = @"select MaSach,TenSach,TacGia,NXB from SACH where MaSach=(select MaSach from CHITIETHOADON where CHITIETHOADON.MaSach=SACH.MaSach)";
DataTable dt = DatabaseService.getDataTable(str);
dataHienThi.DataSource = dt;
}
catch (Exception) { }
//MessageBox.Show(DateTime.Now.Date.ToShortDateString());
}
//
if (Convert.ToString(listBox1.SelectedItem) == "Danh mục sách đã quá hạn trả.")
{
string str = @"SELECT MaSach,TenSach,TacGia,NXB from SACH where MaSach=(select MaSach from CHITIETHOADON where NgayTra <'" + currTime + "')";
DataTable dt = DatabaseService.getDataTable(str);
dataHienThi.DataSource = dt;
}
if (Convert.ToString(listBox1.SelectedItem) == "Danh sách sinh viên bị phạt vì trả quá hạn.")
{
string str = @"select * from DOCGIA where MaDG=(select MaDG from HOADON,CHITIETHOADON where HOADON.MaPM=CHITIETHOADON.MaPM and CHITIETHOADON.NgayTra<'" + currTime + "')";
DataTable dt = DatabaseService.getDataTable(str);
dataHienThi.DataSource = dt;
}
}
public void Load_cboxTheLoai()
{
string dt = "select * from THELOAI";
cboxTheLoai.DisplayMember = "TenTL";
cboxTheLoai.DataSource = DatabaseService.getDataTable(dt);
}
private void txtTim_TextChanged(object sender, EventArgs e)
{
string TimKiemTS = @"select * from SACH where TenSach LIKE N'%" + txtTim.Text + "%' or TacGia LIKE N'%" + txtTim.Text + "%' or TheLoai LIKE N'%" + txtTim.Text + "%'";
DataTable dt = DatabaseService.getDataTable(TimKiemTS);
dataSach.DataSource = dt;
}
// Load Tác Giả
public void Load_cboxTacGia()
{
string dt = "select * from TACGIA";
cboxTacGia.DisplayMember = "TenTG";
cboxTacGia.DataSource = DatabaseService.getDataTable(dt);
}
public void Load_cboxNXB()
{
string dt = "select * from NXB";
cboxNXB.DisplayMember = "TenNXB";
cboxNXB.DataSource = DatabaseService.getDataTable(dt);
}
