private void RefreshDTGV()
        {
            dtgvThongKe.Rows.Clear();
            int     ID = dtgvThongKe.Rows.Count + 1;
            ThongKe NV = new ThongKe();

            foreach (THONGKEDONHANGDABAN item in NV.ThongKeSanPham())
            {
                dtgvThongKe.Rows.Add(ID, item.MADH, item.TENKH, item.TENNV, item.TIMEXUAT, item.THANHTIEN);
                ID++;
            }
            lbTongTien.Text = String.Format("{0:n0} VNĐ", NV.TongThanhTien());
        }
        private void load()
        {
            ThongKe TK = new ThongKe();

            lbTongTien.Text = String.Format("{0:n0} VNĐ", TK.TongThanhTien());
            DonHangBUS DH = new DonHangBUS();

            lbSoLuong.Text = DH.SoLuong().ToString();
            KhachHangBUS KH = new KhachHangBUS();

            lbSoLuongKH.Text = KH.SoLuongKH().ToString();
            SanPhamBUS SP = new SanPhamBUS();

            foreach (var item in SP.loadSP())
            {
                SANPHAM S = (SANPHAM)item;
                showTheMost(S.TENSP, S.IMAGES);
            }
        }
        private void BtnThongKe_Click(object sender, EventArgs e)
        {
            try
            {
                string cbbSelected = cbbSelectThongKe.SelectedItem.ToString();
                if (cbbSelected == "Ngày" || cbbSelected == "Tháng" || cbbSelected == "Năm" || cbbSelected == "Tổng")
                {
                    dtgvThongKe.Rows.Clear();
                    int     ID           = dtgvThongKe.Rows.Count + 1;
                    ThongKe NV           = new ThongKe();
                    string  valueThongke = cbbSelectThongKe.SelectedItem.ToString();
                    foreach (THONGKEDONHANGDABAN item in NV.THONGKETHEONTN(dTimePicker.Value, valueThongke))
                    {
                        dtgvThongKe.Rows.Add(ID, item.MADH, item.TENKH, item.TENNV, item.TIMEXUAT, item.THANHTIEN);
                        ID++;
                    }

                    lbTongTien.Text = String.Format("{0:n0} VNĐ", NV.TongThanhTien());
                }

                if (cbbSelected == "Quý")
                {
                    dtgvThongKe.Rows.Clear();
                    int     ID           = dtgvThongKe.Rows.Count + 1;
                    ThongKe NV           = new ThongKe();
                    string  valueThongke = cbbQuy.SelectedItem.ToString();
                    foreach (THONGKEDONHANGDABAN item in NV.TKQuy(dTimePicker.Value, valueThongke))
                    {
                        dtgvThongKe.Rows.Add(ID, item.MADH, item.TENKH, item.TENNV, item.TIMEXUAT, item.THANHTIEN);
                        ID++;
                    }

                    lbTongTien.Text = String.Format("{0:n0} VNĐ", NV.TongThanhTien());
                }
            }
            catch (Exception)
            {
            }
        }