MVCxGridViewGeneratorHelper.cs 35 KB

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