$PBExportHeader$dw_order_wfjg_input2.srd
release 9;
datawindow(units=0 timer_interval=0 color=16777215 processing=0 HTMLDW=no print.printername="" 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.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no )
summary(height=0 color="536870912" )
footer(height=0 color="536870912" )
detail(height=892 color="536870912" )
table(column=(type=long updatewhereclause=yes name=u_order_wfjg_wfjgid dbname="u_order_wfjg.wfjgID" initial="0" )
 column=(type=long updatewhereclause=yes name=u_order_wfjg_billtype dbname="u_order_wfjg.billtype" initial="0" )
 column=(type=datetime updatewhereclause=yes name=u_order_wfjg_requiredate dbname="u_order_wfjg.requiredate" initial="today" )
 column=(type=char(10) updatewhereclause=yes name=u_order_wfjg_assign_emp dbname="u_order_wfjg.Assign_Emp" initial="empty" )
 column=(type=char(20) updatewhereclause=yes name=sptcode dbname="u_spt.sptcode" initial="empty" )
 column=(type=char(255) updatewhereclause=yes name=u_order_wfjg_dscrp dbname="u_order_wfjg.Dscrp" initial="empty" )
 column=(type=char(15) updatewhereclause=yes name=u_order_wfjg_taskcode dbname="u_order_wfjg.TaskCode" initial="empty" )
 column=(type=long updatewhereclause=yes name=u_order_wfjg_sptid dbname="u_order_wfjg.sptID" initial="0" )
 column=(type=datetime updatewhereclause=yes name=u_order_wfjg_accomplishdate dbname="u_order_wfjg.accomplishdate" initial="empty" )
 column=(type=long updatewhereclause=yes name=u_order_wfjg_status dbname="u_order_wfjg.Status" initial="0" )
 column=(type=char(10) updatewhereclause=yes name=u_order_wfjg_opemp dbname="u_order_wfjg.Opemp" initial="empty" )
 column=(type=char(10) updatewhereclause=yes name=u_order_wfjg_permit_emp dbname="u_order_wfjg.Permit_Emp" initial="empty" )
 column=(type=datetime updatewhereclause=yes name=u_order_wfjg_opdate dbname="u_order_wfjg.opdate" initial="today" )
 column=(type=datetime updatewhereclause=yes name=u_order_wfjg_permit_date dbname="u_order_wfjg.Permit_date" )
 column=(type=char(50) updatewhereclause=yes name=u_spt_name dbname="u_spt.name" initial="empty" )
 column=(type=char(20) updatewhereclause=yes name=u_order_wfjg_finishemp dbname="u_order_wfjg.finishemp" )
 column=(type=char(10) updatewhereclause=yes name=u_order_wfjg_modemp dbname="u_order_wfjg.Modemp" initial="empty" )
 column=(type=datetime updatewhereclause=yes name=u_order_wfjg_moddate dbname="u_order_wfjg.moddate" )
 column=(type=char(10) updatewhereclause=yes name=u_order_wfjg_stopemp dbname="u_order_wfjg.stopemp" initial="empty" )
 column=(type=long updatewhereclause=yes name=u_order_wfjg_printnum dbname="u_order_wfjg.printnum" )
 column=(type=long updatewhereclause=yes name=u_order_wfjg_scid dbname="u_order_wfjg.scid" )
 column=(type=long updatewhereclause=yes name=delaydays dbname="delaydays" )
 retrieve="  SELECT top 0 u_order_wfjg.wfjgID,
			 u_order_wfjg.billtype,
         u_order_wfjg.requiredate,     
         u_order_wfjg.Assign_Emp,   
         u_spt.sptcode,   
         u_order_wfjg.Dscrp,
         u_order_wfjg.TaskCode,   
         u_order_wfjg.sptID,   
         u_order_wfjg.accomplishdate,   
         u_order_wfjg.Status,   
         u_order_wfjg.Opemp ,   
         u_order_wfjg.Permit_Emp ,   
         u_order_wfjg.opdate,      
         u_order_wfjg.Permit_date,   
         u_spt.name,   
         u_order_wfjg.finishemp,   
         u_order_wfjg.Modemp,   
         u_order_wfjg.moddate,   
         u_order_wfjg.stopemp,   
         u_order_wfjg.printnum,   
         u_order_wfjg.scid,
			'delaydays' =
			case when isnull(uv_order_wfjg_delaydays.delaydays,0) > 0 then 1 else 0 end
    FROM u_order_wfjg LEFT OUTER  JOIN
         u_spt  ON u_order_wfjg.sptID = u_spt.sptid left outer join 
			uv_order_wfjg_delaydays ON u_order_wfjg.scid = uv_order_wfjg_delaydays.scid
			and u_order_wfjg.wfjgID = uv_order_wfjg_delaydays.wfjgID
" )
bitmap(band=detail filename="people.bmp" x="1755" y="312" height="72" width="82" border="0"  name=p_p pointer="HyperLink!" visible="1" )
column(band=detail id=15 alignment="0" tabsequence=32766 border="4" color="8388608" x="320" y="316" height="68" width="1422" format="[general]" html.valueishtml="0"  name=u_spt_name visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0 edit.displayonly=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=6 alignment="0" tabsequence=32766 border="4" color="16711680" x="320" y="416" height="68" width="1522" format="[general]" html.valueishtml="0"  name=u_order_wfjg_dscrp visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="单据编号" border="0" color="0" x="18" y="28" height="56" width="288" html.valueishtml="0"  name=u_order_wfjg_taskcode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="单据类型" border="0" color="16711680" x="18" y="124" height="56" width="288" html.valueishtml="0"  name=t_1 visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="供应商编号" border="0" color="8388608" x="18" y="220" height="56" width="288" html.valueishtml="0"  name=u_cust_cuscode_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="供应商名称" border="0" color="8388608" x="18" y="316" height="56" width="288" html.valueishtml="0"  name=u_cust_name_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="备    注" border="0" color="16711680" x="18" y="416" height="56" width="288" html.valueishtml="0"  name=dscrp_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="完成日期" border="0" color="0" x="18" y="800" height="56" width="288" html.valueishtml="0"  name=accomplishdate_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="修改时间" border="0" color="0" x="18" y="704" height="56" width="288" html.valueishtml="0"  name=u_buytask_moddate_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="审核时间" border="0" color="0" x="18" y="608" height="56" width="288" html.valueishtml="0"  name=last_emp_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="建立时间" border="0" color="0" x="18" y="512" height="56" width="288" html.valueishtml="0"  name=u_order_wfjg_opdate_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="状    态" border="0" color="0~tif( u_order_wfjg_status =0,rgb(255,0,0),rgb(0,0,0))" x="878" y="28" height="56" width="247" html.valueishtml="0"  name=u_order_wfjg_status_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="下单日期" border="0" color="16711680" x="878" y="124" height="56" width="247" html.valueishtml="0"  name=requiredate_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="负 责 人" border="0" color="16711680" x="878" y="220" height="56" width="247" html.valueishtml="0"  name=assign_emp_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="审 核 人" border="0" color="0" x="878" y="608" height="56" width="247" html.valueishtml="0"  name=permit_emp_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="建 立 人" border="0" color="0" x="878" y="508" height="56" width="247" html.valueishtml="0"  name=u_order_wfjg_opemp_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="修 改 人" border="0" color="0" x="878" y="704" height="56" width="247" html.valueishtml="0"  name=u_buytask_modemp_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="完成确认人" border="0" color="0" x="841" y="800" height="56" width="283" html.valueishtml="0"  name=u_buytask_finishemp_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=7 alignment="0" tabsequence=32766 border="4" color="0" x="320" y="28" height="68" width="494" format="[general]" html.valueishtml="0"  name=u_order_wfjg_taskcode visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="700"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=2 alignment="0" tabsequence=32766 border="4" color="16711680" x="320" y="124" height="68" width="494" format="[general]" html.valueishtml="0"  name=u_order_wfjg_billtype visible="1" dddw.name=ddd_wfjg_billtype2 dddw.displaycolumn=billtypename dddw.datacolumn=billtypeid dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.vscrollbar=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=5 alignment="0" tabsequence=32766 border="4" color="8388608" x="320" y="220" height="68" width="494" format="[general]" html.valueishtml="0"  name=sptcode visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=13 alignment="0" tabsequence=32766 border="4" color="8388608" x="320" y="512" height="68" width="494" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=u_order_wfjg_opdate visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=14 alignment="0" tabsequence=32766 border="4" color="8388608" x="320" y="608" height="68" width="494" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=u_order_wfjg_permit_date visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=18 alignment="0" tabsequence=32766 border="4" color="8388608" x="320" y="704" height="68" width="494" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=u_order_wfjg_moddate visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=9 alignment="0" tabsequence=32766 border="4" color="8388608" x="320" y="800" height="68" width="494" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=u_order_wfjg_accomplishdate visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=19 alignment="0" tabsequence=32766 border="4" color="8388608" x="1536" y="800" height="68" width="302" format="[general]" html.valueishtml="0"  name=u_order_wfjg_stopemp visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="1" text="暂停/终止人" border="0" color="0" x="1536" y="704" height="56" width="302" html.valueishtml="0"  name=u_buytask_stopemp_t visible="1"  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=3 alignment="2" tabsequence=32766 border="4" color="16711680" x="1143" y="124" height="68" width="402" format="[shortdate] [time]" html.valueishtml="0"  name=u_order_wfjg_requiredate visible="1" editmask.spin=yes editmask.mask="yyyy-mm-dd" editmask.imemode=0 editmask.spinincr=0 editmask.focusrectangle=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=12 alignment="0" tabsequence=32766 border="4" color="8388608" x="1143" y="608" height="68" width="361" format="[general]" html.valueishtml="0"  name=u_order_wfjg_permit_emp visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=17 alignment="0" tabsequence=32766 border="4" color="8388608" x="1143" y="704" height="68" width="361" format="[general]" html.valueishtml="0"  name=u_order_wfjg_modemp visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=16 alignment="0" tabsequence=32766 border="4" color="8388608" x="1138" y="800" height="68" width="361" format="[general]" html.valueishtml="0"  name=u_order_wfjg_finishemp visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=11 alignment="0" tabsequence=32766 border="4" color="8388608" x="1143" y="512" height="68" width="361" format="[general]" html.valueishtml="0"  name=u_order_wfjg_opemp visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="4" color="16711680" x="1143" y="220" height="68" width="361" format="[general]" html.valueishtml="0"  name=u_order_wfjg_assign_emp visible="1" dddw.name=ddd_order_wfjg_rep dddw.displaycolumn=assign_emp dddw.datacolumn=assign_emp dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.vscrollbar=yes  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=10 alignment="0" tabsequence=32766 border="4" color="0~tif( u_order_wfjg_status =0,rgb(255,0,0),rgb(0,0,0))" x="1143" y="28" height="68" width="361" format="[general]" html.valueishtml="0"  name=u_order_wfjg_status visible="1" dddw.name=dw_ddd_order_wfjg_status dddw.displaycolumn=status_display dddw.datacolumn=status dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
htmltable(border="1" )
htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )