All Downloads are FREE. Search and download functionalities are using the official Maven repository.

com.scudata.ide.spl.GMSpl Maven / Gradle / Ivy

Go to download

SPL(Structured Process Language) A programming language specially for structured data computing.

There is a newer version: 20240823
Show newest version
package com.scudata.ide.spl;

import java.awt.Font;
import java.io.File;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.Iterator;
import java.util.List;
import java.util.Locale;
import java.util.Map;
import java.util.Vector;

import javax.swing.SwingUtilities;

import com.scudata.app.common.AppConsts;
import com.scudata.app.common.AppUtil;
import com.scudata.app.common.Segment;
import com.scudata.cellset.datamodel.CellSet;
import com.scudata.cellset.datamodel.NormalCell;
import com.scudata.cellset.datamodel.PgmCellSet;
import com.scudata.cellset.datamodel.PgmNormalCell;
import com.scudata.common.Area;
import com.scudata.common.ArgumentTokenizer;
import com.scudata.common.CellLocation;
import com.scudata.common.DBConfig;
import com.scudata.common.DBInfo;
import com.scudata.common.Logger;
import com.scudata.common.Matrix;
import com.scudata.common.StringUtils;
import com.scudata.dm.DBObject;
import com.scudata.dm.FileObject;
import com.scudata.dm.Sequence;
import com.scudata.dm.Table;
import com.scudata.ide.common.AppMenu;
import com.scudata.ide.common.AppToolBar;
import com.scudata.ide.common.ConfigFile;
import com.scudata.ide.common.ConfigOptions;
import com.scudata.ide.common.ConfigUtilIde;
import com.scudata.ide.common.DBTypeEx;
import com.scudata.ide.common.GC;
import com.scudata.ide.common.GM;
import com.scudata.ide.common.GV;
import com.scudata.ide.common.IAtomicCmd;
import com.scudata.ide.common.control.CellRect;
import com.scudata.ide.common.control.CellSelection;
import com.scudata.ide.common.control.ControlUtilsBase;
import com.scudata.ide.common.dialog.DialogDataSource;
import com.scudata.ide.common.dialog.DialogFileReplace;
import com.scudata.ide.common.dialog.DialogMemory;
import com.scudata.ide.spl.control.CellSetParser;
import com.scudata.ide.spl.control.ControlUtils;
import com.scudata.ide.spl.control.SplEditor;
import com.scudata.ide.spl.dialog.DialogAbout;
import com.scudata.ide.spl.resources.IdeSplMessage;

public class GMSpl extends GM {

