| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873 | using System;using System.Collections;using System.Collections.Generic;using System.Data.Entity;using System.Data.Entity.Infrastructure;using System.Linq;using System.Net;using System.Web;using System.Web.Http;using System.Web.Http.Description;using iBemsDataService.Model;using iBemsDataService.Util;using DevExpress.XtraReports.UI;using System.Drawing;using System.Web.Script.Serialization;using iBemsDataService.Controllers;namespace iBemsDataService.Report{    public partial class DailyReport : DevExpress.XtraReports.UI.XtraReport    {        private iBemsEntities db = new iBemsEntities();        List<BusinessField> BusinessFieldlist = new List<BusinessField>();        public int SiteId { get; set; }        public String AddDate { get; set; }        public String SiteName { get; set; }        public int BusinessFieldId { get; set; }        public String ApproverUserId { get; set; }        public String ApproverUserId2 { get; set; }        public String ApproverUserId3 { get; set; }        public String ApproverUserId4 { get; set; }        public String ApproverUserId5 { get; set; }        public String ApproveDate { get; set; }        public String ApproverUserIdTop = "결재자";        public String ApproverUserIdTop2 = "결재자";        public String ApproverUserIdTop3 = "결재자";        public String ApproverUserIdTop4 = "결재자";        public String ApproverUserIdTop5 = "결재자";        public DailyReport()        {            InitializeComponent();        }        protected override void OnBeforePrint(System.Drawing.Printing.PrintEventArgs e)        {            base.OnBeforePrint(e);            int year, month, day;            String[] addDateArrayStr = AddDate.Split('-');            if (int.TryParse(addDateArrayStr[0], out year) == false ||                int.TryParse(addDateArrayStr[1], out month) == false ||                int.TryParse(addDateArrayStr[2], out day) == false)            {                throw new Exception(string.Format("addDate Parsing Error: {0}", AddDate));            }            var CmSiteSource = db.CmSite                 .Where(a => a.SiteId == SiteId).FirstOrDefault();            SiteName = CmSiteSource.Name;            var dailyReport = db.FmsDailyReport                .Where(a => a.SiteId == SiteId &&                    a.AddDate.Year == year &&                    a.AddDate.Month == month &&                    a.AddDate.Day == day &&                    a.BusinessFieldId == BusinessFieldId)                .FirstOrDefault();            if (dailyReport == null) { return; }            var jsonSerialiser = new JavaScriptSerializer();            DailyReportDatas dailyReportDatas = jsonSerialiser.Deserialize<DailyReportDatas>(dailyReport.Datas);            //////////////            if (dailyReportDatas.Approveseq != null)            {                string[] tempApproveseqplit = dailyReportDatas.Approveseq.Split(';');                int tempcnt = tempApproveseqplit.Length;                if (tempcnt > 0)                {                    string tempName1 = tempApproveseqplit[0];                    var CmUser1 = db.CmUser                        .Where(a => a.SiteId == SiteId &&                        a.IsUse == true &&                        a.UserId == tempName1)                        .FirstOrDefault();                    var CmUserGroup1 = db.CmUserGroup                        .Where(a => a.SiteId == SiteId &&                        a.UserGroupId == CmUser1.UserGroupId)                        .FirstOrDefault();                    ApproverUserIdTop = CmUserGroup1.Name;                    tempcnt--;                    if (tempcnt > 0)                    {                        string tempName2 = tempApproveseqplit[1];                        var CmUser2 = db.CmUser                        .Where(a => a.SiteId == SiteId &&                        a.IsUse == true &&                        a.UserId == tempName2)                        .FirstOrDefault();                        var CmUserGroup2 = db.CmUserGroup                            .Where(a => a.SiteId == SiteId &&                            a.UserGroupId == CmUser2.UserGroupId)                            .FirstOrDefault();                        ApproverUserIdTop2 = CmUserGroup2.Name;                        tempcnt--;                        if (tempcnt > 0)                        {                            string tempName3 = tempApproveseqplit[2];                            var CmUser3 = db.CmUser                                .Where(a => a.SiteId == SiteId &&                                a.IsUse == true &&                                a.UserId == tempName3)                                .FirstOrDefault();                            var CmUserGroup3 = db.CmUserGroup                                .Where(a => a.SiteId == SiteId &&                                a.UserGroupId == CmUser3.UserGroupId)                                .FirstOrDefault();                            ApproverUserIdTop3 = CmUserGroup3.Name;                            tempcnt--;                            if (tempcnt > 0)                            {                                string tempName4 = tempApproveseqplit[3];                                var CmUser4 = db.CmUser                                    .Where(a => a.SiteId == SiteId &&                                    a.IsUse == true &&                                    a.UserId == tempName4)                                    .FirstOrDefault();                                var CmUserGroup4 = db.CmUserGroup                                    .Where(a => a.SiteId == SiteId &&                                    a.UserGroupId == CmUser4.UserGroupId)                                    .FirstOrDefault();                                ApproverUserIdTop4 = CmUserGroup4.Name;                                tempcnt--;                                if (tempcnt > 0)                                {                                    string tempName5 = tempApproveseqplit[4];                                    var CmUser5 = db.CmUser                                        .Where(a => a.SiteId == SiteId &&                                        a.IsUse == true &&                                        a.UserId == tempName5)                                        .FirstOrDefault();                                    var CmUserGroup5 = db.CmUserGroup                                        .Where(a => a.SiteId == SiteId &&                                        a.UserGroupId == CmUser5.UserGroupId)                                        .FirstOrDefault();                                    ApproverUserIdTop5 = CmUserGroup5.Name;                                }                            }                        }                    }                }            }            var CmBusinessFieldDataSource = db.CmBusinessField                    .Where(a => a.SiteId == SiteId &&                    a.IsUse == true);            if (dailyReportDatas.dataseq == null)            {                foreach (var deleteItem in CmBusinessFieldDataSource)                {                    BusinessField BusinessFieldArray = new BusinessField();                    BusinessFieldArray.BusinessFieldId = deleteItem.BusinessFieldId;                    BusinessFieldArray.BusinessFieldName = deleteItem.Name;                    BusinessFieldlist.Add(BusinessFieldArray);                }            }            else            {                var tempseqsplit = dailyReportDatas.dataseq.Split(';');                for (var i = 0; i < tempseqsplit.Length; i++)                {                    foreach (var deleteItem in CmBusinessFieldDataSource)                    {                        if (Convert.ToInt32(tempseqsplit[i]) == deleteItem.BusinessFieldId)                        {                            BusinessField BusinessFieldArray = new BusinessField();                            BusinessFieldArray.BusinessFieldId = deleteItem.BusinessFieldId;                            BusinessFieldArray.BusinessFieldName = deleteItem.Name;                            BusinessFieldlist.Add(BusinessFieldArray);                            break;                        }                    }                }            }            SetReport(dailyReport.ApproverUserId, dailyReport.ApproverUserId2, dailyReport.ApproverUserId3, dailyReport.ApproverUserId4, dailyReport.ApproverUserId5, dailyReport.Name, dailyReport.Contents, dailyReportDatas);        }        public string fn(string str)        {            string res = str.Replace("[^0-9]", "");            return res;        }        private void SetReport(string ApproverUserId, string ApproverUserId2, string ApproverUserId3, string ApproverUserId4, string ApproverUserId5, string Title, string Content, DailyReportDatas dailyReportDatas)        {            int checkcnt = 0;            float[] WorkcolumnWidth = new float[] { 60f, 95f, 95f, 589f };            float[] WorkcolumnenergyWidth = new float[] { 167f, 167f, 167f, 167f, 171f };            String[] Workexceptions = new String[] { "WorkRequestId", "BusinessFieldId", "RequestDate" };            float[] MaterialcolumnWidth = new float[] { 84f, 84f, 84f, 84f, 121f, 121f, 121f, 80f, 60f };            String[] Materialexceptions = new String[] { "No", "FirstClassId", "SecondClassId", "ThirdClassId", "WorkerName" };            /* 결재자 */            if (dailyReportDatas.ApproveCnt == null)            {                int cnt = 0;                if (ApproverUserId != null)                {                    cnt++;                    if (ApproverUserId2 != null)                    {                        cnt++;                        if (ApproverUserId3 != null)                        {                            cnt++;                            if (ApproverUserId4 != null)                            {                                cnt++;                                if (ApproverUserId5 != null)                                {                                    cnt++;                                }                            }                        }                    }                }                checkcnt = cnt;            }            else            {                checkcnt = Convert.ToInt32(dailyReportDatas.ApproveCnt);            }            switch (checkcnt)            {                case 0:                    checktop1.Visible = false;                    checkbottom1.Visible = false;                    checktop2.Visible = false;                    checkbottom2.Visible = false;                    checktop3.Visible = false;                    checkbottom3.Visible = false;                    checktop4.Visible = false;                    checkbottom4.Visible = false;                    checktop5.Visible = false;                    checkbottom5.Visible = false;                    break;                case 1:                    checktop1.Visible = false;                    checkbottom1.Visible = false;                    checktop2.Visible = false;                    checkbottom2.Visible = false;                    checktop3.Visible = false;                    checkbottom3.Visible = false;                    checktop4.Visible = false;                    checkbottom4.Visible = false;                    checktop5.Text = ApproverUserIdTop;                    checkbottom5.Text = ApproverUserId;                    break;                case 2:                    checktop1.Visible = false;                    checkbottom1.Visible = false;                    checktop2.Visible = false;                    checkbottom2.Visible = false;                    checktop3.Visible = false;                    checkbottom3.Visible = false;                    checktop4.Text = ApproverUserIdTop;                    checkbottom4.Text = ApproverUserId;                    checktop5.Text = ApproverUserIdTop2;                    checkbottom5.Text = ApproverUserId2;                    break;                case 3:                    checktop1.Visible = false;                    checkbottom1.Visible = false;                    checktop2.Visible = false;                    checkbottom2.Visible = false;                    checktop3.Text = ApproverUserIdTop;                    checkbottom3.Text = ApproverUserId;                    checktop4.Text = ApproverUserIdTop2;                    checkbottom4.Text = ApproverUserId2;                    checktop5.Text = ApproverUserIdTop3;                    checkbottom5.Text = ApproverUserId3;                    break;                case 4:                    checktop1.Visible = false;                    checkbottom1.Visible = false;                    checktop2.Text = ApproverUserIdTop;                    checkbottom2.Text = ApproverUserId;                    checktop3.Text = ApproverUserIdTop2;                    checkbottom3.Text = ApproverUserId2;                    checktop4.Text = ApproverUserIdTop3;                    checkbottom4.Text = ApproverUserId3;                    checktop5.Text = ApproverUserIdTop4;                    checkbottom5.Text = ApproverUserId4;                    break;                case 5:                    checktop1.Text = ApproverUserIdTop;                    checkbottom1.Text = ApproverUserId;                    checktop2.Text = ApproverUserIdTop2;                    checkbottom2.Text = ApproverUserId2;                    checktop3.Text = ApproverUserIdTop3;                    checkbottom3.Text = ApproverUserId3;                    checktop4.Text = ApproverUserIdTop4;                    checkbottom4.Text = ApproverUserId4;                    checktop5.Text = ApproverUserIdTop5;                    checkbottom5.Text = ApproverUserId5;                    break;            }            /* 회사명 */            xrLabelSiteName.Text = SiteName;            /* 기본정보 */            xrTableCellTitle.Text = Title;            if (Content != null)            {                //var result = Content.Replace("\n", " ");                xrTableCellContent.Text = Content;            }            xrTableCellAddDate.Text = AddDate;            String[] addDateArrayStr = AddDate.Split('-');            DateTime tempday = new DateTime(Convert.ToInt32(addDateArrayStr[0]), Convert.ToInt32(addDateArrayStr[1]), Convert.ToInt32(addDateArrayStr[2]));            var tempstringMMDD = tempday.ToString("MM월 dd일");            var tempstringMMDDbefore = tempday.AddDays(-1).ToString("MM월 dd일");            var tempstringMM = tempday.ToString("MM월");            today.Text = tempstringMMDD + "(금일)";            beforeday.Text = tempstringMMDDbefore + "(전일)";            todayusage.Text = tempstringMMDD + " 사용량";            monthusage.Text = tempstringMM + " 사용량";            /* 인원현황 */            xrTableCellHumanResourceTotal.Text = dailyReportDatas.HumanResourceTotal;            xrTableCellHumanResourceVacancy.Text = dailyReportDatas.HumanResourceVacancy;            xrTableCellHumanResourceOff.Text = dailyReportDatas.HumanResourceOff;            xrTableCellHumanResourceVacation.Text = dailyReportDatas.HumanResourceVacation;            xrTableCellHumanResourceClosed.Text = dailyReportDatas.HumanResourceClosed;            xrTableCellHumanResourceTrain.Text = dailyReportDatas.HumanResourceTrain;            xrTableCellHumanResourceCurrent.Text = dailyReportDatas.HumanResourceCurrent;            xrTableCellHumanResourceOut.Text = dailyReportDatas.HumanResourceOut;            xrTableCellHumanResourceEtc.Text = dailyReportDatas.HumanResourceEtc;            /* 작업현황 */            xrTableCellWorkStatus1.Text = dailyReportDatas.WorkStatus.WorkStatusTypePeriodicInspection.ToString();            xrTableCellWorkStatus2.Text = dailyReportDatas.WorkStatus.WorkStatusTypeForensicExamination.ToString();            xrTableCellWorkStatus3.Text = dailyReportDatas.WorkStatus.WorkStatusTypeOccasional.ToString();            xrTableCellWorkStatus4.Text = dailyReportDatas.WorkStatus.WorkStatusTypeEtc.ToString();            xrTableCellWorkStatus5.Text = dailyReportDatas.WorkStatus.WorkStatusTypeTotal.ToString();            xrTableCellWorkStatus6.Text = dailyReportDatas.WorkStatus.WorkStatusPending.ToString();            xrTableCellWorkStatus7.Text = dailyReportDatas.WorkStatus.WorkStatusInProgress.ToString();            xrTableCellWorkStatus8.Text = dailyReportDatas.WorkStatus.WorkStatusDeferred.ToString();            xrTableCellWorkStatus9.Text = dailyReportDatas.WorkStatus.WorkStatusComplete.ToString();            xrTableCellWorkStatus10.Text = dailyReportDatas.WorkStatus.WorkStatusApproved.ToString();            xrTableCellWorkStatus11.Text = dailyReportDatas.WorkStatus.WorkStatusTotal.ToString();            /* 에너지 관리 */            //전기            var tempList = new List<FmsEnergyDailyReport>();            if (dailyReportDatas.resultEnergy1.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergy1);            }            if (dailyReportDatas.resultEnergy2.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergy2);            }            if (dailyReportDatas.resultEnergytotal1.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergytotal1);            }            //가스            if (dailyReportDatas.resultEnergy3.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergy3);            }            if (dailyReportDatas.resultEnergy4.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergy4);            }            if (dailyReportDatas.resultEnergy5.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergy5);            }            if (dailyReportDatas.resultEnergy6.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergy6);            }            if (dailyReportDatas.resultEnergy7.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergy7);            }            if (dailyReportDatas.resultEnergy8.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergy8);            }            if (dailyReportDatas.resultEnergy9.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergy9);            }            if (dailyReportDatas.resultEnergytotal2.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergytotal2);            }            if (dailyReportDatas.resultEnergytotal3.Name != "")            {                tempList.Add(dailyReportDatas.resultEnergytotal3);            }            /* 에너지관리관리 */            XRTable tableEnergy = ReportTableHandler.CreateTableFromEnergyWithWidth(tempList, WorkcolumnenergyWidth);            if (tableEnergy.Rows.Count > 0)            {                EnergyTable.Controls.Clear();                EnergyTable.Controls.Add(tableEnergy);            }            /* 작업관리 */            if (dailyReportDatas.resultWorkCommon != null && dailyReportDatas.resultWorkCommon.Count != 0)            {                XRTable tableCommon = ReportTableHandler.CreateTableFromListWithColumnWidth(dailyReportDatas.resultWorkCommon, WorkcolumnWidth, Workexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon[0].BusinessFieldId)                    {                        xrLabelcommon.Text = BusinessFieldlist[i].BusinessFieldName + " 작업관리";                        break;                    }                }                if (tableCommon.Rows.Count > 0)                {                    DetailCommon.Controls.Clear();                    DetailCommon.Controls.Add(tableCommon);                }            }            else            {                DetailReportCommon.Visible = false;            }            if (dailyReportDatas.resultWorkCommon1 != null && dailyReportDatas.resultWorkCommon1.Count != 0)            {                XRTable tableCommon1 = ReportTableHandler.CreateTableFromListWithColumnWidth(dailyReportDatas.resultWorkCommon1, WorkcolumnWidth, Workexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon1[0].BusinessFieldId)                    {                        xrLabelcommon1.Text = BusinessFieldlist[i].BusinessFieldName + " 작업관리";                        break;                    }                }                if (tableCommon1.Rows.Count > 0)                {                    DetailCommon1.Controls.Clear();                    DetailCommon1.Controls.Add(tableCommon1);                }            }            else            {                DetailReportCommon1.Visible = false;            }            if (dailyReportDatas.resultWorkCommon2 != null && dailyReportDatas.resultWorkCommon2.Count != 0)            {                XRTable tableCommon2 = ReportTableHandler.CreateTableFromListWithColumnWidth(dailyReportDatas.resultWorkCommon2, WorkcolumnWidth, Workexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon2[0].BusinessFieldId)                    {                        xrLabelcommon2.Text = BusinessFieldlist[i].BusinessFieldName + " 작업관리";                        break;                    }                }                if (tableCommon2.Rows.Count > 0)                {                    DetailCommon2.Controls.Clear();                    DetailCommon2.Controls.Add(tableCommon2);                }            }            else            {                DetailReportCommon2.Visible = false;            }            if (dailyReportDatas.resultWorkCommon3 != null && dailyReportDatas.resultWorkCommon3.Count != 0)            {                XRTable tableCommon3 = ReportTableHandler.CreateTableFromListWithColumnWidth(dailyReportDatas.resultWorkCommon3, WorkcolumnWidth, Workexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon3[0].BusinessFieldId)                    {                        xrLabelcommon3.Text = BusinessFieldlist[i].BusinessFieldName + " 작업관리";                        break;                    }                }                if (tableCommon3.Rows.Count > 0)                {                    DetailCommon3.Controls.Clear();                    DetailCommon3.Controls.Add(tableCommon3);                }            }            else            {                DetailReportCommon3.Visible = false;            }            if (dailyReportDatas.resultWorkCommon4 != null && dailyReportDatas.resultWorkCommon4.Count != 0)            {                XRTable tableCommon4 = ReportTableHandler.CreateTableFromListWithColumnWidth(dailyReportDatas.resultWorkCommon4, WorkcolumnWidth, Workexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon4[0].BusinessFieldId)                    {                        xrLabelcommon4.Text = BusinessFieldlist[i].BusinessFieldName + " 작업관리";                        break;                    }                }                if (tableCommon4.Rows.Count > 0)                {                    DetailCommon4.Controls.Clear();                    DetailCommon4.Controls.Add(tableCommon4);                }            }            else            {                DetailReportCommon4.Visible = false;            }            if (dailyReportDatas.resultWorkCommon5 != null && dailyReportDatas.resultWorkCommon5.Count != 0)            {                XRTable tableCommon5 = ReportTableHandler.CreateTableFromListWithColumnWidth(dailyReportDatas.resultWorkCommon5, WorkcolumnWidth, Workexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon5[0].BusinessFieldId)                    {                        xrLabelcommon5.Text = BusinessFieldlist[i].BusinessFieldName + " 작업관리";                        break;                    }                }                if (tableCommon5.Rows.Count > 0)                {                    DetailCommon5.Controls.Clear();                    DetailCommon5.Controls.Add(tableCommon5);                }            }            else            {                DetailReportCommon5.Visible = false;            }            if (dailyReportDatas.resultWorkCommon6 != null && dailyReportDatas.resultWorkCommon6.Count != 0)            {                XRTable tableCommon6 = ReportTableHandler.CreateTableFromListWithColumnWidth(dailyReportDatas.resultWorkCommon6, WorkcolumnWidth, Workexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon6[0].BusinessFieldId)                    {                        xrLabelcommon6.Text = BusinessFieldlist[i].BusinessFieldName + " 작업관리";                        break;                    }                }                if (tableCommon6.Rows.Count > 0)                {                    DetailCommon6.Controls.Clear();                    DetailCommon6.Controls.Add(tableCommon6);                }            }            else            {                DetailReportCommon6.Visible = false;            }            if (dailyReportDatas.resultWorkCommon7 != null && dailyReportDatas.resultWorkCommon7.Count != 0)            {                XRTable tableCommon7 = ReportTableHandler.CreateTableFromListWithColumnWidth(dailyReportDatas.resultWorkCommon7, WorkcolumnWidth, Workexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon7[0].BusinessFieldId)                    {                        xrLabelcommon7.Text = BusinessFieldlist[i].BusinessFieldName + " 작업관리";                        break;                    }                }                if (tableCommon7.Rows.Count > 0)                {                    DetailCommon7.Controls.Clear();                    DetailCommon7.Controls.Add(tableCommon7);                }            }            else            {                DetailReportCommon7.Visible = false;            }            if (dailyReportDatas.resultWorkCommon8 != null && dailyReportDatas.resultWorkCommon8.Count != 0)            {                XRTable tableCommon8 = ReportTableHandler.CreateTableFromListWithColumnWidth(dailyReportDatas.resultWorkCommon8, WorkcolumnWidth, Workexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon8[0].BusinessFieldId)                    {                        xrLabelcommon8.Text = BusinessFieldlist[i].BusinessFieldName + " 작업관리";                        break;                    }                }                if (tableCommon8.Rows.Count > 0)                {                    DetailCommon8.Controls.Clear();                    DetailCommon8.Controls.Add(tableCommon8);                }            }            else            {                DetailReportCommon8.Visible = false;            }            /* 자재사용내역 */            if (dailyReportDatas.resultFmsMaterial != null && dailyReportDatas.resultFmsMaterial.Count() != 0)            {                XRTable tableFmsMaterial = ReportTableHandler.CreateTableFromListWithColumnWidthMaterial(dailyReportDatas.resultFmsMaterial, MaterialcolumnWidth, Materialexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon[0].BusinessFieldId)                    {                        xrLabelMaterial.Text = BusinessFieldlist[i].BusinessFieldName + " 자재사용내역";                        break;                    }                }                if (tableFmsMaterial.Rows.Count > 0)                {                    DetailFmsMaterial.Controls.Clear();                    DetailFmsMaterial.Controls.Add(tableFmsMaterial);                }            }            else            {                DetailMaterial.Visible = false;            }            if (dailyReportDatas.resultFmsMaterial1 != null && dailyReportDatas.resultFmsMaterial1.Count() != 0)            {                XRTable tableFmsMaterial1 = ReportTableHandler.CreateTableFromListWithColumnWidthMaterial(dailyReportDatas.resultFmsMaterial1, MaterialcolumnWidth, Materialexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon1[0].BusinessFieldId)                    {                        xrLabelMaterial1.Text = BusinessFieldlist[i].BusinessFieldName + " 자재사용내역";                        break;                    }                }                if (tableFmsMaterial1.Rows.Count > 0)                {                    DetailFmsMaterial1.Controls.Clear();                    DetailFmsMaterial1.Controls.Add(tableFmsMaterial1);                }            }            else            {                DetailMaterial1.Visible = false;            }            if (dailyReportDatas.resultFmsMaterial2 != null && dailyReportDatas.resultFmsMaterial2.Count() != 0)            {                XRTable tableFmsMaterial2 = ReportTableHandler.CreateTableFromListWithColumnWidthMaterial(dailyReportDatas.resultFmsMaterial2, MaterialcolumnWidth, Materialexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon2[0].BusinessFieldId)                    {                        xrLabelMaterial2.Text = BusinessFieldlist[i].BusinessFieldName + " 자재사용내역";                        break;                    }                }                if (tableFmsMaterial2.Rows.Count > 0)                {                    DetailFmsMaterial2.Controls.Clear();                    DetailFmsMaterial2.Controls.Add(tableFmsMaterial2);                }            }            else            {                DetailMaterial2.Visible = false;            }            if (dailyReportDatas.resultFmsMaterial3 != null && dailyReportDatas.resultFmsMaterial3.Count() != 0)            {                XRTable tableFmsMaterial3 = ReportTableHandler.CreateTableFromListWithColumnWidthMaterial(dailyReportDatas.resultFmsMaterial3, MaterialcolumnWidth, Materialexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon3[0].BusinessFieldId)                    {                        xrLabelMaterial3.Text = BusinessFieldlist[i].BusinessFieldName + " 자재사용내역";                        break;                    }                }                if (tableFmsMaterial3.Rows.Count > 0)                {                    DetailFmsMaterial3.Controls.Clear();                    DetailFmsMaterial3.Controls.Add(tableFmsMaterial3);                }            }            else            {                DetailMaterial3.Visible = false;            }            if (dailyReportDatas.resultFmsMaterial4 != null && dailyReportDatas.resultFmsMaterial4.Count() != 0)            {                XRTable tableFmsMaterial4 = ReportTableHandler.CreateTableFromListWithColumnWidthMaterial(dailyReportDatas.resultFmsMaterial4, MaterialcolumnWidth, Materialexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon4[0].BusinessFieldId)                    {                        xrLabelMaterial4.Text = BusinessFieldlist[i].BusinessFieldName + " 자재사용내역";                        break;                    }                }                if (tableFmsMaterial4.Rows.Count > 0)                {                    DetailFmsMaterial4.Controls.Clear();                    DetailFmsMaterial4.Controls.Add(tableFmsMaterial4);                }            }            else            {                DetailMaterial4.Visible = false;            }            if (dailyReportDatas.resultFmsMaterial5 != null && dailyReportDatas.resultFmsMaterial5.Count() != 0)            {                XRTable tableFmsMaterial5 = ReportTableHandler.CreateTableFromListWithColumnWidthMaterial(dailyReportDatas.resultFmsMaterial5, MaterialcolumnWidth, Materialexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon5[0].BusinessFieldId)                    {                        xrLabelMaterial5.Text = BusinessFieldlist[i].BusinessFieldName + " 자재사용내역";                        break;                    }                }                if (tableFmsMaterial5.Rows.Count > 0)                {                    DetailFmsMaterial5.Controls.Clear();                    DetailFmsMaterial5.Controls.Add(tableFmsMaterial5);                }            }            else            {                DetailMaterial5.Visible = false;            }            if (dailyReportDatas.resultFmsMaterial6 != null && dailyReportDatas.resultFmsMaterial6.Count() != 0)            {                XRTable tableFmsMaterial6 = ReportTableHandler.CreateTableFromListWithColumnWidthMaterial(dailyReportDatas.resultFmsMaterial6, MaterialcolumnWidth, Materialexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon6[0].BusinessFieldId)                    {                        xrLabelMaterial6.Text = BusinessFieldlist[i].BusinessFieldName + " 자재사용내역";                        break;                    }                }                if (tableFmsMaterial6.Rows.Count > 0)                {                    DetailFmsMaterial6.Controls.Clear();                    DetailFmsMaterial6.Controls.Add(tableFmsMaterial6);                }            }            else            {                DetailMaterial6.Visible = false;            }            if (dailyReportDatas.resultFmsMaterial7 != null && dailyReportDatas.resultFmsMaterial7.Count() != 0)            {                XRTable tableFmsMaterial7 = ReportTableHandler.CreateTableFromListWithColumnWidthMaterial(dailyReportDatas.resultFmsMaterial7, MaterialcolumnWidth, Materialexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon7[0].BusinessFieldId)                    {                        xrLabelMaterial7.Text = BusinessFieldlist[i].BusinessFieldName + " 자재사용내역";                        break;                    }                }                if (tableFmsMaterial7.Rows.Count > 0)                {                    DetailFmsMaterial7.Controls.Clear();                    DetailFmsMaterial7.Controls.Add(tableFmsMaterial7);                }            }            else            {                DetailMaterial7.Visible = false;            }            if (dailyReportDatas.resultFmsMaterial8 != null && dailyReportDatas.resultFmsMaterial8.Count() != 0)            {                XRTable tableFmsMaterial8 = ReportTableHandler.CreateTableFromListWithColumnWidthMaterial(dailyReportDatas.resultFmsMaterial8, MaterialcolumnWidth, Materialexceptions);                for (var i = 0; i < BusinessFieldlist.Count(); i++)                {                    if (BusinessFieldlist[i].BusinessFieldId == dailyReportDatas.resultWorkCommon8[0].BusinessFieldId)                    {                        xrLabelMaterial8.Text = BusinessFieldlist[i].BusinessFieldName + " 자재사용내역";                        break;                    }                }                if (tableFmsMaterial8.Rows.Count > 0)                {                    DetailFmsMaterial8.Controls.Clear();                    DetailFmsMaterial8.Controls.Add(tableFmsMaterial8);                }            }            else            {                DetailMaterial8.Visible = false;            }        }        public class BusinessField        {            public int BusinessFieldId { get; set; }            public string BusinessFieldName { get; set; }        }        public class DailyReportDatas        {            public String HumanResourceTotal { get; set; }            public String HumanResourceVacancy { get; set; }            public String HumanResourceOff { get; set; }            public String HumanResourceVacation { get; set; }            public String HumanResourceCurrent { get; set; }            public String HumanResourceTrain { get; set; }            public String HumanResourceClosed { get; set; }            public String HumanResourceOut { get; set; }            public String HumanResourceEtc { get; set; }            public String dataseq { get; set; }            public String Approveseq { get; set; }            public String ApproveCnt { get; set; }            public WorkStatus WorkStatus { get; set; }            public FmsEnergyDailyReport resultEnergy1 { get; set; }            public FmsEnergyDailyReport resultEnergy2 { get; set; }            public FmsEnergyDailyReport resultEnergy3 { get; set; }            public FmsEnergyDailyReport resultEnergy4 { get; set; }            public FmsEnergyDailyReport resultEnergy5 { get; set; }            public FmsEnergyDailyReport resultEnergy6 { get; set; }            public FmsEnergyDailyReport resultEnergy7 { get; set; }            public FmsEnergyDailyReport resultEnergy8 { get; set; }            public FmsEnergyDailyReport resultEnergy9 { get; set; }            public FmsEnergyDailyReport resultEnergytotal1 { get; set; }            public FmsEnergyDailyReport resultEnergytotal2 { get; set; }            public FmsEnergyDailyReport resultEnergytotal3 { get; set; }            public List<FmsWorkRequestForDailyReport> resultWorkCommon { get; set; }            public List<FmsMaterialForDailyReport> resultFmsMaterial { get; set; }            public List<FmsWorkRequestForDailyReport> resultWorkCommon1 { get; set; }            public List<FmsMaterialForDailyReport> resultFmsMaterial1 { get; set; }            public List<FmsWorkRequestForDailyReport> resultWorkCommon2 { get; set; }            public List<FmsMaterialForDailyReport> resultFmsMaterial2 { get; set; }            public List<FmsWorkRequestForDailyReport> resultWorkCommon3 { get; set; }            public List<FmsMaterialForDailyReport> resultFmsMaterial3 { get; set; }            public List<FmsWorkRequestForDailyReport> resultWorkCommon4 { get; set; }            public List<FmsMaterialForDailyReport> resultFmsMaterial4 { get; set; }            public List<FmsWorkRequestForDailyReport> resultWorkCommon5 { get; set; }            public List<FmsMaterialForDailyReport> resultFmsMaterial5 { get; set; }            public List<FmsWorkRequestForDailyReport> resultWorkCommon6 { get; set; }            public List<FmsMaterialForDailyReport> resultFmsMaterial6 { get; set; }            public List<FmsWorkRequestForDailyReport> resultWorkCommon7 { get; set; }            public List<FmsMaterialForDailyReport> resultFmsMaterial7 { get; set; }            public List<FmsWorkRequestForDailyReport> resultWorkCommon8 { get; set; }            public List<FmsMaterialForDailyReport> resultFmsMaterial8 { get; set; }            public int FileUpload { get; set; }        }    }}
 |