private void ExportToStream(object oReport, string sFileName, StringBuilder sb, exportTo eExport) { System.IO.Stream oStream = null; StreamWriter sw = null; ExportOptions oOptions = new ExportOptions(); ExportRequestContext oRequest = new ExportRequestContext(); Response.Buffer = true; Response.ClearHeaders(); Response.ClearContent(); if (eExport == exportTo.TXT) { oStream = new MemoryStream(); sw = new StreamWriter(oStream, System.Text.Encoding.Default); sw.WriteLine(sb); sw.Flush(); oStream.Seek(0, SeekOrigin.Begin); Response.ContentType = "application/vnd.ms-excel"; } else if (eExport == exportTo.XLS) { oOptions.ExportFormatType = ExportFormatType.Excel; oOptions.FormatOptions = new ExcelFormatOptions(); oRequest.ExportInfo = oOptions; oStream = ((ReportDocument)oReport).ExportToStream(ExportFormatType.Excel); Response.ContentType = "application/vnd.ms-excel"; } else if (eExport == exportTo.PDF) { oOptions.ExportFormatType = ExportFormatType.PortableDocFormat; oOptions.FormatOptions = new PdfRtfWordFormatOptions(); oRequest.ExportInfo = oOptions; oStream = ((ReportDocument)oReport).ExportToStream(ExportFormatType.PortableDocFormat); Response.ContentType = "application/pdf"; } else if (eExport == exportTo.DOC) { oOptions.ExportFormatType = ExportFormatType.WordForWindows; oOptions.FormatOptions = new PdfRtfWordFormatOptions(); oRequest.ExportInfo = oOptions; oStream = ((ReportDocument)oReport).ExportToStream(ExportFormatType.WordForWindows); Response.ContentType = "application/msword"; } Response.AppendHeader("Content-Disposition", "Attachment; Filename=\"" + sFileName.Replace(" ", "_") + "\""); byte[] streamByte = new byte[oStream.Length]; oStream.Read(streamByte, 0, (int)oStream.Length); Response.BinaryWrite(streamByte); Response.End(); if (oStream != null) { oStream.Close(); } if (sw != null) { sw.Close(); } }
private void getReport(bool sendToPrinter, exportTo eExport) { string reportName = "AdmRptPrgList"; cCriteria.Visible = false; cClearCriButton.Visible = false; cShowCriButton.Visible = (bool)Session[KEY_bShCriVisible]; DataTable dt = (new AdminSystem()).GetRptDt(58, "GetAdmRptPrgList", base.LImpr, base.LCurr, UpdCriteria(false), GetRptCriteria(), LcAppConnString, LcAppPw, false, false, false, CommandTimeOut); CovertRptUTC(dt); if (dt.Rows.Count > 0) { if (dt.Columns.Contains("ReportName")) { reportName = dt.Rows[0]["ReportName"].ToString(); } } else { PreMsgPopup("For your information, no data is currently available as per your reporting criteria."); } if (Config.DeployType == "DEV" && Config.AppNameSpace == "RO") { DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.DataSetName = "DsAdmRptPrgList"; ds.Tables[0].TableName = "DtAdmRptPrgList"; string xsdPath = Server.MapPath("~/reports/AdmRptPrgListReport.xsd"); using (System.IO.StreamWriter writer = new System.IO.StreamWriter(xsdPath)) { ds.WriteXmlSchema(writer); writer.Close(); } } reportName = reportName + "_" + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString(); DataView dvItem = GetReportItem(); DataView dvSct = GetReportSct(); foreach (DataRowView drv in dvSct) { SetReportSct(dvItem, drv["ReportSctName"].ToString()); } rp.Refresh(); if (sendToPrinter) { rp.PrintOptions.PrinterName = cPrinter.SelectedItem.Value; rp.PrintOptions.PaperOrientation = PaperOrientation.Portrait; } rp.SetDataSource(dt); cViewer.ReportSource = rp; if (cViewerWidth.Value != string.Empty) { cViewer.Width = Unit.Pixel(int.Parse(cViewerWidth.Value)); } cViewer.Visible = true; cViewer.DisplayGroupTree = false; if (sendToPrinter) { rp.PrintToPrinter(1, false, 0, 0); } if (eExport == exportTo.TXT) { StringBuilder sb = new StringBuilder(); if (dt.Columns.Contains("CultureDescIn")) { sb.Append("Culture Requested" + (char)9); } if (dt.Columns.Contains("SystemNameIn")) { sb.Append("System Requested" + (char)9); } if (dt.Columns.Contains("QId")) { sb.Append("Menu Order" + (char)9); } if (dt.Columns.Contains("MenuText")) { sb.Append("Menu Label" + (char)9); } if (dt.Columns.Contains("ProgramType")) { sb.Append("Program Type" + (char)9); } if (dt.Columns.Contains("ProgramName")) { sb.Append("Program Name" + (char)9); } if (dt.Columns.Contains("Everyone")) { sb.Append("Everyone Access" + (char)9); } if (dt.Columns.Contains("ClientTierList")) { sb.Append("Client Tier List" + (char)9); } if (dt.Columns.Contains("RuleTierList")) { sb.Append("Rule Tier List" + (char)9); } if (dt.Columns.Contains("DataTierList")) { sb.Append("Data Tier List" + (char)9); } if (dt.Columns.Contains("ClientRule")) { sb.Append("Client Rule" + (char)9); } if (dt.Columns.Contains("WebRule")) { sb.Append("Web Rule" + (char)9); } if (dt.Columns.Contains("ServerRule")) { sb.Append("Server Rule" + (char)9); } sb.Append(Environment.NewLine); DataView dv = new DataView(dt); foreach (DataRowView drv in dv) { if (dt.Columns.Contains("CultureDescIn")) { sb.Append(drv["CultureDescIn"].ToString() + (char)9); } if (dt.Columns.Contains("SystemNameIn")) { sb.Append(drv["SystemNameIn"].ToString() + (char)9); } if (dt.Columns.Contains("QId")) { sb.Append(drv["QId"].ToString() + (char)9); } if (dt.Columns.Contains("MenuText")) { sb.Append(drv["MenuText"].ToString() + (char)9); } if (dt.Columns.Contains("ProgramType")) { sb.Append(drv["ProgramType"].ToString() + (char)9); } if (dt.Columns.Contains("ProgramName")) { sb.Append(drv["ProgramName"].ToString() + (char)9); } if (dt.Columns.Contains("Everyone")) { sb.Append(drv["Everyone"].ToString() + (char)9); } if (dt.Columns.Contains("ClientTierList")) { sb.Append(drv["ClientTierList"].ToString() + (char)9); } if (dt.Columns.Contains("RuleTierList")) { sb.Append(drv["RuleTierList"].ToString() + (char)9); } if (dt.Columns.Contains("DataTierList")) { sb.Append(drv["DataTierList"].ToString() + (char)9); } if (dt.Columns.Contains("ClientRule")) { sb.Append(drv["ClientRule"].ToString() + (char)9); } if (dt.Columns.Contains("WebRule")) { sb.Append(drv["WebRule"].ToString() + (char)9); } if (dt.Columns.Contains("ServerRule")) { sb.Append(drv["ServerRule"].ToString() + (char)9); } sb.Append(Environment.NewLine); } ExportToStream(null, reportName + ".csv", sb.Insert(0, (Config.ExportExcelCSV ? "sep=\t\n": "")).Replace("\r\n", "\n"), exportTo.TXT); } else if (eExport == exportTo.XLS) { ExportToStream(rp, reportName + ".xls", null, exportTo.XLS); } else if (eExport == exportTo.PDF) { ExportToStream(rp, reportName + ".pdf", null, exportTo.PDF); } else if (eExport == exportTo.DOC) { ExportToStream(rp, reportName + ".doc", null, exportTo.DOC); } }
private void getReport(bool sendToPrinter, exportTo eExport) { string reportName = "AdmRptUsr"; cCriteria.Visible = false; cClearCriButton.Visible = false; cShowCriButton.Visible = (bool)Session[KEY_bShCriVisible]; DataTable dt = (new AdminSystem()).GetRptDt(53, "GetAdmRptUsr", base.LImpr, base.LCurr, UpdCriteria(false), GetRptCriteria(), LcAppConnString, LcAppPw, false, false, false, Config.CommandTimeOut); CovertRptUTC(dt); if (dt.Rows.Count > 0) { if (dt.Columns.Contains("ReportName")) { reportName = dt.Rows[0]["ReportName"].ToString(); } } else { PreMsgPopup("For your information, no data is currently available as per your reporting criteria."); } if (Config.DeployType == "DEV" && Config.AppNameSpace == "RO") { DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.DataSetName = "DsAdmRptUsr"; ds.Tables[0].TableName = "DtAdmRptUsr"; string xsdPath = Server.MapPath("~/reports/AdmRptUsrReport.xsd"); using (System.IO.StreamWriter writer = new System.IO.StreamWriter(xsdPath)) { ds.WriteXmlSchema(writer); writer.Close(); } } reportName = reportName + "_" + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString(); DataView dvItem = GetReportItem(); DataView dvSct = GetReportSct(); foreach (DataRowView drv in dvSct) { SetReportSct(dvItem, drv["ReportSctName"].ToString()); } rp.Refresh(); if (sendToPrinter) { rp.PrintOptions.PrinterName = cPrinter.SelectedItem.Value; rp.PrintOptions.PaperOrientation = PaperOrientation.Landscape; } rp.SetDataSource(dt); cViewer.ReportSource = rp; if (cViewerWidth.Value != string.Empty) { cViewer.Width = Unit.Pixel(int.Parse(cViewerWidth.Value)); } cViewer.Visible = true; cViewer.DisplayGroupTree = false; if (sendToPrinter) { rp.PrintToPrinter(1, false, 0, 0); } if (eExport == exportTo.TXT) { StringBuilder sb = new StringBuilder(); if (dt.Columns.Contains("a.Active")) { sb.Append("a.Active" + (char)9); } if (dt.Columns.Contains("b.UsrGroupId")) { sb.Append("b.UsrGroupId" + (char)9); } if (dt.Columns.Contains("CurrCompany")) { sb.Append("Current Selected Company" + (char)9); } if (dt.Columns.Contains("UsrGroupIn")) { sb.Append("Selected User Group" + (char)9); } if (dt.Columns.Contains("ActiveIn")) { sb.Append("Active" + (char)9); } if (dt.Columns.Contains("UsrGroupName")) { sb.Append("User Group" + (char)9); } if (dt.Columns.Contains("CultureTypeName")) { sb.Append("Culture" + (char)9); } if (dt.Columns.Contains("RowAuthorityDesc")) { sb.Append("Row Authority" + (char)9); } if (dt.Columns.Contains("ColAuthorityDesc")) { sb.Append("Col Authority" + (char)9); } if (dt.Columns.Contains("LoginName")) { sb.Append("Login Name" + (char)9); } if (dt.Columns.Contains("UsrName")) { sb.Append("User Name" + (char)9); } if (dt.Columns.Contains("UsrEmail")) { sb.Append("User Email" + (char)9); } if (dt.Columns.Contains("CompanyDesc")) { sb.Append("Company" + (char)9); } if (dt.Columns.Contains("InvestorName")) { sb.Append("Investor" + (char)9); } if (dt.Columns.Contains("CustomerName")) { sb.Append("Customer" + (char)9); } if (dt.Columns.Contains("VendorName")) { sb.Append("Vendor" + (char)9); } if (dt.Columns.Contains("AgentName")) { sb.Append("Agent Name" + (char)9); } if (dt.Columns.Contains("BrokerName")) { sb.Append("Broker Name" + (char)9); } if (dt.Columns.Contains("MemberName")) { sb.Append("Member" + (char)9); } if (dt.Columns.Contains("iUsrName")) { sb.Append("Impr User Name" + (char)9); } if (dt.Columns.Contains("iCompanyDesc")) { sb.Append("Impr Company Name" + (char)9); } if (dt.Columns.Contains("iInvestorName")) { sb.Append("Impr Investor Name" + (char)9); } if (dt.Columns.Contains("iCustomerName")) { sb.Append("Impr Customer Name" + (char)9); } if (dt.Columns.Contains("iVendorName")) { sb.Append("Impr Vendor Name" + (char)9); } if (dt.Columns.Contains("iAgentName")) { sb.Append("Impr Agent Name" + (char)9); } if (dt.Columns.Contains("iBrokerName")) { sb.Append("Impr Broker Name" + (char)9); } if (dt.Columns.Contains("iMemberName")) { sb.Append("Impr Member Name" + (char)9); } sb.Append(Environment.NewLine); DataView dv = new DataView(dt); foreach (DataRowView drv in dv) { if (dt.Columns.Contains("a.Active")) { sb.Append(drv["a.Active"].ToString() + (char)9); } if (dt.Columns.Contains("b.UsrGroupId")) { sb.Append(drv["b.UsrGroupId"].ToString() + (char)9); } if (dt.Columns.Contains("CurrCompany")) { sb.Append(drv["CurrCompany"].ToString() + (char)9); } if (dt.Columns.Contains("UsrGroupIn")) { sb.Append(drv["UsrGroupIn"].ToString() + (char)9); } if (dt.Columns.Contains("ActiveIn")) { sb.Append(drv["ActiveIn"].ToString() + (char)9); } if (dt.Columns.Contains("UsrGroupName")) { sb.Append(drv["UsrGroupName"].ToString() + (char)9); } if (dt.Columns.Contains("CultureTypeName")) { sb.Append(drv["CultureTypeName"].ToString() + (char)9); } if (dt.Columns.Contains("RowAuthorityDesc")) { sb.Append(drv["RowAuthorityDesc"].ToString() + (char)9); } if (dt.Columns.Contains("ColAuthorityDesc")) { sb.Append(drv["ColAuthorityDesc"].ToString() + (char)9); } if (dt.Columns.Contains("LoginName")) { sb.Append(drv["LoginName"].ToString() + (char)9); } if (dt.Columns.Contains("UsrName")) { sb.Append(drv["UsrName"].ToString() + (char)9); } if (dt.Columns.Contains("UsrEmail")) { sb.Append(drv["UsrEmail"].ToString() + (char)9); } if (dt.Columns.Contains("CompanyDesc")) { sb.Append(drv["CompanyDesc"].ToString() + (char)9); } if (dt.Columns.Contains("InvestorName")) { sb.Append(drv["InvestorName"].ToString() + (char)9); } if (dt.Columns.Contains("CustomerName")) { sb.Append(drv["CustomerName"].ToString() + (char)9); } if (dt.Columns.Contains("VendorName")) { sb.Append(drv["VendorName"].ToString() + (char)9); } if (dt.Columns.Contains("AgentName")) { sb.Append(drv["AgentName"].ToString() + (char)9); } if (dt.Columns.Contains("BrokerName")) { sb.Append(drv["BrokerName"].ToString() + (char)9); } if (dt.Columns.Contains("MemberName")) { sb.Append(drv["MemberName"].ToString() + (char)9); } if (dt.Columns.Contains("iUsrName")) { sb.Append(drv["iUsrName"].ToString() + (char)9); } if (dt.Columns.Contains("iCompanyDesc")) { sb.Append(drv["iCompanyDesc"].ToString() + (char)9); } if (dt.Columns.Contains("iInvestorName")) { sb.Append(drv["iInvestorName"].ToString() + (char)9); } if (dt.Columns.Contains("iCustomerName")) { sb.Append(drv["iCustomerName"].ToString() + (char)9); } if (dt.Columns.Contains("iVendorName")) { sb.Append(drv["iVendorName"].ToString() + (char)9); } if (dt.Columns.Contains("iAgentName")) { sb.Append(drv["iAgentName"].ToString() + (char)9); } if (dt.Columns.Contains("iBrokerName")) { sb.Append(drv["iBrokerName"].ToString() + (char)9); } if (dt.Columns.Contains("iMemberName")) { sb.Append(drv["iMemberName"].ToString() + (char)9); } sb.Append(Environment.NewLine); } ExportToStream(null, reportName + ".csv", sb.Insert(0, (Config.ExportExcelCSV ? "sep=\t\n": "")).Replace("\r\n", "\n"), exportTo.TXT); } else if (eExport == exportTo.XLS) { ExportToStream(rp, reportName + ".xls", null, exportTo.XLS); } else if (eExport == exportTo.PDF) { ExportToStream(rp, reportName + ".pdf", null, exportTo.PDF); } else if (eExport == exportTo.DOC) { ExportToStream(rp, reportName + ".doc", null, exportTo.DOC); } }
private void getReport(bool sendToPrinter, exportTo eExport) { string reportName = "AdmRptSred"; cCriteria.Visible = false; cClearCriButton.Visible = false; cShowCriButton.Visible = (bool)Session[KEY_bShCriVisible]; DataTable dt = (new AdminSystem()).GetRptDt(59, "GetAdmRptSred", base.LImpr, base.LCurr, UpdCriteria(false), GetRptCriteria(), LcAppConnString, LcAppPw, false, false, false); CovertRptUTC(dt); if (dt.Rows.Count > 0) { if (dt.Columns.Contains("ReportName")) { reportName = dt.Rows[0]["ReportName"].ToString(); } } else { PreMsgPopup("For your information, no data is currently available as per your reporting criteria."); } if (Config.DeployType == "DEV" && Config.AppNameSpace == "RO") { DataSet ds = new DataSet(); ds.Tables.Add(dt); ds.DataSetName = "DsAdmRptSred"; ds.Tables[0].TableName = "DtAdmRptSred"; string xsdPath = Server.MapPath("~/reports/AdmRptSredReport.xsd"); using (System.IO.StreamWriter writer = new System.IO.StreamWriter(xsdPath)) { ds.WriteXmlSchema(writer); writer.Close(); } } reportName = reportName + "_" + DateTime.Now.Hour.ToString() + DateTime.Now.Minute.ToString() + DateTime.Now.Second.ToString(); DataView dvItem = GetReportItem(); DataView dvSct = GetReportSct(); foreach (DataRowView drv in dvSct) { SetReportSct(dvItem, drv["ReportSctName"].ToString()); } rp.Refresh(); if (sendToPrinter) { rp.PrintOptions.PrinterName = cPrinter.SelectedItem.Value; rp.PrintOptions.PaperOrientation = PaperOrientation.Portrait; } rp.SetDataSource(dt); cViewer.ReportSource = rp; if (cViewerWidth.Value != string.Empty) { cViewer.Width = Unit.Pixel(int.Parse(cViewerWidth.Value)); } cViewer.Visible = true; cViewer.DisplayGroupTree = false; if (sendToPrinter) { rp.PrintToPrinter(1, false, 0, 0); } if (eExport == exportTo.TXT) { StringBuilder sb = new StringBuilder(); if (dt.Columns.Contains("InMonthEnding")) { sb.Append("Month Ending" + (char)9); } if (dt.Columns.Contains("InNumMonths")) { sb.Append("# of Months" + (char)9); } if (dt.Columns.Contains("EmpType")) { sb.Append("Employee Type" + (char)9); } if (dt.Columns.Contains("MemberName")) { sb.Append("Member Name" + (char)9); } if (dt.Columns.Contains("Salary")) { sb.Append("Salary or Wages" + (char)9); } if (dt.Columns.Contains("TxBenefit")) { sb.Append("Taxable Benefits" + (char)9); } sb.Append(Environment.NewLine); DataView dv = new DataView(dt); foreach (DataRowView drv in dv) { if (dt.Columns.Contains("InMonthEnding")) { sb.Append(drv["InMonthEnding"].ToString() + (char)9); } if (dt.Columns.Contains("InNumMonths")) { sb.Append(drv["InNumMonths"].ToString() + (char)9); } if (dt.Columns.Contains("EmpType")) { sb.Append(drv["EmpType"].ToString() + (char)9); } if (dt.Columns.Contains("MemberName")) { sb.Append(drv["MemberName"].ToString() + (char)9); } if (dt.Columns.Contains("Salary")) { sb.Append(drv["Salary"].ToString() + (char)9); } if (dt.Columns.Contains("TxBenefit")) { sb.Append(drv["TxBenefit"].ToString() + (char)9); } sb.Append(Environment.NewLine); } ExportToStream(null, reportName + ".xls", sb.Replace("\r\n", "\n"), exportTo.TXT); } else if (eExport == exportTo.XLS) { ExportToStream(rp, reportName + ".xls", null, exportTo.XLS); } else if (eExport == exportTo.PDF) { ExportToStream(rp, reportName + ".pdf", null, exportTo.PDF); } else if (eExport == exportTo.DOC) { ExportToStream(rp, reportName + ".doc", null, exportTo.DOC); } }