excelimportmanager.java

j2ee源码

package com.leeman.wkexs.common;

import java.util.Date;

import jxl.Cell;
import jxl.CellType;

import com.leeman.common.util.Formatter;
import com.leeman.common.util.SimpleValidation;


public class ExcelImportManager {
	
	public static final String BASICE_ERROR = "B";
	public static final String DATABASE_ERROR = "D";

	public static final String SPLIT_CHAR = ",";	
	public static final String VALID_CODE = "";		

	public static final String INVALID_EMPTY_STRING_CODE = "ETY";
	public static final String INVALID_LENGTH_STRING_CODE = "LEN";
		
	public static final String INVALID_LARGER_CODE = ">";
	public static final String INVALID_LARGER_EQUAL_CODE = ">=";	
	public static final String INVALID_SMALLER_CODE = "<";
	public static final String INVALID_SMALLER_EQUAL_CODE = "<=";	
	public static final String INVALID_EQUAL_CODE = "=";
	public static final String INVALID_NOT_EQUAL_CODE = "<>";	
	
	public static final String INVALID_NUMBER_CODE = "NUM";
	
	public static final String INVALID_DATE_FORMAT_CODE = "D/M/Y";		
	
	private static String validReturn(boolean isValid, String errorCode)
	{
		if (isValid)
		{
			return VALID_CODE;
		}
		else
		{
			return errorCode;
		}
	}
	
	
	public static String chkEmpty(String strInput)
	{
		strInput = strInput.trim();
		
		boolean isValid = !strInput.equals("");
		
		return validReturn(isValid, INVALID_EMPTY_STRING_CODE);
	}
	
	
	public static String chkLength(String strInput, int intLength)
	{
		strInput = strInput.trim();
		
		boolean isValid = (strInput.length() <= intLength);
			
		return validReturn(isValid, INVALID_LENGTH_STRING_CODE + " " + intLength);
	}	
	

	public static String chkTxtNotEqual(String strInput, String strCompWith)
	{
		strInput = strInput.trim();
		strCompWith = strCompWith.trim();
		
		boolean isValid = !(strInput.equals(strCompWith));
			
		return validReturn(isValid, INVALID_EQUAL_CODE);
	}	
	
	public static String chkTxtEqual(String strInput, String strCompWith)
	{
		strInput = strInput.trim();
		strCompWith = strCompWith.trim();
		
		boolean isValid = (strInput.equals(strCompWith));
			
		return validReturn(isValid, INVALID_NOT_EQUAL_CODE);
	}
	
	public static String chkDateFormat(Cell cell)
	{
		boolean isValid = true;
		
		try
		{
			if(cell.getType() != CellType.DATE)
			{
				String value = cell.getContents().trim();
				Formatter.parseDate(value);
			}
		}
		catch(Exception e)
		{
			isValid = false;
		}
			
		return validReturn(isValid, INVALID_DATE_FORMAT_CODE);			
	}
	
	public static String chkDateAfter(Date dateInput, Date dateCompWith, boolean canEqual)
	{
		String errorCode = "";
		boolean isValid = false;
		
		int result = dateInput.compareTo(dateCompWith);
		
		if(result < 0)
		{
			isValid = true;
		}
		
		if(result > 0)
		{
			isValid = false;
		}
			
		if(!canEqual && result == 0)
		{
			isValid = false;
		}
		
		if(canEqual && result == 0)
		{
			isValid = true;
		}	
		
		if(canEqual)
		{
			errorCode = INVALID_LARGER_EQUAL_CODE;
		}
		else
		{
			errorCode = INVALID_LARGER_CODE;
		}
		
		return validReturn(isValid, errorCode);			
	}	
	
	public static String chkNumeric(String strInput, int digitlen, int dplacelen)
	{	
		strInput = strInput.trim();
		
		boolean isValid = false;
		 
		if(SimpleValidation.isNumeric(strInput))
		{
			double dblInput = Formatter.parseDouble(strInput);
			isValid = SimpleValidation.isDouble(String.valueOf(dblInput), digitlen, dplacelen);
		}
		
		return validReturn(isValid, "(" + digitlen + "," + dplacelen + ")");		
	}
	
	public static String chkNumLarger(String strInput, double dblCompWith)
	{	
		strInput = strInput.trim();
		
		double dblInput = Double.parseDouble(strInput);
		
		boolean isValid = (dblInput > dblCompWith);
		
		return validReturn(isValid, INVALID_LARGER_CODE + " " + String.valueOf(dblCompWith));		
	}

	public static String chkNumLargerEqual(String strInput, double dblCompWith)
	{	
		strInput = strInput.trim();
		
		double dblInput = Double.parseDouble(strInput);
		
		boolean isValid = (dblInput >= dblCompWith);
		
		return validReturn(isValid,  INVALID_LARGER_EQUAL_CODE + " " + String.valueOf(dblCompWith));	
	}

}