YNU_JEUS/app_home/himed/xpapps/tmp/samplexp/xp/SMSMP09204_테이블정보조회.xfdl

<?xml version="1.0" encoding="utf-8"?>
<FDL version="1.5">
  <TypeDefinition url="..\..\..\default_typedef.xml"/>
  <Form id="SMSMP09204" classname="SMSMP09204_테이블정보조회" inheritanceid="" position="absolute 0 0 1199 871" titletext="테이블정보조회" onload="SMSMP09204_onload" oninit="SMSMP09204_oninit" onactivate="SMSMP09204_onactivate" onkeydown="SMSMP09204_onkeydown" ontimer="SMSMP09204_ontimer">
    <Layouts>
      <Layout>
        <Splitter id="Splitter00" position="absolute -1 459 549 469" type="vertical" style="background:antiquewhite;bordertype:round 5 5 ;" anchor="left top">
          <Formats>
            <Format id="default">
              <SplitterItems id="items">
                <SplitterItem id="item00" bindtype="resize" position="leftortop" offset="0" componentid="Grid00"/>
                <SplitterItem id="item01" bindtype="resize" position="rightorbottom" offset="0" componentid="Tab00"/>
              </SplitterItems>
            </Format>
          </Formats>
        </Splitter>
        <Edit id="ipt_table_name" taborder="1" class="input_search" position="absolute 288 23 548 42" inputmode="upper" ontextchanged="ipt_table_name_ontextchanged" autoselect="true" onkeydown="ipt_table_name_onkeydown" updatebindingvalue="default"/>
        <Grid id="Grid02" taborder="2" useinputpanel="false" position="absolute 553 734 1191 863" binddataset="ds_index_info" anchor="all" cellsizingtype="both" autoenter="select" oncellclick="Grid02_oncellclick" onkillfocus="Grid02_onkillfocus">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="118"/>
                <Column size="471"/>
                <Column size="31"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="인덱스명"/>
                <Cell col="1" text="인덱스구성"/>
                <Cell col="2" text="PK"/>
              </Band>
              <Band id="body">
                <Cell edittype="text" style="align:left;" text="bind:index_name" editautoselect="true"/>
                <Cell col="1" edittype="text" style="align:left;" text="bind:index_const" editautoselect="true"/>
                <Cell col="2" text="bind:index_type"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Static id="caption6" text="테이블정보조회" class="tit_1" position="absolute 0 0 188 20" onclick="caption6_onclick"/>
        <Shape id="line1" class="line_1" position="absolute -1 43 546 47"/>
        <Static id="caption7" text="테이블명" class="tit_2" position="absolute 206 24 282 40" onclick="caption7_onclick"/>
        <Button id="btn_select" taborder="3" text="Select문 생성" onclick="group2_btn_distributing_onclick" class="btn4_letter8" position="absolute 578 708 671 730"/>
        <Button id="btn_insert" taborder="4" text="Insert문 생성" class="btn4_letter8" position="absolute 674 708 767 730" onclick="btn_insert_onclick"/>
        <Button id="btn_update" taborder="5" text="Update문 생성" class="btn4_letter8" position="absolute 770 708 871 730" onclick="btn_update_onclick"/>
        <Button id="btn_delete" taborder="6" text="Delete문 생성" class="btn4_letter8" position="absolute 876 708 969 730" onclick="btn_delete_onclick"/>
        <Static id="Static00" text="(Ctrl+V로&#13;&#10;사용가능)" position="absolute 1113 706 1186 729" style="font:돋움체,10,bold;"/>
        <Static id="caption01" text="사용자" class="tit_2" position="absolute 0 24 65 40" onclick="caption01_onclick"/>
        <Combo id="cbOwner" taborder="7" text="Combo00" position="absolute 74 23 190 42" innerdataset="@ds_dbUsers" codecolumn="owner" datacolumn="owner" onitemchanged="Combo00_onitemchanged"/>
        <Tab id="Tab00" taborder="8" tabindex="0" scrollbars="autoboth" position="absolute 0 469 550 867" anchor="left top bottom" style="background:transparent URL('theme://images/bg_tab_BodyTop.png') stretch 10,26;">
          <Tabpages>
            <Tabpage id="tabpage1" text="즐겨찾기">
              <Layouts>
                <Layout>
                  <Grid id="grd_favTable" taborder="0" binddataset="fafds" useinputpanel="false" cellsizingtype="both" oncellclick="fTblGridOnClick" position="absolute 0 26 546 363" anchor="left top bottom" onkeydown="fGridKeyDownEvents" selecttype="row" onkeyup="fGridKeyUpEvents">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="57"/>
                          <Column size="111"/>
                          <Column size="248"/>
                          <Column size="0"/>
                          <Column size="53"/>
                          <Column size="58"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell text="사용자"/>
                          <Cell col="1" text="테이블명"/>
                          <Cell col="2" text="설명"/>
                          <Cell col="3" text="owner"/>
                          <Cell col="4" text="업무"/>
                          <Cell col="5" text="Type"/>
                        </Band>
                        <Band id="body">
                          <Cell text="bind:owner"/>
                          <Cell col="1" edittype="normal" style="align:left;" text="bind:table_name" editdisplay="display"/>
                          <Cell col="2" edittype="normal" style="align:left;" text="bind:comments" editdisplay="display" tooltiptext="bind:comments" autosizerow="limitmax" autosizecol="default"/>
                          <Cell col="3" edittype="normal" text="bind:owner"/>
                          <Cell col="4" style="align:left;" text="bind:domain"/>
                          <Cell col="5" style="align:left;" text="bind:object_type"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Div id="Div00" taborder="6" position="absolute 0 24 186 87" style="background:beige;border:1 solid #808080ff ;" visible="false">
                    <Layouts>
                      <Layout>
                        <Edit id="Edit00" taborder="0" position="absolute 6 7 178 29" anchor="default"/>
                        <Button id="Button01" taborder="1" text="추가" onclick="Tab00_tabpage1_PopupDiv00_Button01_onclick" position="absolute 7 35 61 55" anchor="default"/>
                        <Button id="Button00" taborder="2" text="닫기" position="absolute 125 35 177 56" onclick="Tab00_tabpage1_Div00_Button00_onclick" anchor="default"/>
                      </Layout>
                    </Layouts>
                  </Div>
                  <Combo id="Combo00" taborder="1" text="Combo00" position="absolute 1 1 186 24" innerdataset="@ds_domain" datacolumn="domain" codecolumn="domain" type="search" visible="true" onkeydown="Tab00_tabpage1_Combo00_onkeydown" onitemchanged="Tab00_tabpage1_Combo00_onitemchanged"/>
                  <Button id="Button00" taborder="2" text="등록" position="absolute 268 2 312 24" onclick="Tab00_tabpage1_Button00_onclick" visible="false"/>
                  <CheckBox id="CheckBox00" taborder="7" text="입력 중" position="absolute 196 5 263 21" truevalue="Y" falsevalue="N" onclick="Tab00_tabpage1_CheckBox00_onclick"/>
                  <Grid id="grd_favTable00" taborder="8" binddataset="fafds" useinputpanel="false" cellsizingtype="both" onkeydown="grd_favTable_onkeydown" oncellclick="grd_favTable_oncellclick" position="absolute -4 -466 540 -131" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="57"/>
                          <Column size="111"/>
                          <Column size="248"/>
                          <Column size="0"/>
                          <Column size="56"/>
                          <Column size="60"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell text="사용자"/>
                          <Cell col="1" text="테이블명"/>
                          <Cell col="2" text="설명"/>
                          <Cell col="3" text="owner"/>
                          <Cell col="4" text="업무"/>
                          <Cell col="5" text="Type"/>
                        </Band>
                        <Band id="body">
                          <Cell text="bind:owner"/>
                          <Cell col="1" edittype="normal" style="align:left;" text="bind:table_name" editdisplay="display"/>
                          <Cell col="2" edittype="normal" style="align:left;" text="bind:comments" editdisplay="display" tooltiptext="bind:comments" autosizerow="limitmax" autosizecol="default"/>
                          <Cell col="3" edittype="normal" text="bind:owner"/>
                          <Cell col="4" text="bind:domain"/>
                          <Cell col="5" text="bind:object_type"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="tabpage2" text="History">
              <Layouts>
                <Layout>
                  <Grid id="grd_HistTable" taborder="0" binddataset="histds" useinputpanel="false" cellsizingtype="both" oncellclick="fTblGridOnClick" position="absolute 0 3 543 370" anchor="all" onkeydown="fGridKeyDownEvents">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="57"/>
                          <Column size="111"/>
                          <Column size="296"/>
                          <Column size="0"/>
                          <Column size="60"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell text="사용자"/>
                          <Cell col="1" text="테이블명"/>
                          <Cell col="2" text="설명"/>
                          <Cell col="3" text="owner"/>
                          <Cell col="4" text="Type"/>
                        </Band>
                        <Band id="body">
                          <Cell text="bind:owner"/>
                          <Cell col="1" edittype="normal" style="align:left;" text="bind:table_name" editdisplay="display"/>
                          <Cell col="2" edittype="normal" style="align:left;" text="bind:comments" editdisplay="display" tooltiptext="bind:comments" autosizerow="limitmax" autosizecol="default"/>
                          <Cell col="3" edittype="normal" text="bind:owner"/>
                          <Cell col="4" text="bind:object_type"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="tabpage3" text="tabpage3">
              <Layouts>
                <Layout>
                  <Grid id="grd_workgroup" taborder="0" binddataset="grd_workgroup" useinputpanel="false" cellsizingtype="both" onkeydown="Tab00_tabpage2_grd_HistTable_onkeydown" oncellclick="grd_favTable_oncellclick" position="absolute 84 28 543 241" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="57"/>
                          <Column size="111"/>
                          <Column size="296"/>
                          <Column size="0"/>
                          <Column size="60"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell text="사용자"/>
                          <Cell col="1" text="테이블명"/>
                          <Cell col="2" text="설명"/>
                          <Cell col="3" text="owner"/>
                          <Cell col="4" text="Type"/>
                        </Band>
                        <Band id="body">
                          <Cell text="bind:owner"/>
                          <Cell col="1" edittype="normal" style="align:left;" text="bind:table_name" editdisplay="display"/>
                          <Cell col="2" edittype="normal" style="align:left;" text="bind:comments" editdisplay="display" tooltiptext="bind:comments" autosizerow="limitmax" autosizecol="default"/>
                          <Cell col="3" edittype="normal" text="bind:owner"/>
                          <Cell col="4" text="bind:object_type"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Edit id="Edit00" taborder="1" position="absolute 83 2 314 25"/>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <CheckBox id="CheckBox02" taborder="9" text="Column" position="absolute 205 3 280 18" falsevalue="N" truevalue="Y" value="N" onclick="CheckBox02_onclick"/>
        <Static id="Static01" position="absolute 608 3 819 22" style="font:Dotum,9,bold;"/>
        <Combo id="cbDbType" taborder="11" position="absolute 289 2 381 22" codecolumn="codecolumn" datacolumn="datacolumn" index="-1" onitemchanged="cbDbType_onitemchanged" visible="true">
          <Dataset id="innerdataset">
            <ColumnInfo>
              <Column id="codecolumn" size="256"/>
              <Column id="datacolumn" size="256"/>
            </ColumnInfo>
            <Rows>
              <Row>
                <Col id="codecolumn">EMR</Col>
                <Col id="datacolumn">EMR</Col>
              </Row>
              <Row>
                <Col id="codecolumn">MIS</Col>
                <Col id="datacolumn">MIS</Col>
              </Row>
            </Rows>
          </Dataset>
        </Combo>
        <Splitter id="Splitter01" position="absolute 553 555 1193 561" type="vertical" style="background:bisque;border:0 solid #7eb1dcff ;bordertype:normal 1 1 ;" anchor="left top right">
          <Formats>
            <Format id="default">
              <SplitterItems id="items">
                <SplitterItem id="item00" bindtype="resize" position="leftortop" offset="0" componentid="Tab01"/>
                <SplitterItem id="item01" bindtype="resize" position="rightorbottom" offset="0" componentid="Div02"/>
              </SplitterItems>
            </Format>
          </Formats>
        </Splitter>
        <Div id="Div02" taborder="14" text="Div02" position="absolute 553 562 1192 697" style="background:white;" anchor="left top right">
          <Layouts>
            <Layout>
              <Grid id="Grid03" taborder="2" binddataset="ds_code_info" useinputpanel="false" position="absolute 0 29 634 133" anchor="all" autoenter="select" readonly="false">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="79"/>
                      <Column size="83"/>
                      <Column size="133"/>
                      <Column size="320"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell text="그룹"/>
                      <Cell col="1" text="코드"/>
                      <Cell col="2" text="코드명"/>
                      <Cell col="3" text="코드설명"/>
                    </Band>
                    <Band id="body">
                      <Cell edittype="text" text="bind:cdgrupid" editautoselect="true"/>
                      <Cell col="1" edittype="text" style="align:left;" text="bind:cdid" editautoselect="true"/>
                      <Cell col="2" edittype="text" style="align:left;" text="bind:cdnm" editautoselect="true"/>
                      <Cell col="3" edittype="text" style="align:left;" text="bind:detldesc" editautoselect="true"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Combo id="Combo00" taborder="0" text="Combo00" position="absolute 0 4 112 27" codecolumn="codecolumn" datacolumn="datacolumn" anchor="default">
                <Dataset id="innerdataset">
                  <ColumnInfo>
                    <Column id="codecolumn" size="256"/>
                    <Column id="datacolumn" size="256"/>
                  </ColumnInfo>
                  <Rows>
                    <Row>
                      <Col id="codecolumn">zbcmcode</Col>
                      <Col id="datacolumn">공통코드</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">mnwmcode</Col>
                      <Col id="datacolumn">간호공통코드</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">mmbdhrcd</Col>
                      <Col id="datacolumn">진료하드코드</Col>
                    </Row>
                    <Row>
                      <Col id="codecolumn">pmcmcode</Col>
                      <Col id="datacolumn">원무공통코드</Col>
                    </Row>
                  </Rows>
                </Dataset>
              </Combo>
              <Edit id="Edit00" taborder="1" position="absolute 120 4 293 26" onkeydown="Div02_Edit00_onkeydown" inputmode="upper" autoselect="true" anchor="default"/>
              <CheckBox id="CheckBox00" taborder="3" text="포함" position="absolute 322 5 376 25" falsevalue="N" truevalue="Y"/>
            </Layout>
          </Layouts>
        </Div>
        <CheckBox id="CheckBox04" taborder="15" position="absolute 553 708 570 728" falsevalue="N" truevalue="Y"/>
        <Tab id="Tab01" taborder="17" tabindex="2" scrollbars="autoboth" position="absolute 552 24 1197 552" style="background:azure URL('theme://images/bg_tab_BodyTop.png') stretch 10,26;" anchor="left top right" canchange="Tab01_canchange">
          <Tabpages>
            <Tabpage id="tabpage1" text="컬럼정보">
              <Layouts>
                <Layout>
                  <Grid id="Grid01" taborder="0" binddataset="ds_column_info" autoenter="select" useinputpanel="false" cellsizingtype="both" onkeydown="Grid01_onkeydown" onkeyup="Grid01_onkeyup" onsetfocus="Grid01_onsetfocus" onkillfocus="Grid01_onkillfocus" oncellclick="Grid01_oncellclick" oncelldblclick="Grid01_oncelldblclick" onnodataareadblclick="Grid01_onnodataareadblclick" tooltiptype="hover" anchor="all" position="absolute 0 31 644 498" positiontype="position">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="20"/>
                          <Column size="112"/>
                          <Column size="280"/>
                          <Column size="40"/>
                          <Column size="116"/>
                          <Column size="25"/>
                          <Column size="0"/>
                          <Column size="0"/>
                          <Column size="25"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell/>
                          <Cell col="1" text="컬럼ID"/>
                          <Cell col="2" text="컬럼명"/>
                          <Cell col="3" text="순번"/>
                          <Cell col="4" text="타입(길이)"/>
                          <Cell col="5" text="null"/>
                          <Cell col="6" text="기본값"/>
                          <Cell col="7"/>
                          <Cell col="8" text="PK"/>
                        </Band>
                        <Band id="body">
                          <Cell text="expr:ds_column_info.rowposition == currow? '▶':''"/>
                          <Cell col="1" displaytype="normal" edittype="none" style="align:left;" text="bind:id" editdisplay="edit"/>
                          <Cell col="2" edittype="text" style="align:left;" text="bind:nm" tooltiptype="none" tooltiptext="bind:nm"/>
                          <Cell col="3" text="bind:seq"/>
                          <Cell col="4" edittype="none" text="bind:typeflag"/>
                          <Cell col="5" text="bind:nullflag"/>
                          <Cell col="6" text="bind:defaultval"/>
                          <Cell col="7" text="bind:pkyn"/>
                          <Cell col="8" text="bind:pkyn"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Static id="caption00" text="컬럼명" class="tit_2" position="absolute 3 8 66 25"/>
                  <Edit id="ipt_column_name" taborder="1" inputmode="upper" autoselect="true" onkeydown="ipt_column_name_onkeydown" ontextchanged="ipt_column_name_ontextchanged" class="input_search" position="absolute 74 7 183 26"/>
                  <CheckBox id="CheckBox01" taborder="2" text="포함 여부" value="N" truevalue="Y" falsevalue="N" position="absolute 194 9 269 24"/>
                  <CheckBox id="CheckBox03" taborder="3" text="색상표시" value="N" truevalue="Y" falsevalue="N" onclick="CheckBox03_onclick" position="absolute 283 8 355 24"/>
                  <CheckBox id="CheckBox00" taborder="4" text="주석여부" value="N" truevalue="Y" falsevalue="N" position="absolute 364 6 434 26"/>
                  <Static id="caption2" text="DB(AS)" class="search_name" position="absolute 445 8 504 25"/>
                  <Edit id="Edit00" taborder="5" position="absolute 509 6 559 26"/>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="tabpage2" text="Source">
              <Layouts>
                <Layout>
                  <Static id="st_view_name" position="absolute 3 0 376 14" text="TEST" style="background:transparent;"/>
                  <TextArea id="txt_viewSrc" taborder="1" autoselect="false" position="absolute 0 16 641 501" style="font:돋움체,10;" anchor="all"/>
                </Layout>
              </Layouts>
            </Tabpage>
            <Tabpage id="tabpage3" text="Dependencies">
              <Layouts>
                <Layout>
                  <Grid id="Grid00" taborder="0" useinputpanel="false" position="absolute 1 27 644 501" binddataset="ds_dependencies" cellsizebandtype="body" cellsizingtype="both" autoenter="select" readonly="false" anchor="all">
                    <Formats>
                      <Format id="default">
                        <Columns>
                          <Column size="40"/>
                          <Column size="80"/>
                          <Column size="271"/>
                          <Column size="79"/>
                          <Column size="102"/>
                        </Columns>
                        <Rows>
                          <Row size="24" band="head"/>
                          <Row size="24"/>
                        </Rows>
                        <Band id="head">
                          <Cell text="No"/>
                          <Cell col="1" text="Owner"/>
                          <Cell col="2" text="Dep Name"/>
                          <Cell col="3" text="Status"/>
                          <Cell col="4" text="type"/>
                        </Band>
                        <Band id="body">
                          <Cell edittype="text" style="color:EXPR((status == 'INVALID'? 'silver':''));color2:EXPR((status == 'INVALID'? 'silver':''));" text="expr:currow" editdisplay="edit"/>
                          <Cell col="1" displaytype="text" edittype="text" style="color:EXPR((status == 'INVALID'? 'silver':''));color2:EXPR((status == 'INVALID'? 'silver':''));" text="bind:owner" editautoselect="true" editdisplay="edit"/>
                          <Cell col="2" displaytype="text" edittype="text" style="align:left;color:EXPR((status == 'INVALID'? 'silver':''));color2:EXPR((status == 'INVALID'? 'silver':''));" text="bind:name" editautoselect="true" editdisplay="edit"/>
                          <Cell col="3" displaytype="text" edittype="text" style="color:EXPR((status == 'INVALID'? 'silver':''));color2:EXPR((status == 'INVALID'? 'silver':''));" text="bind:status" editautoselect="true" editdisplay="edit"/>
                          <Cell col="4" displaytype="text" edittype="text" style="align:left;color:EXPR((status == 'INVALID'? 'silver':''));color2:EXPR((status == 'INVALID'? 'silver':''));" text="bind:object_type" editautoselect="true" editdisplay="edit"/>
                        </Band>
                      </Format>
                    </Formats>
                  </Grid>
                  <Button id="btnLeftMove" taborder="1" text="◀ 옮기기" position="absolute 3 2 76 23" onclick="Tab01_tabpage3_btnLeftMove_onclick"/>
                  <Combo id="cbObjectTypeDep" taborder="2" codecolumn="codecolumn" datacolumn="datacolumn" position="absolute 92 2 214 23" onitemchanged="Tab01_tabpage3_cbObjectTypeDep_onitemchanged">
                    <Dataset id="innerdataset">
                      <ColumnInfo>
                        <Column id="codecolumn" size="256"/>
                        <Column id="datacolumn" size="256"/>
                      </ColumnInfo>
                      <Rows>
                        <Row>
                          <Col id="codecolumn"/>
                          <Col id="datacolumn"/>
                        </Row>
                        <Row>
                          <Col id="codecolumn">TABLE</Col>
                          <Col id="datacolumn">TABLE</Col>
                        </Row>
                        <Row>
                          <Col id="codecolumn">VIEW</Col>
                          <Col id="datacolumn">VIEW</Col>
                        </Row>
                        <Row>
                          <Col id="codecolumn">FUNCTION</Col>
                          <Col id="datacolumn">FUNCTION</Col>
                        </Row>
                        <Row>
                          <Col id="codecolumn">PROCEDURE</Col>
                          <Col id="datacolumn">PROCEDURE</Col>
                        </Row>
                        <Row>
                          <Col id="codecolumn">TRIGGER</Col>
                          <Col id="datacolumn">TRIGGER</Col>
                        </Row>
                      </Rows>
                    </Dataset>
                  </Combo>
                </Layout>
              </Layouts>
            </Tabpage>
          </Tabpages>
        </Tab>
        <Static id="Static02" position="absolute 552 3 599 22" style="background:transparent;font:Dotum,9,bold;"/>
        <Grid id="Grid00" taborder="21" binddataset="ds" useinputpanel="false" cellsizingtype="both" onkeydown="fGridKeyDownEvents" onkeyup="fGridKeyUpEvents" oncellclick="fTblGridOnClick" position="absolute 0 79 549 455" anchor="left top bottom" tooltiptype="hover">
          <Formats>
            <Format id="default">
              <Columns>
                <Column size="57"/>
                <Column size="111"/>
                <Column size="296"/>
                <Column size="0"/>
                <Column size="59"/>
              </Columns>
              <Rows>
                <Row size="24" band="head"/>
                <Row size="24"/>
              </Rows>
              <Band id="head">
                <Cell text="사용자"/>
                <Cell col="1" text="테이블명"/>
                <Cell col="2" text="설명"/>
                <Cell col="3" text="owner"/>
                <Cell col="4" text="Type"/>
              </Band>
              <Band id="body">
                <Cell edittype="text" text="bind:owner"/>
                <Cell col="1" edittype="normal" style="align:left;" text="bind:table_name" editdisplay="display" tooltiptext="bind:table_name"/>
                <Cell col="2" edittype="normal" style="align:left;" text="bind:comments" editdisplay="display" tooltiptext="bind:comments" autosizerow="limitmax" autosizecol="default"/>
                <Cell col="3" edittype="normal" text="bind:owner"/>
                <Cell col="4" style="align:left;" text="bind:object_type"/>
              </Band>
            </Format>
          </Formats>
        </Grid>
        <Combo id="cbObjectType" taborder="22" codecolumn="codecolumn" datacolumn="datacolumn" onitemchanged="cbObjectType_onitemchanged" position="absolute 1 51 123 73">
          <Dataset id="innerdataset">
            <ColumnInfo>
              <Column id="codecolumn" size="256"/>
              <Column id="datacolumn" size="256"/>
            </ColumnInfo>
            <Rows>
              <Row>
                <Col id="codecolumn"/>
                <Col id="datacolumn"/>
              </Row>
              <Row>
                <Col id="codecolumn">TABLE</Col>
                <Col id="datacolumn">TABLE</Col>
              </Row>
              <Row>
                <Col id="codecolumn">VIEW</Col>
                <Col id="datacolumn">VIEW</Col>
              </Row>
              <Row>
                <Col id="codecolumn">FUNCTION</Col>
                <Col id="datacolumn">FUNCTION</Col>
              </Row>
              <Row>
                <Col id="codecolumn">PROCEDURE</Col>
                <Col id="datacolumn">PROCEDURE</Col>
              </Row>
              <Row>
                <Col id="codecolumn">TRIGGER</Col>
                <Col id="datacolumn">TRIGGER</Col>
              </Row>
            </Rows>
          </Dataset>
        </Combo>
        <Div id="Div00" taborder="10" position="absolute 1261 228 1504 508" style="background:azure;border:1 solid #808080ff ;" visible="false">
          <Layouts>
            <Layout>
              <Grid id="Grid00" taborder="0" useinputpanel="false" position="absolute 5 62 194 198" anchor="default" binddataset="ds_hrcd">
                <Formats/>
              </Grid>
              <Button id="Button00" taborder="1" text="Button00" position="absolute 5 8 113 29" onclick="Div00_Button00_onclick" anchor="default"/>
              <Button id="Button01" taborder="2" text="Button01" position="absolute 13 38 115 58" onclick="Div00_Button01_onclick" anchor="default"/>
              <Button id="Button02" taborder="3" text="Button00" onclick="Button00_onclick" position="absolute 10 216 118 246" anchor="default"/>
              <Button id="Button03" taborder="4" text="로그테스트" onclick="Button01_onclick" visible="true" position="absolute 13 252 122 275" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btnReload" taborder="23" text="R" position="absolute 512 1 546 21" onclick="btnReload_onclick"/>
        <Div id="Div01" taborder="13" text="Div01" position="absolute 1204 27 1493 206" style="background:antiquewhite;align:center top;" visible="false">
          <Layouts>
            <Layout width="641" height="395">
              <Edit id="Edit00" taborder="0" position="absolute 4 11 160 38" anchor="default"/>
              <Grid id="Grid00" taborder="1" useinputpanel="false" position="absolute 8 40 280 169" binddataset="ds_test_grd" anchor="default">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="123"/>
                      <Column size="147"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <Cell col="1"/>
                    </Band>
                    <Band id="body">
                      <Cell text="bind:prcpcd"/>
                      <Cell col="1" text="bind:prcpnm"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Button id="Button00" taborder="2" text="Procedure 실행" position="absolute 166 11 276 35" onclick="Div01_Button00_onclick" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Edit id="Edit00" taborder="24" position="absolute 796 27 1088 44"/>
        <Div id="divRepSql" taborder="16" text="Div03" position="absolute 1520 193 2562 885" style="background:cornsilk;" visible="false" onrbuttondown="divRepSql_onrbuttondown">
          <Layouts>
            <Layout>
              <Grid id="Grid00" taborder="0" useinputpanel="false" position="absolute 15 54 287 675" binddataset="ds_parameter" anchor="default" autoenter="select" onkeydown="Div03_Grid00_onkeydown">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="55"/>
                      <Column size="98"/>
                      <Column size="96"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <Cell col="1"/>
                      <Cell col="2"/>
                    </Band>
                    <Band id="body">
                      <Cell text="expr:currow"/>
                      <Cell col="1" edittype="text" text="bind:before" editautoselect="true"/>
                      <Cell col="2" edittype="text" text="bind:after" editautoselect="true"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Button id="Button00" taborder="1" text="찾기" position="absolute 16 19 131 46" anchor="default" onclick="Div03_Button00_onclick"/>
              <TextArea id="TextArea00" taborder="2" position="absolute 294 60 1025 360" autoselect="true" anchor="default"/>
              <TextArea id="TextArea01" taborder="3" position="absolute 292 367 1023 676" autoselect="true" anchor="default"/>
              <Button id="Button01" taborder="4" text="치환" position="absolute 139 17 252 45" onclick="divRepSql_Button01_onclick" anchor="default"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btn_merge" taborder="26" text="Merge 문 생성" class="btn4_letter8" position="absolute 976 707 1069 729" onclick="btn_merge_onclick"/>
        <Div id="divScript" taborder="25" text="Div03" position="absolute 1200 244 2398 1089" style="background:cornsilk;" visible="false" anchor="all">
          <Layouts>
            <Layout>
              <Combo id="cbScriptowner" taborder="0" position="absolute 16 13 156 37" anchor="default" innerdataset="@ds_dbUsers" datacolumn="owner" codecolumn="owner" index="-1"/>
              <Edit id="edtScripttablename" taborder="1" position="absolute 168 13 324 37" inputmode="upper" anchor="default"/>
              <Grid id="Grid00" taborder="2" useinputpanel="false" position="absolute 224 69 1192 444" binddataset="ds_scriptcolumn" anchor="left top right" cellsizingtype="col" autoenter="select" onkeydown="divScript_Grid00_onkeydown" selecttype="multirow" onkillfocus="divScript_Grid00_onkillfocus">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="26"/>
                      <Column size="40"/>
                      <Column size="124"/>
                      <Column size="108"/>
                      <Column size="64"/>
                      <Column size="80"/>
                      <Column size="53"/>
                      <Column size="62"/>
                      <Column size="393"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <Cell col="1" text="No"/>
                      <Cell col="2" text="컬럼명"/>
                      <Cell col="3" text="타입"/>
                      <Cell col="4" text="길이"/>
                      <Cell col="5" text="Not Null"/>
                      <Cell col="6" text="기본값"/>
                      <Cell col="7" text="PK"/>
                      <Cell col="8" text="설명"/>
                    </Band>
                    <Band id="body">
                      <Cell/>
                      <Cell col="1" text="expr:currow+1"/>
                      <Cell col="2" edittype="text" editfilter="upper,number,char" text="bind:columnname" editautoselect="true"/>
                      <Cell col="3" displaytype="combo" edittype="combo" style="padding:2 2 2 2;" text="bind:type" editautoselect="true" combodataset="ds_scripttypecd" combocodecol="type" combodatacol="type"/>
                      <Cell col="4" edittype="text" editfilter="number,char" style="align:center;" text="bind:length" editautoselect="true"/>
                      <Cell col="5" displaytype="combo" edittype="combo" style="align:center;" text="bind:isnotnull" editautoselect="true" combodataset="ds_yesno" combocodecol="flag" combodatacol="flag"/>
                      <Cell col="6" edittype="text" text="bind:defaultval" editautoselect="true"/>
                      <Cell col="7" displaytype="combo" edittype="combo" style="align:center;" text="bind:ispk" editautoselect="true" combodataset="ds_yesno" combocodecol="flag" combodatacol="flag"/>
                      <Cell col="8" edittype="text" text="bind:columncomment" editautoselect="true"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Button id="btnScriptAction" taborder="3" text="행 추가" position="absolute 797 46 874 66" onclick="Div03_btnScriptAction_onclick" anchor="default"/>
              <Edit id="edtScriptcomment" taborder="4" position="absolute 356 13 823 37" anchor="default"/>
              <Button id="btnScriptAction00" taborder="5" text="행 삭제" onclick="Div03_btnScriptAction_onclick" position="absolute 876 46 953 66" anchor="default"/>
              <Button id="btnScriptGen" taborder="6" text="생성" position="absolute 1113 46 1190 66" onclick="Div03_btnScriptGen_onclick" anchor="default"/>
              <Button id="btnScriptAction01" taborder="9" text="위로" onclick="Div03_btnScriptAction_onclick" position="absolute 955 46 1032 66" anchor="default"/>
              <Button id="btnScriptAction02" taborder="10" text="아래로" onclick="Div03_btnScriptAction_onclick" position="absolute 1034 46 1111 66" anchor="default"/>
              <Tab id="Tab00" taborder="11" tabindex="0" scrollbars="autoboth" position="absolute 1 450 1196 840" anchor="all" style="background:honeydew URL('theme://images/bg_tab_BodyTop.png') stretch 10,26;">
                <Tabpages>
                  <Tabpage id="tabpage1" text="컬럼">
                    <Layouts>
                      <Layout>
                        <Edit id="Edit00" taborder="1" inputmode="upper" onkeydown="Div03_Div00_Edit00_onkeydown" position="absolute 2 6 157 30" anchor="default" autoselect="true"/>
                        <Grid id="Grid00" taborder="2" binddataset="ds_columnlist" useinputpanel="false" cellsizingtype="col" oncelldblclick="divColumnlist_Grid00_oncelldblclick" position="absolute 3 34 1191 359" anchor="all">
                          <Formats>
                            <Format id="default">
                              <Columns>
                                <Column size="58"/>
                                <Column size="99"/>
                                <Column size="339"/>
                                <Column size="134"/>
                                <Column size="93"/>
                                <Column size="44"/>
                                <Column size="83"/>
                                <Column size="310"/>
                              </Columns>
                              <Rows>
                                <Row size="24" band="head"/>
                                <Row size="24"/>
                              </Rows>
                              <Band id="head">
                                <Cell text="사용자"/>
                                <Cell col="1" text="테이블명"/>
                                <Cell col="2" text="테이블 코멘트"/>
                                <Cell col="3" text="컬럼명"/>
                                <Cell col="4" text="타입"/>
                                <Cell col="5" text="길이"/>
                                <Cell col="6" text="기본값"/>
                                <Cell col="7" text="컬럼 코멘트"/>
                              </Band>
                              <Band id="body">
                                <Cell text="bind:owner"/>
                                <Cell col="1" style="align:left;" text="bind:tablename"/>
                                <Cell col="2" edittype="textarea" style="align:left;" text="bind:tablecomment" tooltiptype="mouse" tooltiptext="bind:tablecomment"/>
                                <Cell col="3" style="align:left;" text="bind:columnname"/>
                                <Cell col="4" text="bind:type"/>
                                <Cell col="5" text="bind:length"/>
                                <Cell col="6" text="bind:defaultva"/>
                                <Cell col="7" edittype="textarea" style="align:left;" text="bind:columncomment" tooltiptype="mouse" tooltiptext="bind:columncomment"/>
                              </Band>
                            </Format>
                          </Formats>
                        </Grid>
                      </Layout>
                    </Layouts>
                  </Tabpage>
                  <Tabpage id="tabpage2" text="스크립트">
                    <Layouts>
                      <Layout>
                        <TextArea id="TextArea00" taborder="0" position="absolute 3 -2 1190 358" anchor="all"/>
                      </Layout>
                    </Layouts>
                  </Tabpage>
                </Tabpages>
              </Tab>
              <Button id="btnScriptsave" taborder="12" text="저장" position="absolute 639 46 716 66" anchor="default" onclick="Div03_btnScriptAction_onclick"/>
              <Grid id="Grid01" taborder="13" useinputpanel="false" position="absolute 4 69 219 444" binddataset="ds_scripttable" anchor="default" oncellclick="divScript_Grid01_oncellclick" cellsizingtype="col">
                <Formats>
                  <Format id="default">
                    <Columns>
                      <Column size="25"/>
                      <Column size="47"/>
                      <Column size="121"/>
                    </Columns>
                    <Rows>
                      <Row size="24" band="head"/>
                      <Row size="24"/>
                    </Rows>
                    <Band id="head">
                      <Cell/>
                      <Cell col="1" text="Owner"/>
                      <Cell col="2" text="테이블명"/>
                    </Band>
                    <Band id="body">
                      <Cell text="expr:currow + 1"/>
                      <Cell col="1" text="bind:owner"/>
                      <Cell col="2" style="align:left;" text="bind:tablename" tooltiptype="mouse" tooltiptext="bind:comment"/>
                    </Band>
                  </Format>
                </Formats>
              </Grid>
              <Button id="btnScriptpaste" taborder="14" text="붙여넣기" position="absolute 560 46 637 66" onclick="divScript_btnScriptpaste_onclick" anchor="default"/>
              <Button id="btnScriptAction03" taborder="15" text="삭제" onclick="Div03_btnScriptAction_onclick" position="absolute 718 46 795 66"/>
              <Edit id="Edit00" taborder="16" position="absolute 14 41 163 63"/>
            </Layout>
          </Layouts>
        </Div>
        <Button id="btnFormOpen" taborder="27" text="Open" position="absolute 1050 2 1182 22" onclick="btnFormOpen_onclick" visible="true"/>
      </Layout>
    </Layouts>
    <Objects>
      <FilteredDataset id="fds" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" binddataset="@ds"/>
      <Dataset id="ds" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="table_name" type="STRING" size="256"/>
          <Column id="comments" type="STRING" size="256"/>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="object_type" type="STRING" size="256"/>
          <Column id="domain" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_table_name" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="table_name" type="STRING" size="256"/>
          <Column id="object_type" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_cond" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="table_name" type="STRING" size="256"/>
          <Column id="table_comment" type="STRING" size="256"/>
          <Column id="column_name" type="STRING" size="256"/>
          <Column id="domain" type="STRING" size="256"/>
          <Column id="domain_combo_inx" type="INT" size="256"/>
          <Column id="inputYn" type="STRING" size="256"/>
          <Column id="dbtype" type="STRING" size="256"/>
          <Column id="object_type" type="STRING" size="256"/>
          <Column id="selectcolumn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="inputYn">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_column_name" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="column_name" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_column_info" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="id" type="STRING" size="256"/>
          <Column id="nm" type="STRING" size="256"/>
          <Column id="seq" type="STRING" size="256"/>
          <Column id="typeflag" type="STRING" size="256"/>
          <Column id="nullflag" type="STRING" size="256"/>
          <Column id="defaultval" type="STRING" size="256"/>
          <Column id="pkyn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_send" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="table_name" type="STRING" size="256"/>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="cdgrupid" type="STRING" size="256"/>
          <Column id="hrcdtype" type="STRING" size="256"/>
          <Column id="likeyn" type="STRING" size="256"/>
          <Column id="columnname" type="STRING" size="256"/>
          <Column id="strrownum" type="STRING" size="256"/>
          <Column id="endrownum" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_index_info" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="index_name" type="STRING" size="256"/>
          <Column id="index_const" type="STRING" size="256"/>
          <Column id="index_type" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <FilteredDataset id="fds_column_info" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" binddataset="@ds_column_info"/>
      <Dataset id="ds_dbas" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="dbasnm" type="STRING" size="256"/>
          <Column id="commentyn" type="STRING" size="256"/>
          <Column id="containYn" type="STRING" size="256"/>
          <Column id="searchColumn" type="STRING" size="256"/>
          <Column id="searchColumnDisplayType" type="STRING" size="256"/>
          <Column id="searchindexcolumn" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="searchColumn">false</Col>
            <Col id="searchColumnDisplayType">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_code_info" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" cancolumnchange="ds_code_info_cancolumnchange">
        <ColumnInfo>
          <Column id="cdid" type="STRING" size="256"/>
          <Column id="cdnm" type="STRING" size="256"/>
          <Column id="detldesc" type="STRING" size="256"/>
          <Column id="cdgrupid" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_dbUsers" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="owner" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
          <Row>
            <Col id="owner">EMR</Col>
          </Row>
          <Row>
            <Col id="owner">PAM</Col>
          </Row>
          <Row>
            <Col id="owner">COM</Col>
          </Row>
          <Row>
            <Col id="owner">MIS</Col>
          </Row>
          <Row>
            <Col id="owner">STS</Col>
          </Row>
          <Row>
            <Col id="owner">CRM</Col>
          </Row>
          <Row>
            <Col id="owner">AST</Col>
          </Row>
          <Row>
            <Col id="owner">LIS</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="fafds" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="table_name" type="STRING" size="256"/>
          <Column id="comments" type="STRING" size="4000"/>
          <Column id="object_type" type="STRING" size="256"/>
          <Column id="domain" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_viewSource" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="text" type="STRING" size="999999"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="text">cw==</Col>
            <Col id="name">s</Col>
            <Col id="owner">s</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_sample" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="radio_value" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="histds" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="table_name" type="STRING" size="256"/>
          <Column id="comments" type="STRING" size="4000"/>
          <Column id="object_type" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="dsback" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="table_name" type="STRING" size="256"/>
          <Column id="comments" type="STRING" size="256"/>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="object_type" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_domain" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="domain" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
          <Row>
            <Col id="domain">응급</Col>
          </Row>
          <Row>
            <Col id="domain">진료</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_hrcd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="ds_columcomment" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="tablename" type="STRING" size="256"/>
          <Column id="columnid" type="STRING" size="256"/>
          <Column id="comment" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_pkcolumn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="id" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_test" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="key" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_test_grd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false"/>
      <Dataset id="arg_ds_arg1" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="formno" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_parameter" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="id" type="STRING" size="256"/>
          <Column id="before" type="STRING" size="256"/>
          <Column id="after" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_sql" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="id" type="STRING" size="256"/>
          <Column id="before" type="STRING" size="256"/>
          <Column id="after" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_dependencies" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="lv" type="STRING" size="256"/>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="name" type="STRING" size="256"/>
          <Column id="status" type="STRING" size="256"/>
          <Column id="table_name" type="STRING" size="256"/>
          <Column id="object_type" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_tmp" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="table_name" type="STRING" size="256"/>
          <Column id="comments" type="STRING" size="256"/>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="object_type" type="STRING" size="256"/>
          <Column id="domain" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
      <Dataset id="ds_scripttable" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="tablename" type="STRING" size="256"/>
          <Column id="comment" type="STRING" size="256"/>
          <Column id="tablespace" type="STRING" size="256"/>
          <Column id="script" type="STRING" size="9999999"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_scriptcolumn" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_scriptcolumn_oncolumnchanged">
        <ColumnInfo>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="tablename" type="STRING" size="256"/>
          <Column id="columnname" type="STRING" size="256"/>
          <Column id="type" type="STRING" size="256"/>
          <Column id="length" type="STRING" size="256"/>
          <Column id="isnotnull" type="STRING" size="256"/>
          <Column id="defaultval" type="STRING" size="256"/>
          <Column id="ispk" type="STRING" size="256"/>
          <Column id="columncomment" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_scripttypecd" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="type" type="STRING" size="256"/>
          <Column id="isreqlegnth" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row>
            <Col id="type">VARCHAR2</Col>
            <Col id="isreqlegnth">Y</Col>
          </Row>
          <Row>
            <Col id="type">NUMBER</Col>
            <Col id="isreqlegnth">Y</Col>
          </Row>
          <Row>
            <Col id="type">TIMESTAMP</Col>
            <Col id="isreqlegnth">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_columnlist" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="tablename" type="STRING" size="256"/>
          <Column id="tablecomment" type="STRING" size="256"/>
          <Column id="columnname" type="STRING" size="256"/>
          <Column id="type" type="STRING" size="256"/>
          <Column id="length" type="STRING" size="256"/>
          <Column id="columncomment" type="STRING" size="256"/>
          <Column id="defaultva" type="STRING" size="256"/>
        </ColumnInfo>
      </Dataset>
      <Dataset id="ds_yesno" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false">
        <ColumnInfo>
          <Column id="flag" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
          <Row>
            <Col id="flag">Y</Col>
          </Row>
          <Row>
            <Col id="flag">N</Col>
          </Row>
        </Rows>
      </Dataset>
      <Dataset id="ds_scriptinput" firefirstcount="0" firenextcount="0" useclientlayout="false" updatecontrol="true" enableevent="true" loadkeymode="keep" loadfiltermode="keep" reversesubsum="false" oncolumnchanged="ds_scriptinput_oncolumnchanged">
        <ColumnInfo>
          <Column id="owner" type="STRING" size="256"/>
          <Column id="tablename" type="STRING" size="256"/>
          <Column id="comment" type="STRING" size="256"/>
          <Column id="tablespace" type="STRING" size="256"/>
          <Column id="script" type="STRING" size="9999999"/>
          <Column id="dsname" type="STRING" size="256"/>
        </ColumnInfo>
        <Rows>
          <Row/>
        </Rows>
      </Dataset>
    </Objects>
    <Bind>
      <BindItem id="item25" compid="cbObjectType" propid="value" datasetid="ds_table_name" columnid="object_type"/>
      <BindItem id="item1" compid="Grid00" propid="tooltiptext" datasetid="fds" columnid=""/>
      <BindItem id="item2" compid="Grid00" propid="readonly" datasetid="fds" columnid=""/>
      <BindItem id="item0" compid="ipt_table_name" propid="value" datasetid="ds_table_name" columnid="table_name"/>
      <BindItem id="item9" compid="CheckBox02" propid="value" datasetid="ds_dbas" columnid="searchColumn"/>
      <BindItem id="item10" compid="CheckBox02" propid="truevalue" datasetid="ds_cond" columnid=""/>
      <BindItem id="item11" compid="Tab00.tabpage1.Combo00" propid="value" datasetid="ds_cond" columnid="domain"/>
      <BindItem id="item12" compid="Tab00.tabpage1.Div00.Edit00" propid="value" datasetid="ds_cond" columnid="domain"/>
      <BindItem id="item13" compid="Tab00.tabpage1.CheckBox00" propid="value" datasetid="ds_cond" columnid="inputYn"/>
      <BindItem id="item14" compid="Tab00.tabpage1.CheckBox00" propid="truevalue" datasetid="Y" columnid=""/>
      <BindItem id="item15" compid="Static01" propid="text" datasetid="ds_cond" columnid="table_name"/>
      <BindItem id="item16" compid="Static02" propid="text" datasetid="ds_cond" columnid="owner"/>
      <BindItem id="item17" compid="cbDbType" propid="value" datasetid="ds_cond" columnid="dbtype"/>
      <BindItem id="item19" compid="Div01.Edit00" propid="value" datasetid="ds_test" columnid="key"/>
      <BindItem id="item20" compid="Div02.Combo00" propid="value" datasetid="ds_send" columnid="hrcdtype"/>
      <BindItem id="item21" compid="Div02.Edit00" propid="value" datasetid="ds_send" columnid="cdgrupid"/>
      <BindItem id="item22" compid="CheckBox04" propid="value" datasetid="ds_dbas" columnid="searchindexcolumn"/>
      <BindItem id="item23" compid="divRepSql.TextArea01" propid="value" datasetid="ds_sql" columnid="after"/>
      <BindItem id="item24" compid="divRepSql.TextArea00" propid="value" datasetid="ds_sql" columnid="before"/>
      <BindItem id="item3" compid="Tab01.tabpage1.Grid01" propid="tooltiptext" datasetid="fds" columnid=""/>
      <BindItem id="item4" compid="Tab01.tabpage1.Grid01" propid="readonly" datasetid="fds" columnid=""/>
      <BindItem id="item5" compid="Tab01.tabpage1.ipt_column_name" propid="value" datasetid="ds_column_name" columnid="column_name"/>
      <BindItem id="item8" compid="Tab01.tabpage1.CheckBox01" propid="value" datasetid="ds_dbas" columnid="containYn"/>
      <BindItem id="item18" compid="Tab01.tabpage1.CheckBox03" propid="value" datasetid="ds_dbas" columnid="searchColumnDisplayType"/>
      <BindItem id="item7" compid="Tab01.tabpage1.CheckBox00" propid="value" datasetid="ds_dbas" columnid="commentyn"/>
      <BindItem id="item6" compid="Tab01.tabpage1.Edit00" propid="value" datasetid="ds_dbas" columnid="dbasnm"/>
      <BindItem id="item26" compid="Edit00" propid="value" datasetid="ds_cond" columnid="selectcolumn"/>
      <BindItem id="item28" compid="divScript.edtScriptcomment" propid="value" datasetid="ds_scriptinput" columnid="comment"/>
      <BindItem id="item29" compid="divScript.edtScripttablename" propid="value" datasetid="ds_scriptinput" columnid="tablename"/>
      <BindItem id="item27" compid="divScript.cbScriptowner" propid="value" datasetid="ds_scriptinput" columnid="owner"/>
      <BindItem id="item32" compid="Div02.CheckBox00" propid="value" datasetid="ds_send" columnid="likeyn"/>
      <BindItem id="item30" compid="divScript.Tab00.tabpage2.TextArea00" propid="value" datasetid="ds_scriptinput" columnid="script"/>
      <BindItem id="item31" compid="divScript.Tab00.tabpage1.Edit00" propid="value" datasetid="ds_send" columnid="columnname"/>
      <BindItem id="item33" compid="divScript.Edit00" propid="value" datasetid="ds_scriptinput" columnid="tablespace"/>
    </Bind>
    <Script type="xscript4.0"><![CDATA[include "com_commonxp::comm_main.xjs"

var objColumnname = Tab01.tabpage1.ipt_column_name;
var objScript = divScript.Grid00;

var selectedRows;

function ipt_table_name_ontextchanged(obj:Edit,  e:TextChangedEventInfo)
{
	fSearchTableList(obj);	
}

function fGetViewSource(owner, name, type)
{
// 	var owner = fds.getColumn(fds.rowposition, "owner"); 
// 	var table_name = fds.getColumn(fds.rowposition, "table_name"); 	
	dsf_createDsRow("tmp_ds", [
					  {col:"owner", type:"STRING", size:256, val:owner}
					, {col:"name", type:"STRING", size:256, val:name}
					, {col:"type", type:"STRING", size:256, val:type}
					, {col:"dbtype", type:"STRING", size:256, val:ds_cond.getColumn(0, "dbtype")}
				      ]);
	
	var oParam = {};
	oParam.id          = "TRSMP09210";
	oParam.service     = "testapp.TestMngt";
	oParam.method      = "reqGetSource";
	oParam.inds        = "req=tmp_ds";
	oParam.outds       = "ds_viewSource=info";
	oParam.async       = false;
		
	tranf_submit(oParam);
	
	var source = "";
	
	for (var i = 0; i < ds_viewSource.rowcount; i++)
	{
		if (!utlf_isNull(ds_viewSource.getColumn(i, "text")))
			source += ds_viewSource.getColumn(i, "text");
	}
	
	Tab01.tabpage2.txt_viewSrc.value = source;	
	Tab01.tabpage2.st_view_name.text =  owner + "." + name;	
}

function fGetViewUseby(owner, name, object_type)
{

	if (ds_dependencies.rowcount == 0)
	{
		dsf_createDsRow("tmp_ds", [
						  {col:"owner", type:"STRING", size:256, val:owner}
						, {col:"name", type:"STRING", size:256, val:name}
						, {col:"object_type", type:"STRING", size:256, val:object_type}
						, {col:"dbtype", type:"STRING", size:256, val:ds_cond.getColumn(0, "dbtype")}
						  ]);

		var oParam = {};
		oParam.id          = "TRSMP092101";
		oParam.service     = "testapp.TestMngt";
		oParam.method      = "reqGetUseby";
		oParam.inds        = "req=tmp_ds";
		oParam.outds       = "ds_dependencies=info";
		oParam.async       = false;
			
		tranf_submit(oParam);	
		
		//trace(ds_dependencies.saveXML());
	}
}

function fGetViewTrigger(owner, name)
{
// 	var owner = fds.getColumn(fds.rowposition, "owner"); 
// 	var table_name = fds.getColumn(fds.rowposition, "table_name"); 	
	dsf_createDsRow("tmp_ds", [
					  {col:"owner", type:"STRING", size:256, val:owner}
					, {col:"name", type:"STRING", size:256, val:name}					
					, {col:"dbtype", type:"STRING", size:256, val:ds_cond.getColumn(0, "dbtype")}
				      ]);

	var oParam = {};
	oParam.id          = "TRSMP092102";
	oParam.service     = "testapp.TestMngt";
	oParam.method      = "reqGetTrigger";
	oParam.inds        = "req=tmp_ds";
	oParam.outds       = "ds_viewSource=info";
	oParam.async       = false;
	tranf_submit(oParam);	
	
	var source = "";
	
	if (ds_viewSource.rowcount > 0)
	{
		source += ds_viewSource.getColumn(0, "referencing_names") + "\n";
		source += ds_viewSource.getColumn(0, "description") + "\n";
		source += ds_viewSource.getColumn(0, "trigger_body") + "\n";
		
		Tab01.tabpage2.txt_viewSrc.value = source;
		Tab01.tabpage2.st_view_name.text =  owner + "." + name;	
	}		
}

/* 
 * desc   : 초기화
 * create : 2019-01-10, 김병국, 최초생성
   update : 
 */
function fInitialize() {
	ds_dbas.setColumn(0, "dbasnm", "A");
	ds_dbas.setColumn(0, "commentyn", "Y");
	ds_dbas.setColumn(0, "containYn", "Y");
	
	ds_cond.setColumn(0, "dbtype", "EMR");
	
	ds_send.setColumn(0, "likeyn", "N");
		
	var oParam = {};
	oParam.id          = "TRSMP09210";
	oParam.service     = "testapp.TestMngt";
	oParam.method      = "reqGetTableInfoList";
	oParam.inds        = "req=ds_cond";
	oParam.outds       = "ds=info";	
	oParam.async	   = true;
	oParam.callback    = "cf_TRADB09204";
		
	tranf_submit(oParam);
	
	fGetDataSet ("fafds", "./fafds.xml");
	
	if ( utlf_isNull(fafds.getColumnInfo("domain")) )
		dsf_makeValue(fafds,"domain"		,"string", "");
	
	fGetDataSet ("ds_domain", "./ds_domain.xml");	
	
	grdf_initGrid(Tab00.tabpage1.grd_favTable); 	
	grdf_initGrid(Grid00); 
	grdf_initGrid(Tab01.tabpage1.Grid01); 
	grdf_initGrid(Div02.Grid03);
	grdf_initGrid(divScript.Tab00.tabpage1.Grid00);
	
	grdf_initGrid(Tab01.tabpage3.Grid00); 
	
	this.setTimer(1, 1000 * 60 * 30);
	
	divScript.position.x = 0;
	divScript.position.y = 23;
	
// 	ds_scriptinput.setColumn(0, "owner", "EMR");
// 	ds_scriptinput.setColumn(0, "tablename", "TEST");
// 	ds_scriptinput.setColumn(0, "comment", "TEST Comment");
// 	ds_send.setColumn(0, "columnname", "PRCP");
	
	fGetDataSet ("ds_scripttable", "./TableScript/ds_scripttable.xml");
	fGetDataSet ("ds_scriptcolumn", "./ds_scriptcolumn.xml");
	
	fLoadscripttable();
	
}

function cf_TRADB09204(sSvcId, nErrorCode, sErrorMsg) {
	dsf_makeValue(ds,"domain"		,"string","");
		
	dsf_copyDs(dsback, ds);
}

function SMSMP09204_onload(obj:Form, e:LoadEventInfo)
{	
	fInitialize();
	
	Tab00.tabindex = 0;	
	Tab01.tabindex = 0;	
}

function fSetHistoryTable(ds, row)
{	
	var strSelectTableName = ds.getColumn(row, "table_name");
	var findRowIndex = histds.findRow("table_name", strSelectTableName);
	
	//trace("strSelectTableName : " + strSelectTableName);
	
	if ( findRowIndex >= 0)
	{
		histds.deleteRow(findRowIndex);
	}
	histds.insertRow(0);
	histds.copyRow(0, ds, row);
}

function fGetColumnList(owner , table_name)
{
	ds_send.clearData();
	dsf_makeValue(ds_send,"table_name", "string", table_name);
	dsf_makeValue(ds_send,"owner", "string", owner);
	dsf_makeValue(ds_send,"dbtype", "string", ds_cond.getColumn(0, "dbtype") );
	
	var oParam = {};
	oParam.id          = "TRSMP09211";
	oParam.service     = "testapp.TestMngt";
	oParam.method      = "reqGetTableDetailInfoList";
	oParam.inds        = "req=ds_send";
	oParam.outds       = "ds_column_info=info ds_index_info=index_info";
	oParam.async       = false;
	
	tranf_submit(oParam);
		
	fSetPkColumn();	
	
	fnSetSearchColumnDisplayType("");
	
	ds_code_info.clearData();
	
	ds_cond.setColumn(0, "selectcolumn", "");
	
}

function ipt_column_name_ontextchanged(obj:Edit,  e:TextChangedEventInfo)
{
	
	obj.updateToDataset();
	var column_name = utlf_transNullToEmpty(ds_column_name.getColumn(0, "column_name"));
	var containYn = ds_dbas.getColumn(0, "containYn");
		
	if(column_name == null || column_name == "") 
	{		
		ds_column_info.filter("");
		fnSetSearchColumnDisplayType("");
	} else {
	
		if (ds_dbas.getColumn(0, "searchColumnDisplayType") == "N")
		{
			var sFilter = "";
			//ds_column.filter("String(nm).indexOf('" + (e.posttext).replace("''","\\'") + "')>=0");	
			if (containYn == 'Y')
			{
				// , 구분하여 멀티로 컬럼정보 검색
				var arrKey = column_name.split(",");	
				sFilter = "1 = 0 ";
				for(var i = 0; i < arrKey.length; i++)
				{
					if ( !utlf_isNull(arrKey[i].trim()))
					{
						sFilter += "|| (String(id).toUpperCase().indexOf('" + arrKey[i].trim() + "') >= 0) ";
						sFilter += "|| (String(nm).toUpperCase().indexOf('" + arrKey[i].trim() + "') >= 0) ";
					}
				}				
			}
			else
			{
				var arrKey = column_name.split(",");	
				sFilter = "1 = 0 ";
				for(var i = 0; i < arrKey.length; i++)
				{
					if ( !utlf_isNull(arrKey[i].trim()))
					{
						sFilter += "|| String(id).toUpperCase().substr(0, String('" + arrKey[i].trim() + "').length) ==  '" + arrKey[i].trim() + "'";						
					}
				}	
				//ds_column_info.filter("String(id).toUpperCase().substr(0, String('" + column_name + "').length) ==  '" + column_name + "'");
			}	
			ds_column_info.filter(sFilter);
			
			//trace(sFilter);
				
		} 
		else
		{		
			fnSetSearchColumnDisplayType(column_name);
		}
	}
}

function fnSetSearchColumnDisplayType(srchData)
{
	
	if (utlf_isNull(srchData))
	{
		var sExpr = "";
	}
	else
	{
		var sExpr = "EXPR( (String(id).toUpperCase().indexOf('" + srchData + "') > -1 || String(nm).toUpperCase().indexOf('" + srchData + "') > -1) ? 'red' : '')";
	}	
	for (var i = 0; i < 2; i++)
	{		
		Tab01.tabpage1.Grid01.setCellProperty("Body", i, "color", sExpr);
		Tab01.tabpage1.Grid01.setCellProperty("Body", i, "color2", sExpr);
		Tab01.tabpage1.Grid01.setCellProperty("Body", i, "selectcolor", sExpr);			
	}	
}

function group2_btn_distributing_onclick(obj:Button,  e:ClickEventInfo)
{
	var clipStr = "";
	var nRow = ds.rowposition;
	var table_name = ds.getColumn(nRow, "table_name"); 
	var owner = ds.getColumn(nRow, "owner");
		
	owner = ds_cond.getColumn(0, "owner").toLowerCase();
	table_name = ds_cond.getColumn(0, "table_name").toLowerCase();
	var table_comment = ds_cond.getColumn(0, "table_comment");
		
	var dbasnm    = ds_dbas.getColumn(0, "dbasnm").toLowerCase();
	
	var commentStr = "";
	var comma = "";
	
	if(dbasnm == null || dbasnm == "") {
		dbasnm="";
	} else {
		dbasnm += ".";
	}
	
	dsf_createDs("ds_column_info_temp");
	ds_column_info_temp.clear();
	ds_column_info_temp.copyData(ds_column_info);
	
	var nm , id, rowcount;	
	rowcount = ds_column_info_temp.rowcount;
		
	clipStr += "SELECT" + "\r\n";
	
	for(var i = 0; i < rowcount; i++) {
		if(i == 0) {
			clipStr += " ";
			comma = "  ";
		} else {
			comma = ", ";
		}
		
		nm = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "nm"));
		id = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "id"));
		
		if( utlf_isNull(nm) ) {
			commentStr = "";
		} else {
			commentStr = "-- " + nm.replace("\n", " ");
		}
		clipStr += "	 " + comma + dbasnm + sRpad(id.toLowerCase(), " ", 20) + commentStr + "\r\n" ;
		
	}
	clipStr += "  FROM " + owner + "." + table_name + " " + ds_dbas.getColumn(0, "dbasnm").toLowerCase() + "        -- " + table_comment + "\n";
	clipStr += " WHERE 1 = 1" + "\n";
	
	for(var i = 0; i < ds_pkcolumn.rowcount; i++)		
	{		
		id  = sRpad(ds_pkcolumn.getColumn(i, "id").toLowerCase(), " ", 20);
		id2 = ds_pkcolumn.getColumn(i, "id");
	
		id2 = fConstColumnValue(id2);
		
		
		var nRow = ds_column_info.findRow("id", ds_pkcolumn.getColumn(i, "id"));		
		nm = utlf_transNullToEmpty(ds_column_info_temp.getColumn(nRow, "nm"));
		if( utlf_isNull(nm) ) 
		{
			commentStr = "";
		} else {
			commentStr = "-- " + nm.replace("\n", " ");
		}
				
		clipStr += "   AND " + id + " = " + sRpad(toLower(id2), " ", 20) + commentStr + "\r\n";		
	}		
	clipStr += ";";
	system.clearClipboard();

	//system.setClipboard("CF_TEXT",clipStr); 
	
	system.setClipboard("CF_UNICODETEXT",clipStr); 
	system.getClipboard("CF_UNICODETEXT").replace(",",""); 
}


