From 85c3a98a228340863fb7507586b2c7cf7231e299 Mon Sep 17 00:00:00 2001
From: wangting <675591594@qq.com>
Date: 星期二, 01 八月 2023 17:16:06 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master'

---
 Source/UBCS-WEB/src/components/Theme/ThemeAttrCrud.vue                                                    |   24 ++++-
 Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java |   43 ++++++++++
 Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/dll/DllDmMapperProcessor.java  |    1 
 Source/UBCS-WEB/src/components/Theme/ThemeClassifyTreeform.vue                                            |    5 +
 Source/UBCS-WEB/src/components/Theme/ThemeClassifyTrees.vue                                               |  142 +++++++++++++++++++----------------
 Source/UBCS-WEB/src/views/modeling/originalAdd.vue                                                        |   10 +-
 Source/UBCS-WEB/vue.config.js                                                                             |    5 
 Source/UBCS-WEB/src/api/template/templateAttr.js                                                          |    1 
 Source/UBCS-WEB/src/components/Theme/ThemeTemplatePro.vue                                                 |    1 
 9 files changed, 151 insertions(+), 81 deletions(-)

diff --git a/Source/UBCS-WEB/src/api/template/templateAttr.js b/Source/UBCS-WEB/src/api/template/templateAttr.js
index 9c4779b..6855c96 100644
--- a/Source/UBCS-WEB/src/api/template/templateAttr.js
+++ b/Source/UBCS-WEB/src/api/template/templateAttr.js
@@ -216,6 +216,7 @@
   return request({
     url:'/api/ubcs-code/codeClassify/exportClassify',
     method: 'get',
+    responseType: 'blob',
     params:{
       ...params
     }
diff --git a/Source/UBCS-WEB/src/components/Theme/ThemeAttrCrud.vue b/Source/UBCS-WEB/src/components/Theme/ThemeAttrCrud.vue
index 34a0cec..6c0b8fd 100644
--- a/Source/UBCS-WEB/src/components/Theme/ThemeAttrCrud.vue
+++ b/Source/UBCS-WEB/src/components/Theme/ThemeAttrCrud.vue
@@ -14,7 +14,7 @@
       </el-button-group>
       <el-button-group>
         <!--    淇濆瓨-->
-        <el-button v-if="(!checkStatus|| crudLCStatus=='Editing') && editOpenFlag" size="small" type="success" plain @click="addsHandler" icon="el-icon-check">淇濆瓨</el-button>
+        <el-button v-if="(!checkStatus|| crudLCStatus=='Editing') && editOpenFlag" size="small" type="success" plain @click.prevent="addsHandler" icon="el-icon-check">淇濆瓨</el-button>
         <!--    棰勮鎺掑簭-->
         <el-button size="small" @click="orderHandle" icon="el-icon-arrow-down">棰勮鎺掑簭</el-button>
         <!--    鍒犻櫎-->
@@ -166,11 +166,11 @@
         </div>
       </el-dialog>
       <!--        灞炴�у垎缁�-->
-      <el-dialog :visible.sync="attrVisible" append-to-body style="width: 800px; left:30vw;top: 10vh ;"
+      <el-dialog :visible.sync="attrVisible" append-to-body :before-close="attrModel=''" style="width: 800px; left:30vw;top: 10vh ;"
                  title="杈撳叆鍒嗙粍鐨勫悕绉�">
         <el-form ref="form" label-width="70px">
           <el-form-item label="灞炴�у垎缁�">
-            <el-input v-model="attrModel"></el-input>
+            <el-input v-model="attrModel" autofocus></el-input>
           </el-form-item>
           <div style="display: flex;justify-content: flex-end">
             <el-button size="small" type="primary" @click="attrHandle">鎻愪氦</el-button>
@@ -218,7 +218,7 @@
       </el-dialog>
       <!--        鍏ㄥ睆缂栬緫-->
       <el-dialog :visible.sync="attrEditVisible" append-to-body fullscreen="true" :before-close="escEdit" >
-        <attrCrud :ProData="this.ProData" :attrFlagChiledren="this.attrFlag" :editStyleFlag="editStyleFlag" :editOpenFlag="editOpenFlag" :crudArrayFlag="this.crudArrayFlag"></attrCrud>
+        <attrCrud :ProData="this.ProData" :attrFlagChiledren="this.attrFlag" @editCloseChildren="editClose" :editStyleFlag="editStyleFlag" :editOpenFlag="editOpenFlag" :crudArrayFlag="this.crudArrayFlag"></attrCrud>
       </el-dialog>
       <!--      缁勫悎瑙勫垯-->
       <formula-editor :systemVariableTableData="systemVariableTableData"
@@ -1677,15 +1677,16 @@
       this.attrRow = row;
     },
     //淇濆瓨
-    addsHandler() {
+    addsHandler(event) {
       batchAddSave(JSON.parse(JSON.stringify(this.ProData))).then(res => {
         this.$message.success('淇濆瓨鎴愬姛')
-        this.editOpenFlag=false
+        this.editOpenFlag=false;
+        // 璋冪敤鐖剁粍浠朵慨鏀规寜閽姸鎬�
+        this.$emit('editCloseChildren')
       }).catch(()=>{
         this.$message.warning('淇濆瓨澶辫触锛岃鏌ョ湅鎺у埗鍙拌緭鍑猴紒')
       })
     },
-
     //琛ㄦ牸琛岀紪杈�
     handleCellClicks(row, column) {
        if(this.editOpenFlag){
@@ -1705,6 +1706,7 @@
            }
            // this.$refs.referConfigFormDialog.onloadAttrData();
          }else if(column.property == 'classifyInvokeText'){
+           this.injectVisible=true;
            if (this.CurrentCell.classifyInvokeAttr != '') {
              this.injectOption = {
                classifyInvokeAttr: this.CurrentCell.classifyInvokeAttr,
@@ -1741,6 +1743,9 @@
            this.rulesVisible=true;
          }else if(column.property == 'attributeGroup'){
            this.attrVisible = true;
+           if(this.CurrentCell.attributeGroup !== ''){
+                this.attrModel=this.CurrentCell.attributeGroup
+           }
          }
        }
     },
@@ -1889,6 +1894,7 @@
           this.$set(this.attrSelectList[0],'classifyInvokeText',data)
         }
         this.injectHandleReset()
+
       if(this.injectOption.classifyInvokeLevel !== 'min'){
         this.injectOption.classifyInvokeLevel=this.injectOption.classifyNumber;
       }else  {
@@ -1995,6 +2001,10 @@
     editOpen(){
       this.editOpenFlag=true;
     },
+    //瀹氫箟涓�涓叧闂紪杈戠殑鏂规硶渚涘瓙缁勪欢浣跨敤
+    editClose(){
+      this.editOpenFlag=false;
+    },
     //鎵归噺璁剧疆switch
     batchSetFlag(value){
       this.attrSelectList.forEach(item=>{
diff --git a/Source/UBCS-WEB/src/components/Theme/ThemeClassifyTreeform.vue b/Source/UBCS-WEB/src/components/Theme/ThemeClassifyTreeform.vue
index 87bf1ca..02f63df 100644
--- a/Source/UBCS-WEB/src/components/Theme/ThemeClassifyTreeform.vue
+++ b/Source/UBCS-WEB/src/components/Theme/ThemeClassifyTreeform.vue
@@ -334,6 +334,11 @@
     }
   },
   watch:{
+    TreeFlag:{
+      handler(newval,oldval){
+        console.log(newval)
+      }
+    }
   },
   created() {
   },
diff --git a/Source/UBCS-WEB/src/components/Theme/ThemeClassifyTrees.vue b/Source/UBCS-WEB/src/components/Theme/ThemeClassifyTrees.vue
index 8e63b85..f0d7364 100644
--- a/Source/UBCS-WEB/src/components/Theme/ThemeClassifyTrees.vue
+++ b/Source/UBCS-WEB/src/components/Theme/ThemeClassifyTrees.vue
@@ -24,7 +24,7 @@
           </div>
         </div>
         <!--        鏍戣妭鐐规坊鍔犲璇濇-->
-        <el-dialog :title="this.TreeFlag ? '娣诲姞鍒嗙被' :'娣诲姞涓婚搴�'" :visible.sync="TreeAddFormVisible" append-to-body
+        <el-dialog :title="this.TreeFlag ? '娣诲姞鍒嗙被' :'娣诲姞涓婚搴�'" :visible.sync="TreeAddFormVisible"  v-loading="AddLoading" append-to-body
                    style="width: 1700px;margin: auto">
           <el-form :model="TreeAddform" :rules="rules">
             <el-form-item :label="this.TreeFlag ? '鍒嗙被缂栧彿锛�' :'涓婚搴撶紪鍙凤細'" label-width="150px" style="display: inline-block" prop="id">
@@ -33,7 +33,7 @@
             <el-form-item :label="this.TreeFlag ? '鍒嗙被鍚嶇О锛�' :'涓婚搴撳悕绉帮細'" label-width="110px" style="display: inline-block" prop="name">
               <el-input v-model="TreeAddform.name" autocomplete="off" style="width: 170px"></el-input>
             </el-form-item>
-            <el-form-item label="瀛樺偍鐨勪笟鍔$被鍨嬶細" label-width="150px" v-if="TreeFlagCode==false" prop="btmTypeName">
+            <el-form-item label="瀛樺偍鐨勪笟鍔$被鍨嬶細" label-width="150px" v-if="TreeFlagCode" prop="btmTypeName">
               <el-input v-model="TreeAddform.btmTypeName" autocomplete="off" style="width: 585px" @focus="btmFoucus"></el-input>
             </el-form-item>
             <el-form-item label="鎻忚堪锛�" label-width="150px">
@@ -350,6 +350,9 @@
   inject: ["crudTreeData"],
   data() {
     return {
+      AddLoading:false,
+      // 瀹氫箟涓�涓彉閲忔潵淇濆瓨鏍戣姹傜殑鏁伴噺
+      requestCount:0,
       //瀵煎叆鐘舵�佹
       ThemeImportVisible:false,
       selectRow:'',
@@ -656,6 +659,13 @@
       showEditBtn:false,
     }
   },
+  watch:{
+    TreeFlagCode:{
+      handler(newval,oldval){
+        console.log('TreeFlagCode',newval)
+      }
+    }
+  },
   //tab鏍忛粯璁ゆ槸琛ㄦ牸
   mounted() {
     this.type = this.tabOption.column[0];
@@ -730,9 +740,6 @@
   created() {
 
   },
-  watch:{
-
-  },
   methods: {
     /** 瀵煎叆 */
     ImportExcel(){
@@ -742,7 +749,7 @@
     ExportExcel(){
       if(this.nodeClickList){
         exportClassify({oid:this.nodeClickList.oid}).then(res=>{
-          func.downloadFileByBlob(res);
+          func.downloadFileByBlobHandler(res);
         })
       }else {
         this.$message.warning('璇峰厛閫夋嫨瑕佸鍑虹殑涓婚搴撳垎绫�')
@@ -996,11 +1003,23 @@
       }
     },
     //鏍戣妭鐐规坊鍔犳寜閽�
-    TreeAdd() {
-      this.TreeAddFormVisible = true;
-      // 鍒ゆ柇褰撳墠鏄惁鏈夌偣鍑诲瓙椤�
-      if (this.nodeClickList !== "") {
-        this.TreeFlag = true
+    async TreeAdd() {
+      const loading = this.$loading({
+        lock: true,
+        text: 'Loading',
+        spinner: 'el-icon-loading',
+        background: 'rgba(0, 0, 0, 0.3)'
+      });
+      try {
+        if (this.nodeClickList !== "") {
+          this.TreeFlag = true;
+        }
+        await new Promise(resolve => setTimeout(resolve, 500));
+        this.TreeAddFormVisible = true;
+        loading.close();
+      } catch (error) {
+        this.$message.error(error);
+        loading.close();
       }
     },
     //鏍戣妭鐐规坊鍔犱簨浠�
@@ -1173,72 +1192,61 @@
     },
     //鏍戠偣鍑讳簨浠�
     async nodeClick(data) {
-      //瀹氫箟涓�涓ā鏉垮睘鎬d锛屾暟鎹槸妯℃澘绠$悊琛ㄦ牸閲岄潰鐨刼id
-      if(data.parentId == ""){
-        this.TreeFlagCode=true;
-
+      console.log(data);
+      if (data.parentId === "") {
+        this.TreeFlagCode = true;
+      }else {
+        this.TreeFlagCode =false;
       }
-      this.nodeClickList = data
-      this.selectRow=0;
+      this.nodeClickList = data;
+      this.selectRow = 0;
       try {
-        await TreeObjcet(data.oid).then(res => {
-          this.FlagObj = res.data.data
-        }).catch(res => {
-          this.$message.error(res)
-        })
-        //妯℃澘绠$悊琛ㄦ牸鏁版嵁
-        await gridCodeClassifyTemplate({'conditionMap[codeclassifyoid]': data.oid}).then(res => {
-          this.Formlist = res.data.data.filter(item => {
-            if (item.codeclassifyoid != "") {
-              this.codeClassifyOid = item.codeclassifyoid
-              return item.codeclassifyoid == this.nodeClickList.oid
-            }
-          })
-          if(this.Formlist.length >= 1){
-            this.crudLCStatus=this.Formlist[this.selectRow].lcStatus;
-            this.crudArray.push(this.Formlist[this.selectRow]);
-            this.crudOid=this.Formlist[this.selectRow].oid;
-            this.gridCode()
-          }else {
-              this.ProData = [];
+        this.requestCount += 1;
+        const [res1, res2, res3] = await Promise.all([
+          TreeObjcet(data.oid),
+          gridCodeClassifyTemplate({ 'conditionMap[codeclassifyoid]': data.oid }),
+          getObjectByOid(data.oid)
+        ]);
+        this.FlagObj = res1.data.data;
+        this.Formlist = res2.data.data.filter(item => {
+          if (item.codeclassifyoid != "") {
+            this.codeClassifyOid = item.codeclassifyoid;
+            return item.codeclassifyoid == this.nodeClickList.oid;
           }
-        }).catch(res => {
-          this.$message.error(res)
-        })
-        //  鍩烘湰淇℃伅琛ㄥ崟鏁版嵁
-          await getObjectByOid(this.nodeClickList.oid).then(res => {
-            this.TreeList = res.data.data;
-          }).catch(res => {
-            this.$message.error(res)
-          })
+        });
+        if (this.Formlist.length >= 1) {
+          this.crudLCStatus = this.Formlist[this.selectRow].lcStatus;
+          this.crudArray.push(this.Formlist[this.selectRow]);
+          this.crudOid = this.Formlist[this.selectRow].oid;
+          await this.gridCode();
+        } else {
+          this.ProData = [];
+        }
+        this.TreeList = res3.data.data;
       } catch (error) {
-        this.$message.error(error)
+        this.$message.error(error);
       }
     },
-    gridCode(){
-      gridCodeClassifyTemplateAttr({'conditionMap[classifyTemplateOid]': this.Formlist[this.selectRow].oid,limit:-1}).then(res => {
-        this.ProData = res.data.data;
-        //鍒嗙被娉ㄥ叆鏁版嵁鏍煎紡
-        this.ProData =  res.data.data.map((item) => {
-          //濡傛灉鍒嗙被娉ㄥ叆classifyInvokeAttr涓虹┖璇存槑鏄垵濮嬬姸鎬�
-          if(item.classifyInvokeAttr !== ''){
-            if (!item.hasOwnProperty('classifyInvokeText')) { // 妫�鏌lassifyInvokeText灞炴�ф槸鍚﹀瓨鍦�
-              item = {
-                ...item,
-                classifyInvokeText: {
-                  "娉ㄥ叆绫诲瀷": item.classifyInvokeAttr,
-                  "娉ㄥ叆绫诲瀷鍚嶇О": item.classifyInvokeAttrName,
-                  "灞傜骇璁剧疆": item.classifyInvokeLevel,
-                  "鏄惁鍙慨鏀�": item.classifyInvokeEditFlag
-                }
+
+    async gridCode() {
+      try {
+        const res = await gridCodeClassifyTemplateAttr({ 'conditionMap[classifyTemplateOid]': this.Formlist[this.selectRow].oid, limit: -1 });
+        this.ProData = res.data.data.map(item => {
+          if (item.classifyInvokeAttr !== '') {
+            if (!item.hasOwnProperty('classifyInvokeText')) {
+              item.classifyInvokeText = {
+                '娉ㄥ叆绫诲瀷': item.classifyInvokeAttr,
+                '娉ㄥ叆绫诲瀷鍚嶇О': item.classifyInvokeAttrName,
+                '灞傜骇璁剧疆': item.classifyInvokeLevel,
+                '鏄惁鍙慨鏀�': item.classifyInvokeEditFlag
               };
             }
           }
           return item;
         });
-      }).catch(res => {
-        this.$message.error(res)
-      })
+      } catch (error) {
+        this.$message.error(error);
+      }
     },
     treeClick(e) {
       console.log(e);
@@ -1423,6 +1431,8 @@
           this.Formlist = res.data.data.filter(item => {
             return item.codeclassifyoid == this.nodeClickList.oid
           })
+          this.crudLCStatus=this.Formlist[this.selectRow].lcStatus;
+          this.crudArray.push(this.Formlist[this.selectRow]);
           gridCodeClassifyTemplateAttr({'conditionMap[classifyTemplateOid]':  res.data.data[this.selectRow].oid,limit:-1}).then(res => {
             this.ProData = res.data.data;
             //鍒嗙被娉ㄥ叆鏁版嵁鏍煎紡
diff --git a/Source/UBCS-WEB/src/components/Theme/ThemeTemplatePro.vue b/Source/UBCS-WEB/src/components/Theme/ThemeTemplatePro.vue
index e9693d8..dbfef25 100644
--- a/Source/UBCS-WEB/src/components/Theme/ThemeTemplatePro.vue
+++ b/Source/UBCS-WEB/src/components/Theme/ThemeTemplatePro.vue
@@ -13,6 +13,7 @@
     </span>
   </basic-container>
 
+
 </template>
 
 <script>
diff --git a/Source/UBCS-WEB/src/views/modeling/originalAdd.vue b/Source/UBCS-WEB/src/views/modeling/originalAdd.vue
index 14cea7e..73f633b 100644
--- a/Source/UBCS-WEB/src/views/modeling/originalAdd.vue
+++ b/Source/UBCS-WEB/src/views/modeling/originalAdd.vue
@@ -6,7 +6,7 @@
             <el-form ref="form" :model="attribute" show-message="true" inline size="medium" label-suffix=":"
                 class="attributeForm" :rules="rules" @resetFields="resetAttributeForm" status-icon="true">
                 <el-form-item label="灞炴�х紪鍙�" label-width="100px" prop="id">
-                    <el-input v-model="attribute.id" maxlength="15" show-word-limit type="text"></el-input>
+                    <el-input v-model="attribute.id" maxlength="30" show-word-limit type="text"></el-input>
                 </el-form-item>
                 <el-form-item label="灞炴�у悕绉�" label-width="100px" prop="name">
                     <el-input v-model="attribute.name"></el-input>
@@ -153,7 +153,7 @@
                 id: [
                     { required: true, message: '璇疯緭鍏ュ睘鎬х紪鍙�', trigger: 'blur' },
                     { pattern: /^[A-Za-z]+$/, message: '灞炴�х紪鍙峰彧鑳戒负鑻辨枃', trigger: 'blur' },
-                    { min: 2, max: 15, message: '闀垮害鍦�2鍒�15涓瓧绗�', trigger: 'blur' }
+                    { min: 2, max: 30, message: '闀垮害鍦�2鍒�30涓瓧绗�', trigger: 'blur' }
                 ],
                 name: [
                     { required: true, message: '璇疯緭鍏ュ睘鎬у悕绉�', trigger: 'blur' }
@@ -382,9 +382,9 @@
                     this.btmRefer.btmPage.total = res.data.data.total;
                 })
             }
-            if (this.attribute.referTypeKey == 'linkType') {
-
-            }
+            // if (this.attribute.referTypeKey == 'linkType') {
+            //
+            // }
         },
         // 鏋氫妇绫诲瀷杈撳叆妗嗚幏寰楃劍鐐规椂鐨勪簨浠�
         openEnumConfig() {
diff --git a/Source/UBCS-WEB/vue.config.js b/Source/UBCS-WEB/vue.config.js
index 54a1f5d..853f29f 100644
--- a/Source/UBCS-WEB/vue.config.js
+++ b/Source/UBCS-WEB/vue.config.js
@@ -26,10 +26,11 @@
     proxy: {
       '/api': {
         //鏈湴鏈嶅姟鎺ュ彛鍦板潃
-        target: 'http://localhost:37000',
+        // target: 'http://localhost:37000',
         // target: 'http://192.168.1.51:37000',
-        // target: 'http://dev.vci-tech.com:37000',
+        target: 'http://dev.vci-tech.com:37000',
         // target: 'http://192.168.1.104:37000',
+        // target: 'http://192.168.0.103:37000',
         // target: 'http://192.168.1.63:37000',
         // target: 'http://192.168.3.7:37000',
         //杩滅▼婕旂ず鏈嶅姟鍦板潃,鍙敤浜庣洿鎺ュ惎鍔ㄩ」鐩�
diff --git a/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java b/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java
index 719627b..8f93c96 100644
--- a/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java
+++ b/Source/UBCS/ubcs-service/ubcs-code/src/main/java/com/vci/ubcs/code/service/impl/MdmEngineServiceImpl.java
@@ -3672,7 +3672,48 @@
         } else {
             if (StringUtils.isNotBlank(referConfigVO.getParentFieldName()) && StringUtils.isNotBlank(queryObject.getParentOid())) {
                 queryObject.getConditionMap().put(referConfigVO.getParentFieldName(), queryObject.getParentOid());
-            }
+				//鏌ヨ鍏ㄩ儴鐨勪俊鎭�
+				String parentOidSql = "";
+				if (StringUtils.isNotBlank(referConfigVO.getParentValue())) {
+					String temp = referConfigVO.getParentValue();
+					if (temp.startsWith(QueryOptionConstant.IN)) {
+						temp = temp.substring((QueryOptionConstant.IN).length()).trim();
+						parentOidSql = " in " + "('" + queryObject.getParentOid() + "')";
+					} else if (temp.startsWith(QueryOptionConstant.NOTIN)) {
+						parentOidSql = " not in " + "('" + queryObject.getParentOid() + "')";
+					} else if (temp.startsWith(QueryOptionConstant.NOTEQUAL)) {
+						temp = temp.substring((QueryOptionConstant.NOTEQUAL).length()).trim();
+						parentOidSql = QueryOptionConstant.NOTEQUAL + " " + ((temp.startsWith("'") && temp.endsWith("'")) ? temp : "'" + temp + "'");
+					} else if (temp.startsWith(QueryOptionConstant.MORETHAN)) {
+						temp = temp.substring((QueryOptionConstant.MORETHAN).length()).trim();
+						parentOidSql = QueryOptionConstant.MORETHAN + " " + ((temp.startsWith("'") && temp.endsWith("'")) ? temp : "'" + temp + "'");
+					} else if (temp.startsWith(QueryOptionConstant.MORE)) {
+						temp = temp.substring((QueryOptionConstant.MORE).length()).trim();
+						parentOidSql = QueryOptionConstant.MORE + " " + ((temp.startsWith("'") && temp.endsWith("'")) ? temp : "'" + temp + "'");
+					} else if (temp.startsWith(QueryOptionConstant.LESSTHAN)) {
+						temp = temp.substring((QueryOptionConstant.LESSTHAN).length()).trim();
+						parentOidSql = QueryOptionConstant.LESSTHAN + " " + ((temp.startsWith("'") && temp.endsWith("'")) ? temp : "'" + temp + "'");
+					} else if (temp.startsWith(QueryOptionConstant.LESS)) {
+						temp = temp.substring((QueryOptionConstant.LESS).length()).trim();
+						parentOidSql = QueryOptionConstant.LESS + " " + ((temp.startsWith("'") && temp.endsWith("'")) ? temp : "'" + temp + "'");
+					} else if (temp.startsWith(QueryOptionConstant.ISNOTNULL)) {
+						parentOidSql = " is not null";
+					} else if (temp.startsWith(QueryOptionConstant.ISNULL)) {
+						parentOidSql = " is  null";
+					} else if (temp.contains("*")) {
+						parentOidSql = " like " + ((temp.startsWith("'") && temp.endsWith("'")) ? temp : "'" + temp + "'").replace("*", "%");
+					} else {
+						parentOidSql = " = " + ((temp.startsWith("'") && temp.endsWith("'")) ? temp : "'" + temp + "'");
+					}
+
+				}
+				//鏌ヨ鍏ㄩ儴鐨勪俊鎭�
+				queryObject.getConditionMap().put("oid", QueryOptionConstant.IN + "(select oid from " +
+					getTableName(referConfigVO.getReferType()) +
+					" START WITH " + referConfigVO.getParentFieldName() + " " +
+					parentOidSql +
+					" CONNECT BY PRIOR " + oidFieldName + " = " + referConfigVO.getParentFieldName() + ")");
+			}
         }
         LambdaQueryWrapper<CodeClassify> lqw = new LambdaQueryWrapper<>();
         String sql = queryObject.getConditionMap().get("oid").substring(3);
diff --git a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/dll/DllDmMapperProcessor.java b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/dll/DllDmMapperProcessor.java
index 839f8a7..b4ece98 100644
--- a/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/dll/DllDmMapperProcessor.java
+++ b/Source/UBCS/ubcs-service/ubcs-ddl/src/main/java/com/vci/ubcs/ddl/processor/dll/DllDmMapperProcessor.java
@@ -42,6 +42,7 @@
 		FIELD_MAP.put(VciFieldTypeEnum.VTFilePath, new DdlFieldMappingAttrBO("TEXT", null, null, true, null));
 		FIELD_MAP.put(VciFieldTypeEnum.VTClob, new DdlFieldMappingAttrBO("CLOB", 100, null, true, null));
 		FIELD_MAP.put(VciFieldTypeEnum.VTString, new DdlFieldMappingAttrBO("VARCHAR", 255, null, true, null));
+		FIELD_MAP.put(VciFieldTypeEnum.VTString, new DdlFieldMappingAttrBO("VARCHAR2", 255, null, true, null));
 	}
 
 	public DllDmMapperProcessor() {

--
Gitblit v1.9.3