public static void ExportPDF(string reportFileName, DataTable dataSource, string reportDataSourceName, string pdfFileName) { using (FileStream fileStream = new FileStream(pdfFileName, FileMode.Create)) { PDFHelper.ExportPDF(reportFileName, dataSource, reportDataSourceName, fileStream); } }
private static void CreateLedger(object state) { LedgerArgument ledgerArgument = (LedgerArgument)state; Token token = ledgerArgument.Token; string sql = "EXEC P_RptLedger @xmlAccounts=\'" + XmlTransform.Transform(ledgerArgument.IDs, ',', "Accounts", "Account", "ID") + "\',@tradeDayBegin=\'" + ledgerArgument.DateFrom + "\',@tradeDayTo=\'" + ledgerArgument.DateTo + "\',@language=\'" + ledgerArgument.Version + "\',@userID=\'" + ledgerArgument.Token.UserID.ToString() + "\'"; try { DataSet dataSet = DataAccess.GetData(sql, SettingManager.Default.ConnectionString, LedgerReportTimeout); try { TradingConsoleServer tradingConsoleServer = ledgerArgument.TradingConsoleServer; tradingConsoleServer.SaveLedger(token, "", ledgerArgument.IDs); } catch { } if (dataSet.Tables.Count > 0) { string filepath = Path.Combine(SettingManager.Default.PhysicPath, ledgerArgument.Rdlc); //this.Server.MapPath(ledgerArgument.Rdlc); byte[] reportContent = PDFHelper.ExportPDF(filepath, dataSet.Tables[0]); AsyncResultManager asyncResultManager = ledgerArgument.AsyncResultManager; asyncResultManager.SetResult(ledgerArgument.AsyncResult, reportContent); CommandManager.Default.AddCommand(new AsyncCommand(0, ledgerArgument.AsyncResult)); } } catch (System.Exception ex) { CommandManager.Default.AddCommand(new AsyncCommand(0, ledgerArgument.AsyncResult, true, ex)); _Logger.Error(ex); } }
private static void CreateAccountSummary(object state) { AccountSummaryArgument accountSummaryArgument = (AccountSummaryArgument)state; Token token = accountSummaryArgument.Token; string sql = "EXEC P_RptAccountSummary @xmlAccounts=\'" + XmlTransform.Transform(accountSummaryArgument.AccountIds, ',', "Accounts", "Account", "ID") + "\',@tradeDayFrom=\'" + accountSummaryArgument.FromDay + "\',@tradeDayTo=\'" + accountSummaryArgument.ToDay + "\',@language=\'" + accountSummaryArgument.Version + "\',@userID=\'" + accountSummaryArgument.Token.UserID.ToString() + "\', @skipNoTransactionAccount=0"; try { DataSet dataSet = DataAccess.GetData(sql, SettingManager.Default.ConnectionString, LedgerReportTimeout); if (dataSet.Tables.Count > 0) { string filepath = Path.Combine(SettingManager.Default.PhysicPath, accountSummaryArgument.Rdlc); //this.Server.MapPath(accountSummaryArgument.Rdlc); byte[] reportContent = PDFHelper.ExportPDF(filepath, dataSet.Tables[0]); AsyncResultManager asyncResultManager = accountSummaryArgument.AsyncResultManager; asyncResultManager.SetResult(accountSummaryArgument.AsyncResult, reportContent); CommandManager.Default.AddCommand(new AsyncCommand(0, accountSummaryArgument.AsyncResult)); } } catch (System.Exception ex) { CommandManager.Default.AddCommand(new AsyncCommand(0, accountSummaryArgument.AsyncResult, true, ex)); _Logger.Error(ex); } }
public static void ExportPDF(string reportFileName, DataTable dataSource, string reportDataSourceName, Stream fileStream) { LocalReport localReport = PDFHelper.CreateLocalReport(reportFileName, dataSource, reportDataSourceName); PDFHelper.ExportPDF(localReport, fileStream); }
public static void ExportPDF(string reportFileName, DataTable dataSource, Stream fileStream) { PDFHelper.ExportPDF(reportFileName, dataSource, "Default", fileStream); }
public static void ExportPDF2(string reportFileName, DataTable dataSource, string pdfFileName) { PDFHelper.ExportPDF(reportFileName, dataSource, "Default", pdfFileName); }
public static byte[] ExportPDF(string reportFileName, DataTable dataSource) { return(PDFHelper.ExportPDF(reportFileName, dataSource, "Default")); }
private static void CreateStatement(object state) { StatementArg statementArg = (StatementArg)state; Token token = statementArg.Token; string sql = string.Empty; if (statementArg.Rdlc.ToLower().Contains("statement_mc")) { sql = "EXEC P_RptStatement_RC2 "; } else { switch (statementArg.StatementReportType) { case 0: sql = "EXEC P_RptStatement_RC2 "; break; case 1: sql = "EXEC P_RptStatement2_RC2 "; break; case 2: sql = "EXEC P_RptStatement4_RC2 "; break; case 3: sql = "EXEC P_RptStatement5_RC2 "; break; } } sql += "@xmlAccounts=" + "\'" + XmlTransform.Transform(statementArg.IDs, ',', "Accounts", "Account", "ID") + "\',@tradeDayBegin=\'" + statementArg.DayBegin + "\',@tradeDayTo=\'" + statementArg.DayTo + "\',@language=\'" + statementArg.Version + "\',@userID=\'" + statementArg.Token.UserID.ToString() + "\'"; try { DataSet dataSet = DataAccess.GetData(sql, SettingManager.Default.ConnectionString, StatementReportTimeout); try { TradingConsoleServer tradingConsoleServer = statementArg.TradingConsoleServer; tradingConsoleServer.SaveStatement(token, "", statementArg.IDs); } catch { } if (dataSet.Tables.Count > 0) { string filepath = Path.Combine(SettingManager.Default.PhysicPath, statementArg.Rdlc); // this.Server.MapPath(statementArg.Rdlc); Console.WriteLine(filepath); if (statementArg.Rdlc.ToLower().Contains("statement_mc") && dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { if (!(bool)dataSet.Tables[0].Rows[0]["IsMultiCurrency"]) { filepath = filepath.ToLower().Replace("rptStatement_mc.rdlc", "RptStatement.rdlc"); } } byte[] reportContent = PDFHelper.ExportPDF(filepath, dataSet.Tables[0]); AsyncResultManager asyncResultManager = statementArg.AsyncResultManager; asyncResultManager.SetResult(statementArg.AsyncResult, reportContent); CommandManager.Default.AddCommand(new AsyncCommand(0, statementArg.AsyncResult)); } } catch (System.Exception ex) { CommandManager.Default.AddCommand(new AsyncCommand(0, statementArg.AsyncResult, true, ex)); _Logger.Error(ex); } }