private void dgvHoaDon_CellClick(object sender, DataGridViewCellEventArgs e) { textBoxNSX.Visible = true; textBoxLoaiSP.Visible = true; textBoxDSP.Visible = true; textBoxMauKieu.Visible = true; textBoxMaKieuSP.Visible = true; textBoxSP.Visible = true; int r = dgvHoaDon.CurrentCell.RowIndex; string id = dgvHoaDon.Rows[r].Cells[1].Value.ToString(); USP_GETAllInfoSPNew_Result sp = ChiTietSPBUS.GetMaSPByMaKieuSP(id); textBoxNSX.Text = sp.TenHSX; textBoxLoaiSP.Text = sp.TenLSP; textBoxDSP.Text = sp.TenDong; textboxGiaBan.Text = dgvHoaDon.Rows[r].Cells[3].Value.ToString(); textBoxSLTon.Text = ChiTietSPBUS.GetChiTietSPOderByMaCHByIDKieuSP(textBoxMaCH.Text, id).SoluongSP.ToString(); textBoxMaKieuSP.Text = sp.MaKieu; textBoxTenSP.Text = sp.TenSP; textBoxSLMua.Text = dgvHoaDon.Rows[r].Cells[2].Value.ToString(); ChiTietSP ct = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id); textBoxSP.Text = ct.MaSP.ToString(); textBoxMauKieu.Text = ct.MaMau.ToString(); try { pictureBox.BackgroundImage = ConverBinaryToImage(ct.Anh); } catch { pictureBox.BackgroundImage = null; } }
void LoadSP() { try { Sp = ChiTietSPBUS.GetMaSPByIDKieuSP(IDMaKieu); CtSp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(IDMaKieu); DSp = DongSanPhamBUS.Get1DongSPByMaSP(Sp.MaDSP); } catch { } }
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 comboBoxMaKieu_SelectedIndexChanged(object sender, EventArgs e) { try { textBoxSLTonKieu.Text = ""; pictureBox.BackgroundImage = null; khoHangBindingSource.DataSource = null; textBoxMaKieu.Text = ""; string id = comboBoxMaKieu.SelectedValue.ToString(); CtSp = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id); textBoxMaKieu.Text = CtSp.MaKieu; textBoxSLTonKieu.Text = CtSp.SoluongSP.ToString(); try { pictureBox.BackgroundImage = ConverBinaryToImage(CtSp.Anh); } catch { pictureBox.BackgroundImage = null; } khoHangBindingSource.DataSource = KhoHangBUS.GetAllKhoHangByMaKieu(CtSp.MaKieu); } catch { } }
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); }
private void cmBoxKieuSP_SelectedIndexChanged(object sender, EventArgs e) { try { string id = cmBoxKieuSP.SelectedValue.ToString(); ChiTietSP ct = ChiTietSPBUS.Get1ChiTietSPByIDMaKieu(id); if (ct != null) { txtBoxSLTon.Text = ct.SoluongSP.ToString(); txtboxGiaBan.Text = ct.Gia.ToString(); } else { txtBoxSLTon.Text = ""; txtboxGiaBan.Text = ""; } } catch { txtBoxSLTon.Text = ""; txtboxGiaBan.Text = ""; } }