1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 | <div class="colorscripter-code" style="color:#010101;font-family:Consolas, 'Liberation Mono', Menlo, Courier, monospace !important; position:relative !important;overflow:auto"><table class="colorscripter-code-table" style="margin:0;padding:0;border:none;background-color:#fafafa;border-radius:4px;" cellspacing="0" cellpadding="0"><tr><td style="padding:6px;border-right:2px solid #e5e5e5"><div style="margin:0;padding:0;word-break:normal;text-align:right;color:#666;font-family:Consolas, 'Liberation Mono', Menlo, Courier, monospace !important;line-height:130%"><div style="line-height:130%">1</div><div style="line-height:130%">2</div><div style="line-height:130%">3</div><div style="line-height:130%">4</div><div style="line-height:130%">5</div><div style="line-height:130%">6</div><div style="line-height:130%">7</div><div style="line-height:130%">8</div><div style="line-height:130%">9</div><div style="line-height:130%">10</div><div style="line-height:130%">11</div><div style="line-height:130%">12</div><div style="line-height:130%">13</div><div style="line-height:130%">14</div><div style="line-height:130%">15</div><div style="line-height:130%">16</div><div style="line-height:130%">17</div><div style="line-height:130%">18</div><div style="line-height:130%">19</div><div style="line-height:130%">20</div><div style="line-height:130%">21</div><div style="line-height:130%">22</div><div style="line-height:130%">23</div><div style="line-height:130%">24</div><div style="line-height:130%">25</div><div style="line-height:130%">26</div><div style="line-height:130%">27</div><div style="line-height:130%">28</div><div style="line-height:130%">29</div><div style="line-height:130%">30</div><div style="line-height:130%">31</div><div style="line-height:130%">32</div><div style="line-height:130%">33</div><div style="line-height:130%">34</div><div style="line-height:130%">35</div><div style="line-height:130%">36</div><div style="line-height:130%">37</div><div style="line-height:130%">38</div><div style="line-height:130%">39</div><div style="line-height:130%">40</div><div style="line-height:130%">41</div><div style="line-height:130%">42</div><div style="line-height:130%">43</div><div style="line-height:130%">44</div><div style="line-height:130%">45</div><div style="line-height:130%">46</div><div style="line-height:130%">47</div><div style="line-height:130%">48</div><div style="line-height:130%">49</div><div style="line-height:130%">50</div><div style="line-height:130%">51</div><div style="line-height:130%">52</div><div style="line-height:130%">53</div><div style="line-height:130%">54</div><div style="line-height:130%">55</div><div style="line-height:130%">56</div><div style="line-height:130%">57</div><div style="line-height:130%">58</div><div style="line-height:130%">59</div><div style="line-height:130%">60</div><div style="line-height:130%">61</div><div style="line-height:130%">62</div><div style="line-height:130%">63</div><div style="line-height:130%">64</div><div style="line-height:130%">65</div><div style="line-height:130%">66</div><div style="line-height:130%">67</div><div style="line-height:130%">68</div><div style="line-height:130%">69</div><div style="line-height:130%">70</div><div style="line-height:130%">71</div><div style="line-height:130%">72</div><div style="line-height:130%">73</div><div style="line-height:130%">74</div><div style="line-height:130%">75</div><div style="line-height:130%">76</div><div style="line-height:130%">77</div><div style="line-height:130%">78</div><div style="line-height:130%">79</div><div style="line-height:130%">80</div><div style="line-height:130%">81</div><div style="line-height:130%">82</div><div style="line-height:130%">83</div><div style="line-height:130%">84</div><div style="line-height:130%">85</div><div style="line-height:130%">86</div><div style="line-height:130%">87</div><div style="line-height:130%">88</div><div style="line-height:130%">89</div><div style="line-height:130%">90</div><div style="line-height:130%">91</div><div style="line-height:130%">92</div><div style="line-height:130%">93</div><div style="line-height:130%">94</div><div style="line-height:130%">95</div><div style="line-height:130%">96</div><div style="line-height:130%">97</div><div style="line-height:130%">98</div><div style="line-height:130%">99</div><div style="line-height:130%">100</div><div style="line-height:130%">101</div><div style="line-height:130%">102</div><div style="line-height:130%">103</div><div style="line-height:130%">104</div><div style="line-height:130%">105</div><div style="line-height:130%">106</div><div style="line-height:130%">107</div><div style="line-height:130%">108</div><div style="line-height:130%">109</div><div style="line-height:130%">110</div><div style="line-height:130%">111</div><div style="line-height:130%">112</div><div style="line-height:130%">113</div><div style="line-height:130%">114</div><div style="line-height:130%">115</div><div style="line-height:130%">116</div><div style="line-height:130%">117</div><div style="line-height:130%">118</div><div style="line-height:130%">119</div><div style="line-height:130%">120</div><div style="line-height:130%">121</div><div style="line-height:130%">122</div><div style="line-height:130%">123</div><div style="line-height:130%">124</div><div style="line-height:130%">125</div><div style="line-height:130%">126</div><div style="line-height:130%">127</div><div style="line-height:130%">128</div><div style="line-height:130%">129</div><div style="line-height:130%">130</div><div style="line-height:130%">131</div><div style="line-height:130%">132</div><div style="line-height:130%">133</div><div style="line-height:130%">134</div><div style="line-height:130%">135</div><div style="line-height:130%">136</div><div style="line-height:130%">137</div><div style="line-height:130%">138</div><div style="line-height:130%">139</div><div style="line-height:130%">140</div><div style="line-height:130%">141</div><div style="line-height:130%">142</div><div style="line-height:130%">143</div><div style="line-height:130%">144</div><div style="line-height:130%">145</div><div style="line-height:130%">146</div><div style="line-height:130%">147</div><div style="line-height:130%">148</div><div style="line-height:130%">149</div><div style="line-height:130%">150</div><div style="line-height:130%">151</div><div style="line-height:130%">152</div><div style="line-height:130%">153</div><div style="line-height:130%">154</div></div></td><td style="padding:6px 0;text-align:left"><div style="margin:0;padding:0;color:#010101;font-family:Consolas, 'Liberation Mono', Menlo, Courier, monospace !important;line-height:130%"><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋 초기화 (컬럼정보까지)</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_1_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.clear();</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">trace</span>(<span style="color:#066de2">this</span>.ds_list.saveXML());</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋 초기화 (데이터만)</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_2_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.clearData();</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">trace</span>(<span style="color:#066de2">this</span>.ds_list.saveXML());</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에 행추가</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_3_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">var</span> iAddRow <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#066de2">this</span>.ds_list.addRow();</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">trace</span>(<span style="color:#63a35c">"추가된 행번호 == "</span> <span style="color:#ff3399"></span><span style="color:#a71d5d">+</span> iAddRow);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에 행삽입</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_4_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.insertRow(<span style="color:#0099cc">1</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에 행삭제</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_5_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.deleteRow(<span style="color:#0099cc">1</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에 컬럼추가</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_6_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.addColumn(<span style="color:#63a35c">"Column5"</span>, <span style="color:#63a35c">"string"</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">trace</span>(<span style="color:#066de2">this</span>.ds_list.saveXML());</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에 컬럼삭제</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_7_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.set_updatecontrol(<span style="color:#0099cc">false</span>);<span style="color:#999999">//updatecontrol 속성이 false일때만 컬럼이 삭제됨</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.deleteColumn(<span style="color:#63a35c">"Column1"</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.set_updatecontrol(<span style="color:#a71d5d">true</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">trace</span>(<span style="color:#066de2">this</span>.ds_list.saveXML());</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에 컬럼에 값 입력</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_8_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.setColumn(<span style="color:#0099cc">0</span>, <span style="color:#63a35c">"Column3"</span>, <span style="color:#63a35c">"테스트 입력"</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋 컬럼의 값 읽기</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_9_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//alert(e.co);</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">var</span> sReadValue <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#066de2">this</span>.ds_list.getColumn(<span style="color:#066de2">this</span>.ds_list.rowposition, <span style="color:#63a35c">"Column1"</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">alert</span>(<span style="color:#63a35c">"2번째 Row, Column1 컬럼값 = "</span> <span style="color:#ff3399"></span><span style="color:#a71d5d">+</span> sReadValue);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋 복사</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_10_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_copyList.copyData(<span style="color:#066de2">this</span>.ds_list, <span style="color:#a71d5d">true</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋 총건수</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_11_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">// 개수를 구할 때 필터링되거나 삭제된 행은 제외됩니다.</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">alert</span>(<span style="color:#63a35c">"ds_list 데이터셋 Row 총건수 == "</span> <span style="color:#ff3399"></span><span style="color:#a71d5d">+</span> <span style="color:#066de2">this</span>.ds_list.getRowCount());</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋 필터</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_12_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.filter(<span style="color:#63a35c">""</span>);<span style="color:#999999">//필터 초기화</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.filter(<span style="color:#63a35c">"Column4=='1'"</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에서 특정값 위치 찾기</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_13_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">var</span> iFindRow <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#066de2">this</span>.ds_list.findRow(<span style="color:#63a35c">"Column0"</span>, <span style="color:#63a35c">"3"</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">alert</span>(<span style="color:#63a35c">"컬럼 Column0의 값이 3인 Row 위치 == "</span> <span style="color:#ff3399"></span><span style="color:#a71d5d">+</span> iFindRow);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋의 현재 Row 위치</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_14_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">alert</span>(<span style="color:#066de2">this</span>.ds_list.rowposition);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋의 특정값 카운트</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_15_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">alert</span>(<span style="color:#63a35c">"컬럼 Column4의 값이 '1'인 Row수 == "</span> <span style="color:#ff3399"></span><span style="color:#a71d5d">+</span> <span style="color:#066de2">this</span>.ds_list.getCaseCount(<span style="color:#63a35c">"Column4=='1'"</span>));</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋의 특정 Row로 이동</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_16_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.set_rowposition(<span style="color:#0099cc">1</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에 Append</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_17_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//현재 데이터셋의 마지막 레코드 다음에 지정한 데이터셋의 레코드를 추가하는 메소드입니다.</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.appendData(<span style="color:#066de2">this</span>.ds_appendList);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋 CopyRow</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_18_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">// 특정 데이터셋의 행(row)을 현재 데이터셋의 지정한 행의 위치에 복사하는 메소드입니다.</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.copyRow(<span style="color:#0099cc">1</span>, <span style="color:#066de2">this</span>.ds_appendList, <span style="color:#0099cc">0</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋 합계</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_19_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//getAvg, getMax, getMin, getCaseSum, getCaseMax, getCaseMin, getCaseAvg 사용가능</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">alert</span>(<span style="color:#066de2">this</span>.ds_list.getSum(<span style="color:#63a35c">"Column3"</span>));</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋 lookup</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_20_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋의 대상 열(column)에서 조건과 일치하는 값을 검색 후 해당 행(row)의 지정된 열 값을 구하는 메소드입니다.</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">alert</span>(<span style="color:#066de2">this</span>.ds_list.lookup(<span style="color:#63a35c">"Column0"</span>, <span style="color:#63a35c">"2"</span>, <span style="color:#63a35c">"Column2"</span>));</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋 정렬</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_21_onclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Button, e:nexacro.ClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.ds_list.set_keystring(<span style="color:#63a35c">"S:-Column3"</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.Grid00_oncellclick <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#a71d5d">function</span>(obj:Grid, e:nexacro.GridClickEventInfo)</div><div style="padding:0 6px; white-space:pre; line-height:130%">{</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//alert(e.col + " " + e.row);</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">// alert(this.ds_list.getColID(e.col));</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"> </div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">var</span> sReadValue <span style="color:#ff3399"></span><span style="color:#a71d5d">=</span> <span style="color:#066de2">this</span>.ds_list.getColumn(e.row, <span style="color:#066de2">this</span>.ds_list.getColID(e.col));</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">alert</span>(sReadValue);</div><div style="padding:0 6px; white-space:pre; line-height:130%">}</div></div><div style="text-align:right;margin-top:-13px;margin-right:5px;font-size:9px;font-style:italic"><a href="http://colorscripter.com/info#e" target="_blank" style="color:#e5e5e5text-decoration:none">Colored by Color Scripter</a></div></td><td style="vertical-align:bottom;padding:0 2px 4px 0"><a href="http://colorscripter.com/info#e" target="_blank" style="text-decoration:none;color:white"><span style="font-size:9px;word-break:normal;background-color:#e5e5e5;color:white;border-radius:10px;padding:1px">cs</span></a></td></tr></table></div> //데이터셋 초기화 (컬럼정보까지) this.btn_1_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_list.clear(); trace(this.ds_list.saveXML()); } //데이터셋 초기화 (데이터만) this.btn_2_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_list.clearData(); trace(this.ds_list.saveXML()); } //데이터셋에 행추가 this.btn_3_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { var iAddRow = this.ds_list.addRow(); trace("추가된 행번호 == " + iAddRow); } //데이터셋에 행삽입 this.btn_4_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_list.insertRow(1); } //데이터셋에 행삭제 this.btn_5_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_list.deleteRow(1); } //데이터셋에 컬럼추가 this.btn_6_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_list.addColumn("Column5", "string"); trace(this.ds_list.saveXML()); } //데이터셋에 컬럼삭제 this.btn_7_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_list.set_updatecontrol(false);//updatecontrol 속성이 false일때만 컬럼이 삭제됨 this.ds_list.deleteColumn("Column1"); this.ds_list.set_updatecontrol(true); trace(this.ds_list.saveXML()); } //데이터셋에 컬럼에 값 입력 this.btn_8_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_list.setColumn(0, "Column3", "테스트 입력"); } //데이터셋 컬럼의 값 읽기 this.btn_9_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { //alert(e.co); var sReadValue = this.ds_list.getColumn(this.ds_list.rowposition, "Column1"); alert("2번째 Row, Column1 컬럼값 = " + sReadValue); } //데이터셋 복사 this.btn_10_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_copyList.copyData(this.ds_list, true); } //데이터셋 총건수 this.btn_11_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { // 개수를 구할 때 필터링되거나 삭제된 행은 제외됩니다. alert("ds_list 데이터셋 Row 총건수 == " + this.ds_list.getRowCount()); } //데이터셋 필터 this.btn_12_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_list.filter("");//필터 초기화 this.ds_list.filter("Column4=='1'"); } //데이터셋에서 특정값 위치 찾기 this.btn_13_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { var iFindRow = this.ds_list.findRow("Column0", "3"); alert("컬럼 Column0의 값이 3인 Row 위치 == " + iFindRow); } //데이터셋의 현재 Row 위치 this.btn_14_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { alert(this.ds_list.rowposition); } //데이터셋의 특정값 카운트 this.btn_15_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { alert("컬럼 Column4의 값이 '1'인 Row수 == " + this.ds_list.getCaseCount("Column4=='1'")); } //데이터셋의 특정 Row로 이동 this.btn_16_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_list.set_rowposition(1); } //데이터셋에 Append this.btn_17_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { //현재 데이터셋의 마지막 레코드 다음에 지정한 데이터셋의 레코드를 추가하는 메소드입니다. this.ds_list.appendData(this.ds_appendList); } //데이터셋 CopyRow this.btn_18_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { // 특정 데이터셋의 행(row)을 현재 데이터셋의 지정한 행의 위치에 복사하는 메소드입니다. this.ds_list.copyRow(1, this.ds_appendList, 0); } //데이터셋 합계 this.btn_19_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { //getAvg, getMax, getMin, getCaseSum, getCaseMax, getCaseMin, getCaseAvg 사용가능 alert(this.ds_list.getSum("Column3")); } //데이터셋 lookup this.btn_20_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { //데이터셋의 대상 열(column)에서 조건과 일치하는 값을 검색 후 해당 행(row)의 지정된 열 값을 구하는 메소드입니다. alert(this.ds_list.lookup("Column0", "2", "Column2")); } //데이터셋 정렬 this.btn_21_onclick = function(obj:Button, e:nexacro.ClickEventInfo) { this.ds_list.set_keystring("S:-Column3"); } this.Grid00_oncellclick = function(obj:Grid, e:nexacro.GridClickEventInfo) { //alert(e.col + " " + e.row); // alert(this.ds_list.getColID(e.col)); var sReadValue = this.ds_list.getColumn(e.row, this.ds_list.getColID(e.col)); alert(sReadValue); } | cs |
넥사크로 웹브라우저(webBrowser) 사용법 (0) | 2021.06.29 |
---|---|
넥사크로_배열, for문, set or get Column 사용법 (0) | 2021.05.21 |
넥사크로_자바_SQL_체크박스 다중 값 검색 (0) | 2021.05.21 |
JSTL_forEach문, if문 사용법 (0) | 2021.05.21 |
넥사크로_엑셀 저장하기 (0) | 2021.05.21 |
댓글 영역