// might need to incorporate this with the bar slider.
private void cashBond(List <Check> checksToCash)
{
if (!patronCarryingReport.IsMaxLevel())
{
foreach (Check c in checksToCash)
{
if (c.IsTrialPassed)
{
patronCarryingReport.BondGainedOnThisQuest = 5;
}
else
{
patronCarryingReport.BondGainedOnThisQuest = 0;
}
patronCarryingReport.convertGainedBondToTotalBond();
if (patronCarryingReport.HasLeveledUp)
{
nextPageToTurnTo = ReportPages.LEVELUP;
if (patronCarryingReport.IsMaxLevel())
{
bondSlider.IsPatronAtMaxLevel = true;
}
}
}
}
}
public void Run()
{
var name = "test_0_2";
Report report = new Report(Json.Read(Path.Combine("rrpt", name + ".rrpt")));
report.GlobalScope.Add("time", DateTime.Now);
report.GlobalScope.Add("lang", "core");
report.Fill(DummyDataSource.GetInstance());
ReportPages pages = report.GetPages();
using (FileStream fs = new FileStream(Path.Combine("out", name + ".pdf"), FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
pages.Render(renderer);
}
using (FileStream fs = new FileStream(Path.Combine("out", name + ".xlsx"), FileMode.Create))
{
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook);
renderer.NewSheet("sheet_name");
pages.Render(renderer);
workbook.Write(fs);
}
{
var printer = new Printer(pages);
var preview = new FmPrintPreview(printer);
preview.ShowDialog();
}
}
public static void Run()
{
// 帳票定義ファイルを読み込みます
Report report = new Report(Json.Read("report\\example2.rrpt"));
// GlobalScopeに値を登録します
report.GlobalScope.Add("startDate", DateTime.ParseExact("2013/02/01", "yyyy/MM/dd", null));
report.GlobalScope.Add("endDate", DateTime.ParseExact("2013/02/28", "yyyy/MM/dd", null));
report.GlobalScope.Add("printDate", DateTime.Today);
report.GlobalScope.Add("kaisha", "株式会社 システムベース");
// 帳票にデータを渡します
report.Fill(new ReportDataSource(getDataTable()));
// PDF出力の実行時間を計測します
Stopwatch sw = new Stopwatch();
sw.Start();
// ページ分割を行います
ReportPages pages = report.GetPages();
// PDF出力
using (FileStream fs = new FileStream("output\\example2_huge.pdf", FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
// バックスラッシュ文字を円マーク文字に変換します
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
}
// 計測結果を表示します
System.Windows.Forms.MessageBox.Show("実行時間は" + sw.ElapsedMilliseconds + "ミリ秒です");
}
public void ReadBattleReport(Patron patronCarryingPaystub)
{
BattleReportPannel.gameObject.SetActive(true);
nextPageToTurnTo = ReportPages.REPORT;
patronCarryingReport = patronCarryingPaystub;
questToReportOn = patronCarryingPaystub.QuestToCompleete;
checkForUnlockables(patronCarryingPaystub.QuestToCompleete);
// bondSlider.SetSliderDefautValue(patronCarryingPaystub.BondPoints, patronCarryingReport.ThresholdToNextBondLevel); // HACK
flipPageInBattleReport();
}
public void Run()
{
var name = "test_5_14_date";
Report report = new Report(Json.Read(Path.Combine("rrpt", name + ".rrpt")));
report.Fill(DummyDataSource.GetInstance());
ReportPages pages = report.GetPages();
{
var preview = new FmPrintPreview(new Printer(pages));
preview.ShowDialog();
}
}
private void FlipToSummaryPage()
{
BattleReportSummaryPageProps.SetActive(true);
nextPageToTurnTo = ReportPages.CLOSED;
nextPageButton.gameObject.SetActive(false);
DescriptionOfQuest.gameObject.SetActive(true);
PatronNameOnBattleReport.text = patronCarryingReport.Name;
QuestTitle.text = questToReportOn.QuestName;
DescriptionOfQuest.text = questToReportOn.getPersonalResponceForQuest(patronCarryingReport.ID);
PatronBondLevelOnBattleReport.text = "Bond Level: " + patronCarryingReport.Level.ToString();
BattleReportRewardsList.text = listUnlockables();
BattleReportPatronTokenSummaryPage.sprite = ApperanceManager.instance.ThisPatronsToken(patronCarryingReport.ID);
}
private void FlipToLevelUp()
{
nextPageToTurnTo = ReportPages.SUMMARY;
DescriptionOfQuest.gameObject.SetActive(true);
QuestTitle.text = "Level Up";
DescriptionOfQuest.text = patronCarryingReport.Name + " has leveled up!";
if (patronCarryingReport.HasAnyMoreSkills())
{
Debug.Log("level up text hit");
DescriptionOfQuest.text += " \n They have gained the new attribute " + patronCarryingReport.PatronSkills[patronCarryingReport.Level - 1] + "!";
}
Director.RecordPatronLevelUp(patronCarryingReport);
}
public static void Run()
{
Report report = new Report(Json.Read("report\\example1.rrpt"));
report.Fill(new ReportDataSource(getDataTable()));
ReportPages pages = report.GetPages();
Printer printer = new Printer(pages);
// カスタマイズされたプレビュー画面を表示します
MyFmPrintPreview preview = new MyFmPrintPreview(printer);
preview.ShowDialog();
}
public static void Run()
{
Report report = new Report(Json.Read("report\\feature.rrpt"));
// "feature-4"にgetDataTable1-4をそれぞれ割り当てます
GroupDataProvider dataProvider = new GroupDataProvider();
dataProvider.GroupDataMap.Add("feature1", new ReportDataSource(getDataTable1()));
dataProvider.GroupDataMap.Add("feature2", new ReportDataSource(getDataTable2()));
dataProvider.GroupDataMap.Add("feature3", new ReportDataSource(getDataTable3()));
dataProvider.GroupDataMap.Add("feature4", new ReportDataSource(getDataTable4()));
// 第2引数にdataProviderを渡します
report.Fill(DummyDataSource.GetInstance(), dataProvider);
ReportPages pages = report.GetPages();
// PDF出力
using (FileStream fs = new FileStream("output\\feature.pdf", FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
}
// XLS出力
using (FileStream fs = new FileStream("output\\feature.xls", FileMode.Create))
{
HSSFWorkbook workbook = new HSSFWorkbook();
XlsRenderer renderer = new XlsRenderer(workbook);
renderer.NewSheet("feature");
pages.Render(renderer);
workbook.Write(fs);
}
// XLSX出力
using (FileStream fs = new FileStream("output\\feature.xlsx", FileMode.Create))
{
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook);
renderer.NewSheet("feature");
pages.Render(renderer);
workbook.Write(fs);
}
// プレビュー
{
FmPrintPreview preview = new FmPrintPreview(new Printer(pages));
preview.StartUpZoomFit = true;
preview.ShowDialog();
}
}
public static void Run()
{
// サブページを先に生成します
Report subReport = new Report(Json.Read("report\\example_subpage2.rrpt"));
subReport.Fill(new ReportDataSource(getDataTable()));
ReportPages subPages = subReport.GetPages();
Report report = new Report(Json.Read("report\\example_subpage1.rrpt"));
// 外枠帳票にサブページを登録します
report.AddSubPages("subpage", subPages);
// 外枠帳票の中でサブページが正しく割り当てられるようにSubPageDataSourceを渡します
report.Fill(new SubPageDataSource(subPages, "group1", "page1", "page2"));
ReportPages pages = report.GetPages();
// PDF出力
using (FileStream fs = new FileStream("output\\example_subpage.pdf", FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
}
// XLS出力
using (FileStream fs = new FileStream("output\\example_subpage.xls", FileMode.Create))
{
HSSFWorkbook workbook = new HSSFWorkbook();
XlsRenderer renderer = new XlsRenderer(workbook);
renderer.NewSheet("example_subpage");
pages.Render(renderer);
workbook.Write(fs);
}
// XLSX出力
using (FileStream fs = new FileStream("output\\example_subpage.xlsx", FileMode.Create))
{
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook);
renderer.NewSheet("example_subpage");
pages.Render(renderer);
workbook.Write(fs);
}
// プレビュー
{
FmPrintPreview preview = new FmPrintPreview(new Printer(pages));
preview.StartUpZoomFit = true;
preview.ShowDialog();
}
}
private void flipToReportPage()
{
PropsForReportPage.SetActive(true);
nextPageToTurnTo = ReportPages.SUMMARY;
//cashBond(questToReportOn.TrialsOfTheQuest);
nextPageButton.gameObject.SetActive(true);
QuestTitle.text = questToReportOn.QuestName;
DescriptionOfQuest.gameObject.SetActive(false);
AdventurerSkillList.text = patronCarryingReport.convertSkillsListToString();
QuestSkillCheckList.text = questToReportOn.convertChecksToString();
BattleReportPatronToken.sprite = ApperanceManager.instance.ThisPatronsToken(patronCarryingReport.ID);
checkIfBondSliderNeedsToMove();
DrinkSkill.text = patronCarryingReport.SkillGrantedByDrink.ToString();
}
public static void Run()
{
Report report = new Report(Json.Read("report\\example_dataprovider.rrpt"));
// "group_shohin"という識別子を持ったグループには、
// getShoninDataTableから得られるデータを割り当てます
GroupDataProvider dataProvider = new GroupDataProvider();
dataProvider.GroupDataMap.Add("group_shonin", new ReportDataSource(getShoninDataTable()));
// 第2引数にdataProviderを渡します
report.Fill(new ReportDataSource(getDataTable()), dataProvider);
ReportPages pages = report.GetPages();
// PDF出力
using (FileStream fs = new FileStream("output\\example_dataprovider.pdf", FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
}
// XLS出力
using (FileStream fs = new FileStream("output\\example_dataprovider.xls", FileMode.Create))
{
HSSFWorkbook workbook = new HSSFWorkbook();
XlsRenderer renderer = new XlsRenderer(workbook);
renderer.NewSheet("example_dataprovider");
pages.Render(renderer);
workbook.Write(fs);
}
// XLSX出力
using (FileStream fs = new FileStream("output\\example_dataprovider.xlsx", FileMode.Create))
{
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook);
renderer.NewSheet("example_dataprovider");
pages.Render(renderer);
workbook.Write(fs);
}
// プレビュー
{
FmPrintPreview preview = new FmPrintPreview(new Printer(pages));
preview.StartUpZoomFit = true;
preview.ShowDialog();
}
}
public override void PageAdded(Report report, ReportPages pages, ReportPage page)
{
// このメソッドはページが追加されるたびに呼ばれます
// 直前のページで"group_example"という識別子を持ったグループが終了しているかを調べます
Group g = page.FindFinishedGroup("group_example");
if (g != null)
{
// 直前に終了したグループのデータを用いて集計ページを作成し、挿入します
Report _report = new Report(this.reportDesign);
_report.Fill(g.Data);
pages.AddRange(_report.GetPages());
}
}
public static void Run()
{
// 差込みを行うコンテントを、あらかじめ共有コンテントへ登録しておきます
ReportDesign sharedReport = new ReportDesign(Json.Read("report/example_shared.rrpt"));
Report.AddSharedContent("company_info", sharedReport);
Report report = new Report(Json.Read("report\\example_mergecontent.rrpt"));
report.GlobalScope.Add("company_name", "株式会社ラピッドレポート");
report.GlobalScope.Add("tel", "0000-11-2222");
report.Fill(new ReportDataSource(getDataTable()));
ReportPages pages = report.GetPages();
// PDF出力
using (FileStream fs = new FileStream("output\\example_mergecontent.pdf", FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
}
// XLS出力
using (FileStream fs = new FileStream("output\\example_mergecontent.xls", FileMode.Create))
{
HSSFWorkbook workbook = new HSSFWorkbook();
XlsRenderer renderer = new XlsRenderer(workbook);
renderer.NewSheet("example_mergecontent");
pages.Render(renderer);
workbook.Write(fs);
}
// XLSX出力
using (FileStream fs = new FileStream("output\\example_mergecontent.xlsx", FileMode.Create))
{
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook);
renderer.NewSheet("example_mergecontent");
pages.Render(renderer);
workbook.Write(fs);
}
// プレビュー
{
FmPrintPreview preview = new FmPrintPreview(new Printer(pages));
preview.StartUpZoomFit = true;
preview.ShowDialog();
}
}
public void Run()
{
var name = "test_5_9_weekdayoperator";
Report report = new Report(jp.co.systembase.json.Json.Read(Path.Combine("rrpt", name + ".rrpt")));
report.Fill(new ReportDataSource(getDataTable()));
ReportPages pages = report.GetPages();
using (FileStream fs = new FileStream(Path.Combine("out", name + ".pdf"), FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
pages.Render(renderer);
}
}
public void Run()
{
var name = "test_5_14_pdfbarcode";
Report report = new Report(Json.Read(Path.Combine("rrpt", name + ".rrpt")));
report.Fill(DummyDataSource.GetInstance());
ReportPages pages = report.GetPages();
using (FileStream fs = new FileStream(Path.Combine("out", name + ".pdf"), FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
pages.Render(renderer);
}
}
public void Run()
{
var name = "test_5_13_unit";
Report report = new Report(Json.Read(Path.Combine("rrpt", name + ".rrpt")));
report.GlobalScope.Add("time", DateTime.Now);
report.GlobalScope.Add("lang", "core");
report.Fill(DummyDataSource.GetInstance());
ReportPages pages = report.GetPages();
{
var preview = new FmPrintPreview(new Printer(pages));
preview.ShowDialog();
}
}
public void Run()
{
var name = "test_0_6";
Report report = new Report(Json.Read(Path.Combine("rrpt", name + ".rrpt")));
report.Fill(DummyDataSource.GetInstance());
ReportPages pages = report.GetPages();
using (FileStream fs = new FileStream(Path.Combine("out", name + ".pdf"), FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
renderer.Setting.GaijiFont = BaseFont.CreateFont("font/eudc.ttf", BaseFont.IDENTITY_H, BaseFont.EMBEDDED);
renderer.Setting.GaijiFontMap.Add("gothic", BaseFont.CreateFont("font/msgothic.ttf", BaseFont.IDENTITY_H, BaseFont.EMBEDDED));
pages.Render(renderer);
}
}
public void Run()
{
var name = "test_5_10_backslash";
Report report = new Report(jp.co.systembase.json.Json.Read(Path.Combine("rrpt", name + ".rrpt")));
report.Fill(new ReportDataSource(getDataTable()));
ReportPages pages = report.GetPages();
using (FileStream fs = new FileStream(Path.Combine("out", name + ".pdf"), FileMode.Create))
{
PdfRendererSetting setting = new PdfRendererSetting();
setting.ReplaceBackslashToYen = true;
PdfRenderer renderer = new PdfRenderer(fs, setting);
pages.Render(renderer);
}
}
public void Run()
{
var name = "test_5_7_isnumeric";
Report report = new Report(Json.Read(Path.Combine("rrpt", name + ".rrpt")));
report.GlobalScope.Add("time", DateTime.Now);
report.GlobalScope.Add("lang", "core");
report.Fill(new ReportDataSource(_GetDataTable()));
ReportPages pages = report.GetPages();
using (FileStream fs = new FileStream(Path.Combine("out", name + ".pdf"), FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
pages.Render(renderer);
}
}
public static void Run()
{
// カスタマイザを指定せずに、Reportオブジェクトを生成します
Report report = new Report(Json.Read("report\\example_customize.rrpt"));
report.Fill(new ReportDataSource(getDataTable()));
ReportPages pages = report.GetPages();
// PDF出力
using (FileStream fs = new FileStream("output\\example_customize.pdf", FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
}
// XLS出力
using (FileStream fs = new FileStream("output\\example_customize.xls", FileMode.Create))
{
HSSFWorkbook workbook = new HSSFWorkbook();
XlsRenderer renderer = new XlsRenderer(workbook);
renderer.NewSheet("example_render");
pages.Render(renderer);
workbook.Write(fs);
}
// XLSX出力
using (FileStream fs = new FileStream("output\\example_customize.xlsx", FileMode.Create))
{
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook);
renderer.NewSheet("example_customize");
pages.Render(renderer);
workbook.Write(fs);
}
// プレビュー
{
FmPrintPreview preview = new FmPrintPreview(new Printer(pages));
preview.StartUpZoomFit = true;
preview.ShowDialog();
}
}
public static void Run()
{
// 帳票定義ファイルを読み込みます
Report report = new Report(Json.Read("report\\example1.rrpt"));
// 帳票にデータを渡します
report.Fill(new ReportDataSource(getDataTable()));
// ページ分割を行います
ReportPages pages = report.GetPages();
// PDF出力
using (FileStream fs = new FileStream("output\\example1.pdf", FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
// バックスラッシュ文字を円マーク文字に変換します
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
}
MessageBox.Show("PDFを出力しました");
}
public void Run()
{
var name = "test_0_5";
var sw = new Stopwatch();
sw.Start();
Report report = new Report(Json.Read(Path.Combine("rrpt", name + ".rrpt")));
report.Fill(new ReportDataSource(Test_0_5_Data.GetDataTable()));
ReportPages pages = report.GetPages();
using (FileStream fs = new FileStream(Path.Combine("out", name + ".pdf"), FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
pages.Render(renderer);
}
sw.Stop();
MessageBox.Show(sw.ElapsedMilliseconds.ToString());
}
public void Run()
{
var name = "test_0_1";
Report report = new Report(Json.Read(Path.Combine("rrpt", name + ".rrpt")));
report.GlobalScope.Add("time", DateTime.Now);
report.GlobalScope.Add("lang", "core");
report.Fill(DummyDataSource.GetInstance());
ReportPages pages = report.GetPages();
using (FileStream fs = new FileStream(Path.Combine("out", name + ".pdf"), FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
renderer.Setting.FontMap.Add("meiryo", BaseFont.CreateFont(
Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.Fonts), "meiryo.ttc,0"),
BaseFont.IDENTITY_H, BaseFont.EMBEDDED));
pages.Render(renderer);
}
using (FileStream fs = new FileStream(Path.Combine("out", name + ".xlsx"), FileMode.Create))
{
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook);
renderer.Setting.FontMap.Add("meiryo", "メイリオ");
renderer.NewSheet("sheet_name");
pages.Render(renderer);
workbook.Write(fs);
}
{
var printer = new Printer(pages);
printer.Setting.FontMap.Add("meiryo", "メイリオ");
var preview = new FmPrintPreview(printer);
preview.ShowDialog();
}
}
public static void Run(HttpServerUtility server, HttpResponse response)
{
// 帳票定義ファイルを読み込みます
Report report = new Report(Json.Read(server.MapPath("report\\example1.rrpt")));
// 帳票にデータを渡します
report.Fill(new ReportDataSource(getDataTable()));
// ページ分割を行います
ReportPages pages = report.GetPages();
// PDF出力
using (Stream _out = response.OutputStream)
{
PdfRenderer renderer = new PdfRenderer(_out);
// バックスラッシュ文字を円マーク文字に変換します
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
response.ContentType = "application/pdf";
response.AddHeader("Content-Disposition", "attachment;filename=example1.pdf");
response.End();
}
}
public static void Run()
{
// 帳票定義ファイルを読み込みます
Report report = new Report(Json.Read("report\\example1.rrpt"));
// CSVファイルから帳票にデータを渡します
using (StreamReader r = new StreamReader("report\\data.csv", Encoding.GetEncoding("shift-jis")))
{
report.Fill(new CsvDataSource(r));
}
// ページ分割を行います
ReportPages pages = report.GetPages();
// PDF出力
using (FileStream fs = new FileStream("output\\example1csv.pdf", FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
// バックスラッシュ文字を円マーク文字に変換します
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
}
// XLS出力
using (FileStream fs = new FileStream("output\\example1csv.xls", FileMode.Create))
{
HSSFWorkbook workbook = new HSSFWorkbook();
XlsRenderer renderer = new XlsRenderer(workbook);
// Renderメソッドを呼ぶ前に必ずNewSheetメソッドを呼んでワークシートを作成します
renderer.NewSheet("見積書");
pages.Render(renderer);
workbook.Write(fs);
}
// XLSX出力
using (FileStream fs = new FileStream("output\\example1csv.xlsx", FileMode.Create))
{
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook);
// Renderメソッドを呼ぶ前に必ずNewSheetメソッドを呼んでワークシートを作成します
renderer.NewSheet("見積書");
pages.Render(renderer);
workbook.Write(fs);
}
// 直接印刷、プレビュー画面表示
{
Printer printer = new Printer(pages);
//// 直接印刷
//// ダイアログを出して印刷します
//if (printer.PrintDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
//{
// printer.PrintDocument.Print();
//}
//// ダイアログを出さずに印刷します
//printer.PrintDocument.Print();
// プレビュー画面表示
FmPrintPreview preview = new FmPrintPreview(printer);
// プレビュー画面が開かれた時点で表示倍率を現在のウィンドウサイズに合わせます
preview.StartUpZoomFit = true;
preview.ShowDialog();
}
}
public static void Run()
{
// 郵便番号フォーマッタが設定されたSettingオブジェクトを用意します
ReportSetting setting = new ReportSetting();
setting.TextFormatterMap.Add("yubin", new YubinTextFormatter());
Report report = new Report(Json.Read("report\\example_extention.rrpt"), setting);
report.Fill(new ReportDataSource(getDataTable()));
ReportPages pages = report.GetPages();
// PDF出力
using (FileStream fs = new FileStream("output\\example_extention.pdf", FileMode.Create))
{
// チェックボックスレンダラが設定されたSettingオブジェクトを用意します
PdfRendererSetting pdfSetting = new PdfRendererSetting();
pdfSetting.ElementRendererMap.Add("checkbox", new PdfCheckBoxRenderer());
PdfRenderer renderer = new PdfRenderer(fs, pdfSetting);
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
}
// XLS出力
using (FileStream fs = new FileStream("output\\example_extention.xls", FileMode.Create))
{
// チェックボックスレンダラが設定されたSettingオブジェクトを用意します
XlsRendererSetting xlsSetting = new XlsRendererSetting();
xlsSetting.ElementRendererMap.Add("checkbox", new XlsCheckBoxRenderer());
HSSFWorkbook workbook = new HSSFWorkbook();
XlsRenderer renderer = new XlsRenderer(workbook, xlsSetting);
renderer.NewSheet("example_extention");
pages.Render(renderer);
workbook.Write(fs);
}
// XLSX出力
using (FileStream fs = new FileStream("output\\example_extention.xlsx", FileMode.Create))
{
// チェックボックスレンダラが設定されたSettingオブジェクトを用意します
XlsxRendererSetting xlsxSetting = new XlsxRendererSetting();
xlsxSetting.ElementRendererMap.Add("checkbox", new XlsxCheckBoxRenderer());
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook, xlsxSetting);
renderer.NewSheet("example_extention");
pages.Render(renderer);
workbook.Write(fs);
}
// プレビュー
{
// チェックボックスレンダラが設定されたSettingオブジェクトを用意します
GdiRendererSetting gdiSetting = new GdiRendererSetting();
gdiSetting.ElementRendererMap.Add("checkbox", new GdiCheckBoxRenderer());
FmPrintPreview preview = new FmPrintPreview(new Printer(pages, gdiSetting));
preview.StartUpZoomFit = true;
preview.ShowDialog();
}
}
public static void Run()
{
// 帳票定義ファイルを読み込みます
Report report = new Report(Json.Read("report\\example_image.rrpt"));
// 帳票にデータを渡します
report.Fill(new ReportDataSource(getDataTable()));
// ページ分割を行います
ReportPages pages = report.GetPages();
// イメージマップを生成します
ImageMap imageMap = getImageMap();
// PDF出力
using (FileStream fs = new FileStream("output\\example_image.pdf", FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
// イメージローダを登録します
renderer.ImageLoaderMap.Add("image", new PdfImageLoader(imageMap));
renderer.ImageLoaderMap.Add("graph", new PdfGraphImageLoader());
pages.Render(renderer);
}
// XLS出力
using (FileStream fs = new FileStream("output\\example_image.xls", FileMode.Create))
{
HSSFWorkbook workbook = new HSSFWorkbook();
XlsRenderer renderer = new XlsRenderer(workbook);
renderer.NewSheet("example_image");
// イメージローダを登録します
renderer.ImageLoaderMap.Add("image", new XlsImageLoader(imageMap));
renderer.ImageLoaderMap.Add("graph", new XlsGraphImageLoader());
pages.Render(renderer);
workbook.Write(fs);
}
// XLSX出力
using (FileStream fs = new FileStream("output\\example_image.xlsx", FileMode.Create))
{
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook);
renderer.NewSheet("example_image");
// イメージローダを登録します
renderer.ImageLoaderMap.Add("image", new XlsxImageLoader(imageMap));
renderer.ImageLoaderMap.Add("graph", new XlsxGraphImageLoader());
pages.Render(renderer);
workbook.Write(fs);
}
// プレビュー画面表示
{
Printer printer = new Printer(pages);
// イメージローダを登録します
printer.ImageLoaderMap.Add("image", new GdiImageLoader(imageMap));
printer.ImageLoaderMap.Add("graph", new GdiGraphImageLoader());
FmPrintPreview preview = new FmPrintPreview(printer);
preview.StartUpZoomFit = true;
preview.ShowDialog();
}
}
public override void PageAdded(Report report, ReportPages pages, ReportPage page)
{
// このメソッドはページが追加されるたびに呼ばれます
// 直前のページで"group_example"という識別子を持ったグループが終了しているかを調べます
Group g = page.FindFinishedGroup("group_example");
if (g != null)
{
// 直前に終了したグループのデータを用いて集計ページを作成し、挿入します
Report _report = new Report(this.reportDesign);
_report.Fill(g.Data);
pages.AddRange(_report.GetPages());
}
}
public static void Run()
{
// 帳票定義ファイルを読み込みます
Report report = new Report(Json.Read("report\\example2.rrpt"));
// GlobalScopeに値を登録します
report.GlobalScope.Add("startDate", DateTime.ParseExact("2013/02/01", "yyyy/MM/dd", null));
report.GlobalScope.Add("endDate", DateTime.ParseExact("2013/02/28", "yyyy/MM/dd", null));
report.GlobalScope.Add("printDate", DateTime.Today);
report.GlobalScope.Add("kaisha", "株式会社 システムベース");
// 帳票にデータを渡します
report.Fill(new ReportDataSource(getDataTable()));
// ページ分割を行います
ReportPages pages = report.GetPages();
// PDF出力
using (FileStream fs = new FileStream("output\\example2.pdf", FileMode.Create))
{
PdfRenderer renderer = new PdfRenderer(fs);
// バックスラッシュ文字を円マーク文字に変換します
renderer.Setting.ReplaceBackslashToYen = true;
pages.Render(renderer);
}
// XLS出力
using (FileStream fs = new FileStream("output\\example2.xls", FileMode.Create))
{
HSSFWorkbook workbook = new HSSFWorkbook();
XlsRenderer renderer = new XlsRenderer(workbook);
// Renderメソッドを呼ぶ前に必ずNewSheetメソッドを呼んでワークシートを作成します
renderer.NewSheet("売上明細表");
pages.Render(renderer);
workbook.Write(fs);
}
// XLSX出力
using (FileStream fs = new FileStream("output\\example2.xlsx", FileMode.Create))
{
XSSFWorkbook workbook = new XSSFWorkbook();
XlsxRenderer renderer = new XlsxRenderer(workbook);
// Renderメソッドを呼ぶ前に必ずNewSheetメソッドを呼んでワークシートを作成します
renderer.NewSheet("売上明細表");
pages.Render(renderer);
workbook.Write(fs);
}
// 直接印刷、プレビュー画面表示
{
Printer printer = new Printer(pages);
//// 直接印刷
//// ダイアログを出して印刷します
//if (printer.PrintDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
//{
// printer.PrintDocument.Print();
//}
//// ダイアログを出さずに印刷します
//printer.PrintDocument.Print();
// プレビュー画面表示
FmPrintPreview preview = new FmPrintPreview(printer);
// プレビュー画面が開かれた時点で表示倍率を現在のウィンドウサイズに合わせます
preview.StartUpZoomFit = true;
preview.ShowDialog();
}
}