//Rpad
function sRpad(sOrg, sPad, nCnt) {
	var i, sRet="";
	if(sPad == null) sPad = " ";
	if(nCnt == null) ncnt = 1;
	
	//trace("sOrg : " + sOrg);
	sRet += sOrg;
	
	for(i =0; i < nCnt-sOrg.length; i++) {
		sRet += sPad;
	
	}
	return sRet;
}

function Grid01_oncellclick(obj:Grid, e:GridClickEventInfo)
{	
	var nm = utlf_transNullToEmpty( ds_column_info.getColumn(obj.currentrow, "nm") ).trim();
	
	
	if ( utlf_isNull( nm )) 
		return;
	
	var aFlag = "N";
	var bFlag = "N";
	var cFlag = "N";
	var cdgrupid ="";
	
	if(nm.indexOf("코드군") > -1) {
		aFlag = "Y";
	}
	
	if(nm.indexOf("코드정의") > -1 || nm.indexOf("코드정의서") > -1)
	{		
		bFlag = "Y";
	}
	
	if(nm.indexOf("공통") > -1 || nm.indexOf("공통코드") > -1 ) {
		cFlag = "Y";
	}
	
	if(aFlag == "Y" || bFlag == "Y" || cFlag == "Y" || true) {
// 		alert(nm.indexOf("A0"));
// 		alert(nm.indexOf("C0"));
// 		alert(nm.indexOf("L0"));
// 		alert(nm.indexOf("M0"));
// 		alert(nm.indexOf("P0"));
// 		alert(nm.indexOf("R0"));
// 		alert(nm.indexOf("T0"));
// 		alert(nm.indexOf("Z0"));
		var nStrPos, nEndPos;
		var hrcdtype;
		
		hrcdtype = "zbcmcode";
		if( nm.indexOf("A0") > 0) {
			cdgrupid = nm.substr(nm.indexOf("A0"), 5);
		} else if( nm.indexOf("C0") > 0) {
			cdgrupid = nm.substr(nm.indexOf("C0"), 5);
		} else if( nm.indexOf("L0") > 0) {
			cdgrupid = nm.substr(nm.indexOf("L0"), 5); 
		} else if( nm.indexOf("M0") > 0) {
			cdgrupid = nm.substr(nm.indexOf("M0"), 5);
		} else if( nm.indexOf("P0") > 0) {
			cdgrupid = nm.substr(nm.indexOf("P0"), 5);
		} else if( nm.indexOf("R0") > 0) {
			cdgrupid = nm.substr(nm.indexOf("R0"), 5);
		} else if( nm.indexOf("T0") > 0) {
			cdgrupid = nm.substr(nm.indexOf("T0"), 5);
		} else if( nm.indexOf("Z0") > 0) {
			cdgrupid = nm.substr(nm.indexOf("Z0"), 5);
		} else if( nm.indexOf("간호공통코드") > 0 )
		{
			nStrPos = nm.indexOf("간호공통코드") + String("간호공통코드").length + 1;
			nEndPos = nm.indexOf(" ", nStrPos +1 );								
			if (nEndPos < 0)
				nEndPos = nm.length;			
			cdgrupid = nm.substr(nStrPos, nEndPos - nStrPos).trim();
			hrcdtype = "mnwmcode";
		} else if( nm.indexOf("원무공통코드") > 0 )
		{
			nStrPos = nm.indexOf("원무공통코드") + String("원무공통코드").length + 1;
			nEndPos = nm.indexOf(" ", nStrPos +1 );								
			if (nEndPos < 0)
				nEndPos = nm.length;			
			cdgrupid = nm.substr(nStrPos, nEndPos - nStrPos).trim();
			hrcdtype = "pmcmcode";			
		} else if ( (nm.indexOf("진료공통코드") > 0) || (nm.indexOf("진료하드코드") > 0))
		{					
			var sKeyword = "진료공통코드,진료하드코드";
			arrToken = sKeyword.split(",");
			hrcdtype = "mmbdhrcd";
			for (var i = 0; i < arrToken.length; i++)
			{			
				nStrPos = nm.indexOf(arrToken[i]) ;
				if ( nStrPos > -1 )
				{					
					nStrPos += arrToken[i].length + 1;			
					nEndPos = nm.indexOf(" ", nStrPos +1 );		
					if (nEndPos < 0)
						nEndPos = nm.length;
					cdgrupid = nm.substr(nStrPos, nEndPos - nStrPos).trim();		
					break;
				}
			}			
		}
		else
		{				
			var sKeyword = "코드군,코드정의,코드정의서,공통코드,공통";
			arrToken = sKeyword.split(",");
			hrcdtype = "zbcmcode";
			for (var i = 0; i < arrToken.length; i++)
			{			
				nStrPos = nm.indexOf(arrToken[i]) ;
				if ( nStrPos > -1 )
				{					
					nStrPos += arrToken[i].length + 1;			
					nEndPos = nm.indexOf(" ", nStrPos +1 );		
					if (nEndPos < 0)
						nEndPos = nm.length;
					cdgrupid = nm.substr(nStrPos, nEndPos - nStrPos).trim();		
					break;
				}
			}
		}			
		if ( ! utlf_isNull(cdgrupid) )
		{
			cdgrupid = cdgrupid.replace(")", "");
			lf_getHrcd(hrcdtype, cdgrupid);
		} else
		{
			ds_send.setColumn(0, "cdgrupid", "");
			ds_code_info.clearData();		
		}
	
	} else {
		ds_code_info.clearData();		
	}
}

