public List <ReportEntity> Build(string reporttype)
{
IReportService service = new ReportService();
var setting = service.GetSetting(reporttype);
var start = DateTime.MinValue;
var end = DateTime.MinValue;
this.BuildPiror(setting, out start, out end);
var data = service.BuildAllReport(start, end, reporttype);
var filelist = new List <FileInfoEntity>();
var folder = ConfigurationManager.AppSettings["FilePath"];
foreach (var item in data)
{
if (item.TaskList != null)
{
var id = Guid.NewGuid();
var fileentity = new FileInfoEntity()
{
FileId = id.ToString(),
FileName = string.Format("{0}{1}{2}", item.ReportUser, item.ReportType, ".xlsx"),
FilePath = string.Format("~/Resource/Report/{0}.xlsx", id),
FileExtensions = ".xlsx",
FileType = "xlsx",
DeleteMark = 0,
EnabledMark = 1,
CreateDate = DateTime.Now,
CreateUserId = "system",
CreateUserName = "******",
ModifyDate = DateTime.Now,
ModifyUserId = "system",
ModifyUserName = "******",
RecId = item.ReportId.ToString()
};
var book = new Workbook();
var sheet = book.Worksheets[0];
sheet.Name = "任务清单";
sheet.Cells[0, 0].PutValue("序号");
sheet.Cells[0, 1].PutValue("工作时间");
sheet.Cells[0, 2].PutValue("工作任务");
sheet.Cells[0, 3].PutValue("作业人");
var style = sheet.Cells[0, 0].GetStyle();
style.ForegroundColor = System.Drawing.ColorTranslator.FromHtml("#C6EFCE");
style.Pattern = BackgroundType.Solid;
var range = sheet.Cells.CreateRange(0, 0, 1, 4);
range.ApplyStyle(style, new StyleFlag()
{
All = true
});
for (int i = 0; i < item.TaskList.Count; i++)
{
sheet.Cells[i + 1, 0].PutValue(i + 1);
sheet.Cells[i + 1, 1].PutValue(item.TaskList[i].TaskPrior);
sheet.Cells[i + 1, 2].PutValue(item.TaskList[i].TaskContent);
sheet.Cells[i + 1, 3].PutValue(item.TaskList[i].TaskPerson);
}
sheet.Cells.SetColumnWidthPixel(0, 100);
sheet.Cells.SetColumnWidthPixel(1, 200);
sheet.Cells.SetColumnWidthPixel(2, 600);
sheet.Cells.SetColumnWidthPixel(3, 300);
if (!Directory.Exists(Path.Combine(folder, "Report")))
{
Directory.CreateDirectory(Path.Combine(folder, "Report"));
}
book.Save(Path.Combine(folder, "Report", id.ToString() + ".xlsx"), SaveFormat.Xlsx);
filelist.Add(fileentity);
}
}
if (filelist.Count > 0)
{
var fileservice = new FileInfoService();
fileservice.SaveFiles(filelist);
}
return(data);
}