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