private void ckbChuaTra_CheckedChanged(object sender, EventArgs e)
{
txtPage.Text = "1";
PhieuMuonDAO pm = new PhieuMuonDAO();
if (ckhQuaHan.Checked == false)
{
listTK.DataSource = pm.GetListPhieuMuonbyPage(1, 0);
}
else if (ckhQuaHan.Checked == true)
{
listTK.DataSource = pm.GetListPhieuMuonbyPage(1, 1);
}
}
private void txtPage_TextChanged(object sender, EventArgs e)
{
PhieuMuonDAO pm = new PhieuMuonDAO();
if (ckhQuaHan.Checked == false)
{
PhanTrang();
int nowPage = int.Parse(txtPage.Text);
listTK.DataSource = pm.GetListPhieuMuonbyPage(nowPage, 0);
}
else if (ckhQuaHan.Checked == true)
{
PhanTrang();
int nowPage = int.Parse(txtPage.Text);
listTK.DataSource = pm.GetListPhieuMuonbyPage(nowPage, 1);
}
}
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;
}
}
}
