private void cbMaThe_MouseClick(object sender, MouseEventArgs e)
{
DataTable dt = Sql_MuonSach.SelectMaThe();
cbMaThe.DataSource = dt;
cbMaThe.DisplayMember = "MaThe";
cbMaThe.ValueMember = "MaThe";
}
private void TraSach_Load(object sender, EventArgs e)
{
DataTable dt = Sql_MuonSach.SelectMaThe();
if (dt.Rows.Count <= 0)
{
MessageBox.Show("Chưa có đọc giả nào mượn sách!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
cbMaThe.DataSource = dt;
cbMaThe.DisplayMember = "MaThe";
cbMaThe.ValueMember = "MaThe";
}
}
public static void Giam_SLSACH(string maSach)
{
Sql_MuonSach.Giam_SLSACH(maSach);
}
public static int SoSachDaMuon(string maDG)
{
return(Sql_MuonSach.SoSachDaMuon(maDG));
}
public static bool SachDaMuon(string maDG, string maSach)
{
return(Sql_MuonSach.SachDaMuon(maDG, maSach));
}
public static DataTable ThongTinDocGia(string key)
{
return(Sql_MuonSach.ThongTinDocGia(key));
}
public static bool KiemTraSachDaMuon(string maThe, string maSach)
{
return(Sql_MuonSach.KiemTraSachDaMuon(maThe, maSach));
}
public static bool KiemTraDocGia(string maThe)
{
return(Sql_MuonSach.KiemTraDocGia(maThe));
}
public static DataTable TimKiemSach(string key)
{
return(Sql_MuonSach.TimKiemSach(key));
}
public static void MuonSach(En_MuonSach s)
{
Sql_MuonSach.MuonSach(s);
}
