dw_rp_wfjg_waste_edit.srd 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. $PBExportHeader$dw_rp_wfjg_waste_edit.srd
  2. release 9;
  3. datawindow ( units=1 timer_interval=0 color=1073741824 processing=0 print.orientation=0 print.margin.left=24 print.margin.right=24 print.margin.top=24 print.margin.bottom=24 print.paper.size=0 print.paper.source=0 selected.mouse=no)
  4. header(height=104 color="536870912" )
  5. summary(height=25 color="536870912" )
  6. footer(height=0 color="536870912" )
  7. detail(height=32 color="536870912" height.autosize=yes)
  8. table(column=(type=long updatewhereclause=yes initial="null" name=u_order_wfjg_waste_scid dbname="u_order_wfjg_waste.scid"
  9. values="分部ID /" )
  10. column=(type=long updatewhereclause=yes initial="null" name=u_order_wfjg_waste_wasteid dbname="u_order_wfjg_waste.wasteid"
  11. values="损耗单ID /" )
  12. column=(type=char(20) updatewhereclause=yes initial="null" name=u_order_wfjg_waste_wastecode dbname="u_order_wfjg_waste.wastecode" )
  13. column=(type=char(50) updatewhereclause=yes initial="null" name=u_spt_name dbname="u_spt.name" )
  14. column=(type=datetime updatewhereclause=yes initial="null" name=u_order_wfjg_waste_wastedate dbname="u_order_wfjg_waste.wastedate" )
  15. column=(type=char(10) updatewhereclause=yes initial="null" name=u_order_wfjg_waste_assign_emp dbname="u_order_wfjg_waste.assign_emp" )
  16. column=(type=char(20) updatewhereclause=yes initial="null" name=u_order_wfjg_waste_relcode dbname="u_order_wfjg_waste.relcode" )
  17. column=(type=char(255) updatewhereclause=yes initial="null" name=u_order_wfjg_waste_dscrp dbname="u_order_wfjg_waste.dscrp" )
  18. column=(type=char(10) updatewhereclause=yes initial="null" name=u_order_wfjg_waste_opemp dbname="u_order_wfjg_waste.opemp" )
  19. column=(type=datetime updatewhereclause=yes initial="null" name=u_order_wfjg_waste_opdate dbname="u_order_wfjg_waste.opdate"
  20. values="新建时间 /" )
  21. column=(type=long updatewhereclause=yes initial="null" name=u_order_wfjg_waste_printnum dbname="u_order_wfjg_waste.printnum"
  22. values="打印次数 /" )
  23. retrieve="SELECT u_order_wfjg_waste.scid,
  24. u_order_wfjg_waste.wasteid,
  25. u_order_wfjg_waste.wastecode,
  26. u_spt.name,
  27. u_order_wfjg_waste.wastedate,
  28. u_order_wfjg_waste.assign_emp,
  29. u_order_wfjg_waste.relcode,
  30. u_order_wfjg_waste.dscrp,
  31. u_order_wfjg_waste.opemp,
  32. u_order_wfjg_waste.opdate,
  33. u_order_wfjg_waste.printnum
  34. FROM u_order_wfjg_waste left outer join u_spt on
  35. u_order_wfjg_waste.sptid = u_spt.sptid
  36. where u_order_wfjg_waste.wasteid=:arg_wasteid and
  37. ( u_order_wfjg_waste.scid = :arg_scid )
  38. "
  39. arguments=(("arg_scid", number), ("arg_wasteid", number))
  40. )
  41. line(name=l_1 visible="1" band=header background.mode="2" background.color="1073741824" pen.style="0" pen.width="2" pen.color="33554432" x1="227" y1="34" x2="401" y2="34" )
  42. text(name=t_1 visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-18" font.pitch="2" font.weight="700" background.mode="1" background.color="536870912" color="33554432" alignment="2" border="0" x="180" y="3" height="27" width="268" text="损耗单" )
  43. compute(name=compute_1 visible="1" tag="if( printnum > 0,'(重复打印-'+string(printnum)+')','')" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-12" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" x="451" y="6" height="24" width="127" format="[GENERAL]" expression="if( printnum > 0,'(重复打印-'+string(printnum)+')','')" alignment="0" border="0" crosstab.repeat=no )
  44. compute(name=compute_2 visible="1 if( pageCount()>1,1,0)" tag="'第 ' + page() + ' 页/共 ' + pageCount()+' 页'" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-9" font.pitch="2" font.weight="700" background.mode="2" background.color="16777215" color="0" x="581" y="17" height="13" width="136" format="[general]" expression="'第 ' + page() + ' 页/共 ' + pageCount()+' 页'" alignment="0" border="0" crosstab.repeat=no )
  45. text(name=wastecode_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="0" border="0" x="522" y="39" height="15" width="64" text="单据编号:" )
  46. text(name=relcode_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="0" border="0" x="318" y="62" height="15" width="64" text="相关号码:" )
  47. text(name=wastedate_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="0" border="0" x="522" y="62" height="15" width="64" text="日 期:" )
  48. column(name=u_order_wfjg_waste_wastecode visible="1" tag="u_order_wfjg_waste_wastecode" band=header id=3 x="588" y="39" height="17" width="128" color="33554432" border="0" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="700" tabsequence=0 )
  49. column(name=u_order_wfjg_waste_wastedate visible="1" tag="u_order_wfjg_waste_wastedate" band=header id=5 x="589" y="62" height="17" width="128" color="33554432" border="0" alignment="0" format="yyyy-mm-dd" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
  50. text(name=sptid_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="0" border="0" x="4" y="62" height="15" width="64" text="供 应 商:" )
  51. column(name=u_order_wfjg_waste_dscrp visible="1" tag="u_order_wfjg_waste_dscrp" band=header id=8 x="70" y="85" height="17" width="647" color="33554432" border="0" alignment="0" format="[general]" protect="0" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
  52. text(name=dscrp_t visible="1" band=header font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="0" border="0" x="4" y="85" height="15" width="64" text="备 注:" )
  53. column(name=u_spt_name visible="1" tag="u_spt_name" band=header id=4 x="70" y="62" height="17" width="232" color="33554432" border="0" alignment="0" format="[general]" protect="0" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-11" font.pitch="2" font.weight="700" tabsequence=0 )
  54. column(name=u_order_wfjg_waste_relcode visible="1" tag="u_order_wfjg_waste_relcode" band=header id=7 x="385" y="62" height="17" width="128" color="33554432" border="0" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=20 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
  55. text(name=opemp_t visible="1" band=summary font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="2" background.color="1073741824" color="33554432" alignment="0" border="0" x="4" y="4" height="15" width="63" text="建 立 人:" )
  56. column(name=u_order_wfjg_waste_opemp visible="1" tag="u_order_wfjg_waste_opemp" band=summary id=9 x="70" y="4" height="17" width="93" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.autohscroll=no edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=0 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
  57. text(name=assign_emp_t visible="1" band=summary font.charset="134" font.face="宋体" font.family="0" font.height="-10" font.pitch="2" font.weight="400" background.mode="1" background.color="536870912" color="33554432" alignment="1" border="0" x="172" y="3" height="15" width="66" text="经 手 人:" )
  58. column(name=u_order_wfjg_waste_assign_emp visible="1" tag="u_order_wfjg_waste_assign_emp" band=summary id=6 x="240" y="3" height="17" width="77" color="33554432" border="4" alignment="0" format="[general]" protect="0" edit.focusrectangle=no edit.autohscroll=yes edit.autoselect=yes edit.autovscroll=no edit.case=any edit.codetable=no edit.displayonly=no edit.hscrollbar=no edit.imemode=0 edit.limit=10 edit.password=no edit.vscrollbar=no edit.validatecode=no edit.nilisnull=no edit.required=no criteria.required=no criteria.override_edit=no crosstab.repeat=no background.mode="1" background.color="536870912" font.charset="134" font.face="宋体" font.family="2" font.height="-10" font.pitch="2" font.weight="400" tabsequence=0 )
  59. report(name=dw_1 visible="1" slideleft=yes height.autosize=yes slideup=directlyabove band=detail x="0" y="3" height="25" width="732" border="0" trail_footer=yes dataobject="dw_rp_wfjg_wastemx" nest_arguments=
  60. ((" scid "),(" wasteid ")))
  61. htmltable()
  62. htmlgen()
  63. export.xml(metadatatype=0 savemetadata=0 )
  64. import.xml()
  65. export.pdf(method=0 )