743
社区成员
发帖
与我相关
我的任务
分享在线等，紧急求助。。。。
问题满简单： 下面是代码 把 “备注”改到 “金额” 后面就可以了，谢谢 在线等啊。。。满急的问题，现在就要用的，在线等答案，谢谢！
$PBExportHeader$jh.srd
release 9;
datawindow(units=0 timer_interval=0 color=1090519039 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 )
header(height=460 color="536870912" )
summary(height=92 color="536870912" )
footer(height=196 color="536870912" )
detail(height=80 color="536870912" )
table(column=(type=char(18) update=yes updatewhereclause=yes name=importno dbname="IMPORT.importno" )
column=(type=char(1) update=yes updatewhereclause=yes name=busiflag dbname="IMPORT.busiflag" )
column=(type=char(8) update=yes updatewhereclause=yes name=dddw_vendorno dbname="IMPORT.vendorno" values="" )
column=(type=datetime update=yes updatewhereclause=yes name=inputdate dbname="IMPORT.inputdate" )
column=(type=char(5) update=yes updatewhereclause=yes name=dddw_operator dbname="IMPORT.operator" values="" )
column=(type=char(5) update=yes updatewhereclause=yes name=dddw_employee dbname="IMPORT.employee" values="" )
column=(type=char(1) update=yes updatewhereclause=yes name=auditflag dbname="IMPORT.auditflag" )
column=(type=datetime update=yes updatewhereclause=yes name=auditdate dbname="IMPORT.auditdate" )
column=(type=char(100) update=yes updatewhereclause=yes name=remark dbname="IMPORT.remark" )
column=(type=char(13) updatewhereclause=yes name=goodsno dbname="IMPORTDETAIL.goodsno" )
column=(type=decimal(4) updatewhereclause=yes name=qty dbname="IMPORTDETAIL.qty" )
column=(type=decimal(5) updatewhereclause=yes name=price dbname="IMPORTDETAIL.price" )
column=(type=decimal(3) updatewhereclause=yes name=taxratio dbname="IMPORTDETAIL.taxratio" )
column=(type=char(50) updatewhereclause=yes name=name dbname="GOODS.name" )
column=(type=char(16) updatewhereclause=yes name=spec dbname="GOODS.spec" )
column=(type=char(6) updatewhereclause=yes name=saleunit dbname="GOODS.saleunit" )
column=(type=decimal(2) updatewhereclause=yes name=packratio dbname="GOODS.packratio" )
column=(type=char(5) updatewhereclause=yes name=dddw_aoperator dbname="IMPORT.auditoperator" values="" )
column=(type=char(12) updatewhereclause=yes name=invoiceno dbname="IMPORT.invoiceno" )
column=(type=datetime updatewhereclause=yes name=invoicedate dbname="IMPORT.invoicedate" )
column=(type=char(18) updatewhereclause=yes name=orderno dbname="IMPORT.orderno" )
column=(type=char(4) updatewhereclause=yes name=dddw_inputshop dbname="IMPORT.inputshop" )
column=(type=char(4) updatewhereclause=yes name=dddw_shopno dbname="IMPORT.shopno" values="" )
column=(type=char(7) updatewhereclause=yes name=dddw_dmno dbname="IMPORT.dmno" )
column=(type=datetime updatewhereclause=yes name=checkdate dbname="IMPORT.checkdate" )
column=(type=char(1) updatewhereclause=yes name=ischeck dbname="IMPORT.ischeck" )
column=(type=char(10) updatewhereclause=yes name=ud1 dbname="IMPORT.ud1" )
column=(type=char(10) updatewhereclause=yes name=ud2 dbname="IMPORT.ud2" )
column=(type=char(8) updatewhereclause=yes name=dddw_classno dbname="IMPORTDETAIL.classno" values="" )
column=(type=char(2) updatewhereclause=yes name=dddw_groupno dbname="IMPORTDETAIL.groupno" )
column=(type=decimal(4) updatewhereclause=yes name=giftqty dbname="IMPORTDETAIL.giftqty" )
column=(type=decimal(3) updatewhereclause=yes name=retailprice dbname="IMPORTDETAIL.retailprice" )
column=(type=datetime updatewhereclause=yes name=makedate dbname="IMPORTDETAIL.makedate" )
column=(type=long updatewhereclause=yes name=rowno dbname="IMPORTDETAIL.rowno" )
column=(type=char(25) updatewhereclause=yes name=barcode dbname="GOODS.barcode" )
column=(type=char(15) updatewhereclause=yes name=parea dbname="GOODS.parea" )
column=(type=char(16) updatewhereclause=yes name=model dbname="GOODS.model" )
retrieve=" select import.importno ,
$PBExportHeader$jh.srd
release 9;
datawindow(units=0 timer_interval=0 color=1090519039 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 )
header(height=460 color="536870912" )
summary(height=92 color="536870912" )
footer(height=196 color="536870912" )
detail(height=80 color="536870912" )
table(column=(type=char(18) update=yes updatewhereclause=yes name=importno dbname="IMPORT.importno" )
column=(type=char(1) update=yes updatewhereclause=yes name=busiflag dbname="IMPORT.busiflag" )
column=(type=char(8) update=yes updatewhereclause=yes name=dddw_vendorno dbname="IMPORT.vendorno" values="" )
column=(type=datetime update=yes updatewhereclause=yes name=inputdate dbname="IMPORT.inputdate" )
column=(type=char(5) update=yes updatewhereclause=yes name=dddw_operator dbname="IMPORT.operator" values="" )
column=(type=char(5) update=yes updatewhereclause=yes name=dddw_employee dbname="IMPORT.employee" values="" )
column=(type=char(1) update=yes updatewhereclause=yes name=auditflag dbname="IMPORT.auditflag" )
column=(type=datetime update=yes updatewhereclause=yes name=auditdate dbname="IMPORT.auditdate" )
column=(type=char(100) update=yes updatewhereclause=yes name=remark dbname="IMPORT.remark" )
column=(type=char(13) updatewhereclause=yes name=goodsno dbname="IMPORTDETAIL.goodsno" )
column=(type=decimal(4) updatewhereclause=yes name=qty dbname="IMPORTDETAIL.qty" )
column=(type=decimal(5) updatewhereclause=yes name=price dbname="IMPORTDETAIL.price" )
column=(type=decimal(3) updatewhereclause=yes name=taxratio dbname="IMPORTDETAIL.taxratio" )
column=(type=char(50) updatewhereclause=yes name=name dbname="GOODS.name" )
column=(type=char(16) updatewhereclause=yes name=spec dbname="GOODS.spec" )
column=(type=char(6) updatewhereclause=yes name=saleunit dbname="GOODS.saleunit" )
column=(type=decimal(2) updatewhereclause=yes name=packratio dbname="GOODS.packratio" )
column=(type=char(5) updatewhereclause=yes name=dddw_aoperator dbname="IMPORT.auditoperator" values="" )
column=(type=char(12) updatewhereclause=yes name=invoiceno dbname="IMPORT.invoiceno" )
column=(type=datetime updatewhereclause=yes name=invoicedate dbname="IMPORT.invoicedate" )
column=(type=char(18) updatewhereclause=yes name=orderno dbname="IMPORT.orderno" )
column=(type=char(4) updatewhereclause=yes name=dddw_inputshop dbname="IMPORT.inputshop" )
column=(type=char(4) updatewhereclause=yes name=dddw_shopno dbname="IMPORT.shopno" values="" )
column=(type=char(7) updatewhereclause=yes name=dddw_dmno dbname="IMPORT.dmno" )
column=(type=datetime updatewhereclause=yes name=checkdate dbname="IMPORT.checkdate" )
column=(type=char(1) updatewhereclause=yes name=ischeck dbname="IMPORT.ischeck" )
column=(type=char(10) updatewhereclause=yes name=ud1 dbname="IMPORT.ud1" )
column=(type=char(10) updatewhereclause=yes name=ud2 dbname="IMPORT.ud2" )
column=(type=char(8) updatewhereclause=yes name=dddw_classno dbname="IMPORTDETAIL.classno" values="" )
column=(type=char(2) updatewhereclause=yes name=dddw_groupno dbname="IMPORTDETAIL.groupno" )
column=(type=decimal(4) updatewhereclause=yes name=giftqty dbname="IMPORTDETAIL.giftqty" )
column=(type=decimal(3) updatewhereclause=yes name=retailprice dbname="IMPORTDETAIL.retailprice" )
column=(type=datetime updatewhereclause=yes name=makedate dbname="IMPORTDETAIL.makedate" )
column=(type=long updatewhereclause=yes name=rowno dbname="IMPORTDETAIL.rowno" )
column=(type=char(25) updatewhereclause=yes name=barcode dbname="GOODS.barcode" )
column=(type=char(15) updatewhereclause=yes name=parea dbname="GOODS.parea" )
column=(type=char(16) updatewhereclause=yes name=model dbname="GOODS.model" )
retrieve=" select import.importno ,
...全文
请发表友善的回复…
发表回复
eviler 2008-10-25
- 打赏
- 举报
你的这个数据窗口风格应该是 grid 风格的
1.双击这个数据窗口，在右边会显示出这个数据窗口的编辑界面，这里你是不能改变位置的
2.这时 选择菜单 view -> preview ,这时右面窗口中的下半部分也会出现一列标题吧，选中某列标题，你就拖动吧，之后保存一下就可以了
1.双击这个数据窗口，在右边会显示出这个数据窗口的编辑界面，这里你是不能改变位置的
2.这时 选择菜单 view -> preview ,这时右面窗口中的下半部分也会出现一列标题吧，选中某列标题，你就拖动吧，之后保存一下就可以了
msf 2008-10-25
- 打赏
- 举报
在PB的数据库窗口上点大右键。MODIFY DATAWINDOW
之后在这个窗口出来的预览窗口直接拖动你的列在指定的位置就可以。是预窗口。下边的那个。
之后在这个窗口出来的预览窗口直接拖动你的列在指定的位置就可以。是预窗口。下边的那个。
ldysky 2008-10-25
- 打赏
- 举报
你好 你能不能说的具体点啊!操作步骤! 跪谢你
jlwei888 2008-10-25
- 打赏
- 举报
用PB打开这个DW，其中有个预览窗口，显示DW的实际效果，你点一个列，就可以移动了！
yxwonline 2008-10-25
- 打赏
- 举报
怎么移？ 不不懂PB啊！
yxwonline 2008-10-25
- 打赏
- 举报
text(band=footer alignment="0" text="小 计：" border="0" color="0" x="23" y="8" height="56" width="302" html.valueishtml="0" name=t_1 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
compute(band=footer alignment="1" expression="sum(AMT for page)"border="0" color="0" x="2766" y="12" height="60" width="361" format="#,##0.00" html.valueishtml="0" name=compute_1 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=footer alignment="0" text="操作员：" border="0" color="0" x="18" y="116" height="60" width="293" html.valueishtml="0" name=dddw_operator_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=footer alignment="0" text="审核人：" border="0" color="0" x="2510" y="116" height="60" width="288" html.valueishtml="0" name=dddw_aoperator_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=footer id=18 alignment="0" tabsequence=32766 border="0" color="0" x="2798" y="116" height="60" width="402" format="[general]" html.valueishtml="0" name=dddw_aoperator visible="1" dddw.name=d_base_operator dddw.displaycolumn=name dddw.datacolumn=operator dddw.percentwidth=280 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.autohscroll=yes dddw.imemode=0 dddw.vscrollbar=yes dddw.autoretrieve=no font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=footer alignment="0" text="录入日期：" border="0" color="0" x="1211" y="116" height="60" width="357" html.valueishtml="0" name=inputdate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=footer id=4 alignment="2" tabsequence=32766 border="0" color="0" x="1568" y="116" height="60" width="402" format="yyyy-mm-dd" html.valueishtml="0" name=inputdate 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="0" background.mode="1" background.color="553648127" )
column(band=footer id=5 alignment="0" tabsequence=32766 border="0" color="0" x="311" y="116" height="60" width="398" format="[general]" html.valueishtml="0" name=dddw_operator visible="1" dddw.name=d_base_operator dddw.displaycolumn=name dddw.datacolumn=operator dddw.percentwidth=280 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.autohscroll=yes dddw.imemode=0 dddw.vscrollbar=yes dddw.autoretrieve=no font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=summary alignment="0" expression="gf_upperamout(sum_amt)"border="0" color="0" x="343" y="8" height="56" width="1417" format="[GENERAL]" html.valueishtml="0" name=compute_2 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="553648127" )
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" )
compute(band=footer alignment="1" expression="sum(AMT for page)"border="0" color="0" x="2766" y="12" height="60" width="361" format="#,##0.00" html.valueishtml="0" name=compute_1 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=footer alignment="0" text="操作员：" border="0" color="0" x="18" y="116" height="60" width="293" html.valueishtml="0" name=dddw_operator_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
text(band=footer alignment="0" text="审核人：" border="0" color="0" x="2510" y="116" height="60" width="288" html.valueishtml="0" name=dddw_aoperator_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=footer id=18 alignment="0" tabsequence=32766 border="0" color="0" x="2798" y="116" height="60" width="402" format="[general]" html.valueishtml="0" name=dddw_aoperator visible="1" dddw.name=d_base_operator dddw.displaycolumn=name dddw.datacolumn=operator dddw.percentwidth=280 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.autohscroll=yes dddw.imemode=0 dddw.vscrollbar=yes dddw.autoretrieve=no font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=footer alignment="0" text="录入日期：" border="0" color="0" x="1211" y="116" height="60" width="357" html.valueishtml="0" name=inputdate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=footer id=4 alignment="2" tabsequence=32766 border="0" color="0" x="1568" y="116" height="60" width="402" format="yyyy-mm-dd" html.valueishtml="0" name=inputdate 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="0" background.mode="1" background.color="553648127" )
column(band=footer id=5 alignment="0" tabsequence=32766 border="0" color="0" x="311" y="116" height="60" width="398" format="[general]" html.valueishtml="0" name=dddw_operator visible="1" dddw.name=d_base_operator dddw.displaycolumn=name dddw.datacolumn=operator dddw.percentwidth=280 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.autohscroll=yes dddw.imemode=0 dddw.vscrollbar=yes dddw.autoretrieve=no font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
compute(band=summary alignment="0" expression="gf_upperamout(sum_amt)"border="0" color="0" x="343" y="8" height="56" width="1417" format="[GENERAL]" html.valueishtml="0" name=compute_2 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="553648127" )
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" )
jlwei888 2008-10-25
- 打赏
- 举报
晕，你直接移过去不就行了！
yxwonline 2008-10-25
- 打赏
- 举报
line(band=header x1="14" y1="456" x2="3095" y2="456" name=obj_15691982 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
line(band=header x1="14" y1="360" x2="3095" y2="360" name=obj_15691983 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
line(band=detail x1="14" y1="0" x2="14" y2="80" name=obj_15691984 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=34 alignment="1" tabsequence=32766 border="0" color="0" x="23" y="4" height="60" width="101" format="[general]" html.valueishtml="0" name=rowno 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="137" y1="0" x2="137" y2="80" name=obj_15691985 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=35 alignment="1" tabsequence=32766 border="0" color="0" x="146" y="4" height="60" width="448" format="[general]" html.valueishtml="0" name=barcode 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="603" y1="0" x2="603" y2="80" name=obj_15691986 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=14 alignment="0" tabsequence=32766 border="0" color="0" x="617" y="4" height="60" width="896" format="[general]" html.valueishtml="0" name=name 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="1527" y1="0" x2="1527" y2="80" name=obj_15691987 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
line(band=detail x1="1806" y1="0" x2="1806" y2="80" name=obj_15691988 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=16 alignment="2" tabsequence=32766 border="0" color="0" x="1815" y="4" height="60" width="151" format="[general]" html.valueishtml="0" name=saleunit 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="1975" y1="0" x2="1975" y2="80" name=obj_15691989 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=12 alignment="1" tabsequence=32766 border="0" color="0" x="1984" y="4" height="60" width="402" format="#,##0.0000" html.valueishtml="0" name=price 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="2395" y1="0" x2="2395" y2="80" name=obj_15691990 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=11 alignment="1" tabsequence=32766 border="0" color="0" x="2405" y="4" height="60" width="302" format="#,##0.00" html.valueishtml="0" name=qty 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="2715" y1="0" x2="2715" y2="80" name=obj_15691991 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
compute(band=detail alignment="1" expression="ROUND(PRICE * QTY ,2)"border="0" color="0" x="2725" y="4" height="60" width="361" format="#,##0.00" html.valueishtml="0" name=amt visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=detail x1="3095" y1="0" x2="3095" y2="80" name=obj_15691992 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
line(band=detail x1="14" y1="76" x2="3095" y2="76" name=obj_15691993 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=summary alignment="0" text="备注：" border="0" color="0" x="9" y="172" height="60" width="219" html.valueishtml="0" name=remark_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
compute(band=summary alignment="1" expression="sum(AMT for all)"border="0" color="0" x="2725" y="4" height="60" width="361" format="#,##0.00" html.valueishtml="0" name=sum_amt visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=summary x1="14" y1="0" x2="14" y2="80" name=obj_15691994 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
line(band=summary x1="3095" y1="0" x2="3095" y2="80" name=obj_15691996 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=summary id=9 alignment="0" tabsequence=32766 border="0" color="0" x="229" y="172" height="60" width="800" format="[general]" html.valueishtml="0" name=remark 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="0" background.mode="1" background.color="553648127" )
line(band=summary x1="14" y1="80" x2="3095" y2="80" name=obj_15691995 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=summary alignment="0" text="合 计：" border="0" color="0" x="18" y="4" height="72" width="302" html.valueishtml="0" name=hj_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="14" y1="360" x2="3095" y2="360" name=obj_15691983 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
line(band=detail x1="14" y1="0" x2="14" y2="80" name=obj_15691984 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=34 alignment="1" tabsequence=32766 border="0" color="0" x="23" y="4" height="60" width="101" format="[general]" html.valueishtml="0" name=rowno 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="137" y1="0" x2="137" y2="80" name=obj_15691985 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=35 alignment="1" tabsequence=32766 border="0" color="0" x="146" y="4" height="60" width="448" format="[general]" html.valueishtml="0" name=barcode 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="603" y1="0" x2="603" y2="80" name=obj_15691986 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=14 alignment="0" tabsequence=32766 border="0" color="0" x="617" y="4" height="60" width="896" format="[general]" html.valueishtml="0" name=name 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="1527" y1="0" x2="1527" y2="80" name=obj_15691987 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
line(band=detail x1="1806" y1="0" x2="1806" y2="80" name=obj_15691988 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=16 alignment="2" tabsequence=32766 border="0" color="0" x="1815" y="4" height="60" width="151" format="[general]" html.valueishtml="0" name=saleunit 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="1975" y1="0" x2="1975" y2="80" name=obj_15691989 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=12 alignment="1" tabsequence=32766 border="0" color="0" x="1984" y="4" height="60" width="402" format="#,##0.0000" html.valueishtml="0" name=price 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="2395" y1="0" x2="2395" y2="80" name=obj_15691990 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=detail id=11 alignment="1" tabsequence=32766 border="0" color="0" x="2405" y="4" height="60" width="302" format="#,##0.00" html.valueishtml="0" name=qty 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="0" background.mode="1" background.color="553648127" )
line(band=detail x1="2715" y1="0" x2="2715" y2="80" name=obj_15691991 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
compute(band=detail alignment="1" expression="ROUND(PRICE * QTY ,2)"border="0" color="0" x="2725" y="4" height="60" width="361" format="#,##0.00" html.valueishtml="0" name=amt visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=detail x1="3095" y1="0" x2="3095" y2="80" name=obj_15691992 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
line(band=detail x1="14" y1="76" x2="3095" y2="76" name=obj_15691993 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=summary alignment="0" text="备注：" border="0" color="0" x="9" y="172" height="60" width="219" html.valueishtml="0" name=remark_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
compute(band=summary alignment="1" expression="sum(AMT for all)"border="0" color="0" x="2725" y="4" height="60" width="361" format="#,##0.00" html.valueishtml="0" name=sum_amt visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=summary x1="14" y1="0" x2="14" y2="80" name=obj_15691994 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
line(band=summary x1="3095" y1="0" x2="3095" y2="80" name=obj_15691996 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
column(band=summary id=9 alignment="0" tabsequence=32766 border="0" color="0" x="229" y="172" height="60" width="800" format="[general]" html.valueishtml="0" name=remark 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="0" background.mode="1" background.color="553648127" )
line(band=summary x1="14" y1="80" x2="3095" y2="80" name=obj_15691995 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=summary alignment="0" text="合 计：" border="0" color="0" x="18" y="4" height="72" width="302" html.valueishtml="0" name=hj_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
yxwonline 2008-10-25
- 打赏
- 举报
text(band=header alignment="2" text="茶城超市入库单" border="0" color="0" x="530" y="24" height="124" width="1509" html.valueishtml="0" name=title_t visible="1" font.face="楷体_GB2312" font.height="-20" font.weight="400" font.family="1" font.pitch="1" font.charset="134" background.mode="1" background.color="536870912" )
text(band=header alignment="0" text="单据号：" border="0" color="0" x="9" y="200" height="60" width="293" html.valueishtml="0" name=importno_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=header id=1 alignment="0" tabsequence=32766 border="0" color="0" x="302" y="200" height="60" width="498" format="[general]" html.valueishtml="0" name=importno 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="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="供应商：" border="0" color="0" x="9" y="280" height="60" width="293" html.valueishtml="0" name=dddw_vendorno_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=header id=3 alignment="0" tabsequence=32766 border="0" color="0" x="302" y="280" height="60" width="398" format="[general]" html.valueishtml="0" name=dddw_vendorno visible="1" dddw.name=d_pub_vendor_list dddw.displaycolumn=name dddw.datacolumn=vendorno dddw.percentwidth=280 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.autohscroll=yes dddw.imemode=0 dddw.vscrollbar=yes dddw.autoretrieve=no font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="页号：" border="0" color="0" x="2501" y="280" height="60" width="219" html.valueishtml="0" name=page_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
compute(band=header alignment="0" expression="page() + '/' + pagecount()"border="0" color="0" x="2720" y="280" height="60" width="402" format="[general]" html.valueishtml="0" name=page visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="业务员：" border="0" color="0" x="1202" y="280" height="60" width="288" html.valueishtml="0" name=dddw_employee_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=header id=6 alignment="0" tabsequence=32766 border="0" color="0" x="1490" y="280" height="60" width="398" format="[general]" html.valueishtml="0" name=dddw_employee visible="1" dddw.name=d_base_operator dddw.displaycolumn=name dddw.datacolumn=operator dddw.percentwidth=280 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.autohscroll=yes dddw.imemode=0 dddw.vscrollbar=yes dddw.autoretrieve=no font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=header x1="14" y1="360" x2="14" y2="460" name=obj_15691973 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="行号" border="0" color="0" x="23" y="372" height="80" width="101" html.valueishtml="0" name=rowno_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="137" y1="360" x2="137" y2="460" name=obj_15691974 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="条码" border="0" color="0" x="146" y="372" height="80" width="448" html.valueishtml="0" name=barcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="603" y1="360" x2="603" y2="460" name=obj_15691975 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="名称" border="0" color="0" x="617" y="372" height="80" width="896" html.valueishtml="0" name=name_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="1527" y1="360" x2="1527" y2="460" name=obj_15691976 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="单位" border="0" color="0" x="1536" y="372" height="80" width="151" html.valueishtml="0" name=saleunit_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="1806" y1="360" x2="1806" y2="460" name=obj_15691977 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="价格" border="0" color="0" x="1815" y="372" height="80" width="402" html.valueishtml="0" name=price_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="1975" y1="360" x2="1975" y2="460" name=obj_15691978 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="数量" border="0" color="0" x="1984" y="372" height="80" width="302" html.valueishtml="0" name=qty_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="2395" y1="360" x2="2395" y2="460" name=obj_15691979 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="金额" border="0" color="0" x="2405" y="372" height="80" width="361" html.valueishtml="0" name=amt_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="2715" y1="360" x2="2715" y2="460" name=obj_15691980 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="备注" border="0" color="0" x="2725" y="372" height="56" width="261" html.valueishtml="0" name=spec_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="3095" y1="360" x2="3095" y2="460" name=obj_15691981 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="单据号：" border="0" color="0" x="9" y="200" height="60" width="293" html.valueishtml="0" name=importno_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=header id=1 alignment="0" tabsequence=32766 border="0" color="0" x="302" y="200" height="60" width="498" format="[general]" html.valueishtml="0" name=importno 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="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="供应商：" border="0" color="0" x="9" y="280" height="60" width="293" html.valueishtml="0" name=dddw_vendorno_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=header id=3 alignment="0" tabsequence=32766 border="0" color="0" x="302" y="280" height="60" width="398" format="[general]" html.valueishtml="0" name=dddw_vendorno visible="1" dddw.name=d_pub_vendor_list dddw.displaycolumn=name dddw.datacolumn=vendorno dddw.percentwidth=280 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.autohscroll=yes dddw.imemode=0 dddw.vscrollbar=yes dddw.autoretrieve=no font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="页号：" border="0" color="0" x="2501" y="280" height="60" width="219" html.valueishtml="0" name=page_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
compute(band=header alignment="0" expression="page() + '/' + pagecount()"border="0" color="0" x="2720" y="280" height="60" width="402" format="[general]" html.valueishtml="0" name=page visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
text(band=header alignment="0" text="业务员：" border="0" color="0" x="1202" y="280" height="60" width="288" html.valueishtml="0" name=dddw_employee_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
column(band=header id=6 alignment="0" tabsequence=32766 border="0" color="0" x="1490" y="280" height="60" width="398" format="[general]" html.valueishtml="0" name=dddw_employee visible="1" dddw.name=d_base_operator dddw.displaycolumn=name dddw.datacolumn=operator dddw.percentwidth=280 dddw.lines=0 dddw.limit=0 dddw.allowedit=yes dddw.useasborder=no dddw.case=any dddw.autohscroll=yes dddw.imemode=0 dddw.vscrollbar=yes dddw.autoretrieve=no font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="1" background.color="553648127" )
line(band=header x1="14" y1="360" x2="14" y2="460" name=obj_15691973 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="行号" border="0" color="0" x="23" y="372" height="80" width="101" html.valueishtml="0" name=rowno_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="137" y1="360" x2="137" y2="460" name=obj_15691974 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="条码" border="0" color="0" x="146" y="372" height="80" width="448" html.valueishtml="0" name=barcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="603" y1="360" x2="603" y2="460" name=obj_15691975 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="名称" border="0" color="0" x="617" y="372" height="80" width="896" html.valueishtml="0" name=name_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="1527" y1="360" x2="1527" y2="460" name=obj_15691976 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="单位" border="0" color="0" x="1536" y="372" height="80" width="151" html.valueishtml="0" name=saleunit_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="1806" y1="360" x2="1806" y2="460" name=obj_15691977 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="价格" border="0" color="0" x="1815" y="372" height="80" width="402" html.valueishtml="0" name=price_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="1975" y1="360" x2="1975" y2="460" name=obj_15691978 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="数量" border="0" color="0" x="1984" y="372" height="80" width="302" html.valueishtml="0" name=qty_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="2395" y1="360" x2="2395" y2="460" name=obj_15691979 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="金额" border="0" color="0" x="2405" y="372" height="80" width="361" html.valueishtml="0" name=amt_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="2715" y1="360" x2="2715" y2="460" name=obj_15691980 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
text(band=header alignment="2" text="备注" border="0" color="0" x="2725" y="372" height="56" width="261" html.valueishtml="0" name=spec_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="0" background.mode="2" background.color="16777215" )
line(band=header x1="3095" y1="360" x2="3095" y2="460" name=obj_15691981 visible="1" pen.style="0" pen.width="5" pen.color="0" background.mode="1" background.color="553648127" )
yxwonline 2008-10-25
- 打赏
- 举报
import.busiflag ,
import.vendorno ,
import.inputdate ,
import.operator ,
import.employee ,
import.auditflag ,
import.auditdate ,
import.remark ,
importdetail.goodsno ,
importdetail.qty ,
importdetail.price ,
importdetail.taxratio ,
goods.name ,
goods.spec ,
goods.saleunit ,
goods.packratio ,
import.auditoperator ,
import.invoiceno ,
import.invoicedate ,
import.orderno ,
import.inputshop ,
import.shopno ,
import.dmno ,
import.checkdate ,
import.ischeck ,
import.ud1 ,
import.ud2 ,
importdetail.classno ,
importdetail.groupno ,
importdetail.giftqty ,
importdetail.retailprice ,
importdetail.makedate ,
importdetail.rowno ,
goods.barcode ,
goods.parea ,
goods.model
from import , importdetail , goods
where ( import.importno = importdetail.importno ) and
( importdetail.goodsno = goods.goodsno ) " sort="rowno A " )
import.vendorno ,
import.inputdate ,
import.operator ,
import.employee ,
import.auditflag ,
import.auditdate ,
import.remark ,
importdetail.goodsno ,
importdetail.qty ,
importdetail.price ,
importdetail.taxratio ,
goods.name ,
goods.spec ,
goods.saleunit ,
goods.packratio ,
import.auditoperator ,
import.invoiceno ,
import.invoicedate ,
import.orderno ,
import.inputshop ,
import.shopno ,
import.dmno ,
import.checkdate ,
import.ischeck ,
import.ud1 ,
import.ud2 ,
importdetail.classno ,
importdetail.groupno ,
importdetail.giftqty ,
importdetail.retailprice ,
importdetail.makedate ,
importdetail.rowno ,
goods.barcode ,
goods.parea ,
goods.model
from import , importdetail , goods
where ( import.importno = importdetail.importno ) and
( importdetail.goodsno = goods.goodsno ) " sort="rowno A " )
