| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166 | 
							- using System;
 
- using System.Collections.Generic;
 
- using System.ComponentModel.DataAnnotations;
 
- using System.Data;
 
- using System.Data.Entity;
 
- using System.Data.Entity.Infrastructure;
 
- using System.Linq;
 
- using System.Net;
 
- using System.Net.Http;
 
- using System.Web.Http;
 
- using System.Web.Http.Description;
 
- using System.Web.Http.OData;
 
- using iBemsDataService;
 
- using iBemsDataService.Model;
 
- namespace iBemsDataService.Controllers
 
- {
 
-     public class FmsMaterialStockHistoryMonthlyController : ODataController
 
-     {
 
-         private iBemsEntities db = new iBemsEntities();
 
-         // GET: odata/FmsMaterialStockHistoryMonthly
 
-         [Queryable]
 
-         public List<FmsMaterialStockHistoryMonthly> GetFmsMaterialStockHistoryMonthly()
 
-         {
 
-             List<FmsMaterialStockHistoryMonthly> dailiyHistoryList = new List<FmsMaterialStockHistoryMonthly>();
 
-             var storedList = db.FmsMaterialStored
 
-                 .Where(ms => ms.IsApproval == true)
 
-                 .ToList();
 
-             var releaseList = db.FmsMaterialRelease
 
-                 .Where(mr => mr.IsConfirmed == true)
 
-                 .ToList();
 
-             // 입고정보로 데이터 생성 
 
-             foreach (var item in storedList)
 
-             {
 
-                 var dailyStoredInfo = dailiyHistoryList
 
-                     .Where(d => d.MaterialId == item.MaterialId
 
-                         && d.YearMonthDate.Year == item.StoredDate.Year
 
-                         && d.YearMonthDate.Month == item.StoredDate.Month)
 
-                     .FirstOrDefault();
 
-                 if (dailyStoredInfo == null)
 
-                 {
 
-                     FmsMaterialStockHistoryMonthly d = new FmsMaterialStockHistoryMonthly()
 
-                     {
 
-                         SiteId = item.SiteId,
 
-                         BusinessFieldId = item.BusinessFieldId,
 
-                         BusinessFieldName = item.CmBusinessField.Name,
 
-                         Unit = item.FmsMaterial.Unit,
 
-                         Standard = item.FmsMaterial.Standard,
 
-                         YearMonthDate = new DateTime(item.StoredDate.Year, item.StoredDate.Month, item.StoredDate.Day),
 
-                         YearMonth = new DateTime(item.StoredDate.Year, item.StoredDate.Month, 1),
 
-                         MaterialId = item.MaterialId,
 
-                         MaterialName = item.FmsMaterial.Name,
 
-                         MaterialCode = item.FmsMaterial.MaterialCode,
 
-                         StoredCount = item.StoredCount,
 
-                         StockCount = item.StockCount,
 
-                         StockAmount = (item.StoredCount * item.UnitCost),//+ dailiyHistoryList.Where(b => b.MaterialId == item.MaterialId).Sum(c => c.StockAmount),
 
-                         FirstClassId = item.FmsMaterial.FirstClassId != null ? item.FmsMaterial.FirstClassId.Value : 0,
 
-                         SecondClassId = item.FmsMaterial.SecondClassId != null ? item.FmsMaterial.SecondClassId.Value : 0,
 
-                         ThirdClassId = item.FmsMaterial.ThirdClassId != null ? item.FmsMaterial.ThirdClassId.Value : 0,
 
-                     };
 
-                     dailiyHistoryList.Add(d);
 
-                 }
 
-                 else
 
-                 {
 
-                     dailyStoredInfo.StoredCount += item.StoredCount;
 
-                     dailyStoredInfo.StockCount = item.StockCount;
 
-                     dailyStoredInfo.StockAmount += (item.StoredCount * item.UnitCost); // + dailiyHistoryList.Where(b => b.MaterialId == item.MaterialId).Sum(c => c.StockAmount);
 
-                 }
 
-             }
 
-             // 출고 정보로 데이터 생성
 
-             foreach (var item in releaseList)
 
-             {
 
-                 var dailyReleasedInfo = dailiyHistoryList
 
-                 .Where(d => d.MaterialId == item.MaterialId
 
-                     && d.YearMonthDate.Year == item.ReleaseDate.Year
 
-                     && d.YearMonthDate.Month == item.ReleaseDate.Month)
 
-                 .FirstOrDefault();
 
-                 if (dailyReleasedInfo == null)
 
-                 {
 
-                     FmsMaterialStockHistoryMonthly d = new FmsMaterialStockHistoryMonthly()
 
-                     {
 
-                         SiteId = item.SiteId,
 
-                         BusinessFieldId = item.BusinessFieldId,
 
-                         BusinessFieldName = item.CmBusinessField.Name,
 
-                         Unit = item.FmsMaterial.Unit,
 
-                         Standard = item.FmsMaterial.Standard,
 
-                         YearMonthDate = new DateTime(item.ReleaseDate.Year, item.ReleaseDate.Month, item.ReleaseDate.Day),
 
-                         YearMonth = new DateTime(item.ReleaseDate.Year, item.ReleaseDate.Month, 1),
 
-                         MaterialId = item.MaterialId.Value,
 
-                         MaterialName = item.FmsMaterial.Name,
 
-                         MaterialCode = item.FmsMaterial.MaterialCode,
 
-                         StoredCount = 0,
 
-                         ReleaseCount = item.AdjustmentTypeId == 0 ? item.MaterialCount.Value : 0,
 
-                         ReleaseLossCount = item.AdjustmentTypeId == 1 ? item.MaterialCount.Value : 0,
 
-                         ReleaseReturnCount = item.AdjustmentTypeId == 2 ? item.MaterialCount.Value : 0,
 
-                         FirstClassId = item.FmsMaterial.FirstClassId != null ? item.FmsMaterial.FirstClassId.Value : 0,
 
-                         SecondClassId = item.FmsMaterial.SecondClassId != null ? item.FmsMaterial.SecondClassId.Value : 0,
 
-                         ThirdClassId = item.FmsMaterial.ThirdClassId != null ? item.FmsMaterial.ThirdClassId.Value : 0,
 
-                     };
 
-                     // StockCount 를 체크하기 위한 코드 
 
-                     var tempStoredInfo = dailiyHistoryList
 
-                         .Where(h => h.MaterialId == item.MaterialId)
 
-                         .OrderByDescending(m => m.YearMonthDate)
 
-                         .Take(1).FirstOrDefault();
 
-                     if (tempStoredInfo == null) { continue; }
 
-                     d.StockCount = tempStoredInfo.StockCount - d.ReleaseCount - d.ReleaseLossCount + d.ReleaseReturnCount;
 
-                     if (item.AdjustmentTypeId == 2)
 
-                     {
 
-                         d.StockAmount = tempStoredInfo.StockAmount + item.ReleaseTotalCost.Value;
 
-                     }
 
-                     else
 
-                     {
 
-                         d.StockAmount = tempStoredInfo.StockAmount - item.ReleaseTotalCost.Value;
 
-                     }
 
-                     dailiyHistoryList.Add(d);
 
-                 }
 
-                 else
 
-                 {
 
-                     if (item.AdjustmentTypeId == 2)
 
-                     {
 
-                         dailyReleasedInfo.ReleaseReturnCount += item.MaterialCount.Value;
 
-                         dailyReleasedInfo.StockCount += item.MaterialCount.Value;
 
-                         dailyReleasedInfo.StockAmount += item.ReleaseTotalCost.Value;
 
-                     }
 
-                     else if (item.AdjustmentTypeId == 1)
 
-                     {
 
-                         dailyReleasedInfo.ReleaseLossCount += item.MaterialCount.Value;
 
-                         dailyReleasedInfo.StockCount -= item.MaterialCount.Value;
 
-                         dailyReleasedInfo.StockAmount -= item.ReleaseTotalCost.Value;
 
-                     }
 
-                     else if (item.AdjustmentTypeId == 0)
 
-                     {
 
-                         dailyReleasedInfo.ReleaseCount += item.MaterialCount.Value;
 
-                         dailyReleasedInfo.StockCount -= item.MaterialCount.Value;
 
-                         dailyReleasedInfo.StockAmount -= item.ReleaseTotalCost.Value;
 
-                     }
 
-                 }
 
-             }
 
-             return dailiyHistoryList;
 
-         }
 
-         protected override void Dispose(bool disposing)
 
-         {
 
-             if (disposing)
 
-             {
 
-                 db.Dispose();
 
-             }
 
-             base.Dispose(disposing);
 
-         }
 
-     }
 
- }
 
 
  |