private void LoadCtpgc_review()
        {
            BUL_LoaiSanPham    bulLoaiSp  = new BUL_LoaiSanPham();
            BUL_CTPDV          bulCtpdv   = new BUL_CTPDV();
            List <LOAISANPHAM> listLoaiSp = bulLoaiSp.getAllProductType();
            BUL_CTPGC          bulCtpgc   = new BUL_CTPGC();
            List <CTPGC>       listCtpgc  = bulCtpgc.GetAllCTPGCBySoPhieuGC(_soPGC);

            _dataTableCtpgcReview.Rows.Clear();
            foreach (var item in listCtpgc)
            {
                CTPDV ctpdv = bulCtpdv.GetCTPDVById(item.Id);
                _dataTableCtpgcReview.Rows.Add(new object[]
                {
                    null,
                    ctpdv.SoPhieuDV,
                    item.Id,
                    /*MaLoaiSP*/ ctpdv.MaLoaiSP,
                    /*TenLoaiSP*/ ctpdv.MaLoaiSP == null ? "Khác" : listLoaiSp.Find(i => i.MaLoaiSP == ctpdv.MaLoaiSP).TenLoaiSP,
                    /*HTGC*/ ctpdv.GhiChu.Trim(),
                    /*Soluong*/ item.SoLuong,
                    /*TienCong*/ item.TienCong,
                    /*ThanhTien*/ item.ThanhTien
                });
            }
            gridControlCTPGC_review.DataSource = _dataTableCtpgcReview;
            gridViewCTPGC_review.Columns["SoPhieuDV"].GroupIndex = 0;
            gridViewCTPGC_review.ExpandAllGroups();
            CalculateTongTien();
        }
        private void LoadCtpdvCanGiaCong()
        {
            BUL_LoaiSanPham    bulLoaiSp  = new BUL_LoaiSanPham();
            List <LOAISANPHAM> listLoaiSp = bulLoaiSp.getAllProductType();
            BUL_CTPDV          bulCtpdv   = new BUL_CTPDV();
            List <CTPDV>       listCtpdv  = bulCtpdv.GetCTPDVGiaCong();
            BUL_CTPGC          bulCtpgc   = new BUL_CTPGC();

            _dataTableCtspCanGiaCong.Rows.Clear();
            foreach (var item in listCtpdv)
            {
                _dataTableCtspCanGiaCong.Rows.Add(new object[]
                {
                    null,
                    item.Id,
                    item.SoPhieuDV,
                    /*MaLoaiSP*/ item.MaLoaiSP == null ? -1 : item.MaLoaiSP,
                    /*TenLoaiSP*/ item.MaLoaiSP == null ? "Khác" : listLoaiSp.Find(i => i.MaLoaiSP == item.MaLoaiSP).TenLoaiSP,
                    /*HTGC*/ item.GhiChu.Trim(),
                    /*Soluong*/ item.SoLuong - bulCtpgc.GetSoluongByIdPDV(item.Id),
                    /*TienCong*/ item.TienCong
                });
            }
            gridControlCTSPGC.DataSource = _dataTableCtspCanGiaCong;

            gridViewCTSPGC.Columns["SoPhieuDV"].GroupIndex = 0;
            gridViewCTSPGC.ExpandAllGroups();
        }