	/**
	 * ִ?в˵?????Sheet????
	 * 
	 * @param cmd
	 *            GCSpl??GC?ж???IJ˵?????
	 * @throws Exception
	 */
	public static void executeCmd(short cmd) throws Exception {
		switch (cmd) {
		case GC.iNEW:
			GV.appFrame.openSheetFile(null);
			return;
		case GCSpl.iNEW_SPL:
			GV.appFrame.openSheetFile("");
			return;
		case GC.iOPEN:
			String ext = "\"" + AppConsts.SPL_FILE_EXTS + "\"";
			File file = GM.dialogSelectFile(ext);
			if (file != null) {
				GV.appFrame.openSheetFile(file.getAbsolutePath());
			}
			return;
		case GC.iSAVE:
			GV.appSheet.save();
			return;
		case GC.iSAVEAS:
			GV.appSheet.saveAs();
			return;
		case GC.iSAVEALL:
			((SPL) GV.appFrame).saveAll();
			return;
		case GC.iFILE_CLOSE:
		case GC.iFILE_CLOSE1:
			if (GV.appSheet != null) {
				GV.appFrame.closeSheet(GV.appSheet);
			}
			return;
		case GC.iFILE_CLOSE_ALL:
			GV.appFrame.closeAll();
			return;
			// case GCSpl.iSPL_IMPORT_TXT:
			// importTxt2Spl();
			// return;
		case GC.iQUIT:
			GV.appFrame.quit();
			return;
		case GC.iDATA_SOURCE:
			DialogDataSource dds = new DialogDataSource(GV.dsModel);
			dds.setVisible(true);
			try {
				ConfigUtilIde.writeConfig();
			} catch (Exception ex) {
				Logger.debug(ex);
			}
			if (GVSpl.tabParam != null) {
				GVSpl.tabParam.resetEnv();
			}
			return;
		case GC.iOPTIONS:
			boolean showDB = ConfigOptions.bShowDBStruct;
			float oldRowHeight = ConfigOptions.fRowHeight;
			Font oldFont = GC.font;
			new com.scudata.ide.spl.dialog.DialogOptions().setVisible(true);
			((SPL) GV.appFrame).refreshOptions();
			if (showDB != ConfigOptions.bShowDBStruct) {
				if (GVSpl.tabParam != null) {
					GVSpl.tabParam.resetEnv();
				}
			}
			if (oldRowHeight != ConfigOptions.fRowHeight
					|| oldFont.getSize() != GC.font.getSize()
					|| oldFont.getStyle() != GC.font.getStyle()
					|| !oldFont.getFontName().equals(GC.font.getFontName())) {
				// ѡ???޸??????塢?ֺŻ????и?
				GVSpl.panelValue.tableValue.refreshOptions();
			}
			return;

		case GCSpl.iFILE_REPLACE:
			DialogFileReplace dfr = new DialogFileReplace(GV.appFrame) {
				private static final long serialVersionUID = 1L;

				public PgmCellSet readEncryptedCellSet(String filePath,
						String fileName) throws Exception {
					fileResultMap.put(
							filePath,
							IdeSplMessage.get().getMessage("spl.errorsplfile",
									fileName));
					return null;
				}

			};
			dfr.setVisible(true);
			return;
		case GC.iSHOW_WINLIST:
			((SPL) GV.appFrame).switchWinList();
			GM.resetAllSheetStyle();
			return;
		case GC.iVIEW_CONSOLE:
			((SPL) GV.appFrame).viewLeft();
			return;
		case GC.iVIEW_RIGHT:
			((SPL) GV.appFrame).viewRight();
			return;
		case GC.iCASCADE:
		case GC.iTILEHORIZONTAL:
		case GC.iTILEVERTICAL:
		case GC.iLAYER:
			GV.appFrame.arrangeSheet(cmd);
			GM.resetAllSheetStyle();
			return;
		case GC.iABOUT:
			DialogAbout da = new DialogAbout();
			da.init();
			da.setVisible(true);
			return;
		case GC.iMEMORYTIDY:
			if (GV.dialogMemory == null) {
				GV.dialogMemory = new DialogMemory() {
					private static final long serialVersionUID = 1L;

					protected void cleanMemory() {
						if (ControlUtilsBase.wrapStringBuffer != null) {
							ControlUtilsBase.wrapStringBuffer.clear();
						}
					}
				};
			}
			GV.dialogMemory.setVisible(true);
			return;
			// case GCSpl.iFILE_EXPORTTXT:
			// ((SheetSpl) GV.appSheet).exportTxt();
			// return;
			// case GCSpl.iFUNC_MANAGER:
			// DialogFuncEditor dfe = new DialogFuncEditor(GV.appFrame, false);
			// dfe.setVisible(true);
			// return;
		}
		// sheet commands
		GV.appSheet.executeCmd(cmd);
	}

	/**
	 * ???????ָ??????ȡ??Ԫ?????
	 * 
	 * @param cellSet
	 *            ????
	 * @param rect
	 *            ????
	 * @return
	 */
	public static Matrix getMatrixCells(CellSet cellSet, CellRect rect) {
		return getMatrixCells(cellSet, rect, true);
	}

	/**
	 * ???????ָ??????ȡ??Ԫ?????
	 * 
	 * @param cellSet
	 *            ????
	 * @param rect
	 *            ????
	 * @param cloneCell
	 *            ??Ԫ???Ƿ??¡
	 * @return
	 */
	public static Matrix getMatrixCells(CellSet cellSet, CellRect rect,
			boolean cloneCell) {
		if (rect == null) {
			return null;
		}
		int rowSize = 0;
		CellSetParser csp = new CellSetParser(cellSet);
		for (int i = 0; i < rect.getRowCount(); i++) {
			if (csp.isRowVisible(rect.getBeginRow() + i)) {
				rowSize++;
			}
		}
		int colSize = 0;
		for (int j = 0; j < rect.getColCount(); j++) {
			if (csp.isColVisible((int) (j + rect.getBeginCol()))) {
				colSize++;
			}
		}
		if (rowSize == 0 || colSize == 0) {
			return null;
		}
		Matrix m = new Matrix(rowSize, colSize);
		NormalCell nc;
		int rs = 0;
		for (int i = 0; i < rect.getRowCount(); i++) {
			int row = rect.getBeginRow() + i;
			if (!csp.isRowVisible(row)) {
				continue;
			}
			int cs = 0;
			for (int j = 0; j < rect.getColCount(); j++) {
				int col = (int) (j + rect.getBeginCol());
				if (!csp.isColVisible(col)) {
					continue;
				}
				NormalCell temp = (NormalCell) cellSet.getCell(row, col);
				if (cloneCell) {
					nc = (NormalCell) temp.deepClone();
				} else {
					nc = (NormalCell) temp;
				}
				nc.setValue(GM.getOptionTrimChar0Value(temp.getValue()));
				m.set(rs, cs, nc);
				cs++;
			}
			rs++;
		}
		return m;
	}

