From 8c9f15cc8a3c3e6f4a4404574d39732b624289a6 Mon Sep 17 00:00:00 2001
From: ludc
Date: 星期五, 13 九月 2024 14:59:08 +0800
Subject: [PATCH] 代码提交

---
 Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/UIManagerServiceImpl.java |  469 +++++++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 440 insertions(+), 29 deletions(-)

diff --git a/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/UIManagerServiceImpl.java b/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/UIManagerServiceImpl.java
index b58b9f9..d53f1b4 100644
--- a/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/UIManagerServiceImpl.java
+++ b/Source/plt-web/plt-web-parent/plt-web/src/main/java/com/vci/web/service/impl/UIManagerServiceImpl.java
@@ -11,8 +11,10 @@
 import com.vci.corba.portal.data.*;
 import com.vci.dto.RoleRightDTO;
 import com.vci.dto.UIAuthorDTO;
+import com.vci.frameworkcore.compatibility.SmRoleQueryServiceI;
 import com.vci.model.PLDefination;
 import com.vci.pagemodel.*;
+import com.vci.starter.poi.bo.SheetDataSet;
 import com.vci.starter.poi.bo.WriteExcelData;
 import com.vci.starter.poi.bo.WriteExcelOption;
 import com.vci.starter.poi.util.ExcelUtil;
@@ -33,13 +35,21 @@
 import com.vci.web.util.UITools;
 import lombok.AllArgsConstructor;
 import lombok.NoArgsConstructor;
+import org.apache.poi.hssf.usermodel.HSSFCell;
+import org.apache.poi.hssf.usermodel.HSSFRow;
+import org.apache.poi.hssf.usermodel.HSSFSheet;
+import org.apache.poi.hssf.usermodel.HSSFWorkbook;
 import org.slf4j.Logger;
 import org.slf4j.LoggerFactory;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.stereotype.Service;
 import org.springframework.web.multipart.MultipartFile;
 import javax.annotation.Resource;
+import javax.swing.*;
 import java.io.File;
+import java.io.FileInputStream;
+import java.io.FileNotFoundException;
+import java.io.IOException;
 import java.util.*;
 import java.util.concurrent.atomic.AtomicBoolean;
 import java.util.concurrent.atomic.AtomicInteger;
@@ -380,11 +390,11 @@
         //鐣岄潰娌′紶鍚嶇О锛屼娇鐢ㄩ粯璁ゅ鍑哄悕绉�
         String exportFileName = "UI涓婁笅鏂囧鍑篲" + Func.format(new Date(),"yyyy-MM-dd HHmmss.sss");
         //璁剧疆鍒楀悕
-        List<String> columns = Arrays.asList(
+        /*List<String> columns = Arrays.asList(
                 "鎵�灞炰笟鍔$被鍨�","鍚嶇О", "UI涓婁笅鏂�", "瀵艰埅鍖�", "鎺у埗鍖�","鎿嶄綔鍖�",
                 "椤电搴忓彿","鍖哄煙缂栫爜","鍖哄煙鍚嶇О","鏄惁鍚敤","鏄剧ず琛ㄨ揪寮�", "UI瑙f瀽绫�",
                 "鎵╁睍灞炴��", "鎻忚堪","椤甸潰璁捐淇℃伅","椤甸潰涓嬮厤缃殑鎸夐挳"
-        );
+        );*/
 
         //鍐檈xcel
         String excelPath = LocalFileUtil.getDefaultTempFolder() + File.separator + exportFileName +  ".xls";
@@ -394,58 +404,114 @@
             throw new VciBaseException(LangBaseUtil.getErrorMsg(e), new String[]{excelPath}, e);
         }
         //璁剧疆鍒�
-        List<WriteExcelData> excelDataList = new ArrayList<>();
+        List<WriteExcelData> pldDataList = new ArrayList<>();
+        List<WriteExcelData> tpDataList = new ArrayList<>();
+        List<WriteExcelData> pdDataList = new ArrayList<>();
+        List<WriteExcelData> tbDataList = new ArrayList<>();
+        List<WriteExcelData> cpDataList = new ArrayList<>();
         //璁剧疆鍒楀ご
