使用linq检查和更新List<Dictionary<string、object>>中DateTime值的唯一时间

using System;
using System.Collections.Generic;
using System.Linq;

public class Program
{
    public static void Main()
    {
        // 创建一个包含 DateTime 值的 List<Dictionary<string, object>>
        List<Dictionary<string, object>> data = new List<Dictionary<string, object>>
        {
            new Dictionary<string, object> { { "Id", 1 }, { "Name", "John" }, { "Date", new DateTime(2022, 1, 1) } },
            new Dictionary<string, object> { { "Id", 2 }, { "Name", "Jane" }, { "Date", new DateTime(2022, 1, 2) } },
            new Dictionary<string, object> { { "Id", 3 }, { "Name", "Bob" }, { "Date", new DateTime(2022, 1, 1) } },
            new Dictionary<string, object> { { "Id", 4 }, { "Name", "Alice" }, { "Date", new DateTime(2022, 1, 3) } }
        };

        // 使用 LINQ 查询语法筛选出包含 DateTime 值的字典
        var dictionariesWithDateTime = from dict in data
                                       where dict.Values.Any(value => value is DateTime)
                                       select dict;

        // 使用 Distinct 方法获取唯一的 DateTime 值
        var uniqueDateTimes = dictionariesWithDateTime.Select(dict => (DateTime)dict["Date"]).Distinct();

        // 输出唯一的 DateTime 值
        Console.WriteLine("唯一的 DateTime 值：");
        foreach (var dateTime in uniqueDateTimes)
        {
            Console.WriteLine(dateTime);
        }

        // 使用 Select 方法更新原始列表中的 DateTime 值
        data = data.Select(dict =>
        {
            if (dict.ContainsKey("Date") && dict["Date"] is DateTime)
            {
                dict["Date"] = ((DateTime)dict["Date"]).AddDays(1); // 更新为后一天的日期
            }
            return dict;
        }).ToList();

        // 输出更新后的列表
        Console.WriteLine("更新后的列表：");
        foreach (var dict in data)
        {
            foreach (var kvp in dict)
            {
                Console.WriteLine($"{kvp.Key}: {kvp.Value}");
            }
            Console.WriteLine();
        }
    }
}