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