C# GridView.GetRowCellValue方法代码示例

        private void ValidateInspection(GridView view, string NameColumn, ValidateRowEventArgs e)
        {
            string Name = (string)view.GetRowCellValue(e.RowHandle, NameColumn);

            view.ClearColumnErrors();

            if(String.IsNullOrEmpty(Name))
            {
                view.SetColumnError(inspectorsGridColumn,
                   Program.LanguageManager.GetString(StringResources.SelectInspectorsForTestResult));
                e.Valid = false;
            }
        }

        void ValidateCertificate(GridView view, GridColumn certNameColumn, GridColumn expDateColumn, ValidateRowEventArgs e)
        {
            string certName = (string)view.GetRowCellValue(e.RowHandle, certNameColumn);
            DateTime? certExpDate = (DateTime?)view.GetRowCellValue(e.RowHandle, expDateColumn);

            view.ClearColumnErrors();

            if (string.IsNullOrWhiteSpace(certName))
            {
                view.SetColumnError(certNameColumn, Program.LanguageManager.GetString(StringResources.Settings_ValueRequired));
                e.Valid = false;
            }
        }

        void ValidatePersonName(GridView view, GridColumn firstNameColumn, GridColumn lastNameColumn, ValidateRowEventArgs e)
        {

            string firstName = (string)view.GetRowCellValue(e.RowHandle, firstNameColumn);
            string lastName = (string)view.GetRowCellValue(e.RowHandle, lastNameColumn);

            view.ClearColumnErrors();

            if (String.IsNullOrEmpty(firstName))
            {
                view.SetColumnError(firstNameColumn,
                    Program.LanguageManager.GetString(StringResources.Settings_ValueRequired));
                e.Valid = false;
            }

            if (String.IsNullOrEmpty(lastName))
            {
                view.SetColumnError(lastNameColumn,
                   Program.LanguageManager.GetString(StringResources.Settings_ValueRequired));
                e.Valid = false;
            }
        }

        //获取当前checkbox选中行数
        private int getChoiceCount(GridView gridview)
        {
            int choiceCount = 0;
            for (int i = 0; i < gridview.RowCount; i++)
            {
                if (gridview.GetRowCellValue(i, "selected") != null)
                {
                    if ((bool)gridview.GetRowCellValue(i, "selected") == true)
                    {
                        choiceCount++;
                    }
                }

            }
            return choiceCount;
        }

        SchedulerDragData GetDragData(GridView view)
        {
            int[] selection = view.GetSelectedRows();
            if (selection == null)
                return null;

            AppointmentBaseCollection appointments = new AppointmentBaseCollection();
            int count = selection.Length;
            for (int i = 0; i < count; i++) {
                int rowIndex = selection[i];
                Appointment apt = schedulerStorage1.CreateAppointment(AppointmentType.Normal);
                apt.Subject = "Programación de Visita Cliente " + (string)view.GetRowCellValue(rowIndex, "NombreCliente");
                apt.LabelId = (int)Entidades.Enums.Enums.VisitaEstadoVista.Pendiente; // (int)view.GetRowCellValue(rowIndex, "Severity");
                apt.StatusId = 0; // (int)view.GetRowCellValue(rowIndex, "Priority");
                apt.Duration = new TimeSpan(0, 1, 0, 0); // TimeSpan.FromHours((int)view.GetRowCellValue(rowIndex, "Duration"));
                apt.Description = "Visita Cliente " + (string)view.GetRowCellValue(rowIndex, "NombreCliente");
                IdClienteDraw = (Int64)view.GetRowCellValue(rowIndex, "Id");
                appointments.Add(apt);
            }

            return new SchedulerDragData(appointments, 0);
        }

        public static void SetCellDisable(GridView view, string FieldName, string KeyField, long[] KeyValues)
        {
            view.CustomDrawCell += delegate(object sender, RowCellCustomDrawEventArgs e)
            {
                if (e.RowHandle == view.FocusedRowHandle) return;

                if (e.Column.FieldName == FieldName)
                {
                    for (int vt = 0; vt <= KeyValues.Length - 1; vt++)
                    {
                        //if (Convert.ToInt64(view.GetRowCellDisplayText(e.RowHandle, KeyField)) == KeyValues[vt])
                        //{
                        //    e.Appearance.BackColor = Color.Gray;
                        //    // view.Columns[FieldName].OptionsColumn.AllowFocus = false;
                        //}
                        if (Convert.ToInt64(view.GetRowCellValue(e.RowHandle, KeyField)) == KeyValues[vt])
                        {
                            e.Appearance.BackColor = Color.Gray;
                            // view.Columns[FieldName].OptionsColumn.AllowFocus = false;
                        }
                    }
                }
            };
            view.ShowingEditor += delegate(object sender, CancelEventArgs e)
            {
                int index = view.FocusedRowHandle;
                if (index >= 0)
                {
                    for (int vt = 0; vt <= KeyValues.Length - 1; vt++)
                    {
                        //if (Convert.ToInt64(view.GetRowCellDisplayText(index, KeyField)) == KeyValues[vt]
                        //    && view.FocusedColumn.FieldName == FieldName)
                        //{
                        //    e.Cancel = true;
                        //}
                        if (Convert.ToInt64(view.GetRowCellValue(index, KeyField)) == KeyValues[vt]
                            && view.FocusedColumn.FieldName == FieldName)
                        {
                            e.Cancel = true;
                        }
                    }
                }
            };
        }

 public void openSaveFile(GridHitInfo gHitInfo, GridView view, string path, byte[] bytes)
 {
     if (HelpMsgBox.ShowConfirmMessage("Bạn có muốn lưu lại tài liệu không?") == DialogResult.Yes)
     {
         SaveFileDialog saveFile = new SaveFileDialog();
         //Cấu hình các thuộc tính cho saveFile
         saveFile.InitialDirectory = FrameworkParams.TEMP_FOLDER;
         saveFile.Title = "Chọn thư mục để lưu file:";
         //Lấy kiểu file
         string[] typeFile = Path.GetFileName(view.GetRowCellValue(gHitInfo.RowHandle, gHitInfo.Column).ToString()).Split(new char[] { '.' });
         saveFile.Filter = "File type " + typeFile.GetValue(typeFile.Length - 1).ToString()
             + "(*." + typeFile.GetValue(typeFile.Length - 1).ToString() + ")" + "|*."
             + typeFile.GetValue(typeFile.Length - 1).ToString();
         saveFile.FileName = FrameworkParams.TEMP_FOLDER + @"\" + typeFile.GetValue(typeFile.Length - 2).ToString();
         if (saveFile.ShowDialog() == DialogResult.OK)
         {
             path = saveFile.FileName;
         }
         Thread.Sleep(200);
     }
     if (path != null)
     {
         if (!HelpFile.BytesToFile(bytes, path))
         {
             if (HelpFile.BytesToFile(bytes, FrameworkParams.TEMP_FOLDER + @"\" + view.GetRowCellValue(gHitInfo.RowHandle, gHitInfo.Column).ToString()))
                 HelpFile.OpenFile(FrameworkParams.TEMP_FOLDER + @"\" + view.GetRowCellValue(gHitInfo.RowHandle, gHitInfo.Column).ToString());
             HelpMsgBox.ShowNotificationMessage("Không lưu được file.");
         }
         else
             HelpFile.OpenFile(path);
     }
     else
     {
         if (HelpFile.BytesToFile(bytes, FrameworkParams.TEMP_FOLDER + @"\" + view.GetRowCellValue(gHitInfo.RowHandle, gHitInfo.Column).ToString()))
             HelpFile.OpenFile(FrameworkParams.TEMP_FOLDER + @"\" + view.GetRowCellValue(gHitInfo.RowHandle, gHitInfo.Column).ToString());
     }
 }

 private bool IsConnected (GridView view, int row)
 {
     GridColumn col = view.Columns["IsConnected"];
     return Convert.ToBoolean(view.GetRowCellValue(row, col));
 }

 private bool IsStockMore(GridView view, int row)
 {
     try
     {
         string val = Convert.ToString(view.GetRowCellValue(row, "STOCK"));
         string val1 = Convert.ToString(view.GetRowCellValue(row, "QTY"));
         string stockid = Convert.ToString(view.GetRowCellValue(row, "STOCKID"));
         if (int.Parse(stockid.ToUpper()) > 0)
             return (int.Parse(val) < int.Parse(val1));
     }
     catch
     {
         return false;
     }
     return false;
 }

        private static int GetRowHandleByColumnValue(GridView view, string ColumnFieldName, object value)
        {
            int result = GridControl.InvalidRowHandle;

            for(int i = 0; i < view.RowCount; i++)
            {
                if(view.GetRowCellValue(i, ColumnFieldName).Equals(value))

                    return i;
            }
            return result;
        }

 public void SaveSelectionViewInfo(GridView view)
 {
     SaveSelList.Clear();
     GridColumn column = view.Columns[descriptor.keyFieldName];
     RowInfo rowInfo;
     int[] selectionArray = view.GetSelectedRows();
     if (selectionArray != null)  // otherwise we have a single focused but not selected row
         for (int i = 0; i < selectionArray.Length; i++)
         {
             int dataRowHandle = selectionArray[i];
             rowInfo.level = view.GetRowLevel(dataRowHandle);
             if (dataRowHandle < 0) // group row
                 dataRowHandle = view.GetDataRowHandleByGroupRowHandle(dataRowHandle);
             rowInfo.Id = view.GetRowCellValue(dataRowHandle, column);
             SaveSelList.Add(rowInfo);
         }
     rowInfo.Id = view.GetRowCellValue(view.FocusedRowHandle, column);
     rowInfo.level = view.GetRowLevel(view.FocusedRowHandle);
     SaveSelList.Add(rowInfo);
 }

 public void SaveExpansionViewInfo(GridView view)
 {
     if (view.GroupedColumns.Count == 0) return;
     SaveExpList.Clear();
     GridColumn column = view.Columns[descriptor.keyFieldName];
     for (int i = -1; i > int.MinValue; i--)
     {
         if (!view.IsValidRowHandle(i)) break;
         if (view.GetRowExpanded(i))
         {
             RowInfo rowInfo;
             int dataRowHandle = view.GetDataRowHandleByGroupRowHandle(i);
             rowInfo.Id = view.GetRowCellValue(dataRowHandle, column);
             rowInfo.level = view.GetRowLevel(i);
             SaveExpList.Add(rowInfo);
         }
     }
 }

 public void SaveExpandedMasterRows(GridView view)
 {
     if (view.GridControl.Views.Count == 1) return;
     SaveMasterRowsList.Clear();
     GridColumn column = view.Columns[descriptor.keyFieldName];
     for (int i = 0; i < view.DataRowCount; i++)
         if (view.GetMasterRowExpanded(i))
         {
             object key = view.GetRowCellValue(i, column);
             SaveMasterRowsList.Add(key);
             GridView detail = view.GetVisibleDetailView(i) as GridView;
             if (detail != null)
             {
                 ViewState state = ViewState.Create(this, detail);
                 if (state != null)
                 {
                     DetailViews.Add(key, state);
                     state.SaveState(detail);
                 }
             }
         }
 }

        private bool recargo(GridView view, int row)
        {
            GridColumn col = view.Columns["Recargo"];

            decimal val = Convert.ToDecimal(view.GetRowCellValue(row, col));

            return val > 0;
        }

 /// <summary>
 /// 删除选中行数据
 /// </summary>
 private void DeleteRow(GridView dr,string FileName)
 {
     try
     {
         for (int i = dr.RowCount - 1; i >= 0; i--)
         {
             if (Convert.ToBoolean(dr.GetRowCellValue(i, FileName)) == true)
             {
                 dr.DeleteRow(i);
             }
         }
         if (dr.DataSource != null)
         {
             ((DataView)dr.DataSource).Table.AcceptChanges();
         }
     }
     catch (Exception ex)
     {
         throw ex;
     }
 }