private void HienThiTenHang(ComboBox cbTenHang) { var xuli = new BAL_Hang(); cbTenHang.DisplayMember = "TenHang"; cbTenHang.DataSource = xuli.LayDSTenHang(); }
private void dgvSP_KH_CellClick(object sender, DataGridViewCellEventArgs e) { DataTable dt = new DataTable(); var xuli = new BAL_Hang(); try { cothang = e.RowIndex; DataGridViewRow row = dgvSP_KH.Rows[cothang]; string ten = row.Cells[0].Value.ToString(); dt = xuli.LayDSSLHangQuaTen(ten); int SL = int.Parse(dt.Rows[0]["SoLuong"].ToString()); if (SL == 0) { lb1.Text = "Mặt Hàng Đã Hết"; lb1.ForeColor = Color.Red; dt = xuli.LayHinh_KH(ten); pt1.Image = Image.FromFile(dt.Rows[0]["Hinh"].ToString()); } else { lb1.Text = "Giá " + row.Cells[1].Value.ToString() + "$"; lb1.ForeColor = Color.Black; dt = xuli.LayHinh_KH(ten); pt1.Image = Image.FromFile(dt.Rows[0]["Hinh"].ToString()); } } catch (Exception err) { } }
private void HienThiGia(string TenHang) { var xulihang = new BAL_Hang(); DataTable dt = new DataTable(); dt = xulihang.LayDSGiaHangQuaTen(TenHang); tbGia.Text = dt.Rows[0]["Gia"].ToString(); }
private void HienThiLoaiHang(string TenHang) { var xulihang = new BAL_Hang(); DataTable dt = new DataTable(); dt = xulihang.LayDSLoaiHangQuaTen(TenHang); tbLoaiHang.Text = dt.Rows[0]["Loai"].ToString(); }
private bool KTSLHang() { bool kq = false; var xuli = new BAL_Hang(); if (xuli.CapNhapSLHang() == true) { return(kq = true); } return(false); }
private void HienThiSL(string TenHang) { var xulihang = new BAL_Hang(); DataTable dt = new DataTable(); dt = xulihang.LayDSSLHangQuaTen(TenHang); if (Chay == 0) { tbSoLuong.Text = dt.Rows[0]["SoLuong"].ToString(); SL = int.Parse(tbSoLuong.Text); SL_Dem = SL; } else { tbSoLuong.Text = SL_Dem.ToString(); } }
private void TimTenHang(DataGridView dvg) { BAL_Hang xuli = new BAL_Hang(); dvg.DataSource = xuli.TimHang_KH(tbTen.Text); }
private void HienThiHang(DataGridView dvg) { BAL_Hang xuli = new BAL_Hang(); dvg.DataSource = xuli.LayTen_KH(); }