/// <summary>
/// - Search all work order line have status MfgClose and have Due Date between FromDueDate and ToDueDate
/// - after search work order line succeed, we need to update OpenQuantity column for each work order line
/// Open Quantity = WorkOrderLine.OrderQuantity - Completed Quantity - Scrap Quantity
/// + Completed Quantity = PRO_WorkOrderCompletionDS.GetCompletedQuantity(WorkOrderMasterID, WorkOrderDetailID)
/// + Scrap Quantity = PRO_AssemblyScrapMasterDS.GetScrapQuantity(WorkOrderMasterID, WorkOrderDetailID) + PRO_OperationScrapMasterDS.GetScrapQuantity(WorkOrderMasterID, WorkOrderDetailID)
/// </summary>
/// <param name="pdtmFromDueDate">From due date of work order line</param>
/// <param name="pdtmToDueDate">To due date of work order line</param>
/// <returns>All work order line have status is Released</returns>
public DataSet SearchMfgCloseWOLines(int pintCCNID, int pintMasterLocationID, DateTime pdtmFromDueDate, DateTime pdtmToDueDate)
{
try
{
dsPRO_WorkOrderDetail = new PRO_WorkOrderDetailDS();
return(dsPRO_WorkOrderDetail.SearchWOForClose(WOLineStatus.MfgClose, pintCCNID, pintMasterLocationID, pdtmFromDueDate, pdtmToDueDate));
}
catch (PCSDBException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public DataSet SearchReleasedWO(int pintCCNID, int pintMasterLocationID, DateTime pdtmFromDueDate, DateTime pdtmToDueDate)
{
dsPRO_WorkOrderDetail = new PRO_WorkOrderDetailDS();
return(dsPRO_WorkOrderDetail.SearchWOForClose(WOLineStatus.Released, pintCCNID, pintMasterLocationID, pdtmFromDueDate, pdtmToDueDate));
}
