private CompleteWOOperationSerialized.Response CompletePreviousOperations(WorkOrderOperation workOrderOperation, string serialNumber)
{
var predecessorsIds = workOrderOperation.Predecessors.Select(p => p.From_Id).Distinct().ToList();
foreach (var predecessorId in predecessorsIds)
{
var predecesor = Platform.ProjectionQuery <WorkOrderOperation>().Include(wo => wo.ToBeUsedMachines).First(wo => wo.Id == predecessorId);
int equipId = predecesor.ToBeUsedMachines.First().Machine.GetValueOrDefault();
string equipNid = Platform.ProjectionQuery <Equipment>().Where(e => e.Id == equipId).Select(e => e.NId).FirstOrDefault();
var mateialItem = Platform.ProjectionQuery <ActualProducedMaterial>().Include(pmi => pmi.MaterialItem).Where(pmi => pmi.WorkOrderOperation_Id == predecesor.Id).Where(pmi => pmi.MaterialItem.SerialNumberCode == serialNumber && pmi.PartialWorkedQuantity == 1).Select(pmi => pmi.MaterialItem).FirstOrDefault();
if (mateialItem == null)
{
continue;
}
var materialItemNId = mateialItem.NId;
var matDefId = mateialItem.MaterialDefinition;
var matDefNId = Platform.ProjectionQuery <MaterialDefinition>().Where(m => m.Id == matDefId).Select(m => m.NId).FirstOrDefault();
var completeInput = new CompleteWOOperationSerialized
{
CompleteSerializedWoOpParameter = new CompleteSerializedParameterType
{
Id = predecesor.Id,
NId = predecesor.NId,
EquipmentNId = equipNid,
ActualProducedMaterials = new List <MaterialItemParameterType>
{
new MaterialItemParameterType
{
EquipmentNId = equipNid,
MaterialDefinitionNId = matDefNId,
NId = materialItemNId,
SerialNumber = serialNumber
}
}
}
};
var completeResponse = Platform.CallCommand <CompleteWOOperationSerialized, CompleteWOOperationSerialized.Response>(completeInput);
if (!completeResponse.Succeeded)
{
return(completeResponse);
}
}
return(new CompleteWOOperationSerialized.Response());
}
private DABCompleteSerial.Response DABCompleteSerialHandler(DABCompleteSerial command)
{
var response = new DABCompleteSerial.Response();
var commandInfo = command.CompleteSerializedWoOpParameterList.First();
var actualProducedMaterial = commandInfo.ActualProducedMaterials.First();
string serialNumber = actualProducedMaterial.SerialNumber;
string workOrderOperationNId = commandInfo.NId;
string materialDefinitionNId = actualProducedMaterial.MaterialDefinitionNId;
var workOrderOperation = Platform.ProjectionQuery <WorkOrderOperation>().Include(wo => wo.ToBeUsedMachines).Include(wo => wo.Predecessors).Include(wo => wo.Successors).FirstOrDefault(wo => wo.NId == workOrderOperationNId);
int equipId = workOrderOperation.ToBeUsedMachines.First().Machine.GetValueOrDefault();
Equipment equip = Platform.ProjectionQuery <Equipment>().FirstOrDefault(e => e.Id == equipId);
if (!SerialIsCompletedOnAllPreviousOperations(workOrderOperation, serialNumber))
{
response.SetError(-1001, $"Il seriale {serialNumber} è ancora attivo sulle operazioni precedenti. Impossibile completare l'operazione");
return(response);
}
WorkOrderExt workOrderExt = Platform.ProjectionQuery <WorkOrderExt>().FirstOrDefault(woe => woe.WorkOrderId == workOrderOperation.WorkOrder_Id);
if (IsLastOperationOfOrder(workOrderOperation))
{
WorkOrder order = Platform.ProjectionQuery <WorkOrder>().FirstOrDefault(wo => wo.Id == workOrderOperation.WorkOrder_Id);
var processQuantity = Platform.ProjectionQuery <Process>().Where(p => p.Id == order.Process).Select(p => p.Quantity.Val).FirstOrDefault().GetValueOrDefault();
if (processQuantity == 0)
{
response.SetError(-1005, $"Impossiblie avanzare la produzione dell'ordine {order.NId}. Dimensione Pallet non impostata.");
return(response);
}
var inforIntConf = Platform.ProjectionQuery <ConfigurationKey>().Where(c => c.NId == "InforIntegration").Select(c => c.Val).FirstOrDefault();
if (!string.IsNullOrEmpty(inforIntConf) && inforIntConf == "true")
{
int producedQuantity = decimal.ToInt32(workOrderOperation.ProducedQuantity) + 1;
if (IsLastPieceOfPallet(workOrderOperation, processQuantity))
{
var reportOperationProg = new ReportOperationProgress
{
ErpOrder = order.ERPOrder,
OperationSequence = workOrderExt.Sequence.GetValueOrDefault(),
ProducedQuantity = producedQuantity,
IsComplete = producedQuantity == workOrderOperation.TargetQuantity,
Plant = order.Enterprise.Substring(0, order.Enterprise.Length - 4)
};
var reportOperationResponse = Platform.CallCommand <ReportOperationProgress, ReportOperationProgress.Response>(reportOperationProg);
if (!reportOperationResponse.Succeeded)
{
response.SetError(reportOperationResponse.Error.ErrorCode, reportOperationResponse.Error.ErrorMessage);
return(response);
}
var reportQuantity = new ReportProducedQuantity
{
ErpOrder = order.ERPOrder,
CloseOrder = IsLastSerialOfLastOperationOfERPOrder(workOrderOperation, workOrderExt),
Plant = order.Enterprise.Substring(0, order.Enterprise.Length - 4),
Warehouse = workOrderExt.Warehouse
};
var reportQuantityResponse = Platform.CallCommand <ReportProducedQuantity, ReportProducedQuantity.Response>(reportQuantity);
if (!reportQuantityResponse.Succeeded)
{
response.SetError(reportQuantityResponse.Error.ErrorCode, reportQuantityResponse.Error.ErrorMessage);
return(response);
}
}
}
}
var mateialItem = Platform.ProjectionQuery <ActualProducedMaterial>().Include(pmi => pmi.MaterialItem).Where(pmi => pmi.WorkOrderOperation_Id == workOrderOperation.Id).Where(pmi => pmi.MaterialItem.SerialNumberCode == serialNumber).Select(pmi => pmi.MaterialItem).Distinct().ToDictionary(mi => mi.NId, mi => mi.MaterialDefinition).FirstOrDefault();
var materialItemNId = mateialItem.Key;
var matDefId = mateialItem.Value;
var matDefNId = Platform.ProjectionQuery <MaterialDefinition>().Where(m => m.Id == matDefId).Select(m => m.NId).FirstOrDefault();
var completeInput = new CompleteWOOperationSerialized
{
CompleteSerializedWoOpParameter = new CompleteSerializedParameterType
{
Id = workOrderOperation.Id,
NId = workOrderOperation.NId,
EquipmentNId = equip.NId,
ActualProducedMaterials = new List <MaterialItemParameterType>
{
new MaterialItemParameterType
{
EquipmentNId = equip.NId,
MaterialDefinitionNId = matDefNId,
NId = materialItemNId,
SerialNumber = serialNumber
}
}
}
};
var completeResponse = Platform.CallCommand <CompleteWOOperationSerialized, CompleteWOOperationSerialized.Response>(completeInput);
if (!completeResponse.Succeeded)
{
response.SetError(completeResponse.Error.ErrorCode, completeResponse.Error.ErrorMessage);
}
if (IsLastOperationOfOrder(workOrderOperation))
{
var niceLabelIntegration = Platform.ProjectionQuery <ConfigurationKey>().Where(c => c.NId == "NiceLabelIntegration").Select(c => c.Val).FirstOrDefault();
if (!string.IsNullOrEmpty(niceLabelIntegration) && niceLabelIntegration == "true")
{
var printPackageAndDataLabels = new PrintPackageDataLabel
{
ProductCode = materialDefinitionNId,
WorkArea = equip.Parent,
SerialNumbers = new List <string> {
serialNumber
}
};
var printPackageAndDataResponse = Platform.CallCommand <PrintPackageDataLabel, PrintPackageDataLabel.Response>(printPackageAndDataLabels);
if (!printPackageAndDataResponse.Succeeded)
{
response.SetError(printPackageAndDataResponse.Error.ErrorCode, printPackageAndDataResponse.Error.ErrorMessage);
return(response);
}
}
//if(IsLastSerialOfLastOperationOfERPOrder(workOrderOperation,workOrderExt))
//{
var today = DateTime.UtcNow;
Platform.CallCommand <SetProducedPieces, SetProducedPieces.Response>(new SetProducedPieces
{
Year = today.Year,
Month = today.Month,
Day = today.Day,
WorkOrderId = workOrderExt.WorkOrderId,
WorkArea = equip.Parent
});
//}
//print package & data label
//if (!string.IsNullOrEmpty(niceLabelIntegration) && niceLabelIntegration == "true")
//{
// if (IsLastPieceOfPallet(workOrderOperation, processQuantity))
// {
// var printPalletLabel = new PrintPalletLabel
// {
// ProductCode = materialDefinitionNId,
// WorkArea = equip.Parent,
// SerialNumbers = new List<string>(),
// Quantity = 1
// };
// var printPalletResponse = Platform.CallCommand<PrintPalletLabel, PrintPalletLabel.Response>(printPalletLabel);
// if (!printPalletResponse.Succeeded)
// {
// response.SetError(printPalletResponse.Error.ErrorCode, printPalletResponse.Error.ErrorMessage);
// return response;
// }
// }
//}
}
Platform.CallCommand <FireUpdateAndonEvent, FireUpdateAndonEvent.Response>(new FireUpdateAndonEvent(equip.Parent));
return(response);
}
