package com.vci.client.omd.provider;

import java.io.BufferedReader;
import java.io.BufferedWriter;
import java.io.File;
import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.FileOutputStream;
import java.io.FileWriter;
import java.io.IOException;
import java.io.InputStreamReader;
import java.io.OutputStreamWriter;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Arrays;
import java.util.HashMap;
import java.util.HashSet;
import java.util.List;
import java.util.Map;
import java.util.Set;
import org.dom4j.Document;
import org.dom4j.DocumentException;
import org.dom4j.Element;
import org.dom4j.io.SAXReader;

import com.vci.corba.omd.atm.AttribItem;
import com.vci.corba.omd.btm.BtmItem;
import com.vci.corba.omd.ltm.LinkType;
import com.vci.corba.omd.ltm.LinkTypeServicePrx;
import com.vci.client.common.providers.ServiceProvider;
import com.vci.corba.common.VCIError;


/**
 * 获取属性的数据类型, 属性: 系统属性, 属性池属性
 * 
 */
public class LinkTypeProvider {
	private static LinkTypeProvider linkTypeProvider = null;
	/**
	 * 链接类型table名的前缀
	 */
	private static LinkTypeServicePrx linkTypeService = null;
	/**
	 * oracle中table名的最大长度
	 */
//	private static final int TABLEMAXLENTGH = 30;
	
	public static DateFormat tsDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS");
	public static DateFormat timeDF = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
	
//	private String[] sysAttibutes = {"OID","Creator","CreateTime","LastModifier","LASTMODIFYTIME","F_OID","F_REVISIONOID","F_NAMEOID","F_BtwName",
//									"T_OID","T_REVISIONOID","T_NAMEOID","T_BtwName","TS"};
//	private final String otherFieldLt = "\n\tOID VARCHAR2(36) not null," + 
//			"\n\tCreator VARCHAR2(36),\n\tCreateTime TIMESTAMP,\n\tLastModifier VARCHAR2(36)," +
//			"\n\tLastModifyTime TIMESTAMP,\n\tF_OID VARCHAR2(36) not null,\n\tF_REVISIONOID VARCHAR2(36)," + 
//			"\n\tF_NAMEOID VARCHAR2(36),\n\tF_BtwName VARCHAR2(36),\n\tT_OID VARCHAR2(36) not null,\n\tT_REVISIONOID VARCHAR2(36)," + 
//			"\n\tT_NAMEOID VARCHAR2(36),\n\tT_BtwName VARCHAR2(36),\n\tTS TIMESTAMP,\n\t";
	
	/**
	 * 缓存已经调用new LinkTypeProvider();
	 * 因此不能定义 私有的LinkTypeProvider();
	 * @return
	 */
	public static LinkTypeProvider getInstance(){
		if(linkTypeProvider == null){
			linkTypeProvider = new LinkTypeProvider();
		}
		return linkTypeProvider;
	}
	