-        for (int index = 0; index < columns.size(); index++) {
+        /*for (int index = 0; index < columns.size(); index++) {
             excelDataList.add(new WriteExcelData(0,index, columns.get(index)));
-        }
-        AtomicInteger row = new AtomicInteger(1);
+        }*/
+        AtomicInteger pldRow = new AtomicInteger(0);
+        AtomicInteger tpRow = new AtomicInteger(0);
+        AtomicInteger pdRow = new AtomicInteger(0);
+        AtomicInteger tbRow = new AtomicInteger(0);
+        AtomicInteger cpRow = new AtomicInteger(0);
+
         expConditionMap.entrySet().stream().forEach(item->{
             //key瀛樻斁鐨剈i涓婁笅鏂囩殑id
             try {
                 PLUILayout pluiLayout = platformClientUtil.getUIService().getPLUILayoutById(item.getKey());
+                pldDataList.add(new WriteExcelData(pldRow.get(),0, pluiLayout.plOId));
+                pldDataList.add(new WriteExcelData(pldRow.get(),1, pluiLayout.plCode));
+                pldDataList.add(new WriteExcelData(pldRow.get(),2, pluiLayout.plName));
+                pldDataList.add(new WriteExcelData(pldRow.get(),3, pluiLayout.plRelatedType));
+                pldDataList.add(new WriteExcelData(pldRow.get(),4, pluiLayout.plIsShowForm));
+                pldDataList.add(new WriteExcelData(pldRow.get(),5, pluiLayout.plIsShowNavigator));
+                pldDataList.add(new WriteExcelData(pldRow.get(),6, pluiLayout.plIsShowTab));
+                pldRow.getAndIncrement();
+
                 //value涓瓨鏀剧殑澶氫釜浠ラ�楀彿闂撮殧鐨勯〉绛緄d,閫氳繃杩欎釜id鏌ヨ鍑哄叾涓嬬殑椤甸潰璁捐鍜屾寜閽厤缃�
                 List<String> plTabPageOIds = Arrays.asList(item.getValue().split(","));
                 if(Func.isNotEmpty(pluiLayout) && Func.isNotBlank(pluiLayout.plOId) && Func.isNotEmpty(plTabPageOIds)){
                     PLTabPage[] plTabPages = platformClientUtil.getUIService().getPLTabPagesByPageDefinationOId(pluiLayout.plOId);
                     List<PLTabPage> filterTabPages = Arrays.stream(plTabPages).filter(plTabPage -> plTabPageOIds.contains(plTabPage.plOId)).collect(Collectors.toList());
                     filterTabPages.stream().forEach(tabPage->{
-                        excelDataList.add(new WriteExcelData(row.get(),0, pluiLayout.plRelatedType));
-                        excelDataList.add(new WriteExcelData(row.get(),1, pluiLayout.plName));
-                        excelDataList.add(new WriteExcelData(row.get(),2, pluiLayout.plCode));
-                        excelDataList.add(new WriteExcelData(row.get(),3, pluiLayout.plIsShowForm));
-                        excelDataList.add(new WriteExcelData(row.get(),4, pluiLayout.plIsShowNavigator));
-                        excelDataList.add(new WriteExcelData(row.get(),5, pluiLayout.plIsShowTab));
-                        excelDataList.add(new WriteExcelData(row.get(),6, tabPage.plSeq));
-                        excelDataList.add(new WriteExcelData(row.get(),7, tabPage.plLabel));
-                        excelDataList.add(new WriteExcelData(row.get(),8, tabPage.plName));
-                        excelDataList.add(new WriteExcelData(row.get(),9, tabPage.plIsOpen));
-                        excelDataList.add(new WriteExcelData(row.get(),10, tabPage.plOpenExpression));
-                        excelDataList.add(new WriteExcelData(row.get(),11, tabPage.plUIParser));
-                        excelDataList.add(new WriteExcelData(row.get(),12, tabPage.plExtAttr));
-                        excelDataList.add(new WriteExcelData(row.get(),13, tabPage.plDesc));
+                        //鍖哄煙瀹氫箟
+                        tpDataList.add(new WriteExcelData(tpRow.get(),0, tabPage.plOId));
+                        tpDataList.add(new WriteExcelData(tpRow.get(),1, tabPage.plSeq));
+                        tpDataList.add(new WriteExcelData(tpRow.get(),2, tabPage.plLabel));
+                        tpDataList.add(new WriteExcelData(tpRow.get(),3, tabPage.plName));
+                        tpDataList.add(new WriteExcelData(tpRow.get(),4, tabPage.plContextOId));
+                        tpDataList.add(new WriteExcelData(tpRow.get(),5, tabPage.plIsOpen));
+                        tpDataList.add(new WriteExcelData(tpRow.get(),6, tabPage.plOpenExpression));
+                        tpDataList.add(new WriteExcelData(tpRow.get(),7, tabPage.plUIParser));
+                        tpDataList.add(new WriteExcelData(tpRow.get(),8, tabPage.plExtAttr));
+                        tpDataList.add(new WriteExcelData(tpRow.get(),9, tabPage.plDesc));
+                        tpRow.getAndIncrement();
                         try {
                             PLPageDefination[] plPageDefinations = platformClientUtil.getUIService().getPLPageDefinationsByPageContextOId(tabPage.plOId);
                             if(Func.isNotEmpty(plPageDefinations)){
-                                excelDataList.add(new WriteExcelData(row.get(),14, JSON.toJSONString(plPageDefinations)));
-                                List<PLTabButtonVO> tabButtonsTotal = new ArrayList<>();
+                                //List<PLTabButtonVO> tabButtonsTotal = new ArrayList<>();
                                 Arrays.stream(plPageDefinations).forEach(plPageDefination->{
-                                    List<PLTabButtonVO> tabButtons = this.getTabButtons(plPageDefination.plOId);
-                                    tabButtonsTotal.addAll(tabButtons);
+                                    pdDataList.add(new WriteExcelData(pdRow.get(),0, plPageDefination.plOId));
+                                    pdDataList.add(new WriteExcelData(pdRow.get(),1, plPageDefination.plTabPageOId));
+                                    pdDataList.add(new WriteExcelData(pdRow.get(),2, plPageDefination.plType));
+                                    pdDataList.add(new WriteExcelData(pdRow.get(),3, plPageDefination.name));
+                                    pdDataList.add(new WriteExcelData(pdRow.get(),4, plPageDefination.desc));
+                                    pdDataList.add(new WriteExcelData(pdRow.get(),5, plPageDefination.seq));
+                                    pdDataList.add(new WriteExcelData(pdRow.get(),6, plPageDefination.plDefination));
+                                    pdRow.getAndIncrement();
+                                    //鏌ヨ鎸夐挳
+                                    try {
+                                        PLTabButton[] tabButtons = platformClientUtil.getUIService().getPLTabButtonsByTableOId(plPageDefination.plOId);
+                                        for (PLTabButton tabButton:tabButtons){
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),0, tabButton.plOId));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),1, tabButton.plTableOId));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),2, tabButton.plPageOId));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),3, tabButton.plActionOId));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),4, tabButton.plLabel));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),5, tabButton.plAreaType));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),6, tabButton.plDesc));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),7, tabButton.plSeq));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),8, tabButton.plParentOid));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),9, tabButton.displayMode));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),10, tabButton.iconPath));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),11, tabButton.authorization));
+                                            tbDataList.add(new WriteExcelData(tbRow.get(),12, tabButton.show));
+                                            tbRow.getAndIncrement();
+                                            PLCommandParameter[] parameters = platformClientUtil.getUIService().getPLCommandParametersByCommandOId(tabButton.plOId);
+                                            if(Func.isNotEmpty(parameters)){
+                                                Arrays.stream(parameters).forEach(param->{
+                                                    cpDataList.add(new WriteExcelData(cpRow.get(),0, param.plOId));
+                                                    cpDataList.add(new WriteExcelData(cpRow.get(),1, param.plCommandOId));
+                                                    cpDataList.add(new WriteExcelData(cpRow.get(),2, param.plKey));
+                                                    cpDataList.add(new WriteExcelData(cpRow.get(),3, param.plValue));
+                                                    cpRow.getAndIncrement();
+                                                });
+                                            }
+                                        }
+                                    } catch (PLException e) {
+                                        e.printStackTrace();
+                                    }
                                 });
