package com.vci.client.portal.NewUI;

import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import javax.swing.JFileChooser;
import javax.swing.filechooser.FileFilter;

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 com.vci.corba.omd.btm.BtmItem;
import com.vci.corba.portal.data.PLAction;
import com.vci.corba.portal.data.PLCommandParameter;
import com.vci.corba.portal.data.PLPageDefination;
import com.vci.corba.portal.data.PLUILayout;
import com.vci.corba.portal.data.PLTabButton;
import com.vci.corba.portal.data.PLTabPage;
import com.vci.client.LogonApplication;
import com.vci.client.bof.ClientBusinessObjectOperation;
import com.vci.client.portal.utility.UITools;
import com.vci.client.ui.swing.VCIOptionPane;
import com.vci.common.utility.ObjectUtility;
import com.vci.corba.common.VCIError;

public class ImportExcel {

	private BtmItem selectTreeNodeobject;
	private String plpageLayoutDefinationId = "";
	private String plPageContextOId = "";
	private String plTableOId = "";
	private String plCommandOId = "";
	HSSFWorkbook readworkbook;
	public ImportExcel(BtmItem selectTreeNodeobject){
		this.selectTreeNodeobject = selectTreeNodeobject;
	}

	public boolean impExcel() {
		JFileChooser jf = new JFileChooser();
		jf.setDialogTitle("打开");
		jf.removeChoosableFileFilter(jf.getFileFilter());
		jf.setFileFilter(new FileFilter() {
			
			@Override
			public String getDescription() {
				return "xls";
			}
			
			@Override
			public boolean accept(File f) {
				if(f.isDirectory()||f.getName().endsWith(".xls")){
					return true;
				}else{
					return false;
				}
			}
		});
		int showOpenDialog = jf.showOpenDialog(LogonApplication.frame);
		String xfileName = "";
		if (showOpenDialog == JFileChooser.APPROVE_OPTION) {
			File file = jf.getSelectedFile();
			xfileName = file.getAbsolutePath();
			if(!xfileName.endsWith(".xls")){
				xfileName = xfileName+".xls";
			}
		}
		try {
			FileInputStream fin = new FileInputStream(xfileName);
			PLUILayout[] plpagelayoutdefinations = null;
			try {
				PLAction[] allPLAction = UITools.getService().getAllPLAction();
				readworkbook = new HSSFWorkbook(fin);
				HSSFSheet btmNamesheet = readworkbook.getSheet("btmName");
				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");
				HSSFSheet plactionsheet = readworkbook.getSheet("PlAction");
				
				Map<PLUILayout,List<PLTabPage>> pdMap = new HashMap<PLUILayout,List<PLTabPage>>();
				Map<PLTabPage,List<PLPageDefination>> tdMap = new HashMap<PLTabPage,List<PLPageDefination>>();
				Map<PLPageDefination,List<PLTabButton>> dbMap = new HashMap<PLPageDefination,List<PLTabButton>>();
				Map<PLTabButton,List<PLCommandParameter>> bcMap = new HashMap<PLTabButton,List<PLCommandParameter>>();
				
				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();
				if(selectTreeNodeobject!=null){
					String btmName = selectTreeNodeobject.name;
					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;
						}
						p.plOId = ObjectUtility.getNewObjectID36();
						HSSFCell readcell = readrow.getCell(0);
						p.plName = readcell.getStringCellValue();
						readcell = readrow.getCell(1);
						p.plCode = readcell.getStringCellValue();
						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(!btmName.equals(name)){
							VCIOptionPane.showMessage(LogonApplication.frame, "请选择要导入的类型节点名称！");
							return false;
						}
						plpagelayoutdefinations = UITools.getService().getPLUILayoutsByRelatedType(btmName);
						for(PLUILayout pd : plpagelayoutdefinations){
							if(pd.plName.equals(p.plName)){
								checkplpagelayoutdefination.append(pd.plName).append(",");
							}
							if(pd.plCode.equals(p.plCode)){
								if(!checkplpagelayoutdefinationPlcode.toString().contains(p.plCode)){
									checkplpagelayoutdefinationPlcode.append(p.plCode).append(",");
								}
							}
						}
						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();
							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);
							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();
									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的关系，在确定层级关系时使用
										Map<String,String> relation = new HashMap<String,String>();
										for(int a=0;a<=pltabbuttonsheet.getLastRowNum();a++){
											HSSFRow readrow3 = pltabbuttonsheet.getRow(a);
											if(readrow3==null){
												break;
											}
											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(7);
											plCommandOId = readcell3.getStringCellValue();
											plTabButton.plOId = plCommandOId;
											readcell3 = readrow3.getCell(8);
											String parentOid = readcell3.getStringCellValue();
											readcell3 = readrow3.getCell(9);
											plTabButton.displayMode = readcell3.getStringCellValue();
											readcell3 = readrow3.getCell(10);
											plTabButton.iconPath = readcell3.getStringCellValue();
											readcell3 = readrow3.getCell(11);
											plTabButton.authorization = readcell3.getStringCellValue();
											//赋予保存好的值，来保证层级关系不会丢失
											plTabButton.plOId = relation.get(plCommandOId);
											if(parentOid != null && parentOid.length() > 0) {											
												plTabButton.plParentOid = 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);
					}
				}else{
					
					for(int btmNamei=0;btmNamei<=btmNamesheet.getLastRowNum();btmNamei++){
						HSSFRow btmNameReadrow = btmNamesheet.getRow(btmNamei);
						HSSFCell btmNameReadcell = btmNameReadrow.getCell(0);
						String btmName = btmNameReadcell.getStringCellValue();
						if(btmNameReadrow==null){
							break;
						}
						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;
							}
							p.plOId = ObjectUtility.getNewObjectID36();
							HSSFCell readcell = readrow.getCell(0);
							p.plName = readcell.getStringCellValue();
							readcell = readrow.getCell(1);
							p.plCode = readcell.getStringCellValue();
							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(!btmName.equals(name)){
//								VCIOptionPane.showMessage(LogonApplication.frame, "请选择要导入的类型节点名称！");
//								return false;
//							}
							if(btmName.equals(name)){
								plpagelayoutdefinations = UITools.getService().getPLUILayoutsByRelatedType(btmName);
								for(PLUILayout pd : plpagelayoutdefinations){
									if(pd.plName.equals(p.plName)){
										if(!checkplpagelayoutdefination.toString().contains(name)){
											checkplpagelayoutdefination.append("\n\t"+name).append(":");
										}
										checkplpagelayoutdefination.append(pd.plName).append(",");
									}
									if(pd.plCode.equals(p.plCode)){
										if(!checkplpagelayoutdefinationPlcode.toString().contains(name)){
											checkplpagelayoutdefinationPlcode.append("\n\t"+name).append(":");
										}
										if(!checkplpagelayoutdefinationPlcode.toString().contains(p.plCode)){
											checkplpagelayoutdefinationPlcode.append(p.plCode).append(",");
										}
									}
								}
								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();
									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);
									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();
											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的关系，在确定层级关系时使用
												Map<String,String> relation = new HashMap<String,String>();
												for(int a=0;a<=pltabbuttonsheet.getLastRowNum();a++){
													HSSFRow readrow3 = pltabbuttonsheet.getRow(a);
													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(name)){
															plActionIDNulls.append("\n\t"+name).append(":");
														}
														if(!plActionIDNulls.toString().contains(readrow3.getCell(4).getStringCellValue())){
															plActionIDNulls.append("Action编号:"+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(7);
													plCommandOId = readcell3.getStringCellValue();
													readcell3 = readrow3.getCell(8);
													String parentOid = readcell3.getStringCellValue();
													//赋予保存好的值，来保证层级关系不会丢失
													plTabButton.plOId = relation.get(plCommandOId);
													if(parentOid != null && parentOid.length() > 0) {											
														plTabButton.plParentOid = 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);
						}
						System.out.println("秒:"+System.currentTimeMillis()*1000);
					}
				}
				ClientBusinessObjectOperation cboo = new ClientBusinessObjectOperation();
				for(int a=0;a<=plactionsheet.getLastRowNum();a++){
					int count = 0;
					PLAction plaction = new PLAction();
					HSSFRow readrow3 = plactionsheet.getRow(a);
					if(readrow3==null){
						break;
					}
					HSSFCell readcell2 = readrow3.getCell(0);
					plaction.plOId = readcell2.getStringCellValue();
					readcell2 = readrow3.getCell(1);
					plaction.plName = readcell2.getStringCellValue();
					readcell2 = readrow3.getCell(2);
					plaction.plCode = readcell2.getStringCellValue();
					readcell2 = readrow3.getCell(3);
					plaction.plActionCls = readcell2.getStringCellValue();
					readcell2 = readrow3.getCell(4);
					plaction.plBSUrl = readcell2.getStringCellValue();
					readcell2 = readrow3.getCell(5);
					plaction.plCSClass = readcell2.getStringCellValue();
					readcell2 = readrow3.getCell(6);
					plaction.plTypeType = readcell2.getStringCellValue();
					readcell2 = readrow3.getCell(7);
					plaction.plLicensOrs = readcell2.getStringCellValue();
					readcell2 = readrow3.getCell(8);
					plaction.plDesc = readcell2.getStringCellValue();
					//PLAction[] allPLAction = Tool.getService().getAllPLAction();
					for(PLAction pa : allPLAction){
						if(pa.plCode.equals(plaction.plCode)){
							count++;
							break;
						}
					}
					if(count==0){
						UITools.getService().savePLAction(plaction);
					}
				}
				if(checkplpagelayoutdefination.length()>0){
//					VCIOptionPane.showMessage(LogonApplication.frame, checkplpagelayoutdefination.toString()+"名称已经存在！");
					MessageDialog msgdia = new MessageDialog(checkplpagelayoutdefination.toString()+"名称已经存在！");
					return false;
				}
				if(checkplpagelayoutdefinationPlcode.length()>0){
//					VCIOptionPane.showMessage(LogonApplication.frame, checkplpagelayoutdefinationPlcode.toString()+"上下文已经存在！");
					MessageDialog msgdia = new MessageDialog(checkplpagelayoutdefinationPlcode.toString()+"上下文已经存在！");
					return false;
				}
				
				if(plActionIDNulls.length()>0){
//					VCIOptionPane.showMessage(LogonApplication.frame, plActionIDNulls.toString()+"不存在！");
					MessageDialog msgdia = new MessageDialog(plActionIDNulls.toString()+"不存在！");
					return false;
				}
				
				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 = LogonApplication.getUserEntityObject().getUserName();
									plcommandparameter.plModifyUser = LogonApplication.getUserEntityObject().getUserName();
									UITools.getService().savePLCommandParameter(plcommandparameter);
								}
								pltabbutton.plCreateUser = LogonApplication.getUserEntityObject().getUserName();
								pltabbutton.plModifyUser = LogonApplication.getUserEntityObject().getUserName();
								UITools.getService().updatePLTabButton(pltabbutton);
							}
							UITools.getService().savePLPageDefination(plpagedefination);
						}
						pltabpage.plCreateUser = LogonApplication.getUserEntityObject().getUserName();
						pltabpage.plModifyUser = LogonApplication.getUserEntityObject().getUserName();
						UITools.getService().savePLTabPage(pltabpage);
					}
					plPageLayoutDefination.plCreateUser = LogonApplication.getUserEntityObject().getUserName();
					plPageLayoutDefination.plModifyUser = LogonApplication.getUserEntityObject().getUserName();
					UITools.getService().savePLUILayout(plPageLayoutDefination);
				}
				return true;
			} catch (IOException e) {
				e.printStackTrace();
				return false;
			} catch (VCIError e) {
				e.printStackTrace();
				return false;
			}
		} catch (FileNotFoundException e) {
			e.printStackTrace();
			return false;
		}
	}
	
}