123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429 |
- using DevExpress.XtraReports.UI;
- using iBemsDataService.Controllers;
- using System;
- using System.Collections.Generic;
- using System.Diagnostics;
- using System.Drawing;
- using System.Linq;
- using System.Net;
- using System.Reflection;
- using System.Web;
- namespace iBemsDataService.Util
- {
- public class ReportTableHandler
- {
- public static XRTable CreateTableFromEnergyWithWidth<T>(List<T> list, float[] columnWidth)
- {
- XRTable table = CreateTableFromEnergy(list);
- AdjustTextSizeEnergy(table, columnWidth);
- return table;
- }
- public static XRTable CreateTableFromEnergy<T>(List<T> list)
- {
- XRTable table = new XRTable();
- table.LocationF = new PointF(0, 0);
- table.Font = new System.Drawing.Font("맑은 고딕", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
- table.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleRight;
- List<XRTableRow> rowListtop = ConvertEnergyToTableRowstop(list);
- for (var i = 0; i < rowListtop.Count; i++)
- {
- table.Rows.Add(rowListtop[i]);
- }
- table.AdjustSize();
- table.EndInit();
- table.WidthF = 839f;
- return table;
- }
- private static List<XRTableRow> ConvertEnergyToTableRowstop<T>(List<T> list)
- {
- List<XRTableRow> rowList = new List<XRTableRow>();
- String[] Text = { "TextResultDate", "TextResult" };
- Type type = typeof(T);
- foreach (T item in list)
- {
- XRTableRow newRow = MakeXrTableRowTemplate();
- foreach (PropertyInfo propertyInfo in type.GetProperties())
- {
- var obj = propertyInfo.GetValue(item);
- String cellText = "";
- bool colorchekck = false;
- if (propertyInfo.Name.ToString() == "Name")
- {
- if (obj != null)
- {
- cellText = (String)obj;
- if (cellText.IndexOf("합계") != -1)
- {
- colorchekck = true;
- }
- }
- }
- else if (propertyInfo.Name.ToString() == "Today")
- {
- if (obj != null)
- {
- cellText = obj.ToString();
- }
- }
- else if (propertyInfo.Name.ToString() == "Daybefore")
- {
- if (obj != null)
- {
- cellText = obj.ToString();
- }
- }
- else if (propertyInfo.Name.ToString() == "Dailyusage")
- {
- if (obj != null)
- {
- cellText = obj.ToString();
- }
- }
- else
- {
- if (obj != null)
- {
- cellText = obj.ToString();
- }
- }
- XRTableCell newcell = new XRTableCell();
- newcell.Text = cellText;
- if (propertyInfo.Name.ToString() == "Name")
- {
- newcell.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- }
- newRow.Cells.Add(newcell);
- if (colorchekck)
- {
- newRow.BackColor = Color.FromArgb(255, 255, 204);
- colorchekck = false;
- }
- }
- rowList.Add(newRow);
- }
- return rowList;
- }
- public static XRTable CreateTableFromListWithColumnWidth<T>(List<T> list, float[] columnWidth, String[] exceptions = null)
- {
- XRTable table = CreateTableFromList(list, exceptions);
- AdjustTextSize(table, columnWidth);
- return table;
- }
- public static XRTable CreateTableFromListWithColumnWidthPatrol<T>(List<T> list, float[] columnWidth, String[] exceptions = null)
- {
- XRTable table = CreateTableFromListPatrol(list, exceptions);
- AdjustTextSizePatrol(table, columnWidth);
- return table;
- }
- public static XRTable CreateTableFromList<T>(List<T> list, String[] exceptions = null)
- {
- XRTable table = new XRTable();
- table.LocationF = new PointF(0, 0);
- table.Font = new System.Drawing.Font("맑은 고딕", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
- table.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- table.BeginInit();
- List<XRTableRow> rowListtop = ConvertListToTableRowstop(list, exceptions);
- List<XRTableRow> rowListbottom = ConvertListToTableRowsbottom(list, exceptions);
- for (var i = 0; i < rowListtop.Count; i++)
- {
- table.Rows.Add(rowListtop[i]);
- table.Rows.Add(rowListbottom[i]);
- }
- for (var i = 1; i < rowListtop.Count * 2; i += 2)
- {
- table.Rows[i].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
- }
- table.AdjustSize();
- table.EndInit();
- table.WidthF = 839f;
- return table;
- }
- public static XRTable CreateTableFromListPatrol<T>(List<T> list, String[] exceptions = null)
- {
- XRTable table = new XRTable();
- table.LocationF = new PointF(0, 0);
- table.Font = new System.Drawing.Font("맑은 고딕", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
- table.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- table.BeginInit();
- List<XRTableRow> rowListtop = ConvertListToTableRowstop(list, exceptions);
- List<XRTableRow> rowListbottom = ConvertListToTableRowsbottom(list, exceptions);
- for (var i = 0; i < rowListtop.Count; i++)
- {
- table.Rows.Add(rowListtop[i]);
- //table.Rows.Add(rowListbottom[i]);
- }
- //for (var i = 1; i < rowListtop.Count; i += 2)
- //{
- // table.Rows[i].TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleLeft;
- //}
- table.AdjustSize();
- table.EndInit();
- table.WidthF = 800f;
- return table;
- }
- public static XRTable CreateTableFromListWithColumnWidthMaterial<T>(List<T> list, float[] columnWidth, String[] exceptions = null)
- {
- XRTable table = CreateTableFromListMaterial(list, exceptions);
- AdjustTextSize(table, columnWidth);
- return table;
- }
- public static XRTable CreateTableFromListMaterial<T>(List<T> list, String[] exceptions = null)
- {
- XRTable table = new XRTable();
- table.LocationF = new PointF(0, 0);
- table.Font = new System.Drawing.Font("맑은 고딕", 11.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
- table.TextAlignment = DevExpress.XtraPrinting.TextAlignment.MiddleCenter;
- table.BeginInit();
- List<XRTableRow> rowListtop = ConvertListToTableRowstop(list, exceptions);
- for (var i = 0; i < rowListtop.Count; i++)
- {
- table.Rows.Add(rowListtop[i]);
- }
- table.AdjustSize();
- table.EndInit();
- table.WidthF = 839f;
- return table;
- }
- private static void AdjustTextSize(XRTable table, float[] columnWidth)
- {
- float[] columnWidthbottom = { 230f, 609f, 839f };
- foreach (XRTableRow row in table.Rows)
- {
- for (int i = 0; i < row.Cells.Count; i++)
- {
- if (row.Cells.Count > 2)
- {
- XRTableCell cell = row.Cells[i];
- if (columnWidth != null)
- {
- cell.SizeF = new SizeF(columnWidth[i], cell.SizeF.Height);
- }
- }
- else
- {
- XRTableCell cell = row.Cells[i];
- if (columnWidth != null)
- {
- cell.SizeF = new SizeF(columnWidthbottom[2], cell.SizeF.Height);
- }
- }
- }
- }
- }
- private static void AdjustTextSizePatrol(XRTable table, float[] columnWidth)
- {
- float[] columnWidthbottom = { 230f, 609f, 800f };
- foreach (XRTableRow row in table.Rows)
- {
- for (int i = 0; i < row.Cells.Count; i++)
- {
- if (row.Cells.Count > 2)
- {
- XRTableCell cell = row.Cells[i];
- if (columnWidth != null)
- {
- cell.SizeF = new SizeF(columnWidth[i], cell.SizeF.Height);
- }
- }
- else
- {
- XRTableCell cell = row.Cells[i];
- if (columnWidth != null)
- {
- cell.SizeF = new SizeF(columnWidthbottom[2], cell.SizeF.Height);
- }
- }
- }
- }
- }
- private static void AdjustTextSizeEnergy(XRTable table, float[] columnWidth)
- {
- foreach (XRTableRow row in table.Rows)
- {
- for (int i = 0; i < row.Cells.Count; i++)
- {
- XRTableCell cell = row.Cells[i];
- if (columnWidth != null)
- {
- cell.SizeF = new SizeF(columnWidth[i], cell.SizeF.Height);
- }
- }
- }
- }
- private static List<XRTableRow> ConvertListToTableRowstop<T>(List<T> list, String[] exceptions)
- {
- List<XRTableRow> rowList = new List<XRTableRow>();
- Type type = typeof(T);
- String[] Text = { "TextResultDate", "TextResult" };
- foreach (T item in list)
- {
- XRTableRow newRow = MakeXrTableRowTemplate();
- foreach (PropertyInfo propertyInfo in type.GetProperties())
- {
- if (exceptions != null && exceptions.Contains(propertyInfo.Name)) continue;
- if (Text.Contains(propertyInfo.Name)) continue;
- var obj = propertyInfo.GetValue(item);
- String cellText = null;
- if (obj != null)
- {
- cellText = obj.ToString();
- }
- XRTableCell newCell = new XRTableCell();
- newCell.Text = cellText;
- newRow.Cells.Add(newCell);
- }
- rowList.Add(newRow);
- }
- return rowList;
- }
- private static List<XRTableRow> ConvertListToTableRowsbottom<T>(List<T> list, String[] exceptions)
- {
- List<XRTableRow> rowList = new List<XRTableRow>();
- Type type = typeof(T);
- String[] Text = { "TextResultDate", "TextResult" };
- foreach (T item in list)
- {
- XRTableRow newRow = MakeXrTableRowTemplate();
- //String cellText = null;
- String[] temptext = new string[1];
- foreach (PropertyInfo propertyInfo in type.GetProperties())
- {
- if (exceptions != null && exceptions.Contains(propertyInfo.Name)) continue;
- if (!Text.Contains(propertyInfo.Name)) continue;
- var obj = propertyInfo.GetValue(item);
- if (propertyInfo.Name.ToString() == "TextResultDate")
- {
- if (obj != null)
- {
- DateTime[] TextResultDate = (DateTime[])obj;
- temptext = new string[TextResultDate.Count()];
- }
- else
- {
- temptext = null;
- }
- }
- if (propertyInfo.Name.ToString() == "TextResultDate")
- {
- DateTime[] TextResultDate = (DateTime[])obj;
- if (TextResultDate != null)
- {
- for (var i = 0; i < TextResultDate.Count(); i++)
- {
- temptext[i] = " " + TextResultDate[i].ToString("yyyy-MM-dd");
- }
- }
- else
- {
- //for (var i = 0; i < TextResultDate.Count(); i++)
- //{
- // temptext[i] = "";
- //}
- }
- }
- else if (propertyInfo.Name.ToString() == "TextResult")
- {
- String[] TextResult = (String[])obj;
- //var seven = 50;
- if (TextResult != null)
- {
- for (var i = 0; i < TextResult.Count(); i++)
- {
- //var result = TextResult[i].Replace("\n", " "); //.replace(/\n/gi, '</p><p>      ');
- //temptext[i] += " - " + result + "\r\n";
- var result = TextResult[i].Replace("\n", "\n ");
- result = result.Replace("?-", " -");
- temptext[i] += " - " + result + "\r\n";
- //if (temptext[i].Length > seven)
- //{
- // temptext[i] = factorial(temptext[i]);
- //}
- }
- }
- else
- {
- //for (var i = 0; i < TextResult.Count(); i++)
- //{
- // temptext[i] += "";
- //}
- }
- }
- }
- XRTableCell newCell = new XRTableCell();
- string finaltempstring = "";
- if (temptext != null)
- {
- for (var i = 0; i < temptext.Length; i++)
- {
- finaltempstring += temptext[i];
- }
- }
- else
- {
- finaltempstring = "";
- }
- newCell.Text = finaltempstring;
- newCell.Multiline = true;
- newRow.Cells.Add(newCell);
- rowList.Add(newRow);
- }
- return rowList;
- }
- public static string factorial(string temp)
- {
- var seven = 50;
- var forcnt = temp.Length / seven; //몫
- var forcnt1 = temp.Length % seven; //나머지
- if (forcnt == 0)
- {
- return temp;
- }
- else if (forcnt != 0 && forcnt1 != 0)
- {
- return temp.Substring(0, seven) + "\r\n" + factorial(temp.Substring(seven));
- }
- else
- {
- return temp.Substring(0, seven);
- }
- }
- private static XRTableRow MakeXrTableRowTemplate()
- {
- XRTableRow newRow = new XRTableRow();
- newRow.BorderColor = Color.Black;
- newRow.BorderWidth = 1;
- newRow.Borders = DevExpress.XtraPrinting.BorderSide.All;
- newRow.HeightF = 30f;
- return newRow;
- }
- }
- }
|