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 simpleButtonSua_Click(object sender, EventArgs e)
        {
            int       soluong   = Convert.ToInt32(textEditSoLuong.Text);
            DataRow   drReview  = gridViewCTPGC_review.GetDataRow(gridViewCTPGC_review.FocusedRowHandle);
            BUL_CTPDV bulCtpdv  = new BUL_CTPDV();
            int       slTrenPdv = bulCtpdv.GetSoLuongById(Convert.ToInt32(drReview["Id"]));

            if (soluong > slTrenPdv)
            {
                MessageBox.Show(Resources.SuaPhieuGiaCong_SoLuongNhapGCToiDa
                                + Resources.SuaPhieuGiaCong_SLToiDaCoTheNhap + slTrenPdv, Resources.TitleMessageBox_Error,
                                MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }
            BUL_CTPGC bulCtpgc = new BUL_CTPGC();
            CTPGC     ctpgc    = new CTPGC();

            ctpgc.Id         = Convert.ToInt32(drReview["Id"]);
            ctpgc.SoPhieuGC  = _soPGC;
            ctpgc.TrongLuong = 0.1;
            ctpgc.SoLuong    = Convert.ToInt32(soluong);
            ctpgc.TienCong   = Convert.ToInt32(textEditTienCong.Text);
            ctpgc.ThanhTien  = Convert.ToDecimal(textEditTongTien.Text);
            bulCtpgc.UpdateCTPGC(ctpgc);
            MessageBox.Show(Resources.SuaPhieuGiaCong_SuaCTPGCThanhCong, Resources.TitleMessageBox_ThongBao, MessageBoxButtons.OK, MessageBoxIcon.Information);
            LoadCtpgc_review();
            LoadCtpdvCanGiaCong();
        }
        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();
        }