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

$PBExportHeader$dw_inwaremx_buy_audit_edit.srd
release 9;
datawindow(units=0 timer_interval=0 color=16777215 processing=1 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 grid.lines=0 selected.mouse=no )
header(height=68 color="536870912" )
summary(height=0 color="536870912" )
footer(height=64 color="536870912" )
detail(height=76 color="536870912" )
table(column=(type=long updatewhereclause=yes name=u_inwaremx_mtrlid dbname="u_inwaremx.mtrlid" initial="0" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_ifrel dbname="u_inwaremx.ifrel" initial="0" values="	1/	0" )
 column=(type=char(50) updatewhereclause=yes name=u_inwaremx_relcode dbname="u_inwaremx.relcode" initial="empty" )
 column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlcode dbname="u_mtrldef.mtrlcode" initial="empty" )
 column=(type=char(255) updatewhereclause=yes name=u_inwaremx_status dbname="u_inwaremx.status" initial="empty" )
 column=(type=char(255) updatewhereclause=yes name=u_inwaremx_woodcode dbname="u_inwaremx.woodcode" initial="empty" )
 column=(type=char(255) updatewhereclause=yes name=u_inwaremx_pcode dbname="u_inwaremx.pcode" initial="empty" )
 column=(type=char(30) updatewhereclause=yes name=u_inwaremx_unit dbname="u_inwaremx.unit" initial="empty" )
 column=(type=decimal(2) updatewhereclause=yes name=u_inwaremx_inputamt dbname="inputamt" initial="0" validationmsg="'请输入数字'" )
 column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_uqty dbname="u_inwaremx.uqty" initial="0" validationmsg="'请输入数字'" )
 column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_rate dbname="u_inwaremx.rate" initial="1" )
 column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_addqty dbname="u_inwaremx.addqty" initial="0" )
 column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_uprice dbname="u_inwaremx.uprice" initial="0" validationmsg="'请输入数字'" )
 column=(type=decimal(4) updatewhereclause=yes name=u_inwaremx_rebate dbname="u_inwaremx.rebate" initial="1" validationmsg="'请输入数字'" )
 column=(type=char(30) updatewhereclause=yes name=u_inwaremx_plancode dbname="u_inwaremx.plancode" initial="empty" )
 column=(type=char(255) updatewhereclause=yes name=u_inwaremx_formula dbname="u_inwaremx.formula" initial="empty" )
 column=(type=char(255) updatewhereclause=yes name=u_inwaremx_mxdscrp dbname="u_inwaremx.mxdscrp" initial="empty" )
 column=(type=char(255) updatewhereclause=yes name=u_inwaremx_waredscrp dbname="u_inwaremx.waredscrp" initial="empty" )
 column=(type=datetime updatewhereclause=yes name=u_inwaremx_inworkdate dbname="u_inwaremx.inworkdate" initial="empty" )
 column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_fprice dbname="u_inwaremx.fprice" initial="0" validationmsg="'请输入数字'" )
 column=(type=char(15) updatewhereclause=yes name=u_buytask_taskcode dbname="u_buyTask.taskcode" initial="empty" )
 column=(type=decimal(4) updatewhereclause=yes name=u_inwaremx_qty dbname="u_inwaremx.qty" initial="0" validationmsg="'请输入数字'" )
 column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_price dbname="u_inwaremx.price" initial="0" )
 column=(type=char(10) updatewhereclause=yes name=u_mtrldef_unit dbname="u_mtrldef.unit" initial="empty" )
 column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlname dbname="u_mtrldef.mtrlname" initial="empty" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_inwareid dbname="u_inwaremx.inwareid" initial="0" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_printid dbname="u_inwaremx.printid" initial="0" )
 column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlmode dbname="u_mtrldef.mtrlmode" initial="empty" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_relid dbname="u_inwaremx.relid" initial="0" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_relprintid dbname="u_inwaremx.relprintid" initial="0" )
 column=(type=long updatewhereclause=yes name=u_inwaremx_sptid_cusid dbname="u_inwaremx.sptid_cusid" initial="0" )
 column=(type=decimal(6) updatewhereclause=yes name=amt dbname="amt" initial="0" )
 column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_cost dbname="u_inwaremx.cost" initial="0" )
 column=(type=char(50) updatewhereclause=yes name=u_inwaremx_sptmtrlname dbname="u_inwaremx.sptmtrlname" initial="empty" )
 column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_bootqty dbname="u_inwaremx.bootqty" initial="0" )
 column=(type=decimal(5) updatewhereclause=yes name=u_inwaremx_noauditqty dbname="u_inwaremx.noauditqty" initial="0" )
 column=(type=decimal(10) updatewhereclause=yes name=u_inwaremx_dftsptprice dbname="u_inwaremx.dftsptprice" initial="0" )
 column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlsectype dbname="u_mtrldef.mtrlsectype" initial="empty" )
 column=(type=char(50) updatewhereclause=yes name=u_mtrldef_zxmtrlmode dbname="u_mtrldef.zxmtrlmode" initial="empty" )
 column=(type=long updatewhereclause=yes name=u_mtrldef_statusflag dbname="u_mtrldef.statusflag" initial="0" )
 column=(type=long updatewhereclause=yes name=u_mtrldef_woodcodeflag dbname="u_mtrldef.woodcodeflag" initial="0" )
 column=(type=long updatewhereclause=yes name=u_mtrldef_pcodeflag dbname="u_mtrldef.pcodeflag" initial="0" )
 column=(type=char(30) updatewhereclause=yes name=u_buytask_relcode dbname="u_inwaremx.buytaskrelcode" initial="empty" )
 column=(type=decimal(5) updatewhereclause=yes name=wareqty dbname="wareqty" initial="0" )
 retrieve="SELECT u_inwaremx.mtrlid,
	u_inwaremx.ifrel,
	u_inwaremx.relcode ,
	u_mtrldef.mtrlcode,
	u_inwaremx.status ,
	u_inwaremx.woodcode ,
	u_inwaremx.pcode ,
	u_inwaremx.unit,
	0.00 as inputamt,
	u_inwaremx.uqty,  
	 u_inwaremx.rate,  
	 u_inwaremx.addqty,
	u_inwaremx.uprice,
	u_inwaremx.rebate,
	u_inwaremx.plancode,
	u_inwaremx.formula,
	u_inwaremx.mxdscrp,
	u_inwaremx.waredscrp,
	u_inwaremx.inworkdate,
	u_inwaremx.fprice,
	u_buytask.taskcode,
	u_inwaremx.qty,
	u_inwaremx.price,
	u_mtrldef.unit,
	u_mtrldef.mtrlname,
	u_inwaremx.inwareid,
	u_inwaremx.printid,
	u_mtrldef.mtrlmode,
	u_inwaremx.relid ,
	u_inwaremx.relprintid ,
	u_inwaremx.sptid_cusid,
	round(u_inwaremx.uprice*u_inwaremx.rebate*u_inwaremx.uqty,2)  as amt,
	u_inwaremx.cost ,
	u_inwaremx.sptmtrlname  ,
	u_inwaremx.bootqty  ,
	u_inwaremx.noauditqty,
	u_inwaremx.dftsptprice,
	u_mtrldef.mtrlsectype,
	u_mtrldef.zxmtrlmode,
	u_mtrldef.statusflag,
	u_mtrldef.woodcodeflag,
	u_mtrldef.pcodeflag,		
	case when u_buytask.relcode is null then '' else u_buytask.relcode end as buytaskrelcode,
	0.00000 as wareqty
	FROM u_inwaremx LEFT OUTER JOIN u_buytask ON u_inwaremx.relid = u_buytask.taskid
	AND u_inwaremx.scid = u_buytask.scid left outer join 
	u_mtrldef on   ( u_inwaremx.mtrlid = u_mtrldef.mtrlid )
	WHERE ( u_inwaremx.inwareid = :arg_inwareid ) AND
	( u_inwaremx.scid = :arg_scid ) 
