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

$PBExportHeader$dw_rp_giveback_edit.srd
release 9;
datawindow ( units=1 timer_interval=0 color=1073741824 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=146 color="?" )
summary(height=0 color="536870912" )
footer(height=27 color="536870912" )
detail(height=28 color="536870912"  height.autosize=yes)
table(column=(type=datetime updatewhereclause=yes initial="null" name=u_giveback_givebackdate dbname="u_giveback.givebackdate"  )
column=(type=datetime updatewhereclause=yes initial="null" name=u_giveback_startdate dbname="u_giveback.startdate"  )
column=(type=datetime updatewhereclause=yes initial="null" name=u_giveback_enddate dbname="u_giveback.enddate"  )
column=(type=char(20) updatewhereclause=yes initial="null" name=u_cust_cuscode dbname="u_cust.cuscode"  )
column=(type=char(10) updatewhereclause=yes initial="null" name=u_giveback_assign_emp dbname="u_giveback.assign_emp"  )
column=(type=char(20) updatewhereclause=yes initial="null" name=u_giveback_relcode dbname="u_giveback.relcode"  )
column=(type=char(255) updatewhereclause=yes initial="null" name=u_giveback_dscrp dbname="u_giveback.dscrp"  )
column=(type=char(10) updatewhereclause=yes initial="null" name=u_giveback_opemp dbname="u_giveback.opemp"  )
column=(type=datetime updatewhereclause=yes initial="null" name=u_giveback_opdate dbname="u_giveback.opdate"  )
column=(type=char(50) updatewhereclause=yes initial="null" name=u_cust_name dbname="u_cust.name"  )
column=(type=long updatewhereclause=yes initial="null" name=u_giveback_cusid dbname="u_giveback.cusid" 
 values="客户ID	/"  )
column=(type=long updatewhereclause=yes initial="null" name=u_giveback_printnum dbname="u_giveback.printnum" 
 values="打印次数	/"  )
column=(type=long updatewhereclause=yes initial="null" name=u_giveback_scid dbname="u_giveback.scid" 
 values="分部ID	/"  )
column=(type=char(20) updatewhereclause=yes initial="null" name=u_giveback_givebackcode dbname="u_giveback.givebackcode"  )
column=(type=decimal(5) updatewhereclause=yes initial="null" name=u_giveback_givebackrate dbname="u_giveback.givebackrate"  )
column=(type=decimal(5) updatewhereclause=yes initial="null" name=u_giveback_sumamt dbname="u_giveback.sumamt"  )
 retrieve="SELECT	u_giveback.givebackdate,   
         u_giveback.startdate,   
         u_giveback.enddate, 
	 u_cust.cuscode,             
	 u_giveback.assign_emp,   
         u_giveback.relcode,   
         u_giveback.dscrp,   
         u_giveback.opemp,   
         u_giveback.opdate,   
 	 u_cust.name ,
 	 u_giveback.cusid,   
         u_giveback.printnum    ,
	 u_giveback.scid,   
         u_giveback.givebackcode,
	 u_giveback.givebackrate,   
         u_giveback.sumamt 
  FROM u_cust,    
         u_giveback  
   WHERE ( u_cust.cusid = u_giveback.cusid ) 
and ( u_giveback.scid = :arg_scid )
and ( u_giveback.givebackid = :arg_givebackid )
"
  arguments=(("arg_scid", number), ("arg_givebackid", number))
)
line(name=l_1 visible="1" band=header background.mode="2" background.color="1073741824" pen.style="0" pen.width="2" pen.color="33554432" x1="239" y1="39" x2="447" y2="39" )
text(name=t_6 visible="1" moveable=1 resizeable=1 band=header font.charset="134" font.face="宋体" font.family="0" font.height="-20" font.pitch="2" font.weight="700" background.mode="2" background.color="1073741824" color="33554432" alignment="2" border="0" x="184" y="5" height="31" width="318" text="返利单" )
compute(name=compute_1 visible="1" tag="if(   u_giveback_printnum > 0,'(重复打印-'+string(  u_giveback_printnum )+')','')" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-12" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="0" x="509" y="15" height="21" width="121" format="[GENERAL]" expression="if(   u_giveback_printnum > 0,'(重复打印-'+string(  u_giveback_printnum )+')','')" alignment="0" border="0" crosstab.repeat=no )
text(name=u_cust_cuscode_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="7" y="51" height="15" width="62" text="客户编号:" )
text(name=u_giveback_givebackcode_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="523" y="50" height="15" width="62" text="单据编号:" )
column(name=u_giveback_givebackcode visible="1" tag="u_giveback_givebackcode" band=header id=14 x="588" y="50" height="17" width="130" color="0" border="0" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="700" tabsequence=0 )
text(name=u_giveback_givebackdate_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="523" y="76" height="15" width="62" text="单据日期:" )
text(name=u_giveback_givebackrate_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="7" y="76" height="15" width="62" text="返 利 率:" )
column(name=u_cust_name visible="1" tag="u_cust_name" band=header id=10 x="242" y="51" height="17" width="271" color="0" border="0" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=50 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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-11" font.pitch="2" font.weight="700" tabsequence=0 )
text(name=u_cust_name_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="178" y="51" height="15" width="62" text="客户名称:" )
text(name=u_giveback_startdate_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="179" y="76" height="15" width="62" text="开始日期:" )
column(name=u_cust_cuscode visible="1" tag="u_cust_cuscode" band=header id=4 x="72" y="51" height="17" width="103" color="0" border="0" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=u_giveback_relcode_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="523" y="101" height="15" width="62" text="相关号码:" )
column(name=u_giveback_givebackdate visible="1" tag="u_giveback_givebackdate" band=header id=1 x="588" y="76" height="17" width="130" color="0" border="0" alignment="0" format="yyyy-mm-dd" protect="0" editmask.focusrectangle=no editmask.autoskip=no editmask.required=no editmask.readonly=no editmask.codetable=no editmask.spin=no editmask.useformat=no editmask.mask="yyyy-mm-dd" editmask.imemode=0 criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_giveback_relcode visible="1" tag="u_giveback_relcode" band=header id=6 x="588" y="101" height="17" width="130" color="0" border="0" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=u_giveback_enddate_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="337" y="76" height="15" width="69" text="结束日期:" )
text(name=u_giveback_assign_emp_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="337" y="101" height="15" width="69" text="经 手 人:" )
text(name=u_giveback_sumamt_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="7" y="101" height="15" width="62" text="交易金额:" )
column(name=u_giveback_dscrp visible="1" tag="u_giveback_dscrp" band=header id=7 x="72" y="126" height="17" width="646" color="0" border="0" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=255 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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-9" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_giveback_startdate visible="1" tag="u_giveback_startdate" band=header id=2 x="242" y="76" height="17" width="91" color="0" border="0" alignment="0" format="yyyy-mm-dd" protect="0" editmask.focusrectangle=no editmask.autoskip=no editmask.required=no editmask.readonly=no editmask.codetable=no editmask.spin=no editmask.useformat=no editmask.mask="yyyy-mm-dd" editmask.imemode=0 criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_giveback_enddate visible="1" tag="u_giveback_enddate" band=header id=3 x="408" y="76" height="17" width="91" color="0" border="0" alignment="0" format="yyyy-mm-dd" protect="0" editmask.focusrectangle=no editmask.autoskip=no editmask.required=no editmask.readonly=no editmask.codetable=no editmask.spin=no editmask.useformat=no editmask.mask="yyyy-mm-dd" editmask.imemode=0 criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_giveback_assign_emp visible="1" tag="u_giveback_assign_emp" band=header id=5 x="408" y="101" height="17" width="91" color="0" border="0" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=10 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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
column(name=u_giveback_givebackrate visible="1" tag="u_giveback_givebackrate" band=header id=15 x="72" y="76" height="17" width="103" color="0" border="0" alignment="0" format="##0.00###" protect="0" edit.focusrectangle=no edit.autohscroll=yes 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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=u_giveback_dscrp_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="7" y="126" height="15" width="62" text="备    注:" )
column(name=u_giveback_sumamt visible="1" tag="u_giveback_sumamt" band=header id=16 x="72" y="101" height="17" width="103" color="0" border="0" alignment="0" format="#,###0.00###" protect="0" edit.focusrectangle=no edit.autohscroll=yes 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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=amt_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="179" y="101" height="15" width="62" text="返利金额:" )
compute(name=amt visible="1" tag="round( u_giveback_givebackrate * u_giveback_sumamt, 2)" band=header font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" x="242" y="101" height="17" width="91" format="#,###0.00###" expression="round( u_giveback_givebackrate * u_giveback_sumamt, 2)" alignment="0" border="0" crosstab.repeat=no )
text(name=u_giveback_opemp_t visible="1" slideup=allabove band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="5" y="8" height="15" width="63" text="制 单 人:" )
column(name=u_giveback_opemp visible="1" tag="u_giveback_opemp" slideup=allabove band=footer id=8 x="71" y="8" height="17" width="91" color="0" border="0" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=10 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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
text(name=u_giveback_opdate_t visible="1" slideup=allabove band=footer font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="0" alignment="1" border="0" x="171" y="8" height="15" width="69" text="制单时间:" )
column(name=u_giveback_opdate visible="1" tag="u_giveback_opdate" slideup=allabove band=footer id=9 x="241" y="8" height="17" width="145" color="0" border="0" alignment="0" format="yyyy-mm-dd hh:mm" protect="0" edit.focusrectangle=no edit.autohscroll=yes 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="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
report(name=dw_1 visible="1" slideleft=yes height.autosize=yes slideup=directlyabove band=detail x="4" y="4" height="21" width="719" border="0" trail_footer=yes dataobject="dw_rp_givebackmx_index" nest_arguments=
((" arg_scid "),(" arg_givebackid ")))
htmltable()
htmlgen()
export.xml(metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 )