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