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