dw_gz_cwork_edit.srd 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111
  1. $PBExportHeader$dw_gz_cwork_edit.srd
  2. release 9;
  3. datawindow(units=0 timer_interval=0 color=16777215 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 )
  4. summary(height=0 color="536870912" )
  5. footer(height=0 color="536870912" )
  6. detail(height=1584 color="536870912" )
  7. table(column=(type=long updatewhereclause=yes name=u_gz_cwork_billid dbname="u_gz_cwork.billid" initial="0" )
  8. column=(type=long updatewhereclause=yes name=u_gz_cwork_wageid dbname="u_gz_cwork.wageid" initial="0" )
  9. column=(type=long updatewhereclause=yes name=u_gz_cwork_cworkid dbname="u_gz_cwork.cworkid" initial="0" )
  10. column=(type=char(30) updatewhereclause=yes name=u_rs_empinfo_empcode dbname="u_rs_empinfo.Empcode" initial="empty" )
  11. column=(type=datetime updatewhereclause=yes name=u_gz_cwork_billdate dbname="u_gz_cwork.billdate" initial="today" )
  12. column=(type=decimal(2) updatewhereclause=yes name=u_gz_cwork_amt dbname="u_gz_cwork.amt" initial="0" )
  13. column=(type=long updatewhereclause=yes name=u_gz_cwork_wagemth dbname="u_gz_cwork.wagemth" initial="0" )
  14. column=(type=datetime updatewhereclause=yes name=u_gz_cwork_begindate dbname="u_gz_cwork.begindate" initial="today" )
  15. column=(type=datetime updatewhereclause=yes name=u_gz_cwork_enddate dbname="u_gz_cwork.enddate" initial="today" )
  16. column=(type=char(200) updatewhereclause=yes name=u_gz_cwork_reason dbname="u_gz_cwork.reason" initial="empty" )
  17. column=(type=char(100) updatewhereclause=yes name=u_gz_cwork_deptidea dbname="u_gz_cwork.deptidea" initial="empty" )
  18. column=(type=char(100) updatewhereclause=yes name=u_gz_cwork_idea dbname="u_gz_cwork.idea" initial="empty" )
  19. column=(type=long updatewhereclause=yes name=u_gz_cwork_empid dbname="u_gz_cwork.empid" initial="0" )
  20. column=(type=char(20) updatewhereclause=yes name=u_gz_cwork_billcode dbname="u_gz_cwork.billcode" initial="empty" )
  21. column=(type=datetime updatewhereclause=yes name=u_gz_cwork_moddate dbname="u_gz_cwork.moddate" )
  22. column=(type=char(10) updatewhereclause=yes name=u_gz_cwork_modemp dbname="u_gz_cwork.modemp" initial="empty" )
  23. column=(type=datetime updatewhereclause=yes name=u_gz_cwork_auditdate dbname="u_gz_cwork.auditdate" )
  24. column=(type=long updatewhereclause=yes name=u_gz_cwork_flag dbname="u_gz_cwork.flag" initial="0" values=" 1/ 0" )
  25. column=(type=char(10) updatewhereclause=yes name=u_gz_cwork_auditrep dbname="u_gz_cwork.auditrep" initial="empty" )
  26. column=(type=char(10) updatewhereclause=yes name=u_gz_cwork_opemp dbname="u_gz_cwork.opemp" initial="empty" )
  27. column=(type=datetime updatewhereclause=yes name=u_gz_cwork_opdate dbname="u_gz_cwork.opdate" initial="today" )
  28. column=(type=char(30) updatewhereclause=yes name=u_rs_empinfo_empname dbname="u_rs_empinfo.Empname" initial="empty" )
  29. column=(type=char(10) updatewhereclause=yes name=u_rs_empinfo_duty dbname="u_rs_empinfo.duty" initial="empty" )
  30. column=(type=char(30) updatewhereclause=yes name=cw_department_departmentname dbname="cw_department.departmentname" initial="empty" )
  31. column=(type=long updatewhereclause=yes name=u_gz_cwork_printnum dbname="u_gz_cwork.printnum" initial="0" )
  32. retrieve=" SELECT top 0 u_gz_cwork.billid,
  33. u_gz_cwork.wageid,
  34. u_gz_cwork.cworkid,
  35. u_rs_empinfo.Empcode,
  36. u_gz_cwork.billdate,
  37. u_gz_cwork.amt,
  38. u_gz_cwork.wagemth,
  39. u_gz_cwork.begindate,
  40. u_gz_cwork.enddate,
  41. u_gz_cwork.reason,
  42. u_gz_cwork.deptidea,
  43. u_gz_cwork.idea,
  44. u_gz_cwork.empid,
  45. u_gz_cwork.billcode,
  46. u_gz_cwork.moddate,
  47. u_gz_cwork.modemp,
  48. u_gz_cwork.auditdate,
  49. u_gz_cwork.flag,
  50. u_gz_cwork.auditrep,
  51. u_gz_cwork.opemp,
  52. u_gz_cwork.opdate,
  53. u_rs_empinfo.Empname,
  54. u_rs_empinfo.duty,
  55. cw_department.departmentname,
  56. u_gz_cwork.printnum
  57. FROM u_gz_cwork left outer join
  58. u_rs_empinfo on ( u_gz_cwork.empid = u_rs_empinfo.empid ) left outer join
  59. cw_department on ( u_rs_empinfo.deptid = cw_department.departmentid )
  60. " )
  61. text(band=detail alignment="1" text="主管部门意见:" border="0" color="16711680" x="32" y="928" height="56" width="375" html.valueishtml="0" name=u_gz_loanwage_dscrp_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" )
  62. text(band=detail alignment="1" text="审核日期:" border="0" color="33554432" x="128" y="1488" height="56" width="279" html.valueishtml="0" name=u_gz_loanwage_auditdate_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" )
  63. text(band=detail alignment="1" text="修改日期:" border="0" color="33554432" x="128" y="1388" height="56" width="279" html.valueishtml="0" name=u_gz_loanwage_moddate_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" )
  64. text(band=detail alignment="1" text="建立日期:" border="0" color="33554432" x="128" y="1288" height="56" width="279" html.valueishtml="0" name=u_gz_loanwage_opdate_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" )
  65. text(band=detail alignment="1" text="批 示:" border="0" color="16711680" x="128" y="1108" height="56" width="279" html.valueishtml="0" name=u_gz_loanwage_loanreason_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" )
  66. text(band=detail alignment="1" text="工资项目:" border="0" color="16711680" x="128" y="148" height="56" width="279" html.valueishtml="0" name=u_gz_loanwage_wageid_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" )
  67. text(band=detail alignment="1" text="单据编号:" border="0" color="33554432" x="128" y="48" height="56" width="279" html.valueishtml="0" name=u_gz_loanwage_billcode_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" )
  68. text(band=detail alignment="1" text="人员编号:" border="0" color="16711680" x="128" y="248" height="56" width="279" html.valueishtml="0" name=u_rs_empinfo_empcode_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" )
  69. text(band=detail alignment="1" text="工资月份:" border="0" color="16711680" x="128" y="548" height="56" width="279" html.valueishtml="0" name=u_gz_loanwage_wagemth_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" )
  70. text(band=detail alignment="1" text="事 由:" border="0" color="16711680" x="128" y="748" height="56" width="279" html.valueishtml="0" name=u_gz_loanwage_cardcode_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" )
  71. text(band=detail alignment="1" text="开始时间:" border="0" color="16711680" x="128" y="648" height="56" width="279" html.valueishtml="0" name=t_4 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" )
  72. column(band=detail id=10 alignment="0" tabsequence=32766 border="4" color="33554432" x="421" y="748" height="148" width="1403" format="[general]" html.valueishtml="0" name=u_gz_cwork_reason 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="1" background.color="536870912" )
  73. column(band=detail id=11 alignment="0" tabsequence=32766 border="4" color="33554432" x="421" y="928" height="148" width="1403" format="[general]" html.valueishtml="0" name=u_gz_cwork_deptidea 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="1" background.color="536870912" )
  74. column(band=detail id=12 alignment="0" tabsequence=32766 border="4" color="33554432" x="421" y="1108" height="148" width="1403" format="[general]" html.valueishtml="0" name=u_gz_cwork_idea 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="1" background.color="536870912" )
  75. text(band=detail alignment="1" text="日 期:" border="0" color="16711680" x="128" y="448" height="56" width="279" html.valueishtml="0" name=u_gz_loanwage_billdate_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" )
  76. column(band=detail id=14 alignment="0" tabsequence=32766 border="4" color="33554432" x="421" y="48" height="68" width="553" format="[general]" html.valueishtml="0" name=u_gz_cwork_billcode visible="1" edit.limit=0 edit.case=any edit.autoselect=yes edit.imemode=0 font.face="宋体" font.height="-9" font.weight="700" font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  77. text(band=detail alignment="1" text="审 核:" border="0" color="33554432" x="987" y="48" height="56" width="274" html.valueishtml="0" name=u_gz_loanwage_flag_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" )
  78. text(band=detail alignment="1" text="金 额:" border="0" color="16711680" x="987" y="448" height="56" width="274" html.valueishtml="0" name=u_gz_loanwage_loanamt_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" )
  79. column(band=detail id=18 alignment="0" tabsequence=32766 border="0" color="33554432" x="1275" y="48" height="68" width="553" format="[general]" html.valueishtml="0" name=u_gz_cwork_flag 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="1" background.color="536870912" )
  80. column(band=detail id=6 alignment="1" tabsequence=32766 border="4" color="0" x="1275" y="448" height="68" width="553" format="#,##0.00" html.valueishtml="0" name=u_gz_cwork_amt visible="1" edit.limit=0 edit.case=any edit.format="#,##0.00" 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="1" background.color="536870912" )
  81. text(band=detail alignment="1" text="结束时间:" border="0" color="16711680" x="987" y="648" height="56" width="274" html.valueishtml="0" name=t_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" )
  82. text(band=detail alignment="1" text="建 立 人:" border="0" color="33554432" x="987" y="1288" height="56" width="274" html.valueishtml="0" name=u_gz_loanwage_opemp_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" )
  83. text(band=detail alignment="1" text="修 改 人:" border="0" color="33554432" x="987" y="1388" height="56" width="274" html.valueishtml="0" name=u_gz_loanwage_modemp_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" )
  84. text(band=detail alignment="1" text="审 核 人:" border="0" color="33554432" x="987" y="1488" height="56" width="274" html.valueishtml="0" name=u_gz_loanwage_auditrep_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" )
  85. column(band=detail id=21 alignment="0" tabsequence=32766 border="4" color="33554432" x="421" y="1288" height="68" width="553" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_gz_cwork_opdate 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="1" background.color="536870912" )
  86. column(band=detail id=15 alignment="0" tabsequence=32766 border="4" color="33554432" x="421" y="1388" height="68" width="553" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_gz_cwork_moddate 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="1" background.color="536870912" )
  87. column(band=detail id=17 alignment="0" tabsequence=32766 border="4" color="33554432" x="421" y="1488" height="68" width="553" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_gz_cwork_auditdate 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="1" background.color="536870912" )
  88. column(band=detail id=20 alignment="0" tabsequence=32766 border="4" color="33554432" x="1275" y="1288" height="68" width="270" format="[general]" html.valueishtml="0" name=u_gz_cwork_opemp 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="1" background.color="536870912" )
  89. column(band=detail id=16 alignment="0" tabsequence=32766 border="4" color="33554432" x="1275" y="1388" height="68" width="270" format="[general]" html.valueishtml="0" name=u_gz_cwork_modemp 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="1" background.color="536870912" )
  90. column(band=detail id=19 alignment="0" tabsequence=32766 border="4" color="33554432" x="1275" y="1488" height="68" width="270" format="[general]" html.valueishtml="0" name=u_gz_cwork_auditrep 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="1" background.color="536870912" )
  91. column(band=detail id=2 alignment="0" tabsequence=32766 border="4" color="33554432" x="421" y="148" height="68" width="553" format="[general]" html.valueishtml="0" name=u_gz_cwork_wageid visible="1" dddw.name=dddw_wageitem_24 dddw.displaycolumn=wagename dddw.datacolumn=wageid dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.vscrollbar=yes font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  92. column(band=detail id=4 alignment="0" tabsequence=32766 border="4" color="16711680" x="421" y="248" height="68" width="457" format="[general]" html.valueishtml="0" name=u_rs_empinfo_empcode 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="1" background.color="536870912" )
  93. bitmap(band=detail filename="people.bmp" x="891" y="248" height="72" width="82" border="0" name=p_p pointer="HyperLink!" visible="1" )
  94. text(band=detail alignment="1" text="考勤项目:" border="0" color="8388608" x="987" y="148" height="56" width="274" html.valueishtml="0" name=t_1 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" )
  95. column(band=detail id=3 alignment="0" tabsequence=32766 border="4" color="8388608" x="1275" y="148" height="68" width="553" format="[general]" html.valueishtml="0" name=u_gz_cwork_cworkid visible="1" dddw.name=dddw_cworkitem dddw.displaycolumn=cworkname dddw.datacolumn=cworkid dddw.percentwidth=0 dddw.lines=0 dddw.limit=0 dddw.allowedit=no dddw.useasborder=no dddw.case=any dddw.imemode=0 dddw.vscrollbar=yes font.face="宋体" font.height="-9" font.weight="400" font.family="2" font.pitch="2" font.charset="134" background.mode="1" background.color="536870912" )
  96. text(band=detail alignment="1" text="人员姓名:" border="0" color="8388608" x="987" y="248" height="56" width="274" html.valueishtml="0" name=u_rs_empinfo_empname_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" )
  97. column(band=detail id=22 alignment="0" tabsequence=32766 border="4" color="8388608" x="1275" y="248" height="68" width="553" format="[general]" html.valueishtml="0" name=u_rs_empinfo_empname 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="1" background.color="536870912" )
  98. text(band=detail alignment="1" text="部 门:" border="0" color="8388608" x="128" y="344" height="56" width="279" 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="1" background.color="536870912" )
  99. column(band=detail id=24 alignment="0" tabsequence=32766 border="4" color="8388608" x="421" y="348" height="68" width="553" format="[general]" html.valueishtml="0" name=cw_department_departmentname 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="1" background.color="536870912" )
  100. text(band=detail alignment="1" text="职 务:" border="0" color="8388608" x="987" y="348" height="56" width="274" html.valueishtml="0" name=t_3 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" )
  101. column(band=detail id=23 alignment="0" tabsequence=32766 border="4" color="8388608" x="1275" y="348" height="68" width="553" format="[general]" html.valueishtml="0" name=u_rs_empinfo_duty 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="1" background.color="536870912" )
  102. column(band=detail id=9 alignment="0" tabsequence=32766 border="4" color="33554432" x="1275" y="648" height="68" width="553" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_gz_cwork_enddate visible="1" editmask.spin=yes editmask.mask="yyyy-mm-dd hh:mm" 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="1" background.color="536870912" )
  103. column(band=detail id=8 alignment="0" tabsequence=32766 border="4" color="33554432" x="421" y="648" height="68" width="553" format="yyyy-mm-dd hh:mm" html.valueishtml="0" name=u_gz_cwork_begindate visible="1" editmask.spin=yes editmask.mask="yyyy-mm-dd hh:mm" 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="1" background.color="536870912" )
  104. column(band=detail id=5 alignment="2" tabsequence=32766 border="4" color="33554432" x="421" y="448" height="68" width="553" format="[shortdate] [time]" html.valueishtml="0" name=u_gz_cwork_billdate 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="1" background.color="536870912" )
  105. column(band=detail id=7 alignment="2" tabsequence=32766 border="4" color="33554432" x="421" y="548" height="68" width="553" format="[general]" html.valueishtml="0" name=u_gz_cwork_wagemth visible="1" editmask.spin=yes editmask.mask="000000" 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="1" background.color="536870912" )
  106. htmltable(border="1" )
  107. htmlgen(clientevents="1" clientvalidation="1" clientcomputedfields="1" clientformatting="0" clientscriptable="0" generatejavascript="1" encodeselflinkargs="1" netscapelayers="0" )
  108. export.xml(headgroups="1" includewhitespace="0" metadatatype=0 savemetadata=0 )
  109. import.xml()
  110. export.pdf(method=0 distill.custompostscript="0" xslfop.print="0" )