123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214 |
- using System;
- using System.Collections.Generic;
- using System.Data;
- using System.Data.Entity;
- using System.Data.Entity.Infrastructure;
- using System.Diagnostics;
- using System.Linq;
- using System.Net;
- using System.Net.Http;
- using System.Web;
- using System.Web.Http;
- using System.Web.Http.Description;
- using DevExpress.XtraCharts.Native;
- using DevExpress.XtraPrinting.Native;
- using iBemsDataService;
- using iBemsDataService.Model;
- using iBemsDataService.Util;
- namespace iBemsDataService.Controllers
- {
- public class FmsMaterialStoredController : ApiController
- {
- private iBemsEntities db = new iBemsEntities();
- [ResponseType(typeof(void))]
- [ActionName("Store")]
- public IHttpActionResult PostFmsMaterialStored(FmsMaterialStored info)
- {
- // 2016 01 11 추가 hcLee
- info.StoredDate = TimeZoneInfo.ConvertTimeFromUtc(info.StoredDate, TimeZoneInfo.Local);
- if (info.PurchaseOrderId == null || info.PurchaseOrderId == 0 || info.MaterialId == 0)
- {
- return BadRequest("Not Found Parameters.");
- }
- try
- {
- // 해당 material 의 최신 입고 정보
- var lastestStoredItem = db.FmsMaterialStored.Where(ms =>
- ms.SiteId == info.SiteId && // 19.07.12
- ms.MaterialId == info.MaterialId)
- .OrderByDescending(sm => sm.MaterialStoredId)
- .FirstOrDefault();
- // 재고정보업데이트
- if (lastestStoredItem != null) { info.StockCount += (lastestStoredItem.StockCount+info.StoredCount); }
- else { info.StockCount = info.StoredCount; }
- // 입고테이블에 추가
- db.FmsMaterialStored.Add(info);
- db.SaveChanges();
- var storedMaterialList = db.FmsMaterialStored.Where(ms =>
- ms.SiteId == info.SiteId && // 19.07.12
- ms.PurchaseOrderId == info.PurchaseOrderId)
- //.GroupBy(ms => ms.MaterialId)
- //.Select(group => group.Sum(item => item.StoredCount) )
- .ToList();
- var orderedMaterialList = db.FmsMaterialPurchaseOrderMaterial.Where(mpom =>
- mpom.SiteId == info.SiteId && // 19.07.12
- mpom.PurchaseOrderId == info.PurchaseOrderId)
- .ToList();
- bool isAllStored = false;
- foreach (var order in orderedMaterialList)
- {
- int storedCount = storedMaterialList.Where(a=>
- a.MaterialId == order.MaterialId)
- .Sum(a=>a.StoredCount);
- if (order.MaterialCount > storedCount) { isAllStored = false; break; }
- else { isAllStored = true; }
- }
-
- if(isAllStored)
- {
- var requestId = db.FmsMaterialPurchaseOrder.Where(po=>
- po.SiteId == info.SiteId && // 19.07.12
- po.PurchaseOrderId == info.PurchaseOrderId )
- .Select(a=>a.PurchaseRequestId);
- var materialRequest = db.FmsMaterialPurchaseRequest.Where(mpr =>
- mpr.SiteId == info.SiteId && // 19.07.12
- mpr.PurchaseRequestId == requestId.FirstOrDefault())
- .FirstOrDefault();
- if (materialRequest != null)
- {
- materialRequest.ProgressId = (short)PurchaseProgress.MATERIAL_STORED;
- }
- db.SaveChanges();
- }
- }
- catch( DbUpdateException e ) { throw e; }
-
- return StatusCode( HttpStatusCode.NoContent );
- }
- [ResponseType(typeof(void))]
- [ActionName("Approval")]
- public IHttpActionResult PostFmsMaterialStored(MaterialStoredAppovalInfo info)
- {
- if (!ModelState.IsValid)
- {
- return BadRequest(ModelState);
- }
- if (info.UserId == null || info.UserId.IsEmpty() ||
- info.MaterialStoredList == null || info.MaterialStoredList.IsEmpty())
- {
- return BadRequest("Not Found Parameters.");
- }
- try
- {
- var materialStoredList = info.MaterialStoredList;
- foreach (var p in materialStoredList)
- {
- var purchaseOrder = db.FmsMaterialPurchaseOrder.Where(x =>
- x.SiteId == p.SiteId &&
- x.BusinessFieldId == p.BusinessFieldId &&
- x.PurchaseOrderId == p.PurchaseOrderId
- ).FirstOrDefault();
- if (purchaseOrder == null)
- {
- continue;
- }
- var materialStored = db.FmsMaterialStored.Where(x =>
- x.SiteId == p.SiteId &&
- x.BusinessFieldId == p.BusinessFieldId &&
- x.MaterialStoredId == p.MaterialStoredId
- ).FirstOrDefault();
- if (materialStored == null)
- {
- continue;
- }
- materialStored.ApprovalUserId = info.UserId;
- materialStored.ApprovalDate = DateTime.Now;
- materialStored.IsApproval = true;
- db.SaveChanges();
- // 발주요청과 입고를 비교하여 모두 입고되었다면 상태 변경
- bool isAllMaterialStored = false;
- foreach (var orderMaterial in purchaseOrder.FmsMaterialPurchaseOrderMaterial)
- {
- var notApprovedItem = purchaseOrder.FmsMaterialStored.Where(a =>
- a.SiteId == orderMaterial.SiteId && // 19.07.12
- a.IsApproval == false).FirstOrDefault();
- if (notApprovedItem != null) { isAllMaterialStored = false; break; }
-
- int storedCount = purchaseOrder.FmsMaterialStored.Where(ms =>
- ms.SiteId == orderMaterial.SiteId && // 19.07.12
- ms.MaterialId == orderMaterial.MaterialId)
- .Sum(a => a.StoredCount);
- if (orderMaterial.MaterialCount > storedCount) { isAllMaterialStored = false; break; }
- else { isAllMaterialStored = true; }
- }
- if (isAllMaterialStored)
- {
- purchaseOrder.FmsMaterialPurchaseRequest.ProgressId = (short)PurchaseProgress.MATERIAL_STORED_APPROVAL;
- db.SaveChanges();
- }
- }
- }
- catch (DbUpdateException e) { throw e; }
- return StatusCode(HttpStatusCode.NoContent);
- }
- protected override void Dispose(bool disposing)
- {
- if (disposing)
- {
- db.Dispose();
- }
- base.Dispose(disposing);
- }
- }
- public class MaterialStoredAppovalInfo
- {
- public string UserId { get; set; }
- public List<MaterialStored> MaterialStoredList { get; set; }
- }
- public class MaterialStored
- {
- public int SiteId { get; set; }
- public int BusinessFieldId { get; set; }
- public int MaterialStoredId { get; set; }
- public int PurchaseOrderId { get; set; }
- };
- }
|