function btn_insert_onclick(obj:Button,  e:ClickEventInfo)
{
	var clipStr = "";
	var nRow = ds.rowposition;
	var table_name = ds.getColumn(nRow, "table_name"); 
	var owner = ds.getColumn(nRow, "owner"); 
	
	owner = ds_cond.getColumn(0, "owner").toLowerCase();
	table_name = ds_cond.getColumn(0, "table_name").toLowerCase();
	
	var dbasnm    = ds_dbas.getColumn(0, "dbasnm").toLowerCase();
	
	var commentStr = "";
	var comma = "";
	
	if(dbasnm == null || dbasnm == "") {
		dbasnm="";
	} else {
		dbasnm += ".";
	}
	
	dsf_createDs("ds_column_info_temp");
	ds_column_info_temp.clear();
	ds_column_info_temp.copyData(ds_column_info);
	
	var nm , id, rowcount;	
	rowcount = ds_column_info_temp.rowcount;		
		
	clipStr += "INSERT " + "\n";
	clipStr += "  INTO " + owner + "." + table_name + "\n";
	clipStr += "     (" + "\n";
	 
	for(var i = 0; i < rowcount; i++) {
	
		if(i == 0) {
			clipStr += "";
			comma = "  ";
		} else {
			comma = ", ";
		}
		
		nm = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "nm"));
		id = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "id"));

		if(utlf_isNull(nm))
		{
			commentStr = "";
		} else {
			commentStr = "-- " + nm.replace("\n", " ");
		}
		
		id = sRpad(id.toLowerCase(), " ", 20);
		clipStr += "     " + comma + id + commentStr + "\r\n" ;
		
	}
	clipStr += "     )" + "\n";
	clipStr += "VALUES" + "\n";
	clipStr += "     (" + "\n";
	
	for(var i = 0; i < rowcount; i++) {
		if(i == 0) {
			clipStr += "";
			comma = "  ";
		} else {
			comma = ", ";
		}
		id = ds_column_info_temp.getColumn(i, "id")
		id = fConstColumnValue(id);
		id = sRpad(id, " " , 20);
				
		var nm = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "nm")); 
		if (!utlf_isNull(nm))
		{
			nm = nm.replace("\n", " ");
		}
		//clipStr += "     " + comma + id + "      -- " + sRpad(ds_column_info_temp.getColumn(i, "id").toLowerCase(), " ", 15) + " / " + nm  + "\r\n" ;
		clipStr += "     " + comma + id + "      -- " + ds_column_info_temp.getColumn(i, "id").toLowerCase() + "(" + nm  + ")\r\n" ;
		
	}
	
	clipStr += "     )\r\n;";
	system.clearClipboard();

	system.setClipboard("CF_TEXT",clipStr); 
}

