public IHttpActionResult LoadSummaryPreviewUrl(string taskId, string corp, string org, string name, string username) { bool c1 = !string.IsNullOrEmpty(corp) && corp == "1"; //公司 bool c2 = !string.IsNullOrEmpty(org) && org == "1"; //组织架构 bool c3 = !string.IsNullOrEmpty(name) && name == "1"; //姓名 bool c4 = !string.IsNullOrEmpty(username) && username == "1"; //账号 TaskCollectionDataBuilder tdb = new TaskCollectionDataBuilder(taskId, null); string fileExt = ".xls"; Workbook dataBook = tdb.BuildData(c1, c2, c3, c4, out fileExt); SaveFormat format = SaveFormat.Excel97To2003; if (fileExt == ".xlsx") { format = SaveFormat.Xlsx; } MemoryStream stream = new MemoryStream(); dataBook.Save(stream, format); stream.Seek(0, SeekOrigin.Begin); var fileName = string.Format("{0}{1}", dataBook.FileName, fileExt); var attachment = AttachmentOperator.Instance.CommonUpload(taskId, "DownLoadTaskSummaryFile", fileName, stream); return(BizResult(string.Format("/api/attachments/orgstream/{0}", attachment.ID))); }
public IHttpActionResult LoadSummaryData(string taskId, string corp, string org, string name, string username) { bool c1 = !string.IsNullOrEmpty(corp) && corp == "1"; //公司 bool c2 = !string.IsNullOrEmpty(org) && org == "1"; //组织架构 bool c3 = !string.IsNullOrEmpty(name) && name == "1"; //姓名 bool c4 = !string.IsNullOrEmpty(username) && username == "1"; //账号 TaskCollectionDataBuilder tdb = new TaskCollectionDataBuilder(taskId, null); string fileExt = ".xls"; //Workbook dataBook = tdb.BuildData(c1, c2, c3, c4, out fileExt); Workbook dataBook = tdb.BuildDataFormula(c1, c2, c3, c4, out fileExt); SaveFormat format = SaveFormat.Excel97To2003; if (fileExt == ".xlsx") { format = SaveFormat.Xlsx; } MemoryStream stream = new MemoryStream(); dataBook.Save(stream, format); stream.Seek(0, SeekOrigin.Begin); var fileName = string.Format("{0}{1}", dataBook.FileName, fileExt); //return BizResult(FileUploadHelper.GetPreviewUrlByStream(stream, fileName)); return(new FileResult(fileName, stream.ToArray(), Request)); }