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