$PBExportHeader$dw_saletask_scll_ch.srd release 9; datawindow(units=0 timer_interval=0 color=1073741824 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_saletask_taskid dbname="u_SaleTask.TaskID" ) column=(type=char(15) updatewhereclause=yes name=u_saletask_taskcode dbname="u_SaleTask.TaskCode" ) column=(type=long updatewhereclause=yes name=u_cust_cusid dbname="u_cust.cusid" ) column=(type=char(20) updatewhereclause=yes name=u_cust_cuscode dbname="u_cust.cuscode" ) column=(type=char(50) updatewhereclause=yes name=u_cust_name dbname="u_cust.name" ) column=(type=datetime updatewhereclause=yes name=u_saletask_requiredate dbname="u_SaleTask.requiredate" ) column=(type=char(30) updatewhereclause=yes name=u_saletask_relcode dbname="u_SaleTask.relcode" ) column=(type=decimal(4) updatewhereclause=yes name=u_saletaskmx_saleqty dbname="u_SaleTaskMx.SaleQty" ) column=(type=decimal(5) updatewhereclause=yes name=u_saletaskmx_assignqty dbname="u_SaleTaskMx.AssignQty" ) column=(type=char(255) updatewhereclause=yes name=u_saletaskmx_mxdscrp dbname="u_SaleTaskMx.mxdscrp" ) column=(type=long updatewhereclause=yes name=u_saletaskmx_mtrlid dbname="u_SaleTaskMx.MtrlID" ) column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlcode dbname="u_mtrldef.mtrlcode" ) column=(type=char(50) updatewhereclause=yes name=u_mtrldef_mtrlname dbname="u_mtrldef.mtrlname" ) column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlmode dbname="u_mtrldef.mtrlmode" ) column=(type=char(10) updatewhereclause=yes name=u_mtrldef_unit dbname="u_mtrldef.unit" ) column=(type=char(255) updatewhereclause=yes name=u_saletaskmx_status dbname="u_SaleTaskMx.status" ) column=(type=datetime updatewhereclause=yes name=u_saletask_taskdate dbname="u_SaleTask.taskdate" ) column=(type=char(255) updatewhereclause=yes name=u_saletaskmx_woodcode dbname="u_SaleTaskMx.woodcode" ) column=(type=char(255) updatewhereclause=yes name=u_saletaskmx_pcode dbname="u_SaleTaskMx.pcode" ) column=(type=char(30) updatewhereclause=yes name=u_saletask_relcode dbname="u_SaleTask.relcode" ) column=(type=long updatewhereclause=yes name=scid dbname="u_SaleTask.scid" ) column=(type=long updatewhereclause=yes name=printid dbname="u_SaleTaskMx.printid" ) column=(type=char(30) updatewhereclause=yes name=u_mtrldef_mtrlsectype dbname="u_mtrldef.mtrlsectype" ) column=(type=char(50) updatewhereclause=yes name=u_mtrldef_zxmtrlmode dbname="u_mtrldef.zxmtrlmode" ) retrieve=" SELECT u_SaleTask.TaskID, u_SaleTask.TaskCode, u_cust.cusid, u_cust.cuscode, u_cust.name, u_SaleTask.requiredate, u_SaleTask.relcode, u_SaleTaskMx.SaleQty, u_SaleTaskMx.AssignQty, u_SaleTaskMx.mxdscrp, u_SaleTaskMx.MtrlID, u_mtrldef.mtrlcode, u_mtrldef.mtrlname, u_mtrldef.mtrlmode, u_mtrldef.unit, u_SaleTaskMx.status, u_SaleTask.taskdate, u_SaleTaskMx.woodcode, u_SaleTaskMx.pcode, u_saletask.relcode, u_saletask.scid, u_saletaskmx.printid, u_mtrldef.mtrlsectype, u_mtrldef.zxmtrlmode FROM u_cust, u_SaleTask, u_SaleTaskMx, u_mtrldef , uv_saletask_ifallinware WHERE ( u_SaleTask.scid = u_SaleTaskMx.scid ) and ( u_SaleTask.TaskID = u_SaleTaskMx.TaskID ) and ( u_cust.cusid = u_SaleTask.CusID ) and ( u_SaleTaskMx.MtrlID = u_mtrldef.mtrlid ) and ( u_SaleTask.Status = 1 ) and ( u_SaleTask.CusID = u_cust.cusid ) AND ( u_SaleTask.scid = :arg_scid OR :arg_scid = -1 ) and ( u_cust.cusareaid in (:arg_areaid_arr) or u_cust.cusareaid = 0 ) and ( uv_saletask_ifallinware.taskid = u_SaleTask.taskid) and ( :arg_flag = 0 or ( :arg_flag = 1 and uv_saletask_ifallinware.if_inware = 0 )) and u_SaleTaskMx.flag = 1 and u_SaleTaskMx.scllflag = 1 " arguments=(("arg_scid", number),("arg_areaid_arr", numberlist),("arg_flag", number)) ) text(band=header alignment="2" text="订单编号" border="0" color="0" x="9" y="8" height="56" width="315" html.valueishtml="0" name=u_saletask_taskcode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="客户编号" border="0" color="0" x="5358" y="8" height="56" width="393" html.valueishtml="0" name=u_cust_cuscode_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="客户名称" border="0" color="0" x="2825" y="8" height="56" width="585" html.valueishtml="0" name=u_cust_name_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="交货日期" border="0" color="0" x="631" y="8" height="56" width="315" html.valueishtml="0" name=u_saletask_requiredate_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="订货数量" border="0" color="0" x="2267" y="8" height="56" width="270" html.valueishtml="0" name=u_saletaskmx_saleqty_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="已排数量" border="0" color="0" x="2546" y="8" height="56" width="270" html.valueishtml="0" name=u_saletaskmx_assignqty_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="编码" border="0" color="0" x="955" y="8" height="56" width="389" 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="1" background.color="536870912" ) text(band=header alignment="2" text="品名" border="0" color="0" x="1353" y="8" height="56" width="617" 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="1" background.color="536870912" ) text(band=header alignment="2" text="明细备注" border="0" color="0" x="5760" y="8" height="56" width="576" html.valueishtml="0" name=u_saletaskmx_mxdscrp_t visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) text(band=header alignment="2" text="规格" border="0" color="0" x="4521" y="8" height="56" width="366" 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="1" background.color="536870912" ) text(band=header alignment="2" text="未排数量" border="0" color="0" x="1979" y="8" height="56" width="279" 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="15793151" ) text(band=header alignment="2" text="属性" border="0" color="0" x="3419" y="8" height="56" width="357" html.valueishtml="0" name=u_saletaskmx_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="1073741824" ) text(band=header alignment="2" text="订货日期" border="0" color="0" x="334" y="8" height="56" width="288" html.valueishtml="0" name=u_saletask_taskdate_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="1073741824" ) text(band=header alignment="2" text="属性1" border="0" color="0" x="3785" y="8" height="56" width="343" html.valueishtml="0" name=u_saletaskmx_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="1073741824" ) text(band=header alignment="2" text="属性2" border="0" color="0" x="4137" y="8" height="56" width="375" html.valueishtml="0" name=u_saletaskmx_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="1073741824" ) text(band=header alignment="2" text="相关号码" border="0" color="0" x="4896" y="8" height="56" width="453" html.valueishtml="0" name=u_saletask_relcode_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="1073741824" ) text(band=header alignment="2" text="库存单位" border="0" color="0" x="6345" y="8" height="56" width="238" 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="1073741824" ) text(band=header alignment="2" text="自定义一" border="0" color="33554432" x="6592" y="8" height="56" width="329" 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="1073741824" ) text(band=header alignment="2" text="自定义二" border="0" color="33554432" x="6930" y="8" height="56" width="398" 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="1073741824" ) column(band=detail id=2 alignment="2" tabsequence=32766 border="0" color="0" x="9" y="4" height="68" width="315" format="[general]" html.valueishtml="0" name=u_saletask_taskcode visible="1" edit.limit=15 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="0" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=4 alignment="0" tabsequence=32766 border="0" color="0" x="5358" y="4" height="68" width="393" format="[general]" html.valueishtml="0" name=u_cust_cuscode visible="1" edit.limit=20 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="0" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=5 alignment="0" tabsequence=32766 border="0" color="0" x="2825" y="4" height="68" width="585" format="[general]" html.valueishtml="0" name=u_cust_name 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="0" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=6 alignment="2" tabsequence=32766 border="0" color="0" x="631" y="4" height="68" width="315" format="yyyy-mm-dd" html.valueishtml="0" name=u_saletask_requiredate 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="0" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=8 alignment="1" tabsequence=32766 border="0" color="0" x="2267" y="4" height="68" width="270" format="#,##0.0###" html.valueishtml="0" name=u_saletaskmx_saleqty 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="0" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=9 alignment="1" tabsequence=32766 border="0" color="0" x="2546" y="4" height="68" width="270" format="#,##0.0###" html.valueishtml="0" name=u_saletaskmx_assignqty 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="0" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=12 alignment="0" tabsequence=32766 border="0" color="0" x="955" y="4" height="68" width="389" format="[general]" html.valueishtml="0" name=u_mtrldef_mtrlcode 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="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=13 alignment="0" tabsequence=32766 border="0" color="0" x="1353" y="4" height="68" width="617" format="[general]" html.valueishtml="0" name=u_mtrldef_mtrlname 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="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=10 alignment="0" tabsequence=32766 border="0" color="0" x="5760" y="4" height="68" width="576" format="[general]" html.valueishtml="0" name=u_saletaskmx_mxdscrp visible="1" edit.limit=100 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="0" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=14 alignment="0" tabsequence=32766 border="0" color="0" x="4521" y="4" height="68" width="366" 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="0" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) compute(band=detail alignment="1" expression=" u_saletaskmx_saleqty - u_saletaskmx_assignqty "border="0" color="0" x="1979" y="4" height="68" width="279" format="#,##0.0###" html.valueishtml="0" name=noassignqty visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="0" background.color="16777215~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=16 alignment="2" tabsequence=32766 border="0" color="0" x="3419" y="4" height="68" width="357" format="[general]" html.valueishtml="0" name=u_saletaskmx_status 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="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=17 alignment="2" tabsequence=32766 border="0" color="0" x="334" y="4" height="68" width="288" format="yyyy-mm-dd" html.valueishtml="0" name=u_saletask_taskdate 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="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=18 alignment="0" tabsequence=32766 border="0" color="0" x="3785" y="4" height="68" width="343" format="[general]" html.valueishtml="0" name=u_saletaskmx_woodcode 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="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=19 alignment="0" tabsequence=32766 border="0" color="0" x="4137" y="4" height="68" width="375" format="[general]" html.valueishtml="0" name=u_saletaskmx_pcode 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="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=7 alignment="0" tabsequence=32766 border="0" color="0" x="4896" y="4" height="68" width="453" format="[general]" html.valueishtml="0" name=u_saletask_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="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) column(band=detail id=15 alignment="2" tabsequence=32766 border="0" color="0" x="6345" y="4" height="68" width="238" 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="0" font.pitch="2" font.charset="134" background.mode="0" background.color="536870912~tif( noassignqty = 0 , rgb(232,242,249),rgb(255,255,255) )" ) column(band=detail id=23 alignment="0" tabsequence=32766 border="0" color="0" x="6592" y="4" height="68" width="329" 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="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) column(band=detail id=24 alignment="0" tabsequence=32766 border="0" color="0" x="6930" y="4" height="68" width="398" 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="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) compute(band=footer alignment="2" expression="count(u_saletask_taskcode for all distinct)"border="0" color="8388608" x="9" y="4" height="56" width="315" format="[general]" html.valueishtml="0" name=compute_1 visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) compute(band=footer alignment="2" expression="count(u_mtrldef_mtrlcode for all)"border="0" color="8388608" x="955" y="4" height="56" width="389" format="[general]" html.valueishtml="0" name=compute_2 visible="1" font.face="宋体" font.height="-9" font.weight="700" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) compute(band=footer alignment="1" expression="sum(u_saletaskmx_saleqty for all)"border="0" color="8388608" x="2267" y="4" height="56" width="270" format="#,##0.0###" html.valueishtml="0" name=compute_5 visible="1" font.face="宋体" font.height="-9" font.weight="400" font.family="0" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" ) compute(band=footer alignment="1" expression="sum(u_saletaskmx_assignqty for all)"border="0" color="8388608" x="2546" y="4" height="56" width="270" 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="1" background.color="536870912" ) compute(band=footer alignment="1" expression="sum( u_saletaskmx_saleqty - u_saletaskmx_assignqty for all)"border="0" color="8388608" x="1979" y="4" height="56" width="279" 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" ) sparse(names="u_saletask_taskcode u_cust_cuscode u_cust_name u_saletask_requiredate u_saletask_relcode u_saletask_taskdate")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" )