" arguments=(("arg_scid", number),("arg_inwareid", number))  sort="u_inwaremx_printid A " )
text(band=header alignment="2" text="品名" border="0" color="33554432" x="1029" y="8" height="56" width="608" html.valueishtml="0"  name=u_mtrldef_mtrlname_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=header alignment="2" text="入仓数量" border="0" color="33554432" x="7666" y="8" height="56" width="270" html.valueishtml="0"  name=u_inwaremx_qty_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=header alignment="2" text=" 规格" border="0" color="33554432" x="1646" y="8" height="56" width="375" html.valueishtml="0"  name=u_mtrldef_mtrlmode_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=header alignment="2" text="批号" border="0" color="33554432" x="4727" y="8" height="56" width="375" html.valueishtml="0"  name=u_inwaremx_plancode_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=header alignment="2" text="明细备注" border="0" color="33554432" x="5746" y="8" height="56" width="425" html.valueishtml="0"  name=u_inwaremx_mxdscrp_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=header alignment="2" text="序" border="0" color="33554432" x="9" y="8" height="56" width="64" html.valueishtml="0"  name=t_2 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=header alignment="2" text=" 编码" border="0" color="33554432" x="672" y="8" height="56" width="347" html.valueishtml="0"  name=u_mtrldef_mtrlcode_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=header alignment="2" text="订单" border="0" color="33554432" x="82" y="8" height="56" width="151" html.valueishtml="0"  name=u_inwaremx_ifrel_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=header alignment="2" text="属性" border="0" color="33554432" x="2697" y="8" height="56" width="402" html.valueishtml="0"  name=u_inwaremx_status_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=header alignment="2" text="属性1" border="0" color="33554432" x="3109" y="8" height="56" width="352" html.valueishtml="0"  name=u_inwaremx_woodcode_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=header alignment="2" text="属性2" border="0" color="33554432" x="3470" y="8" height="56" width="375" html.valueishtml="0"  name=u_inwaremx_pcode_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=header alignment="2" text="物料别名" border="0" color="33554432" x="7945" y="8" height="56" width="521" html.valueishtml="0"  name=u_inwaremx_sptmtrlname_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=header alignment="2" text="采购单位" border="0" color="33554432" x="3854" y="8" height="56" width="233" html.valueishtml="0"  name=u_inwaremx_unit_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=header alignment="2" text="数量" border="0" color="33554432" x="4096" y="8" height="56" width="311" html.valueishtml="0"  name=u_inwaremx_uqty_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=header alignment="2" text="公式" border="0" color="33554432" x="5111" y="8" height="56" width="626" html.valueishtml="0"  name=u_inwaremx_formula_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=header alignment="2" text="转换率" border="0" color="33554432" x="7365" y="8" height="56" width="293" html.valueishtml="0"  name=u_inwaremx_rate_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=header alignment="2" text="库存摘要" border="0" color="33554432" x="6181" y="8" height="56" width="421" html.valueishtml="0"  name=u_inwaremx_waredscrp_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=header alignment="2" text="有效期" border="0" color="33554432" x="6610" y="8" height="56" width="503" html.valueishtml="0"  name=u_inwaremx_inworkdate_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=header alignment="2" text="本次应收数" border="0" color="33554432" x="8475" y="8" height="56" width="366" html.valueishtml="0"  name=u_inwaremx_bootqty_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=header alignment="2" text="超数量" border="0" color="33554432" x="8850" y="8" height="56" width="338" 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" )
text(band=header alignment="2" text="库存单位" border="0" color="33554432" x="7122" y="8" height="56" width="233" html.valueishtml="0"  name=u_mtrldef_unit_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=header alignment="2" text="辅数" border="0" color="33554432" x="4416" y="8" height="56" width="302" html.valueishtml="0"  name=u_inwaremx_addqty_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=header alignment="2" text="自定义1" border="0" color="33554432" x="2030" y="8" height="56" width="334" html.valueishtml="0"  name=u_mtrldef_mtrlsectype_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=header alignment="2" text="自定义2" border="0" color="33554432" x="2373" y="8" height="56" width="315" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode_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=header alignment="2" text="订单号" border="0" color="33554432" x="242" y="8" height="56" width="421" html.valueishtml="0"  name=u_inwaremx_relcode_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=header alignment="2" text="已收货数" border="0" color="33554432" x="9198" y="8" height="56" width="357" html.valueishtml="0"  name=u_inwaremx_noauditqty_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=header alignment="2" text="采购订单相关号" border="0" color="33554432" x="9563" y="8" height="56" width="512" html.valueishtml="0"  name=u_buytask_relcode_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=header alignment="2" text="当前库存总量" border="0" color="33554432" x="10085" y="8" height="56" width="421" html.valueishtml="0"  name=wareqty_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=25 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="1029" y="4" height="68" width="608" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlname  tag="物料名称" visible="1" edit.limit=50 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=22 alignment="1" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="7666" y="4" height="68" width="270" format="#,##0.0###" html.valueishtml="0"  name=u_inwaremx_qty  tag="进仓数量" visible="1" edit.limit=0 edit.case=any edit.format="#########0.0###" 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=28 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="1646" y="4" height="68" width="375" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlmode 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" )
column(band=detail id=15 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="4727" y="4" height="68" width="375" format="[general]" html.valueishtml="0"  name=u_inwaremx_plancode 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" )
column(band=detail id=17 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="5746" y="4" height="68" width="425" format="[general]" html.valueishtml="0"  name=u_inwaremx_mxdscrp visible="1" edit.limit=0 edit.case=any 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" )
compute(band=detail alignment="2" expression="getrow()"border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="9" y="4" height="68" width="64" format="[general]" html.valueishtml="0"  name=printid 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=2 alignment="2" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="82" y="4" height="68" width="151" format="[general]" html.valueishtml="0"  name=u_inwaremx_ifrel 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="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="672" y="4" height="68" width="347" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlcode  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="400"  font.family="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="2697" y="4" height="68" width="402" format="[general]" html.valueishtml="0"  name=u_inwaremx_status visible="1" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.imemode=0  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=detail id=6 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="3109" y="4" height="68" width="352" format="[general]" html.valueishtml="0"  name=u_inwaremx_woodcode visible="1" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.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=7 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="3470" y="4" height="68" width="375" format="[general]" html.valueishtml="0"  name=u_inwaremx_pcode visible="1" ddlb.limit=0 ddlb.allowedit=no ddlb.case=any ddlb.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=34 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="7945" y="4" height="68" width="521" format="[general]" html.valueishtml="0"  name=u_inwaremx_sptmtrlname 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" )
column(band=detail id=8 alignment="2" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="3854" y="4" height="68" width="233" format="[general]" html.valueishtml="0"  name=u_inwaremx_unit visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 edit.displayonly=yes  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=35 alignment="1" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="8475" y="4" height="68" width="366" format="#,##0.0####" html.valueishtml="0"  name=u_inwaremx_bootqty 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" )
compute(band=detail alignment="1" expression="if ( u_inwaremx_ifrel =0 ,0 ,round(  u_inwaremx_uqty - u_inwaremx_bootqty    ,5))"border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="8850" y="4" height="68" width="338" format="#,##0.0####" html.valueishtml="0"  name=compute_5 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=detail id=11 alignment="1" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="7365" y="4" height="68" width="293" format="#,##0.00###" html.valueishtml="0"  name=u_inwaremx_rate visible="1" edit.limit=0 edit.case=any edit.format="#,##0.#####" 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" )
column(band=detail id=24 alignment="2" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="7122" y="4" height="68" width="233" format="[general]" html.valueishtml="0"  name=u_mtrldef_unit 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" )
column(band=detail id=10 alignment="1" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="4096" y="4" height="68" width="311" format="#,##0.#####" html.valueishtml="0"  name=u_inwaremx_uqty visible="1" edit.limit=0 edit.case=any edit.format="#,##0.#####" 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" )
column(band=detail id=12 alignment="1" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="4416" y="4" height="68" width="302" format="#,##0.#####" html.valueishtml="0"  name=u_inwaremx_addqty visible="1" edit.limit=0 edit.case=any edit.format="#,##0.#####" 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" )
column(band=detail id=38 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="2030" y="4" height="68" width="334" format="[general]" html.valueishtml="0"  name=u_mtrldef_mtrlsectype 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" )
column(band=detail id=39 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="2373" y="4" height="68" width="315" format="[general]" html.valueishtml="0"  name=u_mtrldef_zxmtrlmode 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" )
column(band=detail id=3 alignment="0" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="242" y="4" height="68" width="421" format="[general]" html.valueishtml="0"  name=u_inwaremx_relcode 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" )
column(band=detail id=36 alignment="1" tabsequence=32766 border="0" color="33554432~t if(u_inwaremx_uprice  *  u_inwaremx_rebate < u_inwaremx_dftsptprice ,rgb(255,0,0),rgb(0,0,0))" x="9198" y="4" height="68" width="357" format="#,##0.0####" html.valueishtml="0"  name=u_inwaremx_noauditqty 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" )
column(band=detail id=43 alignment="0" tabsequence=32766 border="0" color="33554432" x="9563" y="4" height="68" width="512" format="[general]" html.valueishtml="0"  name=u_buytask_relcode 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" )
column(band=detail id=16 alignment="0" tabsequence=32766 border="0" color="33554432" x="5111" y="4" height="68" width="626" format="[general]" html.valueishtml="0"  name=u_inwaremx_formula visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no 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" )
column(band=detail id=44 alignment="1" tabsequence=32766 border="0" color="33554432" x="10085" y="4" height="68" width="421" format="##,##0.#####" html.valueishtml="0"  name=wareqty visible="1" edit.limit=0 edit.case=any edit.format="##,##0.#####" 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=18 alignment="0" tabsequence=32766 border="0" color="33554432" x="6181" y="4" height="68" width="421" format="[general]" html.valueishtml="0"  name=u_inwaremx_waredscrp visible="1" edit.limit=0 edit.case=any edit.focusrectangle=no 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" )
column(band=detail id=19 alignment="0" tabsequence=32766 border="0" color="33554432" x="6610" y="4" height="68" width="503" format="[shortdate] [time]" html.valueishtml="0"  name=u_inwaremx_inworkdate 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="2" font.pitch="2" font.charset="134" background.mode="2" background.color="16777215" )
compute(band=footer alignment="2" expression="count(  u_mtrldef_mtrlcode  for all )"border="0" color="33554432" x="672" y="4" height="56" width="347" format="[general]" html.valueishtml="0"  name=compute_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" )
compute(band=footer alignment="1" expression="sum(u_inwaremx_qty for all)"border="0" color="33554432" x="7666" y="4" height="56" width="270" format="#,##0.0###" html.valueishtml="0"  name=compute_3 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" )
compute(band=footer alignment="1" expression="sum(u_inwaremx_uqty for all)"border="0" color="33554432" x="4096" y="4" height="56" width="311" format="#,##0.0###" html.valueishtml="0"  name=compute_4 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" )
compute(band=footer alignment="1" expression="sum(u_inwaremx_addqty for all)"border="0" color="33554432" x="4416" y="4" height="56" width="302" format="#,##0.0###" html.valueishtml="0"  name=compute_6 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" )
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  template=(comment="" encoding="gb2312" name="1" xml="<?xml version=~"1.0~" encoding=~"gb2312~" standalone=~"no~"?><dw_inwaremx_buy_edit><dw_inwaremx_buy_edit_row __pbband=~"detail~"><u_inwaremx_mtrlid>u_inwaremx_mtrlid</u_inwaremx_mtrlid><u_inwaremx_ifrel>u_inwaremx_ifrel</u_inwaremx_ifrel><u_inwaremx_relcode>u_inwaremx_relcode</u_inwaremx_relcode><u_mtrldef_mtrlcode>u_mtrldef_mtrlcode</u_mtrldef_mtrlcode><u_inwaremx_status>u_inwaremx_status</u_inwaremx_status><u_inwaremx_woodcode>u_inwaremx_woodcode</u_inwaremx_woodcode><u_inwaremx_pcode>u_inwaremx_pcode</u_inwaremx_pcode><u_inwaremx_unit>u_inwaremx_unit</u_inwaremx_unit><u_inwaremx_inputamt>u_inwaremx_inputamt</u_inwaremx_inputamt><u_inwaremx_uqty>u_inwaremx_uqty</u_inwaremx_uqty><u_inwaremx_rate>u_inwaremx_rate</u_inwaremx_rate><u_inwaremx_addqty>u_inwaremx_addqty</u_inwaremx_addqty><u_inwaremx_uprice>u_inwaremx_uprice</u_inwaremx_uprice><u_inwaremx_rebate>u_inwaremx_rebate</u_inwaremx_rebate><u_inwaremx_plancode>u_inwaremx_plancode</u_inwaremx_plancode><u_inwaremx_mxdscrp>u_inwaremx_mxdscrp</u_inwaremx_mxdscrp><u_inwaremx_fprice>u_inwaremx_fprice</u_inwaremx_fprice><u_buytask_taskcode>u_buytask_taskcode</u_buytask_taskcode><u_inwaremx_qty>u_inwaremx_qty</u_inwaremx_qty><u_inwaremx_price>u_inwaremx_price</u_inwaremx_price><u_mtrldef_unit>u_mtrldef_unit</u_mtrldef_unit><u_mtrldef_mtrlname>u_mtrldef_mtrlname</u_mtrldef_mtrlname><u_inwaremx_inwareid>u_inwaremx_inwareid</u_inwaremx_inwareid><u_inwaremx_printid>u_inwaremx_printid</u_inwaremx_printid><u_mtrldef_mtrlmode>u_mtrldef_mtrlmode</u_mtrldef_mtrlmode><u_inwaremx_relid>u_inwaremx_relid</u_inwaremx_relid><u_inwaremx_sptid_cusid>u_inwaremx_sptid_cusid</u_inwaremx_sptid_cusid><amt>amt</amt><u_inwaremx_cost>u_inwaremx_cost</u_inwaremx_cost><u_inwaremx_sptmtrlname>u_inwaremx_sptmtrlname</u_inwaremx_sptmtrlname><u_inwaremx_bootqty>u_inwaremx_bootqty</u_inwaremx_bootqty><u_inwaremx_noauditqty>u_inwaremx_noauditqty</u_inwaremx_noauditqty><u_inwaremx_dftsptprice>u_inwaremx_dftsptprice</u_inwaremx_dftsptprice><u_mtrldef_mtrlsectype>u_mtrldef_mtrlsectype</u_mtrldef_mtrlsectype><u_mtrldef_zxmtrlmode>u_mtrldef_zxmtrlmode</u_mtrldef_zxmtrlmode><u_mtrldef_statusflag/><u_mtrldef_woodcodeflag/><u_mtrldef_pcodeflag/></dw_inwaremx_buy_edit_row></dw_inwaremx_buy_edit>"))
import.xml()
export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )