C# GridView.GetDataRow方法代码示例

        /// <summary>
        /// Thêm danh sách menu ngữ cảnh vào trong GridView.
        /// Menu này áp dụng khi click phải trên phần nội dung của lưới
        /// </summary>
        public static void AddContextMenu(GridView grid, List<ItemInfo> items)
        {
            BarManager manager = new BarManager(); ;
            PopupMenu menu = new PopupMenu();

            if (items == null) return;
            for (int i = 0; i < items.Count; i++)
            {
                if (items[i].Per != null)
                    if (ApplyPermissionAction.checkPermission(items[i].Per) == null ||
                       ApplyPermissionAction.checkPermission(items[i].Per) == false)
                    {
                        continue;
                    }

                Image image = ResourceMan.getImage16(items[i].Image);
                BarItem item = new BarButtonItem();
                item.Caption = items[i].Caption;
                item.Name = i.ToString();
                item.Glyph = image;
                manager.Items.Add(item);
                menu.ItemLinks.Add(manager.Items[i]);
                DelegationLib.CallFunction_MulIn_NoOut del = items[i].Delegates;
                item.ItemClick += delegate(object sender, ItemClickEventArgs e)
                {
                    string name = item.Name;
                    List<object> objs = new List<object>();

                    int[] a = grid.GetSelectedRows();
                    DataRow dr = grid.GetDataRow(a[0]);
                    objs.Add(dr);

                    del(objs);
                };
            }

            grid.MouseUp += delegate(object sender, MouseEventArgs e)
            {
                if ((e.Button & MouseButtons.Right) != 0 && grid.GridControl.ClientRectangle.Contains(e.X, e.Y))
                {
                    menu.ShowPopup(manager, Control.MousePosition);
                }
                else
                {
                    menu.HidePopup();
                }
            };

            grid.MouseMove += delegate(object sender, MouseEventArgs e)
            {
                if ((e.Button & MouseButtons.Right) != 0 && grid.GridControl.ClientRectangle.Contains(e.X, e.Y))
                {
                    menu.ShowPopup(manager, Control.MousePosition);
                }
                else
                {
                    menu.HidePopup();
                }
            };
        }

 public void CheckDuplicateDIEM_THEO_DOI_NOP_BAI(GridView grid, DataSet GridDataSet, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
 {
     DataRow row = grid.GetDataRow(e.RowHandle);
     int count = 0;
     foreach (DataRow r in GridDataSet.Tables[0].Rows)
     {
         if (r.RowState != DataRowState.Deleted)
         {
             if (r["NHAN_SU"].ToString() == row["NHAN_SU"].ToString() && r["NGUOI_GIAO"].ToString() == row["NGUOI_GIAO"].ToString() && r["NGAY_GIAO"].ToString() == row["NGAY_GIAO"].ToString())
             {
                 if (grid.IsNewItemRow(grid.FocusedRowHandle))
                 {
                     r.RowError = "Dữ liệu bị trùng, xin vui lòng kiểm tra lại.";
                     grid.SetColumnError(grid.Columns["NHAN_SU"], "Nhân sự, người giao và ngày giao bị trùng, xin vui lòng kiểm tra lại.");
                     e.Valid = false;
                     return;
                 }
                 else
                 {
                     count++;
                     if (count == 2)
                     {
                         r.RowError = "Dữ liệu bị trùng, xin vui lòng kiểm tra lại.";
                         grid.SetColumnError(grid.Columns["NHAN_SU"], "Nhân sự, người giao và ngày giao bị trùng, xin vui lòng kiểm tra lại.");
                         e.Valid = false;
                         return;
                     }
                 }
             }
         }
     }
 }

 private int GetRowHandleByColumnValue(GridView view, string ColumnFieldName, object value)
 {
     int result = GridControl.InvalidRowHandle;
     for (int i = 0; i < view.RowCount; i++)
     {
         if (view.GetDataRow(i)[ColumnFieldName].Equals(value))
             return i;
     }
         
     return result;
 }

        /// <summary>Kiểm tra Duplicate trên 1 tổ hợp Field ( Dùng cho 2 field unique chính trở lên )
        /// </summary>
        public static bool CheckDuplicateAllField(GridView grid, DataSet GridDataSet, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e, string[] FieldChecks, string[] Subjects)
        {
            DataRow row = grid.GetDataRow(e.RowHandle);
            int times = 0;
            for (int i = 0; i < GridDataSet.Tables[0].Rows.Count; i++)
            {
                if (GridDataSet.Tables[0].Rows[i].RowState != DataRowState.Deleted)
                {
                    int count = 0;
                    for (int j = 0; j < FieldChecks.Length; j++)
                    {
                        if (row[FieldChecks[j]] == null || row[FieldChecks[j]] == DBNull.Value)
                        {
                            //PHUOCNC : Tạm thời không xử lý
                        }
                        else
                        {
                            string tmp = row[FieldChecks[j]].ToString().Trim();
                            if (GridDataSet.Tables[0].Rows[i][FieldChecks[j]] != null &&
                                GridDataSet.Tables[0].Rows[i][FieldChecks[j]] != DBNull.Value &&
                                tmp == GridDataSet.Tables[0].Rows[i][FieldChecks[j]].ToString())
                            {
                                count++;
                            }
                        }
                    }
                    if(count == FieldChecks.Length) {
                        times++;
                        if (times >= 2) break;
                    }
                }
            }
            string error = "Thông tin tại cột (" + Subjects[0] ;
            for (int i = 1; i < Subjects.Length; i++)
            {
                error += "," + Subjects[i];
            }
            error += ") đã sử dụng !";

            for (int i = 0; i < Subjects.Length; i++)
            {
                if ((row.RowState == DataRowState.Detached && times == 1)||(times > 1))
                {
                    row.SetColumnError(FieldChecks[i], error);
                    e.Valid = false;
                }
                else
                {
                    row.SetColumnError(FieldChecks[i], "");
                }
            }

            return e.Valid;
        }

        public RepositoryPLGridSelect(XtraForm frmDanhMuc ,string columnField, string tableName , string ValueField , string[] visibleField , string[] caption , string getField , GridView gridView)
        {
            init();
            plDanhMuc.GridView = gridView;
            plDanhMuc._init(frmDanhMuc ,columnField, tableName ,ValueField , visibleField , caption , getField);

            gridView.GotFocus += delegate(object sender , EventArgs e)
            {
                if (gridView.DataSource != null &&
                    !((DataView)gridView.DataSource).Table.Columns.Contains(columnField + getField))
                {
                    ((DataView)gridView.DataSource).Table.Columns.Add(new DataColumn(columnField + getField));
                }
            };
            int idValue;
            gridView.CellValueChanged += delegate(object sender , DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
            {

                if (e.Column.FieldName.Equals(columnField+getField))
                {
                    idValue = _getId(e.Value);
                    if (e.RowHandle < 0)
                    {
                        gridView.EditingValue = idValue;
                        gridView.SetFocusedRowCellValue(gridView.Columns.ColumnByFieldName(columnField) , idValue);
                    }
                    else
                    {
                        DataRow row = gridView.GetDataRow(e.RowHandle);
                        row[columnField] = idValue;
                    }
                }

            };

            gridView.InitNewRow += delegate(object sender , InitNewRowEventArgs e)
            {
                  gridView.SetRowCellValue(e.RowHandle , columnField + getField , plDanhMuc.GridViewEditor.FocusedValue);
            };
            this.Popup += new EventHandler(RepositoryHuyDanhMuc_Popup);
            this.Leave += new EventHandler(RepositoryDanhMucAdv_Leave);
        }

        public RepositoryItemDataTreeNewExt(XtraForm danhMucForm , GridView gridView ,string columnField, string TableName , int[] RootID , string ValueField , string IDParentField , string[] VisibleFields , string[] Captions , string getField)
        {
            init();
            dataTree.GridView = gridView;
            dataTree._BuildTree(danhMucForm ,columnField, TableName , RootID ,ValueField , IDParentField , VisibleFields , Captions , getField);
            int idValue ;

            gridView.GotFocus += delegate(object sender , EventArgs e)
            {
                if (gridView.DataSource != null &&
                   !((DataView)gridView.DataSource).Table.Columns.Contains(columnField + getField))
                {
                    ((DataView)gridView.DataSource).Table.Columns.Add(new DataColumn(columnField + getField));
                }
            };
            gridView.CellValueChanged += delegate(object sender , DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
            {
                if (e.Column.FieldName.Equals(columnField+getField))
                {
                    idValue = _getId(e.Value);
                    if (e.RowHandle < 0)
                    {
                        gridView.EditingValue = idValue;
                        gridView.SetRowCellValue(e.RowHandle , columnField , idValue);
                    }
                    else
                    {
                        DataRow dr = gridView.GetDataRow(e.RowHandle);
                        dr[columnField] = idValue;
                    }
                }
            };
            gridView.InitNewRow +=delegate(object sender , InitNewRowEventArgs e)
            {
                gridView.SetRowCellValue(e.RowHandle , columnField + getField , dataTree.TreeListEditor.FocusedNode.GetValue(getField));
            };
        }

        public BookRefund()
        {
            InitializeComponent();
            this.Dock = DockStyle.Fill;

            this.reloadGrid();

            gridViewNick = gridView1;

            DataRow CurrentRow = gridViewNick.GetDataRow(0);

            if (CurrentRow != null)
            {
                if (CurrentRow["coderef"].ToString() != "")
                {
                    textEditReserveID.EditValue = CurrentRow["reserve_id"].ToString();
                    textEditRoomNo.EditValue = CurrentRow["coderef"].ToString();
                    textEditName.EditValue = CurrentRow["reserve_name"].ToString();
                    textEditAmount.EditValue = CurrentRow["reserve_payments"].ToString();

                    if (CurrentRow["reserve_flag"].ToString() != "0")
                    {

                        simpleButton2.Enabled = false;
                        simpleButton1.Enabled = false;
                    }
                    else
                    {
                        simpleButton2.Enabled = true;
                        simpleButton1.Enabled = true;
                    }

                }
            }

            gridViewNick.FocusedRowChanged += new DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventHandler(gridView1_FocusedRowChanged);
        }

        public static void CreateBusinessMenu(
            GridView gridViewMaster,
            DevExpress.XtraBars.BarSubItem barSubItem1,
            string fieldName,
            string[] captions,
            string[] ImageNames,
            DelegationLib.CallFunction_MulIn_NoOut[] delegates,
            PermissionItem[] pers)
        {
            if (captions == null)
            {
                //barSubItem1.Enabled = false;
                barSubItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
                return;
            }

            int index = 0;
            foreach (string s in captions)
            {
                //Start Check Permission
                if (pers != null)
                {
                    if (pers[index] != null)
                    {
                        if (ApplyPermissionAction.checkPermission(pers[index]) == null ||
                            ApplyPermissionAction.checkPermission(pers[index]) == false)
                        {
                            index++;
                            continue;
                        }
                    }
                }
                //End Check Permission

                DevExpress.XtraBars.BarButtonItem temp = new DevExpress.XtraBars.BarButtonItem();
                temp.Caption = captions[index];
                temp.Name = index.ToString();
                if (!ImageNames[index].Equals(""))
                {
                    temp.Glyph = ResourceMan.getImage16(ImageNames[index]);
                }
                temp.PaintStyle = DevExpress.XtraBars.BarItemPaintStyle.CaptionGlyph;
                temp.ItemClick += delegate(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
                {
                    if (gridViewMaster.SelectedRowsCount < 1)
                    {
                        HelpMsgBox.ShowNotificationMessage("Vui lòng chọn dữ liệu !");
                        return;
                    }
                    //Lấy danh sách các giá trị (row[fieldName]) đang chọn
                    List<object> objs = new List<object>();
                    foreach (int i in gridViewMaster.GetSelectedRows())
                    {
                        DataRow row = gridViewMaster.GetDataRow(i);
                        objs.Add(row[fieldName]);
                    }

                    //Chọn xử lý tương ứng với chọn lựa
                    delegates[HelpNumber.ParseInt32(e.Item.Name)](objs);
                };

                barSubItem1.ItemLinks.Add(temp);
                index++;
            }
            //Không có chọn lựa ẩn luôn.
            if (barSubItem1.ItemLinks == null || barSubItem1.ItemLinks.Count == 0)
                barSubItem1.Visibility = DevExpress.XtraBars.BarItemVisibility.Never;
        }

        public RepositoryComboboxAuto(GridView gridView , string idField , string tableName , string valueField , string displayField , bool startWith)
            : this()
        {
            ParamInfo.tableName = tableName;
            ParamInfo.valueField = valueField;
            ParamInfo.displayField = displayField;
            ParamInfo.startWith = startWith;
            long idValue = -1;
            gridView.CellValueChanging+= delegate(object sender , DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e)
            {
                if (gridView.DataSource != null &&
                      !((DataView)gridView.DataSource).Table.Columns.Contains(idField + displayField))
                {
                    ((DataView)gridView.DataSource).Table.Columns.Add(new DataColumn(idField + displayField));
                }

                if ((idField+displayField).Equals(e.Column.FieldName))
                {
                    if (e.Value is ItemData)
                        idValue = ((ItemData)e.Value).ID;
                    else
                        idValue = -1;

                    if (e.RowHandle < 0)
                        gridView.SetRowCellValue(e.RowHandle , idField , idValue);
                    else
                    {
                        DataRow dr = gridView.GetDataRow(e.RowHandle);
                        dr[idField] = idValue;
                    }

                }
            };
            gridView.InitNewRow += delegate(object sender , InitNewRowEventArgs e)
            {
                gridView.SetRowCellValue(e.RowHandle , idField , idValue);
            };
        }

 public DataTable GetTableOfSelectedRows(GridView view)
 {
     DataTable resultTable = new DataTable();
     DataTable sourceTable = null;
     if (view.DataSource is DataView)
         sourceTable = ((DataView)view.DataSource).Table;
     else if (view.DataSource is BindingSource)
     {
         object dv = ((BindingSource)view.DataSource).List;
         sourceTable = ((DataView)dv).Table;
     }
     if (sourceTable != null)
     {
         resultTable = sourceTable.Clone();
         foreach (int rowHandle in view.GetSelectedRows())
         {
             DataRow row = view.GetDataRow(rowHandle);
             resultTable.Rows.Add(row.ItemArray);
         }
         resultTable.AcceptChanges();
     }
     return resultTable;
 }

 public void processTEN_TAI_LIEU(GridHitInfo gHitInfo, GridView view, bool? IsAdd, DataSet GridDataSet)
 {
     if (gHitInfo.Column.FieldName == "TEN_TAI_LIEU")
     {
         if (IsAdd != null)
         {
             if (view.IsNewItemRow(view.FocusedRowHandle))
                 DANopBai.Instance.UpData(view);
             else DANopBai.Instance.UpdateData(view);
         }
         else
         {
             object o = HelpDB.getDatabase().LoadDataSet("select NOI_DUNG from " + GridDataSet.Tables[0].TableName.Trim() + " where DTD_ID = " + HelpNumber.ParseInt64(view.GetDataRow(view.FocusedRowHandle)["DTD_ID"].ToString())).Tables[0].Rows[0]["NOI_DUNG"];
             DANopBai.Instance.openSaveFile(gHitInfo, view, null, (o == System.DBNull.Value ? null : (byte[])o));
         }
     }
 }

 private int FindRowHandleByDataRow(GridView view, DataRow row)
 {
     if (row != null)
         for (var i = 0; i < view.DataRowCount; i++)
             if (view.GetDataRow(i) == row)
                 return i;
     return GridControl.InvalidRowHandle;
 }

 public bool CheckDuplicateDIEM_THEO_DOI_LEN_LOP(GridView grid, DataSet gridDataSet, DevExpress.XtraGrid.Views.Base.ValidateRowEventArgs e)
 {
     DataRow dataRow = grid.GetDataRow(e.RowHandle);
     if (Convert.ToDateTime(dataRow[2]).TimeOfDay > Convert.ToDateTime(dataRow[3]).TimeOfDay)
     {
         grid.SetColumnError(grid.Columns[2], "Thời gian bắt đầu lớn hơn thời gian kết thúc");
         e.Valid = false;
         return false;
     }
     for (int i = 0; i < gridDataSet.Tables[0].Rows.Count; i++)
     {
         if (long.Parse(dataRow[4].ToString()) == long.Parse(gridDataSet.Tables[0].Rows[i][4].ToString()))
             if (Convert.ToDateTime(dataRow[1]) == Convert.ToDateTime(gridDataSet.Tables[0].Rows[i][1]))
             {
                 if ((Convert.ToDateTime(dataRow[2]).TimeOfDay > Convert.ToDateTime(gridDataSet.Tables[0].Rows[i][2]).TimeOfDay) && (Convert.ToDateTime(dataRow[2]).TimeOfDay < Convert.ToDateTime(gridDataSet.Tables[0].Rows[i][3]).TimeOfDay))
                 {
                     grid.SetColumnError(grid.Columns[2], "Thời gian không hợp lý");
                     e.Valid = false;
                     return false;
                 }
                 if ((Convert.ToDateTime(dataRow[3]).TimeOfDay > Convert.ToDateTime(gridDataSet.Tables[0].Rows[i][2]).TimeOfDay) && (Convert.ToDateTime(dataRow[3]).TimeOfDay < Convert.ToDateTime(gridDataSet.Tables[0].Rows[i][3]).TimeOfDay))
                 {
                     grid.SetColumnError(grid.Columns[3], "Thời gian không hợp lý");
                     e.Valid = false;
                     return false;
                 }
                 if ((Convert.ToDateTime(dataRow[2]).TimeOfDay < Convert.ToDateTime(gridDataSet.Tables[0].Rows[i][2]).TimeOfDay) && (Convert.ToDateTime(dataRow[3]).TimeOfDay > Convert.ToDateTime(gridDataSet.Tables[0].Rows[i][3]).TimeOfDay))
                 {
                     grid.SetColumnError(grid.Columns[2], "Thời gian không hợp lý");
                     e.Valid = false;
                     return false;
                 }
             }
     }
     return true;
 }

 public static void UpdateDuyetState(
     bool DuyetSupport,
     bool AllowUpdatePhieuDuyet,
     GridView gridViewMaster,
     DevExpress.XtraBars.BarButtonItem barButtonItemCommit,
     DevExpress.XtraBars.BarButtonItem barButtonItemNoCommit,
     DevExpress.XtraBars.BarButtonItem barButtonItemDelete,
     DevExpress.XtraBars.BarButtonItem barButtonItemUpdate)
 {
     if (DuyetSupport)
     {
         DataRow row = gridViewMaster.GetDataRow(gridViewMaster.FocusedRowHandle);
         if (row["DUYET"] == null) row["DUYET"] = "1";
         if (row["DUYET"].ToString() == "1")
         {
             barButtonItemCommit.Enabled = true;
             barButtonItemNoCommit.Enabled = true;
             barButtonItemDelete.Enabled = true;
             barButtonItemUpdate.Enabled = true;
         }
         else if (row["DUYET"].ToString() == "3")
         {
             barButtonItemCommit.Enabled = true;
             barButtonItemNoCommit.Enabled = false;
             barButtonItemDelete.Enabled = true;
             barButtonItemUpdate.Enabled = true;
         }
         else if (row["DUYET"].ToString() == "2")
         {
             if (AllowUpdatePhieuDuyet)
             {
                 barButtonItemCommit.Enabled = false;
                 barButtonItemNoCommit.Enabled = true;
             }
             else
             {
                 barButtonItemCommit.Enabled = false;
                 barButtonItemNoCommit.Enabled = false;
             }
             barButtonItemUpdate.Enabled = false;
             barButtonItemDelete.Enabled = false;
         }
     }
 }

        //Nghiên cứu
        public void UpData(GridView view)
        {
            string path = null;
            OpenFileDialog openFile = new OpenFileDialog();
            openFile.Title = "Chọn file để cập nhật tài liệu:";
            DialogResult value = openFile.ShowDialog();
            if (value == DialogResult.OK)
            {
                path = openFile.FileName;
                //Kiểm tra độ lớn của file
                if (!HelpFile.CheckFileSize(path, 20))
                {
                    //Độ lớn của file lớn hơn độ lớn qui định
                    HelpMsgBox.ShowNotificationMessage("Bạn không được chọn file lớn hơn 20 MB.");
                    path = null;
                    UpData(view);
                }
            }
            else if (value == DialogResult.Cancel)
            {
                path = null;
                return;
            }

            Thread.Sleep(200);
            if (path != null)
            {
                byte[] bytes = null;
                bytes = HelpFile.FileToBytes(path);
                DataRow row = view.GetDataRow(view.FocusedRowHandle);
                if (row == null) HelpMsgBox.ShowNotificationMessage("Bạn chưa chọn nhân sự, vui lòng vào thông tin nhân sự!");
                else
                {
                    row["TEN_TAI_LIEU"] = Path.GetFileName(path);
                    row["NOI_DUNG"] = bytes;
                    row["NGAY_NOP"] = DateTime.Now;
                }
            }
        }