存储xml分析

《存储xml分析》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、1MODIFYOYMXYYG4C7IN9XGPOYRI0P0PG62YW6TL1//为0表示不需更改数据3//Size大小需和要保存的属性个数相等ID必须有值IDJ

2、I7F7IXWRYFN5RPZDUUINV7PILCTAZQ0MaterialGroupB01VendorMaterialNumber其他Model中的属性不作为保存条件则将PropertySet的Size减1Name

3、B01要保存多条记录时，InstanceSet下的Size值为要保存的记录数，每个Instance标签表示一条记录。DataTypeId标签标示对应存储的ModelId解析时先将字段插入临时表中，然后将临时表中数据更新/插入数据表：[INSERTINTO"AT_ASSET_TRANS_A_ITEM"("MASTER_FK","ACCEP

4、TER_FK","ACCEPTER_ORG_FK","ACCEPTER_COST_CNTR_FK","SUCCESS","ASSET_FK","EFFECT","ASSET_OLD_NUM","USER_FK","USER_ORG_FK","MODEL_NUMBER","AA_CODE","REMARK","SAP_INFO","ID","ASSET_NAME","SERIAL_NUM","ASSET_CLASS_FK","ASSET_SUB_CLASS_FK","LOW_VALUE_FLAG","DEPRECIATION_FK

5、","ASSET_NUM","ASSET_SUB_NUM","CURRENCY_FK","MEASURE_UNIT_FK","COMPANY_FK","PLANT_FK","COST_CNTR_FK","OWNER_ORG_FK","OWNER_FK","VENDOR_FK","VENDOR_NAME","STR_LOC_FK","ROOM","ORIGIN_VALUE","BOOK_VALUE","QTY","USEFUL_YEAR","USEFUL_MONTH","DATE_ACQUIRE","TRANS_TYPE_FK",

6、"ASSET_MEMO")SELECT"MASTER_FK","ACCEPTER_FK","ACCEPTER_ORG_FK","ACCEPTER_COST_CNTR_FK","SUCCESS","ASSET_FK","EFFECT","ASSET_OLD_NUM","USER_FK","USER_ORG_FK","MODEL_NUMBER","AA_CODE","REMARK","SAP_INFO","ID","ASSET_NAME","SERIAL_NUM","ASSET_CLASS_FK","ASSET_SUB_CLASS_

7、FK","LOW_VALUE_FLAG","DEPRECIATION_FK","ASSET_NUM","ASSET_SUB_NUM","CURRENCY_FK","MEASURE_UNIT_FK","COMPANY_FK","PLANT_FK","COST_CNTR_FK","OWNER_ORG_FK","OWNER_FK","VENDOR_FK","VENDOR_NAME","STR_LOC_FK","ROOM","ORIGIN_VALUE","BOOK_VALUE","QTY","USEFUL_YEAR","USEFUL_M

8、ONTH","DATE_ACQUIRE","TRANS_TYPE_FK","ASSET_MEMO"FROM"AT_ASSET_TRANS_A_ITEM_XXBHQWSWYF"WHERE"ID"NOTIN(SELECT"ID"FROM"AT_ASSET_TRANS