private void SuaDangKyCho_Load(object sender, EventArgs e) { Sach dataSach = new Sach(); DocGia dataDocGia = new DocGia(); DataTable dtDocGia = dataDocGia.loadDocGia(); DataTable dtDauSach = dataSach.loadDauSachTuaSach(); ComboboxItem item; string tuaSach = String.Empty; for (int i = 0; i < dtDocGia.Rows.Count; i++) { if (dtDocGia.Rows[i]["Tình trạng"].ToString() != String.Empty && (bool)dtDocGia.Rows[i]["Tình trạng"] == true)//== String.Empty cbxmdg.Items.Add(Convert.ToInt32(dtDocGia.Rows[i]["Mã độc giả"].ToString())); } for (int i = 0; i < dtDauSach.Rows.Count; i++) { //if (dtDauSach.Rows[i]["Tình trạng"].ToString() == String.Empty || (bool)dtDauSach.Rows[i]["Tình trạng"] == false)//== String.Empty //{ //cbxmadausach.Items.Add(Convert.ToInt32(dtDauSach.Rows[i]["Mã đầu sách"].ToString())); item = new ComboboxItem(); item.Text = dtDauSach.Rows[i]["Mã đầu sách"].ToString() + " - " + dtDauSach.Rows[i]["Tên tựa sách"].ToString() + " - " + dtDauSach.Rows[i]["Ngôn ngữ"].ToString(); item.Value = Convert.ToInt32(dtDauSach.Rows[i]["Mã đầu sách"]); cbxmadausach.Items.Add(item); //} } //cbxmadausach.SelectedIndex = inf.ma; //cbxmdg.SelectedIndex = 0; for (int i = 0; i < cbxmdg.Items.Count; i++) { if (cbxmdg.Items[i].ToString() == inf.madocgia) { cbxmdg.SelectedIndex = i; break; } } for (int i = 0; i < cbxmadausach.Items.Count; i++) { if ((cbxmadausach.Items[i] as ComboboxItem).Value.ToString() == inf.madausach) { cbxmadausach.SelectedIndex = i; break; } } dtngaygiodk.Value = inf.ngaygiodk; if (inf.tinhtrang == true) cbdamuon.Checked = true; else cbdamuon.Checked = false; }
public DataTable thongKeDocGiaHetHan() { DocGia dataDocGia = new DocGia(); DataTable dt = dataDocGia.loadDocGia(); for (int i = 0; i < dt.Rows.Count; i++) { if ((bool)dt.Rows[i]["Tình trạng"] == true) { dt.Rows.RemoveAt(i); i--; } } return dt; }
private void ThemDangKyCho_Load(object sender, EventArgs e) { Sach dataSach = new Sach(); DocGia dataDocGia = new DocGia(); DataTable dtDocGia = dataDocGia.loadDocGia(); DataTable dtDauSach = dataSach.loadDauSachTuaSach(); ComboboxItem item; string tuaSach = String.Empty; for (int i = 0; i < dtDocGia.Rows.Count; i++) { if (dtDocGia.Rows[i]["Tình trạng"].ToString() != String.Empty && (bool)dtDocGia.Rows[i]["Tình trạng"] == true)//== String.Empty cbxmdg.Items.Add(Convert.ToInt32(dtDocGia.Rows[i]["Mã độc giả"].ToString())); } for (int i = 0; i < dtDauSach.Rows.Count; i++) { if (dtDauSach.Rows[i]["Tình trạng"].ToString() == String.Empty || (bool)dtDauSach.Rows[i]["Tình trạng"] == false)//== String.Empty { //cbxmadausach.Items.Add(Convert.ToInt32(dtDauSach.Rows[i]["Mã đầu sách"].ToString())); item = new ComboboxItem(); item.Text = dtDauSach.Rows[i]["Mã đầu sách"].ToString() + " - " + dtDauSach.Rows[i]["Tên tựa sách"].ToString() + " - " + dtDauSach.Rows[i]["Ngôn ngữ"].ToString(); item.Value = Convert.ToInt32(dtDauSach.Rows[i]["Mã đầu sách"]); cbxmadausach.Items.Add(item); } } if (cbxmadausach.Items.Count > 0) cbxmadausach.SelectedIndex = 0; else btnthem.Enabled = false; if (cbxmdg.Items.Count > 0) cbxmdg.SelectedIndex = 0; else btnthem.Enabled = false; }
private void SuaMuonTraSach_Load(object sender, EventArgs e) { temp = data.timMuonTraSach(inf); Sach dataSach = new Sach(); DocGia dataDocGia = new DocGia(); DataTable dtDocGia = dataDocGia.loadDocGia(); DataTable dtCuonSach = dataSach.loadCuonSach(); for (int i = 0; i < dtDocGia.Rows.Count; i++) { //if (dtDocGia.Rows[i]["Tình trạng"].ToString() != String.Empty && (bool)dtDocGia.Rows[i]["Tình trạng"] == true)//== String.Empty string mdg = dtDocGia.Rows[i]["Mã độc giả"].ToString(); cbxmdg.Items.Add(mdg); if (temp.madocgia == mdg) cbxmdg.SelectedIndex = i; } for (int i = 0; i < dtCuonSach.Rows.Count; i++) { string macuonsach = dtCuonSach.Rows[i]["Mã cuốn sách"].ToString(); cbxmacuonsach.Items.Add(macuonsach); if (temp.macuonsach == macuonsach) cbxmacuonsach.SelectedIndex = i; } dtngaygiomuon.Value = temp.ngaygiomuon; if (temp.ngaygiotra != null) { dtngaygiotra.Value = (DateTime)temp.ngaygiotra; } else { dtngaygiotra.Enabled = false; } }