123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657 |
- $PBExportHeader$dw_rp_storage.srd
- release 9;
- datawindow(units=0 timer_interval=60000 color=1073741824 processing=1 HTMLDW=no print.printername="" print.documentname="" print.orientation = 2 print.margin.left = 110 print.margin.right = 110 print.margin.top = 96 print.margin.bottom = 96 print.paper.source = 0 print.paper.size = 9 print.canusedefaultprinter=yes print.prompt=no print.buttons=no print.preview.buttons=no print.cliptext=no print.overrideprintjob=no print.collate=yes hidegrayline=no grid.lines=0 )
- header(height=276 color="536870912" )
- summary(height=68 color="536870912" )
- footer(height=0 color="536870912" )
- detail(height=84 color="536870912" )
- table(column=(type=char(30) updatewhereclause=yes name=u_storage_storagename dbname="u_storage.storagename" )
- column=(type=char(10) updatewhereclause=yes name=u_storage_rep dbname="u_storage.rep" )
- column=(type=char(20) updatewhereclause=yes name=u_storage_tele dbname="u_storage.tele" )
- column=(type=long updatewhereclause=yes name=u_storage_storageid dbname="u_storage.storageid" )
- column=(type=long updatewhereclause=yes name=u_storage_mtrlprp dbname="u_storage.Mtrlprp" values="成品 0/原料 1/半成品 2/" )
- column=(type=char(2) updatewhereclause=yes name=u_storage_stattype dbname="u_storage.stattype" )
- column=(type=long updatewhereclause=yes name=u_storage_scid dbname="u_storage.scid" )
- column=(type=long updatewhereclause=yes name=u_storage_inuse dbname="u_storage.inuse" values=" 1/ 0" )
- column=(type=char(30) updatewhereclause=yes name=u_scdef_scname dbname="u_scdef.scname" )
- column=(type=long updatewhereclause=yes name=u_storage_noallocflag dbname="u_storage.noallocflag" )
- column=(type=long updatewhereclause=yes name=u_storage_balctype dbname="u_storage.balctype" )
- retrieve=" SELECT u_storage.storagename,
- u_storage.rep,
- u_storage.tele,
- u_storage.storageid,
- u_storage.Mtrlprp,
- u_storage.stattype,
- u_storage.scid,
- u_storage.inuse,
- u_scdef.scname ,
- u_storage.noallocflag,
- u_storage.balctype
- FROM u_storage,
- u_scdef
- WHERE ( u_storage.scid = u_scdef.ScID )
- " sort="u_scdef_scname A u_storage_storagename A " )
- text(band=header alignment="2" text="名称" border="2" color="33554432" x="681" y="220" height="56" width="704" html.valueishtml="0" name=u_storage_storagename_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="联系人" border="2" color="33554432" x="1394" y="220" height="56" width="439" html.valueishtml="0" name=u_storage_rep_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="电话" border="2" color="33554432" x="1842" y="220" height="56" width="594" html.valueishtml="0" name=u_storage_tele_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="属性" border="2" color="33554432" x="2446" y="220" height="56" width="265" html.valueishtml="0" name=u_storage_mtrlprp_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="统计类别" border="2" color="33554432" x="2720" y="220" height="56" width="311" html.valueishtml="0" name=u_storage_stattype_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="有效" border="2" color="33554432" x="9" y="220" height="56" width="146" html.valueishtml="0" name=u_storage_inuse_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- text(band=header alignment="2" text="分部" border="2" color="33554432" x="165" y="220" height="56" width="507" html.valueishtml="0" name=u_scdef_scname_t visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- column(band=detail id=1 alignment="2" tabsequence=32766 border="0" color="33554432" x="681" y="8" height="68" width="704" format="[general]" html.valueishtml="0" name=u_storage_storagename visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- column(band=detail id=2 alignment="0" tabsequence=32766 border="0" color="33554432" x="1394" y="8" height="68" width="439" format="[general]" html.valueishtml="0" name=u_storage_rep visible="1" edit.limit=10 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432" x="1842" y="8" height="68" width="594" format="[general]" html.valueishtml="0" name=u_storage_tele visible="1" edit.limit=20 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- column(band=detail id=5 alignment="2" tabsequence=32766 border="0" color="33554432" x="2446" y="8" height="68" width="265" format="[general]" html.valueishtml="0" name=u_storage_mtrlprp visible="1" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- column(band=detail id=6 alignment="2" tabsequence=32766 border="0" color="33554432" x="2720" y="8" height="68" width="311" format="[general]" html.valueishtml="0" name=u_storage_stattype visible="1" edit.limit=2 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- column(band=detail id=8 alignment="2" tabsequence=32766 border="0" color="33554432" x="9" y="8" height="68" width="146" format="[general]" html.valueishtml="0" name=u_storage_inuse visible="1" checkbox.text="" checkbox.on="1" checkbox.off="0" checkbox.scale=no checkbox.threed=yes font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- column(band=detail id=9 alignment="2" tabsequence=32766 border="0" color="33554432" x="165" y="8" height="68" width="507" format="[general]" html.valueishtml="0" name=u_scdef_scname visible="1" edit.limit=30 edit.case=any edit.focusrectangle=no edit.autoselect=yes edit.autohscroll=yes edit.imemode=0 font.face="宋体" font.height="-10" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- compute(band=summary alignment="2" expression="count(u_storage_storagename for all)"border="0" color="33554432" x="681" y="4" height="60" width="704" format="[general]" html.valueishtml="0" name=compute_1 visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- text(band=summary alignment="2" text="合计" border="0" color="0" x="165" y="4" height="60" width="507" html.valueishtml="0" name=t_2 visible="1" font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
- text(band=foreground alignment="1" text="" border="0" color="33554431" x="0" y="0" height="216" width="3090" html.valueishtml="0" name=t_1 visible="1" resizeable=1 font.face="宋体" font.height="-10" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
- compute(band=foreground alignment="0" expression="'打印日期: '+string(today(),'yyyy-mm-dd')+' 共 '+string(pageCount())+' 页 第 ' + string(page()) + ' 页'"border="0" color="0" x="9" y="144" height="56" width="2075" format="[general]" html.valueishtml="0" name=pagemsg visible="1" moveable=1 font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
- text(band=foreground alignment="0" text="仓库资料" border="0" color="0" x="9" y="8" height="124" width="1678" html.valueishtml="0" name=title visible="1" moveable=1 font.face="宋体" font.height="-20" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="2" background.color="33554431" )
- 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" )
|