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