public frmSanPhamSua(frmSanPham f, string masp) { InitializeComponent(); BU_NhaSanXuat nsx = new BU_NhaSanXuat(); cbxMaNSX.DataSource = nsx.getAll(); cbxMaNSX.DisplayMember = "TENNSX"; cbxMaNSX.ValueMember = "MANSX"; tg = f; txtMaSP.Text = masp; BU_SanPham sp = new BU_SanPham(); DataTable tb = sp.tkMa(masp); DataRow row = tb.Rows[0]; txtBoNho.Text = row["BONHO"].ToString(); txtCamera.Text = row["CAMERA"].ToString(); txtCPU.Text = row["CPU"].ToString(); txtDonGiaBan.Text = row["DONGIABAN"].ToString(); //txtDonGiaNhap.Text = row["DONGIANHAP"].ToString(); txtDVT.Text = row["DONVITINH"].ToString(); txtHeDieuHanh.Text = row["HEDIEUHANH"].ToString(); txtKetNoi.Text = row["KETNOI"].ToString(); txtPin.Text = row["PIN"].ToString(); txtRam.Text = row["RAM"].ToString(); txtSoLuong.Text = row["SOLUONG"].ToString(); txtTenSP.Text = row["TENSP"].ToString(); cbxMaNSX.SelectedValue = row["MANSX"].ToString(); }
private void cbxMaHang_SelectedIndexChanged(object sender, EventArgs e) { BU_SanPham sp = new BU_SanPham(); DataTable tb = sp.tkMa(cbxMaHang.SelectedValue.ToString()); foreach (DataRow row in tb.Rows) { txtDonGia.Text = row["DONGIABAN"].ToString(); } }
private void frmCTHDB_Load(object sender, EventArgs e) { loaddata(); BU_SanPham sp = new BU_SanPham(); cbxMaHang.DataSource = sp.getAll(); cbxMaHang.DisplayMember = "TENSP"; cbxMaHang.ValueMember = "MASP"; DataTable tb = sp.tkMa(cbxMaHang.SelectedValue.ToString()); foreach (DataRow row in tb.Rows) { txtDonGia.Text = row["DONGIABAN"].ToString(); } }
private void frmCTHDN_Load(object sender, EventArgs e) { BU_SanPham sp = new BU_SanPham(); cbsanpham.DataSource = sp.getAll(); cbsanpham.DisplayMember = "TENSP"; cbsanpham.ValueMember = "MASP"; loadData(); DataTable tb = sp.tkMa(cbsanpham.SelectedValue.ToString()); foreach (DataRow row in tb.Rows) { txtdg.Text = row["DONGIABAN"].ToString(); } }
private void btnTimKiem_Click(object sender, EventArgs e) { if (radiobtnMaSP.Checked) { if (txtTimMaSanPham.Text != "") { DataTable dt = thucthi.tkMa(txtTimMaSanPham.Text); if (dt != null) { dgvSanPham.DataSource = dt; } else { MessageBox.Show(thucthi.Error, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Mã Không được để trống", "Chú Ý", MessageBoxButtons.OK); } } if (radiobtnTenSP.Checked) { if (txtTimTenSanPham.Text != "") { DataTable dt = thucthi.tkTen(txtTimTenSanPham.Text); if (dt != null) { dgvSanPham.DataSource = dt; } else { MessageBox.Show(thucthi.Error, "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("Tên Không được để trống", "Chú Ý", MessageBoxButtons.OK); } } }