	public String[] getSysAttributes() {
		try {
			return getService().getSysAttributes();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		return null;
	}
	
	
	public AttribItem[] getSysAttribItems() {
		return getService().getSysAttribItems();
	}
	
	/**
	 * 获取属性的数据类型, 属性: 系统属性, 属性池属性
	 * @param abUpperName
	 * @return
	 */
	public String getAbItemDataType(String abName){
		String dataType = null;
		String abUpperName = abName.toUpperCase();
		//系统属性
		if(abUpperName.equals("OID") || abUpperName.equals("REVISIONOID") || abUpperName.equals("NAMEOID") || abUpperName.equals("BTMNAME")
				|| abUpperName.equals("CREATOR") || abUpperName.equals("LASTMODIFIER") || abUpperName.equals("REVISIONRULE")
				|| abUpperName.equals("VERSIONRULE") || abUpperName.equals("REVISIONVALUE") || abUpperName.equals("VERSIONVALUE")
				|| abUpperName.equals("LCTID") || abUpperName.equals("LCSTATUS")
				|| abUpperName.equals("ID") || abUpperName.equals("NAME") || abUpperName.equals("DESCRIPTION") 
				|| abUpperName.equals("OWNER") || abUpperName.equals("CHECKINBY") 
				|| abUpperName.equals("CHECKOUTBY") || abUpperName.equals("COPYFROMVERSION")
				|| abUpperName.equals("ISLASTR") || abUpperName.equals("ISFIRSTR")
				|| abUpperName.equals("ISLASTV") || abUpperName.equals("ISFIRSTV")
				|| abUpperName.equals("F_OID") || abUpperName.equals("F_REVISIONOID") 
				|| abUpperName.equals("F_NAMEOID") || abUpperName.equals("F_BTWNAME")
				|| abUpperName.equals("T_OID") || abUpperName.equals("T_REVISIONOID") 
				|| abUpperName.equals("T_NAMEOID") || abUpperName.equals("T_BTWNAME")){
			dataType = "VTString";
		}else if(abUpperName.equals("REVISIONSEQ") || abUpperName.equals("VERSIONSEQ")){
			dataType = "VTInteger";
		}else if(abUpperName.equals("CREATETIME") || abUpperName.equals("LASTMODIFYTIME")
				|| abUpperName.equals("TS") || abUpperName.equals("CHECKINTIME") || abUpperName.equals("CHECKOUTTIME")){
			dataType = "VTDateTime";
		//属性池中属性
		}else{
			dataType = ApProvider.getAbItemDataType(abName);
		}		
		return dataType;
	}
	
	/**
	 * 
	 * @return
	 */
	public String getLTData(){
		String content = "";
		try {
			content = getService().getLTData();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
		return content;
	}
	
	/***
	 * 
	 *  获取所有链接类型对象数组
	 *  
	 */
	public LinkType [] getLinkTypes(){
			LinkType[] linkTypes = null;
		try {
			linkTypes = getService().getLinkTypes();
		} catch (VCIError e) {
			// TODO Auto-generated catch block
			e.printStackTrace();
		}
		return linkTypes;
	}
	/***
	 * 
	 * 根据链接类型名称获取链接类型对象
	 */
	public LinkType getLinkTypeByName(String name){
		LinkType[] linkTypes = null;
		try {
			linkTypes = getService().getLinkTypes();
			for(LinkType lt:linkTypes){
				if(lt.name.equals(name)){
					return lt;
				}
			}
		} catch (VCIError e) {
			e.printStackTrace();
		}
		return null;
		
	}
	
	public LinkType[] getLinkTypeByBtmName(String btmName, String direction) {
		LinkType[] linkTypes = null;
		try {
			linkTypes = getService().getLinkTypeByBtmName(btmName, direction);
		} catch (VCIError e) {
			e.printStackTrace();
		}
		return linkTypes;
	}
	
	public LinkTypeServicePrx getService(){
		try {
			return ServiceProvider.getOMDService().getLinkTypeService();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return linkTypeService;
	}

	
	/**
	 * 返回创建链接类型的sql
	 * @param linkType
	 * @return
	 */
//	public String getCreateLtSql(LinkType linkType){
//		String tableName = OmdTools.getLTTableName(linkType.name);
//		String sql = "create table " + tableName + "(" + otherFieldLt;
//		
//		String[] abInfo = linkType.attributes;
//		
//		for(int i = 0; i < abInfo.length; i++){
//			com.vci.corba.omd.attribpool.AttribItem abItem = null;
//			abItem = ApProvider.getAbItemByName(abInfo[i]);
//
//			String abSql = getAbSql(abItem);
//			sql += abSql;
//		}
//		sql = sql.substring(0, sql.lastIndexOf(","));
//		sql += "\n)";
//		return sql;
//	}
	
	/**
	 * 获取增加主键sql
	 * @param typeName
	 * @return
	 */
//	public String getAddPKSql(String typeName){
//		return "alter table " + OmdTools.getLTTableName(typeName) + " add constraint PKLT_" + typeName + " primary key (OID)\n";
//	}
	
//	public String getAbSql(AttribItem abItem){
//		String sql = "";
//		if(abItem == null){
//			return sql;
//		}
//		String abName = abItem.name;
//		String vtType = abItem.vtDataType;
//		String other = abItem.other;
//		String defValue = abItem.defValue;
//		
//		if(vtType.equals("VTString")){
//			int length = 50;
//			String lengthStr = getOtherValueByType(other, "length");
//			if(lengthStr != null && !lengthStr.equals("")){
//				length = Integer.valueOf(lengthStr);
//			}
//			sql += abName.toUpperCase() + " VARCHAR2(" + length + ")";
//			if(!defValue.equals("")){
//				sql += " default '" + defValue + "'";
//			}
//			sql += ",\n\t";
//		}else if(vtType.equals("VTInteger")){
//			sql += abName.toUpperCase() + " NUMBER";
//			if(!defValue.equals("")){
//				sql += " default " + defValue;
//			}
//			sql += ",\n\t";
//		}else if(vtType.equals("VTDouble")){
//			int length = 20;
//			String lengthStr = getOtherValueByType(other, "length");
//			if(lengthStr != null && !lengthStr.equals("")){
//				length = Integer.valueOf(lengthStr);
//			}
//			
//			int accuracy = 2;
//			String accuracyStr = getOtherValueByType(other, "accuracy");
//			if(accuracyStr != null && !accuracyStr.equals("")){
//				accuracy = Integer.valueOf(accuracyStr);
//			}
//			sql += abName.toUpperCase() + " NUMBER(" + length + ", " + accuracy +")";
//			if(!defValue.equals("")){
//				sql += " default " + defValue;
//			}
//			sql += ",\n\t";
//		}else if(vtType.equals("VTBoolean")){
//			sql += abName.toUpperCase() + " VARCHAR2(8)";
//			if(!defValue.equals("")){
//				sql += " default '" + defValue + "'";
//			}
//			sql += ",\n\t";
//		}else if(vtType.equals("VTImage")){
//			sql += abName.toUpperCase() + " VARCHAR2(255)";
//			sql += ",\n\t";
//		}else if(vtType.equals("VTDate")){
//			sql += abName.toUpperCase() + " DATE";
//			sql += ",\n\t";
//		}else if(vtType.equals("VTTime")){
//			sql += abName.toUpperCase() + " TIMESTAMP";
//			sql += ",\n\t";
//		}else if(vtType.equals("VTDateTime")){
//			sql += abName.toUpperCase() + " TIMESTAMP";
//			sql += ",\n\t";
//		}else if(vtType.equals("VTNote")){
//			sql += abName.toUpperCase() + " VARCHAR2(255)";
//			sql += ",\n\t";
//		}else if(vtType.equals("VTFilePath")){
//			sql += abName.toUpperCase() + " VARCHAR2(255)";
//			sql += ",\n\t";
//		}else if(vtType.equals("VTClob")){
//			sql += abName.toUpperCase() + " CLOB";
//			sql += ",\n\t";
//		}
//		
//		return sql;
//	}
	
	/**
	 * 获取属性other中type的值
	 * @param other
	 * @param type
	 * @return
	 */
	public String getOtherValueByType(String other, String type){
		String[] otherArray = other.split(";");
		for(int i = 0; i < otherArray.length; i++){
			String otherValue = otherArray[i];
			if(otherValue.contains(type)){
				return otherValue.substring(otherValue.indexOf("=") + 2, otherValue.length());
			}
		}
		return null;
		
	}
	
	/**
	 * Array-->List
	 * @param array
	 * @return
	 */
	public List<String> parseArrayToList(String[] array){
		List<String> list = new ArrayList<String>();
		for(int i = 0; i < array.length; i++){
			list.add(array[i]);
		}
		return list;
	}
	
	/**
	 * 指定的链接类型是否使用了指定的业务类型
	 * @param link
	 * @param btmName
	 * @return
	 */
	public boolean containsBtm(LinkType link, String btmName){
		String[] btms = link.btmItemsFrom;
		for(int i = 0; i < btms.length; i++){
			if(btmName.equalsIgnoreCase(btms[i])){
				return true;
			}
		}
		btms = link.btmItemsTo;
		for(int i = 0; i < btms.length; i++){
			if(btmName.equalsIgnoreCase(btms[i])){
				return true;
			}
		}
		return false;
	}
	
	/**
	 * 
	 * 获取链接类型的全部属性(包括系统属性)数组
	 * @return
	 */
	public List<String> getAllAbNames(LinkType link){
		List<String> abList = new ArrayList<String>();
		for(String attr : getService().getSysAttributes()) {
			abList.add(attr);
		}
		String[] abNames = getAbNames(link);
		for(int i = 0; i < abNames.length; i++){
			abList.add(abNames[i]);
		}
		
		return abList;
	}
	
	/**
	 * 获取链接类型的属性(不包括系统属性)数组
	 * @param btName
	 * @return
	 */
	public String[] getAbNames(LinkType link){
		return link.attributes;
	}
	
	/**
	 * 获取链接类型对应的属性
	 * @param linkTypeName
	 * @return
	 */
	public AttribItem[] getLTAbItems(String linkTypeName) {
		LinkType linkType = getLinkTypeByName(linkTypeName);
		if (linkType.attributes == null || linkType.attributes.length == 0) {
			return new AttribItem[0];
		}
		AttribItem[] abItems = ApProvider.getAttribItemsByNames(linkType.attributes);
		
		return abItems;
	}
	
	public boolean expData(String dir, LinkType[] lts){
		Set<String> attNameSet = new HashSet<String>();
		Set<String> btNameSet = new HashSet<String>();
		BufferedWriter bw = null;
		FileOutputStream fos = null;
		OutputStreamWriter osw =null;
		try{
			File file = new File(dir + "/lt.txt");
			//将clob字段写到单独的文件中
			new File(dir + "/lt").mkdir();
			//add by caill start 2015.12.24 	导出时将txt文件设置为“utf-8”格式
			fos = new FileOutputStream(file);
			osw = new OutputStreamWriter(fos, "utf-8");
			bw = new BufferedWriter(osw);
			//add by caill end
			/*w = new FileWriter(file);
			bw = new BufferedWriter(w);*/
			for(LinkType lt : lts){
				String[] apNames = lt.attributes;
				if(apNames.length > 0){
					attNameSet.addAll(Arrays.asList(apNames));
				}
				for(String btName : lt.btmItemsFrom){
					btNameSet.add(btName);
				}
				for(String btName : lt.btmItemsTo){
					btNameSet.add(btName);
				}
				//若str小于缓冲区大小, 将写到缓冲区; 
				//若str大于缓冲区大小, 将刷新缓冲区(将缓冲区内容写到底层流), 然后str直接写到底层流.
				String text = getObjectText(lt);
				bw.write(text);
				bw.newLine();
				BufferedWriter clobBW = null;
				FileOutputStream fo = null;
				OutputStreamWriter pw =null;
				try{
					File clobFile = new File(dir + "/lt/" + lt.oid + ".xml");
					//add by caill start 2015.12.24 将xml内容和xml文件格式统一
				    fo = new FileOutputStream(clobFile);
					pw = new OutputStreamWriter(fo, "utf-8");
					clobBW = new BufferedWriter(pw);
					clobBW.write( "<?xml version=\"1.0\" encoding=\"utf-8\" ?>");
					clobBW.write(getXmlText(lt));
					clobBW.flush();
					//add by caill end
					/*clobW = new FileWriter(clobFile);
					clobBW = new BufferedWriter(clobW);
					clobBW.write( "<?xml version=\"1.0\" encoding=\"gb2312\" ?>");//gb2312
					clobBW.write(getXmlText(lt));
					clobBW.flush();*/
				}catch(IOException e2){
					e2.printStackTrace();
				}finally{
					try{
						if(clobBW != null){
							fo.close();		//add by caill 2015.12.24 将fo关闭
							pw.close();		//add by caill 2015.12.24 将pw关闭
							clobBW.close();
						}
					} catch (IOException e) {
						e.printStackTrace();
					}
				}
			}
			bw.flush();
			//导出属性
			AttribItem[] abs = ApProvider.getAttribItemsByNames(attNameSet.toArray(new String[0]));			
			boolean apFlag = ApProvider.expData(dir, abs);
			
			//导出业务类型
			List<BtmItem> bts = new ArrayList<BtmItem>();
			for(String btName : btNameSet){
				BtmItem bt = BtmProvider.getBtmItemByName(btName);
				bts.add(bt);
			}
			boolean btFlag = BtmProvider.expData(dir, bts.toArray(new BtmItem[0]));
			if(true & apFlag & btFlag){
				System.out.println("**************链接类型导出成功************");
			}else{
				System.out.println("**************链接类型导出失败************");
			}
			return true & apFlag & btFlag;
		}catch(IOException e){
			e.printStackTrace();
		}finally{
			try {
				if(bw != null){
					fos.close();		//add by caill 2015.12.24 将fos关闭
					osw.close();		//add by caill 2015.12.24 将osw关闭
					bw.close();
				}
			} catch (IOException e) {
				e.printStackTrace();
			}
		}
		return false;
	}
	
	private static final String OID = "oid";
	private static final String NAME = "name";
	private static final String LABEL = "label";
	private static final String DESCRIPTION = "description";
	private static final String TS = "ts";
	private static final String CREATOR = "creator";
	private static final String CREATETIME = "createTime";
	private static final String MODIFIER = "modifier";
	private static final String MODIFYTIME = "modifyTime";
	
	/**
	 * 将对象转化成字符串
	 * {oid:qqq, name:q}
	 * @param lt
	 * @return
	 */
	public String getObjectText(LinkType lt) {
		StringBuilder stb = new StringBuilder("{");
		stb.append(OID + ":" + lt.oid + ",");
		stb.append(NAME + ":" + lt.name + ",");
		stb.append(LABEL + ":" + lt.tag + ",");
		stb.append(DESCRIPTION + ":" + lt.description + ",");
		stb.append(TS + ":" + lt.ts + ",");
		stb.append(CREATOR + ":" + lt.creator + ",");
		stb.append(CREATETIME + ":" + lt.createTime + ",");
		stb.append(MODIFIER + ":" + lt.modifier + ",");
		stb.append(MODIFYTIME + ":" + lt.modifyTime);
		stb.append("}");
		return stb.toString();
	}
	
	/**
	 * 将LinkType lt转化成xmltext
	 * @param bt
	 * @return
	 */
	public String getXmlText(LinkType lt){
		StringBuilder stb = new StringBuilder("<linkType>");
		stb.append("<name>" + lt.name + "</name>");
		stb.append("<tag>" + lt.tag + "</tag>");
		stb.append("<description>" + lt.description + "</description>");
		for(String btmFrom : lt.btmItemsFrom){
			stb.append("<btmFrom>" + btmFrom + "</btmFrom>");
		}
		for(String btmTo : lt.btmItemsTo){
			stb.append("<btmTo>" + btmTo + "</btmTo>");
		}
		stb.append("<primitivesFrom>" + lt.primitivesFrom + "</primitivesFrom>");
		stb.append("<primitivesTo>" + lt.primitivesTo + "</primitivesTo>");
		stb.append("<relationFrom>" + lt.relationFrom + "</relationFrom>");
		stb.append("<relationTo>" + lt.relationTo + "</relationTo>");
		stb.append("<relation>" + lt.relation + "</relation>");
		stb.append("<implClass>" + lt.implClass + "</implClass>");
		stb.append("<shape>" + lt.shape + "</shape>");
		for(String attibute : lt.attributes){
			stb.append("<attibute>" + attibute + "</attibute>");
		}
		stb.append("</linkType>");
		return stb.toString();
	}
	
	public List<LinkType> getLTFromFile(String dir) {
		File file = new File(dir + "/lt.txt");
		List<LinkType> list = new ArrayList<LinkType>();
		BufferedReader br = null;
		FileInputStream fo = null;
		InputStreamReader isw =null;
		try {
			/*r = new FileReader(file);
			br = new BufferedReader(r);*/
			//add by caill start 2015.12.24 	导入时将txt文件内容设置为“utf-8”格式
		    fo = new FileInputStream(file);
			isw = new InputStreamReader(fo, "utf-8");
			br = new BufferedReader(isw);
			//add by caill end
			String str = null;
			while((str = br.readLine()) != null){
				Map<String, String> map = getMapFormText(str);
				String oid = map.get("oid");
				if(oid != null && !oid.equals("")){
					File contentFile = new File(dir + "/lt/" + oid + ".xml");
					if(!contentFile.exists()){
						System.out.println(dir + "/lt/" + oid + ".xml不存在");
						break;
					}
					LinkType lt = new LinkType();
					lt.oid = oid;
					lt.name = map.get("name");
					lt.tag = map.get("label");
					lt.description = map.get("description");
					lt.ts = Long.valueOf(map.get("ts"));
					lt.creator = map.get("creator");
					lt.createTime = Long.valueOf(map.get("createTime"));
					lt.modifier = map.get("modifier");
					lt.modifyTime = Long.valueOf(map.get("modifyTime"));
					SAXReader sa = new SAXReader();
					//add by caill 2015.12.24	导入时将saxReader对象设置为“utf-8”格式
					sa.setEncoding("utf-8");
					Document document = sa.read(contentFile);
					setLTValueFormDoc(lt, document.getRootElement());
					list.add(lt);
				}else{
					System.out.println(dir + "bt.txt中存在oid为空的错误记录");
					break;
				}
			}
			return list;
		} catch (FileNotFoundException e) {
			e.printStackTrace();
		} catch (IOException e) {
			e.printStackTrace();
		} catch (DocumentException e) {
			e.printStackTrace();
		} finally{
			if(br != null){
				try {
					fo.close();		//add by caill 2015.12.24	将fo关闭
					isw.close();	//add by caill 2015.12.24	将isw关闭
					br.close();
				} catch (IOException e) {
					e.printStackTrace();
				}
			}
		}
		return null;
	}
	/**
	 * 将文件中一条记录解析成key-value
	 * @param str
	 * @return
	 */
	public Map<String, String> getMapFormText(String str) {
		str = str.trim();
		if(!str.startsWith("{") || !str.endsWith("}")){
			return null;
		}
		Map<String, String> map = new HashMap<String, String>();
		str = str.substring(1, str.length() - 1);
		String[] kvs = str.split(",");
		for(String kv : kvs){
			String[] kv_ = kv.split(":");
			if(kv_.length == 1){
				map.put(kv_[0].trim(), "");	
			}else{
				map.put(kv_[0].trim(), kv_[1].trim());
			}
		}
		return map;
	}
	
	/**
	 * 设置EnumItem存在
	 * @param att
	 * @param element
	 */
	public void setLTValueFormDoc(LinkType lt, Element element){
		List<Element> fromElements = element.elements("btmFrom");
		List<String> froms = new ArrayList<String>();
		for(Element fromElement : fromElements){
			froms.add(fromElement.getText());
		}
		lt.btmItemsFrom = froms.toArray(new String[0]);
		List<Element> toElements = element.elements("btmTo");
		List<String> tos = new ArrayList<String>();
		for(Element toElement : toElements){
			tos.add(toElement.getText());
		}
		lt.btmItemsTo = tos.toArray(new String[0]);
		String value = element.elementText("primitivesFrom");
		lt.primitivesFrom = (value == null ? "" : value);
		value = element.elementText("primitivesTo");
		lt.primitivesTo = (value == null ? "" : value);
		value = element.elementText("relationFrom");
		lt.relationFrom = (value == null ? "" : value);
		value = element.elementText("relationTo");
		lt.relationTo = (value == null ? "" : value);
		value = element.elementText("relation");
		lt.relation = (value == null ? "" : value);
		value = element.elementText("implClass");
		lt.implClass = (value == null ? "" : value);
		value = element.elementText("shape");
		lt.shape = (value == null ? "" : value);
		List<Element> attElements = element.elements("attibute");
		List<String> atts = new ArrayList<String>();
		for(Element attElement : attElements){
			atts.add(attElement.getText());
		}
		lt.attributes = atts.toArray(new String[0]);
	}
	
	public boolean impData(String dir, LinkType[] lts) {
		try {
			List<AttribItem> atts = ApProvider.getAttFromFile(dir);
			boolean attFlag = ApProvider.impData(dir, atts.toArray(new AttribItem[0]));
			if(!attFlag){
				System.out.println("链接类型使用的属性导入失败。导入中止。");
				return false;
			}
			
			List<BtmItem> bts = BtmProvider.getBTFromFile(dir);
			boolean btFlag = BtmProvider.impData(dir, bts.toArray(new BtmItem[0]));
			if(!btFlag){
				System.out.println("链接类型使用的业务类型导入失败。导入中止。");
				return false;
			}
			
			for(LinkType lt : lts){
				LinkType lt_ = getService().getLinkType(lt.name);
				//已经存在
				if(!lt_.oid.equals("")){
					getService().deleteLinkType(lt_);
					getService().addLinkType(lt);
					System.out.println(lt.name + "在数据库中已经存在， 覆盖。");
				}else{
					getService().addLinkType(lt);
				}
			}
			return true;
		} catch (VCIError e) {
			e.printStackTrace();
		}
		return false;
	}
	/**将linktype导出为.sql文件
	 * add by caill 2015.12.22
	 * 
	 * */
//	public boolean expLinkSqlData(String dir, LinkType[] linkTypes) throws VCIError {
//		new File(dir).mkdir();
//		File file = new File(dir + "/platformLink.sql");
//		FileWriter w = null;;
//		BufferedWriter bw = null;
//		try {
//			w = new FileWriter(file);
//		    bw = new BufferedWriter(w);
//		} catch (IOException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
//		
//		for(int i = 0; i < linkTypes.length; i++){
//			String sql = getLinkTableSqlByName(linkTypes[i]);
//			try {
//				bw.write(sql);
//				bw.write("\r\n");
//			} catch (IOException e) {
//				// TODO Auto-generated catch block
//				e.printStackTrace();
//			}	
//		}
//		try {
//			bw.flush();
//			bw.close();
//			return true;
//		} catch (IOException e) {
//			// TODO Auto-generated catch block
//			e.printStackTrace();
//		}
//		
//		
//		return false;
//	}
	/**
	 * 生成链接类型导出为.sql文件的sql语句 add by caill 2015.12.22
	 * @param linkType
	 * @return
	 */
//	public String getLinkTableSqlByName(LinkType linkType){
//		String tableName = OmdTools.getLTTableName(linkType.name);
//		String sql = "create table " + tableName +"(" + otherFieldLt;	
//		String[] abInfo = linkType.attributes;		
//		for(int i = 0; i < abInfo.length; i++){
//			com.vci.corba.omd.attribpool.AttribItem abItem = null;
//
//			abItem = ApProvider.getAbItemByName(abInfo[i]);
//
//			String abSql = getAbSql(abItem);
//			sql += abSql;
//		}
//		sql = sql.substring(0, sql.lastIndexOf(","));
//		sql += "\n);";
//		sql += "\r\ncomment on table "+tableName+" is '"+ linkType.tag+"';";	//添加表注释
//		for(int i = 0; i < abInfo.length; i++){
//			com.vci.corba.omd.attribpool.AttribItem abItem = null;
//
//			abItem = ApProvider.getAbItemByName(abInfo[i]);	//添加列注释
//
//			sql += "\r\ncomment on column "+tableName+"."+abItem.name+" is '"+ abItem.label +"';";
//		}
//		return sql;
//	}
	
}