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