function btn_update_onclick(obj:Button,  e:ClickEventInfo)
{
	var clipStr = "";
	var nRow = ds.rowposition;
	var table_name = ds.getColumn(nRow, "table_name"); 
	var owner = ds.getColumn(nRow, "owner"); 
	
		owner = ds_cond.getColumn(0, "owner");
	table_name = ds_cond.getColumn(0, "table_name");
	
	
	var dbasnm    = ds_dbas.getColumn(0, "dbasnm");
	
	var commentStr = "";
	var comma = "";
	var id="";
	var id2= "";
	var pkyn = "N";
	var cnt = 0;
	
	if(dbasnm == null || dbasnm == "") {
		dbasnm="";
	} else {
		dbasnm += ".";
	}
	
	dsf_createDs("ds_column_info_temp");
	ds_column_info_temp.clear();
	ds_column_info_temp.copyData(ds_column_info);
	
	var nm , id, rowcount;	
	rowcount = ds_column_info_temp.rowcount;

	clipStr += "UPDATE " + owner + "." + table_name + "\r\n";
	clipStr += "   SET \r\n";
	
	for(var i = 0; i < rowcount; i++) {
	
		nm = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "nm"));
		id = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "id"));
		
		// PK는 스킵..		
		if (ds_pkcolumn.findRow("id", id) >= 0)
		{			
			continue;		
		}
// 		pkyn = ds_column_info.getColumn(i, "pkyn");
// 		
// 		if(pkyn == "Y") {
// 			continue;
// 		}

		if(cnt == 0) {
			clipStr += " ";
			comma = " ";
		} else {
			comma = ", ";
		}
		
		if( utlf_isNull(nm)) {
			commentStr = "";
		} else {
			commentStr = "-- " + nm.replace("\n", " ");
		}
		
		id  = sRpad(id, " ", 20);
		id2 = ds_column_info_temp.getColumn(i, "id");
		id2 = fConstColumnValue(id2);
				
		id2 = sRpad(id2, " ", 25);
		
		clipStr += "     " + comma + id.toLowerCase() + " = " + id2 + commentStr + "\r\n" ;
		cnt++;
	}

	clipStr += " WHERE 1 = 1\r\n";

	for(var i = 0; i < ds_pkcolumn.rowcount; i++)		
	{		
		id  = sRpad(ds_pkcolumn.getColumn(i, "id").toLowerCase(), " ", 20);
		id2 = ds_pkcolumn.getColumn(i, "id");
	
		id2 = fConstColumnValue(id2);
		
		var nRow = ds_column_info.findRow("id", ds_pkcolumn.getColumn(i, "id"));		
		nm = utlf_transNullToEmpty(ds_column_info_temp.getColumn(nRow, "nm"));
		if( utlf_isNull(nm) ) 
		{
			commentStr = "";
		} else {
			commentStr = "-- " + nm.replace("\n", " ");
		}
				
		clipStr += "   AND " + id + " = " + sRpad(toLower(id2), " ", 20) + commentStr + "\r\n";		
		
	}
	clipStr += ";";
	system.clearClipboard();

	system.setClipboard("CF_TEXT",clipStr); 
}


function fConstColumnValue(id)
{
	var retValue = "";
	switch (id.toUpperCase())
	{
		case "INSTCD":
			retValue = "#%dutplceinstcd#";
			break;
			
		case "FSTRGSTRID":
		case "LASTUPDTRID":
			retValue = "#%userid#";
			break;
			
		case "FSTRGSTDT":
		case "LASTUPDTDT":
			retValue = "systimestamp";
			break;
			
		default:
			retValue= "#" + toLower(id).trim() + "#"				
	}
	return retValue;
}

function btn_delete_onclick(obj:Button,  e:ClickEventInfo)
{
	var clipStr = "";
	var nRow = fds.rowposition;
	var table_name = ds.getColumn(nRow , "table_name").toLowerCase(); 
	var owner = ds.getColumn(nRow , "owner").toLowerCase(); 
	
		owner = ds_cond.getColumn(0, "owner").toLowerCase();
	table_name = ds_cond.getColumn(0, "table_name").toLowerCase();
	
	
	var dbasnm    = ds_dbas.getColumn(0, "dbasnm").toLowerCase();
	
	var commentStr = "";
	var comma = "";
	//var id="";
	var id2= "";
	var pkyn = "N";
	var cnt = 0;
	
	if(dbasnm == null || dbasnm == "") {
		dbasnm="";
	} else {
		dbasnm += ".";
	}
	
	clipStr += "DELETE\r\n" 
	clipStr += "  FROM "+ owner + "." + table_name + "\r\n";
	clipStr += " WHERE 1=1 \r\n";
	
	for(var i = 0; i < ds_pkcolumn.rowcount; i++)		
	{		
		id  = sRpad(ds_pkcolumn.getColumn(i, "id").toLowerCase(), " ", 20);
		id2 = ds_pkcolumn.getColumn(i, "id");
	
		id2 = fConstColumnValue(id2);
				
		clipStr += "   AND " + id + " = " + toLower(id2) + "\r\n";		
	}	
	clipStr += ";";
	
	system.clearClipboard();

	system.setClipboard("CF_TEXT",clipStr); 
}



function btn_merge_onclick(obj:Button,  e:ClickEventInfo)
{
	var clipStr = "";
	var nRow = ds.rowposition;
	var table_name = ds.getColumn(nRow, "table_name"); 
	var owner = ds.getColumn(nRow, "owner"); 
	
	owner = ds_cond.getColumn(0, "owner").toLowerCase();
	table_name = ds_cond.getColumn(0, "table_name").toLowerCase();
	
	var dbasnm    = ds_dbas.getColumn(0, "dbasnm").toLowerCase();
	
	var commentStr = "";
	var comma = "";
	
	if(dbasnm == null || dbasnm == "") {
		dbasnm="";
	} else {
		dbasnm += ".";
	}	
	
	dsf_createDs("ds_column_info_temp");
	ds_column_info_temp.clear();
	ds_column_info_temp.copyData(ds_column_info);

	var nm , id, rowcount, cnt;	
	
	clipStr += " MERGE INTO " + owner + "." + table_name + "\n";
	clipStr += " USING DUAL" + "\n";
	clipStr += "    ON (1 = 1" + "\n";
	for(var i = 0; i < ds_pkcolumn.rowcount; i++)
	{
		id  = sRpad(ds_pkcolumn.getColumn(i, "id").toLowerCase(), " ", 20);
		nm = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "nm"));
		if( utlf_isNull(nm)) {
			commentStr = "";
		} else {
			commentStr = "-- " + nm.replace("\n", " ");
		}
		
		id2 = ds_pkcolumn.getColumn(i, "id");
		id2 = fConstColumnValue(id2);		
		id2 = sRpad(id2, " ", 25);
		clipStr += "   AND " + id + " = " + toLower(id2) + commentStr + "\n";				
	}	
	clipStr += "       )" + "\n";
	clipStr += "  WHEN MATCHED THEN" + "\n";
	clipStr += "UPDATE" + "\n";	
	clipStr += "   SET" + "\n";
	
	rowcount = ds_column_info_temp.rowcount;
	cnt = 0;
	for(var i = 0; i < rowcount; i++)
	{
		nm = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "nm"));
		id = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "id"));
		
		// PK는 스킵..		
		if (ds_pkcolumn.findRow("id", id) >= 0)
		{			
			continue;		
		}	
		if(cnt == 0) {
			clipStr += " ";
			comma = " ";
		} else {
			comma = ", ";
		}
		
		if( utlf_isNull(nm)) {
			commentStr = "";
		} else {
			commentStr = "-- " + nm.replace("\n", " ");
		}
		
		id  = sRpad(id, " ", 20);
		id2 = ds_column_info_temp.getColumn(i, "id");
		id2 = fConstColumnValue(id2);
				
		id2 = sRpad(id2, " ", 25);
		
		clipStr += "     " + comma + id.toLowerCase() + " = " + id2 + commentStr + "\n" ;
		cnt++;		
	}	
	clipStr += "" + "\n";
	clipStr += "  WHEN NOT MATCHED THEN" + "\n";
	clipStr += "INSERT " + "\n";
	clipStr += "     (" + "\n";
	cnt = 0;
	for(var i = 0; i < rowcount; i++) 
	{
	
		if(i == 0) {
			clipStr += "";
			comma = "  ";
		} else {
			comma = ", ";
		}
		
		nm = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "nm"));
		id = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "id"));

		if(utlf_isNull(nm))
		{
			commentStr = "";
		} else {
			commentStr = "-- " + nm.replace("\n", " ");
		}
		
		id = sRpad(id.toLowerCase(), " ", 20);
		clipStr += "     " + comma + id + commentStr + "\r\n" ;
		
	}	
	clipStr += "     )" + "\n";
	clipStr += "VALUES" + "\n";
	clipStr += "     (" + "\n";	
	for(var i = 0; i < rowcount; i++) 
	{
		if(i == 0) {
			clipStr += "";
			comma = "  ";
		} else {
			comma = ", ";
		}
		id = ds_column_info_temp.getColumn(i, "id")
		id = fConstColumnValue(id);
		id = sRpad(id, " " , 20);
				
		var nm = utlf_transNullToEmpty(ds_column_info_temp.getColumn(i, "nm")); 
		if (!utlf_isNull(nm))
		{
			nm = nm.replace("\n", " ");
		}
		clipStr += "     " + comma + id + "      -- " + sRpad(ds_column_info_temp.getColumn(i, "id").toLowerCase(), " ", 15) + " / " + nm  + "\r\n" ;
		
	}	
	clipStr += "     )\n;";
	system.clearClipboard();

	system.setClipboard("CF_TEXT",clipStr); 	
}



function toLower(str) {
	
	var chr = "";
	var tempStr = "";
	
	for(i = 0; i < str.length; i++) {
		chr = str.charAt(i).toLowerCase();
		tempStr += chr;
	}
	
	return tempStr;
}


// 테이블 관련 그리드 클릭 시
function fTblGridOnClick(obj:Grid, e:GridClickEventInfo)
{
    var tmpDs = eval(obj.binddataset)
	
	var owner = tmpDs.getColumn(tmpDs.rowposition, "owner");
	var table_name = tmpDs.getColumn(tmpDs.rowposition, "table_name"); 
	var table_comment = tmpDs.getColumn(tmpDs.rowposition, "comments"); 
	var object_type = tmpDs.getColumn(tmpDs.rowposition, "object_type");
	
	
	ds_cond.setColumn(0, "object_type", tmpDs.getColumn(tmpDs.rowposition, "object_type"));
	
	ds_cond.setColumn(0, "owner",      owner);
	ds_cond.setColumn(0, "table_name", table_name);
	ds_cond.setColumn(0, "table_comment", table_comment);
	ds_cond.setColumn(0, "object_type", object_type);
	
	ds_dependencies.clearData();
	
	fGetdbasnm(table_name) ;
	
	switch (object_type)
	{
		case "TABLE":
		case "VIEW":
			// 컬럼 정보 가져오기
			fGetColumnList(owner, table_name);
			
			ds_column_name.setColumn(0, "column_name", "")	
			ipt_column_name_ontextchanged(Tab01.tabpage1.ipt_column_name, null);
						
			if (obj.name != "grd_HistTable")
			{
				fSetHistoryTable(ds, ds.rowposition);			
			}
			
			Tab01.tabindex = 0;
			break;
	
		case "FUNCTION":
		case "PROCEDURE":

			fGetViewSource(owner, table_name, object_type);
			Tab01.tabindex = 1;
			break;
			
		case "TRIGGER":
			fGetViewTrigger(owner, table_name);
			Tab01.tabindex = 1;
			break;
			
	}	 		 	
}

function fGetdbasnm(table_name)
{
	var dbasnm = table_name.substr(table_name.length - 4).replace("_", "");
	switch (dbasnm)
	{
		// 오라클 예약어
		case "ADD":
		case "ALL":
		case "AND":
		case "ANY":
		case "ASC":
		case "FOR":
		case "RAW":
		case "ROW":
		case "SET":
		case "UID":			
			dbasnm += "_";
		break;		
	}		
	dsf_makeValue(ds_dbas, "dbasnm", "string", dbasnm);
}

function fSaveFavTable(dsname , fileName, bSort)
{	
	Tab00.tabpage1.grd_favTable.updateToDataset();
	Tab00.tabpage1.Combo00.updateToDataset();
	
	// 정렬한 상태에서 저장을 하니까 제대로 저장이 안되어서 DataSet을 복사해서 다시 저장을 해야 함. 이거 해결방법이 있을까나?	
	if( bSort)
	{		
		dsf_createDs("ds_copy_tmp");
		dsf_createDs("ds_copy_tmp1");
		
		ds_copy_tmp.clear();
		
		var ds = eval(dsname);
				
		ds_copy_tmp1.copyData(ds);
	
		var rowcount = ds_copy_tmp1.rowcount;
		var colcount = ds_copy_tmp1.getColCount();
		
		for(var j = 0; j < colcount ; j++)
		{
			var col = ds_copy_tmp1.getColumnInfo(j);
			ds_copy_tmp.addColumn(col.name, "string");
		}

		for (var i = 0; i < rowcount ; i++)
		{
			ds_copy_tmp.addRow();
			for(var j = 0; j < colcount ; j++)
			{
				ds_copy_tmp.setColumn(i, j,ds_copy_tmp1.getColumn(i, j));				
			}		
		}	
		ds_copy_tmp1.copyData(ds_copy_tmp);
		
		var vfile = new VirtualFile(fileName, VirtualFile.openWrite); 
		vfile.write(ds_copy_tmp1.saveXML());
		vfile.close();
	}	
	else
	{
		var vfile = new VirtualFile(fileName, VirtualFile.openWrite); 
		
		//trace("save filename : " + fileName);
		var ds = eval(dsname);		
		vfile.write(ds.saveXML());
		vfile.close();
	}
}

function btn_load_onclick(obj:Button,  e:ClickEventInfo)
{
	fGetDataSet ("fafds", "./fafds.xml");
}


function fGetDataSet(dsname, datafile_name)
{
	var vfile = new VirtualFile(); 
	
	var bOpened = vfile.open(datafile_name, VirtualFile.openRead);
	
	if (bOpened) 
	{
		if (vfile.getFileSize() > 0)
		{					
			if ( utlf_isNull(this.objects[dsname]) )
			{
				dsf_createDs(dsname);
			}
			
			var ds = eval(dsname);			
			ds.loadXML( vfile.read() );
			
			if (datafile_name == "./fafds.xml")
			{		
				// 컬럼정보가 변경되어서
				if ( utlf_isNull(ds.getColumnInfo("object_type")) )
				{
					ds.addColumn("object_type", "String");
					
					for(var i = 0; i < pDs.rowcount; i++)
					{
						ds.setColumn(i, "object_type", ds.getColumn(i, "table_type"));
						fSaveFavTable("fafds", "./fafds.xml", false);
					}
				}
			}
		}
	}
	vfile.close();
}

function Combo00_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	if ( ds_dbas.getColumn(0, "searchColumn") == "Y" )	
		return ;
		
	var table_name = ds_table_name.getColumn(0, "table_name");		
	var owner = utlf_transNullToEmpty( ds_dbUsers.getColumn(cbOwner.index, "owner") );
	
	fGetFilteredData(ds, owner, table_name, "", "");
}


function fGetFilteredData(ds, owner, table_name, object_type, domain)
{
	var filter = "";
	
	table_name = utlf_trim(table_name);
	
	filter += "(" ;
	filter += "    (String(owner).indexOf('" + owner + "') > -1 || '" + owner + "' == '') ";
	filter += " && (String(comments).toUpperCase().indexOf('" + table_name.toUpperCase() + "') > -1 || String(table_name).toUpperCase().indexOf('" + table_name.toUpperCase() + "') > -1 || '" + table_name + "' == '')";
	filter += " && (String(object_type) == '" + object_type + "' || '" + object_type + "' == '')";
	filter += " && (String(domain) == '" + domain+ "' || '" + domain + "' == '')";
	filter += ")";
	
	//trace(filter);
		ds.filter( filter );
		
		return ;
	
	

	if ( !utlf_isNull(owner))
	{
		if (  !utlf_isNull(table_name) )
		{
			filter = filter + "String(owner).indexOf('" + owner + "') > -1 &&";
			filter = filter + "(String(comments).toUpperCase().indexOf('" + table_name.toUpperCase() + "') > -1 || String(table_name).toUpperCase().indexOf('" + table_name.toUpperCase() + "') > -1)";
		}
		else
		{		
			filter = filter + "String(owner).indexOf('" + owner + "') > -1";			
		}
	}
	else
	{	
		if (  !utlf_isNull(table_name)  )
		{
			//filter = filter + "String(owner).indexOf('" + owner + "') > -1 &&" ;
			//filter = filter + "(String(comments.toUpperCase()).indexOf('" + table_name.toUpperCase() + "') > -1 || String(table_name.toUpperCase()).indexOf('" + table_name.toUpperCase() + "') > -1)";
			//filter = filter + "(String(comments).toUpperCase().indexOf('" + table_name.toUpperCase() + "') > -1 || String(table_name).toUpperCase().indexOf('" + table_name.toUpperCase() + "') > -1)";
			filter = filter + "(String(comments).toUpperCase().indexOf('" + table_name.toUpperCase() + "') > -1 || String(table_name).indexOf('" + table_name + "') > -1)";
			//filter = filter + "(String(table_name).indexOf('" + table_name + "') > -1)";
			//filter = filter + "(String(comments).toUpperCase().indexOf('" + table_name.toUpperCase() + "') > -1)";
			//filter = filter + "(String(comments).toUpperCase().indexOf('" + table_name.toUpperCase() + "') > -1 || String(table_name).indexOf('" + table_name + "') > -1)";
			
			filter = "((String(comments).toUpperCase().indexOf('" + table_name.toUpperCase() + "') > -1 || String(table_name).indexOf('" + table_name + "') > -1) && ( String(object_type) == '" + object_type + "' || '" + object_type + "' == ''))";
			
			trace(filter);
		}
	}
	
	if ( utlf_transNullToEmpty(domain) != "" )
	{
		if ( filter != "" )
			filter += " && ";
					
		filter = filter + " String(domain).indexOf('" + domain + "') > -1 " ;
	}
		
	//trace( filter);
	ds.filter( filter );	
	
//	trace ("filter : " + filter);
}

function SMSMP09204_oninit(obj:Form, e:InitEventInfo)
{
	frmf_initForm(obj);	
}

function SMSMP09204_onactivate(obj:Form, e:ActivateEventInfo)
{
	ipt_table_name.setFocus();
	
	fGetDataSet ("fafds", "./fafds.xml");
	
}
	
function fGridCopyClipboard(obj:Grid, e:KeyEventInfo)
{
	var bPushed = e.ctrlKey;
    var clipStr = "";
    var dbasnm    = ds_dbas.getColumn(0, "dbasnm").toLowerCase();
    var commentyn = ds_dbas.getColumn(0, "commentyn");
    
    var dsTmp = eval(obj.binddataset);
    var row = obj.currentrow;
    
    
    var owner = dsTmp.getColumn(row, "owner").toLowerCase();
    var table_name = dsTmp.getColumn(row, "table_name").toLowerCase();
                   
    if (e.keycode == 67 && bPushed == true )		// ctrl + c
    {
		table_name += " " +  dbasnm;
        table_name = sRpad(table_name, " ", 20) ;

        clipStr = owner + "." +  table_name;

        if(commentyn == "Y") {
            commentStr = "-- " + utlf_transNullToEmpty(dsTmp.getColumn(row, "comments"));
            clipStr += commentStr;
        }
        //clipStr += "\r\n" ;

        system.clearClipboard();
        system.setClipboard("CF_TEXT",clipStr);
    }  
}

function caption01_onclick(obj:Static,  e:ClickEventInfo)
{	
	if (e.ctrlKey)
	{
		fPopupNewWindow("SMSMP09205");
//frmf_open("SMSMP09205", "SMSMP09205", null, "", 0, 200, 200, "", "", "", "", "", "M");	
// 		var maxformnum = 0;
// 		for(var i = 0; i < application.popupframes.length; i ++)
// 		{
// 			var frm =  application.popupframes[i];
// 			
// 			if (frm.name.substr(0, 10) == "SMSMP09205")
// 			{
// 				var tmp = utlf_transNullToEmpty(frm.name.substr(10, 2))
// 				if (utlf_isNull(tmp)) {
// 					maxformnum = 1;
// 				} else {				
// 					maxformnum = toNumber(tmp);
// 					maxformnum++;				
// 				}			
// 			}	
// 		}
// 		var scrid = "SMSMP09205" + maxformnum;	
// 		frmf_open(scrid, "SMSMP09205", "", "", 0, 500, 500, "", "", "", "", "", "M");
	}
}

function caption6_onclick(obj:Static,  e:ClickEventInfo)
{
	if (e.ctrlKey)
	{
		frmf_open("SMSMP09206", "SMSMP09206", null, "", 0, 200, 200, "", "", "", "", "", "M");		
	}
}


// 새 창 띄우기
function fPopupNewWindow(srcid)
{
	var sgvname = srcid + "count";
	var maxformnum = 0;
	if ( utlf_isNull (sysf_getGlobalVariable(sgvname)) ) 
	{
		maxformnum = 1;
	}
	else
	{
		maxformnum = parseInt(sysf_getGlobalVariable(sgvname));
	}	
	var sNewscrid = srcid  + "_" + maxformnum;	
	
	frmf_open(sNewscrid, srcid, "", "", 0, 500, 500, "", "", "", "", "", "M");
	
	sysf_setGlobalVariable(sgvname, maxformnum + 1);
}

function caption7_onclick(obj:Static,  e:ClickEventInfo)
{
	if (e.ctrlKey)
	{
		fPopupNewWindow("SMSMP09204");
	}	
	/*frmf_open("SMSMP09206", "SMSMP09206", null, "", 0, 200, 200, "", "", "", "", "", "M");	*/
	
// 	var maxformnum = 0;
// 	for(var i = 0; i < application.popupframes.length; i ++)
// 	{
// 		var frm =  application.popupframes[i];
// 		
// 		if (frm.name.substr(0, 10) == "SMSMP09204")
// 		{
// 			var tmp = utlf_transNullToEmpty(frm.name.substr(10, 2))
// 			if (utlf_isNull(tmp)) {
// 				maxformnum = 1;
// 			} else {				
// 				maxformnum = toNumber(tmp);
// 				maxformnum++;				
// 			}			
// 		}	
// 	}
// 	var scrid = "SMSMP09204" + maxformnum;	
// 	frmf_open(scrid, "SMSMP09204", "", "", 0, 500, 500, "", "", "", "", "", "M");	
}

