<?xml version="1.0" encoding="UTF-8"?> <!-- $Author: DJ $Date: 2013-4-23 上午9:29:27 $Revision: 1.0 $Purpose: --> <bm:model xmlns:f="leaf.database.features" xmlns:bm="http://www.leaf-framework.org/schema/bm" alias="t1" baseTable="PRJ_PROJECT"> <bm:fields> <bm:field name="project_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="PROJECT_ID"/> <bm:field name="project_name" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROJECT_NAME" prompt="PRJ501.PRJ_PROJECT.PROJECT_NAME"/> <bm:field name="company_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="COMPANY_ID"/> <bm:field name="bp_name" forInsert="false" forUpdate="false" prompt="PRJ501.PRJ_PROJECT.BP_NAME"/> <bm:field name="lease_chance_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="LEASE_CHANCE_ID"/> <bm:field name="lease_chance_code" forInsert="false" forUpdate="false" prompt="HLS.LEASE_CHANCE_CODE"/> <bm:field name="status" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="STATUS"/> <bm:field name="status_desc" forInsert="false" forUpdate="false" prompt="PRJ501.PRJ_PROJECT.STATUS"/> <bm:field name="project_number" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="PROJECT_NUMBER" prompt="PRJ501.PRJ_PROJECT.PROJECT_NO"/> <bm:field name="document_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_TYPE"/> <bm:field name="document_type_desc" forInsert="false" forUpdate="false" prompt="PRJ501.PRJ_PROJECT.DOCUMENT_TYPE"/> <bm:field name="business_type" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="BUSINESS_TYPE"/> <bm:field name="document_category" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DOCUMENT_CATEGORY"/> <bm:field name="lease_organization" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_ORGANIZATION" prompt="HLS.LEASE_ORGANIZATION_CODE"/> <bm:field name="lease_organization_desc" forInsert="false" forUpdate="false" prompt="HLS.LEASE_ORGANIZATION_NAME"/> <bm:field name="lease_channel" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="LEASE_CHANNEL" prompt="HLS.LEASE_CHANNEL_CODE"/> <bm:field name="lease_channel_desc" forInsert="false" forUpdate="false" prompt="HLS.LEASE_CHANNEL_NAME"/> <bm:field name="division" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DIVISION" prompt="HLS.DIVISION"/> <bm:field name="division_desc" forInsert="false" forUpdate="false" prompt="HLS.DIVISION_NAME"/> <bm:field name="owner_user_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="OWNER_USER_ID"/> <bm:field name="unit_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="UNIT_ID"/> <bm:field name="unit_name" forInsert="false" forUpdate="false" prompt="HLS.UNIT_NAME"/> <bm:field name="employee_id_of_manager" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EMPLOYEE_ID_OF_MANAGER"/> <bm:field name="employee_name_of_manager" forInsert="false" forUpdate="false" prompt="PRJ501.PRJ_PROJECT.EMPLOYEE_NAME_OF_MANAGER"/> <bm:field name="employee_id" databaseType="NUMBER" datatype="java.lang.Long" physicalName="EMPLOYEE_ID"/> <bm:field name="employee_name" forInsert="false" forUpdate="false" prompt="PRJ501.PRJ_PROJECT.EMPLOYEE_NAME"/> <bm:field name="financed_amount" databaseType="NUMBER" datatype="java.lang.Double" physicalName="FINANCED_AMOUNT" prompt="PRJ501.PRJ_PROJECT.FINANCED_AMOUNT"/> <bm:field name="financing_purpose" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="FINANCING_PURPOSE" prompt="PRJ501.PRJ_PROJECT.FINANCING_PURPOSE"/> <bm:field name="description" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="DESCRIPTION" prompt="PRJ501.PRJ_PROJECT.DESCRIPTION"/> <bm:field name="ref_v01" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V01" prompt="PRJ501.PRJ_PROJECT.REF_V01"/> <bm:field name="ref_v02" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V02" prompt="PRJ501.PRJ_PROJECT.REF_V02"/> <bm:field name="ref_v03" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V03" prompt="PRJ501.PRJ_PROJECT.REF_V03"/> <bm:field name="ref_v04" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V04" prompt="PRJ501.PRJ_PROJECT.REF_V04"/> <bm:field name="ref_v05" databaseType="VARCHAR2" datatype="java.lang.String" physicalName="REF_V05" prompt="PRJ501.PRJ_PROJECT.REF_V05"/> <bm:field name="ref_n01" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N01" prompt="PRJ501.PRJ_PROJECT.REF_N01"/> <bm:field name="ref_n02" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N02" prompt="PRJ501.PRJ_PROJECT.REF_N02"/> <bm:field name="ref_n03" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N03" prompt="PRJ501.PRJ_PROJECT.REF_N03"/> <bm:field name="ref_n04" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N04" prompt="PRJ501.PRJ_PROJECT.REF_N04"/> <bm:field name="ref_n05" databaseType="NUMBER" datatype="java.lang.Long" physicalName="REF_N05" prompt="PRJ501.PRJ_PROJECT.REF_N05"/> <bm:field name="ref_d01" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D01" prompt="PRJ501.PRJ_PROJECT.REF_D01"/> <bm:field name="ref_d02" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D02" prompt="PRJ501.PRJ_PROJECT.REF_D02"/> <bm:field name="ref_d03" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D03" prompt="PRJ501.PRJ_PROJECT.REF_D03"/> <bm:field name="ref_d04" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D04" prompt="PRJ501.PRJ_PROJECT.REF_D04"/> <bm:field name="ref_d05" databaseType="DATE" datatype="java.util.Date" physicalName="REF_D05" prompt="PRJ501.PRJ_PROJECT.REF_D05"/> </bm:fields> <bm:query-fields> <bm:query-field field="project_id" queryOperator="="/> <bm:query-field field="employee_id" queryOperator="="/> <bm:query-field field="unit_id" queryOperator="="/> <bm:query-field field="project_number" queryOperator="like"/> </bm:query-fields> <bm:operations> <bm:operation name="query"> <bm:query-sql><![CDATA[ select t1.project_id, t1.project_name, t1.bp_name, t1.company_id, t1.lease_chance_id, t1.lease_chance_code, t1.status, t1.status_desc, t1.project_number, t1.document_type, t1.document_type_desc, t1.business_type, t1.document_category, t1.lease_organization, t1.lease_organization_desc, t1.lease_channel, t1.lease_channel_desc, t1.division, t1.division_desc, t1.owner_user_id, t1.employee_id_of_manager, t1.employee_name_of_manager, t1.unit_id, t1.unit_name, t1.employee_id, t1.employee_name, t1.finance_amount, t1.financing_purpose, t1.description, t1.ref_v01, t1.ref_v02, t1.ref_v03, t1.ref_v04, t1.ref_v05, t1.ref_n01, t1.ref_n02, t1.ref_n03, t1.ref_n04, t1.ref_n05, t1.ref_d01, t1.ref_d02, t1.ref_d03, t1.ref_d04, t1.ref_d05 from prj_project_v t1 #WHERE_CLAUSE# order by t1.project_number ]]></bm:query-sql> </bm:operation> <bm:operation name="insert"> <bm:parameters> <bm:parameter name="project_id" input="false" output="true" outputPath="@project_id"/> <bm:parameter name="project_no" input="true" inputPath="@project_no" output="true" outputPath="@project_no"/> </bm:parameters> <bm:update-sql><![CDATA[ begin PRJ501_PROJECT_SAVE_PKG.project_manage(p_sql_type => 'INSERT', p_project_id => ${@project_id}, p_project_name => ${@project_name}, p_company_id => ${/session/@company_id}, p_lease_chance_id => ${@lease_chance_id}, p_status => ${@status}, p_project_no => ${@project_no}, p_document_type => ${@document_type}, p_document_category => ${@document_category}, p_business_type => ${@business_type}, p_lease_organization => ${@lease_organization}, p_lease_channel => ${@lease_channel}, p_division => ${@division}, p_employee_id => ${@employee_id}, p_owner_user_id => ${/session/@user_id}, p_unit_id => ${@unit_id}, p_employee_id_of_manager => ${@employee_id_of_manager}, p_financed_amount => ${@financed_amount}, p_financing_purpose => ${@financing_purpose}, p_description => ${@description}, p_user_id => ${/session/@user_id}, p_ref_v01 => ${@ref_v01}, p_ref_v02 => ${@ref_v02}, p_ref_v03 => ${@ref_v03}, p_ref_v04 => ${@ref_v04}, p_ref_v05 => ${@ref_v05}, p_ref_n01 => ${@ref_n01}, p_ref_n02 => ${@ref_n02}, p_ref_n03 => ${@ref_n03}, p_ref_n04 => ${@ref_n04}, p_ref_n05 => ${@ref_n05}, p_ref_d01 => to_date(${@ref_d01},'yyyy-mm-dd'), p_ref_d02 => to_date(${@ref_d02},'yyyy-mm-dd'), p_ref_d03 => to_date(${@ref_d03},'yyyy-mm-dd'), p_ref_d04 => to_date(${@ref_d04},'yyyy-mm-dd'), p_ref_d05 => to_date(${@ref_d05},'yyyy-mm-dd')); end; ]]></bm:update-sql> </bm:operation> <bm:operation name="update"> <bm:update-sql><![CDATA[ begin PRJ501_PROJECT_SAVE_PKG.project_manage(p_sql_type => 'UPDATE', p_project_id => ${@project_id}, p_project_name => ${@project_name}, p_company_id => ${/session/@company_id}, p_lease_chance_id => ${@lease_chance_id}, p_status => ${@status}, p_project_no => ${@project_no}, p_document_type => ${@document_type}, p_document_category => ${@document_category}, p_business_type => ${@business_type}, p_lease_organization => ${@lease_organization}, p_lease_channel => ${@lease_channel}, p_division => ${@division}, p_employee_id => ${@employee_id}, p_owner_user_id => ${/session/@user_id}, p_unit_id => ${@unit_id}, p_employee_id_of_manager => ${@employee_id_of_manager}, p_financed_amount => ${@financed_amount}, p_financing_purpose => ${@financing_purpose}, p_description => ${@description}, p_user_id => ${/session/@user_id}, p_ref_v01 => ${@ref_v01}, p_ref_v02 => ${@ref_v02}, p_ref_v03 => ${@ref_v03}, p_ref_v04 => ${@ref_v04}, p_ref_v05 => ${@ref_v05}, p_ref_n01 => ${@ref_n01}, p_ref_n02 => ${@ref_n02}, p_ref_n03 => ${@ref_n03}, p_ref_n04 => ${@ref_n04}, p_ref_n05 => ${@ref_n05}, p_ref_d01 => to_date(${@ref_d01},'yyyy-mm-dd'), p_ref_d02 => to_date(${@ref_d02},'yyyy-mm-dd'), p_ref_d03 => to_date(${@ref_d03},'yyyy-mm-dd'), p_ref_d04 => to_date(${@ref_d04},'yyyy-mm-dd'), p_ref_d05 => to_date(${@ref_d05},'yyyy-mm-dd')); end; ]]></bm:update-sql> </bm:operation> <bm:operation name="delete"> <bm:update-sql><![CDATA[ begin PRJ501_PROJECT_SAVE_PKG.project_manage(p_sql_type => 'DELETE', p_project_id => ${@project_id}, p_project_name => ${@project_name}, p_company_id => ${/session/@company_id}, p_lease_chance_id => ${@lease_chance_id}, p_status => ${@status}, p_project_no => ${@project_no}, p_document_type => ${@document_type}, p_document_category => ${@document_category}, p_business_type => ${@business_type}, p_lease_organization => ${@lease_organization}, p_lease_channel => ${@lease_channel}, p_division => ${@division}, p_employee_id => ${@employee_id}, p_owner_user_id => ${/session/@user_id}, p_unit_id => ${@unit_id}, p_employee_id_of_manager => ${@employee_id_of_manager}, p_financed_amount => ${@financed_amount}, p_financing_purpose => ${@financing_purpose}, p_description => ${@description}, p_user_id => ${/session/@user_id}, p_ref_v01 => ${@ref_v01}, p_ref_v02 => ${@ref_v02}, p_ref_v03 => ${@ref_v03}, p_ref_v04 => ${@ref_v04}, p_ref_v05 => ${@ref_v05}, p_ref_n01 => ${@ref_n01}, p_ref_n02 => ${@ref_n02}, p_ref_n03 => ${@ref_n03}, p_ref_n04 => ${@ref_n04}, p_ref_n05 => ${@ref_n05}, p_ref_d01 => to_date(${@ref_d01},'yyyy-mm-dd'), p_ref_d02 => to_date(${@ref_d02},'yyyy-mm-dd'), p_ref_d03 => to_date(${@ref_d03},'yyyy-mm-dd'), p_ref_d04 => to_date(${@ref_d04},'yyyy-mm-dd'), p_ref_d05 => to_date(${@ref_d05},'yyyy-mm-dd')); end; ]]></bm:update-sql> </bm:operation> </bm:operations> <bm:features> <f:standard-who/> </bm:features> <bm:primary-key> <bm:pk-field name="project_id"/> </bm:primary-key> </bm:model>