请问：如何在配置文件中调用脚本啊，数据库和XML得对应关系确立了怎么读取啊？

[wuwenli]

请问：如何在配置文件中调用脚本啊，数据库和XML得对应关系确立了怎么读取啊？
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>
<section name="convertor" type="AvonWnd.AppConfig,AvonWnd" />
</configSections>
<appSettings>
<add key="connectionstring" value="Persist Security Info=False;Integrated Security=SSPI;database=gsdtest;server=(local)" />
<!--<add key="xmlfile" value="F:\DSH1027-01.xml" />-->
<add key="xmlFilePath" value="F:\XmlFilePath" />
</appSettings>
<convertor>
<convertorconfig>
<script>
<![CDATA[
public string getCompanyID(string id) {if ("4006"==id) return "SY";if ("4007"==id) return "ZZ";return "SH";}
public string getClientID(string id) {if ("4006"==id) return "SY0025";if ("4007"==id) return "ZZ0010";return "SH0031";}
public string getDate() {return System.DateTime.Now.ToString("d");}
public string getCreateUser(string id) {if ("4006"==id) return "SY100001";if ("4007"==id) return "ZZ100001";return "SH100001";}
public string getApproveUser(string id) {if ("4006"==id) return "SY100002";if ("4007"==id) return "ZZ100002";return "SH100002";}
public string getDeptID(string id) {if ("4006"==id) return "SY10";if ("4007"==id) return "ZZ10";return "SH10";}
]]>
</script>
<database>
<table name="bs_fclient" root="DOMASTER" />
<table name="out_request" root="DOMASTER">
<table name="out_reqbox" root="PACKAGE">
<table name="out_reqdetail" root="ITEM" />
</table>
</table>
</database>
<mapping root="//DO">
<table name="bs_fclient" root="DOMASTER">
<field name="fclient_id">
<var>BBID</var>
</field>
<field name="fclient_name">
<var>BBNAME</var>
</field>
<field name="fclient_addr">
<var>ADDRESS</var>
</field>
<field name="contact_person">
<var>CONTACT</var>
</field>
<field name="tel_no">
<var>PHONE</var>
</field>
<field name="post_code">
<var>ZIP</var>
</field>
<!--调用脚本-->
<field name="company_id">
<function>getCompanyID(SUPPLIERID)</function>
</field>
<field name="client_id">
<function>getClientID(SUPPLIERID)</function>
</field>
<field name="province_id">
<text>NOO</text>
</field>
<field name="area_id">
<text>0000</text>
</field>
</table>
<table name="out_request" root="DOMASTER">
<field name="req_id">
<text>Created by SP</text>
</field>
<field name="create_date">
<function>getDate()</function>
</field>
<field name="req_date">
<var>SHIPDATE</var>
</field>
<field name="input_time">
<text>Today</text>
</field>
<field name="deploy_type">
<text>35</text>
</field>
<field name="client_id">
<function>getClientID(SUPPLIERID)</function>
</field>
<field name="ref_no">
<var>DONO</var>
</field>
<field name="status">
<text>76</text>
</field>
<field name="upload_province">
<text>NOO</text>
</field>
<field name="update_area">
<text>00000</text>
</field>
<field name="upload_addr">
<var>SUPPLIERNAME</var>
</field>
<field name="volume">
<var>PAKSIZE</var>
</field>
<field name="weight">
<var>PAKWEIGHT</var>
</field>
<field name="start_time">
<var>SHIPDATE</var>
</field>
<field name="end_time">
<var>EXPCTARVDATE</var>
</field>
<field name="create_user">
<function>getCreateUser(SUPPLIERID)</function>
</field>
<field name="approve_user">
<function>getApproveUser(SUPPLIERID)</function>
</field>
<field name="dept_id">
<function>getDeptID(SUPPLIERID)</function>
</field>
<field name="company_id">
<function>getCompanyID(SUPPLIERID)</function>
</field>
<field name="sell_no">
<var>SYSTEMTAG</var>
</field>
<field name="deploy_ticket">
<text>Y</text>
</field>
<field name="mark_ticket">
<text>N</text>
</field>
</table>
<table name="out_reqbox" root="PACKAGE">
<field name="mark_id">
<text>Created by SP</text>
</field>
<field name="box_id">
<var>PACKAGENO</var>
</field>
<field name="mark_name">
<text>avon箱</text>
</field>
<field name="mark_spec">
<var>../DOMASTER/DONO</var>
</field>
<field name="mark_price">
<text>0</text>
</field>
<field name="mark_weight">
<text>0</text>
</field>
<field name="mark_volume">
<text>0</text>
</field>
<field name="req_id">
<var>position()</var> <!-- XPath 函数，因为req_id是主键，用于防止多条记录时启用约束失败 -->
</field>
<field name="fclient_id">
<var>../DOMASTER/BBID</var>
</field>
<field name="fclient_name">
<var>../DOMASTER/BBNAME</var>
</field>
<field name="fclient_tel">
<var>../DOMASTER/PHONE</var>
</field>
<field name="fclient_person">
<var>../DOMASTER/CONTACT</var>
</field>
<field name="download_addr">
<var>../DOMASTER/ADDRESS</var>
</field>
<field name="client_id">
<function>getClientID(../DOMASTER/SUPPLIERID)</function>
</field>
<field name="status">
<text>N</text>
</field>
<field name="mark_qty">
<text>1</text>
</field>
<field name="feetype_id">
<text>BJ</text><!--修改这里确定存储过程来源-->
</field>
<field name="deploy_type">
<text>35</text>
</field>
</table>
<table name="out_reqdetail" root="PACKAGE/ITEM">
<field name="product_id">
<var>FSC</var>
</field>
<field name="product_name">
<text>AVON货品</text>
</field>
<field name="outed_qty">
<var>SHIPQTY</var>
</field>
<field name="req_id">
<var>position()</var> <!-- XPath 函数，因为req_id是主键，用于防止多条记录时启用约束失败 -->
</field>
<field name="expire_date">
<text>2010-01-01</text>
</field>
<field name="download_addr">
<var>//DOMASTER/ADDRESS</var>
</field>
<field name="contact_person">
<var>//DOMASTER/CONTACT</var>
</field>
<field name="tel">
<var>//DOMASTER/PHONE</var>
</field>
<field name="status">
<text>0</text>
</field>
<field name="out_qty">
<text>0</text>
</field>
<field name="fclient_id">
<var>//DOMASTER/BBID</var>
</field>
<field name="box_id">
<var>../PACKAGENO</var>
</field>
<field name="mark_id">
<text>Created by SP</text>
</field>
<!-- 以下三个字段是为了保存触发器所需的临时变量，具体内容可参见本表的<INSTEAD OF>触发器。绝对不可删除！-->
<field name="supp_id">
<function>getClientID(//DOMASTER/SUPPLIERID)</function>
</field>
<field name="stack_id">
<text>35</text>
</field>
<field name="remark">
<var>//DOMASTER/DONO</var>
</field>
</table>
</mapping>
</convertorconfig>
</convertor>
</configuration>

[jxzhang615]

关注！学习！！