private void LoadDSSach() { DataTable dt = Sach_DAO.LoadDuLieu(); DataTable dtg = ChuDe_DAO.LoadDuLieu(); AutoCompleteStringCollection ac = new AutoCompleteStringCollection(); for (int i = 0; i < dtg.Rows.Count; i++) { ListViewGroup lvg = new ListViewGroup(dtg.Rows[i][0].ToString(), dtg.Rows[i][1].ToString()); lsvSach.Groups.Add(lvg); } for (int i = 0; i < dt.Rows.Count; i++) { ListViewItem lvi = new ListViewItem(dt.Rows[i][1].ToString()); // ten mon lvi.SubItems.Add(dt.Rows[i][2].ToString()); // Don gia lvi.SubItems.Add(dt.Rows[i][4].ToString()); //So luong DataTable nxb = NhaXuatBan_DAO.LoadDuLieuNXB(dt.Rows[i][6].ToString()); lvi.SubItems.Add(nxb.Rows[0][1].ToString()); //NXB lvi.SubItems.Add(dt.Rows[i][7].ToString()); //id chu de lvi.SubItems.Add(dt.Rows[i][0].ToString()); // id mon lvi.Group = lsvSach.Groups[lvi.SubItems[4].Text]; lsvSach.Items.Add(lvi); ac.Add(lvi.SubItems[0].Text); } txtTenSach.AutoCompleteCustomSource = ac; }
private void FrmThemDS_Load(object sender, EventArgs e) { cboMaCD.DataSource = ChuDe_DAO.LoadDuLieu(); cboMaCD.DisplayMember = "TenCD"; cboMaCD.ValueMember = "MaCD"; cboNhaNXB.DataSource = NhaXuatBan_DAO.LoadDuLieu(); dgvDausach.DataSource = Sach_DAO.LoadDuLieu(); cboNhaNXB.DisplayMember = "TenNXB"; cboNhaNXB.ValueMember = "MaNXB"; txtMasach.ReadOnly = true; }
private void l(object sender, EventArgs e) { ListViewItem lvi = lsvDsDuocChon.SelectedItems[0]; txtSach.Text = lvi.SubItems[0].Text; itemSelect = lsvDsDuocChon.SelectedItems[0]; indexItemSelect = lsvDsDuocChon.SelectedItems[0].Index; IdCD = itemSelect.SubItems[4].Text; txtSoLuong.Text = itemSelect.SubItems[2].Text; cd = ChuDe_DAO.LoadDuLieuCD(IdCD); txtChuD.Text = cd.Rows[0][1].ToString(); dtNgayHenTra.Value = DateTime.Parse(itemSelect.SubItems[6].Text); txtSoLuong.ReadOnly = true; btnSuaDsChon.Enabled = true; }
private void lsvSach_Click(object sender, EventArgs e) { txtSoLuong.ReadOnly = false; ListViewItem lvi = lsvSach.SelectedItems[0]; txtSach.Text = lvi.SubItems[0].Text; itemSelect = lsvSach.SelectedItems[0]; indexItemSelect = lsvSach.SelectedItems[0].Index; IdCD = itemSelect.SubItems[4].Text; IdSach = itemSelect.SubItems[5].Text; GiaBan = itemSelect.SubItems[1].Text; NhaXuatBan = itemSelect.SubItems[3].Text; cd = ChuDe_DAO.LoadDuLieuCD(IdCD); txtChuD.Text = cd.Rows[0][1].ToString(); }
private void LoadDocGia() { ThoiGianNow.DateTime = DateTime.Now; cboTenNhanVien.DataSource = NhanVien_DAO.LoadDuLieu(); cboTenNhanVien.DisplayMember = "HoTen"; cboTenNhanVien.ValueMember = "MaNV"; cboTenChuDe.DataSource = ChuDe_DAO.LoadDuLieu(); cboTenChuDe.DisplayMember = "TenCD"; cboTenChuDe.ValueMember = "MaCD"; cboTenChuDe.Text = ""; cboNhaXuatBan.DataSource = NhaXuatBan_DAO.LoadDuLieu(); cboNhaXuatBan.DisplayMember = "TenNXB"; cboNhaXuatBan.ValueMember = "MaNXB"; cboNhaXuatBan.Text = ""; }
public static ChuDe_DTO LayThongTinChiTietChuDeBoiMa(string machude) { return(ChuDe_DAO.LayThongTinChiTietChuDeBoiMa(machude)); }
public static List <ChuDe_DTO> LayDanhSachChuDe() { return(ChuDe_DAO.LayDanhSachChuDe()); }