自动生成数据网格中的日期时间转换器

本文关键字:日期 时间 转换器 数据 数据网 网格 自动生成 | 更新日期: 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;
            }
        }
}

自动生成数据网格中的日期时间转换器

可以这样处理DataGridAutoGeneratingColumn事件来解决这个问题

<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}";
}

这里您只需更改日期列中的日期格式,而无需使用转换器。