private void btnHuyKieuSP_Click(object sender, EventArgs e) { dgvCTSP.Enabled = true; btnLuuKieuSP.Visible = false; btnHuyKieuSP.Visible = false; btnThemKieuSP.Visible = true; btnChinhSuaKieuSP.Visible = true; btnXoaKieuSP.Visible = true; textBoxMaKieu.ReadOnly = false; textBoxMaSP.ReadOnly = false; textBoxMaKieu.Visible = false; textBoxMaSP.Visible = false; cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP(); cmBoxMauSP.ValueMember = "MaMau"; cmBoxMauSP.DisplayMember = "Mau"; textBoxMau.Visible = false; int r = dgvCTSP.CurrentCell.RowIndex; textBoxMaKieu.Text = dgvCTSP.Rows[r].Cells[1].Value.ToString(); cmBoxMaKieuSP.SelectedValue = dgvCTSP.Rows[r].Cells[1].Value.ToString(); textBoxMaSP.Text = dgvCTSP.Rows[r].Cells[0].Value.ToString(); cmBoxMaSP.SelectedValue = dgvCTSP.Rows[r].Cells[0].Value.ToString(); txtBoxGiaSP.Text = dgvCTSP.Rows[r].Cells[3].Value.ToString(); txtboxSoLuongAll.Text = dgvCTSP.Rows[r].Cells[4].Value.ToString(); cmBoxMauSP.SelectedValue = dgvCTSP.Rows[r].Cells[2].Value.ToString(); }
private void btnThemSPMua_Click(object sender, EventArgs e) { IsAdd = true; textBoxNSX.Visible = false; textBoxLoaiSP.Visible = false; textBoxDSP.Visible = false; textBoxMauKieu.Visible = false; textBoxMaKieuSP.Visible = false; textBoxSP.Visible = false; numericSL.Value = 1; numericSL.Minimum = 0; textboxGiaBan.Text = ""; textBoxSLTon.Text = ""; textBoxSLMua.Text = ""; textBoxTenSP.Text = ""; comboBoxMaKieu.DataSource = null; comboBoxSP.DataSource = null; comboBoxNSX.DataSource = HSXBUS.GetAllHSX(); comboBoxNSX.ValueMember = "MaHSX"; comboBoxNSX.DisplayMember = "TenHSX"; comboBoxMau.DataSource = ChiTietSPBUS.GetAllMauSP(); comboBoxMau.DisplayMember = "Mau"; comboBoxMau.ValueMember = "MaMau"; comboBoxLoaiSP.DataSource = LoaiSPBUS.GetAllLoaiSP(); comboBoxLoaiSP.DisplayMember = "TenLSP"; comboBoxLoaiSP.ValueMember = "MaLSP"; }
private void cmBoxMaKieuSP_SelectedIndexChanged(object sender, EventArgs e) { try { string id = cmBoxMaKieuSP.SelectedValue.ToString(); //ChiTietSP sp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id); if (IDMode == "ts") { ChiTietSP sp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id); cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP(); cmBoxMauSP.ValueMember = "MaMau"; cmBoxMauSP.DisplayMember = "Mau"; cmBoxMauSP.SelectedValue = sp.MaMau; txtBoxGiaSP.Text = sp.Gia.ToString(); txtboxSoLuongAll.Text = sp.SoluongSP.ToString(); //picBoxKieuSP.Image = null; picBoxKieuSP.BackgroundImage = null; textBoxPathAnh.Text = ""; //picBoxKieuSP.Image = ConverBinaryToImage(sp.Anh); picBoxKieuSP.BackgroundImage = ConverBinaryToImage(sp.Anh); } else { ChiTietSP sp = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDKieuSP(IDMode, id); cmBoxMauSP.SelectedValue = sp.MaMau; txtBoxGiaSP.Text = sp.Gia.ToString(); txtboxSoLuongAll.Text = sp.SoluongSP.ToString(); //picBoxKieuSP.Image = null; picBoxKieuSP.BackgroundImage = null; textBoxPathAnh.Text = ""; //picBoxKieuSP.Image = ConverBinaryToImage(sp.Anh); picBoxKieuSP.BackgroundImage = ConverBinaryToImage(sp.Anh); } //cmBoxMauSP.SelectedValue = sp.MaMau; //txtBoxGiaSP.Text = sp.Gia.ToString(); //txtboxSoLuongAll.Text = sp.SoluongSP.ToString(); //picBoxKieuSP.Image = null; //textBoxPathAnh.Text = ""; //picBoxKieuSP.Image = ConverBinaryToImage(sp.Anh); } catch { } }
private void btnThemKieuSP_Click(object sender, EventArgs e) { NewCTSP = true; dgvCTSP.Enabled = false; cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP(); cmBoxMauSP.ValueMember = "MaMau"; cmBoxMauSP.DisplayMember = "Mau"; textBoxMaKieu.Visible = true; textBoxMaKieu.Text = ""; textBoxMaSP.Visible = true; txtBoxGiaSP.Text = "0"; txtboxSoLuongAll.Text = "0"; btnLuuKieuSP.Visible = true; btnHuyKieuSP.Visible = true; btnThemKieuSP.Visible = false; btnChinhSuaKieuSP.Visible = false; btnXoaKieuSP.Visible = false; textBoxMaSP.Text = cmBoxMaSP.SelectedValue.ToString(); }
private void btnLuuHD_Click(object sender, EventArgs e) { HoaDon hd = new HoaDon(); hd.MaHoaDon = textBoxMaHD.Text; hd.MaKH = comboBoxMaKH.SelectedValue.ToString(); hd.MaNV = textBoxMaNV.Text; hd.MaCuaHang = textBoxMaCH.Text; hd.NgayLapHD = dateTimePickerNgayVietHD.Value; hd.TinhTrang = 0; if (radioMuaTT.Checked) { hd.HTGiaoHang = "Trực Tiếp"; } else { hd.HTGiaoHang = "Giao Hàng"; } try { HoaDonBUS.ThemHoaDon(hd); MessageBox.Show("Thêm Thành Công!", "Thông Báo", MessageBoxButtons.OK, MessageBoxIcon.Information); groupBox2.Enabled = true; btnLuuTam.Visible = true; btnThanhToan.Visible = true; comboBoxNSX.DataSource = HSXBUS.GetAllHSX(); comboBoxNSX.ValueMember = "MaHSX"; comboBoxNSX.DisplayMember = "TenHSX"; comboBoxMau.DataSource = ChiTietSPBUS.GetAllMauSP(); comboBoxMau.DisplayMember = "Mau"; comboBoxMau.ValueMember = "MaMau"; comboBoxLoaiSP.DataSource = LoaiSPBUS.GetAllLoaiSP(); comboBoxLoaiSP.DisplayMember = "TenLSP"; comboBoxLoaiSP.ValueMember = "MaLSP"; } catch { MessageBox.Show("Không Thể Thực Hiện Thao Tác!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void cmBoxMaSP_SelectedIndexChanged(object sender, EventArgs e) { string id = cmBoxMaSP.SelectedValue.ToString(); //cmBoxMaKieuSP.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id); //cmBoxMaKieuSP.DisplayMember = "MaKieu"; //cmBoxMaKieuSP.ValueMember = "MaKieu"; //cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP(); //cmBoxMauSP.ValueMember = "MaMau"; //cmBoxMauSP.DisplayMember = "Mau"; if (IDMode == "ts") { chiTietSPBindingSource.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id); cmBoxMaKieuSP.DataSource = ChiTietSPBUS.GetChiTietSPByIDSP(id); cmBoxMaKieuSP.DisplayMember = "MaKieu"; cmBoxMaKieuSP.ValueMember = "MaKieu"; cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP(); cmBoxMauSP.ValueMember = "MaMau"; cmBoxMauSP.DisplayMember = "Mau"; } else { chiTietSPBindingSource.DataSource = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDSP(IDMode, id); //cmBoxMaKieuSP.DataSource = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDSP(IDMode,id); if (ChiTietSPBUS.GetChiTietSPOderByMaCHByIDSP(IDMode, id).Count != 0) { cmBoxMaKieuSP.DataSource = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDSP(IDMode, id); cmBoxMaKieuSP.DisplayMember = "MaKieu"; cmBoxMaKieuSP.ValueMember = "MaKieu"; } else { cmBoxMaKieuSP.DataSource = null; } cmBoxMauSP.DataSource = ChiTietSPBUS.GetAllMauSP(); cmBoxMauSP.ValueMember = "MaMau"; cmBoxMauSP.DisplayMember = "Mau"; } }
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; } }