private void ThemSach_Load(object sender, EventArgs e) { CTL.NgonNgu dataNgonNgu = new CTL.NgonNgu(); ComboboxItem item; DataTable dtNgonNgu = dataNgonNgu.loadNgonNgu(); DataTable dtTuaSach = dataSach.loadTuaSach(); DataTable dtDauSach = dataSach.loadDauSachTuaSach(); DataTable dtCuonSach = dataSach.loadCuonSach(); int matuasach = timSTT(dtTuaSach, "Mã tựa sách"); int madausach = timSTT(dtDauSach, "Mã đầu sách"); int macuonsach = timSTT(dtCuonSach, "Mã cuốn sách"); #region Tựa sách txtmatuasach.Text = matuasach.ToString(); #endregion #region Đầu sách txtmadausach.Text = madausach.ToString(); for (int i = 0; i < dtTuaSach.Rows.Count; i++) { item = new ComboboxItem(); item.Text = dtTuaSach.Rows[i]["Mã tựa sách"].ToString() + " - " + dtTuaSach.Rows[i]["Tên tựa sách"].ToString(); item.Value = dtTuaSach.Rows[i]["Mã tựa sách"].ToString(); cbxtuasach.Items.Add(item); } for (int i = 0; i < dtNgonNgu.Rows.Count; i++) { item = new ComboboxItem(); item.Text = dtNgonNgu.Rows[i]["Ngôn ngữ"].ToString(); item.Value = dtNgonNgu.Rows[i]["Ngôn ngữ"].ToString(); cbxngonngu.Items.Add(item); } if (cbxtuasach.Items.Count > 0) cbxtuasach.SelectedIndex = 0; if (cbxngonngu.Items.Count > 0) cbxngonngu.SelectedIndex = 0; #endregion #region Cuốn sách for (int i = 0; i < dtDauSach.Rows.Count; i++) { 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 = dtDauSach.Rows[i]["Mã đầu sách"].ToString(); cbxmadausach.Items.Add(item); } if (cbxmadausach.Items.Count > 0) cbxmadausach.SelectedIndex = 0; txtmacuonsach.Text = macuonsach.ToString(); #endregion }
private void SuaSach_Load(object sender, EventArgs e) { CTL.NgonNgu dataNgonNgu = new CTL.NgonNgu(); ComboboxItem item; DataTable dtNgonNgu = dataNgonNgu.loadNgonNgu(); DataTable dtTuaSach = dataSach.loadTuaSach(); DataTable dtDauSach = dataSach.loadDauSachTuaSach(); DataTable dtCuonSach = dataSach.loadCuonSach(); TUASACH ts; DAUSACH ds; CUONSACH cs; tcsuasach.SelectedTabIndex = selectedTab; if (selectedTab == 0) { tithemtuasach.Visible = true; tithemdausach.Visible = false; tithemcuonsach.Visible = false; ts = dataSach.timTuaSach(mts); txtmatuasach.Text = ts.matuasach; txttentuasach.Text = ts.tentuasach; txttacgia.Text = ts.tacgia; txtgioithieu.Text = ts.gioithieu; } else if (selectedTab == 1) { tithemtuasach.Visible = false; tithemdausach.Visible = true; tithemcuonsach.Visible = false; ds = dataSach.timDauSach(mds); txtmadausach.Text = ds.madausach; if (ds.tinhtrang == true) cbdausach.Checked = true; for (int i = 0; i < dtTuaSach.Rows.Count; i++) { item = new ComboboxItem(); item.Text = dtTuaSach.Rows[i]["Mã tựa sách"].ToString() + " - " + dtTuaSach.Rows[i]["Tên tựa sách"].ToString(); item.Value = dtTuaSach.Rows[i]["Mã tựa sách"].ToString(); cbxmatuasach.Items.Add(item); } for (int i = 0; i < dtNgonNgu.Rows.Count; i++) { item = new ComboboxItem(); item.Text = dtNgonNgu.Rows[i]["Ngôn ngữ"].ToString(); item.Value = dtNgonNgu.Rows[i]["Ngôn ngữ"].ToString(); cbxngonngu.Items.Add(item); } for (int i = 0; i < cbxmatuasach.Items.Count; i++) { if ((cbxmatuasach.Items[i] as ComboboxItem).Value.ToString() == ds.matuasach) { cbxmatuasach.SelectedIndex = i; break; } } for (int i = 0; i < cbxngonngu.Items.Count; i++) { if ((cbxngonngu.Items[i] as ComboboxItem).Value.ToString() == ds.ngonngu) { cbxngonngu.SelectedIndex = i; break; } } } else if (selectedTab == 2) { tithemtuasach.Visible = false; tithemdausach.Visible = false; tithemcuonsach.Visible = true; cs = dataSach.timCuonSach(mcs); txtmacuonsach.Text = cs.macuonsach; if (cs.tinhtrang == true) cbcuonsach.Checked = true; for (int i = 0; i < dtDauSach.Rows.Count; i++) { 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 = dtDauSach.Rows[i]["Mã đầu sách"].ToString(); cbxmadausach.Items.Add(item); } for (int i = 0; i < cbxmadausach.Items.Count; i++) { if ((cbxmadausach.Items[i] as ComboboxItem).Value.ToString() == cs.madausach) { cbxmadausach.SelectedIndex = i; break; } } } }