数据集定义
数据集是定义数据库查询SQL,数据显示格式和查询参数等的信息属性。
<ATTRIBUTE TYPE="DS" PROGID="PPDomainDataSetSvr" CODE="EDITDS" NAME="主编辑数据集" ID="15528" ENTITYNAME="资产入库">
<RETRIEVE TYPE="BASE">
<PRESQL>
</PRESQL>
<SQL TABLES="t_zcrk~c_zcfl~s_employee~c_zcxh~c_wldw~c_qdfs~s_objectstore">
SELECT t_zcrk.zcrkid as zcrkid, ... WHERE ( t_zcrk.zcrkid = :zcrkid )</SQL>
<SUBDS></SUBDS>
<UPDATE TABLE="t_zcrk" WHERECOL="UPD"/>
<OBJSTORE TYPE="1" COL="objid" VALIDTIME=""/>
<OBJBLOB PATHEXP="'c:\srp\'+ecode+'.'+jpg" FIELD="字段内容base64" KEYFIELD='文件名称'/>
<SCRIPT></SCRIPT>
<CONTRACTSINGLE></CONTRACT>
<ROOMPROVIDER></ROOMPROVIDER>
<IDCOLS> zcrkid</IDCOLS>
<COLUMNS>
<COL DBNAME="t_zcrk.zcrkid" DATATYPE="25" ALIGNMENT="0" TYPE="FIELD" EXPRESSION="" SIZE="0" PRECISION="0" CODE="zcrkid" GENERATED="TRUE" NAME="" FORMAT="" MASK="" DEFAULTVALUE=""/>....
</COLUMNS>
<PARAMS>
<CONCOLS>c_wldwgys_ecode~c_wldwgys_ename</CONCOLS>
<PARAM TYPE="INSQL" CODE="zcrkid" REQUIRED="TRUE" NAME="实体主键参数" DBNAME="" DATATYPE="3" FORMAT="" DEFAULTVALUE="" PRECISION="" MASK=""/>
<GROUPBY>c_wldwgys_ecode~c_wldwgys_ename</GROUPBY>
</PARAMS>
</RETRIEVE>
<FORMATS>
<FORMAT STYLE="PANEL" CODE="DEFAULT" NAME="DEFAULT" WIDTH="640" HEIGHT="210">
<OBJECT TYPE="TEXT" CODE="t_ecode" LABEL="入库单号" VISIBLE="TRUE" READONLY="TRUE" X="16" Y="20" HEIGHT="30" WIDTH="70" SIZERATIO="0,0"/>
......
</FORMAT>
</FORMATS>
<ALIASES>
<ALIAS CODE="DEFAULT" NAME="DEFAULT" ORDERBY="" GROUPBY="">
<FILTER></FILTER>
<PARAMS>
<PARAM CODE='' VISIBILE='TRUE'/>
</PARAMS>
<COLSFILTER></COLSFILTER>
</ALIAS>
</ALIASES>
</ATTRIBUTE>
Created with the Personal Edition of HelpNDoc: Free help authoring environment