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

$PBExportHeader$dw_rp_reissue_spt_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=159 color="536870912" )
summary(height=0 color="536870912" )
footer(height=33 color="536870912" )
detail(height=26 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_spt_sptcode dbname="u_spt.sptcode"  )
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_spt_name dbname="u_spt.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" 
 values="客户费用单主表-单据编号	/"  )
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_spt.sptcode,
	u_reissue.moneyid,
	u_reissue.reissuedate,
	u_reissue.relid,
	u_reissue.relcode,  
	u_reissue.reissueemp,
	u_itemdef.itemcode,
	u_reissue.dscrp,
	u_spt.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_spt
on u_reissue.cusid = u_spt.sptid LEFT OUTER JOIN
	u_itemdef ON u_reissue.itemid = u_itemdef.itemid
	where  u_reissue.scid = :arg_scid and
			u_reissue.reissueid = :arg_reissueid and 
		:arg_printrow = :arg_printrow and
		:arg_top = :arg_top
"
  arguments=(("arg_scid", number), ("arg_reissueid", number), ("arg_printrow", number), ("arg_top", number))
)
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="6" y="61" height="14" width="61" 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="6" y="87" height="14" width="61" text="供应商名称" )
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="527" y="59" 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="527" y="87" height="14" width="52" text="单据日期" )
column(name=u_reissue_reissuecode visible="1" tag="u_reissue_reissuecode" band=header id=16 x="582" y="59" height="17" width="139" 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 )
column(name=u_reissue_reissuedate visible="1" tag="u_reissue_reissuedate" band=header id=14 x="582" y="87" height="17" width="139" color="33554432" border="4" alignment="0" format="yyyy-mm-dd" 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_relcode visible="1" tag="u_reissue_relcode" band=header id=6 x="582" y="113" height="17" width="139" 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=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="527" y="113" height="14" width="52" text="相关单号" )
column(name=u_itemdef_itemname visible="1" tag="u_itemdef_itemname" band=header id=23 x="323" y="113" height="17" width="165" 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=t_2 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="270" y="113" height="14" width="50" text="项目名称" )
text(name=t_1 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="15" y="113" 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="15" y="138" height="14" width="52" text="备    注" )
column(name=u_spt_sptcode visible="1" tag="u_spt_sptcode" band=header id=2 x="70" y="61" height="17" width="418" 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_spt_name visible="1" tag="u_spt_name" band=header id=10 x="70" y="88" height="17" width="418" 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="70" y="113" height="17" width="181" 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_dscrp visible="1" tag="u_reissue_dscrp" band=header id=20 x="70" y="138" height="17" width="418" 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=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="0" alignment="2" border="0" x="3" y="2" 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="0" x="408" y="38" 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="1073741824" pen.style="0" pen.width="1" pen.color="33554432" x1="263" y1="33" x2="462" y2="33" )
column(name=u_reissue_opdate visible="1" tag="u_reissue_opdate" band=footer id=4 x="68" y="9" 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="13" y="9" height="14" width="52" text="建立时间" )
column(name=u_reissue_opemp visible="1" tag="u_reissue_opemp" band=footer id=5 x="246" y="9" 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 )
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="191" y="9" height="14" width="52" text="建 立 人" )
column(name=u_reissue_reissueemp visible="1" tag="u_reissue_reissueemp" band=footer id=11 x="441" y="9" 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 )
text(name=reissueemp_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="388" y="9" height="14" width="50" text="经 手 人" )
report(name=dw_1 visible="1" slideleft=yes height.autosize=yes slideup=directlyabove band=detail x="2" y="1" height="24" width="719" border="0" trail_footer=yes dataobject="dw_rp_reissuemx_index_spt" nest_arguments=
((" arg_scid "),(" arg_reissueid "),(" arg_printrow "),(" arg_top ")))
htmltable()
htmlgen()
export.xml(metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 )