d_house.srd

pb所需编程技巧和事例

$PBExportHeader$d_house.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="house.number" )
 column=(type=char(40) update=yes updatewhereclause=yes name=itemname dbname="house.itemname" )
 column=(type=char(20) update=yes updatewhereclause=yes name=identifyno dbname="house.identifyno" )
 column=(type=char(10) update=yes updatewhereclause=yes name=buildingno dbname="house.buildingno" )
 column=(type=char(10) update=yes updatewhereclause=yes name=unitno dbname="house.unitno" )
 column=(type=long update=yes updatewhereclause=yes name=storey dbname="house.storey" )
 column=(type=long update=yes updatewhereclause=yes name=buildingheight dbname="house.buildingheight" )
 column=(type=char(16) update=yes updatewhereclause=yes name=housetype dbname="house.housetype" )
 column=(type=char(50) update=yes updatewhereclause=yes name=description dbname="house.description" )
 column=(type=char(4) update=yes updatewhereclause=yes name=direction dbname="house.direction" )
 column=(type=long update=yes updatewhereclause=yes name=area dbname="house.area" )
 column=(type=decimal(2) update=yes updatewhereclause=yes name=price dbname="house.price" )
 column=(type=char(200) update=yes updatewhereclause=yes name=memo dbname="house.memo" )
 column=(type=long update=yes updatewhereclause=yes name=flag dbname="house.flag" values="已售出	1/待售	0/" )
 retrieve="PBSELECT(TABLE(NAME=~"house~") COLUMN(NAME=~"house.number~")COLUMN(NAME=~"house.itemname~")COLUMN(NAME=~"house.identifyno~")COLUMN(NAME=~"house.buildingno~")COLUMN(NAME=~"house.unitno~")COLUMN(NAME=~"house.storey~")COLUMN(NAME=~"house.buildingheight~")COLUMN(NAME=~"house.housetype~")COLUMN(NAME=~"house.description~")COLUMN(NAME=~"house.direction~")COLUMN(NAME=~"house.area~")COLUMN(NAME=~"house.price~")COLUMN(NAME=~"house.memo~")COLUMN(NAME=~"house.flag~"))" update="house" updatewhere=1 updatekeyinplace=no )
text(band=header alignment="2" text="编号" border="0" color="33554432" x="9" y="8" height="76" width="507" 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="526" y="8" height="76" width="704" 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="1239" y="8" height="76" width="672" html.valueishtml="0"  name=identifyno_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="1920" y="8" height="76" width="352" html.valueishtml="0"  name=buildingno_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="2281" y="8" height="76" width="352" html.valueishtml="0"  name=unitno_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="2642" y="8" height="76" width="384" html.valueishtml="0"  name=storey_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="3035" y="8" height="76" width="448" html.valueishtml="0"  name=buildingheight_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="3493" 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="4046" y="8" height="76" width="1170" html.valueishtml="0"  name=description_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="5225" y="8" height="76" width="288" html.valueishtml="0"  name=direction_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="5522" 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="5915" 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="6309" y="8" height="76" width="1097" html.valueishtml="0"  name=memo_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="7415" y="8" height="76" width="384" html.valueishtml="0"  name=flag_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="507" 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="526" y="8" height="88" width="704" 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=3 alignment="0" tabsequence=30 border="0" color="33554432" x="1239" y="8" height="88" width="672" format="[general]" html.valueishtml="0"  name=identifyno 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=4 alignment="0" tabsequence=40 border="0" color="33554432" x="1920" y="8" height="88" width="352" format="[general]" html.valueishtml="0"  name=buildingno 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=5 alignment="0" tabsequence=50 border="0" color="33554432" x="2281" y="8" height="88" width="352" format="[general]" html.valueishtml="0"  name=unitno 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=6 alignment="1" tabsequence=60 border="0" color="33554432" x="2642" y="8" height="88" width="384" format="[general]" html.valueishtml="0"  name=storey 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=7 alignment="1" tabsequence=70 border="0" color="33554432" x="3035" y="8" height="88" width="448" format="[general]" html.valueishtml="0"  name=buildingheight 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="0" tabsequence=80 border="0" color="33554432" x="3493" 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=9 alignment="0" tabsequence=90 border="0" color="33554432" x="4046" y="8" height="88" width="1170" format="[general]" html.valueishtml="0"  name=description visible="1" edit.limit=50 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="5225" y="8" height="88" width="288" format="[general]" html.valueishtml="0"  name=direction visible="1" edit.limit=4 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="1" tabsequence=110 border="0" color="33554432" x="5522" 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=12 alignment="1" tabsequence=120 border="0" color="33554432" x="5915" 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=13 alignment="0" tabsequence=130 border="0" color="33554432" x="6309" y="8" height="88" width="1097" format="[general]" html.valueishtml="0"  name=memo visible="1" edit.limit=200 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=14 alignment="1" tabsequence=32766 border="0" color="33554432" x="7415" y="8" height="88" width="384" format="[general]" html.valueishtml="0"  name=flag visible="1" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.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" )