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";
}
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;
}
}
private void btnLoadHSX_Click(object sender, EventArgs e)
{
try
{
hSXBindingSource.DataSource = HSXBUS.GetAllHSX();
}
catch { }
}
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";
}
public void loadCmboxDongSanPham()
{
cmBoxLoaiSP.DataSource = LoaiSPBUS.GetAllLoaiSP();
cmBoxLoaiSP.DisplayMember = "TenLSP";
cmBoxLoaiSP.ValueMember = "MaLSP";
cmBoxHSX.DataSource = HSXBUS.GetAllHSX();
cmBoxHSX.DisplayMember = "TenHSX";
cmBoxHSX.ValueMember = "MaHSX";
}
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 btnEditHSX_Click(object sender, EventArgs e)
{
try
{
if (textBoxMaHSX.Text != "" && textBoxTenHSX.Text != "")
{
HSX hsx = new HSX();
hsx.MaHSX = textBoxMaHSX.Text;
hsx.TenHSX = textBoxTenHSX.Text;
HSXBUS.ChinhSua(hsx);
MessageBox.Show("Chỉnh Sửa thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
hSXBindingSource.DataSource = HSXBUS.GetAllHSX();
}
else
{
MessageBox.Show("Mã HSX Không Được Điền!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
catch { MessageBox.Show("Không Thể Thực Hiện Thao Tác!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); }
}
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);
}
}
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);
}
