넥사크로 Dataset

 

 

 

 

데이터셋 동적 생성

 

 - 아래 소스는 Dataset을 생성하는 두가지 예제를 보여준다

 - 첫번째는 빈 Dataset을 생성하고 두번째는 데이터셋의 id와 컬럼, 데이터를 추가하는 예제

 

//Dataset Object 생성 예제 1
this.dataset_test1 = new Dataset();	
trace("\n" + this.dataset_test1.saveXML());
	
//Dataset Object 생성 예제 2 (id 포함)
this.dataset_test2 = new Dataset("dataset_test2");
	
//컬럼 추가
this.dataset_test2.addColumn("col1");
this.dataset_test2.addColumn("col2");
	
//데이터 추가
var currentRow = this.dataset_test2.addRow();
this.dataset_test2.setColumn(currentRow, "col1", "data1");
this.dataset_test2.setColumn(currentRow, "col2", "data2");
	
trace("\n" + this.dataset_test2.saveXML());

 

https://6developer.com/961#google_vignette

[Nexacro 17] Dataset 동적 생성 및 로드

 

넥사크로 findRow로 특정 행 찾기

this.dsSearch.findRow("NAME", "JY"));

 

https://flatsun.tistory.com/465

넥사크로 findRow로 특정 행 찾기

 

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

<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);
}

 

https://joshart777.tistory.com/78

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

 

 

• 데이터셋에서 row 생성 (맨아래 row 로 생성)

var row = this.ds.addRow();

 

 

• 데이터셋에서 row 생성 (맨위에 row 로 생성)

var row = this.ds.insertRow();

 

 

• 데이터셋에서 row 삭제

this.ds.deleteRow(this.ds.rowposition);

this.ds.deleteRow(rowIndex);

 

 

• 데이터셋에서 컬럼 가져오기

this.ds.getColumn(rowIndex, "columnName");

 

 

• 데이터셋에서 특정컬럼 세팅하기

this.ds.setColumn(row, "columnName", value);

 

 

• 데이터셋에서 컬럼정보 가져오기

this.ds.getColumnInfo(columnIndex);

 

 

• 데이터셋에 값이 있는지 rowcount 로 확인하는 방법

this.ds.rowcount == 0

//if(this.ds.rowcount > 0) { 
//	trace("데이터가 있네!") 
//};

 

 

• 값이 포함된 row 찾기 (rowIndex 반환, 못찾을 경우 -1 반환)

this.ds.findRow("columnName",value);

 

 

• 이벤트를 잠시 중지함

this.ds.set_enableevent(false);

 

https://devinserengeti.tistory.com/44

[넥사크로17] 넥사크로 데이터셋 메소드 정리