public async Task <ProductionOrderReportDetailViewModel> GetDetailReport(long no)
{
var query = (from a in DbContext.ProductionOrder_Details
join b in DbContext.ProductionOrder on a.ProductionOrderModel.Id equals b.Id
where a.IsDeleted == false &&
b.IsDeleted == false &&
b.Id == no
select new ProductionOrderDetailViewModel
{
orderNo = b.OrderNo,
orderQuantity = a.Quantity,
uom = a.UomUnit
}).ToList();
var sppNo = "";
foreach (var spp in query)
{
sppNo = spp.orderNo; break;
}
ProductionOrderReportDetailViewModel detail = new ProductionOrderReportDetailViewModel();
detail.SPPList = query;
detail.QCList = await GetFabricQualityItems(sppNo);
detail.DailyOPList = await GetDailyOperationItems(sppNo);
return(detail);
}
public async Task <IActionResult> GetDetail([FromRoute] long no)
{
try
{
VerifyUser();
ProductionOrderReportDetailViewModel model = await _facade.GetDetailReport(no);
return(Ok(new
{
apiVersion = ApiVersion,
statusCode = General.OK_STATUS_CODE,
message = General.OK_MESSAGE,
data = model,
}));
}
catch (Exception e)
{
Dictionary <string, object> Result =
new ResultFormatter(ApiVersion, General.INTERNAL_ERROR_STATUS_CODE, e.Message)
.Fail();
return(StatusCode(General.INTERNAL_ERROR_STATUS_CODE, Result));
}
}
