根据日期 读取三个csv不留指定日期的内容 新保存一个文件

mac2022-06-30  24

using System;using System.Collections.Generic;using System.Drawing;using System.Globalization;using System.IO;using System.Linq;using System.Net;using System.Text;using System.Threading.Tasks;using System.Windows.Forms;using System.Xml;using ConsoleApplication1;using log4net;namespace ISC.LPCheck.HashValue{    static class Program    {        static void Main()        {            string title = "日付";            string str1 = "2016年10月12日";            DateTime dt1 = Convert.ToDateTime(str1);            string str3 = "2016年7月12日";            DateTime dt3 = Convert.ToDateTime(str3);            int index = 1;                       List<string> newList = new List<string>();             foreach (var file in Directory.GetFiles(@"C:\ECsystem\Pv_Click\download\csv\20161019"))            {                foreach (var item in File.ReadAllLines(file, Encoding.UTF8))                {                    if (item.Contains(title) && index == 1)                    {                        newList.Add(item); //添加title                    }                    else if(!item.Contains(title))                    {                        var hitukistr = item.Split(',')[0].Replace("\"", "");                        DateTime dt2 = Convert.ToDateTime(hitukistr);                        if (DateTime.Compare(dt1, dt2) >= 0 && DateTime.Compare(dt2, dt3) >= 0)                        {                            newList.Add(item);                        }                    }                    Console.WriteLine(item);                    index++;                }            }            File.WriteAllLines(@"C:\ECsystem\Pv_Click\download\csv\20161019\test1.csv", newList.ToArray(), Encoding.UTF8);        }    }}

转载于:https://www.cnblogs.com/c-x-a/p/5981295.html

最新回复(0)