/// <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)); }