Q5/ws_objects/Ew_buy.pbl.src/dw_inware_buy_audit_edit.srd

$PBExportHeader$dw_inware_buy_audit_edit.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=764 color="536870912" )
table(column=(type=long updatewhereclause=yes name=inwareid dbname="u_inware.inwareid" initial="0" )
 column=(type=long updatewhereclause=yes name=storageid dbname="u_inware.storageid" initial="0" )
 column=(type=decimal(2) updatewhereclause=yes name=u_inware_otheramt dbname="u_inware.otheramt" initial="0" )
 column=(type=char(20) updatewhereclause=yes name=u_spt_sptcode dbname="u_spt.sptcode" initial="empty" )
 column=(type=datetime updatewhereclause=yes name=indate dbname="u_inware.indate" initial="today" )
 column=(type=char(10) updatewhereclause=yes name=inrep dbname="u_inware.inrep" initial="empty" )
 column=(type=char(50) updatewhereclause=yes name=part dbname="u_inware.part" initial="empty" )
 column=(type=long updatewhereclause=yes name=u_inware_relint_1 dbname="u_inware.relint_1" )
 column=(type=char(255) updatewhereclause=yes name=dscrp dbname="u_inware.dscrp" initial="empty" )
 column=(type=datetime updatewhereclause=yes name=opdate dbname="u_inware.opdate" initial="today" )
 column=(type=char(10) updatewhereclause=yes name=u_inware_opemp dbname="u_inware.opemp" )
 column=(type=long updatewhereclause=yes name=flag dbname="u_inware.flag" initial="0" values="	1/	0" )
 column=(type=datetime updatewhereclause=yes name=auditingdate dbname="u_inware.auditingdate" )
 column=(type=char(10) updatewhereclause=yes name=auditingrep dbname="u_inware.auditingrep" initial="empty" )
 column=(type=long updatewhereclause=yes name=u_inware_secflag dbname="u_inware.secflag" initial="0" values="	1/	0" )
 column=(type=datetime updatewhereclause=yes name=u_inware_secauditingdate dbname="u_inware.secauditingdate" initial="today" )
 column=(type=char(10) updatewhereclause=yes name=u_inware_secauditingrep dbname="u_inware.secauditingrep" )
 column=(type=char(30) updatewhereclause=yes name=inwarecode dbname="u_inware.inwarecode" initial="empty" )
 column=(type=long updatewhereclause=yes name=balcflag dbname="u_inware.balcflag" initial="0" values="	1/	0" )
 column=(type=char(50) updatewhereclause=yes name=u_spt_name dbname="u_spt.name" initial="empty" )
 column=(type=long updatewhereclause=yes name=sptid dbname="u_inware.sptid" initial="0" )
 column=(type=char(30) updatewhereclause=yes name=u_storage_storagename dbname="u_storage.storagename" )
 column=(type=long updatewhereclause=yes name=u_inware_relid dbname="u_inware.relid" initial="0" )
 column=(type=long updatewhereclause=yes name=u_inware_thflag dbname="u_inware.thflag" values="	1/	0" )
 column=(type=long updatewhereclause=yes name=u_inware_scid dbname="u_inware.scid" )
 column=(type=char(10) updatewhereclause=yes name=u_inware_modemp dbname="u_inware.Modemp" )
 column=(type=datetime updatewhereclause=yes name=u_inware_moddate dbname="u_inware.moddate" )
 column=(type=long updatewhereclause=yes name=u_inware_printnum dbname="u_inware.printnum" )
 column=(type=long updatewhereclause=yes name=u_inware_balcdateint dbname="u_inware.balcdateint" )
 retrieve="  SELECT top 0 
			u_inware.inwareid,   
         u_inware.storageid,   
			u_inware.otheramt,
         u_spt.sptcode,      
         u_inware.indate,   
         u_inware.inrep,   
         u_inware.part,  
         u_inware.relint_1,
         u_inware.dscrp,
          u_inware.opdate,   
         u_inware.opemp,       
         u_inware.flag,   
         u_inware.auditingdate,   
         u_inware.auditingrep,   
			 u_inware.secflag,   
         u_inware.secauditingdate,   
         u_inware.secauditingrep,  
         u_inware.inwarecode,   
         u_inware.balcflag,   
         u_spt.name,   
         u_inware.sptid,   
         u_storage.storagename,   
         u_inware.relid,   
         u_inware.thflag,   
         u_inware.scid,   
         u_inware.Modemp,   
         u_inware.moddate ,   
         u_inware.printnum ,
			u_inware.balcdateint
    FROM u_inware ,   
         u_spt,   
         u_storage  
   WHERE ( u_inware.sptid = u_spt.sptid ) and  
         ( u_inware.storageid = u_storage.storageid ) and  
         ( ( u_inware.billtype = 1 ) )    
"  sort="inwareid D " )
bitmap(band=detail filename="dview.bmp" x="1920" y="412" height="60" width="69" border="0"  name=p_dview pointer="HyperLink!" visible="1" )
text(band=detail alignment="1" text="仓审" border="0" color="0~tif(flag=1,rgb(0,0,255),rgb(255,0,0))" x="855" y="28" height="56" width="110" html.valueishtml="0"  name=flag_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=12 alignment="2" tabsequence=32766 border="0" color="0~tif(flag=1,rgb(0,0,255),rgb(255,0,0))" x="978" y="28" height="56" width="110" format="[general]" html.valueishtml="0"  name=flag  tag="审核标志" visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes  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="283" html.valueishtml="0"  name=inwarecode_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=18 alignment="0" tabsequence=32766 border="4" color="0" x="320" y="28" height="68" width="507" format="[general]" html.valueishtml="0"  name=inwarecode  tag="单据编号" visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="700"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
text(band=detail alignment="2" text="待审核" border="0" color="255" x="1541" y="28" height="56" width="192" html.valueishtml="0"  name=t_3 visible="1~t1- flag"  font.face="宋体" font.height="-9" font.weight="700"  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="1193" y="28" height="56" width="142" html.valueishtml="0"  name=balcflag_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=19 alignment="2" tabsequence=32766 border="0" color="0" x="1353" y="28" height="56" width="110" format="[general]" html.valueishtml="0"  name=balcflag visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=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=2 alignment="0" tabsequence=32766 border="4" color="0" x="320" y="120" height="68" width="507" format="[general]" html.valueishtml="0"  name=storageid  tag="仓库" visible="1" dddw.name=dw_dddw_storage_withscid dddw.displaycolumn=storagename dddw.datacolumn=storageid dddw.percentwidth=100 dddw.lines=100 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="2" 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="120" height="56" width="283" html.valueishtml="0"  name=storageid_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=4 alignment="0" tabsequence=32766 border="4" color="0" x="1147" y="116" height="68" width="818" format="[general]" html.valueishtml="0"  name=u_spt_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" )
text(band=detail alignment="1" text="供应商编号" border="0" color="0" x="850" y="120" height="56" width="283" html.valueishtml="0"  name=u_spt_sptcode_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=11 alignment="0" tabsequence=32766 border="4" color="0" x="1083" y="500" height="68" width="379" format="[general]" html.valueishtml="0"  name=u_inware_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="2" 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="500" height="56" width="229" html.valueishtml="0"  name=operator_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="500" height="56" width="283" html.valueishtml="0"  name=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" )
column(band=detail id=26 alignment="0" tabsequence=32766 border="4" color="0" x="1083" y="588" height="68" width="379" format="[general]" html.valueishtml="0"  name=u_inware_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" )
text(band=detail alignment="1" text="修 改 人" border="0" color="0" x="841" y="588" height="56" width="229" html.valueishtml="0"  name=u_inware_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="18" y="588" height="56" width="283" html.valueishtml="0"  name=u_inware_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~tif(flag=1,rgb(0,0,255),rgb(255,0,0))" x="841" y="676" height="56" width="229" html.valueishtml="0"  name=auditingrep_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(flag=1,rgb(0,0,255),rgb(255,0,0))" x="18" y="676" height="56" width="283" html.valueishtml="0"  name=auditingdate_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="224" height="56" width="283" html.valueishtml="0"  name=indate_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=5 alignment="2" tabsequence=32766 border="4" color="0" x="320" y="224" height="68" width="507" format="yyyy-mm-dd " html.valueishtml="0"  name=indate  tag="进仓发生时间" visible="1" editmask.spin=yes editmask.mask="yyyy-mm-dd" editmask.imemode=0 editmask.spinrange="~~" editmask.spinincr=1 editmask.focusrectangle=no  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" 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="224" height="56" width="229" html.valueishtml="0"  name=inrep_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=6 alignment="0" tabsequence=32766 border="4" color="0" x="1079" y="224" height="68" width="379" format="[general]" html.valueishtml="0"  name=inrep visible="1" dddw.name=ddd_inrep_1 dddw.displaycolumn=inrep dddw.datacolumn=inrep dddw.percentwidth=100 dddw.lines=10 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="2" 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="316" height="56" width="283" html.valueishtml="0"  name=part_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="325" y="316" height="68" width="507" format="[general]" html.valueishtml="0"  name=part  tag="相关部门" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" 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="408" height="56" width="283" 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" )
column(band=detail id=10 alignment="0" tabsequence=32766 border="4" color="0" x="320" y="500" height="68" width="507" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=opdate  tag="建立时间" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=27 alignment="0" tabsequence=32766 border="4" color="0" x="320" y="588" height="68" width="507" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=u_inware_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="0" x="320" y="408" height="68" width="1586" format="[general]" html.valueishtml="0"  name=dscrp  tag="备注" visible="1" edit.limit=200 edit.case=any edit.focusrectangle=no edit.autoselect=no edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=14 alignment="0" tabsequence=32766 border="4" color="0~tif(flag=1,rgb(0,0,255),rgb(255,0,0))" x="1083" y="676" height="68" width="379" format="[general]" html.valueishtml="0"  name=auditingrep  tag="审核人" visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=13 alignment="0" tabsequence=32766 border="4" color="0~tif(flag=1,rgb(0,0,255),rgb(255,0,0))" x="320" y="676" height="68" width="507" format="yyyy-mm-dd hh:mm" html.valueishtml="0"  name=auditingdate  tag="审核时间" visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0  font.face="宋体" font.height="-9" font.weight="400"  font.family="2" 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" )