正在创建可为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值的更改实际上是=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;
}
}