private void frmQuanLySach_Load(object sender, EventArgs e) { cmbTenTG.DataSource = TacGiaBUS.GetList(); cmbTenTG.DisplayMember = "TenTG"; cmbTenTG.ValueMember = "MaTG"; comboBox4.DataSource = NhaXuatBanBUS.GetList(); comboBox4.DisplayMember = "TenNXB"; comboBox4.ValueMember = "MaNXB"; cmbLoaiSach.DataSource = TheLoaiBUS.GetList(); cmbLoaiSach.DisplayMember = "TenTheLoai"; cmbLoaiSach.ValueMember = "MaLoai"; cmbNgonNgu.DataSource = NgonNguBUS.GetList(); cmbNgonNgu.DisplayMember = "TenNgonNgu"; cmbNgonNgu.ValueMember = "MaNgonNgu"; tbxTenSach.Text = ""; textBox2.Text = ""; cmbNgonNgu.Text = ""; cmbLoaiSach.Text = ""; cmbTenTG.Text = ""; comboBox4.Text = ""; }
public void LayTenTacGia() { TacGiaBUS tacgiaBus = new TacGiaBUS(); IList ds; ds = TacGiaBUS.GetList(); cmbTenTacGia.DataSource = ds; cmbTenTacGia.ValueMember = "MaTG"; cmbTenTacGia.DisplayMember = "TenTG"; }
private void UserControl_Loaded(object sender, RoutedEventArgs e) { List <Sach> _sach = new List <Sach>(); SachBUS _busSach = new SachBUS(); dataGrid.Items.Clear(); _sach = _busSach.GetList(); List <TacGia> _tacGia = new List <TacGia>(); TacGiaBUS _busTacGia = new TacGiaBUS(); _tacGia = _busTacGia.GetList(); List <NhaXuatBan> _nhaXuatBan = new List <NhaXuatBan>(); NhaXuatBanBUS _busNhaXuatBan = new NhaXuatBanBUS(); _nhaXuatBan = _busNhaXuatBan.GetList(); List <TheLoai> _theLoai = new List <TheLoai>(); TheLoaiBUS _busTheLoai = new TheLoaiBUS(); _theLoai = _busTheLoai.GetList(); foreach (Sach i in _sach) { ThongTinSach _thongTinSach = new ThongTinSach(); _thongTinSach.MaSach = i.MaSach; _thongTinSach.TenSach = i.TenSach; _thongTinSach.TheLoai = LayTenTheLoai(_theLoai, i.TheLoai); _thongTinSach.TacGia = LayTenTacGia(_tacGia, i.TacGia); _thongTinSach.NhaXuatBan = LayTenNhaXuatBan(_nhaXuatBan, i.NhaXuatBan); _thongTinSach.NamXuatBan = i.NamXuatBan; _thongTinSach.GiaBan = i.GiaBan.ToString(); _thongTinSach.SoLuong = i.SoLuong; dataGrid.Items.Add(_thongTinSach); } }
private void frmCapNhatSach_Load(object sender, EventArgs e) { try { cmbTenTG.DataSource = TacGiaBUS.GetList(); cmbTenTG.DisplayMember = "TenTG"; cmbTenTG.ValueMember = "MaTG"; cmbNhaXuatBan.DataSource = NhaXuatBanBUS.GetList(); cmbNhaXuatBan.DisplayMember = "TenNXB"; cmbNhaXuatBan.ValueMember = "MaNXB"; cmbLoaiSach.DataSource = TheLoaiBUS.GetList(); cmbLoaiSach.DisplayMember = "TenTheLoai"; cmbLoaiSach.ValueMember = "MaLoai"; cmbNgonNgu.DataSource = NgonNguBUS.GetList(); cmbNgonNgu.DisplayMember = "TenNgonNgu"; cmbNgonNgu.ValueMember = "MaNgonNgu"; int maSach = TimKiemSach.MaSach; SachBUS sachBUS = new SachBUS(); SachDTO sachDTO = null; sachDTO = sachBUS.Search_MaSach(maSach); tbxTenSach.Text = sachDTO.TenSach; txtSoTrang.Text = sachDTO.SoTrang.ToString(); TacGiaBUS tacgiaBUS = new TacGiaBUS(); TacGiaDTO tacgiaDTO = null; tacgiaDTO = tacgiaBUS.LayTenTacGia(sachDTO.MaTacGia); cmbTenTG.Text = tacgiaDTO.TenTG; NhaXuatBanBUS nxbBUS = new NhaXuatBanBUS(); NhaXuatBanDTO nxbDTO = null; nxbDTO = nxbBUS.LayTenNhaXuatBan(sachDTO.MaNXB); cmbNhaXuatBan.Text = nxbDTO.TenNXB; NgonNguBUS nnBUS = new NgonNguBUS(); NgonNguDTO nnDTO = null; nnDTO = nnBUS.LayTenNgonNgu(sachDTO.MaNgonNgu); cmbNgonNgu.Text = nnDTO.TenNgonNgu; TheLoaiBUS tlBUS = new TheLoaiBUS(); TheLoaiDTO tlDTO = null; tlDTO = tlBUS.LayTenTheLoai(sachDTO.MaTheLoai); cmbLoaiSach.Text = tlDTO.TenTheLoai; if (sachDTO.TrangThai == 0) { cmbTinhTrang.Text = "Chưa mượn"; } else { cmbTinhTrang.Text = "Đã mượn"; } } catch (System.Exception ex) { MessageBox.Show(ex.Message); } }
private void QuanLyTacGia_Load(object sender, EventArgs e) { cmbTacGia.DataSource = TacGiaBUS.GetList(); cmbTacGia.ValueMember = "MaTG"; cmbTacGia.DisplayMember = "TenTG"; }
private void btTim_Click(object sender, RoutedEventArgs e) { List <Sach> _sach = new List <Sach>(); SachBUS _busSach = new SachBUS(); dataGrid.Items.Clear(); _sach = _busSach.GetList(); string _maTheLoai = ""; foreach (TheLoai i in _theLoai) { if (i.TenTheLoai == cbbTheLoai.Text) { _maTheLoai = i.MaTheLoai; break; } } List <TacGia> _tacGia = new List <TacGia>(); TacGiaBUS _busTacGia = new TacGiaBUS(); _tacGia = _busTacGia.GetList(); List <NhaXuatBan> _nhaXuatBan = new List <NhaXuatBan>(); NhaXuatBanBUS _busNhaXuatBan = new NhaXuatBanBUS(); _nhaXuatBan = _busNhaXuatBan.GetList(); int stt = 1; if (tbTenSach.Text == "") { foreach (Sach i in _sach) { if (i.TheLoai == _maTheLoai) { ThongTinSach _thongTinSach = new ThongTinSach(); _thongTinSach.Stt = stt++; _thongTinSach.TenSach = i.TenSach; _thongTinSach.TheLoai = cbbTheLoai.Text; _thongTinSach.TacGia = LayTenTacGia(_tacGia, i.TacGia); _thongTinSach.NhaXuatBan = LayTenNhaXuatBan(_nhaXuatBan, i.NhaXuatBan); _thongTinSach.NamXuatBan = i.NamXuatBan; _thongTinSach.GiaBan = i.GiaBan.ToString(); _thongTinSach.SoLuong = i.SoLuong; dataGrid.Items.Add(_thongTinSach); } } } else if (tbTenSach.Text != "" && cbbTheLoai.Text != "") { foreach (Sach i in _sach) { if (String.Compare(i.TenSach, tbTenSach.Text, true) == 0 && i.TheLoai == _maTheLoai) { ThongTinSach _thongTinSach = new ThongTinSach(); _thongTinSach.Stt = stt++; _thongTinSach.TenSach = i.TenSach; _thongTinSach.TheLoai = cbbTheLoai.Text; _thongTinSach.TacGia = LayTenTacGia(_tacGia, i.TacGia); _thongTinSach.NhaXuatBan = LayTenNhaXuatBan(_nhaXuatBan, i.NhaXuatBan); _thongTinSach.NamXuatBan = i.NamXuatBan; _thongTinSach.GiaBan = i.GiaBan.ToString(); _thongTinSach.SoLuong = i.SoLuong; dataGrid.Items.Add(_thongTinSach); } } } else if (tbTenSach.Text != "") { foreach (Sach i in _sach) { if (String.Compare(i.TenSach, tbTenSach.Text, true) == 0) { ThongTinSach _thongTinSach = new ThongTinSach(); _thongTinSach.Stt = stt++; _thongTinSach.TenSach = i.TenSach; _thongTinSach.TheLoai = LayTenTheLoai(_theLoai, i.TheLoai); _thongTinSach.TacGia = LayTenTacGia(_tacGia, i.TacGia); _thongTinSach.NhaXuatBan = LayTenNhaXuatBan(_nhaXuatBan, i.NhaXuatBan); _thongTinSach.NamXuatBan = i.NamXuatBan; _thongTinSach.GiaBan = i.GiaBan.ToString(); _thongTinSach.SoLuong = i.SoLuong; dataGrid.Items.Add(_thongTinSach); } } } }