/// <summary>
/// 获取后道工序、工艺
/// </summary>
/// <param name="moRoutingDId"></param>
/// <returns></returns>
private DependencyObject GetMoRouting(object moRoutingDId)
{
QueryNode node =
OOQL.Select(1,
OOQL.CreateProperty("mrd.MO_ROUTING_D_ID", "MO_ROUTING_D_ID"),
OOQL.CreateProperty("mrd.OPERATION_ID", "OPERATION_ID"))
.From("MO_ROUTING.MO_ROUTING_D", "mrd")
.InnerJoin("OPERATION", "o")
.On((OOQL.CreateProperty("o.OPERATION_ID") == OOQL.CreateProperty("mrd.OPERATION_ID")))
.Where((OOQL.AuthFilter("MO_ROUTING.MO_ROUTING_D", "mrd"))
& OOQL.Exists(
OOQL.Select(
OOQL.CreateConstants(1, GeneralDBType.Int32, "IS_OK"))
.From("MO_ROUTING.MO_ROUTING_D.MO_ROUTING_PATH", "mrp")
.InnerJoin("MO_ROUTING.MO_ROUTING_D", "mrd2")
.On((OOQL.CreateProperty("mrd2.MO_ROUTING_D_ID") ==
OOQL.CreateProperty("mrp.MO_ROUTING_D_ID")))
.Where((OOQL.CreateProperty("mrp.MO_ROUTING_D_ID") == OOQL.CreateConstants(moRoutingDId))
& (OOQL.CreateProperty("mrp.TO_SEQ") == OOQL.CreateProperty("mrd.OPERATION_SEQ"))
& (OOQL.CreateProperty("mrd.MO_ROUTING_ID") == OOQL.CreateProperty("mrd2.MO_ROUTING_ID")))));
DependencyObjectCollection moRoutings = GetService <IQueryService>().ExecuteDependencyObject(node);
return(moRoutings.Count > 0 ? moRoutings[0] : new DependencyObject(moRoutings.ItemDependencyObjectType));
}
