public Stream GetReportContainerSizeList(string strTypeLanguage) { Stream stream; DataRow row; _DataSet_ContainerSizeList.DataTable1DataTable dt; List <ContainerSize_M> containerSizeList; int intLanguage = 1; var containersizes = _containerSizeRepository.GetAllQueryable(); containersizes = containersizes.OrderBy("ContainerSizeC descending"); containerSizeList = containersizes.ToList(); dt = new _DataSet_ContainerSizeList.DataTable1DataTable(); foreach (ContainerSize_M item in containerSizeList) { row = dt.NewRow(); row["ContainerSizeC"] = item.ContainerSizeC; row["ContainerSizeN"] = item.ContainerSizeN; row["Description"] = item.Description; row["Status"] = item.IsActive; //row["Status"] = "Không khả dụng"; //if (item.IsActive) //{ // row["Status"] = "Khả dụng"; //} dt.Rows.Add(row); } if (strTypeLanguage == "en") { intLanguage = 2; } else if (strTypeLanguage == "jp") { intLanguage = 3; } stream = ExportPDF.GetContainerSizeList(dt, intLanguage); return(stream); }
public static Stream GetContainerSizeList(_DataSet_ContainerSizeList.DataTable1DataTable datatable, int intLanguage = 1) { try { ReportDocument report; string strPath; //strPath = HttpContext.Current.Request.MapPath("~/FileRpt/ContainerSize/ContainnerSizeList.rpt"); //deploy strPath = HttpContext.Current.Request.MapPath("~/FileRpt/ContainerSize/ContainnerSizeList.rpt"); if (intLanguage == 3) { strPath = HttpContext.Current.Request.MapPath("~/FileRpt/ContainerSize/ContainnerSizeListJP.rpt"); } else if (intLanguage == 2) { strPath = HttpContext.Current.Request.MapPath("~/FileRpt/ContainerSize/ContainnerSizeListEN.rpt"); } report = new ReportDocument(); report.Load(strPath); report.Database.Tables[0].SetDataSource((DataTable)datatable); //if (type == 1) //{ // return report.ExportToStream(ExportFormatType.Excel); //} Stream stream = report.ExportToStream(ExportFormatType.PortableDocFormat); report.Close(); report.Dispose(); GC.Collect(); return(stream); } catch (NullReferenceException) { throw new NullReferenceException(); } }