123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477 |
- 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 DevExpress.Office.Utils;
- using iBemsDataService.Model;
- using iBemsDataService.Util;
- using System.Transactions;
- using System.Collections.Specialized;
- namespace iBemsDataService.Controllers
- {
- public class DailyReportController : ApiController
- {
- private iBemsEntities db = new iBemsEntities();
- public enum WorkTypeId
- {
- PeriodicInspection = 1,
- ForensicExamination = 2,
- CivilComplaint = 3,
- Etc1 = 4,
- Occasional = 5
- }
- public enum WorkProgressId
- {
- WorkStatusPending = 3,
- WorkStatusInProgress = 4,
- WorkStatusComplete = 5,
- WorkStatusApproved = 6,
- WorkStatusDeferred = 7,
- }
- public enum AdjustmentTypeId
- {
- Regular = 0,
- Loss = 1,
- Return = 2
- }
- // jhLee 2016-05-12
- [ActionName("CurrentDate")]
- public DateTime GetCurrentDate()
- {
- return DateTime.Now;
- }
- [ActionName("WorkStatus")]
- public WorkStatus GetWorkStatus()
- {
- Uri uri = Request.RequestUri;
- NameValueCollection uriQuery = HttpUtility.ParseQueryString(uri.Query);
- WorkStatusGenerator workStatusGenerator = new WorkStatusGenerator(db, uriQuery);
- return workStatusGenerator.GetWorkStatus();
- }
- [ActionName("FmsWorkRequestForDailyReport")]
- public List<FmsWorkRequestForDailyReport> GetFmsWorkRequestForDailyReport()
- {
- Uri uri = Request.RequestUri;
- NameValueCollection uriQuery = HttpUtility.ParseQueryString(uri.Query);
- WorkStatusGenerator workStatusGenerator = new WorkStatusGenerator(db, uriQuery);
- return workStatusGenerator.GetFmsWorkRequestForDailyReport();
- }
- [ActionName("FmsWorkOrderForDailyReport")]
- public List<FmsWorkOrderForDailyReport> GetFmsWorkOrderForDailyReport()
- {
- Uri uri = Request.RequestUri;
- NameValueCollection uriQuery = HttpUtility.ParseQueryString(uri.Query);
- WorkStatusGenerator workStatusGenerator = new WorkStatusGenerator(db, uriQuery);
- return workStatusGenerator.GetFmsWorkOrderForDailyReport(WorkTypeId.PeriodicInspection, WorkTypeId.ForensicExamination);
- }
- [ActionName("FmsWorkEtcForDailyReport")]
- public List<FmsWorkOrderForDailyReport> GetFmsWorkEtcForDailyReport()
- {
- Uri uri = Request.RequestUri;
- NameValueCollection uriQuery = HttpUtility.ParseQueryString(uri.Query);
- WorkStatusGenerator workStatusGenerator = new WorkStatusGenerator(db, uriQuery);
- return workStatusGenerator.GetFmsWorkOrderForDailyReport(WorkTypeId.Etc1, WorkTypeId.Occasional);
- }
- [ActionName("FmsMaterialForDailyReport")]
- public List<FmsMaterialForDailyReport> GetFmsMaterialForDailyReport()
- {
- Uri uri = Request.RequestUri;
- NameValueCollection uriQuery = HttpUtility.ParseQueryString(uri.Query);
- WorkStatusGenerator workStatusGenerator = new WorkStatusGenerator(db, uriQuery);
- return workStatusGenerator.GetFmsMaterialForDailyReport();
- }
- [ActionName("FileUpload")]
- public String FileUpload()
- {
- //Uri uri = Request.RequestUri;
- //NameValueCollection uriQuery = HttpUtility.ParseQueryString(uri.Query);
- //String siteId = uriQuery.Get("SiteId");
- //WorkStatusGenerator workStatusGenerator = new WorkStatusGenerator(db, uriQuery);
- var httpPostedFile = HttpContext.Current.Request.Files[0];
- if (httpPostedFile != null)
- {
- try
- {
- var fileSavePath = System.IO.Path.Combine(HttpContext.Current.Server.MapPath("..\\..\\App_Data\\files\\report2"), httpPostedFile.FileName);
- //var fileSavePath = System.IO.Path.Combine("../", httpPostedFile.FileName);
- // Save the uploaded file to "UploadedFiles" folder
- httpPostedFile.SaveAs(fileSavePath);
- return fileSavePath;
- }
- catch (Exception e)
- {
- throw new Exception(e.Message.ToString());
- }
- }
- else
- {
- throw new Exception("File length error");
- }
- }
- class WorkStatusGenerator
- {
- iBemsEntities db;
- int siteId;
- int year;
- int month;
- int day;
- int businessFieldId;
- public WorkStatusGenerator(iBemsEntities db, NameValueCollection uriQuery)
- {
- int siteId, businessFieldId;
- String addDate;
- if (int.TryParse(uriQuery.Get("SiteId"), out siteId) == false ||
- (addDate = uriQuery.Get("AddDate")) == null ||
- int.TryParse(uriQuery.Get("BusinessFieldId"), out businessFieldId) == false)
- {
- throw new Exception(string.Format("Not Found Parameters: {0} {1} {2}", "SiteId", "addDate", "BusinessFieldId"));
- }
- this.db = db;
- this.siteId = siteId;
- 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));
- }
- this.businessFieldId = businessFieldId;
- }
- /* 작업 현황 테이블 정보 추출 */
- public WorkStatus GetWorkStatus()
- {
- WorkStatus workStatus = new WorkStatus();
- workStatus.WorkStatusTypeOccasional = GetWorkStatusByWorkTypeId(WorkTypeId.Occasional);
- workStatus.WorkStatusTypePeriodicInspection = GetWorkStatusByWorkTypeId(WorkTypeId.PeriodicInspection);
- workStatus.WorkStatusTypeForensicExamination = GetWorkStatusByWorkTypeId(WorkTypeId.ForensicExamination);
- workStatus.WorkStatusTypeEtc = GetWorkStatusByWorkTypeId(WorkTypeId.Etc1) + GetWorkStatusByWorkTypeId(WorkTypeId.CivilComplaint);
- workStatus.WorkStatusTypeTotal = workStatus.WorkStatusTypePeriodicInspection + workStatus.WorkStatusTypeForensicExamination + workStatus.WorkStatusTypeEtc + workStatus.WorkStatusTypeOccasional;
- workStatus.WorkStatusPending = GetWorkStatusByWorkProgressId(WorkProgressId.WorkStatusPending);
- workStatus.WorkStatusInProgress = GetWorkStatusByWorkProgressId(WorkProgressId.WorkStatusInProgress);
- workStatus.WorkStatusDeferred = GetWorkStatusByWorkProgressId(WorkProgressId.WorkStatusDeferred);
- workStatus.WorkStatusComplete = GetFmsWorkResultComplete(WorkProgressId.WorkStatusComplete);
- workStatus.WorkStatusApproved = GetFmsWorkResultApproval(WorkProgressId.WorkStatusApproved);
- workStatus.WorkStatusTotal = workStatus.WorkStatusPending +
- workStatus.WorkStatusInProgress + workStatus.WorkStatusDeferred + workStatus.WorkStatusComplete + workStatus.WorkStatusApproved;
- return workStatus;
- }
- private int GetWorkStatusByWorkTypeId(WorkTypeId workTypeId)
- {
- return (from x in db.FmsWorkOrder
- let y = from y in db.FmsWorkRequest
- where y.SiteId == siteId && // 2019.07.12
- y.WorkTypeId == (int)workTypeId
- select y.WorkRequestId
- where x.SiteId == siteId &&
- x.OrderDate.Year == year &&
- x.OrderDate.Month == month &&
- x.OrderDate.Day == day &&
- y.Contains(x.WorkRequestId)
- select x
- ).Count();
- }
- private int GetWorkStatusByWorkTypeIdEtc()
- {
- return (from x in db.FmsWorkOrder
- let y = from y in db.FmsWorkRequest
- where y.SiteId == siteId && //2019.07.12
- y.WorkTypeId >= (int)WorkTypeId.Etc1
- select y.WorkRequestId
- where x.SiteId == siteId &&
- x.OrderDate.Year == year &&
- x.OrderDate.Month == month &&
- x.OrderDate.Day == day &&
- y.Contains(x.WorkRequestId)
- select x
- ).Count();
- }
- private int GetWorkStatusByWorkProgressId(WorkProgressId workProgressId)
- {
- return (from x in db.FmsWorkOrder
- let y = from y in db.FmsWorkRequest
- where y.SiteId == siteId && //2019.07.12
- y.WorkProgressId == (int)workProgressId &&
- y.StartWorkDate <= new DateTime(year, month, day)
- select y.WorkRequestId
- where x.SiteId == siteId &&
- y.Contains(x.WorkRequestId)
- select x
- ).Count();
- }
- private int GetFmsWorkResultComplete(WorkProgressId workProgressId)
- {
- return (from x in db.FmsWorkResult
- let y = from y in db.FmsWorkRequest
- where y.SiteId == siteId && //2019.07.12
- y.WorkProgressId == (int)workProgressId &&
- y.StartWorkDate <= new DateTime(year, month, day)
- select y.WorkRequestId
- where x.SiteId == siteId &&
- y.Contains(x.WorkRequestId)
- select x
- ).Count();
- }
- private int GetFmsWorkResultApproval(WorkProgressId workProgressId)
- {
- return (from x in db.FmsWorkResult
- let y = from y in db.FmsWorkRequest
- where y.SiteId == siteId && //2019.07.12
- y.WorkProgressId == (int)workProgressId
- select y.WorkRequestId
- where x.SiteId == siteId &&
- y.Contains(x.WorkRequestId) &&
- x.ConfirmedDate.Value.Year == year &&
- x.ConfirmedDate.Value.Month == month &&
- x.ConfirmedDate.Value.Day == day
- select x
- ).Count();
- }
- /* 공통 업무 테이블 정보 추출 */
- public List<FmsWorkRequestForDailyReport> GetFmsWorkRequestForDailyReport()
- {
- var list = (from x in db.FmsWorkRequest
- let y = from y in db.FmsWorkResult
- where (y.IsConfirmed == false && (y.StartDate <= new DateTime(year, month, day))) || //&& (y.StartDate <= new DateTime(year, month, day))) 추가
- (y.ConfirmedDate.Value.Year == year &&//ConfirmedDate.Value
- y.ConfirmedDate.Value.Month == month &&//ConfirmedDate.Value
- y.ConfirmedDate.Value.Day == day) &&
- y.SiteId == siteId
- select y.WorkRequestId
- where
- (y.Contains(x.WorkRequestId) && x.BusinessFieldId == businessFieldId) ||
- (x.WorkProgressId <= (int)WorkProgressId.WorkStatusComplete && x.WorkProgressId >= (int)WorkProgressId.WorkStatusInProgress && x.BusinessFieldId == businessFieldId) && (x.StartWorkDate <= new DateTime(year, month, day)) &&
- x.SiteId == siteId
- orderby x.RequestDate, x.WorkProgressId ascending
- select new FmsWorkRequestForDailyReport
- {
- WorkRequestId = x.WorkRequestId,
- BusinessFieldId = x.BusinessFieldId,
- WorkProgressId = x.FmsWorkCodeProgress.Name,
- WorkTypeId = x.FmsWorkCodeType.Name,
- RequestDate = x.RequestDate,
- Title = x.Title
- }).ToList();
- for (int i = 0; i < list.Count; i++)
- {
- list[i].No = i + 1;
- int tempWorkRequestId = list[i].WorkRequestId;
- /////////////////////////////////////////
- db = new iBemsEntities();
- var TextResultData = db.FmsWorkResultCheckItem.Where(x =>
- x.SiteId == siteId &&
- x.WorkRequestId == tempWorkRequestId)
- .ToList();//list[i].WorkRequestId
- if (TextResultData == null) { }
- else
- {
- using (var transaction = new TransactionScope())
- {
- var j = 0;
- foreach (var TextData in TextResultData)
- {
- if (list[i].TextResult == null)
- list[i].TextResult = new String[TextResultData.Count];
- if (list[i].TextResultDate == null)
- list[i].TextResultDate = new DateTime[TextResultData.Count];
- list[i].TextResult[j] = TextData.TextResult;
- list[i].TextResultDate[j] = TextData.CheckDate;
- j++;
- }
- transaction.Complete();
- }
- }
- }
- return list;
- }
- /* 정기/법정 테이블 정보 추출 */
- /* 기타 테이블 정보 추출 */
- public List<FmsWorkOrderForDailyReport> GetFmsWorkOrderForDailyReport(WorkTypeId workTypeId1, WorkTypeId workTypeId2)
- {
- var list = (from x in db.FmsWorkOrder
- let y = from y in db.FmsWorkRequest
- where y.SiteId == siteId &&
- (y.WorkTypeId == (int)workTypeId1 ||
- y.WorkTypeId == (int)workTypeId2)
- select y.WorkRequestId
- let z = from z in db.FmsWorkResult
- where z.SiteId == siteId &&
- z.ConfirmedDate.Value.Year == year &&
- z.ConfirmedDate.Value.Month == month &&
- z.ConfirmedDate.Value.Day == day
- select z.WorkRequestId
- where
- x.SiteId == siteId &&
- x.BusinessFieldId == businessFieldId &&
- y.Contains(x.WorkRequestId) &&
- z.Contains(x.WorkRequestId)
- orderby x.OrderDate ascending
- select new FmsWorkOrderForDailyReport
- {
- OrderDate = x.OrderDate,
- Title = x.Title
- }).ToList();
- for (int i = 0; i < list.Count; i++)
- {
- list[i].No = i + 1;
- }
- return list;
- }
- /* 자재사용현황 */
- public List<FmsMaterialForDailyReport> GetFmsMaterialForDailyReport()
- {
- var list =
- (from x in db.FmsMaterialRelease
- where
- x.SiteId == siteId &&
- x.ReleaseDate.Year == year &&
- x.ReleaseDate.Month == month &&
- x.ReleaseDate.Day == day &&
- x.BusinessFieldId == businessFieldId &&
- (x.AdjustmentTypeId == (int)AdjustmentTypeId.Regular ||
- x.AdjustmentTypeId == (int)AdjustmentTypeId.Loss)
- orderby x.ReleaseDate ascending
- select new FmsMaterialForDailyReport
- {
- ReleaseType = x.FmsMaterialCodeReleaseType.Name,
- //MaterialCode = x.FmsMaterial.MaterialCode,
- FirstClassId = x.FmsMaterial.FirstClassId,
- SecondClassId = x.FmsMaterial.SecondClassId,
- ThirdClassId = x.FmsMaterial.ThirdClassId,
- Standard = x.FmsMaterial.Standard,
- MaterialName = x.FmsMaterial.Name,
- WorkName = x.FmsWorkResult.FmsWorkOrder.Title,
- Unit = x.FmsMaterial.Unit,
- MaterialCount = (int)x.MaterialCount,
- WorkerName = x.FmsWorkResult.CmUser.Name
- }).ToList();
- for (int i = 0; i < list.Count; i++)
- {
- list[i].No = i + 1;
- }
- return list;
- }
- }
- }
- public class WorkStatus
- {
- public int WorkStatusTypeOccasional { get; set; }
- public int WorkStatusTypePeriodicInspection { get; set; }
- public int WorkStatusTypeForensicExamination { get; set; }
- public int WorkStatusTypeEtc { get; set; }
- public int WorkStatusTypeTotal { get; set; }
- public int WorkStatusPending { get; set; }
- public int WorkStatusInProgress { get; set; }
- public int WorkStatusDeferred { get; set; }
- public int WorkStatusComplete { get; set; }
- public int WorkStatusApproved { get; set; }
- public int WorkStatusTotal { get; set; }
- }
- public class FmsEnergyDailyReport
- {
- //public int FacilityCode { get; set; }
- //public int PropertyId { get; set; }
- public String Name { get; set; }
- //public int FuelTypeId { get; set; }
- public string Today { get; set; }
- public string Daybefore { get; set; }
- public string Dailyusage { get; set; }
- public string Monthusage { get; set; }
- }
- public class FmsWorkRequestForDailyReport
- {
- public int No { get; set; }
- public int WorkRequestId { get; set; }
- public int BusinessFieldId { get; set; }
- public DateTime RequestDate { get; set; }
- public String WorkTypeId { get; set; }
- public String WorkProgressId { get; set; }
- public String Title { get; set; }
- public DateTime[] TextResultDate { get; set; }
- public String[] TextResult { get; set; }
- }
- public class FmsWorkOrderForDailyReport
- {
- public int No { get; set; }
- public DateTime OrderDate { get; set; }
- public String Title { get; set; }
- }
- public class FmsMaterialForDailyReport
- {
- public int No { get; set; }
- public String ReleaseType { get; set; }
- //public String MaterialCode { get; set; }
- public Nullable<int> FirstClassId { get; set; }
- public Nullable<int> SecondClassId { get; set; }
- public Nullable<int> ThirdClassId { get; set; }
- public string StringFirstClassId { get; set; }
- public string StringSecondClassId { get; set; }
- public string StringThirdClassId { get; set; }
- public String MaterialName { get; set; }
- public String Standard { get; set; }
- public String WorkName { get; set; }
- public String Unit { get; set; }
- public int MaterialCount { get; set; }
- public String WorkerName { get; set; }
- }
- public class FmsMaterialForDailyReport2
- {
- public int No { get; set; }
- public string ReleaseType { get; set; }
- public string StringFirstClassId { get; set; }
- public string StringSecondClassId { get; set; }
- public string StringThirdClassId { get; set; }
- public string MaterialName { get; set; }
- public string Standard { get; set; }
- public string WorkName { get; set; }
- public string Unit { get; set; }
- public string MaterialCount { get; set; }
- public string WorkerName { get; set; }
- }
- public class CurrentDate
- {
- public DateTime Date { get; set; }
- }
- }
|