自动生成数据网格中的日期时间转换器
本文关键字:日期 时间 转换器 数据 数据网 网格 自动生成 | 更新日期: 2023-09-27 18:11:40
我创建了一个自动生成的数据网格,其中有5列,其中3列是日期时间,另外2列是字符串。我需要能够从datetime列条目的末尾删除时间。
通常我使用一个日期转换器,但我从中得到奇怪的结果,我猜这是因为它应用于整个数据网格,而不仅仅是datetime列。
谁能帮我解决这个问题?是否有一种方法可以单独列出日期时间列来应用转换器?
谢谢,我会在下面附上一些代码:
MainPage.xaml:
<UserControl x:Class="Peppermint.Flix.UI.Views.MainPage"
xmlns:my="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Data"
xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
xmlns:d="http://schemas.microsoft.com/expression/blend/2008"
xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006"
xmlns:navigation="clr-namespace:System.Windows.Controls;assembly=System.Windows.Controls.Navigation"
xmlns:local="clr-namespace:Peppermint.Flix.UI"
mc:Ignorable="d"
d:DesignHeight="300" d:DesignWidth="400" xmlns:sdk="http://schemas.microsoft.com/winfx/2006/xaml/presentation/sdk">
<UserControl.Resources>
<local:DateTimeConverter x:Key="DateTimeConverter" />
</UserControl.Resources>
<Grid x:Name="LayoutRoot" Background="White">
<Grid.RowDefinitions>
<RowDefinition Height="0.5*" />
<RowDefinition Height="10*" />
</Grid.RowDefinitions>
<Grid x:Name="QuickNav" Grid.Row="0">
<Grid.ColumnDefinitions>
<ColumnDefinition Width="0.2*"/>
<ColumnDefinition Width="1*"/>
</Grid.ColumnDefinitions>
<Grid x:Name="ComboBox" Grid.Column="0">
<ComboBox HorizontalAlignment="Stretch" Height="20" ItemsSource="{Binding NavItems}" SelectedItem="{Binding NavItem, Mode=TwoWay}" />
</Grid>
<Grid x:Name="GoButton" Grid.Column="1">
<Button Content="Go" HorizontalAlignment="Left" Height="20" Command="{Binding GoCommand, Mode=OneTime}" />
</Grid>
</Grid>
<Grid x:Name="DataGrid" Grid.Row="1" >
<sdk:DataGrid HorizontalAlignment="Stretch" VerticalAlignment="Stretch" AutoGenerateColumns="True" ItemsSource="{Binding TransferPackages, Converter={StaticResource DateTimeConverter} }"/>
</Grid>
</Grid>
</UserControl>
MainViewModel.cs:
public class MainViewModel : ViewModelBase
{
private string _navItem;
private TransferPackageViewModel _data;
#region Constructor
public MainViewModel()
{
GoCommand = new DelegateCommand<object>(QuickNavGo);
TransferPackages = new ObservableCollection<TransferPackageViewModel>();
NavItems = new List<string> { "QUICK NAV", "New Transfer Package" };
TransferPackages.Add(new TransferPackageViewModel { TransferPackageName = "Harry Potter 7 The Golden Amulet in 4D (12A)", CreatedBy = "Bilbo Baggins" });
TransferPackages.Add(new TransferPackageViewModel { TransferPackageName = "Harry Potter 8 The Hairy InnKeeper in 4D (12A)", CreatedBy = "Bilbo Baggins" });
TransferPackages.Add(new TransferPackageViewModel { TransferPackageName = "Harry Potter 7 The Milking the Cow in 5D (12A)", CreatedBy = "Bilbo Baggins" });
}
#endregion
public TransferPackageViewModel Data
{
get { return _data; }
set { _data = value; OnPropertyChanged("Data"); }
}
public void QuickNavGo(object obj)
{
MessageBox.Show("This will open the new Transfer Package Window");
}
public string NavItem
{
get { return _navItem; }
set { _navItem = value; OnPropertyChanged("NavItem"); }
}
public ObservableCollection<TransferPackageViewModel> TransferPackages { get; set; }
public List<string> NavItems { get; set; }
public ICommand GoCommand { get; set; }
}
}
DateTimeConverter.cs:
public class DateTimeConverter : IValueConverter
{
public object Convert(object value, Type targetType,
object parameter, CultureInfo culture)
{
if (parameter != null)
{
string formatString = parameter.ToString();
if (!string.IsNullOrEmpty(formatString))
{
return string.Format(culture, formatString, value);
}
}
return value.ToString();
}
public object ConvertBack(object value, Type targetType,
object parameter, CultureInfo culture)
{
if (value != null)
{
return DateTime.Parse(value.ToString());
}
return value;
}
}
}
可以这样处理DataGrid
的AutoGeneratingColumn
事件来解决这个问题
<DataGrid AutoGeneratingColumn="DataGrid_AutoGeneratingColumn" HorizontalAlignment="Stretch" VerticalAlignment="Stretch" AutoGenerateColumns="True" ItemsSource="{Binding TransferPackages}"/>
在那个事件中做这个
private void DataGrid_AutoGeneratingColumn(object sender, System.Windows.Controls.DataGridAutoGeneratingColumnEventArgs e)
{
//your date time property
if (e.PropertyType == typeof(System.DateTime))
{
DataGridTextColumn dgtc = e.Column as DataGridTextColumn;
DateTimeConverter con = new DateTimeConverter();
(dgtc.Binding as Binding).Converter = con;
}
}
和一个简单的转换器
public class DateTimeConverter : IValueConverter
{
public object Convert(object value, Type targetType, object parameter, CultureInfo culture)
{
if(value != null && value.GetType() == typeof(System.DateTime))
{
DateTime t = (DateTime) value;
return t.ToShortDateString();
}
return value;
}
public object ConvertBack(object value, Type targetType, object parameter, CultureInfo culture)
{
if (value != null)
{
return DateTime.Parse(value.ToString());
}
return value;
}
}
在您的DataGrid_AutoGeneratingColumn事件处理程序中也可以使用以下代码片段:
DataGridBoundColumn = e.Column;
if (col != null && e.PropertyType == typeof(DateTime))
{
col.Binding.StringFormat = "{0:d}";
}
这里您只需更改日期列中的日期格式,而无需使用转换器。