6345a7b74a08b8083f30a23caa31271b614d469f.svn-base 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Data.Entity;
  5. using System.Data.Entity.Infrastructure;
  6. using System.Diagnostics;
  7. using System.Linq;
  8. using System.Net;
  9. using System.Net.Http;
  10. using System.Web;
  11. using System.Web.Http;
  12. using System.Web.Http.Description;
  13. using DevExpress.XtraCharts.Native;
  14. using DevExpress.XtraPrinting.Native;
  15. using iBemsDataService;
  16. using iBemsDataService.Model;
  17. using iBemsDataService.Util;
  18. namespace iBemsDataService.Controllers
  19. {
  20. public class FmsMaterialStoredController : ApiController
  21. {
  22. private iBemsEntities db = new iBemsEntities();
  23. [ResponseType(typeof(void))]
  24. [ActionName("Store")]
  25. public IHttpActionResult PostFmsMaterialStored(FmsMaterialStored info)
  26. {
  27. // 2016 01 11 추가 hcLee
  28. info.StoredDate = TimeZoneInfo.ConvertTimeFromUtc(info.StoredDate, TimeZoneInfo.Local);
  29. if (info.PurchaseOrderId == null || info.PurchaseOrderId == 0 || info.MaterialId == 0)
  30. {
  31. return BadRequest("Not Found Parameters.");
  32. }
  33. try
  34. {
  35. // 해당 material 의 최신 입고 정보
  36. var lastestStoredItem = db.FmsMaterialStored.Where(ms =>
  37. ms.SiteId == info.SiteId && // 19.07.12
  38. ms.MaterialId == info.MaterialId)
  39. .OrderByDescending(sm => sm.MaterialStoredId)
  40. .FirstOrDefault();
  41. // 재고정보업데이트
  42. if (lastestStoredItem != null) { info.StockCount += (lastestStoredItem.StockCount+info.StoredCount); }
  43. else { info.StockCount = info.StoredCount; }
  44. // 입고테이블에 추가
  45. db.FmsMaterialStored.Add(info);
  46. db.SaveChanges();
  47. var storedMaterialList = db.FmsMaterialStored.Where(ms =>
  48. ms.SiteId == info.SiteId && // 19.07.12
  49. ms.PurchaseOrderId == info.PurchaseOrderId)
  50. //.GroupBy(ms => ms.MaterialId)
  51. //.Select(group => group.Sum(item => item.StoredCount) )
  52. .ToList();
  53. var orderedMaterialList = db.FmsMaterialPurchaseOrderMaterial.Where(mpom =>
  54. mpom.SiteId == info.SiteId && // 19.07.12
  55. mpom.PurchaseOrderId == info.PurchaseOrderId)
  56. .ToList();
  57. bool isAllStored = false;
  58. foreach (var order in orderedMaterialList)
  59. {
  60. int storedCount = storedMaterialList.Where(a=>
  61. a.MaterialId == order.MaterialId)
  62. .Sum(a=>a.StoredCount);
  63. if (order.MaterialCount > storedCount) { isAllStored = false; break; }
  64. else { isAllStored = true; }
  65. }
  66. if(isAllStored)
  67. {
  68. var requestId = db.FmsMaterialPurchaseOrder.Where(po=>
  69. po.SiteId == info.SiteId && // 19.07.12
  70. po.PurchaseOrderId == info.PurchaseOrderId )
  71. .Select(a=>a.PurchaseRequestId);
  72. var materialRequest = db.FmsMaterialPurchaseRequest.Where(mpr =>
  73. mpr.SiteId == info.SiteId && // 19.07.12
  74. mpr.PurchaseRequestId == requestId.FirstOrDefault())
  75. .FirstOrDefault();
  76. if (materialRequest != null)
  77. {
  78. materialRequest.ProgressId = (short)PurchaseProgress.MATERIAL_STORED;
  79. }
  80. db.SaveChanges();
  81. }
  82. }
  83. catch( DbUpdateException e ) { throw e; }
  84. return StatusCode( HttpStatusCode.NoContent );
  85. }
  86. [ResponseType(typeof(void))]
  87. [ActionName("Approval")]
  88. public IHttpActionResult PostFmsMaterialStored(MaterialStoredAppovalInfo info)
  89. {
  90. if (!ModelState.IsValid)
  91. {
  92. return BadRequest(ModelState);
  93. }
  94. if (info.UserId == null || info.UserId.IsEmpty() ||
  95. info.MaterialStoredList == null || info.MaterialStoredList.IsEmpty())
  96. {
  97. return BadRequest("Not Found Parameters.");
  98. }
  99. try
  100. {
  101. var materialStoredList = info.MaterialStoredList;
  102. foreach (var p in materialStoredList)
  103. {
  104. var purchaseOrder = db.FmsMaterialPurchaseOrder.Where(x =>
  105. x.SiteId == p.SiteId &&
  106. x.BusinessFieldId == p.BusinessFieldId &&
  107. x.PurchaseOrderId == p.PurchaseOrderId
  108. ).FirstOrDefault();
  109. if (purchaseOrder == null)
  110. {
  111. continue;
  112. }
  113. var materialStored = db.FmsMaterialStored.Where(x =>
  114. x.SiteId == p.SiteId &&
  115. x.BusinessFieldId == p.BusinessFieldId &&
  116. x.MaterialStoredId == p.MaterialStoredId
  117. ).FirstOrDefault();
  118. if (materialStored == null)
  119. {
  120. continue;
  121. }
  122. materialStored.ApprovalUserId = info.UserId;
  123. materialStored.ApprovalDate = DateTime.Now;
  124. materialStored.IsApproval = true;
  125. db.SaveChanges();
  126. // 발주요청과 입고를 비교하여 모두 입고되었다면 상태 변경
  127. bool isAllMaterialStored = false;
  128. foreach (var orderMaterial in purchaseOrder.FmsMaterialPurchaseOrderMaterial)
  129. {
  130. var notApprovedItem = purchaseOrder.FmsMaterialStored.Where(a =>
  131. a.SiteId == orderMaterial.SiteId && // 19.07.12
  132. a.IsApproval == false).FirstOrDefault();
  133. if (notApprovedItem != null) { isAllMaterialStored = false; break; }
  134. int storedCount = purchaseOrder.FmsMaterialStored.Where(ms =>
  135. ms.SiteId == orderMaterial.SiteId && // 19.07.12
  136. ms.MaterialId == orderMaterial.MaterialId)
  137. .Sum(a => a.StoredCount);
  138. if (orderMaterial.MaterialCount > storedCount) { isAllMaterialStored = false; break; }
  139. else { isAllMaterialStored = true; }
  140. }
  141. if (isAllMaterialStored)
  142. {
  143. purchaseOrder.FmsMaterialPurchaseRequest.ProgressId = (short)PurchaseProgress.MATERIAL_STORED_APPROVAL;
  144. db.SaveChanges();
  145. }
  146. }
  147. }
  148. catch (DbUpdateException e) { throw e; }
  149. return StatusCode(HttpStatusCode.NoContent);
  150. }
  151. protected override void Dispose(bool disposing)
  152. {
  153. if (disposing)
  154. {
  155. db.Dispose();
  156. }
  157. base.Dispose(disposing);
  158. }
  159. }
  160. public class MaterialStoredAppovalInfo
  161. {
  162. public string UserId { get; set; }
  163. public List<MaterialStored> MaterialStoredList { get; set; }
  164. }
  165. public class MaterialStored
  166. {
  167. public int SiteId { get; set; }
  168. public int BusinessFieldId { get; set; }
  169. public int MaterialStoredId { get; set; }
  170. public int PurchaseOrderId { get; set; }
  171. };
  172. }