From 6dad7ef53ebc83b4dc81af67079f3290c27fca98 Mon Sep 17 00:00:00 2001
From: ?? ? <neonhuang@hotmail.com>
Date: Thu, 10 Apr 2008 21:01:10 +0800
Subject: [PATCH] 

---
 xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2ShpJob.java |   17 ++++++++++++++---
 1 files changed, 14 insertions(+), 3 deletions(-)

diff --git a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2ShpJob.java b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2ShpJob.java
index 30cd470..73ad22e 100644
--- a/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2ShpJob.java
+++ b/xdgnjobs/ximple-spatialjob/src/main/java/com/ximple/eofms/jobs/OracleConvertDgn2ShpJob.java
@@ -87,11 +87,12 @@
         jobContext.setLogin(_username, _password);
         jobContext.setShapeData(_dataPath);
         jobContext.setExecutionContext(context);
-
+     
         try
         {
-            //exetcuteConvert(jobContext, _orgSchema, _dataPath);
-            exetcuteConvert(jobContext, "CMMS_SPATIALDB", _dataPath);
+            copyConnectivity(jobContext);
+            exetcuteConvert(jobContext, _orgSchema, _dataPath);
+            //exetcuteConvert(jobContext, "CMMS_SPATIALDB", _dataPath);
 
             //close all open filewriter instance
             jobContext.closeFeatureWrite();
@@ -103,6 +104,15 @@
             ex.printStackTrace();  //To change body of catch statement use File | Settings | File Templates.
         }
 
+    }
+
+    //Connectivity�ƻs�@�Ӫ����A�b�d�߹q�y��V�ɥΨӤ��OMS��Ʈw���q���s����(Connectivity)
+    private void copyConnectivity(OracleConvertJobContext jobContext)  throws SQLException
+    {
+       OracleConnection connection =  jobContext.getOracleConnection() ;
+       Statement stmt = connection.createStatement();
+       stmt.execute(OracleConvertJobContext.TRUNCATE_CONNECTIVITY_WEBCHECK);
+       stmt.execute(OracleConvertJobContext.COPY_CONNECTIVITY_TO_WEBCHECK);
     }
 
     private void exetcuteConvert(OracleConvertJobContext jobContext,
@@ -332,6 +342,7 @@
         stmtDest.close();
     }
 
+    // Binary to Element
     private Element fetchBinaryElement(byte[] raws) throws Dgn7fileException
     {
         ByteBuffer buffer = ByteBuffer.wrap(raws);

--
Gitblit v0.0.0-SNAPSHOT