	/**
	 * ȡ?ƶ???????ӵ?ԭ???????
	 * 
	 * @param editor
	 *            ????༭??
	 * @param srcRect
	 *            Դ????
	 * @param tarRect
	 *            Ŀ??????
	 * @return
	 */
	public static Vector getMoveRectCmd(SplEditor editor,
			CellRect srcRect, CellRect tarRect) {
		if (editor == null) {
			return null;
		}
		if (srcRect.getColCount() == 0) {
			return null;
		}
		SheetSpl sheet = (SheetSpl) GV.appSheet;
		if (sheet != null) {
			try {
				sheet.moveRect(srcRect, tarRect);
			} catch (Exception ex) {
				GM.showException(ex);
				return null;
			}
		}

		Vector cmds = new Vector();
		CellSet ics = editor.getComponent().getCellSet();

		int cols = tarRect.getEndCol() - ics.getColCount();
		if (cols > 0) {
			cmds.add(editor.getAppendCols(cols));
		}

		int rows = tarRect.getEndRow() - ics.getRowCount();
		if (rows > 0) {
			cmds.add(editor.getAppendRows(rows));
		}

		Matrix srcCells = getMatrixCells(ics, srcRect);
		CellSelection cs = new CellSelection(srcCells, srcRect, editor
				.getComponent().getCellSet());
		AtomicSpl ad = new AtomicSpl(editor.getComponent());
		ad.setType(AtomicSpl.MOVE_RECT);
		ad.setRect(tarRect);
		ad.setValue(cs);
		cmds.add(ad);
		return cmds;
	}

	/**
	 * ȡ?????п???
	 * 
	 * @param cs
	 *            ????
	 * @param col
	 *            ??
	 * @return
	 */
	public static float getMaxColWidth(CellSet cs, int col) {
		if (cs == null || cs.getColCount() < col || col < 1) {
			return -1;
		}
		int rc = cs.getRowCount();
		NormalCell nc;
		String cellText;
		float maxWidth = -1, temp;
		Font font = GC.font;
		for (int row = 1; row <= rc; row++) {
			nc = (NormalCell) cs.getCell(row, col);
			if (nc == null) {
				continue;
			}
			cellText = nc.getExpString();
			if (cellText == null) {
				continue;
			}
			temp = ControlUtils.getStringMaxWidth(cellText, font);
			if (maxWidth < temp) {
				maxWidth = temp;
			}
		}
		if (maxWidth < GCSpl.MIN_COL_WIDTH) {
			return GCSpl.MIN_COL_WIDTH;
		}
		return maxWidth;
	}

	/**
	 * ȡ?????и߶?
	 * 
	 * @param cs
	 *            ????
	 * @param row
	 *            ?к?
	 * @return
	 */
	public static float getMaxRowHeight(CellSet cs, int row, float scale) {
		if (cs == null || cs.getRowCount() < row || row < 1) {
			return -1;
		}
		CellSetParser parser = new CellSetParser(cs);
		int cc = cs.getColCount();
		NormalCell nc;
		String cellText;
		float maxHeight = -1, temp;
		for (int col = 1; col <= cc; col++) {
			nc = (NormalCell) cs.getCell(row, col);
			if (nc == null) {
				continue;
			}
			Font font = GC.font;
			cellText = nc.getExpString();
			if (cellText == null) {
				continue;
			}
			float width = parser.getColWidth(col, scale);
			temp = ControlUtils.getStringHeight(cellText, width, font);
			if (maxHeight < temp) {
				maxHeight = temp;
			}
		}
		if (maxHeight < GCSpl.MIN_ROW_HEIGHT) {
			return GCSpl.MIN_ROW_HEIGHT;
		}
		return maxHeight;
	}

	/**
	 * ?ӳ???????ҳ???޸?״̬
	 */
	public static void invokeSheetChanged() {
		SwingUtilities.invokeLater(new Runnable() {
			public void run() {
				GV.appSheet.setChanged(true);
			}
		});
	}

	/**
	 * ?????ı??ļ???spl?ļ?
	 * 
	 * @return
	 */
	// public static boolean importTxt2Spl() {
	// File file = GM.dialogSelectFile(AppConsts.FILE_SPL);
	// if (file == null) {
	// return false;
	// }
	// try {
	// String filePath = file.getAbsolutePath();
	// PgmCellSet cellSet = readSPL(filePath);
	// filePath = getNotDuplicateName(filePath, AppConsts.FILE_SPL);
	// ((SPL) GV.appFrame).openSheet(filePath, cellSet, false);
	// invokeSheetChanged();
	// } catch (Throwable ex) {
	// GM.showException(ex);
	// return false;
	// }
	// return true;
	// }

	/**
	 * ??ȡSPL?ļ???????????
	 * 
	 * @param filePath
	 *            SPL?ļ?·??
	 * @return
	 * @throws Exception
	 */
	public static PgmCellSet readSPL(String filePath) throws Exception {
		PgmCellSet cellSet = AppUtil.readSPL(filePath);
		if (cellSet == null) {
			cellSet = new PgmCellSet(ConfigOptions.iRowCount.intValue(),
					ConfigOptions.iColCount.intValue());
		}
		cellSet.setName(filePath);
		return cellSet;
	}

	/**
	 * Set Locale according to options
	 * 
	 */
	public static void setOptionLocale() {
		try {
			ConfigFile cf = ConfigFile.getConfigFile();
			cf.setConfigNode(ConfigFile.NODE_OPTIONS);
			String val = cf.getAttrValue("iLocale");
			if (StringUtils.isValidString(val)) {
				Byte ii = Byte.valueOf(val);
				if (ii != null) {
					ConfigOptions.iLocale = ii;
				}
			}
			/* Currently there are only two versions in Chinese and English */
			if (ConfigOptions.iLocale != null) {
				switch (ConfigOptions.iLocale.byteValue()) {
				case GC.ASIAN_CHINESE:
					Locale.setDefault(Locale.SIMPLIFIED_CHINESE);
					break;
				default:
					Locale.setDefault(Locale.ENGLISH);
					break;
				}
				GC.initLocale();
			} else {
				if (GC.LANGUAGE == GC.ASIAN_CHINESE) {
				} else if (GC.LANGUAGE != GC.ENGLISH) {
					ConfigOptions.iLocale = new Byte(GC.ENGLISH);
					Locale.setDefault(Locale.ENGLISH);
					GC.initLocale();
				}
			}
		} catch (Throwable e) {
			Locale.setDefault(Locale.ENGLISH);
			e.printStackTrace();
		}
		GC.resetLocal();
	}

	/**
	 * ȡ??????????
	 * 
	 * @return
	 */
	public static String getNewName() {
		String pre = GCSpl.PRE_NEWPGM;
		return getNewName(pre);
	}

	/**
	 * ȡ???ظ?????????????
	 * 
	 * @param pre
	 * @return
	 */
	public static String getNewName(String pre) {
		String[] titles = ((SPL) GV.appFrame).getSheetTitles();
		return StringUtils.getNewName(pre, titles);
		// String[] titles = ((SPL) GV.appFrame).getSheetTitles();
		// ArrayList names = new ArrayList();
		// if (titles != null) {
		// for (int i = 0; i < titles.length; i++) {
		// names.add(titles[i]);
		// }
		// }
		// int index = 1;
		// while (names.contains(pre + index)) {
		// index++;
		// }
		// return pre + index;
	}

	/**
	 * ????水ť
	 */
	public static void enableSave() {
		if (GVSpl.splEditor != null)
			GVSpl.splEditor.setDataChanged(true);
		enableSave(true);
	}