function lf_searchTableInfoListByColumn()
{
	var column_name = ds_table_name.getColumn(0, "table_name");
	var owner = utlf_transNullToEmpty( ds_dbUsers.getColumn(cbOwner.index, "owner") );
		
	trace ( "owner : " +owner + " , " + column_name  );
	
	ds_cond.setColumn(0, "owner", owner);
	ds_cond.setColumn(0, "column_name", column_name);
	
	var oParam = {};
	oParam.id          = "TRSMP09210";
	oParam.service     = "testapp.TestMngt";
	oParam.method      = "reqGetTableInfoList";
	oParam.inds        = "req=ds_cond";
	oParam.outds       = "ds=info";	
	oParam.async	   = true;
	oParam.callback    = "cf_TRADB09204_1";		
					
	tranf_submit(oParam);
}


function cf_TRADB09204_1(sSvcId, nErrorCode, sErrorMsg) 
{		
	dsf_makeValue(ds,"domain"		,"string","");
	ds.filter("");		
	Grid00.updateToDataset();	
}

function CheckBox02_onclick(obj:CheckBox,  e:ClickEventInfo)
{
	trace( ds_dbas.getColumn(0, "searchColumn"));
	
	if ( ds_dbas.getColumn(0, "searchColumn") == "N" )
	{
		dsf_copyDs(ds, dsback);
		ds.filter("");		
	}
	ipt_table_name.setFocus();
}

function Tab00_tabpage1_Button00_onclick(obj:Button,  e:ClickEventInfo)
{
	//var nRow = fafds.rowposition;
	var strDomain = utlf_transNullToEmpty(ds_cond.getColumn(0, "domain"));
		
// 	fafds.setColumn(nRow , "domain", strDomain);
// 	fSaveFavTable(fafds, "./fafds.xml");
	
	var grd = eval("Tab00.tabpage1.grd_favTable");
		
	for(var i = 0; i <= grd.selectstartrow.length-1; i++) 
	{
		for(var j = grd.selectstartrow[i]; j < grd.selectendrow[i]+1; j++) 
		{
			fafds.setColumn(j, "domain", strDomain);
		}		
	}	
	fSaveFavTable("fafds", "./fafds.xml", false);
}

function Tab00_tabpage1_PopupDiv00_Button01_onclick(obj:Button,  e:ClickEventInfo)
{
	var strDomain = ds_cond.getColumn(0, "domain");
	
	var nFindRow = ds_domain.findRow("domain", strDomain);
	
	if ( nFindRow < 0 )
	{
		var nRow = ds_domain.addRow();
		ds_domain.setColumn(nRow, "domain", strDomain);				
		
		fSaveFavTable("ds_domain", "./ds_domain.xml", false);
	}
	Tab00.tabpage1.Div00.visible = false;
}

function Tab00_tabpage1_Combo00_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	// 필터링 하기
	if (ds_cond.getColumn(0, "inputYn") == "N")
	{

		var table_name = ds_table_name.getColumn(0, "table_name");
		var owner = utlf_transNullToEmpty( ds_dbUsers.getColumn(cbOwner.index, "owner") );
		var strDomain = utlf_transNullToEmpty(ds_cond.getColumn(0 ,"domain"));
		
		fGetFilteredData(fafds, owner, table_name, "", strDomain);
	}
}

function Tab00_tabpage1_CheckBox00_onclick(obj:CheckBox,  e:ClickEventInfo)
{
	if (ds_cond.getColumn(0, "inputYn") == "Y")
	{
		Tab00.tabpage1.Button00.visible=true;
		Tab00.tabpage1.grd_favTable.selecttype = "multiarea";
	}
	else
	{
		Tab00.tabpage1.Button00.visible=false;
		Tab00.tabpage1.grd_favTable.selecttype = "row";
		ds_cond.setColumn(0, "domain","");
	}
	
}

function Tab00_tabpage1_Div00_Button00_onclick(obj:Button,  e:ClickEventInfo)
{
	Tab00.tabpage1.Div00.visible = false;
}

function lf_getHrcd(hrcdtype, cdgrupid)
{
	
	ds_send.setColumn(0, "hrcdtype", hrcdtype);
	ds_send.setColumn(0, "cdgrupid", cdgrupid);
	var oParam = {};
	oParam.id          = "TRSMP09210";
	oParam.service     = "testapp.TestMngt";
	oParam.method      = "reqGetHrcd";
	oParam.inds        = "req=ds_send";
	oParam.outds       = "ds_code_info=info";	
	oParam.async	   = true;
	oParam.callback    = "cf_TRADB09204";
		
	tranf_submit(oParam);
}



function lf_getColumnlist(owner, columnname)
{
	var rowcount = 10000;
	var index = 0;
	
	dsf_createDs("ds_tmp_columnlist");
	
	ds_send.setColumn(0, "columnname", columnname);
	ds_send.setColumn(0, "owner", owner);
	
	var oParam = {};
		oParam.id          = "TRSMP09212";
		oParam.service     = "testapp.TestMngt";
		oParam.method      = "reqGetColumnlist";
		oParam.inds        = "req=ds_send";
		oParam.outds       = "ds_columnlist=info";	
		oParam.async	   = false;
		oParam.callback    = "";
		tranf_submit(oParam);
	return;
	
// 	var nRowcount = 0;
// 	do 
// 	{		
// 		ds_send.setColumn(0, "strrownum", (index * rowcount) + 1);	
// 		index++;
// 		ds_send.setColumn(0, "endrownum", (rowcount * index));
// 				
// 		var oParam = {};
// 		oParam.id          = "TRSMP09212";
// 		oParam.service     = "testapp.TestMngt";
// 		oParam.method      = "reqGetColumnlist";
// 		oParam.inds        = "req=ds_send";
// 		oParam.outds       = "ds_tmp_columnlist=info";	
// 		oParam.async	   = false;
// 		oParam.callback    = "";
// 		tranf_submit(oParam);
// 		
// 		nRowcount = ds_tmp_columnlist.rowcount;
// 		if (nRowcount > 0)
// 		{
// 			if (ds_columnlist.getCountNF() == 0)
// 			{
// 				ds_columnlist.copyData(ds_tmp_columnlist);
// 				
// 				trace("ds_columnlist.copyData");
// 				
// 			}
// 			else
// 			{
// 				ds_columnlist.appendData(ds_tmp_columnlist);
// 				trace("ds_columnlist.appendData");
// 			}
// 		}
// 		else
// 		{
// 			trace("break ?");
// 			break;
// 		}
// 		
// // 		if (index >= 10)
// // 		{
// // 			break;
// // 		}
// 		trace("index : " + index + ", nRowcount : " + nRowcount + " , ds_tmp_columnlist.rowcount : " + ds_tmp_columnlist.rowcount);
// 		
// 	}while (nRowcount > 0);	
// 	
// 	trace("ds_columnlist.getCountNF()  : " + ds_columnlist.getCountNF() );
}

function Div00_Button00_onclick(obj:Button,  e:ClickEventInfo)
{
	lf_getHrcd();
}


function cbDbType_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	obj.updateToDataset();
	var oParam = {};
	oParam.id          = "TRSMP09210";
	oParam.service     = "testapp.TestMngt";
	oParam.method      = "reqGetTableInfoList";
	oParam.inds        = "req=ds_cond";
	oParam.outds       = "ds=info";	
	oParam.async	   = true;
	oParam.callback    = "cf_TRADB09204";
		
	tranf_submit(oParam);		
}


function fSetPkColumn()   
{
	ds_pkcolumn.clearData();
	for (var i = 0; i < ds_index_info.rowcount; i++)
	{
		var indexname = ds_index_info.getColumn(i, "index_type");
				
		if (indexname  == "P") 
		{
			var indexconst = ds_index_info.getColumn(i, "index_const");					
			var arrIndexColumn = indexconst.split(",");				
					
			for (var j = 0; j < arrIndexColumn.length; j++)
			{			
				var row = ds_pkcolumn.addRow();
				ds_pkcolumn.setColumn(row, "id", arrIndexColumn[j].trim());
				
				var nRow = ds_column_info.findRow("id" , arrIndexColumn[j].trim());
				if (nRow >= 0)
					ds_column_info.setColumn(nRow, "pkyn", "Y");
			}
						
			break;
		}		
	}
}
function CheckBox03_onclick(obj:CheckBox,  e:ClickEventInfo)
{
	obj.updateToDataset();
	
	if (ds_dbas.getColumn(0, "searchColumnDisplayType") == "N")
	{		
		ipt_column_name_ontextchanged(Tab01.tabpage1.ipt_column_name, null);
		
		fnSetSearchColumnDisplayType("");
	}
	else
	{
		ds_column_info.filter("");
		fnSetSearchColumnDisplayType(ds_column_name.getColumn(0, "column_name"));
	}
}

function Button00_onclick(obj:Button,  e:ClickEventInfo)
{
trace(ds.rowcount);
	dsf_createDs("tmpds");
	
	tmpds.copyData(ds);
	tmpds.appendData(ds);
	tmpds.appendData(ds);
	tmpds.appendData(ds);
	tmpds.appendData(ds);
	tmpds.appendData(ds);
	tmpds.appendData(ds);
	
	
	ds.copyData(tmpds);
	
	trace(ds.rowcount);	
}


// 테이블 검색
function fSearchTableList(obj)
{
	obj.updateToDataset();
	
	if ( ds_dbas.getColumn(0, "searchColumn") == "Y" )	
		return ;
	
	Tab01.tabpage1.ipt_column_name.value = "";
		
	var table_name = ds_table_name.getColumn(0, "table_name");
	var object_type = utlf_transNullToEmpty(ds_table_name.getColumn(0, "object_type"));
		
	var owner = utlf_transNullToEmpty( ds_dbUsers.getColumn(cbOwner.index, "owner") );	
	if ( ! utlf_isNull(table_name) )
	{
		if ( table_name.indexOf(".") >= 0 )
		{
			var objArr = table_name.split(".");
			ds_table_name.setColumn(0, "table_name", objArr[1]);
			
			owner = objArr[0];
			table_name = objArr[1];
		}
	}
	
	fGetFilteredData(ds, owner, table_name, object_type, "");
			
	var strDomain = utlf_transNullToEmpty(ds_cond.getColumn(0 ,"domain"));
	fGetFilteredData(fafds, owner, table_name, object_type, strDomain);
	
	if (ds.rowcount == 1)
	{
		ds.rowposition = 0;
		
		fTblGridOnClick(Grid00, null);
		//Grid00_oncellclick(null,null);
	}			
}

function Div01_Button00_onclick(obj:Button,  e:ClickEventInfo)
{	
// 	var oParam = {};
// 	oParam.id          = "TRSMP09210";
// 	oParam.service     = "testapp.TestMngt";
// 	oParam.method      = "reqGetSolr";
// 	oParam.inds        = "req=ds_test";
// 	oParam.outds       = "ds_test_grd=info";
// 	oParam.async       = false;
// 		
// 	tranf_submit(oParam);	

	dsf_makeValue(ds_test, "num", "string", "10");	
	
	var oParam = {};
	oParam.id          = "TRSMP09210";
	oParam.service     = "testapp.TestMngt";
	oParam.method      = "reqGetSPRet";	
	oParam.inds        = "req=ds_test";
	oParam.outds       = "ds_test_grd=info";
	oParam.async       = false;
		
	tranf_submit(oParam);	
}

function Div00_Button01_onclick(obj:Button,  e:ClickEventInfo)
{
	dsf_createDs("ds_tmp_domain");
	ds_tmp_domain.addColumn("domain", "string");
	
	for (var i = 0; i < ds_domain.rowcount; i++)
	{
		ds_tmp_domain.addRow();
		ds_tmp_domain.setColumn(i, "domain", ds_domain.getColumn(i, "domain"));
	}
	ds_domain.copyData(ds_tmp_domain);
	
	fSaveFavTable("ds_domain", "./ds_domain.xml", false);
}

function Grid02_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	var columnlist = ds_index_info.getColumn(ds_index_info.rowposition, "index_const");
	var arrCol = columnlist.split(",");
	
	
	if (ds_dbas.getColumn(0, "searchindexcolumn") == "Y")
	{
		if (! utlf_isNull(columnlist) )
		{
			if (ds_dbas.getColumn(0, "searchColumnDisplayType") == "N")
			{
				var filterstr = "1 == 0 ";
				for (var i = 0; i < arrCol.length; i++)
				{
					filterstr += " || (String(id) == '"  + arrCol[i].trim() + "' )";
				}					
				ds_column_info.filter(filterstr);
			}
			else
			{
				var sExpr = "EXPR( (1 == 0 ";
				for (var i = 0; i < arrCol.length; i++)
				{
					sExpr += " || (String(id) == '"  + arrCol[i].trim() + "' )";
				}
				sExpr += ") ? 'red' : '')";
			
				for (var i = 0; i < 2; i++)
				{
					Tab01.tabpage1.Grid01.setCellProperty("Body", i, "color", sExpr);
					Tab01.tabpage1.Grid01.setCellProperty("Body", i, "color2", sExpr);
					Tab01.tabpage1.Grid01.setCellProperty("Body", i, "selectcolor", sExpr);			
				}	
			}
		}	
		else
		{
			
		}	
	}
}

function Grid01_onnodataareadblclick(obj:Grid, e:EventInfo)
{
	ds_column_info.filter("");	
}

/////////////////////// Keyboard Events
function fGridKeyDownEvents(obj:Grid, e:KeyEventInfo)
{
	var row = obj.currentrow;	
	var tmpDs = eval(obj.binddataset);
	
	switch (e.keycode)
	{
		case 67:		// C
			if (e.ctrlKey)
			{
				fGridCopyClipboard(obj, e);
			}
			break;
		
		case 112:		// F1			
			
			var table_name = utlf_transNullToEmpty(tmpDs.getColumn(row, "table_name"));
			
			if ( !utlf_isNull(table_name) )
			{
				//var findRowIndex = fafds.findRowExpr("table_name == '" + table_name + "' && domain == '" + domain + "'");
				var findRowIndex = fafds.findRow("table_name", table_name);
				if ( findRowIndex == -1 )
				{
					fafds.insertRow(0);
					fafds.copyRow(0, tmpDs, row);
				}
				else
				{
					fafds.deleteRow(findRowIndex);
				}				
			}
			else
			{
				fafds.deleteRow(row);
			}
			
			fSaveFavTable("fafds", "./fafds.xml", false);
			break;
			
		case 119:	// F8 저장
			fSaveFavTable("fafds", "./fafds.xml");
			break;
			
// 		case 115:		// F4						
// 			var owner = tmpDs.getColumn(row, "owner");
// 			var table_name = tmpDs.getColumn(row, "table_name");
// 			var objType = tmpDs.getColumn(row, "object_type");
// 
// 			switch (objType)
// 			{
// 				case "VIEW":
// 				case "FUNCTION":				
// 					fGetViewSource(owner, table_name, objType);		
// 					break;			
// 				default:
// 					break;
// 			}			
// 			break;
			
		case 123:	// F12 Clear		
			if (obj.name == "grd_HistTable") // Histroy Table
			{
				tmpDs.clearData();
			}
			break;			
		
		default:
			break;
	}			
}

function Div02_Edit00_onkeydown(obj:Edit, e:KeyEventInfo)
{
	if (e.keycode == 13) // Enter
	{
		obj.updateToDataset();
		var hrcdtype = ds_send.getColumn(0, "hrcdtype");
		var cdgrupid = ds_send.getColumn(0, "cdgrupid");
		lf_getHrcd(hrcdtype, cdgrupid);
	}
}


