| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169 | 
							- 
 
- 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.Web;
 
- 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 FmsMaterialPurchaseRequestExController : ODataController
 
-     {
 
-         private iBemsEntities db = new iBemsEntities();
 
-         // GET: odata/FmsMaterialPurchaseRequestEx
 
-         [Queryable]
 
-         public List<FmsMaterialPurchaseRequestEx> GetFmsMaterialPurchaseRequestEx()
 
-         {
 
-             // 2019.07.12
 
-             Uri uri = Request.RequestUri;
 
-             var uriQuery = HttpUtility.ParseQueryString(uri.Query);
 
-             int siteId;
 
-             if (int.TryParse(uriQuery.Get("SiteId"), out siteId) == false)
 
-             {
 
-                 throw new Exception("Not Found Parameters.");
 
-             }
 
-             var mterials = (
 
-                 from m in db.FmsMaterialPurchaseRequest.Where(x => x.SiteId == siteId) // 2019.07.12
 
-                 select new FmsMaterialPurchaseRequestEx
 
-                 {
 
-                     SiteId = m.SiteId,
 
-                     BusinessFieldId = m.BusinessFieldId,
 
-                     //CmBusinessField = m.CmBusinessField,
 
-                     PurchaseRequestId = m.PurchaseRequestId,
 
-                     PurchaseTypeId = m.PurchaseTypeId,
 
-                     RequestDate = m.RequestDate,
 
-                     RequestUserId = m.RequestUserId,
 
-                     PurchaseHopeDate = m.PurchaseHopeDate,
 
-                     Title = m.Title,
 
-                     Reason = m.Reason,
 
-                     ProgressId = m.ProgressId,
 
-                     ApprovalDate = m.ApprovalDate,
 
-                     ApprovalUserId = m.ApprovalUserId,
 
-                     bSameOrder2 = true,
 
-                 }
 
-             ).ToList();
 
-             foreach (var m in mterials)
 
-             {
 
-                 m.CmBusinessField_Name = GetCmBusinessField_Name(m.BusinessFieldId);
 
-                 m.FmsMaterialCodeProgress_Name = GetFmsMaterialCodeProgress_Name(m.ProgressId);
 
-                 m.RequestUserId_Name = GetUserId_Name(m.RequestUserId);
 
-                 m.ApprovalUserId_Name = GetUserId_Name(m.ApprovalUserId);
 
-             }
 
-                     /*
 
-             var historyAllList = GetFmsMaterialStockHistory();
 
-             foreach (var material in mterials)
 
-             {
 
-                 var temp = historyAllList.Where(m => m.MaterialId == material.MaterialId).FirstOrDefault();
 
-                 if (temp != null)
 
-                 {
 
-                     material.StockCount = temp.StockCount;
 
-                     material.StockAmount = temp.StockAmount;
 
-                     //hcLee 2015 11 11
 
-                     material.WarehouseId = temp.WarehouseId;
 
-                     material.WHouseName = GetWHouseName(temp.WarehouseId);
 
-                 }
 
-             }
 
-             #region === Obslote ===
 
-             //foreach (var item in mterials)
 
-             //{
 
-             //    var lastestStockInfo = item.FmsMaterialStored
 
-             //        .Where(ms=>ms.IsApproval == true)
 
-             //        .OrderByDescending(ms => ms.MaterialStoredId)
 
-             //        .Take(1).FirstOrDefault();
 
-             //    if (lastestStockInfo == null) // Sotred 정보가 없는 경우
 
-             //    {
 
-             //        item.StockCount = 0;
 
-             //        item.StockAmount = 0;
 
-             //        continue;
 
-             //    }
 
-             //    var releasedMaterials = item.FmsMaterialRelease
 
-             //        .Where(mr=>mr.IsConfirmed == true )
 
-             //        .ToList();
 
-             //    if (releasedMaterials.Count == 0) // Release 정보가 없는 경우
 
-             //    {
 
-             //        item.StockCount = lastestStockInfo.StockCount;
 
-             //        item.StockAmount = lastestStockInfo.StockCount * lastestStockInfo.UnitCost;
 
-             //        continue;
 
-             //    }
 
-             //    var releaseCount = releasedMaterials.Where(r2 => r2.AdjustmentTypeId != 2).Sum(r2 => r2.MaterialCount).Value;
 
-             //    var releaseTotalAmount = releasedMaterials.Where(r2 => r2.AdjustmentTypeId != 2).Sum(r2 => r2.ReleaseTotalCost).Value;
 
-             //    var releaseReturnCount = releasedMaterials.Where(r2 => r2.AdjustmentTypeId == 2).Sum(r2 => r2.MaterialCount).Value;
 
-             //    var releaseReturnTotalAmount = releasedMaterials.Where(r2 => r2.AdjustmentTypeId == 2).Sum(r2 => r2.ReleaseTotalCost).Value;
 
-             //    item.StockCount = lastestStockInfo.StockCount - releaseCount + releaseReturnCount;
 
-             //    item.StockAmount = (lastestStockInfo.StockCount * lastestStockInfo.UnitCost) - releaseTotalAmount + releaseReturnTotalAmount;
 
-             //}
 
-             #endregion
 
-                       */
 
-             return mterials.ToList();
 
-         }
 
-         private string GetCmBusinessField_Name(int id)
 
-         {
 
-             var W = db.CmBusinessField
 
-                 .Where(mr => mr.BusinessFieldId == id)
 
-                 .FirstOrDefault();
 
-             if (W == null) return "";
 
-             else return W.Name;
 
-         }
 
-         private string GetFmsMaterialCodeProgress_Name(int id)
 
-         {
 
-             var W = db.FmsMaterialCodeProgress
 
-                 .Where(mr => mr.ProgressId == id)
 
-                 .FirstOrDefault();
 
-             if (W == null) return "";
 
-             else return W.Name;
 
-         }
 
-         private string GetUserId_Name(string id)
 
-         {
 
-             var W = db.CmUser
 
-                 .Where(mr => mr.UserId == id)
 
-                 .FirstOrDefault();
 
-             if (W == null) return "";
 
-             else return W.Name;
 
-         }
 
-         protected override void Dispose(bool disposing)
 
-         {
 
-             if (disposing)
 
-             {
 
-                 db.Dispose();
 
-             }
 
-             base.Dispose(disposing);
 
-         }
 
-     }
 
- }
 
 
  |