Where The Streets Have No Name

xy change 챠트 본문

Developement/RIA

xy change 챠트

highheat 2006. 8. 25. 13:29
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML>
<HEAD>
<META http-equiv=Content-Type content="text/html; charset=ks_c_5601-1987">
<META content="MSHTML 6.00.2900.2912" name=GENERATOR>
<script language=JavaScript>
 function SetGrid() {
   //데이타셋,그리드,컬럼폭,자동폭조정
   cfDataSetToGrid(MxDataSet_1,MxGrid_1,100,false);
 }

 function cfDataSetToGrid(oDS,oGrid,vWidth,bAutoResize) {
  oGrid.DataID = oDS.id;
  //데이타셋의 컬럼을 읽어서 포맷문자열 생성
    var fmt = "";
    for (i=1;i<=oDS.CountColumn;i++) {
        fmt += "<C>id="+oDS.ColumnID(i)+" name="+oDS.ColumnID(i)+" width="+vWidth+"</C>";
    }
    oGrid.format = fmt;
    //그리드의 컬럼 자동폭조정
    if(bAutoResize) oGrid.SetAutoResizing("");
 }

 function ChangeXY() {
  cfInverseDataSet(MxDataSet_1,MxDataSet_2);
  cfDataSetToGrid(MxDataSet_2,MxGrid_2,100,false);
 }

 function cfInverseDataSet(oDS1,oDS2) {
  if (oDS1.CountColumn==0) return;
  //데이타셋헤더생성
  var vHeader = "";
  vHeader += oDS1.ColumnID(1) + ",";
    for (i=1;i<oDS1.CountRow;i++) {
     vHeader += oDS1.ColumnString(i,1) + ",";
  }
  vHeader += oDS1.ColumnString(oDS1.CountRow,1);
  oDS2.SetDataHeader(vHeader);
  //데이타생성
  for (i=2;i<=oDS1.CountColumn;i++) {
   oDS2.AddRow();
   oDS2.ColumnString(i-1,1) = oDS1.ColumnID(i);
   for (j=1;j<=oDS1.CountRow;j++) {
    oDS2.ColumnString(i-1,j+1) = oDS1.ColumnString(j,i);
   }
  }
 }
</script>

  <object id="MxDataSet_1"
    classid="clsid:3267EA0D-B5D8-11D2-A4F9-00608CEBEE49">
    <Param Name="DataID" value="Data.csv">
  </object>
  <object id="MxDataSet_2"
    classid="clsid:3267EA0D-B5D8-11D2-A4F9-00608CEBEE49">
  </object>
</HEAD>
  <BODY>
  <input type=Button value="그리드처리" OnClick="SetGrid()">
  <input type=Button value="XY바꾸기" OnClick="ChangeXY()">
   <p>
    <OBJECT id=MxGrid_1 style="WIDTH: 600px; HEIGHT: 300px" classid=clsid:1F57AEAD-DB12-11D2-A4F9-00608CEBEE49 >
    </OBJECT>
    <p>
    <OBJECT id=MxGrid_2 style="WIDTH: 600px; HEIGHT: 300px" classid=clsid:1F57AEAD-DB12-11D2-A4F9-00608CEBEE49 >
    </OBJECT>
  </BODY>
</HTML>


col01:STRING(16),col02:DECIMAL(10.1),col03:DECIMAL(10.1),col04:DECIMAL(10.1),col05:DECIMAL(10.1),col06:DECIMAL(10.1),col07:DECIMAL(10.1),col08:DECIMAL(10.1),col09:DECIMAL(10.1),col10:DECIMAL(10.1),col11:DECIMAL(10.1),col12:DECIMAL(10.1),col13:DECIMAL(10.1)
A15.5,15,14.5,14,13.5,13,12.5,12,11.5,11,10.5,10
B,15.5,15.3,15.1,14.9,14.7,14.5,14.3,14.1,13.9,13.7,13.5,13.3
C,15.5,14.7,13.9,13.1,12.3,11.5,10.7,9.9,9.1,8.3,7.5,6.7
D,15.5,14.5,13.5,12.5,11.5,10.5,9.5,8.5,7.5,6.5,5.5,4.5
E,15.5,14,12.5,11,9.5,8,6.5,5,3.5,2,0.5,-1
F,15.5,15.4,15.3,15.2,15.1,15,14.9,14.8,14.7,14.6,14.5,14.4

col01의 값이 같은 값이 존재하면 xy-change후 같은 column의 첫번째값이 반복됨
'Developement/RIA' Related Articles more