C# UltraGridRow类代码示例

    private void colourRow(UltraGridRow row_)
    {
      CurrentRollLine line;

      if (row_ == null || (line = row_.ListObject as CurrentRollLine) == null)
        return;

      {
        var cells = new[]
        {
          row_.Cells[CurrentRollLineHelper.Mappings.GetValueFromKey(CurrentRollLineField.LastCloseOI_Current_Back)],
          row_.Cells[CurrentRollLineHelper.Mappings.GetValueFromKey(CurrentRollLineField.LastCloseOI_Current_Front)]
        };

        Array.ForEach(cells,
          cell => cell.Appearance = line.OI_Status() == Model.Enums.OIStatus.Estimate ? getItalicAppearance() : null);
      }

      // daily front
      {
        var currentVal = line.GetValue(CurrentRollLineField.LastCloseOI_Current_FrontP);
        var avgPrior = line.GetValue(CurrentRollLineField.LastCloseOI_AvgPrior_FrontP);

        var diff = currentVal - avgPrior;
        var cell = row_.Cells[CurrentRollLineHelper.Mappings.GetValueFromKey(CurrentRollLineField.LastCloseOI_Current_FrontP)];

        Infragistics.Win.Appearance app = null;

        if (diff > m_dispOptions.DailyHighlighThreshold)
        {
          app = getSlowAppearance();
        }
        else if (Math.Abs(diff) > m_dispOptions.DailyHighlighThreshold)
        {
          app = getFastAppearance();
        }

        cell.Appearance = app;
        cell.SelectedAppearance = app;
      }

      // daily back
      {
        var currentVal = line.GetValue(CurrentRollLineField.LastCloseOI_Current_BackP);
        var avgPrior = line.GetValue(CurrentRollLineField.LastCloseOI_AvgPrior_BackP);

        var diff = currentVal - avgPrior;

        var cell = row_.Cells[CurrentRollLineHelper.Mappings.GetValueFromKey(CurrentRollLineField.LastCloseOI_Current_BackP)];

        Infragistics.Win.Appearance app = null;

        if (diff > m_dispOptions.DailyHighlighThreshold)
        {
          app = getFastAppearance();
        }
        else if (Math.Abs(diff) > m_dispOptions.DailyHighlighThreshold)
        {
          app = getSlowAppearance();
        }

        cell.Appearance = app;
        cell.SelectedAppearance = app;
      }

      // intraday
      {
        var currentVal = line.GetValue(CurrentRollLineField.SpreadVolumeOnDay_CurrentLiveP);
        var avgPrior = line.GetValue(CurrentRollLineField.SpreadVolumeOnDay_AvgPriorLiveP);

        var diff = currentVal - avgPrior;

        var cell = row_.Cells[CurrentRollLineHelper.Mappings.GetValueFromKey(CurrentRollLineField.SpreadVolumeOnDay_CurrentLiveP)];

        Infragistics.Win.Appearance app = null;

        if (diff > m_dispOptions.DailyHighlighThreshold)
        {
          app = getFastAppearance();
        }
        else if (Math.Abs(diff) > m_dispOptions.DailyHighlighThreshold)
        {
          app = getSlowAppearance();
        }

        cell.Appearance = app;
        cell.SelectedAppearance = app;
      }

      // change on day
      {
        var diff = line.GetValue(CurrentRollLineField.RollLevelChange);

        var cell = row_.Cells[CurrentRollLineHelper.Mappings.GetValueFromKey(CurrentRollLineField.RollLevelChange)];

        Infragistics.Win.Appearance app = null;

        if (diff > 0d)
        {
          app = getFastAppearance();
//.........这里部分代码省略.........

 public void MostrarItem(UltraGridRow Row)
 {
     ItemClasificacionExistencia Item = (ItemClasificacionExistencia)Row.Tag;
     Row.Cells[colCodigo].Value = Item.Codigo;
     Row.Cells[colNombre].Value = Item.Nombre;
     Row.Cells[colActivo].Value = Item.Activo;
 }

 public void MostrarItem(UltraGridRow Row)
 {
     Auditoria Auditoria = (Auditoria)Row.Tag;
     Row.Cells[colFecha].Value = Auditoria.Fecha;
     Row.Cells[colHora].Value = Auditoria.Hora;
     Row.Cells[colUsuario].Value = Auditoria.Usuario;
     Row.Cells[colAccion].Value = Auditoria.Accion;
 }

        public static void SetButtonText(UltraGridRow row, GridButton button)
        {
            var colName = button.ToString();
             var label = button.ToString();
             if (row.Cells.IndexOf(colName) == -1) return;

             var buttonLabel = !string.IsNullOrEmpty(label) ? string.Format("[{0}]", label.ToLower()) : string.Empty;
             row.Cells[colName].Value = buttonLabel;
        }

 private void changeCustOrder(string value,UltraGridRow row)
 {
     var q = from p in custordernoDt.AsEnumerable()
             where p["custorderno"].ToString() == value && p["customerid"].ToString() == ((ValueInfo)this.cmbCustomer.SelectedItem).ValueField
             select p;
     if (q.Count()>0){
         row.Cells["customername"].Value = q.ToList<DataRow>()[0]["customername"];
         row.Cells["factory"].Value = q.ToList<DataRow>()[0]["factory"];
         row.Cells["cartonqty"].Value = q.ToList<DataRow>()[0]["cartonqty"];
     }
 }

 public void BandSteelTypeAndSpec(UltraGridRow row)
 {
     if (row.Cells["FS_COMMUTEDSTEELTYPE"].Value.ToString() == string.Empty)
     {
         row.Cells["FS_COMMUTEDSTEELTYPE"].Value = row.Cells["FS_STEELTYPE"].Value;
     }
     if (row.Cells["FS_COMMUTEDSPEC"].Value.ToString() == string.Empty)
     {
         row.Cells["FS_COMMUTEDSPEC"].Value = row.Cells["FS_SPEC"].Value;
     }
 }

 public static List<string> CalculateRowList(UltraGridRow aUltraGridRow)
 {
     foreach (
         string aString in
             from UltraGridCell cell in aUltraGridRow.Cells
             select cell.Value.ToString()
             into aString
             select aString + "\r\n")
     {
         ARowList.Add(aString);
     }
     return ARowList;
 }

 public bool ShouldCellsBeMerged(UltraGridRow row1,UltraGridRow row2, UltraGridColumn column)
 {
     // Test to make sure the Type is not DBNull since we allow the ShippedDate to be null
     if (row1.GetCellValue(column).GetType().ToString() != "System.DBNull" && row2.GetCellValue(column).GetType().ToString() != "System.DBNull")
     {
         string value1 = row1.GetCellValue(column).ToString();
         string value2 = row2.GetCellValue(column).ToString();
         // Merge cells according to the date portions of the underlying DateTime cell
         // values, ignoring any time portion. For example, "1/1/2004 10:30 AM" will be
         //  merged with "1/1/2004 1:15 AM" since the dates are the same.
         return value1.Equals(value2);
     }
     else
         return false;
 }

    private void setColors(UltraGridRow row_, double maxValue_)
    {
      foreach (UltraGridCell cell in row_.Cells)
      {
        if (cell.Appearance == null)
          return;

        cell.Appearance.Reset();

        if (cell.Value is double)
        {
          cell.Appearance.BackColor =
            Singleton<SI.Controls.SpectrumColoursPositiveNegative>.Instance.GetColor((double)cell.Value, maxValue_);
        }
      }
    }

        protected override void OnPreRender(EventArgs e)
        {
            foreach (Row row in _rows)
            {
                UltraGridRow ultraRow = new UltraGridRow();

                foreach (Cell cell in row.Cells)
                {
                    UltraGridCell ultraCell = new UltraGridCell();
                    ultraCell.Value = cell.Value;
                    ultraRow.Cells.Add(ultraCell);
                }

                _grid.Rows.Add(ultraRow);
            }

            base.OnPreRender(e);
        }

 /// <summary>
 /// Highight ô có dữ liệu không hợp lệ
 /// </summary>
 /// <param name="row">Dòng cần kiểm tra</param>
 /// <param name="inputTypes">Danh sách kiểu tương ứng với từng cột</param>
 /// <returns>True nếu có lỗi</returns>
 public static bool UltraGrid(UltraGridRow row, IList<InputType> inputTypes)
 {
     var result = false;
     HighlightGridCellClear(row);
     var listInputParam = new List<InputParam>();
     for (var i = 0; i < row.Cells.Count; i++)
     {
         if (inputTypes[i] == InputType.NgayThang)
         {
             var ngaythang = DateTime.Parse(row.Cells[i].Value.ToString()).ToString("dd/MM/yyyy");
             listInputParam.Add(new InputParam
             {
                 Input = ngaythang,
                 InputType = inputTypes[i]
             });
         }
         else
         {
             listInputParam.Add(new InputParam
             {
                 Input = row.Cells[i].Value.ToString(),
                 InputType = inputTypes[i]
             });
         }
     }
     var validate = new ValidateData();
     validate.ValDataList(listInputParam);
     if (validate.Errors.Count > 0)
     {
         for (var i = 0; i < row.Cells.Count; i++)
         {
             if (!validate.Output[i].Result)
             {
                 HighlightGridCellSet(row.Cells[i], validate.Output[i].MsgError);
             }
         }
         result = true;
     }
     return result;
 }

        private void annullaPagamento(UltraGridRow row)
        {
            var pagamento = getPagamentoFatturaService().GetById(_ritenutaClick.IdPagamento.GetValueOrDefault());
            if (CommonMessages.DisplayConfirm("Sei sicuro di volere eliminare il pagamento della fattura: " + pagamento.IdentificativoArchiviazione + " ?") == DialogResult.Yes)
            {
                var authMessage = getPagamentoFatturaService().IsAllowDeletePagamento(pagamento);
                if (string.IsNullOrEmpty(authMessage.FatalMessage))
                {
                    var result = DialogResult.Yes;
                    if (!string.IsNullOrEmpty(authMessage.WarnMessage))
                        result = CommonMessages.DisplayConfirm("Attenzione:" + authMessage.WarnMessage + Environment.NewLine + "Vuoi confermare la eliminazione?");

                    if (result == DialogResult.Yes)
                    {
                        string message = getPagamentoFatturaService().DeletePagamento(pagamento);
                        if (string.IsNullOrEmpty(message))
                        {
                            row.Delete(false);
                            CommonMessages.DisplayComplete("Il pagamento è stato correttamente eliminato");
                        }
                        else
                            CommonMessages.DisplayWarning("Si sono verificati i seguenti errori durante l'eliminazione del pagamento" + Environment.NewLine + Environment.NewLine + message);
                    }
                }
                else
                    CommonMessages.DisplayWarning("Non è ammessa la cancellazione del pagamento:" + Environment.NewLine + authMessage.FatalMessage);
            }
        }

 private static void HighlightGridCellClear(UltraGridRow row)
 {
     foreach (var cell in row.Cells)
     {
         HighlightGridCellClear(cell);
     }
 }

        private void setImportoConto(UltraGridRow row)
        {
            try
            {
                if (row != null)
                {
                    decimal importo = 0;
                    foreach (var childRow in row.ChildBands[0].Rows)
                    {
                        if (childRow.Cells["ImportoPreventivo"].Value != null && childRow.Cells["ImportoPreventivo"].Value != DBNull.Value)
                            importo += (decimal)childRow.Cells["ImportoPreventivo"].Value;
                    }

                    row.Cells["ImportoPreventivo"].Value = importo;
                }
            }
            catch (Exception ex)
            {
                _log.ErrorFormat("Errore nell'impostazione dell'importo - {0} - row:{1} - azienda:{2}", ex, Utility.GetMethodDescription(), row != null ? row.ToString() : "<NULL>", Security.Login.Instance.CurrentLogin().Azienda);
                throw;
            }
        }

        private void setRowLayout(UltraGridRow row)
        {
            var scadenza = row.ListObject as ScadenzaSpesaFiscaleDTO;
            if (scadenza != null)
            {
                if (!scadenza.RitenutaNONPagata)
                {
                    row.Cells["DataPagamentoRitenuta"].Hidden = false;
                    row.Cells["ImportoInteressi"].Hidden = false;
                    row.Cells["ImportoSanzioni"].Hidden = false;
                }
                else
                {
                    row.Cells["DataPagamentoRitenuta"].Hidden = true;
                    row.Cells["ImportoInteressi"].Hidden = true;
                    row.Cells["ImportoSanzioni"].Hidden = true;
                    row.Cells["DataPagamentoRitenuta"].Value = null;
                }

            }
        }