	/**
	 * ?޸ı??水ť״̬
	 * 
	 * @param isDataChanged
	 *            ?Ƿ񼤻?水ť
	 */
	public static void enableSave(boolean isDataChanged) {
		if (GV.appMenu != null) {
			((AppMenu) GV.appMenu).enableSave(isDataChanged);
		}
		if (GV.appTool != null) {
			((AppToolBar) GV.appTool).enableSave(isDataChanged);
		}
	}

	/**
	 * config.txt?ļ??еļ???
	 */
	private static final String KEY_JVM = "jvm_args";
	public static final String KEY_XMX = "-Xmx";
	public static final String KEY_XMS = "-Xms";
	public static final String KEY_PRINT_GC_DETAILS = "-XX:+PrintGCDetails";
	public static final String KEY_PRINT_GC_TIMESTAMPS = "-XX:+PrintGCTimeStamps";
	public static final String KEY_PRINT_GC_DATESTAMPS = "-XX:+PrintGCDateStamps";
	public static final String KEY_GC_LOG = "-Xloggc:";
	public static final String KEY_PRINT_GC_HEAP = "-XX:+PrintHeapAtGC";

	private static String[] getJVMArgs() {
		// config.txt??????ͬ????ʽ
		String str;
		// if (GM.isWindowsOS()) {
		str = getConfigValue(KEY_JVM);
		// } else {
		// str = readConfigTxt();
		// }
		if (str == null)
			return null;
		List jvmArgs = new ArrayList();
		ArgumentTokenizer at = new ArgumentTokenizer(str, ' ');
		while (at.hasNext()) {
			String arg = at.next();
			if (StringUtils.isValidString(arg)) {
				jvmArgs.add(arg.trim());
			}
		}
		return jvmArgs.toArray(new String[jvmArgs.size()]);
	}

	/**
	 * ȡJVM????
	 * 
	 * @param keys
	 * @return
	 */
	public static Map getJVMArgs(String[] keys) {
		if (keys == null || keys.length == 0)
			return null;
		String[] args = getJVMArgs();
		if (args == null)
			return null;
		HashMap map = new HashMap();
		for (int i = 0; i < args.length; i++) {
			if (StringUtils.isValidString(args[i])) {
				args[i] = args[i].trim();
				for (String key : keys) {
					if (args[i].toLowerCase().startsWith(key.toLowerCase())) {
						map.put(key, args[i]);
						break;
					}
				}
			}
		}
		return map;
	}

	/**
	 * ????JVM????
	 * 
	 * @param map
	 *            key:value
	 */
	public static void setJVMArgs(Map map) {
		if (map == null)
			return;
		String[] jvmArgs = getJVMArgs();
		List args = new ArrayList();
		if (jvmArgs != null) {
			for (String arg : jvmArgs) {
				args.add(arg);
			}
		}
		Iterator it = map.keySet().iterator();
		while (it.hasNext()) {
			String key = it.next();
			boolean containsKey = false;
			for (int i = 0; i < args.size(); i++) {
				String arg = args.get(i);
				// ???в???
				if (arg.toLowerCase().startsWith(key.toLowerCase())) {
					String value = map.get(key);
					args.set(i, value);
					containsKey = true;
					break;
				}
			}
			// ????????
			if (!containsKey) {
				String value = map.get(key);
				args.add(value);
			}
		}

		StringBuffer buf = new StringBuffer();
		for (String arg : args) {
			if (!StringUtils.isValidString(arg)) // ??????ɾ??
				continue;
			if (buf.length() > 0) {
				buf.append(" ");
			}
			buf.append(arg);
		}
		// config.txt??????ͬ????ʽ
		// if (GM.isWindowsOS()) {
		setConfigValue(KEY_JVM, buf.toString());
		// } else {
		// writeConfigTxt(buf.toString());
		// }
	}

	/**
	 * ȡ?????ļ???·??
	 * 
	 * @return
	 */
	private static String getConfigTxtFilePath() {
		String binPath = GM.getAbsolutePath("bin");
		String configFile = new File(binPath, "config.txt").getAbsolutePath();
		return configFile;
	}

	/**
	 * ??ȡbin/config.txt
	 * 
	 * @return
	 */
	private static String readConfigTxt() {
		try {
			String configFile = getConfigTxtFilePath();
			FileObject fo = new FileObject(configFile);
			Object obj = fo.read(0, -1, null);
			if (obj != null && obj instanceof Sequence) {
				Sequence seq = (Sequence) obj;
				obj = seq.ifn();
			}
			if (obj == null)
				return null;
			return obj.toString().trim();
		} catch (Exception x) {
			Logger.error(x);
		}
		return null;
	}

