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;
}
}
