123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125 |
- using System;
- using System.Drawing;
- using System.Collections;
- using System.ComponentModel;
- using DevExpress.XtraReports.UI;
- using iBemsDataService.Model;
- using System.Data.Entity;
- using System.Data.Entity.Infrastructure;
- using System.Linq;
- using System.Collections.Generic;
- using iBemsDataService.Util;
- namespace iBemsDataService.Report
- {
- public partial class PatrolReport : DevExpress.XtraReports.UI.XtraReport
- {
- private iBemsEntities db = new iBemsEntities();
- private int siteId;
- private DateTime startDate;
- private DateTime endDate;
- public PatrolReport()
- {
- InitializeComponent();
- }
- public PatrolReport(int siteId, DateTime startDate, DateTime endDate) : this()
- {
- this.siteId = siteId;
- this.startDate = startDate;
- this.endDate = endDate;
- }
- protected override void OnBeforePrint(System.Drawing.Printing.PrintEventArgs e)
- {
- base.OnBeforePrint(e);
- //xrLabelDate.Text = String.Format("순찰일자 : {0}", DateTime.Now.ToString("yyyy-MM-dd"));
- xrLabelDate.Text = String.Format("> 순찰일자 : {0}", startDate.ToString("yyyy-MM-dd"));
- List<CmPatrolHistory> pHList =
- (from x in db.CmPatrolHistory
- where x.SiteId == siteId &&
- x.startDate >= startDate && x.endDate != null && // 2016 09 20 hcLee 추가
- x.startDate <= endDate
- orderby x.startDate descending, x.endDate descending
- select x).ToList<CmPatrolHistory>();
- /*
- List<PatrolHistoryDataSource> patrolHistoryList =
- (from x in db.CmPatrolHistory
- where x.SiteId == siteId &&
- x.startDate >= startDate && x.endDate != null && // 2016 09 20 hcLee 추가
- x.startDate <= endDate
- orderby x.startDate descending, x.endDate descending
- select new PatrolHistoryDataSource
- {
- PatrolSheduleName = x.CmPatrolSchedule.Name,
- PatrolTeam = x.CmPatrolSchedule.CmPatrolPlan.CmPatrolGroup.Name,
- PatrolCourse = x.CmPatrolSchedule.CmPatrolPlan.CmPatrolCourse.Name,
- StartDate = x.startDate,
- EndDate = (System.DateTime)x.endDate,
- //Result = x.CmPatrolType.Name,
- Result = String.Format("{0}/{1}/{2}", x.resultPosCnt, x.resultNormalCnt, x.resultAbnormalCnt),
- //resultPosCnt = (int)x.resultPosCnt,
- //resultNormalCnt = (int)x.resultNormalCnt,
- //resultAbnormalCnt = (int) x.resultAbnormalCnt,
- ResultDesc = x.resultDesc
- }).ToList<PatrolHistoryDataSource>(); */
- List<PatrolHistoryDataSource> patrolHistoryList = new List<PatrolHistoryDataSource>();
- foreach (CmPatrolHistory x in pHList)
- {
- PatrolHistoryDataSource pdata = new PatrolHistoryDataSource();
- pdata.PatrolSheduleName = x.CmPatrolSchedule.Name;
- pdata.PatrolTeam = x.CmPatrolSchedule.CmPatrolPlan.CmPatrolGroup.Name;
- pdata.PatrolCourse = x.CmPatrolSchedule.CmPatrolPlan.CmPatrolCourse.Name;
- pdata.StartDate = x.startDate;
- pdata.EndDate = (System.DateTime)x.endDate;
- pdata.Result = String.Format("{0}/{1}/{2}", x.resultPosCnt, x.resultNormalCnt, x.resultAbnormalCnt);
- pdata.ResultDesc = x.resultDesc;
- patrolHistoryList.Add(pdata);
- }
- String resultDescs = String.Empty;
- int listCount = patrolHistoryList.Count;
- for (int i = 0; i < listCount; i++)
- {
- patrolHistoryList[i].No = patrolHistoryList.Count - i;
- resultDescs += String.Format("{0} : {1}\n", patrolHistoryList[i].PatrolSheduleName, patrolHistoryList[i].ResultDesc);
- }
- XRTable tablePatrolHistory = ReportTableHandler.CreateTableFromListWithColumnWidthPatrol(
- patrolHistoryList,
- //new float[] { 72.39f, 150f, 120f, 120f, 140f, 140f, 96.61f },
- new float[] { 69.02f, 143.03f, 114.41f, 114.41f, 133.49f, 133.49f, 92.15f },
- new String[] { "ResultDesc" });
- tablePatrolHistory.LocationF = new Point(20, 0);
- xrRichTextResultDesc.Text = resultDescs;
- if (tablePatrolHistory.Rows.Count > 0)
- {
- DetailPatrolReport.Controls.Clear();
- DetailPatrolReport.Controls.Add(tablePatrolHistory);
- }
- }
- public class PatrolHistoryDataSource
- {
- public int No { get; set; }
- public String PatrolSheduleName { get; set; }
- public String PatrolTeam { get; set; }
- public String PatrolCourse { get; set; }
- public DateTime StartDate { get; set; }
- public DateTime EndDate { get; set; }
- public String Result { get; set; }
- //public int resultPosCnt { get; set; }
- //public int resultNormalCnt { get; set; }
- //public int resultAbnormalCnt { get; set; }
- public String ResultDesc { get; set; }
- }
- }
- }
|