| 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; }    };}
 |