void LoadComboBox() { cmBoxDSP.DataSource = DongSanPhamBUS.GetAllDongSP(); cmBoxDSP.DisplayMember = "TenDong"; cmBoxDSP.ValueMember = "MaDSP"; cmBoxNSX.DataSource = HSXBUS.GetAllHSX(); cmBoxNSX.ValueMember = "MaHSX"; cmBoxNSX.DisplayMember = "TenHSX"; cmBoxLoaiSP.DataSource = LoaiSPBUS.GetAllLoaiSP(); cmBoxLoaiSP.DisplayMember = "TenLSP"; cmBoxLoaiSP.ValueMember = "MaLSP"; comboBoxNoiNhapHang.DataSource = CuaHangBUS.GetAllCuaHang(); comboBoxNoiNhapHang.DisplayMember = "TenCuaHang"; comboBoxNoiNhapHang.ValueMember = "MaCuaHang"; comboBoxNoiNhapHang.SelectedValue = "ts"; if (IDHDNH == null) { //txtboxHSX.Visible = false; //txtBoxLSP.Visible = false; //txtBoxDSP.Visible = false; //txtboxGiaBan.Visible = false; //txtBoxKieuSP.Visible = false; //txtboxSP.Visible = false; txtBoxMaHDNH.ReadOnly = false; txtBoxMaNVNH.Text = MaNV; groupBox2.Enabled = false; //txtboxGiaBan.ReadOnly = false; //txtboxGiaNhap.ReadOnly = false; //txtboxGiaBan.Visible = true; } }
void LoadDSP() { dongSanPhamBindingSource.DataSource = DongSanPhamBUS.GetAllDongSP(); cmBoxHSX.DataSource = HSXBUS.GetAllHSX(); cmBoxHSX.DisplayMember = "TenHSX"; cmBoxHSX.ValueMember = "MaHSX"; cmBoxLoaiSP.DataSource = LoaiSPBUS.GetAllLoaiSP(); cmBoxLoaiSP.DisplayMember = "TenLSP"; cmBoxLoaiSP.ValueMember = "MaLSP"; }
void LoadSP() { try { Sp = ChiTietSPBUS.GetMaSPByIDKieuSP(IDMaKieu); CtSp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(IDMaKieu); DSp = DongSanPhamBUS.Get1DongSPByMaSP(Sp.MaDSP); } catch { } }
private void comboBoxNSX_SelectedIndexChanged(object sender, EventArgs e) { try { //comboBoxNSX.DataSource = null; string id = comboBoxNSX.SelectedValue.ToString(); comboBoxDSP.DataSource = DongSanPhamBUS.GetAllDongSPByMaHSX(id); comboBoxDSP.DisplayMember = "TenDong"; comboBoxDSP.ValueMember = "MaDSP"; } catch { } }
private void txtboxTimKiem_TextChanged(object sender, EventArgs e) { try { string i = cmBoxTimKiemTheo.SelectedItem.ToString(); if (i == "Dòng Sản Phẩm") { tabControlMainClient.SelectedTab = tabControlMainClient.TabPages[2]; dongSanPhamBindingSource.DataSource = DongSanPhamBUS.TimKiemDongSP(txtboxTimKiem.Text); } //else // if (i == "Nhân Viên") //{ // if (MaTruyCap == 2) // tabControlMainClient.SelectedTab = tabControlMainClient.TabPages[0]; // else // tabControlMainClient.SelectedTab = tabControlMainClient.TabPages[4]; // nhanVienBindingSource.DataSource = NhanVienBUS.TimKiemNV(txtboxTimKiem.Text); //} else if (i == "Sản Phẩm") { tabControlMainClient.SelectedTab = tabControlMainClient.TabPages[1]; sanPhamBindingSource.DataSource = SanPhamBUS.TimKiemSP(txtboxTimKiem.Text); } else if (i == "Khách Hàng") { tabControlMainClient.SelectedTab = tabControlMainClient.TabPages[1]; if (MaTruyCap == 3) { tabControlMainClient.SelectedTab = tabControlMainClient.TabPages[6]; } else { tabControlMainClient.SelectedTab = tabControlMainClient.TabPages[4]; } khachHangBindingSource.DataSource = KHBUS.TimKiemKhachHang(txtboxTimKiem.Text); } else if (i == "Nhà Sản Xuất") { tabControlMainClient.SelectedTab = tabControlMainClient.TabPages[3]; hSXBindingSource.DataSource = HSXBUS.TimKiemHSX(txtboxTimKiem.Text); } else if (i == "Hóa Đơn") { tabControlMainClient.SelectedTab = tabControlMainClient.TabPages[0]; hoaDonBindingSource.DataSource = HoaDonBUS.TimKiemHD(txtboxTimKiem.Text); } } catch { MessageBox.Show("Bạn Chưa Chọn Đối Tượng Tìm Kiếm!"); } }
private void txtboxTimKiem_TextChanged(object sender, EventArgs e) { try { string i = cmBoxTimKiemTheo.SelectedItem.ToString(); if (i == "Dòng Sản Phẩm") { tabControlMainServer.SelectedTab = tabControlMainServer.TabPages[2]; dongSanPhamBindingSource.DataSource = DongSanPhamBUS.TimKiemDongSP(txtboxTimKiem.Text); } else if (i == "Nhân Viên") { if (MaTruyCap == 2) { tabControlMainServer.SelectedTab = tabControlMainServer.TabPages[0]; } else { tabControlMainServer.SelectedTab = tabControlMainServer.TabPages[4]; } nhanVienBindingSource.DataSource = NhanVienBUS.TimKiemNV(txtboxTimKiem.Text); } else if (i == "Sản Phẩm") { tabControlMainServer.SelectedTab = tabControlMainServer.TabPages[1]; sanPhamBindingSource.DataSource = SanPhamBUS.TimKiemSP(txtboxTimKiem.Text); } else if (i == "Nhà Sản Xuất") { tabControlMainServer.SelectedTab = tabControlMainServer.TabPages[3]; hSXBindingSource.DataSource = HSXBUS.TimKiemHSX(txtboxTimKiem.Text); } else if (i == "Hóa Đơn Nhập") { if (MaTruyCap == 1) { tabControlMainServer.SelectedTab = tabControlMainServer.TabPages[4]; } else { tabControlMainServer.SelectedTab = tabControlMainServer.TabPages[8]; } hoaDonNhapHangBindingSource.DataSource = HoaDonNhapHangBUS.TimKiemHDNhap(txtboxTimKiem.Text); } } catch { MessageBox.Show("Bạn Chưa Chọn Đối Tượng Tìm Kiếm!"); } }
private void btnXoaDSP_Click(object sender, EventArgs e) { if (dongSanPhamBindingSource.Current == null) { return; } if (MessageBox.Show("Bạn có chắc muốn xóa dòng này không?", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.OK) { try { DongSanPhamBUS.XoaDongSP(dongSanPhamBindingSource.Current as DongSanPham); MessageBox.Show("Xóa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch { MessageBox.Show("Lỗi! Không thể thực hiện thao tác", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } LoadDongSP(); }
private void btnLuuChangeDSP_Click(object sender, EventArgs e) { if (txtboxMaDongSP.Text == "" || txtboxTenDongSP.Text == "") { MessageBox.Show("Lỗi! Xin Nhập Đầy Đủ thông Tin", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); return; } if (lbTitle.Text == "Thêm Dòng Sản Phẩm") { try { DongSanPham dsp = new DongSanPham(); dsp.MaDSP = txtboxMaDongSP.Text; dsp.MaHSX = cmBoxHSX.SelectedValue.ToString(); dsp.TenDong = txtboxTenDongSP.Text; dsp.MaLSP = cmBoxLoaiSP.SelectedValue.ToString(); //kiểm tra hợp lệ DongSanPhamBUS.ThemDongSP(dsp); MessageBox.Show("Thêm Thành Công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch { MessageBox.Show("Lỗi! Không thể thực hiện thao tác", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { try { DongSanPham dsp = new DongSanPham(); dsp.MaDSP = txtboxMaDongSP.Text; dsp.MaHSX = cmBoxHSX.SelectedValue.ToString(); dsp.TenDong = txtboxTenDongSP.Text; dsp.MaLSP = cmBoxLoaiSP.SelectedValue.ToString(); DongSanPhamBUS.ChinhSuaDongSP(dsp); MessageBox.Show("Chỉnh Sửa Thành Công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } catch { MessageBox.Show("Lỗi! Không thể thực hiện thao tác", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error); } } btnThemDSP.Visible = true; btnXoaDSP.Visible = true; btnChinhSuaDSP.Visible = true; btnLuuChangeDSP.Visible = false; btnHuyChangeDSP.Visible = false; txtboxMaDongSP.ReadOnly = false; LoadDongSP(); }
private void comboBoxLoaiSP_SelectedIndexChanged(object sender, EventArgs e) { try { comboBoxDSP.DataSource = null; string id = comboBoxNSX.SelectedValue.ToString(); string idloai = comboBoxLoaiSP.SelectedValue.ToString(); if (DongSanPhamBUS.GetAllDongSPByMaHSXAndMaLoai(id, idloai).Count != 0) { comboBoxDSP.DataSource = DongSanPhamBUS.GetAllDongSPByMaHSXAndMaLoai(id, idloai); comboBoxDSP.DisplayMember = "TenDong"; comboBoxDSP.ValueMember = "MaDSP"; } else { comboBoxDSP.DataSource = null; } } catch { comboBoxDSP.DataSource = null; } }
public void LoadChiTietSP() { //try //{ LoadSP(); //} //catch //{ //} comboBoxCHNhan.DataSource = CuaHangBUS.GetAllCuaHang(); comboBoxCHNhan.DisplayMember = "TenCuaHang"; comboBoxCHNhan.ValueMember = "MaCuaHang"; comboBoxCHPP.DataSource = CuaHangBUS.GetAllCuaHang(); comboBoxCHPP.DisplayMember = "TenCuaHang"; comboBoxCHPP.ValueMember = "MaCuaHang"; comboBoxNXS.DataSource = HSXBUS.GetAllHSX(); comboBoxNXS.DisplayMember = "TenHSX"; comboBoxNXS.ValueMember = "MaHSX"; comboBoxNXS.SelectedValue = DSp.MaHSX; comboBoxDSP.DataSource = DongSanPhamBUS.GetAllDongSPByMaHSX(DSp.MaHSX); comboBoxDSP.DisplayMember = "TenDong"; comboBoxDSP.ValueMember = "MaDSP"; comboBoxDSP.SelectedValue = DSp.MaDSP; comboBoxSP.DataSource = SanPhamBUS.GetSanPhamByMaDSP(DSp.MaDSP); comboBoxSP.DisplayMember = "TenSP"; comboBoxSP.ValueMember = "MaSP"; comboBoxSP.SelectedValue = Sp.MaSP; comboBoxMaKieu.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(Sp.MaSP); comboBoxMaKieu.DisplayMember = "MaKieu"; comboBoxMaKieu.ValueMember = "MaKieu"; CtSp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(IDMaKieu); comboBoxMaKieu.SelectedValue = CtSp.MaKieu; textBoxSLTonKieu.Text = CtSp.SoluongSP.ToString(); pictureBox.BackgroundImage = ConverBinaryToImage(CtSp.Anh); khoHangBindingSource.DataSource = KhoHangBUS.GetAllKhoHangByMaKieu(CtSp.MaKieu); }
public void LoadDongSP() { dongSanPhamBindingSource.DataSource = DongSanPhamBUS.GetAllDongSP(); }
void LoadSP() { cmBoxDongSP.Enabled = true; cmBoxDongSP.DataSource = DongSanPhamBUS.GetAllDongSP(); //cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP(); //cmBoxSP.DataSource = SanPhamBUS.GetSanPhamByMaDSP(); cmBoxTenMau.DataSource = ChiTietSPBUS.GetAllMauSP(); cmBoxTenMau.DisplayMember = "Mau"; cmBoxTenMau.ValueMember = "MaMau"; if (IDMode.Trim(' ') != "ts") { btnAnh.Visible = false; btnThemSP.Visible = false; btnLuuThayDoi.Visible = false; btnLuuKieuSP.Visible = false; btnHuyKieuSP.Visible = false; btnThemKieuSP.Visible = false; btnChinhSuaKieuSP.Visible = false; btnXoaKieuSP.Visible = false; btnThemMau.Visible = false; btnXoaMau.Visible = false; btnLuuMau.Visible = false; } //Xem Chi tiết if (ID != null && Ischange == false) { btnThemSP.Visible = false; btnLuuThayDoi.Visible = false; SanPham sp = BUS.SanPhamBUS.GetSanPhamByID(ID); cmBoxSP.DataSource = SanPhamBUS.GetSanPhamByMaDSP(sp.MaDSP); cmBoxSP.ValueMember = "MaSP"; cmBoxSP.DisplayMember = "TenSP"; cmBoxSP.SelectedValue = ID; cmBoxDongSP.DisplayMember = "TenDong"; cmBoxDongSP.ValueMember = "MaDSP"; cmBoxDongSP.SelectedValue = sp.MaDSP; cmBoxSP.SelectedValue = ID; txtboxMaSP.Text = sp.MaSP; txtTenSP.Text = sp.TenSP; txtNamSX.Text = sp.NămSX; txtboxCPU.Text = sp.CPU; txtboxGPU.Text = sp.CardManHinh; txtCamera.Text = sp.Camera; txtPort.Text = sp.Port; txtboxRam.Text = sp.Ram; txtboxManHinh.Text = sp.ManHinh; txtboxOS.Text = sp.OS; txtboxSim.Text = sp.Sim; txtboxPin.Text = sp.DungLuongPin; txtBoxTrongLuong.Text = sp.TrongLuong; txtboxBNngoai.Text = sp.BoNhoNgoai; txtboxBNtrong.Text = sp.BoNhoTrong; } //Thêm Mới if (ID == null && Ischange == false) { cmBoxSP.Enabled = false; cmBoxDongSP.DisplayMember = "TenDong"; cmBoxDongSP.ValueMember = "MaDSP"; if (IDDSP != null) { cmBoxDongSP.SelectedValue = IDDSP; } btnThemSP.Visible = false; btnLuuThayDoi.Visible = true; cmBoxSP.Visible = false; txtTenSP.ReadOnly = false; txtNamSX.ReadOnly = false; txtboxCPU.ReadOnly = false; txtboxGPU.ReadOnly = false; txtCamera.ReadOnly = false; txtPort.ReadOnly = false; txtboxRam.ReadOnly = false; txtboxManHinh.ReadOnly = false; txtboxOS.ReadOnly = false; txtboxSim.ReadOnly = false; txtboxPin.ReadOnly = false; txtBoxTrongLuong.ReadOnly = false; txtboxBNngoai.ReadOnly = false; txtboxBNtrong.ReadOnly = false; } //Chỉnh sửa if (ID != null && Ischange == true) { cmBoxSP.Enabled = false; cmBoxDongSP.DisplayMember = "TenDong"; cmBoxDongSP.ValueMember = "MaDSP"; btnThemSP.Visible = false; btnLuuThayDoi.Visible = true; cmBoxSP.Visible = false; txtboxMaSP.Text = ID; txtboxMaSP.ReadOnly = true; txtTenSP.ReadOnly = false; txtNamSX.ReadOnly = false; txtboxCPU.ReadOnly = false; txtboxGPU.ReadOnly = false; txtCamera.ReadOnly = false; txtPort.ReadOnly = false; txtboxRam.ReadOnly = false; txtboxManHinh.ReadOnly = false; txtboxOS.ReadOnly = false; txtboxSim.ReadOnly = false; txtboxPin.ReadOnly = false; txtBoxTrongLuong.ReadOnly = false; txtboxBNngoai.ReadOnly = false; txtboxBNtrong.ReadOnly = false; SanPham sp = BUS.SanPhamBUS.GetSanPhamByID(ID); cmBoxSP.DataSource = SanPhamBUS.GetSanPhamByMaDSP(sp.MaDSP); cmBoxSP.ValueMember = "MaSP"; cmBoxSP.DisplayMember = "MaSP"; cmBoxSP.SelectedValue = sp.MaSP; cmBoxDongSP.DisplayMember = "TenDong"; cmBoxDongSP.ValueMember = "MaDSP"; cmBoxDongSP.SelectedValue = sp.MaDSP; txtboxMaSP.Text = sp.MaSP; txtTenSP.Text = sp.TenSP; txtNamSX.Text = sp.NămSX; txtboxCPU.Text = sp.CPU; txtboxGPU.Text = sp.CardManHinh; txtCamera.Text = sp.Camera; txtPort.Text = sp.Port; txtboxRam.Text = sp.Ram; txtboxManHinh.Text = sp.ManHinh; txtboxOS.Text = sp.OS; txtboxSim.Text = sp.Sim; txtboxPin.Text = sp.DungLuongPin; txtBoxTrongLuong.Text = sp.TrongLuong; txtboxBNngoai.Text = sp.BoNhoNgoai; txtboxBNtrong.Text = sp.BoNhoTrong; } }