private void bindData(int index)
        {
            try
            {
                //LAY DANH SACH CAC QUOC GIA RA
                dsGroup = new DataTable();
                dsPhieuNhapXuat = new DataTable();
                clsPhieuNhap objPhieuNhap = new clsPhieuNhap();
                clsPhieuXuat objPhieuXuat = new clsPhieuXuat();

                if (sLoaiPhieu == "0")
                {
                    objPhieuNhap.So_Phieu = sKey;
                    dsGroup = objPhieuNhap.Select_ChiTiet();
                    objPhieuNhap.PhieuNhap_Id = sPhieu_Id;
                    dsPhieuNhapXuat = objPhieuNhap.Select();
                    if (dsPhieuNhapXuat.Rows.Count > 0)
                    {
                        if (Convert.ToInt16(dsPhieuNhapXuat.Rows[0]["LoaiNhapXuat_Id"]) == 1)
                        {
                            txtLoaiNhapXuat.Text = "Phiếu nhập";
                        }
                        else
                        {
                            txtLoaiNhapXuat.Text = "Phiếu xuất";
                        }
                        txtSoPhieu.Text = dsPhieuNhapXuat.Rows[0]["so_phieu"].ToString();
                        txtLyDoNhap.Text = dsPhieuNhapXuat.Rows[0]["LyDoNhap"].ToString();
                        txtDienGiai.Text = dsPhieuNhapXuat.Rows[0]["Dien_Giai"].ToString();
                        dtpNgayNhapXuat.SelectedDate = Convert.ToDateTime(dsPhieuNhapXuat.Rows[0]["Ngay_Nhap"]);
                        if (dsPhieuNhapXuat.Rows[0]["DuAn_DanhRieng_Id"] == DBNull.Value)
                        {
                            txtDuAnDanhRieng.Text = "";
                        }
                        else
                        {
                            txtDuAnDanhRieng.Text = dsPhieuNhapXuat.Rows[0]["DuAn_DanhRieng_Id"].ToString();
                        }
                        txtNhanVienBan.Text = dsPhieuNhapXuat.Rows[0]["TenDayDu"].ToString();
                        txtNhanVienDoiTac.Text = dsPhieuNhapXuat.Rows[0]["TenDoiTac"].ToString();
                    }
                }
                else
                {
                    objPhieuXuat.So_Phieu = sKey;
                    dsGroup = objPhieuXuat.Select_ChiTiet();
                    objPhieuXuat.PhieuXuat_Id = sPhieu_Id;
                    dsPhieuNhapXuat = objPhieuXuat.Select();
                    if (dsPhieuNhapXuat.Rows.Count > 0)
                    {
                        if (Convert.ToInt16(dsPhieuNhapXuat.Rows[0]["LoaiNhapXuat_Id"]) == 1)
                        {
                            txtLoaiNhapXuat.Text = "Phiếu nhập";
                        }
                        else
                        {
                            txtLoaiNhapXuat.Text = "Phiếu xuất";
                        }
                        txtSoPhieu.Text = dsPhieuNhapXuat.Rows[0]["so_phieu"].ToString();
                        txtLyDoNhap.Text = dsPhieuNhapXuat.Rows[0]["LyDoXuat"].ToString();
                        txtDienGiai.Text = dsPhieuNhapXuat.Rows[0]["Dien_Giai"].ToString();
                        dtpNgayNhapXuat.SelectedDate = Convert.ToDateTime(dsPhieuNhapXuat.Rows[0]["Ngay_Xuat"]);
                        if (dsPhieuNhapXuat.Rows[0]["DuAn_Id"] == DBNull.Value)
                        {
                            txtDuAnDanhRieng.Text = "";
                        }
                        else
                        {
                            txtDuAnDanhRieng.Text = dsPhieuNhapXuat.Rows[0]["DuAn_Id"].ToString();
                        }
                        txtNhanVienBan.Text = dsPhieuNhapXuat.Rows[0]["TenDayDu"].ToString();
                        txtNhanVienDoiTac.Text = dsPhieuNhapXuat.Rows[0]["TenDoiTac"].ToString();
                    }
                }
                objPhieuNhap.So_Phieu = "0";

                m_grid.EditIndex = index;
                m_grid.DataSource = dsGroup;
                bool add = false;
                if (dsGroup.Rows.Count <= 0)
                {
                    dsGroup.Rows.Add(dsGroup.NewRow());
                    add = true;

                }
                //
                m_grid.DataBind();
                if (add)
                    m_grid.Rows[0].Visible = false;
                if (m_grid.Rows.Count > 0)
                {
                    string confirm = "return confirm('Bạn thật sự muốn xóa row này?')";

                    for (int i = 0; i < m_grid.Rows.Count; i++)
                    {
                        GridViewRow row = m_grid.Rows[i];
                        LinkButton lbutton1 = (LinkButton)row.FindControl("cmdDelete");
                        if (lbutton1 != null)
                        {
                            lbutton1.Visible = D_Option;
                            lbutton1.Attributes.Add("onclick", confirm);
                            //lbutton1.Enabled = D_Option;
                        }

                        LinkButton lbutton2 = (LinkButton)row.FindControl("cmdEdit");
                        if (lbutton2 != null)
                            lbutton2.Visible = U_Option;
                    }
                }

                //XET QUYETN CHO CHUC NANG INSERT
                GridViewRow row1 = m_grid.FooterRow;
                if (row1 != null)
                {
                    row1.Visible = I_Option;
                }
            }
            catch (Exception ex)
            {
            }
        }
        private void bindData(int index)
        {
            try
            {
                //LAY DANH SACH CAC QUOC GIA RA
                dsGroup = new DataTable();

                //Hiển thị tổng hợp
                clsPhieuXuat oPhieuXuat = new clsPhieuXuat();
                DataTable tblPhieuXuat = new DataTable();
                oPhieuXuat.PhieuXuat_Id = sKey;
                dsGroup = oPhieuXuat.Select_ThongTinThietBi();
                //
                tblPhieuXuat = oPhieuXuat.Select();
                if (tblPhieuXuat.Rows.Count > 0)
                {
                    txtSoPhieu.Text = tblPhieuXuat.Rows[0]["So_Phieu"].ToString();
                    dtpNgayNhap.SelectedDate = Convert.ToDateTime(tblPhieuXuat.Rows[0]["Ngay_Xuat"]);
                    txtNguoiNhan.Text = tblPhieuXuat.Rows[0]["NguoiXuat"].ToString();
                }

                m_grid.EditIndex = index;
                m_grid.DataSource = dsGroup;
                bool add = false;
                if (dsGroup.Rows.Count <= 0)
                {
                    dsGroup.Rows.Add(dsGroup.NewRow());
                    add = true;

                }
                //
                m_grid.DataBind();
                if (add)
                    m_grid.Rows[0].Visible = false;
                if (m_grid.Rows.Count > 0)
                {
                    string confirm = "return confirm('Bạn thật sự muốn xóa row này?')";

                    for (int i = 0; i < m_grid.Rows.Count; i++)
                    {
                        GridViewRow row = m_grid.Rows[i];
                        LinkButton lbutton1 = (LinkButton)row.FindControl("cmdDelete");
                        if (lbutton1 != null)
                        {
                            lbutton1.Visible = D_Option;
                            lbutton1.Attributes.Add("onclick", confirm);
                            //lbutton1.Enabled = D_Option;
                        }

                        LinkButton lbutton2 = (LinkButton)row.FindControl("cmdEdit");
                        if (lbutton2 != null)
                            lbutton2.Visible = U_Option;
                    }
                }

                //XET QUYETN CHO CHUC NANG INSERT
                GridViewRow row1 = m_grid.FooterRow;
                if (row1 != null)
                {
                    row1.Visible = I_Option;
                }
                //
                string connectionString = System.Configuration.ConfigurationManager.ConnectionStrings["SQLConn"].ToString();// "server='NgoQuangLua-PC'; uid=sa;pwd=sa; Database='QL'; trusted_connection=true;";
                System.Data.SqlClient.SqlConnection sqlConnection = new System.Data.SqlClient.SqlConnection(connectionString);
                string queryString = "select COUNT(*) sl_danhap from ThongTinThietBi a where a.PhieuXuat_Id='"+ sKey +"' and a.ThietBi_Id='"+ cboThietBi.SelectedValue +"'";
                sqlConnection.Open();
                SqlDataAdapter oAdap = new SqlDataAdapter(queryString, sqlConnection);

                DataTable tblTemp = new DataTable();
                oAdap.Fill(tblTemp);
                if (tblTemp.Rows.Count > 0)
                {
                    txtSoLuongDaCoChiTiet.Text = tblTemp.Rows[0]["sl_danhap"].ToString();
                    txtSoLuongCanNhapChiTiet.Text = (Convert.ToInt16(txtSoLuongNhapKho.Text == "" ? "0" : txtSoLuongNhapKho.Text) - Convert.ToInt16(txtSoLuongDaCoChiTiet.Text == "" ? "0" : txtSoLuongDaCoChiTiet.Text)).ToString();
                }
                else
                {
                    txtSoLuongDaCoChiTiet.Text = "0";
                    txtSoLuongCanNhapChiTiet.Text = (Convert.ToInt16(txtSoLuongNhapKho.Text == "" ? "0" : txtSoLuongNhapKho.Text) - Convert.ToInt16(txtSoLuongDaCoChiTiet.Text == "" ? "0" : txtSoLuongDaCoChiTiet.Text)).ToString();
                }

            }
            catch (Exception ex)
            {
            }
        }