private List <QueryProperty> GetQueryProperty(string siteNo)
{
List <QueryProperty> properties = OOQL.CreateProperties("ITEM.ITEM_CODE|item_no" //品号
, "ITEM.ITEM_NAME|item_name" //品名
, "ITEM.ITEM_SPECIFICATION|item_spec" //规格
, "ITEM_FEATURE.ITEM_FEATURE_CODE|item_feature_no" //特征码
, "ITEM_FEATURE.ITEM_SPECIFICATION|item_feature_name" //特征码规格
, "UNIT.UNIT_CODE|inventory_unit" //单位编号
).ToList <QueryProperty>();
//常量
properties.Add(OOQL.CreateConstants("99", "enterprise_no")); //企业编号
properties.Add(OOQL.CreateConstants(siteNo, "site_no")); //营运据点
properties.Add(OOQL.CreateConstants("", "warehouse_no")); //库位编号
properties.Add(OOQL.CreateConstants("", "storage_spaces_no")); //储位编号
properties.Add(OOQL.CreateConstants("", "last_transaction_date")); //最后异动日期
//properties.Add(OOQL.CreateConstants(0, "result")); //状态码
//properties.Add(OOQL.CreateConstants("", "message")); //错误信息
return(properties);
}
