SMPIF31500.xjs 3.3 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148
  1. <?xml version="1.0" encoding="utf-8"?>
  2. <Script type="xscript4.0"><![CDATA[function fn_min(grid, dataset)
  3. {
  4. var rows = grdf_getSelectedRows(grid);
  5. if(grid.currentcell == grid.getBindCellIndex("Body", "clmcstotamt"))
  6. {
  7. var sum = 0;
  8. for(var i = 0; i < rows.length; i++)
  9. {
  10. var row = rows[i];
  11. sum += parseInt(utlf_transNull(dataset.getColumn(row, "clmcstotamt"),0));
  12. }
  13. }
  14. if(grid.currentcell == grid.getBindCellIndex("Body", "clamamt"))
  15. {
  16. var sum = 0;
  17. for(var i = 0; i < rows.length; i++)
  18. {
  19. var row = rows[i];
  20. sum += parseInt(utlf_transNull(dataset.getColumn(row, "clamamt"),0));
  21. }
  22. }
  23. if(grid.currentcell == grid.getBindCellIndex("Body", "jrjudgdeciamt"))
  24. {
  25. var sum = 0;
  26. for(var i = 0; i < rows.length; i++)
  27. {
  28. var row = rows[i];
  29. sum += parseInt(utlf_transNull(dataset.getColumn(row, "jrjudgdeciamt"),0));
  30. }
  31. }
  32. if(grid.currentcell == grid.getBindCellIndex("Body", "clhandicaprfund"))
  33. {
  34. var sum = 0;
  35. for(var i = 0; i < rows.length; i++)
  36. {
  37. var row = rows[i];
  38. sum += parseInt(utlf_transNull(dataset.getColumn(row, "clhandicaprfund"),0));
  39. }
  40. }
  41. if(grid.currentcell == grid.getBindCellIndex("Body", "jrhandicaprfund"))
  42. {
  43. var sum = 0;
  44. for(var i = 0; i < rows.length; i++)
  45. {
  46. var row = rows[i];
  47. sum += parseInt(utlf_transNull(dataset.getColumn(row, "jrhandicaprfund"),0));
  48. }
  49. }
  50. if(grid.currentcell == grid.getBindCellIndex("Body", "depoamt"))
  51. {
  52. var sum = 0;
  53. for(var i = 0; i < rows.length; i++)
  54. {
  55. var row = rows[i];
  56. sum += parseInt(utlf_transNull(dataset.getColumn(row, "depoamt"),0));
  57. }
  58. }
  59. if(grid.currentcell == grid.getBindCellIndex("Body", "remainamt"))
  60. {
  61. var sum = 0;
  62. for(var i = 0; i < rows.length; i++)
  63. {
  64. var row = rows[i];
  65. sum += parseInt(utlf_transNull(dataset.getColumn(row, "remainamt"),0));
  66. }
  67. }
  68. if(grid.currentcell == grid.getBindCellIndex("Body", "depoamt"))
  69. {
  70. var sum = 0;
  71. for(var i = 0; i < rows.length; i++)
  72. {
  73. var row = rows[i];
  74. sum += parseInt(utlf_transNull(dataset.getColumn(row, "depoamt"),0));
  75. }
  76. }
  77. if(grid.currentcell == grid.getBindCellIndex("Body", "rtnscheamt"))
  78. {
  79. var sum = 0;
  80. for(var i = 0; i < rows.length; i++)
  81. {
  82. var row = rows[i];
  83. sum += parseInt(utlf_transNull(dataset.getColumn(row, "rtnscheamt"),0));
  84. }
  85. }
  86. if(grid.currentcell == grid.getBindCellIndex("Body", "depocnt"))
  87. {
  88. var sum = 0;
  89. for(var i = 0; i < rows.length; i++)
  90. {
  91. var row = rows[i];
  92. sum += parseInt(utlf_transNull(dataset.getColumn(row, "depocnt"),0));
  93. }
  94. }
  95. if(grid.currentcell == grid.getBindCellIndex("Body", "rtnamt"))
  96. {
  97. var sum = 0;
  98. for(var i = 0; i < rows.length; i++)
  99. {
  100. var row = rows[i];
  101. sum += parseInt(utlf_transNull(dataset.getColumn(row, "rtnamt"),0));
  102. }
  103. }
  104. if(grid.currentcell == grid.getBindCellIndex("Body", "depooutamt"))
  105. {
  106. var sum = 0;
  107. for(var i = 0; i < rows.length; i++)
  108. {
  109. var row = rows[i];
  110. sum += parseInt(utlf_transNull(dataset.getColumn(row, "depooutamt"),0));
  111. }
  112. }
  113. if(grid.currentcell == grid.getBindCellIndex("Body", "depoinamt"))
  114. {
  115. var sum = 0;
  116. for(var i = 0; i < rows.length; i++)
  117. {
  118. var row = rows[i];
  119. sum += parseInt(utlf_transNull(dataset.getColumn(row, "depoinamt"),0));
  120. }
  121. }
  122. group3.Edit00.visible = true;
  123. group3.Edit00.value = sum;
  124. }
  125. ]]></Script>