	/**
	 * дbin/config.txt
	 * 
	 * @param contentStr
	 */
	private static void writeConfigTxt(String contentStr) {
		try {
			String configFile = getConfigTxtFilePath();
			FileObject fo = new FileObject(configFile);
			fo.write(contentStr, null);
		} catch (Exception x) {
			Logger.error(x);
		}
	}

	/**
	 * ??config.txt?ļ???ȡָ??????ֵ
	 * 
	 * @param key
	 * @return
	 */
	public static String getConfigValue(String key) {
		try {
			String segValue = readConfigTxt();
			Segment seg = new Segment(segValue);
			return seg.getValueWithoutRemove(key);
		} catch (Exception x) {
		}
		return null;
	}

	/**
	 * ????config.txt?ļ??еļ?ֵ
	 * 
	 * @param key
	 * @param value
	 */
	public static void setConfigValue(String key, String value) {
		try {
			String segValue = readConfigTxt();
			Segment seg = new Segment(segValue);
			seg.put(key, value, false);
			String configFile = getConfigTxtFilePath();
			FileObject fo = new FileObject(configFile);
			fo.write(seg.toString(), null);
		} catch (Exception e) {
			GM.showException(e);
		}
	}

	/**
	 * ȡ???????ʽ
	 * 
	 * @param cellSet
	 * @return
	 */
	public static String[][] getCellSetExps(PgmCellSet cellSet) {
		int rc = cellSet.getRowCount();
		int cc = cellSet.getColCount();
		String[][] cellExps = new String[rc][cc];
		for (int r = 1; r <= rc; r++) {
			for (int c = 1; c <= cc; c++) {
				PgmNormalCell cell = cellSet.getPgmNormalCell(r, c);
				if (cell != null) {
					cellExps[r - 1][c - 1] = cell.getExpString();
				}
			}
		}
		return cellExps;
	}

	/**
	 * ȡ?仯?ĵ?Ԫ?????ʽ
	 * 
	 * @return ????null??ʾ?ޱ仯
	 */
	public static Map getExpChangedMap(PgmCellSet cellSet,
			String[][] cellExps) {
		Map map = new HashMap();
		int rc = cellSet.getRowCount();
		int cc = cellSet.getColCount();
		for (int r = 1; r <= rc; r++) {
			for (int c = 1; c <= cc; c++) {
				PgmNormalCell cell = cellSet.getPgmNormalCell(r, c);
				String oldExp = null;
				if (cellExps.length >= r && cellExps[r - 1].length >= c) {
					oldExp = cellExps[r - 1][c - 1];
				}
				String newExp = null;
				if (cell != null) {
					newExp = cell.getExpString();
				}
				boolean expChanged = false;
				if (newExp == null) {
					if (oldExp != null) {
						expChanged = true;
					}
				} else if (!newExp.equals(oldExp)) {
					expChanged = true;
				}
				if (expChanged) {
					map.put(CellLocation.getCellId(r, c), newExp);
				}
			}
		}
		if (map.isEmpty())
			return null;
		return map;
	}

	public static Table getDBTable(DBObject dbo) {
		Table dbTable = new Table(new String[] { GCSpl.TITLE_NAME,
				GCSpl.TITLE_PROP });
		if (dbo == null)
			return dbTable;
		DBInfo info = dbo.getDbSession().getInfo();
		if (info == null) {
			return dbTable;
		}
		dbTable.newLast(new Object[] { GCSpl.DB_NAME, info.getName() });
		if (info instanceof DBConfig) {
			int type = info.getDBType();
			dbTable.newLast(new Object[] { GCSpl.DB_TYPE,
					DBTypeEx.getDBTypeName(type) });

			DBConfig dc = (DBConfig) info;
			dbTable.newLast(new Object[] { GCSpl.DRIVER, dc.getDriver() });
			dbTable.newLast(new Object[] { GCSpl.URL, dc.getUrl() });
			dbTable.newLast(new Object[] { GCSpl.USER, dc.getUser() });
			String pwd = dc.getPassword();
			dbTable.newLast(new Object[] { GCSpl.PASSWORD, pwd });
			dbTable.newLast(new Object[] { GCSpl.USE_SCHEMA,
					Boolean.toString(dc.isUseSchema()) });
			dbTable.newLast(new Object[] { GCSpl.ADD_TILDE,
					Boolean.toString(dc.isAddTilde()) });
		}
		return dbTable;
	}

