public JsonResult XepHangDoanhThu(int idDuAn) { var modelDirect = _thamgiaService.GetIncomeById(idDuAn, 0); var modelInDirect = _thamgiaService.GetIncomeById(idDuAn, 1); var responseDataDirect = new JavaScriptSerializer().Serialize(modelDirect); var responseDataInDirect = new JavaScriptSerializer().Serialize(modelInDirect); return(Json(new { dataDirect = responseDataDirect, dataInDirect = responseDataInDirect, status = true }, JsonRequestBehavior.AllowGet)); }
public async Task <HttpResponseMessage> ExportExcel(HttpRequestMessage request, int idDuAn) { return(CreateReponse(request, () => { string filename = string.Concat(DateTime.Now.ToString("ddMMyyyyhhmmss") + "aso.xlsx"); var folderReport = ConfigHelper.GetValueByKey("ReportFolder"); string path = HttpContext.Current.Server.MapPath(folderReport); var pathTemplate = ConfigHelper.GetValueByKey("Template"); string fullPathTemplateStandad = Path.Combine(HttpContext.Current.Server.MapPath(pathTemplate)); if (!Directory.Exists(path)) { Directory.CreateDirectory(path); } string fullPath = Path.Combine(path, filename); try { var duan = _daService.GetAllInfoById(idDuAn); var hangmucGt = _hangmucService.GetHangMucByIdDuAn(idDuAn, 1); var hangmucTT = _hangmucService.GetHangMucByIdDuAn(idDuAn, 0); //fullPathTemplateStandad //, new System.IO.FileInfo() using (ExcelPackage ep = new ExcelPackage(new System.IO.FileInfo(fullPath))) { if (hangmucGt.Count() > 0) { ExcelWorksheet exs = ep.Workbook.Worksheets.Add("GIÁN TIẾP"); var thamgiaGt = _thamGia.GetIncomeById(idDuAn, 1); this.ExcelAction(hangmucGt, thamgiaGt, exs, duan, 1); } if (hangmucTT.Count() > 0) { ExcelWorksheet dexs = ep.Workbook.Worksheets.Add("TRỰC TIẾP"); var thamgiaTt = _thamGia.GetIncomeById(idDuAn, 0); this.ExcelAction(hangmucTT, thamgiaTt, dexs, duan, 0); } // direct //ExcelWorksheet dexs = ep.Workbook.Worksheets[2]; //GenerateInfoProject(duan, dexs, 0); //this.GenerateContent(hangmucTT, dexs); //exs.Cells["B15"].AutoFitColumns(hangmuc); //ExcelCellAddress start = range.Start; //ExcelCellAddress end = range.End; //range.Worksheet.Cells[start.Row, start.Column, end.Row, end.Column].Merge = true; ep.Save(); } return request.CreateErrorResponse(HttpStatusCode.OK, Path.Combine(folderReport, filename)); } catch (Exception ex) { return request.CreateResponse(HttpStatusCode.BadRequest, ex); } })); }