예제 #1
0
        private void HienThiTenHang(ComboBox cbTenHang)
        {
            var xuli = new BAL_Hang();

            cbTenHang.DisplayMember = "TenHang";
            cbTenHang.DataSource    = xuli.LayDSTenHang();
        }
예제 #2
0
        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)
            {
            }
        }
예제 #3
0
        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();
        }
예제 #4
0
        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();
        }
예제 #5
0
        private bool KTSLHang()
        {
            bool kq   = false;
            var  xuli = new BAL_Hang();

            if (xuli.CapNhapSLHang() == true)
            {
                return(kq = true);
            }
            return(false);
        }
예제 #6
0
        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();
            }
        }
예제 #7
0
        private void TimTenHang(DataGridView dvg)
        {
            BAL_Hang xuli = new BAL_Hang();

            dvg.DataSource = xuli.TimHang_KH(tbTen.Text);
        }
예제 #8
0
        private void HienThiHang(DataGridView dvg)
        {
            BAL_Hang xuli = new BAL_Hang();

            dvg.DataSource = xuli.LayTen_KH();
        }