package com.esri.aims.mtier.dx;

import com.esri.sde.sdk.client.*;
import java.util.*;
import java.io.*;

public class SdeService {
  SeConnection sdeConn=null;

  public SdeService() {
  }

  /**
   * 帶參數的構造函數
   * @param server 主機名
   * @param instance 端口號
   * @param database 數據庫名
   * @param user 用戶
   * @param password 密碼
   * @throws SeException
   */
  public SdeService(String server,int instance,String database,String user,String password) throws SeException,Exception{
    initConn(server,instance,database,user,password);
  }

  /**
   * 初始化連接
   * @param server 主機名
   * @param instance 端口號
   * @param database 數據庫名
   * @param user 用戶
   * @param password 密碼
   * @throws SeException
   */
  public void initConn(String server,int instance,String database,String user,String password) throws SeException,Exception{
    try{
      sdeConn=new SeConnection(server,instance,database,user,password);
    }catch(SeException ex){
      throw new Exception(ex.getSeError().getErrDesc());
    }
  }

//************************************************************************************//
/*      registration and make version     */
//************************************************************************************//

  /**
   * 判斷是否注冊
   * @param tableName String
   * @throws SeException
   * @return boolean
   */
  public boolean isRegistration(String tableName) throws SeException,Exception{
    boolean isReg=false;
    
    return isReg;
  }

  /**
   * 注冊
   * @param tableName String
   * @throws SeException
   */
  public void makeRegistration(String tableName) throws SeException,Exception{

  }

  /**
   * 判斷是否支持多版本
   * @param tableName String
   * @throws SeException
   * @return boolean
   */
  public boolean isMultiVersion(String tableName) throws SeException,Exception{
    boolean isMultiVersion=false;

    return isMultiVersion;
  }

  /**
   * 多版本
   * @param tableName String
   * @param isMulti boolean
   * @throws SeException
   */
  public void makeMultiVersion(String tableName,boolean isMulti) throws SeException,Exception{

  }

  /**
   * 創建新版本
   * @param versionName String
   * @throws SeException
   * @return SeVersion
   */
  public SeVersion createNewVersion(String versionName) throws SeException,Exception{
    SeVersion newVersion = null;
 
    return newVersion;
  }

  /**
   * 創建子狀態
   * @param parentState SeState
   * @throws SeException
   * @return SeState
   */
  public SeState createChildState(SeState parentState) throws SeException,Exception{
    SeState child = null;
 
    return child;
  }

//************************************************************************************//
/*      create table and layer     */
//************************************************************************************//

  /**
   * 獲取當前操作圖層
   * @param tableName 表名
   * @throws SeException
   * @return SeLayer
   */
  public SeLayer getActiveLayer(String tableName) throws SeException,Exception{
    SeLayer layer = null;

    return layer;
  }

  /**
   * 設置表結構
   * @param colNames String[]，字段名
   * @param colTypes int[]，字段類型 {1-int16;2-int32;3-float32;4-float64;5-string;6-blob;7-date}
   * @throws SeException
   * @throws Exception
   * @return SeColumnDefinition[]
   */
  public SeColumnDefinition[] setColumnDefinition(String[] colNames,int[] colTypes) throws
      SeException,Exception {
    SeColumnDefinition[]  colDefs = null;

    return colDefs;
  }

  /**
   * 創建圖層及屬性表
   * @param tableName 表名
   * @param type 圖層類型 -> "point"、"line"、"polygon"
   * @param colDefs SeColumnDefinition[]
   * @throws SeException
   * @throws IOException
   * @return SeLayer
   */
  public SeLayer createTable(String tableName,String type,SeColumnDefinition[] colDefs) throws SeException,IOException,Exception{
    SeLayer layer = null;
  
    return layer;
  }

  /**
   * 刪除圖層及屬性表
   * @param tableName 表名
   * @throws SeException
   */
  public void deleteTable(String tableName) throws SeException,Exception{

  }

  /**
   * 關閉連接
   * @throws SeException
   */
  public void closeSdeConn() throws SeException {
    if(!sdeConn.isClosed())
      sdeConn.close();
  }

  //************************************************************************//
  /*      insert   delete   update   query     */
  //************************************************************************//

  /**
   * 創建空間要素
   * @param pts String[]，點坐標
   * @param shapeType Shape類型
   * @param coordRef 參考坐標
   * @throws SeException
   * @return SeShape
   */
  public SeShape createShape(String[] pts, int shapeType, SeCoordinateReference coordRef) throws SeException,Exception {
    SeShape shape = null;
 
    return shape;
  }

  /**
   * 設置要素屬性集
   * @param row SeRow
   * @param rowCells Vector
   * @throws SeException
   */
  protected void setRowCells(SeRow row,Vector rowCells) throws SeException,Exception{
 
  }

  /**
   * 插入空間數據
   * @param tableName String
   * @param rowCells Vector
   * @throws SeException
   * @throws Exception
   */
  public void insertSpatialData(String tableName,Vector rowCells) throws SeException,Exception{
    SeLayer layer=getActiveLayer(tableName);
    if(layer==null || rowCells==null) return;
    
  }

  /**
   * 更新空間數據
   * @param tableName String
   * @param rowCells Vector
   * @param whereClause String
   * @throws SeException
   * @throws Exception
   */
  public void updateSpatialData(String tableName, Vector rowCells, String whereClause) throws SeException,Exception{
    SeLayer layer=getActiveLayer(tableName);
    if(layer==null || rowCells==null) return;

  }

  /**
   * 刪除空間數據
   * @param tableName String
   * @param whereClause String
   * @throws SeException
   */
  public void deleteSpatialData(String tableName,String whereClause) throws SeException,Exception{
    SeLayer layer=getActiveLayer(tableName);
    if(layer==null) return;

  }

  /**
   * 獲取屬性查詢數據
   * @param tableName String
   * @param whereClause String
   * @throws SeException
   * @return List
   */
  public List fetchQueryData(String tableName,String whereClause) throws SeException,Exception {
    SeLayer layer=getActiveLayer(tableName);
    if(layer==null) return null;
    Vector queryRows=new Vector();

    return queryRows;
  }

  /**
   * 獲取空間查詢數據
   * @param tableName String
   * @param shape SeShape[]
   * @param method int
   * @throws SeException
   * @return List
   */
  public List fetchSpatialQueryData(String tableName, SeShape[] shape,int method) throws
      SeException,Exception {
    SeLayer layer = getActiveLayer(tableName);
    if(layer==null) return null;
    Vector queryRows = new Vector();

    return queryRows;
  }

  public void readQueryRows(SeRow row) throws SeException,Exception {
 
  }

}