int PhanTrang()
{
PhieuMuonDAO pm = new PhieuMuonDAO();
int sodong = 0;
if (ckhQuaHan.Checked == false)
{
string query = "Select count(*) from PhieuMuon Where TrangThaiTong=0";
sodong = pm.GetSoLuong(query);
}
else if (ckhQuaHan.Checked == true)
{
DateTime dt = DateTime.Now;
string query = "Select count(*) from PhieuMuon Where TrangThaiTong=0 and NgayTra < '" + dt.ToString() + "'";
sodong = pm.GetSoLuong(query);
}
int sotrang = sodong / 10;
if (sodong % 10 != 0)
{
sotrang += 1;
}
return(sotrang);
}
void showTkMuonAll()
{
PhieuMuonDAO pm = new PhieuMuonDAO();
listTK.DataSource = pm.GetListPhieuMuonbyPage(1, 0);
string query = "Select count(*) from PhieuMuon Where TrangThaiTong=0";
DateTime dt = DateTime.Now;
string query1 = "Select count(*) from PhieuMuon Where TrangThaiTong=0 and NgayTra < '" + dt.ToString() + "'";
int sodongquahan = pm.GetSoLuong(query1);
int sodong = pm.GetSoLuong(query);
thanhtrangthai.Items[0].Text += sodong.ToString();
thanhtrangthai.Items[1].Text += sodongquahan.ToString();
foreach (DataGridViewRow row in dgvThongKe.Rows)
{
if (row.Cells[7].Value.ToString() == "Quá hạn")
{
row.DefaultCellStyle.BackColor = Color.Red;
}
}
}
