主页 / 问题 / 647967
Accepted
Teraro
Asked:2020-04-04 01:08:20 +0000 UTC2020-04-04 01:08:20 +0000 UTC

如何按名称中的日期对文件进行排序？

  • 772

有 10 个 xls 文件。他们有一个名字dd.mm.yy。如何 files按日期升序对列表进行排序？目前还不完全清楚如何转换文件名DateTime 并对其进行排序。

 var path = @"C:\Users\admin\Desktop\1\DBCommanderNew\bin\Debug";
 var files = Directory.GetFiles(
            path,"*.xls").Select(x => Path.GetFileNameWithoutExtension(x)).OrderBy(x => x).ToList();
c#

2 个回答

  1. Best Answer
    var path = @"C:\Users\admin\Desktop\1\DBCommanderNew\bin\Debug";
var files = Directory
    .GetFiles(path,"*.xls")
    .Select(x => Path.GetFileNameWithoutExtension(x))
    .OrderBy(x => 
        {
            DateTime date;
            return DateTime.TryParseExact(x, "dd.MM.yy", CultureInfo.InvariantCulture, DateTimeStyles.None, out date)
                ? date
                : DateTime.MinValue;
        }).ToList();
    • 4

  2. C＃7：

        {
        var path = @"C:\Users\admin\Desktop\1\DBCommanderNew\bin\Debug";
        var files = Directory.GetFiles(path, "*.xls")
            .Select(x => Selector(x))
            .OrderBy(x => x.Item2.Date)
            .Select(x => x.Item1)
            .ToList();
    }

    private static (string, DateTime) Selector(string input)
    {
        var file = Path.GetFileNameWithoutExtension(input);
        if (DateTime.TryParse(file, out DateTime dateTime))
            return (file, dateTime);

        return (file, DateTime.MinValue);
    }

    C＃6：

        {
        var path = @"C:\Users\admin\Desktop\1\DBCommanderNew\bin\Debug";
        var files = Directory.GetFiles(path, "*.xls")
            .Select(x => Selector(x))
            .OrderBy(x => x.Item2.Date)
            .Select(x => x.Item1)
            .ToList();
    }

    private static Tuple<string, DateTime> Selector(string input)
    {
        var file = Path.GetFileNameWithoutExtension(input);
        DateTime dt;
        if (DateTime.TryParse(file , out dt))
            return Tuple.Create(file, dt);
        return Tuple.Create(file, DateTime.MinValue);
    }
    • 1

相关问题