<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: hand $Date: 2016-6-22 上午10:56:55 $Revision: 1.0 $Purpose: --> <bm:model xmlns:o="leaf.database.local.oracle" xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="CON_COLLECTION_PERSONS" defaultOrderBy="staff_name asc" needAccessControl="false"> <!-- insertExpression="${/parameter/@group_id}" --> <bm:fields> <bm:field name="staff_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="STAFF_ID" prompt="CON_COLLECTION_PERSONS.STAFF_ID"/> <bm:field name="user_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="USER_ID" prompt="CON_COLLECTION_PERSONS.USER_ID"/> <bm:field name="group_id" databaseType="NUMBER" datatype="java.lang.Long" forUpdate="false" insertExpression="${../../@group_id}" physicalName="GROUP_ID" prompt="CON_COLLECTION_PERSONS.GROUP_ID"/> <bm:field name="staff_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STAFF_NAME" prompt="CON_COLLECTION_PERSONS.STAFF_NAME"/> <bm:field name="district" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DISTRICT" prompt="CON_COLLECTION_PERSONS.DISTRICT"/> <bm:field name="note" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="NOTE" prompt="CON_COLLECTION_PERSONS.NOTE"/> </bm:fields> <bm:features> <f:standard-who/> <o:sequence-pk/> </bm:features> <bm:primary-key> <bm:pk-field name="staff_id"/> </bm:primary-key> <bm:query-fields> <bm:query-field field="group_id" queryOperator="="/> </bm:query-fields> <!-- <bm:operations > <bm:operation > <bm:update-sql><![CDATA[ DECLARE BEGIN INSERT INTO con_collection_group ( group_id, type_id, group_code, group_name, district, note, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE ) VALUES ( CON_COLLECTION_GROUP_S.NEXTVAL, ${/parameter/@type_id}, ${@group_code}, ${@group_name}, ${@district}, ${@note}, ${/session/@user_id}, sysdate, ${/session/@user_id}, sysdate ) RETURNING group_id INTO ${@group_id}; END; ]]></bm:update-sql> </bm:operation> </bm:operations> --> </bm:model>