d_record.srd

pb所需编程技巧和事例

$PBExportHeader$d_record.srd
release 8;
datawindow(units=0 timer_interval=0 color=1073741824 processing=1 HTMLDW=no print.documentname="" print.orientation = 0 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 0 print.prompt=no print.buttons=no print.preview.buttons=no grid.lines=0 )
header(height=92 color="536870912" )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=104 color="536870912" )
table(column=(type=char(20) update=yes updatewhereclause=yes key=yes name=number dbname="salerecord.number" )
 column=(type=char(40) update=yes updatewhereclause=yes name=itemname dbname="salerecord.itemname" )
 column=(type=char(10) update=yes updatewhereclause=yes name=buildingno dbname="salerecord.buildingno" )
 column=(type=char(10) update=yes updatewhereclause=yes name=unitno dbname="salerecord.unitno" )
 column=(type=long update=yes updatewhereclause=yes name=storey dbname="salerecord.storey" )
 column=(type=char(16) update=yes updatewhereclause=yes name=housetype dbname="salerecord.housetype" )
 column=(type=decimal(2) update=yes updatewhereclause=yes name=price dbname="salerecord.price" )
 column=(type=long update=yes updatewhereclause=yes name=area dbname="salerecord.area" )
 column=(type=char(10) update=yes updatewhereclause=yes name=buyername dbname="salerecord.buyername" )
 column=(type=char(20) update=yes updatewhereclause=yes name=buyertel dbname="salerecord.buyertel" )
 column=(type=char(20) update=yes updatewhereclause=yes name=contractno dbname="salerecord.contractno" )
 column=(type=date update=yes updatewhereclause=yes name=bookdate dbname="salerecord.bookdate" )
 column=(type=char(10) update=yes updatewhereclause=yes name=saler dbname="salerecord.saler" )
 retrieve="PBSELECT(TABLE(NAME=~"salerecord~") COLUMN(NAME=~"salerecord.number~")COLUMN(NAME=~"salerecord.itemname~")COLUMN(NAME=~"salerecord.buildingno~")COLUMN(NAME=~"salerecord.unitno~")COLUMN(NAME=~"salerecord.storey~")COLUMN(NAME=~"salerecord.housetype~")COLUMN(NAME=~"salerecord.price~")COLUMN(NAME=~"salerecord.area~")COLUMN(NAME=~"salerecord.buyername~")COLUMN(NAME=~"salerecord.buyertel~")COLUMN(NAME=~"salerecord.contractno~")COLUMN(NAME=~"salerecord.bookdate~")COLUMN(NAME=~"salerecord.saler~"))" update="salerecord" updatewhere=1 updatekeyinplace=no )
text(band=header alignment="2" text="编号" border="0" color="33554432" x="9" y="8" height="76" width="512" html.valueishtml="0"  name=number_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="项目名称" border="0" color="33554432" x="530" y="8" height="76" width="603" html.valueishtml="0"  name=itemname_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="户型" border="0" color="33554432" x="1147" y="8" height="76" width="544" html.valueishtml="0"  name=housetype_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="单价" border="0" color="33554432" x="1701" y="8" height="76" width="384" html.valueishtml="0"  name=price_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="面积" border="0" color="33554432" x="2094" y="8" height="76" width="384" html.valueishtml="0"  name=area_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="客户" border="0" color="33554432" x="2487" y="8" height="76" width="361" html.valueishtml="0"  name=buyername_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="联系电话" border="0" color="33554432" x="2857" y="8" height="76" width="434" html.valueishtml="0"  name=buyertel_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="合同号" border="0" color="33554432" x="3301" y="8" height="76" width="530" html.valueishtml="0"  name=contractno_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="交易日期、" border="0" color="33554432" x="3840" y="8" height="76" width="384" html.valueishtml="0"  name=bookdate_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
text(band=header alignment="2" text="经手人" border="0" color="33554432" x="4233" y="8" height="76" width="352" html.valueishtml="0"  name=saler_t visible="1"  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=1 alignment="0" tabsequence=10 border="0" color="33554432" x="9" y="8" height="88" width="512" format="[general]" html.valueishtml="0"  name=number visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=2 alignment="0" tabsequence=20 border="0" color="33554432" x="530" y="8" height="88" width="603" format="[general]" html.valueishtml="0"  name=itemname visible="1" edit.limit=40 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=6 alignment="0" tabsequence=60 border="0" color="33554432" x="1147" y="8" height="88" width="544" format="[general]" html.valueishtml="0"  name=housetype visible="1" edit.limit=16 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=7 alignment="1" tabsequence=70 border="0" color="33554432" x="1701" y="8" height="88" width="384" format="[general]" html.valueishtml="0"  name=price visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=8 alignment="1" tabsequence=80 border="0" color="33554432" x="2094" y="8" height="88" width="384" format="[general]" html.valueishtml="0"  name=area visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=9 alignment="0" tabsequence=90 border="0" color="33554432" x="2487" y="8" height="88" width="361" format="[general]" html.valueishtml="0"  name=buyername visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=10 alignment="0" tabsequence=100 border="0" color="33554432" x="2857" y="8" height="88" width="434" format="[general]" html.valueishtml="0"  name=buyertel visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=11 alignment="0" tabsequence=110 border="0" color="33554432" x="3301" y="8" height="88" width="530" format="[general]" html.valueishtml="0"  name=contractno visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=12 alignment="0" tabsequence=120 border="0" color="33554432" x="3840" y="8" height="88" width="384" format="[general]" html.valueishtml="0"  name=bookdate visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
column(band=detail id=13 alignment="0" tabsequence=130 border="0" color="33554432" x="4233" y="8" height="88" width="352" format="[general]" html.valueishtml="0"  name=saler visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="Arial" font.height="-12" font.weight="400"  font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="536870912" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" netscapelayers="0" )