d_buyhouse.srd

pb所需编程技巧和事例

$PBExportHeader$d_buyhouse.srd
release 8;
datawindow(units=0 timer_interval=0 color=1073741824 processing=0 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 )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=2344 color="536870912" )
table(column=(type=char(20) update=yes updatewhereclause=yes key=yes name=number dbname="salerecord.number" )
 column=(type=char(20) update=yes updatewhereclause=yes name=identifyno dbname="salerecord.identifyno" )
 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=long update=yes updatewhereclause=yes name=buildingheight dbname="salerecord.buildingheight" )
 column=(type=char(16) update=yes updatewhereclause=yes name=housetype dbname="salerecord.housetype" )
 column=(type=char(50) update=yes updatewhereclause=yes name=description dbname="salerecord.description" )
 column=(type=char(4) update=yes updatewhereclause=yes name=direction dbname="salerecord.direction" )
 column=(type=long update=yes updatewhereclause=yes name=area dbname="salerecord.area" )
 column=(type=decimal(2) update=yes updatewhereclause=yes name=price dbname="salerecord.price" )
 column=(type=char(200) update=yes updatewhereclause=yes name=memo dbname="salerecord.memo" )
 column=(type=real update=yes updatewhereclause=yes name=discountrate dbname="salerecord.discountrate" )
 column=(type=char(10) update=yes updatewhereclause=yes name=fee1name dbname="salerecord.fee1name" values="天然气	天然气/暖气	暖气/地下室	地下室/车库	车库/其它	其它/" )
 column=(type=decimal(4) update=yes updatewhereclause=yes name=fee1money dbname="salerecord.fee1money" )
 column=(type=char(10) update=yes updatewhereclause=yes name=fee2name dbname="salerecord.fee2name" values="天然气	天然气/暖气	暖气/地下室	地下室/车库	车库/其它	其它/" )
 column=(type=decimal(4) update=yes updatewhereclause=yes name=fee2money dbname="salerecord.fee2money" )
 column=(type=char(10) update=yes updatewhereclause=yes name=fee3name dbname="salerecord.fee3name" values="天然气	天然气/暖气	暖气/地下室	地下室/车库	车库/其它	其它/" )
 column=(type=decimal(4) update=yes updatewhereclause=yes name=fee3money dbname="salerecord.fee3money" )
 column=(type=char(10) update=yes updatewhereclause=yes name=fee4name dbname="salerecord.fee4name" values="天然气	天然气/暖气	暖气/地下室	地下室/车库	车库/其它	其它/" )
 column=(type=decimal(4) update=yes updatewhereclause=yes name=fee4money dbname="salerecord.fee4money" )
 column=(type=char(10) update=yes updatewhereclause=yes name=otherfeename dbname="salerecord.otherfeename" )
 column=(type=decimal(4) update=yes updatewhereclause=yes name=otherfeemoney dbname="salerecord.otherfeemoney" )
 column=(type=char(10) update=yes updatewhereclause=yes name=buyername dbname="salerecord.buyername" )
 column=(type=char(15) update=yes updatewhereclause=yes name=buyeridnum dbname="salerecord.buyeridnum" )
 column=(type=char(20) update=yes updatewhereclause=yes name=buyertel dbname="salerecord.buyertel" )
 column=(type=decimal(4) update=yes updatewhereclause=yes name=firstmoney dbname="salerecord.firstmoney" )
 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(40) update=yes updatewhereclause=yes name=itemname dbname="salerecord.itemname" )
 column=(type=char(10) update=yes updatewhereclause=yes name=saler dbname="salerecord.saler" )
 retrieve="PBSELECT( VERSION(400) TABLE(NAME=~"salerecord~" ) COLUMN(NAME=~"salerecord.number~") COLUMN(NAME=~"salerecord.identifyno~") COLUMN(NAME=~"salerecord.buildingno~") COLUMN(NAME=~"salerecord.unitno~") COLUMN(NAME=~"salerecord.storey~") COLUMN(NAME=~"salerecord.buildingheight~") COLUMN(NAME=~"salerecord.housetype~") COLUMN(NAME=~"salerecord.description~") COLUMN(NAME=~"salerecord.direction~") COLUMN(NAME=~"salerecord.area~") COLUMN(NAME=~"salerecord.price~") COLUMN(NAME=~"salerecord.memo~") COLUMN(NAME=~"salerecord.discountrate~") COLUMN(NAME=~"salerecord.fee1name~") COLUMN(NAME=~"salerecord.fee1money~") COLUMN(NAME=~"salerecord.fee2name~") COLUMN(NAME=~"salerecord.fee2money~") COLUMN(NAME=~"salerecord.fee3name~") COLUMN(NAME=~"salerecord.fee3money~") COLUMN(NAME=~"salerecord.fee4name~") COLUMN(NAME=~"salerecord.fee4money~") COLUMN(NAME=~"salerecord.otherfeename~") COLUMN(NAME=~"salerecord.otherfeemoney~") COLUMN(NAME=~"salerecord.buyername~") COLUMN(NAME=~"salerecord.buyeridnum~") COLUMN(NAME=~"salerecord.buyertel~") COLUMN(NAME=~"salerecord.firstmoney~") COLUMN(NAME=~"salerecord.contractno~") COLUMN(NAME=~"salerecord.bookdate~") COLUMN(NAME=~"salerecord.itemname~") COLUMN(NAME=~"salerecord.saler~")) " update="salerecord" updatewhere=1 updatekeyinplace=yes )
text(band=detail alignment="1" text="项目编号:" border="0" color="33554432" x="46" y="200" height="76" width="503" 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=detail alignment="1" text="项目名称:" border="0" color="33554432" x="1381" y="200" height="76" width="503" 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=detail alignment="1" text="项目许可证:" border="0" color="33554432" x="41" y="324" height="76" width="503" 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=detail alignment="1" text="楼号:" border="0" color="33554432" x="1371" y="328" height="76" width="503" 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=detail alignment="1" text="单元号:" border="0" color="33554432" x="37" y="456" height="76" width="503" 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=detail alignment="1" text="楼高:" border="0" color="33554432" x="32" y="592" height="76" width="503" 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=detail alignment="1" text="描述:" border="0" color="33554432" x="23" y="712" height="76" width="503" 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=detail alignment="1" text="入户门朝向:" border="0" color="33554432" x="32" y="832" height="76" width="503" 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=detail alignment="1" text="单价:" border="0" color="33554432" x="41" y="952" height="76" width="503" 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=detail alignment="1" text="备注:" border="0" color="33554432" x="37" y="1084" height="76" width="503" 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=detail alignment="1" text="附加费1:" border="0" color="33554432" x="32" y="1216" height="76" width="503" html.valueishtml="0"  name=fee1name_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=detail alignment="1" text="附加费3:" border="0" color="33554432" x="37" y="1440" height="76" width="503" html.valueishtml="0"  name=fee3name_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=detail alignment="1" text="附加费4:" border="0" color="33554432" x="41" y="1552" height="76" width="494" html.valueishtml="0"  name=fee4name_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=detail alignment="2" text="其它附加费说明" border="0" color="33554432" x="9" y="1688" height="76" width="526" html.valueishtml="0"  name=otherfeename_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=detail alignment="1" text="楼层号:" border="0" color="33554432" x="1371" y="452" height="76" width="503" 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" )