// Pre: No value is NULL // Post: output report bytes public static byte[] GetUmzugsmitteilung(COR_Reports.ReportFormatInfo formatInfo, string in_ump_uid, string in_sprache) { string report = "UM_Umzugsmitteilung2.rdl"; byte[] baReport = null; // if (string.IsNullOrEmpty(in_ump_uid)) in_ump_uid = "C38CB749-1EEC-4686-9BBA-F627B9C4E8EC"; if (string.IsNullOrEmpty(in_sprache)) in_sprache = "DE"; // formatInfo = new Portal_Reports.ReportFormatInfo(ExportFormat.Word); try { COR_Reports.ReportTools.ReportDataCallback_t myFunc = delegate(COR_Reports.ReportViewer viewer, System.Xml.XmlDocument doc) { // viewer["format"] = formatInfo.FormatName; // viewer["extension"] = formatInfo.Extension; // viewer["report"] = report; //string extension = viewer["extension"]; //////////////////////////// System.Collections.Generic.List<COR_Reports.ReportParameter> lsParameters = new System.Collections.Generic.List<COR_Reports.ReportParameter>(); viewer.SetParameters(lsParameters); lsParameters.Clear(); lsParameters = null; { // Add data sources COR_Reports.ReportDataSource rds = new COR_Reports.ReportDataSource(); rds.Name = "DataSet1"; //This refers to the dataset name in the RDLC file string strSQL = COR_Reports.ReportTools.GetDataSetDefinition(doc, rds.Name); rds.Value = SQL.GetDataTable(strSQL); strSQL = null; viewer.DataSources.Add(rds); } }; baReport = COR_Reports.ReportTools.RenderReport(report, formatInfo, myFunc); } catch { // Basic_SQL.SQL.Log(ex); throw; } // If testing if (System.StringComparer.InvariantCultureIgnoreCase.Equals(System.Environment.UserDomainName, "COR")) { using (System.IO.FileStream fs = System.IO.File.Create(@"D:\" + System.IO.Path.GetFileNameWithoutExtension(report) + formatInfo.Extension)) { fs.Write(baReport, 0, baReport.Length); } // End Using fs } return baReport; }
// D:\reportviewerz\2005 // Depends on TFS://COR-Library\COR_Reports\COR_Reports.csproj // Pre: No value is NULL // Post: output report bytes public static byte[] GetFooter(string report, COR_Reports.ReportFormatInfo formatInfo, string in_aperturedwg, string in_stylizer) { byte[] baReport = null; try { COR_Reports.ReportTools.ReportDataCallback_t myFunc = delegate(COR_Reports.ReportViewer viewer, System.Xml.XmlDocument doc) { // viewer["format"] = formatInfo.FormatName; // viewer["extension"] = formatInfo.Extension; // viewer["report"] = report; //string extension = viewer["extension"]; //////////////////////////// System.Collections.Generic.List<COR_Reports.ReportParameter> lsParameters = new System.Collections.Generic.List<COR_Reports.ReportParameter>(); lsParameters.Add(new COR_Reports.ReportParameter("in_aperturedwg", in_aperturedwg)); lsParameters.Add(new COR_Reports.ReportParameter("in_stylizer", in_stylizer)); // lsParameters.Add(new COR_Reports.ReportParameter("datastart", "dateTimePickerStartRaport.Text")); // lsParameters.Add(new COR_Reports.ReportParameter("dataStop", "dateTimePickerStopRaport.Text")); viewer.SetParameters(lsParameters); lsParameters.Clear(); lsParameters = null; // Add data sources COR_Reports.ReportDataSource rds = new COR_Reports.ReportDataSource(); rds.Name = "DATA_Planinfo"; //This refers to the dataset name in the RDLC file string strSQL = COR_Reports.ReportTools.GetDataSetDefinition(doc, rds.Name); strSQL = strSQL.Replace("@in_aperturedwg", "'" + in_aperturedwg.Replace("'", "''") + "'"); strSQL = strSQL.Replace("@in_stylizer", "'" + in_stylizer.Replace("'", "''") + "'"); rds.Value = Basic_SQL.SQL.GetDataTable(strSQL); strSQL = null; viewer.DataSources.Add(rds); }; // End Sub ReportDataCallback_t baReport = COR_Reports.ReportTools.RenderReport(report, formatInfo, myFunc); } catch (System.Exception ex) { Basic_SQL.SQL.Log(ex); throw; } // If testing if (System.StringComparer.InvariantCultureIgnoreCase.Equals(System.Environment.UserDomainName, "COR")) { using (System.IO.FileStream fs = System.IO.File.Create(@"D:\" + System.IO.Path.GetFileNameWithoutExtension(report) + formatInfo.Extension)) { fs.Write(baReport, 0, baReport.Length); } // End Using fs } return baReport; }
// Pre: No value is NULL // Post: output report bytes public static byte[] GetUmzugsmitteilung(COR_Reports.ReportFormatInfo formatInfo, string in_ump_uid, string in_sprache) { string report = "UM_Umzugsmitteilung.rdl"; byte[] baReport = null; // if (string.IsNullOrEmpty(in_ump_uid)) in_ump_uid = "C38CB749-1EEC-4686-9BBA-F627B9C4E8EC"; if (string.IsNullOrEmpty(in_sprache)) in_sprache = "DE"; // formatInfo = new Portal_Reports.ReportFormatInfo(ExportFormat.Word); try { COR_Reports.ReportTools.ReportDataCallback_t myFunc = delegate(COR_Reports.ReportViewer viewer, System.Xml.XmlDocument doc) { // viewer["format"] = formatInfo.FormatName; // viewer["extension"] = formatInfo.Extension; // viewer["report"] = report; //string extension = viewer["extension"]; //////////////////////////// System.Collections.Generic.List<COR_Reports.ReportParameter> lsParameters = new System.Collections.Generic.List<COR_Reports.ReportParameter>(); lsParameters.Add(new COR_Reports.ReportParameter("in_mandant", "0")); lsParameters.Add(new COR_Reports.ReportParameter("proc", "administrator")); lsParameters.Add(new COR_Reports.ReportParameter("in_sprache", in_sprache)); // lsParameters.Add(new Portal_Reports.ReportParameter("in_report_name", "UM_Umzugsmitteilung")); // lsParameters.Add(new Portal_Reports.ReportParameter("in_stichtag", System.DateTime.Now.ToString("dd.MM.yyyy"))); // lsParameters.Add(new Portal_Reports.ReportParameter("def_pageformat", "Seite {0} von {1}")); // lsParameters.Add(new Portal_Reports.ReportParameter("def_dateformat", "d.MM.yyyy")); lsParameters.Add(new COR_Reports.ReportParameter("in_umzugsuid", in_ump_uid)); // lsParameters.Add(new COR_Reports.ReportParameter("datastart", "dateTimePickerStartRaport.Text")); // lsParameters.Add(new COR_Reports.ReportParameter("dataStop", "dateTimePickerStopRaport.Text")); viewer.SetParameters(lsParameters); lsParameters.Clear(); lsParameters = null; { // Add data sources COR_Reports.ReportDataSource rds = new COR_Reports.ReportDataSource(); rds.Name = "DATA_Umzugsmitteilung"; //This refers to the dataset name in the RDLC file string strSQL = COR_Reports.ReportTools.GetDataSetDefinition(doc, rds.Name); strSQL = strSQL.Replace("@_in_umzugsuid", "'" + in_ump_uid.Replace("'", "''") + "'"); strSQL = strSQL.Replace("@_in_sprache", "'" + in_sprache.Replace("'", "''") + "'"); rds.Value = SQL.GetDataTable(strSQL); strSQL = null; viewer.DataSources.Add(rds); } { COR_Reports.ReportDataSource rdsHeader = new COR_Reports.ReportDataSource(); rdsHeader.Name = "DATA_Umzugsheader"; //This refers to the dataset name in the RDLC file string strSQL = COR_Reports.ReportTools.GetDataSetDefinition(doc, rdsHeader.Name); strSQL = strSQL.Replace("@_in_umzugsuid", "'" + in_ump_uid.Replace("'", "''") + "'"); rdsHeader.Value = SQL.GetDataTable(strSQL); strSQL = null; viewer.DataSources.Add(rdsHeader); } { COR_Reports.ReportDataSource rdsTranslation = new COR_Reports.ReportDataSource(); rdsTranslation.Name = "DATA_Report_Translation"; //This refers to the dataset name in the RDLC file string strSQL = COR_Reports.ReportTools.GetDataSetDefinition(doc, rdsTranslation.Name); strSQL = strSQL.Replace("@in_sprache", "'" + in_sprache.Replace("'", "''") + "'"); rdsTranslation.Value = SQL.GetDataTable(strSQL); strSQL = null; viewer.DataSources.Add(rdsTranslation); } }; baReport = COR_Reports.ReportTools.RenderReport(report, formatInfo, myFunc); } catch { // Basic_SQL.SQL.Log(ex); throw; } // If testing if (System.StringComparer.InvariantCultureIgnoreCase.Equals(System.Environment.UserDomainName, "COR")) { using (System.IO.FileStream fs = System.IO.File.Create(@"D:\" + System.IO.Path.GetFileNameWithoutExtension(report) + formatInfo.Extension)) { fs.Write(baReport, 0, baReport.Length); } // End Using fs } return baReport; }
// D:\reportviewerz\2005 // Depends on TFS://COR-Library\COR_Reports\COR_Reports.csproj // Pre: No value is NULL // Post: output report bytes public static byte[] GetReport2(string report, COR_Reports.ReportFormatInfo formatInfo) { byte[] baReport = null; try { COR_Reports.ReportTools.ReportDataCallback_t myFunc = delegate(COR_Reports.ReportViewer viewer, System.Xml.XmlDocument doc) { // Add data sources COR_Reports.ReportDataSource rds = new COR_Reports.ReportDataSource(); rds.Name = "DataSet1"; //This refers to the dataset name in the RDLC file string strSQL = COR_Reports.ReportTools.GetDataSetDefinition(doc, rds.Name); rds.Value = Basic_SQL.SQL.GetDataTable(strSQL); strSQL = null; viewer.DataSources.Add(rds); }; // End Sub ReportDataCallback_t baReport = COR_Reports.ReportTools.RenderReport(report, formatInfo, myFunc); } catch (System.Exception ex) { Basic_SQL.SQL.Log(ex); throw; } // If testing if (System.StringComparer.InvariantCultureIgnoreCase.Equals(System.Environment.UserDomainName, "COR")) { using (System.IO.FileStream fs = System.IO.File.Create(@"D:\" + System.IO.Path.GetFileNameWithoutExtension(report) + formatInfo.Extension)) { fs.Write(baReport, 0, baReport.Length); } // End Using fs } return baReport; }