MVCxGridViewGeneratorHelper.cs 35 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973
  1. using Autofac;
  2. using DevExpress.Data;
  3. using DevExpress.XtraEditors.Controls;
  4. using DevExpress.XtraPrinting;
  5. using DevExpress.XtraReports.UI;
  6. using GreenTree.Nachtragsmanagement.Core;
  7. using GreenTree.Nachtragsmanagement.Core.Authentication;
  8. using System;
  9. using System.Collections;
  10. using System.Collections.Generic;
  11. using System.Drawing;
  12. using System.IO;
  13. using System.Linq;
  14. using System.Net.Mime;
  15. using System.Text.RegularExpressions;
  16. using System.Web;
  17. namespace GreenTree.Nachtragsmanagement.Web.Extensions
  18. {
  19. public class MVCxGridViewGeneratorHelper
  20. {
  21. public delegate void CustomizeColumnsCollectionEventHandler(object source, ColumnsCreationEventArgs e);
  22. public delegate void CustomizeColumnEventHandler(object source, ControlCustomizationEventArgs e);
  23. public delegate void CustomizeFormattingRulesEventHandler(object source, CustomFormattingRulesEventArgs e);
  24. public delegate void CustomizeColumnTotalSummaryEventHandler(object source, ColumnSummaryCreationEventArgs e);
  25. public delegate void CustomizeColumnGroupSummaryEventHandler(object source, ColumnSummaryCreationEventArgs e);
  26. public delegate void SummaryResetEventHandler(object source, CustomSummaryResetEventArgs e);
  27. public delegate void SummaryRowChangedEventHandler(object source, CustomSummaryRowChangedEventArgs e);
  28. public class MVCReportGeneratonHelper
  29. {
  30. const int initialGroupOffset = 0;
  31. const int subGroupOffset = 10;
  32. const int detaillOffset = 15;
  33. const int bandHeight = 20;
  34. const bool shouldRepeatGroupHeadersOnEveryPage = false;
  35. XtraReport report;
  36. Hashtable detailsInfo = new Hashtable();
  37. Hashtable detailsWidth = new Hashtable();
  38. public event CustomizeColumnsCollectionEventHandler CustomizeColumnsCollection;
  39. public event CustomizeColumnEventHandler CustomizeColumn;
  40. public event CustomizeFormattingRulesEventHandler CustomizeFormattingRules;
  41. public event CustomizeColumnTotalSummaryEventHandler CustomizeTotalColumnSummary;
  42. public event CustomizeColumnGroupSummaryEventHandler CustomizeGroupColumnSummary;
  43. public event SummaryResetEventHandler SummaryReset;
  44. public event SummaryRowChangedEventHandler SummaryRowChanged;
  45. public event SummaryGetResultHandler PageSummaryGetResult;
  46. public event SummaryGetResultHandler TotalSummaryGetResult;
  47. public XtraReport GenerateMVCReport(MVCxGridViewState gridViewState, object model, string title)
  48. {
  49. report = new XtraReport
  50. {
  51. Font = new Font("Calibri", 10f, FontStyle.Regular),
  52. Landscape = true,
  53. PaperKind = System.Drawing.Printing.PaperKind.A4
  54. };
  55. InitStyles();
  56. InitReportTitle(title);
  57. InitDataSource(model);
  58. InitDetailsAndPageHeader(gridViewState);
  59. InitDetailReports(gridViewState);
  60. InitSortings(gridViewState);
  61. InitGroupHeaders(gridViewState);
  62. InitFilters(gridViewState);
  63. InitPageSummaries(gridViewState);
  64. InitTotalSummaries(gridViewState);
  65. InitPageFooter();
  66. return report;
  67. }
  68. private void InitStyles()
  69. {
  70. report.StyleSheet.Add(new XRControlStyle
  71. {
  72. Name = "Title",
  73. Borders = DevExpress.XtraPrinting.BorderSide.None,
  74. Font = new Font(report.Font.FontFamily, 24f, FontStyle.Regular),
  75. ForeColor = Color.FromArgb(35, 133, 160)
  76. });
  77. report.StyleSheet.Add(new XRControlStyle
  78. {
  79. Name = "OddRow",
  80. Borders = (DevExpress.XtraPrinting.BorderSide.Bottom |
  81. DevExpress.XtraPrinting.BorderSide.Left |
  82. DevExpress.XtraPrinting.BorderSide.Right),
  83. Padding = new PaddingInfo(30, 600)
  84. });
  85. report.StyleSheet.Add(new XRControlStyle
  86. {
  87. Name = "EvenRow",
  88. BackColor = Color.LightGray,
  89. Borders = (DevExpress.XtraPrinting.BorderSide.Bottom |
  90. DevExpress.XtraPrinting.BorderSide.Left |
  91. DevExpress.XtraPrinting.BorderSide.Right),
  92. Padding = new PaddingInfo(30, 600)
  93. });
  94. report.StyleSheet.Add(new XRControlStyle
  95. {
  96. Name = "HeaderRow",
  97. BackColor = Color.FromArgb(156, 183, 191),
  98. Borders = DevExpress.XtraPrinting.BorderSide.All,
  99. Padding = new PaddingInfo(30, 600),
  100. Font = new Font(report.Font, FontStyle.Bold)
  101. });
  102. report.StyleSheet.Add(new XRControlStyle
  103. {
  104. Name = "GroupHeader",
  105. BackColor = Color.Beige,
  106. Borders = DevExpress.XtraPrinting.BorderSide.All,
  107. Padding = new PaddingInfo(30, 600),
  108. Font = new Font(report.Font, FontStyle.Bold)
  109. });
  110. report.StyleSheet.Add(new XRControlStyle
  111. {
  112. Name = "SummaryRow",
  113. BackColor = Color.FromArgb(35, 133, 160),
  114. Borders = DevExpress.XtraPrinting.BorderSide.All,
  115. BorderColor = Color.FromArgb(35, 133, 160),
  116. Padding = new PaddingInfo(30, 600),
  117. ForeColor = Color.White,
  118. Font = new Font(report.Font, FontStyle.Bold)
  119. });
  120. report.StyleSheet.Add(new XRControlStyle
  121. {
  122. Name = "DetailRowTable",
  123. Borders = DevExpress.XtraPrinting.BorderSide.All
  124. });
  125. report.StyleSheet.Add(new XRControlStyle
  126. {
  127. Name = "DetailRow",
  128. BackColor = Color.FromArgb(209, 228, 255),
  129. Borders = DevExpress.XtraPrinting.BorderSide.None
  130. });
  131. report.StyleSheet.Add(new XRControlStyle
  132. {
  133. Name = "DetailRowCell",
  134. Borders = DevExpress.XtraPrinting.BorderSide.All
  135. });
  136. report.StyleSheet.Add(new XRControlStyle
  137. {
  138. Name = "DetailRowLabel",
  139. Padding = new PaddingInfo(30, 600),
  140. Borders = DevExpress.XtraPrinting.BorderSide.None
  141. });
  142. report.StyleSheet.Add(new XRControlStyle
  143. {
  144. Name = "FooterRow",
  145. Font = new Font(report.Font, FontStyle.Italic)
  146. });
  147. }
  148. private void InitReportTitle(string title)
  149. {
  150. report.Bands.Add(new ReportHeaderBand
  151. {
  152. HeightF = 32f
  153. });
  154. report.Bands[BandKind.ReportHeader].Controls.Add(new XRLabel
  155. {
  156. Text = title,
  157. StyleName = "Title",
  158. WidthF = (report.PageWidth - (report.Margins.Left + report.Margins.Right))
  159. });
  160. }
  161. private void InitDataSource(object model)
  162. {
  163. report.DataSource = model;
  164. }
  165. private void InitDetailsAndPageHeader(MVCxGridViewState gridViewState)
  166. {
  167. var groupedColumns = gridViewState.GroupedColumns;
  168. var pagewidth = (report.PageWidth - (report.Margins.Left + report.Margins.Right)) - groupedColumns.Count * subGroupOffset;
  169. var columns = GetColumnsInfo(gridViewState, pagewidth);
  170. if (CustomizeColumnsCollection != null)
  171. CustomizeColumnsCollection(report, new ColumnsCreationEventArgs(pagewidth)
  172. {
  173. ColumnsInfo = columns
  174. });
  175. report.Bands.Add(new DetailBand()
  176. {
  177. HeightF = bandHeight,
  178. KeepTogetherWithDetailReports = true
  179. });
  180. report.Bands.Add(new PageHeaderBand()
  181. {
  182. HeightF = bandHeight
  183. });
  184. var headerTable = new XRTable()
  185. {
  186. StyleName = "HeaderRow"
  187. };
  188. var row = new XRTableRow();
  189. var detailTable = new XRTable
  190. {
  191. OddStyleName = "OddRow",
  192. EvenStyleName = "EvenRow"
  193. };
  194. var row2 = new XRTableRow();
  195. for (var i = 0; i < columns.Count; i++)
  196. {
  197. if (columns[i].IsVisible)
  198. {
  199. var cell = new XRTableCell
  200. {
  201. Width = columns[i].ColumnWidth,
  202. Text = columns[i].GridViewColumn.Caption,
  203. Borders = DevExpress.XtraPrinting.BorderSide.All,
  204. TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft
  205. };
  206. row.Cells.Add(cell);
  207. var cell2 = new XRTableCell
  208. {
  209. Width = columns[i].ColumnWidth
  210. };
  211. var cc = new ControlCustomizationEventArgs
  212. {
  213. FieldName = columns[i].FieldName,
  214. IsModified = false,
  215. Owner = cell2,
  216. Header = cell
  217. };
  218. if (CustomizeColumn != null)
  219. CustomizeColumn(report, cc);
  220. if (cc.IsModified == false)
  221. {
  222. cell2.DataBindings.Add("Text", null, columns[i].FieldName,
  223. "{0:" + columns[i].GridViewColumn.DisplayFormat + "}");
  224. }
  225. detailsInfo.Add(columns[i].GridViewColumn, cell2);
  226. row2.Cells.Add(cell2);
  227. detailsWidth.Add(columns[i].GridViewColumn, cell2.WidthF);
  228. }
  229. }
  230. if (CustomizeFormattingRules != null)
  231. CustomizeFormattingRules(report, new CustomFormattingRulesEventArgs { Rules = report.FormattingRuleSheet });
  232. foreach (var rule in report.FormattingRuleSheet)
  233. detailTable.FormattingRules.Add(rule);
  234. headerTable.Rows.Add(row);
  235. headerTable.Width = pagewidth;
  236. headerTable.LocationF = new PointF(groupedColumns.Count * subGroupOffset, 0);
  237. headerTable.Borders = DevExpress.XtraPrinting.BorderSide.Bottom;
  238. detailTable.Rows.Add(row2);
  239. detailTable.LocationF = new PointF(groupedColumns.Count * subGroupOffset, 0);
  240. detailTable.Width = pagewidth;
  241. report.Bands[BandKind.PageHeader].Controls.Add(headerTable);
  242. report.Bands[BandKind.Detail].Controls.Add(detailTable);
  243. }
  244. private void InitDetailReports(MVCxGridViewState gridViewState)
  245. {
  246. var groupedColumns = gridViewState.GroupedColumns;
  247. var pagewidth = (report.PageWidth - (report.Margins.Left + report.Margins.Right)) - groupedColumns.Count * subGroupOffset - detaillOffset;
  248. var columns = GetColumnsInfo(gridViewState, pagewidth);
  249. if (CustomizeColumnsCollection != null)
  250. CustomizeColumnsCollection(report, new ColumnsCreationEventArgs(pagewidth)
  251. {
  252. ColumnsInfo = columns
  253. });
  254. var detailColumns = columns
  255. .Where(c => c.IsDetail)
  256. .ToList();
  257. if (!detailColumns.Any()) return;
  258. var detailReportBand = new DetailReportBand()
  259. {
  260. HeightF = bandHeight
  261. };
  262. report.Bands.Add(detailReportBand);
  263. var detailReportTable = new XRTable
  264. {
  265. StyleName = "DetailRowTable",
  266. OddStyleName = "DetailRow",
  267. EvenStyleName = "DetailRow",
  268. WidthF = pagewidth
  269. };
  270. var detailReportRow = new XRTableRow();
  271. foreach (var detailColumn in detailColumns)
  272. {
  273. var cellDetail = new XRTableCell
  274. {
  275. WidthF = pagewidth / detailColumns.Count,
  276. StyleName = "DetailRowCell"
  277. };
  278. var label = new XRLabel
  279. {
  280. StyleName = "DetailRowLabel",
  281. WidthF = pagewidth / detailColumns.Count,
  282. WordWrap = true,
  283. Multiline = true
  284. };
  285. label.DataBindings.Add("Text", null, detailColumn.FieldName,
  286. detailColumn.ColumnCaption + ":\n{0:" + detailColumn.GridViewColumn.DisplayFormat + "}");
  287. cellDetail.Controls.Add(label);
  288. detailReportRow.Cells.Add(cellDetail);
  289. }
  290. detailReportTable.Rows.Add(detailReportRow);
  291. detailReportTable.LocationF = new PointF(groupedColumns.Count * subGroupOffset + detaillOffset, 0);
  292. DetailBand detailBand = new DetailBand();
  293. detailBand.Height = detailReportTable.Height;
  294. detailReportBand.Bands.Add(detailBand);
  295. detailBand.Controls.Add(detailReportTable);
  296. }
  297. private void InitSortings(MVCxGridViewState gridViewState)
  298. {
  299. var columns = gridViewState.Columns;
  300. var groupedColumns = gridViewState.GroupedColumns;
  301. for (var i = 0; i < columns.Count; i++)
  302. {
  303. if (!groupedColumns.Contains(columns[i]))
  304. {
  305. if (columns[i].FieldName == "CustomNumber")
  306. {
  307. ((DetailBand)report.Bands[BandKind.Detail]).SortFields.Add(new GroupField("CustomNumberSort", columns[i].SortOrder == ColumnSortOrder.Ascending ? XRColumnSortOrder.Ascending : XRColumnSortOrder.Descending));
  308. }
  309. else if (columns[i].SortOrder != ColumnSortOrder.None)
  310. {
  311. ((DetailBand)report.Bands[BandKind.Detail]).SortFields.Add(new GroupField(columns[i].FieldName, columns[i].SortOrder == ColumnSortOrder.Ascending ? XRColumnSortOrder.Ascending : XRColumnSortOrder.Descending));
  312. }
  313. }
  314. }
  315. }
  316. private void InitGroupHeaders(MVCxGridViewState gridViewState)
  317. {
  318. var groupedColumns = gridViewState.GroupedColumns;
  319. for (var i = groupedColumns.Count - 1; i >= 0; i--)
  320. {
  321. var groupedColumn = groupedColumns[i];
  322. var gb = new GroupHeaderBand
  323. {
  324. Height = bandHeight
  325. };
  326. var groupHeaderTable = new XRTable
  327. {
  328. StyleName = "GroupHeader",
  329. LocationF = new PointF(initialGroupOffset + i * 10, 0),
  330. SizeF = new SizeF((report.PageWidth - (report.Margins.Left + report.Margins.Right)) - (initialGroupOffset + i * subGroupOffset), bandHeight)
  331. };
  332. var groupHeaderRow = new XRTableRow();
  333. var l = new XRTableCell
  334. {
  335. Text = groupedColumn.Caption + ": [" + groupedColumn.FieldName + "]",
  336. Borders = DevExpress.XtraPrinting.BorderSide.Left |
  337. DevExpress.XtraPrinting.BorderSide.Top |
  338. DevExpress.XtraPrinting.BorderSide.Bottom
  339. };
  340. groupHeaderRow.Cells.Add(l);
  341. foreach (MVCxSummaryItemState item in gridViewState.TotalSummary)
  342. {
  343. var sum = new XRTableCell
  344. {
  345. Borders = DevExpress.XtraPrinting.BorderSide.Top |
  346. DevExpress.XtraPrinting.BorderSide.Bottom
  347. };
  348. sum.Summary = new XRSummary
  349. {
  350. Running = SummaryRunning.Group
  351. };
  352. sum.Summary.Func = GetSummaryFunc(item.SummaryType);
  353. sum.DataBindings.Add("Text", null, item.FieldName);
  354. groupHeaderRow.Cells.Add(sum);
  355. if (CustomizeGroupColumnSummary != null)
  356. CustomizeGroupColumnSummary(report, new ColumnSummaryCreationEventArgs(item.FieldName, sum.Summary));
  357. }
  358. groupHeaderTable.Rows.Add(groupHeaderRow);
  359. gb.Controls.Add(groupHeaderTable);
  360. gb.RepeatEveryPage = shouldRepeatGroupHeadersOnEveryPage;
  361. var gf = new GroupField(
  362. groupedColumn.FieldName, groupedColumn.SortOrder == ColumnSortOrder.Ascending
  363. ? XRColumnSortOrder.Ascending
  364. : XRColumnSortOrder.Descending);
  365. gb.GroupFields.Add(gf);
  366. report.Bands.Add(gb);
  367. }
  368. }
  369. private void InitFilters(MVCxGridViewState gridViewState)
  370. {
  371. report.FilterString = gridViewState.FilterExpression;
  372. }
  373. private void InitPageSummaries(MVCxGridViewState gridViewState)
  374. {
  375. if (gridViewState.TotalSummary.Count == 0) return;
  376. report.Bands.Add(new PageFooterBand
  377. {
  378. HeightF = bandHeight,
  379. StyleName = "SummaryRow",
  380. PrintOn = PrintOnPages.NotWithReportFooter
  381. });
  382. foreach (MVCxSummaryItemState item in gridViewState.TotalSummary)
  383. {
  384. var col = gridViewState.Columns[item.ShowInColumn == string.Empty
  385. ? item.FieldName
  386. : item.ShowInColumn];
  387. if (col == null) continue;
  388. if (!detailsInfo.Contains(col)) continue;
  389. var label = new XRLabel
  390. {
  391. LocationF = new PointF(
  392. ((XRTableCell)detailsInfo[col]).LocationF.X + subGroupOffset * gridViewState.GroupedColumns.Count,
  393. ((XRTableCell)detailsInfo[col]).LocationF.Y),
  394. SizeF = ((XRTableCell)detailsInfo[col]).SizeF
  395. };
  396. label.Summary = new XRSummary
  397. {
  398. Running = SummaryRunning.Page
  399. };
  400. label.Summary.FormatString = item.DisplayFormat;
  401. label.Summary.Func = GetSummaryFunc(item.SummaryType);
  402. label.DataBindings.Add("Text", null, col.FieldName);
  403. label.Tag = item.FieldName;
  404. if (PageSummaryGetResult != null)
  405. label.SummaryGetResult += PageSummaryGetResult;
  406. report.Bands[BandKind.PageFooter].Controls.Add(label);
  407. if (CustomizeTotalColumnSummary != null)
  408. CustomizeTotalColumnSummary(report, new ColumnSummaryCreationEventArgs(col.FieldName, label.Summary));
  409. }
  410. }
  411. private void InitTotalSummaries(MVCxGridViewState gridViewState)
  412. {
  413. if (gridViewState.TotalSummary.Count == 0) return;
  414. report.Bands.Add(new ReportFooterBand
  415. {
  416. HeightF = bandHeight,
  417. StyleName = "SummaryRow"
  418. });
  419. foreach (MVCxSummaryItemState item in gridViewState.TotalSummary)
  420. {
  421. var col = gridViewState.Columns[item.ShowInColumn == string.Empty
  422. ? item.FieldName
  423. : item.ShowInColumn];
  424. if (col == null) continue;
  425. if (!detailsInfo.Contains(col)) continue;
  426. var label = new XRLabel
  427. {
  428. LocationF = new PointF(
  429. ((XRTableCell)detailsInfo[col]).LocationF.X + subGroupOffset * gridViewState.GroupedColumns.Count,
  430. ((XRTableCell)detailsInfo[col]).LocationF.Y),
  431. SizeF = ((XRTableCell)detailsInfo[col]).SizeF
  432. };
  433. label.DataBindings.Add("Text", null, col.FieldName);
  434. label.Summary = new XRSummary
  435. {
  436. Running = SummaryRunning.Report
  437. };
  438. label.Summary.FormatString = item.DisplayFormat;
  439. label.Summary.Func = GetSummaryFunc(item.SummaryType);
  440. label.Tag = item.FieldName;
  441. if (item.SummaryType == SummaryItemType.Custom)
  442. {
  443. label.SummaryReset += (source, e) =>
  444. {
  445. if (SummaryReset != null)
  446. SummaryReset(report, new CustomSummaryResetEventArgs { FieldName = item.FieldName });
  447. };
  448. label.SummaryRowChanged += (source, e) =>
  449. {
  450. if (SummaryRowChanged != null)
  451. SummaryRowChanged(report, new CustomSummaryRowChangedEventArgs { FieldName = item.FieldName });
  452. };
  453. }
  454. if (TotalSummaryGetResult != null)
  455. label.SummaryGetResult += TotalSummaryGetResult;
  456. report.Bands[BandKind.ReportFooter].Controls.Add(label);
  457. if (CustomizeTotalColumnSummary != null)
  458. CustomizeTotalColumnSummary(report, new ColumnSummaryCreationEventArgs(col.FieldName, label.Summary));
  459. }
  460. }
  461. private void InitPageFooter()
  462. {
  463. var userHelper = Singleton<IContainer>.Instance.Resolve<IUserHelper>();
  464. var user = userHelper.FromCookiesOrSession();
  465. report.Bands.Add(new BottomMarginBand
  466. {
  467. HeightF = 46f
  468. });
  469. var footerTable = new XRTable
  470. {
  471. WidthF = (report.PageWidth - (report.Margins.Left + report.Margins.Right)),
  472. HeightF = 23f,
  473. Borders = DevExpress.XtraPrinting.BorderSide.Top,
  474. StyleName = "FooterRow"
  475. };
  476. var footerRow = new XRTableRow
  477. {
  478. Cells =
  479. {
  480. new XRTableCell
  481. {
  482. TextAlignment = TextAlignment.MiddleLeft,
  483. Text = DateTime.Now.ToString("dd.MM.yyyy - HH:mm \"Uhr\" |"),
  484. WidthF = 145f,
  485. HeightF = 23f
  486. },
  487. new XRTableCell
  488. {
  489. Controls =
  490. {
  491. new XRPageInfo
  492. {
  493. TextAlignment = TextAlignment.MiddleLeft,
  494. Format = "Seite {0} von {1}",
  495. PageInfo = PageInfo.NumberOfTotal,
  496. StartPageNumber = 1,
  497. Padding = 5,
  498. HeightF = 23f
  499. }
  500. },
  501. WidthF = 100f,
  502. HeightF = 23f
  503. },
  504. new XRTableCell
  505. {
  506. TextAlignment = TextAlignment.MiddleRight,
  507. Text = String.Format("{0}, {1}", user.Lastname, user.Forename),
  508. WidthF = (report.PageWidth - (report.Margins.Left + report.Margins.Right)) - 230
  509. }
  510. }
  511. };
  512. footerTable.Rows.Add(footerRow);
  513. report.Bands[BandKind.BottomMargin].Controls.Add(footerTable);
  514. }
  515. private List<MVCxColumnInfo> GetColumnsInfo(MVCxGridViewState gridViewState, int pagewidth)
  516. {
  517. var columns = new List<MVCxColumnInfo>();
  518. var visibleColumns = gridViewState.Columns;
  519. foreach (var dataColumn in visibleColumns)
  520. {
  521. MVCxColumnInfo column = new MVCxColumnInfo(dataColumn)
  522. {
  523. ColumnCaption = string.IsNullOrEmpty(dataColumn.Caption) ? dataColumn.FieldName : dataColumn.Caption,
  524. ColumnWidth = ((int)pagewidth / visibleColumns.Count),
  525. FieldName = dataColumn.FieldName,
  526. IsVisible = true
  527. };
  528. columns.Add(column);
  529. }
  530. return columns;
  531. }
  532. private SummaryFunc GetSummaryFunc(SummaryItemType summaryItemType)
  533. {
  534. switch (summaryItemType)
  535. {
  536. case SummaryItemType.Sum:
  537. return SummaryFunc.Sum;
  538. case SummaryItemType.Average:
  539. return SummaryFunc.Avg;
  540. case SummaryItemType.Max:
  541. return SummaryFunc.Max;
  542. case SummaryItemType.Min:
  543. return SummaryFunc.Min;
  544. case SummaryItemType.Count:
  545. return SummaryFunc.Count;
  546. default:
  547. return SummaryFunc.Custom;
  548. }
  549. }
  550. public void WritePdfToResponse(HttpResponseBase Response, string fileName, string type)
  551. {
  552. report.CreateDocument(false);
  553. using (MemoryStream ms = new MemoryStream())
  554. {
  555. report.ExportToPdf(ms);
  556. ms.Seek(0, SeekOrigin.Begin);
  557. WriteResponse(Response, ms.ToArray(), "application/pdf", type, fileName);
  558. }
  559. }
  560. public void WriteXlsToResponse(HttpResponseBase Response, string fileName, string type)
  561. {
  562. report.CreateDocument(false);
  563. using (MemoryStream ms = new MemoryStream())
  564. {
  565. report.ExportToXls(ms);
  566. ms.Seek(0, SeekOrigin.Begin);
  567. WriteResponse(Response, ms.ToArray(), "application/vnd.ms-excel", type, fileName);
  568. }
  569. }
  570. public void WriteXlsxToResponse(HttpResponseBase Response, string fileName, string type)
  571. {
  572. report.CreateDocument(false);
  573. using (MemoryStream ms = new MemoryStream())
  574. {
  575. report.ExportToXlsx(ms);
  576. ms.Seek(0, SeekOrigin.Begin);
  577. WriteResponse(Response, ms.ToArray(), "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", type, fileName);
  578. }
  579. }
  580. public static void WriteResponse(HttpResponseBase response, byte[] filearray, string contentType, string type, string fileName)
  581. {
  582. response.ClearContent();
  583. response.Buffer = true;
  584. response.Cache.SetCacheability(HttpCacheability.Private);
  585. response.ContentType = contentType;
  586. ContentDisposition contentDisposition = new ContentDisposition();
  587. contentDisposition.FileName = fileName;
  588. contentDisposition.DispositionType = type;
  589. response.AddHeader("Content-Disposition", contentDisposition.ToString());
  590. response.BinaryWrite(filearray);
  591. HttpContext.Current.ApplicationInstance.CompleteRequest();
  592. try
  593. {
  594. response.End();
  595. }
  596. catch (System.Threading.ThreadAbortException)
  597. {
  598. }
  599. }
  600. }
  601. public class CustomFormattingRulesEventArgs : EventArgs
  602. {
  603. private FormattingRuleSheet rules;
  604. public FormattingRuleSheet Rules
  605. {
  606. get { return rules; }
  607. set { rules = value; }
  608. }
  609. }
  610. public class ControlCustomizationEventArgs : EventArgs
  611. {
  612. XRControl owner;
  613. public XRControl Owner
  614. {
  615. get
  616. {
  617. return owner;
  618. }
  619. set
  620. {
  621. owner = value;
  622. }
  623. }
  624. XRControl header;
  625. public XRControl Header
  626. {
  627. get
  628. {
  629. return header;
  630. }
  631. set
  632. {
  633. header = value;
  634. }
  635. }
  636. bool isModified;
  637. public bool IsModified
  638. {
  639. get
  640. {
  641. return isModified;
  642. }
  643. set
  644. {
  645. isModified = value;
  646. }
  647. }
  648. string fieldName;
  649. public string FieldName
  650. {
  651. get
  652. {
  653. return fieldName;
  654. }
  655. set
  656. {
  657. fieldName = value;
  658. }
  659. }
  660. }
  661. public class ColumnSummaryCreationEventArgs : EventArgs
  662. {
  663. public ColumnSummaryCreationEventArgs(string fieldName, XRSummary summary)
  664. {
  665. this.fieldName = fieldName;
  666. this.summary = summary;
  667. }
  668. XRSummary summary;
  669. public XRSummary Summary
  670. {
  671. get
  672. {
  673. return summary;
  674. }
  675. set
  676. {
  677. summary = value;
  678. }
  679. }
  680. string fieldName;
  681. public string FieldName
  682. {
  683. get
  684. {
  685. return fieldName;
  686. }
  687. set
  688. {
  689. fieldName = value;
  690. }
  691. }
  692. }
  693. public class ColumnsCreationEventArgs : EventArgs
  694. {
  695. int pageWidth;
  696. public int PageWidth
  697. {
  698. get
  699. {
  700. return pageWidth;
  701. }
  702. }
  703. public ColumnsCreationEventArgs(int pageWidth)
  704. {
  705. this.pageWidth = pageWidth;
  706. }
  707. List<MVCxColumnInfo> columnsInfo;
  708. public List<MVCxColumnInfo> ColumnsInfo
  709. {
  710. get
  711. {
  712. return columnsInfo;
  713. }
  714. set
  715. {
  716. columnsInfo = value;
  717. }
  718. }
  719. }
  720. public class CustomSummaryResetEventArgs : EventArgs
  721. {
  722. private string fieldName;
  723. public string FieldName
  724. {
  725. get { return fieldName; }
  726. set { fieldName = value; }
  727. }
  728. }
  729. public class CustomSummaryRowChangedEventArgs : EventArgs
  730. {
  731. private string fieldName;
  732. public string FieldName
  733. {
  734. get { return fieldName; }
  735. set { fieldName = value; }
  736. }
  737. }
  738. public class CustomSummaryGetResultEventArgs : SummaryGetResultEventArgs
  739. {
  740. public CustomSummaryGetResultEventArgs(IList calculatedValues) : base(calculatedValues)
  741. {
  742. }
  743. private string fieldName;
  744. public string FieldName
  745. {
  746. get { return fieldName; }
  747. set { fieldName = value; }
  748. }
  749. private XRControl control;
  750. public XRControl Control
  751. {
  752. get { return control; }
  753. set { control = value; }
  754. }
  755. }
  756. public class MVCxColumnInfo
  757. {
  758. public MVCxColumnInfo(GridViewDataColumnState gridViewColumn)
  759. {
  760. this.gridViewColumn = gridViewColumn;
  761. }
  762. GridViewDataColumnState gridViewColumn;
  763. public GridViewDataColumnState GridViewColumn
  764. {
  765. get
  766. {
  767. return gridViewColumn;
  768. }
  769. }
  770. string columnCaption;
  771. public string ColumnCaption
  772. {
  773. get
  774. {
  775. return columnCaption;
  776. }
  777. set
  778. {
  779. columnCaption = value;
  780. }
  781. }
  782. string fieldName;
  783. public string FieldName
  784. {
  785. get
  786. {
  787. return fieldName;
  788. }
  789. set
  790. {
  791. fieldName = value;
  792. }
  793. }
  794. int columnWidth;
  795. public int ColumnWidth
  796. {
  797. get
  798. {
  799. return columnWidth;
  800. }
  801. set
  802. {
  803. columnWidth = value;
  804. }
  805. }
  806. bool isVisible;
  807. public bool IsVisible
  808. {
  809. get
  810. {
  811. return isVisible;
  812. }
  813. set
  814. {
  815. isVisible = value;
  816. }
  817. }
  818. bool isDetail;
  819. public bool IsDetail
  820. {
  821. get
  822. {
  823. return isDetail;
  824. }
  825. set
  826. {
  827. isDetail = value;
  828. }
  829. }
  830. }
  831. }
  832. }