static void WeeklyReport()
{
Console.WriteLine("开始寻找当前文件夹下的所有.xlsx文件，请耐心等待");
var list = new List<Task>();
var fileManager = new FileManager();
var streamManager = new StreamManager();
var bookManager = new MyXSSFWorkbook();
var files = fileManager.GetAllFileNames();
Console.WriteLine("开始导出数据.......");
foreach (var file in files)
{
try
{
var stream = streamManager.GetStreamByName(file);
var currentlist = bookManager.GetTaskList(stream);
Console.WriteLine("导出{0}的周报成功 :)", file);
list.AddRange(currentlist);
}
catch
{
Console.WriteLine("导出{0}的周报出错啦。请查看Excel是否格式正确", file);
}
}
// 需要写入数据的文件
Console.WriteLine("开始写入数据......");
var writeFile = streamManager.GetWriteStream("项目周报-项目编号-汇报日期测试.xls");
bookManager.WriteToFile(list, writeFile);
Console.WriteLine("，导出成功，导出的文件名为：《周报汇总.xls》，请输入任何字符结束程序");
}
static void Main(string[] args)
{
var fileManager=new FileManager();
var streamManager = new StreamManager();
var bookManager = new MyXSSFWorkbook();
var stream = streamManager.GetStreamByName("个人周报汇总-TS中行总行BJ13003FW.xlsx");
var list = bookManager.GetAllTask(stream);
var nwlist = new List<NextWeekTask>();
foreach (var file in fileManager.GetAllNextWeekFilNames())
{
var nwstream = streamManager.GetStreamByName(file);
var empnwlist = bookManager.getNextWeekTask(nwstream);
nwlist.AddRange(empnwlist);
}
var mergeList = new List<Task>();
var taskNumList = list.OrderBy(s=>s.TaskNum).Select(s =>new { s.TaskNum,s.TaskName}).Distinct();
foreach (var taskdis in taskNumList)
{
var sameNumTasks = list.Where(l => l.TaskNum == taskdis.TaskNum);
var taskContent = string.Empty;
double workTime = 0.0;
var workers = string.Empty;
var allresult=string.Empty;
//合并
foreach (var task in sameNumTasks)
{
//工作内容合并
taskContent += task.Description ;
taskContent += "\n";
//工时合并
workTime = workTime + task.Mon + task.Tue + task.Wen + task.Thr + task.Fir + task.San + task.Sun;
//人员合并
workers += task.EmpName;
workers += "、";
//提交结果合并
allresult+=task.Result;
allresult+="\n";
}
var mergetask = new Task();
mergetask.TaskNum = taskdis.TaskNum;
mergetask.TaskName = taskdis.TaskName;
mergetask.Result = allresult;
mergetask.Sum = workTime;
mergetask.Description = taskContent;
mergetask.EmpName = workers;
mergetask.Advince = string.Empty;
mergeList.Add(mergetask);
}
var writeFile = streamManager.GetWriteStream("成品目标template.xls");
bookManager.WriteAllTaskToFile(mergeList, nwlist, writeFile);
Console.WriteLine("导出完成，请按任意键结束！");
Console.Read();
}