private List <TOT> CabeceraTOT(RFNCCAB model) { TOT mTOT = new TOT(); List <TOT> lmTOT = new List <TOT>(); mTOT.TOT_1 = model.FSUBTOT; mTOT.TOT_2 = model.FMONEDA; mTOT.TOT_3 = model.FSUBTOT; mTOT.TOT_4 = model.FMONEDA; mTOT.TOT_5 = model.FTOTNC; mTOT.TOT_6 = model.FMONEDA; lmTOT.Add(mTOT); return(lmTOT); }
static void ProcessTOT() { List <TOT> TOTs = new List <TOT>(); string fileName = @"C:\Users\Zhirong.Xie\Desktop\Testing Data\3、请假明细(18年1-3).csv"; using (var csvReader = new CSVReader(new StreamReader(fileName))) { string[] line; int lineNumber = 0; while ((line = csvReader.ReadNext()) != null) { TOT t = new TOT(); if (lineNumber > 0) { t.Sequence = line[0]; t.EmployeeCode = line[1]; t.EmployeeId = line[2]; t.StartTime = DateTime.Parse(line[3]); t.EndTime = DateTime.Parse(line[4]); TOTs.Add(t); } lineNumber++; } List <TOT> results = TOTProcessor.Process(TOTs); string resultFilePath = @"C:\Users\Zhirong.Xie\Desktop\Testing Data" + "\\TOT_converted.csv"; using (var csvWriter = new CSVWriter(new StreamWriter(resultFilePath, false))) { csvWriter.WriteNext(new string[] { "月度", "季度", "季度日历日数", "员工编码", "员工Id", "休假天数", "开始时间", "结束时间" }); foreach (TOT t in results) { string[] line1 = new string[] { t.MonthString, t.QuarterString, t.DaysInQuarter.ToString(), t.EmployeeCode, t.EmployeeId, t.Days.ToString(), t.StartTime.ToString(), t.EndTime.ToString() }; csvWriter.WriteNext(line1); } } } }