//20170329 add by wangrm for P001-170316001======start======= private DependencyObjectCollection QueryBcFrozen(string scanBarcode) { QueryNode node = OOQL.Select(OOQL.CreateProperty("BC_RECORD.BARCODE_NO", "barcode_no"), OOQL.CreateProperty("ITEM.ITEM_CODE", "item_no"), OOQL.CreateProperty("ITEM.ITEM_NAME", "item_name"), OOQL.CreateProperty("ITEM.ITEM_SPECIFICATION", "item_spec"), OOQL.CreateProperty("ITEM_FEATURE.ITEM_FEATURE_CODE", "item_feature_no"), OOQL.CreateProperty("ITEM_FEATURE.ITEM_SPECIFICATION", "item_feature_name"), Formulas.Case(null, OOQL.CreateConstants("N"), OOQL.CreateCaseArray( OOQL.CreateCaseItem(((OOQL.CreateProperty("BC_RECORD.FROZEN_STATUS") != OOQL.CreateEmptyConstants()) & (OOQL.CreateProperty("BC_RECORD.FROZEN_STATUS") != OOQL.CreateNullConstant())), OOQL.CreateProperty("BC_RECORD.FROZEN_STATUS"))), "frozen"), OOQL.CreateConstants(string.Empty, "warehouse_no"), OOQL.CreateConstants(string.Empty, "storage_spaces_no"), OOQL.CreateConstants(string.Empty, "lot_no"), OOQL.CreateConstants(0m, "inventory_qty"), OOQL.CreateConstants(string.Empty, "inventory_unit")) .From("BC_RECORD", "BC_RECORD") .LeftJoin("ITEM", "ITEM") .On(OOQL.CreateProperty("BC_RECORD.ITEM_ID") == OOQL.CreateProperty("ITEM.ITEM_ID")) .LeftJoin("ITEM.ITEM_FEATURE", "ITEM_FEATURE") .On(OOQL.CreateProperty("BC_RECORD.ITEM_FEATURE_ID") == OOQL.CreateProperty("ITEM_FEATURE.ITEM_FEATURE_ID")) .Where(OOQL.CreateProperty("BC_RECORD.BARCODE_NO") == OOQL.CreateConstants(scanBarcode)); return(GetService <IQueryService>().ExecuteDependencyObject(node)); }