正在创建可为null的Datagridview DateTime列

本文关键字:Datagridview DateTime null 创建 | 更新日期: 2023-09-27 18:26:04

我正在编写一个datagridview列来处理用户输入的null值(在这种情况下,如果没有为用户设置休假日期,它将存储为null并显示为N/a)

我几乎已经使用了一个可为null的日期时间选择器,但网格并没有接收到对null值的更改,它只是切换回旧的时间值。当行被初始化时,它以一个显示良好的空值开始。

然后将其数据绑定回模型类

日历单元格

public class CtlDataGridViewNullableCalendarCell : DataGridViewTextBoxCell
{
public CtlDataGridViewNullableCalendarCell()
    : base()
{
    this.Style.Format = "d";
}
public override void InitializeEditingControl(int rowIndex, object
    initialFormattedValue, DataGridViewCellStyle dataGridViewCellStyle)
{
    // Set the value of the editing control to the current cell value.
    base.InitializeEditingControl(rowIndex, initialFormattedValue, dataGridViewCellStyle);
    CtlCalendarNullableEditingControl ctl = DataGridView.EditingControl as CtlCalendarNullableEditingControl;
    ctl.Value = (DateTime?)this.Value;
    // a hacky way of getting the DateTimePicker to reset its focus, rather than remembering which date part was previously focussed
    DateTimePickerFormat format = ctl.Format;
    ctl.Format = DateTimePickerFormat.Custom;
    ctl.Format = format;
}
public override object ParseFormattedValue(object formattedValue, DataGridViewCellStyle cellStyle, TypeConverter formattedValueTypeConverter, TypeConverter valueTypeConverter)
{
    if (formattedValue == null)
        return null;
    else
        return (formattedValue as DateTime?).Value.Date;
}
public override Type EditType
{
    get
    {
        // Return the type of the editing control that CalendarCell uses.
        return typeof(CtlCalendarNullableEditingControl);
    }
}
public override Type ValueType
{
    get
    {
        // Return the type of the value that CalendarCell contains.
        return typeof(DateTime?);
    }
}
public override object DefaultNewRowValue
{
    get
    {
        // Use the current date as the default value.
        return null;
    }
}
#endregion
}

编辑控制的覆盖

class CtlCalendarNullableEditingControl : CtlNullableDateTimePicker, IDataGridViewEditingControl
{
DataGridView _dataGridView;
private bool _valueChanged = false;
int _rowIndex;
public object EditingControlFormattedValue
{
    get
    {
        return this.Value;
    }
    set
    {
        if (value is string)
            if ((string)value == string.Empty)
                value = null;
            else
                value = DateTime.Parse((string)value);
    }
}
public object GetEditingControlFormattedValue(
    DataGridViewDataErrorContexts context)
{
    return EditingControlFormattedValue as DateTime?;
}
public void ApplyCellStyleToEditingControl(
    DataGridViewCellStyle dataGridViewCellStyle)
{
    this.Font = dataGridViewCellStyle.Font;
    this.CalendarForeColor = dataGridViewCellStyle.ForeColor;
    this.CalendarMonthBackground = dataGridViewCellStyle.BackColor;
}
public int EditingControlRowIndex
{
    get
    {
        return _rowIndex;
    }
    set
    {
        _rowIndex = value;
    }
}
public bool EditingControlWantsInputKey(
    Keys key, bool dataGridViewWantsInputKey)
{
    // Let the DateTimePicker handle the keys listed.
    switch (key & Keys.KeyCode)
    {
        case Keys.Left:
        case Keys.Up:
        case Keys.Down:
        case Keys.Right:
        case Keys.Home:
        case Keys.End:
        case Keys.PageDown:
        case Keys.PageUp:
        case Keys.Delete:
        case Keys.Back:
            return true;
        default:
            return false;
    }
}
public DataGridView EditingControlDataGridView
{
    get
    {
        return _dataGridView;
    }
    set
    {
        _dataGridView = value;
    }
}
public bool EditingControlValueChanged
{
    get
    {
        return _valueChanged;
    }
    set
    {
        _valueChanged = value;
    }
}

#region -- DateTimePicker overrides --
/// <summary>
/// Handle the OnValueChanged event from the <see cref="DateTimePicker"/> and ensure the change propagates to the grid.
/// </summary>
/// <param name="eventargs"></param>
protected override void OnValueChanged(EventArgs eventargs)
{
    // Notify the DataGridView that the contents of the cell have changed.
    _valueChanged = true;
    this.EditingControlDataGridView.NotifyCurrentCellDirty(true);
    base.OnValueChanged(eventargs);
}

编辑控件本身工作得很好,所以我确信问题存在于实际的单元格类中,但我对winforms不够熟悉,无法发现问题。

我们会感激地接受建议,甚至只是一些建议。

正在创建可为null的Datagridview DateTime列

对null值的更改实际上是=null,还是为空?

在线条上放置断点:

if ((string)value == string.Empty)

if (formattedValue == null)

查看value和formattedValue是否是您所期望的。

public override object ParseFormattedValue(object formattedValue, DataGridViewCellStyle cellStyle,TypeConverter formattedValueTypeConverter, TypeConverter valueTypeConverter)
{
  if (formattedValue != DBNull.Value && formattedValue.ToString() != "")
  {
    return base.ParseFormattedValue(formattedValue, cellStyle, formattedValueTypeConverter, valueTypeConverter);
  }
  else
  {
    return DBNull.Value;
  }
}