コード例 #1
0
        private void Submit(object sender, RoutedEventArgs e)
        {
            var           cellgrid = this.DataContext as SfCellGrid;
            GridRangeInfo Range    = cellgrid.SelectedRanges.ActiveRange;

            for (int i = Range.Top; i <= Range.Bottom; i++)
            {
                for (int j = Range.Left; j <= Range.Right; j++)
                {
                    var condition = new GridCondition();
                    condition.ColumnIndex = j;
                    condition.RowIndex    = i;
                    condition.Value1      = Endvalue.Text;
                    if (Type.Equals(GridConditionType.Between))
                    {
                        condition.Value2 = startvalue.Text;
                    }
                    if (Type.Equals(GridConditionType.Contains))
                    {
                        conditionformat.ConditionalFormatType = GridConditionalFormatType.SpecificText;
                    }
                    condition.ConditionType   = Type;
                    conditionformat.Condition = condition;
                    cellgrid.Model[i, j].ConditionalFormats = new GridConditionalFormats();
                    cellgrid.Model[i, j].ConditionalFormats.Add(conditionformat);
                }
            }
            cellgrid.InvalidateCell(Range);
            startvalue.Text            = "";
            Endvalue.Text              = "";
            (this.Tag as Popup).IsOpen = false;
        }
コード例 #2
0
        private void submit(object sender, RoutedEventArgs e)
        {
            var           cellgrid = this.DataContext as SfCellGrid;
            GridRangeInfo Range    = cellgrid.SelectedRanges.ActiveRange;

            for (int i = Range.Top; i <= Range.Bottom; i++)
            {
                for (int j = Range.Left; j <= Range.Right; j++)
                {
                    var condition = new GridCondition();
                    condition.ColumnIndex = j;
                    condition.RowIndex    = i;
                    //conditionformat.Condition = condition;
                    conditionformat.ConditionalFormatType = GridConditionalFormatType.DatesOccurring;
                    //conditionformat.ConditionalFormatType = GridConditionalFormatType.DatesOccurring;
                    cellgrid.Model[i, j].ConditionalFormats = new GridConditionalFormats();
                    cellgrid.Model[i, j].ConditionalFormats.Add(conditionformat);

                    cellgrid.InvalidateCell(i, j);
                }
            }
            (this.Tag as Popup).IsOpen = false;
        }