//ctrl+c 클립보드 복사
function Grid01_onkeydown(obj:Grid, e:KeyEventInfo)
{
	var bPushed = e.ctrlKey;
	var clipStr = "";
	
	var dbasnm    = ds_dbas.getColumn(0, "dbasnm").toLowerCase();
	var commentyn = ds_dbas.getColumn(0, "commentyn");
	
	var commentStr = "";
	
	if(dbasnm == null || dbasnm == "") {
		dbasnm="";
	} else {
		dbasnm += ".";
	}
	
	if(e.keycode == 67 && bPushed == true) 
	{		// Ctrl + c		
		if (e.shiftKey)
		{
			for(var i = 0; i <= obj.selectstartrow.length-1; i++) {
				for(var j = obj.selectstartrow[i]; j < obj.selectendrow[i]+1; j++) 
				{
					if ( j < 0) 
					{
						j = ds_column_info.rowposition;
					}
				
					if(commentyn == "Y") 
					{
						commentStr = "-- " + utlf_transNullToEmpty( ds_column_info.getColumn(j, "nm"));										
						clipStr += ", " + dbasnm + sRpad(ds_column_info.getColumn(j, "id"), " ", 20).toLowerCase() + commentStr + "\n" ;
					} else {
						//clipStr += ", " + dbasnm + ds_column_info.getColumn(j, "id") + "\r\n" ;
						
						clipStr += " " + ds_column_info.getColumn(j, "id") + "\n" ;						
					}				
				}
			}
			if (!utlf_isNull(clipStr)) {
				clipStr = clipStr.substr(0, clipStr.length - 1);
				system.clearClipboard();
				system.setClipboard("CF_TEXT",clipStr); 
			}
		}
		else
		{
			for(var i = 0; i <= obj.selectstartrow.length-1; i++) {
				for(var j = obj.selectstartrow[i]; j < obj.selectendrow[i]+1; j++)
				{
					commentStr = "";
					for(var k = obj.selectstartcol[i]; k < obj.selectendcol[i]+1; k++) 
					{
						var col = obj.getCellProperty("body", k, "text");
						col = col.replace("bind:", "");
						
	//trace("col : " + col);					
						
						commentStr += "" + utlf_transNullToEmpty( ds_column_info.getColumn(j, col) ) + "\t" ;
					}
					if ( !utlf_isNull(commentStr))
					{
						commentStr = commentStr.substr(0, commentStr.length - 1);
					}
					
					clipStr += "" + commentStr + "\n" ;
				}
			}			
			if (!utlf_isNull(clipStr)) {
				clipStr = clipStr.substr(0, clipStr.length - 1);
				system.clearClipboard();
				system.setClipboard("CF_TEXT",clipStr); 
			}
		}

	} else if (e.keycode == 114) // F3
	{
	
// 	trace("obj.selectstartrow.length :" +obj.selectstartrow.length);
// 	trace(			obj.selectstartrow);
// 	trace(			obj.selectendrow);
		for(var i = 0; i <= obj.selectstartrow.length-1; i++) {
			for(var j = obj.selectstartrow[i]; j < obj.selectendrow[i]+1; j++) 
			{
				if ( j < 0) 
				{
					j = ds_column_info.rowposition;
				}
			
				if(commentyn == "Y") 
				{
					commentStr = "-- " + utlf_transNullToEmpty( ds_column_info.getColumn(j, "nm"));										
					clipStr += ", " + dbasnm + sRpad(ds_column_info.getColumn(j, "id"), " ", 20).toLowerCase() + commentStr + "\r\n" ;
				} else {
					//clipStr += ", " + dbasnm + ds_column_info.getColumn(j, "id") + "\r\n" ;
					clipStr += " " + ds_column_info.getColumn(j, "id") + "\r\n" ;
				}				
			}
		}
		if (!utlf_isNull(clipStr)) {
			system.clearClipboard();
			system.setClipboard("CF_TEXT",clipStr); 
		}
	} else if(e.keycode == 115)	// F4
	{
		//ORA-02089: 종속 세션에서는 COMMIT이 허용되지 않습니다. 에러 처리 방법 확인 필요.
		//return ;
		// 변경된 코멘트 저장 하기
		if(lf_messageBox("코멘트를 저장하시겠습니까?") == 6) {
			trace("코멘트 저장 시작");
			var updtdata = grdf_getGridUpdateData(Tab01.tabpage1.Grid01, "all");
			
			if (!utlf_isNull(updtdata))
			{				
				var owner     = ds_cond.getColumn(0, "owner");
				var tablename = ds_cond.getColumn(0, "table_name");
				
				
				for(var i = 0; i < updtdata.rowcount; i++)
				{
					var columnid = updtdata.getColumn(i , "id");
					var comment  = updtdata.getColumn(i , "nm");
						comment = comment.replace("'", "''");					
				
					ds_columcomment.clearData();
					var nRow = ds_columcomment.addRow();
					ds_columcomment.setColumn(nRow , "owner", owner);
					ds_columcomment.setColumn(nRow , "tablename", tablename);
					ds_columcomment.setColumn(nRow , "columnid", columnid);
					ds_columcomment.setColumn(nRow , "comment", comment);					
									
					var oParam = {};
					oParam.id          = "TRSMP09212_1";
					oParam.service     = "testapp.TestMngt";
					oParam.method      = "reqSetColumnComment";
					oParam.inds        = "req=ds_columcomment";
					oParam.outds       = "";
					oParam.async       = false;					
					tranf_submit(oParam);
				}				
			}			
		}
	}
}
function Tab00_tabpage1_Combo00_onkeydown(obj:Combo, e:KeyEventInfo)
{	

	switch ( e.keycode )
	{
		// ESC
		case 27:
			ds_cond.setColumn(0,"domain","");
			// 필터링 하기
			if (ds_cond.getColumn(0, "inputYn") == "N")
			{
				var table_name = ds_table_name.getColumn(0, "table_name");
				var owner = utlf_transNullToEmpty( ds_dbUsers.getColumn(cbOwner.index, "owner") );
				var strDomain = utlf_transNullToEmpty(ds_cond.getColumn(0 ,"domain"));
				
				fGetFilteredData(fafds, owner, table_name, strDomain);
			}
			break;
		case 115:	// F4 Sort
			if(lf_messageBox("정렬을 하시겠습니까?") == 6)
			 {
				ds_domain.keystring ="S:+domain";
// 				ds_domain.updateSortGroup("S:+domain");			
// 									
				fSaveFavTable("ds_domain", "./ds_domain.xml", true);			
			}
			
			break;
		case 117:	// F6 Add
			Tab00.tabpage1.Div00.visible = true;
			Tab00.tabpage1.Div00.Edit00.setFocus();
			break;
			
		case 118:  // F7 , Delete		
			if(lf_messageBox("삭제를 하시겠습니까?") == 6) 
			{
				var strDomain = ds_cond.getColumn(0, "domain");
				var nRow = ds_domain.findRow("domain", strDomain);
				
				if ( nRow > 0 )
				{	
					ds_domain.deleteRow(nRow);
					fafds.filter("");
					for(var i = 0; i < fafds.rowcount; i++)
					{
						if ( strDomain == fafds.getColumn(i, "domain") )
						{
							fafds.setColumn(i, "domain", "");
						}
					}
					fSaveFavTable("ds_domain", "./ds_domain.xml", false);
				}
			}
			break;	
	}
}

function ipt_table_name_onkeydown(obj:Edit, e:KeyEventInfo)
{
	switch (e.keycode)
	{
		//case "13":
		case "116":	//F5
			if ( ds_dbas.getColumn(0, "searchColumn") == "Y" )
			{
				lf_searchTableInfoListByColumn();	
			}				
			break;
			
		case "13":	// Enter
			fSearchTableList(obj);	
			break;
			
		case "40":		// arrow down
			if (fafds.rowcount > 0)
			{			
				Tab00.tabpage1.grd_favTable.setCellPos(1);
				fafds.rowposition = 0;
				Tab00.tabpage1.grd_favTable.setFocus();
			}
			else if (ds.rowcount > 0 )
			{
				Grid00.setCellPos(1);
				ds.rowposition = 0;
				Grid00.setFocus();
			}
		default:
			obj.updateToDataset();
			break;
	}
}

function SMSMP09204_onkeydown(obj:Form, e:KeyEventInfo)
{

//trace(e.keycode);
	switch (e.keycode)
	{	
		case 48 + 1:	// 1
			if(e.ctrlKey) Tab01.tabindex = 0;
			break;
		case 48 + 2:	// 2
			if(e.ctrlKey) Tab01.tabindex = 1;
			break;
		case 48 + 3:	// 3
			if(e.ctrlKey) Tab01.tabindex = 2;
			break;
			
		case 48 + 4:	// 4
			if(e.ctrlKey) divScript.visible = (divScript.visible ? false : true);	
			break;
			
		case 27:		// Escape
			ipt_table_name.setFocus();
			Grid00.binddataset = ds;
			break;

		case 112: 	//F1
			if (e.ctrlKey)
			{			
				/// 도움말
				fPopupHotkey();			
			}
			break;
		case 120:	//F9
			divRepSql.move(146, 56);
			
			if (divRepSql.visible)
			{
				divRepSql.visible = false;
				ipt_table_name.setFocus();
			}
			else
			{
				divRepSql.visible = true;
				divRepSql.TextArea00.setFocus();
			}
			break;
		case 81:	//Q
			if (e.ctrlKey)
			{
				Tab01.tabpage1.ipt_column_name.setFocus();
			}
			break;
			
		case 87:	/// W
			if (e.ctrlKey)
			{
				var column_name = utlf_transNullToEmpty(ds_column_name.getColumn(0, "column_name"));
				var startRow = ds_column_info.rowposition;
								
				if ( ds_column_info.rowposition >= ds_column_info.rowcount )
					startRow = 1;
				else
					startRow = ds_column_info.rowposition + 1;
							
				var nFindRow = ds_column_info.findRowExpr("id.toString().toUpperCase().indexOf('" + column_name + "') >= 0 || nm.toString().toUpperCase().indexOf('" + column_name + "') >= 0 ", startRow);
				
				trace("nFindRow : " + nFindRow + ", column_name : " + column_name );
				if (nFindRow >= 0)
				{
					Tab01.tabpage1.Grid01.selecttype = "row";					
					ds_column_info.rowposition = nFindRow ;			
					//Grid01.selecttype = "multiarea";
				}					
				else
				{
					ds_column_info.rowposition = 0;
				}
			}
		case 69:		//E
			if(e.ctrlKey)
			{
				var selectcolumn = ds_cond.getColumn(0, "selectcolumn");
				if ( !utlf_isNull(selectcolumn) )
				{
					ds_column_name.setColumn(0, "column_name", selectcolumn);
					ipt_column_name_ontextchanged(objColumnname, null);
					objColumnname.setFocus();

				}
			}
			break;
			
	}
}

function fGridKeyUpEvents(obj:Grid, e:KeyEventInfo)
{
trace(e.keycode);
	switch (e.keycode)
	{
		case 40:	// UP
		case 38:	// DOWN
			var pe = new  GridClickEventInfo();
			fTblGridOnClick(obj, pe);		
			break;
		case 13:		// Enter
			fSaveFavTable("fafds", "./fafds.xml");
			break;
	}
}

function ipt_column_name_onkeydown(obj:Edit, e:KeyEventInfo)
{
//trace("ipt_column_name : " + e.keycode);
	switch(e.keycode)
	{
		case "40":		//arrow down
			
			Tab01.tabpage1.Grid01.selecttype = "row";
			ds_column_info.rowposition = 0 ;
			//Grid01.setCellPos(1);
			
			Tab01.tabpage1.Grid01.setFocus();
					
			
			//Grid01.selecttype = "multiarea";
			break;
			
		case "13": 		// Enter					
			ipt_column_name_ontextchanged(obj, null);
			break;
	}	
}

function Grid01_onkeyup(obj:Grid, e:KeyEventInfo)
{
	switch (e.keycode)
	{
		case 40:	// UP
		case 38:	// Down
			var pe = new  GridClickEventInfo();
			Grid01_oncellclick(obj, pe);
			break;
			
	}
}

function Grid01_onkillfocus(obj:Grid, e:KillFocusEventInfo)
{
	Tab01.tabpage1.Grid01.selecttype = "row";
}

function Grid01_onsetfocus(obj:Grid, e:SetFocusEventInfo)
{
	Tab01.tabpage1.Grid01.selecttype = "multiarea";
}

function Div03_Button00_onclick(obj:Button,  e:ClickEventInfo)
{
	var sql = ds_sql.getColumn(0, "before");
	sql = sql.replace("\t", " ");
	sql = sql.replace("\n", " ");
	sql = sql.replace("\r", " ");
	sql = sql.replace("  ", " ");
	sql = sql.replace("  ", " ");
	sql = sql.replace("  ", " ");
	sql = sql.replace("  ", " ");
	
	var oriParam = "";
	var bStart = false;
	
	ds_parameter.enableevent = false;
	ds_parameter.clearData();
	for (var i = 0; i < sql.length; i++)
	{
		var ch = sql.substr(i, 1);
		
		switch(ch)
		{
			case ":":
				bStart = true;
				oriParam = "";
				break;
				
			case " ":
			case "+":
			case "/":
			case "-":
			case ",":
			case ")":
				bStart = false;
								
				break;			
		}
		
		if (bStart)
		{
			oriParam += ch;
		} else
		{
			if (! utlf_isNull(oriParam) )
			{							
				if (ds_parameter.findRow("before", oriParam) < 0)
				{
					var repParam = "";
					switch (oriParam)
					{
						case ":instcd":
							repParam = "#%dutplceinstcd#";
						break;
						
						default:
							repParam = "#" + oriParam.replace(":", "") + "#";
						
					}					
					var row = ds_parameter.addRow();					
					ds_parameter.setColumn(row, "before", oriParam);
					ds_parameter.setColumn(row, "after", repParam);
				}
				oriParam = "";
			}
		}		
	}
	
	ds_parameter.enableevent = true;

}

function Div03_Grid00_onkeydown(obj:Grid, e:KeyEventInfo)
{
	if (e.keycode == 46) // delete
		ds_parameter.deleteRow(ds_parameter.rowposition);
}

function divRepSql_onrbuttondown(obj:Div, e:MouseEventInfo)
{
	obj.visible = false;
}

function divRepSql_Button01_onclick(obj:Button,  e:ClickEventInfo)
{
	if (ds_parameter.rowcount > 0)
	{
		var sql = ds_sql.getColumn(0, "before");
		
		for (var i = 0; i < ds_parameter.rowcount; i++)
		{
			sql = sql.replace(ds_parameter.getColumn(i, "before"), ds_parameter.getColumn(i, "after"));			
		}
		ds_sql.setColumn(0, "after", sql);
	}
}

function Tab01_canchange(obj:Tab, e:TabIndexChangeEventInfo)
{	
	var owner= ds_cond.getColumn(0, "owner");
	var table_name = ds_cond.getColumn(0, "table_name");
	var object_type = ds_cond.getColumn(0, "object_type");
		
	var bCanchange = true;
	switch(object_type)
	{
		case "TABLE":
			switch (e.postindex)
			{
				case 0:	// 컬럼정보
					break;
				case 1:	// 소스
					bCanchange = false;
					break;
				case 2: // Useby
					fGetViewUseby(owner, table_name, object_type);
					break;			
			}		
			break;
			
		case "VIEW":
			switch (e.postindex)
			{
				case 0:	// 컬럼정보
					break;
				case 1: // 소스
					fGetViewSource(owner, table_name, object_type);
					break;					
				case 2: // Useby
					fGetViewUseby(owner, table_name, object_type, object_type);
					break;			
			}			
		case "FUNCTION":
		case "PROCEDURE":
			switch (e.postindex)
			{
				case 0:		// 컬럼정보
					bCanchange = false;
					break;
				case 1:		// 소스
					fGetViewSource(owner, table_name, object_type);
					break;					
				case 2:		// Useby
					fGetViewUseby(owner, table_name, object_type, object_type);
					break;			
			}			
			break;		
		case "TRIGGER":
			switch(e.postindex)
			{
				case 0:	// 컬럼정보
					bCanchange = false;
					break;
					
				case 1:		// 소스
					fGetViewTrigger(owner, table_name);
					break;					
					
				case 2:		// Useby
					fGetViewUseby(owner, table_name, object_type, object_type);
					break;			
			}
			break;
	}
	return bCanchange;
}

function Tab01_tabpage3_btnLeftMove_onclick(obj:Button,  e:ClickEventInfo)
{
	if (ds_dependencies.rowcount > 0)
	{
		ds_tmp.clearData();
		var nRow = 0;
		for(var i = 0; i < ds_dependencies.rowcount; i++)
		{
			if (ds_dependencies.getColumn(i, "status") == "VALID" )
			{
				nRow = ds_tmp.addRow();
				
				ds_tmp.setColumn(nRow, "owner"      , ds_dependencies.getColumn(i, "owner"));
				ds_tmp.setColumn(nRow, "table_name" , ds_dependencies.getColumn(i, "table_name"));
				ds_tmp.setColumn(nRow, "comments"   , "");
				ds_tmp.setColumn(nRow, "object_type", ds_dependencies.getColumn(i, "object_type"));
				ds_tmp.setColumn(nRow, "domain"	    , "");		
			}
		}
		Grid00.binddataset = ds_tmp;
	}	
}

function cbObjectType_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	fSearchTableList(obj);	
}

function Tab01_tabpage3_cbObjectTypeDep_onitemchanged(obj:Combo, e:ItemChangeEventInfo)
{
	var object_type = utlf_transNullToEmpty(Tab01.tabpage3.cbObjectTypeDep.value);
	
	if (utlf_isNull(object_type))
	{
		ds_dependencies.filter ("");
	}
	else
	{
		ds_dependencies.filter ("String(object_type).indexOf('" + object_type + "') > -1");
	}
}


function fPopupHotkey()
{
	var hotkey = "";
	
	hotkey += "※ 전역" + "\n";
	hotkey += "  ESC 	   : 테이블명 입력칸으로 커서" + "\n";
	hotkey += "  F5 : Column 체크 시 컬럼명/컬럼코멘트로 테이블 조회" + "\n";
	hotkey += "  ALT + Q : 컬럼명 입력칸으로 커서 이동" + "\n";
	//hotkey += "  F9 : SQL Parameter 치환" + "\n";
	hotkey += "  CTRL + 1 : 컬럼정보 탭 이동" + "\n";
	hotkey += "  CTRL + 2 : Source 탭 이동" + "\n";
	hotkey += "  CTRL + 3 : Dependencies 탭 이동" + "\n";
	hotkey += "  CTRL + W : 컬럼명으로 순차 검색" + "\n";
	
	hotkey += "" + "\n";
		
	hotkey += "※ 테이블 리스트" + "\n";
	hotkey += "  F1 : 즐겨 찾기 추가/삭제 토글" + "\n";
	hotkey += "  F8 : 즐겨찾기 저장" + "\n";
	hotkey += "  Ctrl + C : 테이블명 복사(owner.table_name -- comment)" + "\n";	
	hotkey += "" + "\n";
	
	hotkey += "※ 컬럼 정보" + "\n";	
	hotkey += "  CTRL + SHIFT + C : 컬럼정보 복사 (, alias.column_name  -- comments)"  + "\n";
	hotkey += "  F8 : 즐겨찾기 저장" + "\n";
	hotkey += "" + "\n";
	
	hotkey += "※ History 리스트" + "\n";
	hotkey += "  F12 : History 삭제" + "\n";
	hotkey += "" + "\n";
	
	alert(hotkey);
}

// function utlfAddLiveLog(msg)
// {
// 	if ( !utlf_isNull(msg) )
// 	{
// 		dsf_createDsRow("ds_tmp_livelog", [
// 											{col:"msg", tyep:"STRING", val:msg}
// 										  //, {col:"msg1", tyep:"STRING", val:"test"}
// 										  ]);
// 	// 	ds_tmp_livelog.addRow();
// 	// 	ds_tmp_livelog.setColumn(1,  "msg", "teter");
// 	// 	ds_tmp_livelog.setColumn(1,  "msg1", "aaaaaaaaaa");
// 			
// 		var oParam = {};
// 		oParam.id          = "TRSMP092109";
// 		oParam.service     = "testapp.TestMngt";
// 		oParam.method      = "reqSetLiveLog";
// 		oParam.inds        = "log=ds_tmp_livelog";
// 		oParam.outds       = "";
// 		oParam.async       = false;
// 			
// 		tranf_submit(oParam);
// 		
// 		dsf_deleteDs(ds_tmp_livelog);
// 	}
// }

function Button01_onclick(obj:Button,  e:ClickEventInfo)
{
	//utlfAddLiveLog(ds.saveXML());
	sysf_addLiveLog(ds_table_name.getColumn(0, "table_name"));
}

function btnReload_onclick(obj:Button,  e:ClickEventInfo)
{
	this.reload();
}


