Q5/ws_objects/Ew_printbill.pbl.src/dw_rp_reissue_print.srd

$PBExportHeader$dw_rp_reissue_print.srd
release 9;
datawindow ( units=1 timer_interval=60000 color=16777215 processing=0 print.orientation=0 print.margin.left=24 print.margin.right=24 print.margin.top=24 print.margin.bottom=24 print.paper.size=0 print.paper.source=0 selected.mouse=no)
header(height=161 color="536870912" )
summary(height=0 color="536870912" )
footer(height=25 color="536870912" )
detail(height=36 color="536870912"  height.autosize=yes)
table(column=(type=long updatewhereclause=yes initial="null" name=u_reissue_reissueid dbname="u_reissue.reissueid" 
 values="客户费用单主表-单据ID	/"  )
column=(type=char(20) updatewhereclause=yes initial="null" name=u_cust_cuscode dbname="u_cust.cuscode"  )
column=(type=long updatewhereclause=yes initial="null" name=u_reissue_moneyid dbname="u_reissue.moneyid" 
 values="客户费用单主表-币种ID	/"  )
column=(type=datetime updatewhereclause=yes initial="null" name=u_reissue_reissuedate dbname="u_reissue.reissuedate"  )
column=(type=long updatewhereclause=yes initial="null" name=u_reissue_relid dbname="u_reissue.relid"  )
column=(type=char(30) updatewhereclause=yes initial="null" name=u_reissue_relcode dbname="u_reissue.relcode"  )
column=(type=char(10) updatewhereclause=yes initial="null" name=u_reissue_reissueemp dbname="u_reissue.reissueemp" 
 values="客户费用单主表-经手人	/"  )
column=(type=char(20) updatewhereclause=yes initial="null" name=u_itemdef_itemcode dbname="u_itemdef.itemcode"  )
column=(type=char(255) updatewhereclause=yes initial="null" name=u_reissue_dscrp dbname="u_reissue.dscrp" 
 values="客户费用单主表-备注	/"  )
column=(type=char(50) updatewhereclause=yes initial="null" name=u_cust_name dbname="u_cust.name"  )
column=(type=char(10) updatewhereclause=yes initial="null" name=u_reissue_opemp dbname="u_reissue.opemp"  )
column=(type=datetime updatewhereclause=yes initial="null" name=u_reissue_opdate dbname="u_reissue.opdate" 
 values="客户费用单主表-新建时间	/"  )
column=(type=char(10) updatewhereclause=yes initial="null" name=u_reissue_modemp dbname="u_reissue.modemp" 
 values="客户费用单主表-修改人	/"  )
column=(type=datetime updatewhereclause=yes initial="null" name=u_reissue_moddate dbname="u_reissue.moddate"  )
column=(type=char(10) updatewhereclause=yes initial="null" name=u_reissue_auditingrep dbname="u_reissue.auditingrep" 
 values="客户费用单主表-审核人	/"  )
column=(type=datetime updatewhereclause=yes initial="null" name=u_reissue_auditingdate dbname="u_reissue.auditingdate"  )
column=(type=long updatewhereclause=yes initial="null" name=u_reissue_flag dbname="u_reissue.flag" 
 values="客户费用单主表-审核标记	/"  )
column=(type=long updatewhereclause=yes initial="null" name=u_reissue_printnum dbname="u_reissue.printnum" 
 values="客户费用单主表-打印次数	/"  )
column=(type=char(20) updatewhereclause=yes initial="null" name=u_reissue_reissuecode dbname="u_reissue.reissuecode"  )
column=(type=long updatewhereclause=yes initial="null" name=u_reissue_scid dbname="u_reissue.scid"  )
column=(type=long updatewhereclause=yes initial="null" name=u_reissue_cusid dbname="u_reissue.cusid" 
 values="客户费用单主表-客户ID	/"  )
column=(type=long updatewhereclause=yes initial="null" name=u_reissue_type dbname="u_reissue.type" 
 values="客户费用单主表-单据类型(客户补件单	客户费用单主表-单据类型(客户补件单/客户费用单)	/"  )
column=(type=char(50) updatewhereclause=yes initial="null" name=u_itemdef_itemname dbname="u_itemdef.itemname"  )
column=(type=long updatewhereclause=yes initial="null" name=u_reissue_itemid dbname="u_reissue.itemid" 
 values="U Reissue
Itemid	/"  )
 retrieve="SELECT  u_reissue.reissueid,
	u_cust.cuscode,
	u_reissue.moneyid,
	u_reissue.reissuedate,
	u_reissue.relid,
	u_reissue.relcode,
	u_reissue.reissueemp,
	u_itemdef.itemcode,
	u_reissue.dscrp,
	u_cust.name,
	u_reissue.opemp,
	u_reissue.opdate,
	u_reissue.modemp,
	u_reissue.moddate,
	u_reissue.auditingrep,
	u_reissue.auditingdate,
	u_reissue.flag,
	u_reissue.printnum  ,
	u_reissue.reissuecode  ,
	u_reissue.scid,
	u_reissue.cusid ,
	u_reissue.type,
	u_itemdef.itemname,
	u_reissue.itemid
 FROM u_reissue LEFT OUTER JOIN
	u_itemdef ON u_reissue.itemid = u_itemdef.itemid LEFT OUTER JOIN
	u_cust ON u_reissue.cusid = u_cust.cusid 
where u_reissue.scid = :arg_scid and
		u_reissue.reissueid = :arg_reissueid  
	
	
"
  arguments=(("arg_scid", number), ("arg_reissueid", number), ("arg_printrow", number), ("arg_top", number))
)
column(name=u_reissue_moneyid visible="1" tag="u_reissue_moneyid" band=header id=19 x="249" y="56" height="17" width="121" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_reissue_reissuedate visible="1" tag="u_reissue_reissuedate" band=header id=14 x="466" y="86" height="17" width="121" color="33554432" border="4" alignment="2" format="yyyy-mm-dd" protect="0" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_reissue_reissueemp visible="1" tag="u_reissue_reissueemp" band=header id=11 x="466" y="112" height="17" width="121" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_reissue_dscrp visible="1" tag="u_reissue_dscrp" band=header id=20 x="68" y="138" height="17" width="299" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_reissue_reissuecode visible="1" tag="u_reissue_reissuecode" band=header id=16 x="466" y="60" height="17" width="121" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="700" tabsequence=0 )
text(name=t_3 visible="1" moveable=1 resizeable=1 band=header font.charset="134" font.face="宋体" font.family="0" font.height="-18" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="33554432" alignment="2" border="0" x="3" y="3" height="27" width="719" text="客户费用单" )
compute(name=now visible="1" tag="'打印时间:'+string(today(),'yyyy-mm-dd ')+string(now(),'h:mm')+'    第 ' + page() + ' 页/共 ' + pageCount()+' 页'" moveable=1 band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" x="408" y="39" height="15" width="312" format="[general]" expression="'打印时间:'+string(today(),'yyyy-mm-dd ')+string(now(),'h:mm')+'    第 ' + page() + ' 页/共 ' + pageCount()+' 页'" alignment="0" border="0" crosstab.repeat=no )
line(name=l_1 visible="1" moveable=1 resizeable=1 band=header background.mode="2" background.color="16777215" pen.style="0" pen.width="1" pen.color="33554432" x1="263" y1="34" x2="462" y2="34" )
text(name=reissuecode_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="411" y="60" height="14" width="52" text="单据编号" )
text(name=reissuedate_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="411" y="86" height="14" width="52" text="单据日期" )
text(name=reissueemp_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="411" y="112" height="14" width="52" text="经 手 人" )
text(name=relcode_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="411" y="136" height="14" width="52" text="相关单号" )
column(name=u_reissue_relcode visible="1" tag="u_reissue_relcode" band=header id=6 x="466" y="136" height="17" width="121" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=u_cust_cuscode_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="13" y="56" height="14" width="52" text="客户编号" )
text(name=u_cust_name_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="13" y="83" height="14" width="52" text="客户名称" )
text(name=dscrp_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="13" y="138" height="14" width="52" text="备    注" )
text(name=u_itemdef_itemcode_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="13" y="115" height="14" width="52" text="项目编号" )
column(name=u_cust_cuscode visible="1" tag="u_cust_cuscode" band=header id=2 x="68" y="56" height="17" width="121" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=no edit.autoselect=no edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_cust_name visible="1" tag="u_cust_name" band=header id=10 x="68" y="83" height="17" width="299" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=no edit.autoselect=no edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_itemdef_itemcode visible="1" tag="u_itemdef_itemcode" band=header id=8 x="68" y="115" height="17" width="121" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=no edit.autoselect=no edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=moneyid_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="192" y="56" height="14" width="52" text="币    种" )
text(name=u_itemdef_itemname_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="192" y="115" height="14" width="52" text="项目名称" )
column(name=u_itemdef_itemname visible="1" tag="u_itemdef_itemname" band=header id=23 x="247" y="115" height="17" width="121" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=no edit.autoselect=no edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_reissue_opemp visible="1" tag="u_reissue_opemp" band=footer id=5 x="239" y="5" height="17" width="121" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_reissue_opdate visible="1" tag="u_reissue_opdate" band=footer id=4 x="61" y="5" height="17" width="121" color="33554432" border="4" alignment="0" format="yyyy-mm-dd hh:mm" protect="0" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="2" background.color="16777215" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=opdate_t visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="6" y="5" height="14" width="52" text="建立时间" )
text(name=opemp_t visible="1" band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="400" background.mode="2" background.color="16777215" color="33554432" alignment="1" border="0" x="185" y="5" height="14" width="52" text="建 立 人" )
report(name=dw_1 visible="1" slideleft=yes height.autosize=yes slideup=directlyabove band=detail x="1" y="0" height="34" width="725" border="0" trail_footer=yes dataobject="dw_rp_reissuemx_cust" nest_arguments=
((" arg_scid "),(" arg_reissueid ")))
htmltable()
htmlgen()
export.xml(metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 )