-                                excelDataList.add(new WriteExcelData(row.get(),15, JSON.toJSONString(tabButtonsTotal)));
                             }
                         } catch (PLException e) {
                             e.printStackTrace();
                         }
-                        row.getAndIncrement();
                     });
                 }
             } catch (PLException e) {
                 e.printStackTrace();
             }
         });
-        WriteExcelOption excelOption = new WriteExcelOption(excelDataList);
+        WriteExcelOption excelOption = new WriteExcelOption();
+        excelOption.addSheetDataList("PlpageLayoutDefnation",pldDataList);
+        excelOption.addSheetDataList("Pltabpage",tpDataList);
+        excelOption.addSheetDataList("Plpagedefination",pdDataList);
+        excelOption.addSheetDataList("Pltabbutton",tbDataList);
+        excelOption.addSheetDataList("PlcommondParam",cpDataList);
         ExcelUtil.writeDataToFile(excelPath, excelOption);
         return excelPath;
     }
@@ -453,13 +519,358 @@
     /**
      * 瀵煎叆UI涓婁笅鏂�
      * @param file
+     * @param isCovered 鏄惁瑕嗙洊
+     * @param selectBtm 閫夋嫨鐨勪笟鍔$被鍨�
      * @return
      */
     @Override
-    public BaseResult impUIContextData(MultipartFile file) {
+    public BaseResult impUIContextData(File file,boolean isCovered,String selectBtm) {
+        /*VciBaseUtil.alertNotNull(file,"excel鏂囦欢");
+        if(!file.exists()){
+            throw new VciBaseException("瀵煎叆鐨別xcel鏂囦欢涓嶅瓨鍦�,{0}",new String[]{file.getPath()});
+        }
+        //璇诲彇excel琛�
+        List<SheetDataSet> sheetDataSets = ExcelUtil.readDataObjectFromExcel(file);
 
+        try {
+            PLUILayout[] plpagelayoutdefinations = null;
+            try {
+                SheetDataSet plpagelayoutdefnationsheet = sheetDataSets.get(0);
+                SheetDataSet pltabpagesheet = sheetDataSets.get(1);
+                SheetDataSet plpagedefinationsheet = sheetDataSets.get(2);
+                SheetDataSet pltabbuttonsheet = sheetDataSets.get(3);
+                SheetDataSet plcommondparamsheet = sheetDataSets.get(4);
 
+                *//*HSSFSheet plpagelayoutdefnationsheet = readworkbook.getSheet("PlpageLayoutDefnation");
+                HSSFSheet pltabpagesheet = readworkbook.getSheet("Pltabpage");
+                HSSFSheet plpagedefinationsheet = readworkbook.getSheet("Plpagedefination");
+                HSSFSheet pltabbuttonsheet = readworkbook.getSheet("Pltabbutton");
+                HSSFSheet plcommondparamsheet = readworkbook.getSheet("PlcommondParam");*//*
 
+                SessionInfo sessionInfo = WebThreadLocalUtil.getCurrentUserSessionInfoInThread();
+
+                Map<PLUILayout,List<PLTabPage>> pdMap = new HashMap<>();
+                Map<PLTabPage,List<PLPageDefination>> tdMap = new HashMap<>();
+                Map<PLPageDefination,List<PLTabButton>> dbMap = new HashMap<>();
+                Map<PLTabButton,List<PLCommandParameter>> bcMap = new HashMap<>();
+
+                List<PLUILayout> plpagelayoutdefinationList = new ArrayList<PLUILayout>();
+                List<PLTabPage> pltabpagelist = new ArrayList<PLTabPage>();
+                List<PLPageDefination> plpagedefinationlist = new ArrayList<PLPageDefination>();
+                List<PLTabButton> pltabbuttonlist = new ArrayList<PLTabButton>();
+                List<PLCommandParameter> plcommandparameterlist = new ArrayList<PLCommandParameter>();
+
+                StringBuffer checkplpagelayoutdefination = new StringBuffer();
+                StringBuffer checkplpagelayoutdefinationPlcode = new StringBuffer();
+                StringBuffer plActionIDNulls = new StringBuffer();
+
+                //add by caill start 鍒濆鍖栨爣璁�
+                int count=0;
+                int preCount=0;
+                String preOID="";
+                String doublePreOID="";
+                //add by caill end
+                PLAction[] allPLAction = platformClientUtil.getUIService().getAllPLAction();
+                Map<String,String> relation = null;
+                for(int i=0;i<=plpagelayoutdefnationsheet.getLastRowNum();i++){
+                    pltabpagelist = new ArrayList<PLTabPage>();
+                    PLUILayout p = new PLUILayout();
+                    HSSFRow readrow = plpagelayoutdefnationsheet.getRow(i);
+                    if(readrow==null){
+                        break;
+                    }
+
+                    plpagelayoutdefinations = platformClientUtil.getUIService().getPLUILayoutsByRelatedType(btmName);
+
+                    p.plOId = ObjectUtility.getNewObjectID36();
+                    HSSFCell readcell = readrow.getCell(0);
+                    p.plName = readcell.getStringCellValue();
+                    readcell = readrow.getCell(1);
+                    p.plCode = readcell.getStringCellValue();
+                    //add by caill start
+                    //閬嶅巻UI鍚嶇О
+                    for(PLUILayout pd : plpagelayoutdefinations){
+                        if(pd.plName.equals(p.plName) && isCovered){
+                            throw new VciBaseException(pd.plName+"鍚嶇О宸茬粡瀛樺湪,鏄惁瑕嗙洊?");
+                        }
+                        //鏍规嵁UI涓婁笅鏂囧仛鍒ゆ柇
+                        if(pd.plCode.equals(p.plCode)){
+                            count=1;
+                            preOID=pd.plOId;  //濡傛灉UI涓婁笅鏂囩浉鍚岋紝灏辨妸绯荤粺涓殑id璧嬪�肩粰鏂板鍏ョ殑id
+                            p.plOId=pd.plOId;
+                        }
+                    }
+                    //add by caill end
+                    readcell = readrow.getCell(2);
+                    plpageLayoutDefinationId = readcell.getStringCellValue();
+                    readcell = readrow.getCell(3);
+                    String name = readcell.getStringCellValue();
+                    readcell = readrow.getCell(4);
+                    p.plRelatedType = readcell.getStringCellValue();
+                    readcell = readrow.getCell(5);
+                    p.plIsShowNavigator = (short) readcell.getNumericCellValue();
+                    readcell = readrow.getCell(6);
+                    p.plIsShowTab = (short) readcell.getNumericCellValue();
+                    readcell = readrow.getCell(7);
+                    p.plIsShowForm = (short) readcell.getNumericCellValue();
+                    //閫夋嫨鐨勫拰瀵煎叆鐨勪笟鍔$被鍨嬭妭鐐逛笉涓�鑷�
+                    if(!selectBtm.equals(name)){
+                        throw new VciBaseException("璇烽�夋嫨瑕佸鍏ョ殑绫诲瀷鑺傜偣鍚嶇О锛�");
+                    }
+
+                    plpagelayoutdefinationList.add(p);
+                    for(int j=0;j<=pltabpagesheet.getLastRowNum();j++){
+                        plpagedefinationlist = new ArrayList<PLPageDefination>();
+                        PLTabPage pt = new PLTabPage();
+                        HSSFRow readrow1 = pltabpagesheet.getRow(j);
+                        if(readrow1==null){
+                            break;
+                        }
+                        pt.plOId = ObjectUtility.getNewObjectID36();
+                        HSSFCell readcell1 = readrow1.getCell(0);
+                        pt.plName = readcell1.getStringCellValue();
+                        readcell1 = readrow1.getCell(1);
+                        pt.plCode = readcell1.getStringCellValue();
+                        //add by caill start
+                        if(count==1) {
+                            PLTabPage[] PLTabPages = platformClientUtil.getUIService().getPLTabPagesByPageDefinationOId(preOID);
+                            //閬嶅巻鎺у埗鍖鸿〃鏍�
+                            for(PLTabPage pl : PLTabPages){
+                                if(pl.plCode.equals(pt.plCode)){
+                                    pt.plOId=pl.plOId; //濡傛灉鎺у埗鍖鸿〃鏍肩殑缂栫爜鍜屽鍏ョ殑缂栫爜涓�鏍凤紝灏辨妸鎺у埗鍖篿d璧嬪�肩粰鏂板鍏ョ殑id
+                                    preCount=1;
+                                    doublePreOID=pl.plOId;
+                                }
+                            }
+                        }
+                        //add by caill end
+                        readcell1 = readrow1.getCell(2);
+                        pt.plSeq = (short) readcell1.getNumericCellValue();
+                        readcell1 = readrow1.getCell(3);
+                        pt.plContextOId = readcell1.getStringCellValue();
+                        readcell1 = readrow1.getCell(4);
+                        pt.plDesc = readcell1.getStringCellValue();
+                        readcell1 = readrow1.getCell(5);
+                        pt.plIsOpen = (short) readcell1.getNumericCellValue();
+                        readcell1 = readrow1.getCell(6);
+                        pt.plAreaType = (short) readcell1.getNumericCellValue();
+                        readcell1 = readrow1.getCell(7);
+                        pt.plOpenExpression = readcell1.getStringCellValue();
+                        readcell1 = readrow1.getCell(8);
+                        pt.plLicensOrs = readcell1.getStringCellValue();
+                        readcell1 = readrow1.getCell(9);
+                        pt.plLabel = readcell1.getStringCellValue();
+                        readcell1 = readrow1.getCell(10);
+                        String plPageContextOId = readcell1.getStringCellValue();
+                        if(pt.plContextOId.equals(plpageLayoutDefinationId)){
+                            pt.plContextOId = p.plOId;
+                            pltabpagelist.add(pt);
+                            for(int k=0;k<=plpagedefinationsheet.getLastRowNum();k++){
+                                pltabbuttonlist = new ArrayList<PLTabButton>();
+                                PLPageDefination plpagedefination  = new PLPageDefination();
+                                HSSFRow readrow2 = plpagedefinationsheet.getRow(k);
+                                if(readrow2==null){
+                                    break;
+                                }
+                                plpagedefination.plOId = ObjectUtility.getNewObjectID36();
+                                HSSFCell readcell2 = readrow2.getCell(0);
+                                plpagedefination.name = readcell2.getStringCellValue();
+                                //add by caill start
+                                //鏈�鍚庝竴绾х殑鍒ゆ柇
+                                if(preCount==1) {
+                                    PLPageDefination[] PLPageDefinations = platformClientUtil.getUIService().getPLPageDefinationsByPageContextOId(doublePreOID);
+                                    for(PLPageDefination plp : PLPageDefinations) {
+                                        if(plp.name.equals(plpagedefination.name)) {
+                                            plpagedefination.plOId=plp.plOId;
+
+                                        }
+
+                                    }
+                                }
+                                //add by caill end
+                                readcell2 = readrow2.getCell(1);
+                                plpagedefination.plDefination = readcell2.getStringCellValue();
+                                readcell2 = readrow2.getCell(2);
+                                plpagedefination.seq = (short) readcell2.getNumericCellValue();
+                                readcell2 = readrow2.getCell(3);
+                                plpagedefination.plTabPageOId = readcell2.getStringCellValue();
+                                readcell2 = readrow2.getCell(4);
+                                plpagedefination.desc = readcell2.getStringCellValue();
+                                readcell2 = readrow2.getCell(5);
+                                plpagedefination.plType = (short) readcell2.getNumericCellValue();
+                                readcell2 = readrow2.getCell(6);
+                                plTableOId = readcell2.getStringCellValue();
+                                if(plpagedefination.plTabPageOId.equals(plPageContextOId)){
+                                    plpagedefination.plTabPageOId = pt.plOId;
+                                    plpagedefinationlist.add(plpagedefination);
+                                    //淇濆瓨鏂版棫oid鐨勫叧绯伙紝鍦ㄧ‘瀹氬眰绾у叧绯绘椂浣跨敤
+                                    relation = new HashMap<String,String>();
+                                    for(int a=0;a<=pltabbuttonsheet.getLastRowNum();a++){
+                                        HSSFRow readrow3 = pltabbuttonsheet.getRow(a);
+                                        if(readrow3!=null){
+                                            HSSFCell readcell3 = readrow3.getCell(7);
+                                            plCommandOId = readcell3.getStringCellValue();
+                                            String newOId = ObjectUtility.getNewObjectID36();
+                                            relation.put(plCommandOId, newOId);
+                                        }
+                                    }
+                                    for(int a=0;a<=pltabbuttonsheet.getLastRowNum();a++){
+                                        plcommandparameterlist = new ArrayList<PLCommandParameter>();
+                                        PLTabButton plTabButton = new PLTabButton();
+                                        HSSFRow readrow3 = pltabbuttonsheet.getRow(a);
+                                        if(readrow3==null){
+                                            break;
+                                        }
+                                        plTabButton.plOId = ObjectUtility.getNewObjectID36();
+                                        HSSFCell readcell3 = readrow3.getCell(0);
+                                        plTabButton.plLabel = readcell3.getStringCellValue();
+                                        readcell3 = readrow3.getCell(1);
+                                        plTabButton.plAreaType = readcell3.getStringCellValue();
+                                        readcell3 = readrow3.getCell(2);
+                                        plTabButton.plTableOId = readcell3.getStringCellValue();
+                                        readcell3 = readrow3.getCell(3);
+                                        plTabButton.plSeq = (short) readcell3.getNumericCellValue();
+                                        String plActionId = "";
+                                        //PLAction[] allPLAction = Tool.getService().getAllPLAction();
+                                        for(PLAction action : allPLAction){
+                                            if((readrow3.getCell(4).getStringCellValue()!=null&&!"".equals(readrow3.getCell(4).getStringCellValue())
+                                            )&&(readrow3.getCell(4).getStringCellValue().trim().equals(action.plCode.trim()))
+                                            ){
+                                                plActionId = action.plOId;
+                                                break;
+                                            }
+                                        }
+                                        if(plActionId==null||"".equals(plActionId)){
+                                            if(!plActionIDNulls.toString().contains(readrow3.getCell(4).getStringCellValue())){
+                                                plActionIDNulls.append("\n\tAction缂栧彿:"+readrow3.getCell(4).getStringCellValue());
+                                            }
+                                        }
+                                        plTabButton.plActionOId = plActionId;
+                                        readcell3 = readrow3.getCell(5);
+                                        plTabButton.plAreaType = readcell3.getStringCellValue();
+                                        readcell3 = readrow3.getCell(6);
+                                        plTabButton.plDesc = readcell3.getStringCellValue();
+                                        readcell3 = readrow3.getCell(8);
+                                        String parentOid = readcell3.getStringCellValue();//鐖秓id
+                                        readcell3 = readrow3.getCell(7);
+                                        plCommandOId = readcell3.getStringCellValue();
+                                        readcell3 = readrow3.getCell(9);
+                                        if(readcell3 != null) {
+                                            plTabButton.displayMode = readcell3.getStringCellValue();
+                                        }
+                                        readcell3 = readrow3.getCell(10);
+                                        if(readcell3 != null) {
+                                            plTabButton.iconPath = readcell3.getStringCellValue();
+                                        }
+                                        readcell3 = readrow3.getCell(11);
+                                        if(readcell3 != null) {
+                                            plTabButton.authorization = readcell3.getStringCellValue();
+                                        }
+                                        readcell3 = readrow3.getCell(12);
+                                        if(readcell3 != null) {
+                                            plTabButton.show = readcell3.getStringCellValue();
+                                        }
+                                        //璧嬩簣淇濆瓨濂界殑鍊硷紝鏉ヤ繚璇佸眰绾у叧绯讳笉浼氫涪澶�
+                                        plTabButton.plOId = relation.get(plCommandOId);
+                                        if(parentOid != null && parentOid.length() > 0) {
+                                            plTabButton.plParentOid =
+                                                    relation.get(parentOid) == null ? "" : relation.get(parentOid);
+                                        }
+                                        if(plTabButton.plTableOId.equals(plTableOId)){
+                                            plTabButton.plTableOId = plpagedefination.plOId;
+                                            pltabbuttonlist.add(plTabButton);
+                                            for(int b=0;b<=plcommondparamsheet.getLastRowNum();b++){
+                                                PLCommandParameter plCommandParameter = new PLCommandParameter();
+                                                HSSFRow readrow4 = plcommondparamsheet.getRow(b);
+                                                if(readrow4==null){
+                                                    break;
+                                                }
+                                                plCommandParameter.plOId = ObjectUtility.getNewObjectID36();
+                                                HSSFCell readcell4 = readrow4.getCell(0);
+                                                plCommandParameter.plCommandOId = readcell4.getStringCellValue();
+                                                readcell4 = readrow4.getCell(1);
+                                                plCommandParameter.plKey = readcell4.getStringCellValue();
+                                                readcell4 = readrow4.getCell(2);
+                                                plCommandParameter.plValue = readcell4.getStringCellValue();
+                                                if(plCommandParameter.plCommandOId.equals(plCommandOId)){
+                                                    plCommandParameter.plCommandOId = plTabButton.plOId;
+                                                    plcommandparameterlist.add(plCommandParameter);
+                                                }
+                                            }
+                                            bcMap.put(plTabButton, plcommandparameterlist);
+                                        }
+                                    }
+                                    dbMap.put(plpagedefination, pltabbuttonlist);
+                                }
+                            }
+                            tdMap.put(pt, plpagedefinationlist);
+                        }
+                    }
+                    pdMap.put(p, pltabpagelist);
+                }
+
+                if(plActionIDNulls.length()>0){
+                    VCIOptionPane.showMessage(PLTApplication.frame, plActionIDNulls.toString()+"涓嶅瓨鍦紒");
+                    return false;
+                }
+
+                //鍒犻櫎鍘熸湁button鏁版嵁
+                if(tdMap.size() > 0) {
+                    for(List<PLPageDefination> list : tdMap.values()) {
+                        for(PLPageDefination ppd : list) {
+                            if(ppd.plOId != null && ppd.plOId.length() > 0) {
+                                PLTabButton[] buttons = platformClientUtil.getUIService().getPLTabButtonsByTableOId(ppd.plOId);
+                                if(buttons != null && buttons.length > 0) {
+                                    for(PLTabButton ptb : buttons) {
+                                        platformClientUtil.getUIService().deletePLTabButtonByID(ptb.plOId);
+                                    }
+                                }
+                            }
+                        }
+                    }
+                }
+
+                for(PLUILayout plPageLayoutDefination : plpagelayoutdefinationList){
+                    List<PLTabPage> pltabpagelists = pdMap.get(plPageLayoutDefination);
+                    for(PLTabPage pltabpage:pltabpagelists){
+                        List<PLPageDefination> plpagedefinationlists = tdMap.get(pltabpage);
+                        for(PLPageDefination plpagedefination : plpagedefinationlists){
+                            List<PLTabButton> pltabbuttons = dbMap.get(plpagedefination);
+                            for(PLTabButton pltabbutton : pltabbuttons){
+                                List<PLCommandParameter> plcommandParams = bcMap.get(pltabbutton);
+                                for(PLCommandParameter plcommandparameter : plcommandParams){
+                                    plcommandparameter.plCreateUser = sessionInfo.getUserId();
+                                    plcommandparameter.plModifyUser = sessionInfo.getUserId();
+                                    platformClientUtil.getUIService().savePLCommandParameter(plcommandparameter);
+                                }
+                                pltabbutton.plCreateUser = sessionInfo.getUserId();
+                                pltabbutton.plModifyUser = sessionInfo.getUserId();
+                                platformClientUtil.getUIService().savePLTabButton(pltabbutton);
+                            }
+                            platformClientUtil.getUIService().savePLPageDefination(plpagedefination);
+                        }
+                        pltabpage.plCreateUser = sessionInfo.getUserId();
+                        pltabpage.plModifyUser = sessionInfo.getUserId();
+                        platformClientUtil.getUIService().savePLTabPage(pltabpage);
+                    }
+                    plPageLayoutDefination.plCreateUser = sessionInfo.getUserId();
+                    plPageLayoutDefination.plModifyUser = sessionInfo.getUserId();
+                    platformClientUtil.getUIService().savePLUILayout(plPageLayoutDefination);
+                }
+                return true;
+            } catch (IOException e) {
+                e.printStackTrace();
+                return false;
+            } catch (PLException e) {
+                e.printStackTrace();
+                return false;
+            }
+        } catch (FileNotFoundException e) {
+            e.printStackTrace();
+            return false;
+        }
+
+*/
 
         return null;
     }
@@ -2532,7 +2943,7 @@
                 }
             } else {
                 // 閾炬帴绫诲瀷涓虹┖鏃讹紝鍙渶瑕佹鏌ヤ笟鍔$被鍨嬩笅鐨勬煡璇㈡ā鏉挎槸鍚︽湁鏁�
-                if(!(super.checkQTNameTxtIsOk("鏌ヨ妯℃澘", queryTemplateName, btmType))){
+                if(!(super.checkQTNameTxtIsOk("鏌ヨ妯℃澘", queryTemplateName, btmType,true))){
                     res = false;
                     return res;
                 }

--
Gitblit v1.9.3