function Grid01_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	var column = ds_column_info.getColumn(ds_column_info.rowposition, "id");
	var selectcolumn = ds_cond.getColumn(0, "selectcolumn");
	
	
	if ( utlf_isNull(selectcolumn) )
	{
		ds_cond.setColumn(0, "selectcolumn", column);
	}
	else
	{
		var existsyn = selectcolumn.indexOf(column);
		
		
		trace("existsyn : "+ existsyn + ", column : " +column);
		if (existsyn < 0)
		{
			selectcolumn += "," + column;
			ds_cond.setColumn(0, "selectcolumn", selectcolumn );
		}
	}		
}


function lf_setTablename(selecttext)
{
	ds_table_name.setColumn(0, "table_name", selecttext);
	ipt_table_name.updateToDataset();
	fSearchTableList(ipt_table_name);
}


function Div03_btnScriptAction_onclick(obj:Button,  e:ClickEventInfo)
{
	var dsname = ds_scriptinput.getColumn(0, "dsname");
	
	if ( utlf_isNull(this.objects[dsname]))
	{
		dsf_createDs(dsname);		
		ds_scriptcolumn.filter("1 == 0");
		var tmpds = eval(dsname);
		tmpds.copyData(ds_scriptcolumn, true);
		objScript.binddataset = tmpds;				
		objScript.setCellProperty("Body", 0, "text", "expr:" +  dsname + ".rowposition == currow ? '▶' : ''");
	}
	
	var ds = eval(ds_scriptinput.getColumn(0, "dsname"));
	var nCurrow = ds.rowposition;

	if (nCurrow < 0)
	{	
		nCurrow = 0;
	}
		
	switch (obj.text)
	{		
		case "행 추가":
			var nRow = ds.addRow();					
			ds.setColumn(nRow, "owner"    , ds_scriptinput.getColumn(0, "owner"));			
			ds.setColumn(nRow, "tablename", ds_scriptinput.getColumn(0, "tablename"));
			break;
			
		case "행 삭제":			
			var arrDeleteRow = new Array();
 			for(var i = objScript.selectstartrow.length - 1; i >= 0; i--) 
			{
				for(var j = objScript.selectendrow[i]; j >= objScript.selectstartrow[i]; j--) 
				{
					arrDeleteRow.push(j);
				}				
			}			
			for(var i = 0; i <= arrDeleteRow.length - 1; i++)
			{				
				ds.deleteRow(arrDeleteRow[i]);
			}			
			break;
			
		case "위로":
			if (nCurrow > 0)
			{
				ds.moveRow(nCurrow, nCurrow-1)
			}
			break;
		
		case "아래로":
			if (nCurrow < ds.rowcount)
			{
				ds.moveRow(nCurrow, nCurrow + 1)
			}
			break;
		
		case "저장":
			fSaveScriptTable();
			break;
			
		case "삭제":
			fDeleteScriptTable();
			break;
			
		
	}
}

function Div03_btnScriptGen_onclick(obj:Button,  e:ClickEventInfo)
{
	var owner = utlf_transNullToEmpty(ds_scriptinput.getColumn(0, "owner"));
	var tablename = utlf_transNullToEmpty(ds_scriptinput.getColumn(0, "tablename"));
	var tablecomment = utlf_transNullToEmpty(ds_scriptinput.getColumn(0, "comment"));
		tablecomment = tablecomment.replace("'", "''");

	var ds = eval(ds_scriptinput.getColumn(0, "dsname"));
	var columncount = ds.rowcount;
	var script = "";
	
	if ( !utlf_isNull(owner) && !utlf_isNull(tablename) )
	{
		// Table 생성
		var arrComment = new Array();
		var arrPkColumn = new Array();
		
		
		script += "/* 테이블 생성 */"  + "\n";		
		script += "CREATE TABLE " + owner + "." + tablename + " \n";
		script += " (" + "\n";
		
		for (var i = 0; i < columncount ; i++)
		{
			var columnname = utlf_transNullToEmpty(ds.getColumn(i, "columnname"));
			
			var type 	   = utlf_transNullToEmpty(ds.getColumn(i, "type"));			
			var isreqlegnth = ds_scripttypecd.lookup("type", type, "isreqlegnth");					
			var length	   = utlf_transNullToEmpty(ds.getColumn(i, "length"));
			
			var isnotnull  = utlf_transNullToEmpty(ds.getColumn(i, "isnotnull"));
			var defaultval = utlf_transNullToEmpty(ds.getColumn(i, "defaultval"));
			var columncomment = utlf_transNullToEmpty(ds.getColumn(i, "columncomment"));
			
			var ispk	   = utlf_transNullToEmpty(ds.getColumn(i, "ispk"));
						
			script += " " + (i == 0 ? "  ": ", ") + columnname + " " + type ;
			if ( isreqlegnth == "Y" )
			{
				script += " (" + length + ") ";
			}
			if (isnotnull == "Y")
			{
				script += " NOT NULL ";
			}
			if ( !utlf_isNull(defaultval) )
			{
				script += " DEFAULT " + defaultval + "";
			}			
			script += "\n";
			
			var columncommentsrc = "Comment on Column " + owner + "." + tablename + "." + columnname + " is '" + columncomment + "';";			
			arrComment.push(columncommentsrc);
			
			if ( ispk == "Y" )
			{
				arrPkColumn.push(columnname);
			}					
		}			
		script += " ) TABLESPACE EMR_D08_01" + "\n";
		script += "    PCTFREE 30"  + "\n";	
		script += "    PCTUSED 0" + "\n";
		script += "    INITRANS 16" + "\n";
		script += "    MAXTRANS 255" + "\n";
		script += "    STORAGE" + "\n";
		script += "   (" + "\n";
		script += "       INITIAL 65536" + "\n";
		script += "       NEXT 327680" + "\n";
		script += "       MINEXTENTS 1" + "\n";
		script += "       MAXEXTENTS UNLIMITED" + "\n";
		script += "       BUFFER_POOL DEFAULT" + "\n";
		script += "    )" + "\n";
		script += "    LOGGING ;" + "\n";
		
		script += ""  + "\n";
		script += "/* 코멘트 생성 */"  + "\n";
		script += "Comment on Table " + owner + "." + tablename + " is '" + tablecomment + "';" + "\n";
		
		for(var i = 0; i < arrComment.length; i++)
		{
			script += arrComment[i]  + "\n";
		}
		
		script += ""  + "\n";
		script += "/* Primary Key 생성 */"  + "\n";		
		if(arrPkColumn.length > 0)
		{		
			script += "Alert Table " + owner + "." + tablename + " add constraints PK_" + tablename + " primary key (\n";
			for (var i = 0; i < arrPkColumn.length; i++)
			{
				script += (i == 0? " ": ", ") + arrPkColumn[i] + " \n";
			}
			script += ");"  + "\n";
		}
		
		script += "GRANT INSERT ON " + owner + "." + tablename + " TO HISU01;"  + "\n";
		script += "GRANT UPDATE ON " + owner + "." + tablename + " TO HISU01;"  + "\n";
		script += "GRANT DELETE ON " + owner + "." + tablename + " TO HISU01;"  + "\n";
		script += "GRANT SELECT ON " + owner + "." + tablename + " TO HISU01;"  + "\n";
		
		script += "GRANT INSERT ON " + owner + "." + tablename + " TO DEVADMIN;"  + "\n";
		script += "GRANT UPDATE ON " + owner + "." + tablename + " TO DEVADMIN;"  + "\n";
		script += "GRANT DELETE ON " + owner + "." + tablename + " TO DEVADMIN;"  + "\n";
		script += "GRANT SELECT ON " + owner + "." + tablename + " TO DEVADMIN;"  + "\n";
		
		script += ""  + "\n";
				
		ds_scriptinput.setColumn(0, "script", script);
		divScript.Tab00.tabindex = 1;
	}
}


function Div03_Div00_Edit00_onkeydown(obj:Edit, e:KeyEventInfo)
{
	switch(e.keycode)
	{	
		case "13":
			obj.updateToDataset();
			var owner = ds_scriptinput.getColumn(0, "owner");
			var columnname = ds_send.getColumn(0, "columnname");
			
			lf_getColumnlist(owner, columnname);
			
// 			if (ds_columnlist.rowcount == 0)
// 			{					
// 				lf_getColumnlist(owner, columnname);
// 			}			
// 			ds_columnlist.filter("String(columnname).indexOf('" + columnname + "') >= 0 || String(columncomment).indexOf('" + columnname + "') >= 0");
			break;
	}
}

function SMSMP09204_ontimer(obj:Form, e:TimerEventInfo)
{
	var oParam = {};
	oParam.id          = "TRSMP09210";
	oParam.service     = "testapp.TestMngt";
	oParam.method      = "reqGetDummy";
	oParam.inds        = "";
	oParam.outds       = "";
	oParam.async       = false;
		
	tranf_submit(oParam);
}

function divColumnlist_Grid00_oncelldblclick(obj:Grid, e:GridClickEventInfo)
{
	var nRow = -1;
	
	var dsname = ds_scriptinput.getColumn(0, "dsname");
	if ( utlf_isNull(this.objects[dsname]))
	{
		dsf_createDs(dsname);		
		ds_scriptcolumn.filter("1 == 0");
		var tmpds = eval(dsname);
		tmpds.copyData(ds_scriptcolumn, true);
		objScript.binddataset = tmpds;
		objScript.setCellProperty("Body", 0, "text", "expr:" +  dsname + ".rowposition == currow ? '▶' : ''");
	}
	var ds = eval(dsname);
	
	var columnname = ds.getColumn(ds_columnlist.rowposition, "columnname");
	
	// 이미 들어가 있음
	
	var isExists = utlf_transNullToEmpty(ds.lookup("columnname", columnname, "columnname"));	
		
	if ( utlf_isNull( isExists ) )
	{				
 		nRow = (ds_scriptcolumn.rowcount == 0 ? 0: ds_scriptcolumn.rowposition);		

		ds.setColumn(nRow, "owner"        , ds_scriptinput.getColumn(0, "owner"));
		ds.setColumn(nRow, "tablename"    , ds_scriptinput.getColumn(0, "tablename"));
		ds.setColumn(nRow, "columnname"   , ds_columnlist.getColumn(ds_columnlist.rowposition, "columnname"));
		ds.setColumn(nRow, "type"		  , ds_columnlist.getColumn(ds_columnlist.rowposition, "type"));
		ds.setColumn(nRow, "length"	      , ds_columnlist.getColumn(ds_columnlist.rowposition, "length"));
		ds.setColumn(nRow, "isnotnull"    , "");
		ds.setColumn(nRow, "defaultval"   , ds_columnlist.getColumn(ds_columnlist.rowposition, "defaultval"));
		ds.setColumn(nRow, "columncomment", ds_columnlist.getColumn(ds_columnlist.rowposition, "columncomment"));	
		
		ds.rowposition = nRow;
	}
	else
	{
		alert("이미 있음");
	}
}

function fSaveScriptTable()
{
	var owner = ds_scriptinput.getColumn(0, "owner");
	var tablename = ds_scriptinput.getColumn(0, "tablename");
	var comment = ds_scriptinput.getColumn(0, "comment");
	var script = ds_scriptinput.getColumn(0, "script");
	
	
	var nRow = ds_scripttable.findRowExpr("owner == '" + owner + "' && tablename == '" + tablename + "'");
	if (nRow < 0)
	{
		nRow = ds_scripttable.addRow();
	}
		
	ds_scripttable.setColumn(nRow, "tablename", tablename);
	ds_scripttable.setColumn(nRow, "comment", comment);
	ds_scripttable.setColumn(nRow, "script", script);	
	
	fSaveFavTable("ds_scripttable", "./TableScript/ds_scripttable.xml", false);
	fGetDataSet ("ds_scripttable", "./TableScript/ds_scripttable.xml");
	
		
	var dsname = ds_scriptinput.getColumn(0, "dsname");	
	
	if ( utlf_isNull(this.objects[dsname]) )
	{
		dsf_createDs(dsname);		
		var ds = eval(dsname);		
		var tmpds = objScript.binddataset;
		
		ds.copyData(tmpds, true);
		
		for(var i = 0; i < tmpds.rowcount; i++)
		{
			ds.setColumn(i, "owner", owner);
			ds.setColumn(i, "tablename", owner);
		}
	}
	fSaveFavTable(dsname, "./TableScript/" + dsname + ".xml", false);	
}

function fDeleteScriptTable()
{
	var owner = ds_scriptinput.getColumn(0, "owner");
	var tablename = ds_scriptinput.getColumn(0, "tablename");
	var comment = ds_scriptinput.getColumn(0, "comment");
	var script = ds_scriptinput.getColumn(0, "script");
	
	var nRow = ds_scripttable.findRowExpr("owner == '" + owner + "' && tablename == '" + tablename + "'");
	
	if (nRow >= 0)
	{
		ds_scripttable.deleteRow(nRow);
	}
		
	var rowcount = ds_scriptcolumn.rowcount;
	for (var i = rowcount ; i >= 0; i--)
	{	
		ds_scriptcolumn.deleteRow(i);
	}

	fSaveFavTable("ds_scripttable", "./TableScript/ds_scripttable.xml", false);
	fSaveFavTable("ds_scriptcolumn", "./ds_scriptcolumn.xml", false);
	
	fGetDataSet ("ds_scripttable", "./TableScript/ds_scripttable.xml");
}


function divScript_Grid01_oncellclick(obj:Grid, e:GridClickEventInfo)
{
	fLoadscripttable();
}

function fLoadscripttable()
{	
	var nRow      = ds_scripttable.rowposition;	
	var owner     = ds_scripttable.getColumn(nRow, "owner");
	var tablename = ds_scripttable.getColumn(nRow, "tablename");
	var comment   = ds_scripttable.getColumn(nRow, "comment") ;
	var script    = ds_scripttable.getColumn(nRow, "script") 

	var dsname = "ds_" + owner + "_" + tablename;	
	var olddsname = ds_scriptinput.getColumn(0, "dsname");
	
	if (dsname != olddsname && !utlf_isNull(olddsname))
	{
		fSaveScriptTable();
	}	
	var ds;
	if ( utlf_isNull(this.objects[dsname]) )
	{		
		var vFile = new VirtualFile();
		var bExists = vFile.open("./TableScript/" + dsname + ".xml", VirtualFile.openRead);
		vFile.close();
		if (bExists)
		{			
			fGetDataSet (dsname, "./TableScript/" + dsname + ".xml");
			ds = eval(dsname);
		}
		else
		{
			dsf_createDs(dsname);
			ds_scriptcolumn.filter("1 == 0");
			
			ds = eval(dsname);
			ds.copyData(ds_scriptcolumn, true);
		}
	}
	else
	{
		ds = eval(dsname);
	}
	
	ds_scriptinput.setColumn(0, "owner", owner  );
	ds_scriptinput.setColumn(0, "tablename", tablename );
	ds_scriptinput.setColumn(0, "comment", comment );
	ds_scriptinput.setColumn(0, "script",  script );
	ds_scriptinput.setColumn(0, "dsname", dsname);
		
	objScript.binddataset = ds;
	objScript.setCellProperty("Body", 0, "text", "expr:" +  dsname + ".rowposition == currow ? '▶' : ''");
}


function divScript_btnScriptpaste_onclick(obj:Button,  e:ClickEventInfo)
{
	var sClipText = system.getClipboard("CF_TEXT");
	
	if ( !utlf_isNull(sClipText) )
	{
		var arrClip = sClipText.split("\n");		
		var nRow = ds_scriptcolumn.rowposition;
		var owner = ds_scriptinput.getColumn(0, "owner");
		var tablename = ds_scriptinput.getColumn(0, "tablename");
		
		var ds = eval(ds_scriptinput.getColumn(0, "dsname"));
		
		ds_scriptcolumn.row1
		
		for(var i = 0; i < arrClip.length; i++)
		{
			if( !utlf_isNull(arrClip[i]) )
			{
				nRow = ds.insertRow(nRow + 1);
				var arrRow = arrClip[i].split("\t");				
				for (var j = 0; j < arrRow.length; j++)
				{
					ds.setColumn(nRow, 2 + j, arrRow[j].trim());			
				}
				
				ds.setColumn(nRow, "owner", owner);
				ds.setColumn(nRow, "tablename", tablename);
			}
		}
	}
}

function divScript_Grid00_onkeydown(obj:Grid, e:KeyEventInfo)
{
	switch(e.keycode)
	{
		case 111 + 2: //F2
			
			var ds = eval(ds_scriptinput.getColumn(0, "dsname"));					
			var columncomment = ds.getColumn(ds.rowposition, "columncomment");
		
			if (!utlf_isNull(columncomment) )
			{
				ds_send.setColumn(0, "columnname", columncomment);
				var owner = ds_scriptinput.getColumn(0, "owner");
				var columnname = ds_send.getColumn(0, "columnname");
				
				lf_getColumnlist(owner, columnname);
				
				divScript.Tab00.tabindex = 0;
				divScript.Tab00.tabpage1.Edit00.setFocus();
			}
			break;			
	}
}

function ds_scriptcolumn_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
	if(e.columnid == "columnname") 
	{
		var tmp = e.newvalue.substr(e.newvalue.length - 2, 2);
		var nRow = ds_scriptcolumn.rowposition;
		switch(tmp)
		{
			case "DD":
				ds_scriptcolumn.setColumn(nRow, "type",   "VARCHAR2");
				ds_scriptcolumn.setColumn(nRow, "length", "8");
				break;
				
			case "TM":
				ds_scriptcolumn.setColumn(nRow, "type",   "VARCHAR2");
				ds_scriptcolumn.setColumn(nRow, "length", "4");
				break;
		}
		trace(tmp);
	}
}



function divScript_Grid00_onkillfocus(obj:Grid, e:KillFocusEventInfo)
{
	obj.updateToDataset();
}

function ds_scriptinput_oncolumnchanged(obj:Dataset, e:DSColChangeEventInfo)
{
 	if (e.columnid == "owner" || e.columnid == "tablename")	
	{
		var owner = ds_scriptinput.getColumn(0, "owner");
		var tablename = ds_scriptinput.getColumn(0, "tablename");	
		ds_scriptinput.setColumn(0, "dsname", "ds_" + owner + "_" + tablename);
	}
}



function btnFormOpen_onclick(obj:Button,  e:ClickEventInfo)
{
	frmf_open("SPMNP09900","SPMNP09900","","","","","","","","","","","M");
}
]]></Script>
  </Form>
</FDL>