	/**
	 * ?ƶ????????????????ڼ???ճ??
	 * 
	 * @param cellSet
	 * @param fromRect
	 * @param toRect
	 */
	public static List moveArea(PgmCellSet cellSet, Area fromArea,
			Area toArea) {
		CellRect fromRect = new CellRect(fromArea);
		CellRect toRect = new CellRect(toArea);

		int toEndRow = toRect.getEndRow();
		int toEndCol = toRect.getEndCol();

		int rowCount = cellSet.getRowCount();
		int colCount = cellSet.getColCount();

		if (toEndRow > rowCount) {
			cellSet.addRow(toEndRow - rowCount);
		}

		if (toEndCol > colCount) {
			cellSet.addCol(toEndCol - colCount);
		}

		Matrix fromData = GMSpl.getMatrixCells(cellSet, fromRect);
		List errorCells = new ArrayList();
		NormalCell nc;
		int dr = toRect.getBeginRow() - fromRect.getBeginRow();
		int dc = (int) (toRect.getBeginCol() - fromRect.getBeginCol());

		// ?Ȼ?ԭԴ???ӣ????????ص?ʱ???????Ȼ?ԭ
		for (int r = 0; r < fromRect.getRowCount(); r++) {
			for (int c = 0; c < fromRect.getColCount(); c++) {
				nc = cellSet.newCell(r + 1, c + 1);
				cellSet.setCell(fromRect.getBeginRow() + r,
						(int) (fromRect.getBeginCol() + c), nc);
			}
		}

		// ????Ŀ?????
		for (int r = 0; r < toRect.getRowCount(); r++) {
			for (int c = 0; c < toRect.getColCount(); c++) {
				nc = (NormalCell) fromData.get(r, c);
				if (nc == null) {
					cellSet.setCell(toRect.getBeginRow() + r,
							(int) (toRect.getBeginCol() + c), null);
				} else {
					cellSet.setCell(toRect.getBeginRow() + r,
							(int) (toRect.getBeginCol() + c),
							(NormalCell) nc.deepClone());
				}
			}
		}

		// Ŀ???????????ϣ?????????һ????Ա???ʽ
		if (dr >= 0) {
			if (dc >= 0) {
				for (int r = toRect.getRowCount() - 1; r >= 0; r--) {
					for (int c = (int) (toRect.getColCount() - 1); c >= 0; c--) {
						List tmp = AtomicSpl.exeAdjust(cellSet,
								fromRect, toRect, r, c, fromData == null ? null
										: (NormalCell) fromData.get(r, c));
						if (tmp != null)
							errorCells.addAll(tmp);
					}
				}
			} else {
				for (int r = toRect.getRowCount() - 1; r >= 0; r--) {
					for (int c = 0; c < toRect.getColCount(); c++) {
						List tmp = AtomicSpl.exeAdjust(cellSet,
								fromRect, toRect, r, c, fromData == null ? null
										: (NormalCell) fromData.get(r, c));
						if (tmp != null)
							errorCells.addAll(tmp);
					}
				}
			}
		} else {
			if (dc >= 0) {
				for (int r = 0; r < toRect.getRowCount(); r++) {
					for (int c = (int) (toRect.getColCount() - 1); c >= 0; c--) {
						List tmp = AtomicSpl.exeAdjust(cellSet,
								fromRect, toRect, r, c, fromData == null ? null
										: (NormalCell) fromData.get(r, c));
						if (tmp != null)
							errorCells.addAll(tmp);
					}
				}
			} else {
				for (int r = 0; r < toRect.getRowCount(); r++) {
					for (int c = 0; c < toRect.getColCount(); c++) {
						List tmp = AtomicSpl.exeAdjust(cellSet,
								fromRect, toRect, r, c, fromData == null ? null
										: (NormalCell) fromData.get(r, c));
						if (tmp != null)
							errorCells.addAll(tmp);
					}
				}
			}
		}
		return errorCells;
	}

}




© 2015 - 2024 Weber Informatics LLC | Privacy Policy