넥사크로 많이 쓰는 문법 정리

개발_참고하기/개발
by 정보 공유 블로그 2021. 6. 29. 10:17
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">//데이터셋&nbsp;초기화&nbsp;(컬럼정보까지)</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_1_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋&nbsp;초기화&nbsp;(데이터만)</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_2_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에&nbsp;행추가</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_3_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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>&nbsp;iAddRow&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<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">"추가된&nbsp;행번호&nbsp;==&nbsp;"</span>&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">+</span>&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에&nbsp;행삽입</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_4_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에&nbsp;행삭제</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_5_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에&nbsp;컬럼추가</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_6_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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>,&nbsp;<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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에&nbsp;컬럼삭제</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_7_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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&nbsp;속성이&nbsp;false일때만&nbsp;컬럼이&nbsp;삭제됨</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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에&nbsp;컬럼에&nbsp;값&nbsp;입력</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_8_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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>,&nbsp;<span style="color:#63a35c">"Column3"</span>,&nbsp;<span style="color:#63a35c">"테스트&nbsp;입력"</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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋&nbsp;컬럼의&nbsp;값&nbsp;읽기</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_9_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">var</span>&nbsp;sReadValue&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#066de2">this</span>.ds_list.getColumn(<span style="color:#066de2">this</span>.ds_list.rowposition,&nbsp;<span style="color:#63a35c">"Column1"</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">alert</span>(<span style="color:#63a35c">"2번째&nbsp;Row,&nbsp;Column1&nbsp;컬럼값&nbsp;=&nbsp;"</span>&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">+</span>&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋&nbsp;복사</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_10_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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,&nbsp;<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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋&nbsp;총건수</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_11_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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">//&nbsp;개수를&nbsp;구할&nbsp;때&nbsp;필터링되거나&nbsp;삭제된&nbsp;행은&nbsp;제외됩니다.</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&nbsp;데이터셋&nbsp;Row&nbsp;총건수&nbsp;==&nbsp;"</span>&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">+</span>&nbsp;<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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋&nbsp;필터</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_12_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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">//필터&nbsp;초기화</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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에서&nbsp;특정값&nbsp;위치&nbsp;찾기</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_13_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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>&nbsp;iFindRow&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#066de2">this</span>.ds_list.findRow(<span style="color:#63a35c">"Column0"</span>,&nbsp;<span style="color:#63a35c">"3"</span>);</div><div style="padding:0 6px; white-space:pre; line-height:130%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">alert</span>(<span style="color:#63a35c">"컬럼&nbsp;Column0의&nbsp;값이&nbsp;3인&nbsp;Row&nbsp;위치&nbsp;==&nbsp;"</span>&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">+</span>&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋의&nbsp;현재&nbsp;Row&nbsp;위치</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_14_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋의&nbsp;특정값&nbsp;카운트</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_15_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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">"컬럼&nbsp;Column4의&nbsp;값이&nbsp;'1'인&nbsp;Row수&nbsp;==&nbsp;"</span>&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">+</span>&nbsp;<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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋의&nbsp;특정&nbsp;Row로&nbsp;이동</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_16_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋에&nbsp;Append</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_17_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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">//현재&nbsp;데이터셋의&nbsp;마지막&nbsp;레코드&nbsp;다음에&nbsp;지정한&nbsp;데이터셋의&nbsp;레코드를&nbsp;추가하는&nbsp;메소드입니다.</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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋&nbsp;CopyRow</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_18_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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">//&nbsp;특정&nbsp;데이터셋의&nbsp;행(row)을&nbsp;현재&nbsp;데이터셋의&nbsp;지정한&nbsp;행의&nbsp;위치에&nbsp;복사하는&nbsp;메소드입니다.</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>,&nbsp;<span style="color:#066de2">this</span>.ds_appendList,&nbsp;<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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋&nbsp;합계</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_19_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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,&nbsp;getMax,&nbsp;getMin,&nbsp;getCaseSum,&nbsp;getCaseMax,&nbsp;getCaseMin,&nbsp;getCaseAvg&nbsp;사용가능</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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋&nbsp;lookup</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_20_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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">//데이터셋의&nbsp;대상&nbsp;열(column)에서&nbsp;조건과&nbsp;일치하는&nbsp;값을&nbsp;검색&nbsp;후&nbsp;해당&nbsp;행(row)의&nbsp;지정된&nbsp;열&nbsp;값을&nbsp;구하는&nbsp;메소드입니다.</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>,&nbsp;<span style="color:#63a35c">"2"</span>,&nbsp;<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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//데이터셋&nbsp;정렬</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.btn_21_onclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Button,&nbsp;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%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#066de2">this</span>.Grid00_oncellclick&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#a71d5d">function</span>(obj:Grid,&nbsp;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&nbsp;+&nbsp;"&nbsp;"&nbsp;+&nbsp;e.row);</span></div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#999999">//&nbsp;alert(this.ds_list.getColID(e.col));</span></div><div style="padding:0 6px; white-space:pre; line-height:130%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%">&nbsp;</div><div style="padding:0 6px; white-space:pre; line-height:130%"><span style="color:#a71d5d">var</span>&nbsp;sReadValue&nbsp;<span style="color:#ff3399"></span><span style="color:#a71d5d">=</span>&nbsp;<span style="color:#066de2">this</span>.ds_list.getColumn(e.row,&nbsp;<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);
}
Colored by Color Scripter
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