exsheetbean.java

我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统我的系在线考试系统

package net.intuitsoft.xeon.table.sale.ex;

import intuitsoft.eclipse.table.common.DatabaseConnection;
import intuitsoft.eclipse.table.common.WriteLog;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

/**
 * author: kent
 */
public class ExSheetBean implements ExSheetModel, java.lang.Cloneable {
	public ExSheetBean(String jndi) {
		this.jndiName = jndi;
	}

	String jndiName = "";

	public String getJndiName() {
		return this.jndiName;
	}

	public void setJndiName(String sV) {
		if (sV != null) {
			this.jndiName = sV;
		}
	}

	private String exSheetCode = "";

	private int computer = 0;

	private int operator = 0;

	private int compID = 0;

	private int type = 0;

	private boolean redBlue = false;

	private boolean isFill = false;

	private boolean isReg = false;

	private boolean isRegLed = false;

	private boolean isAcc = false;

	private boolean isEnd = false;

	private boolean isPosRec = false;

	private boolean isExt = false;

	private boolean isExtAcc = false;

	private boolean isBack = false;

	private boolean isVou = false;

	private String createDate = "";

	private String accDate = "";

	private String regDate = "";

	private String arrDate = "";

	private int emplID = 0;

	private String depID = "";

	private int brandID = 0;

	private double regName = 0;

	private String auditingName = "";

	private double marketName = 0;

	private String finName = "";

	private int custID = 0;

	private int warehouseCode = 0;

	private String currency = "";

	private double cRate = 0;

	private String orderID = "";

	private String invoNo = "";

	private String invoVer = "";

	private double qua = 0;

	private double amo = 0;

	private double costAmo = 0;

	private double discount = 1;

	private double realAmo = 0;

	private double payAmo = 0;

	private double preAmo = 0;

	private String logID = "";

	private String fillSheetID = "";

	private String remark = "";

	private double haveCheck = 0;

	private int userName = 0;

	private String userTel = "";

	private String userAddress = "";

	private int applyState = 0;

	private String recDate = "";

	private boolean isChecked = false;

	private String opTime = "";

	private int settleID = 0;

	private boolean isRec = false;

	private double recAmo = 0;

	private double msAmo = 0;

	public int getSettleID() {
		return this.settleID;
	}

	public void setSettleID(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.settleID = Integer.parseInt(sV);
		}
	}

	public void setSettleID(int nV) {
		this.settleID = nV;
	}

	public String getExSheetCode() {
		return this.exSheetCode;
	}

	public void setExSheetCode(String sV) {
		if (sV != null) {
			this.exSheetCode = sV;
		}
	}

	public int getComputer() {
		return this.computer;
	}

	public void setComputer(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.computer = Integer.parseInt(sV);
		}
	}

	public void setComputer(int nV) {
		this.computer = nV;
	}

	public int getOperator() {
		return this.operator;
	}

	public void setOperator(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.operator = Integer.parseInt(sV);
		}
	}

	public void setOperator(int nV) {
		this.operator = nV;
	}

	public int getCompID() {
		return this.compID;
	}

	public void setCompID(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.compID = Integer.parseInt(sV);
		}
	}

	public void setCompID(int nV) {
		this.compID = nV;
	}

	public int getType() {
		return this.type;
	}

	public void setType(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.type = Integer.parseInt(sV);
		}
	}

	public void setType(int nV) {
		this.type = nV;
	}

	public boolean getRedBlue() {
		return this.redBlue;
	}

	public void setRedBlue(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.redBlue = true;
		} else {
			this.redBlue = false;
		}
	}

	public void setRedBlue(boolean b) {
		this.redBlue = b;
	}

	public boolean getIsFill() {
		return this.isFill;
	}

	public void setIsFill(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.isFill = true;
		} else {
			this.isFill = false;
		}
	}

	public void setIsFill(boolean b) {
		this.isFill = b;
	}

	public boolean getIsReg() {
		return this.isReg;
	}

	public void setIsReg(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.isReg = true;
		} else {
			this.isReg = false;
		}
	}

	public void setIsReg(boolean b) {
		this.isReg = b;
	}

	public boolean getIsRegLed() {
		return this.isRegLed;
	}

	public void setIsRegLed(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.isRegLed = true;
		} else {
			this.isRegLed = false;
		}
	}

	public void setIsRegLed(boolean b) {
		this.isRegLed = b;
	}

	public boolean getIsAcc() {
		return this.isAcc;
	}

	public void setIsAcc(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.isAcc = true;
		} else {
			this.isAcc = false;
		}
	}

	public void setIsAcc(boolean b) {
		this.isAcc = b;
	}

	public boolean getIsEnd() {
		return this.isEnd;
	}

	public void setIsEnd(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.isEnd = true;
		} else {
			this.isEnd = false;
		}
	}

	public void setIsEnd(boolean b) {
		this.isEnd = b;
	}

	public boolean getIsPosRec() {
		return this.isPosRec;
	}

	public void setIsPosRec(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.isPosRec = true;
		} else {
			this.isPosRec = false;
		}
	}

	public void setIsPosRec(boolean b) {
		this.isPosRec = b;
	}

	public boolean getIsExt() {
		return this.isExt;
	}

	public void setIsExt(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.isExt = true;
		} else {
			this.isExt = false;
		}
	}

	public void setIsExt(boolean b) {
		this.isExt = b;
	}

	public boolean getIsExtAcc() {
		return this.isExtAcc;
	}

	public void setIsExtAcc(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.isExtAcc = true;
		} else {
			this.isExtAcc = false;
		}
	}

	public void setIsExtAcc(boolean b) {
		this.isExtAcc = b;
	}

	public boolean getIsBack() {
		return this.isBack;
	}

	public void setIsBack(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.isBack = true;
		} else {
			this.isBack = false;
		}
	}

	public void setIsBack(boolean b) {
		this.isBack = b;
	}

	public boolean getIsVou() {
		return this.isVou;
	}

	public void setIsVou(String b) {
		if (b == null) {
			return;
		}
		if ("1".equals(b)) {
			this.isVou = true;
		} else {
			this.isVou = false;
		}
	}

	public void setIsVou(boolean b) {
		this.isVou = b;
	}

	public String getCreateDate() {
		return this.createDate;
	}

	public void setCreateDate(String sV) {
		if (sV != null) {
			this.createDate = sV.substring(0, (sV.length() > 10) ? 10 : sV
					.length());
		}
	}

	public String getAccDate() {
		return this.accDate;
	}

	public void setAccDate(String sV) {
		if (sV != null) {
			this.accDate = sV.substring(0, (sV.length() > 10) ? 10 : sV
					.length());
		}
	}

	public String getRegDate() {
		return this.regDate;
	}

	public void setRegDate(String sV) {
		if (sV != null) {
			this.regDate = sV.substring(0, (sV.length() > 10) ? 10 : sV
					.length());
		}
	}

	public String getArrDate() {
		return this.arrDate;
	}

	public void setArrDate(String sV) {
		if (sV != null) {
			this.arrDate = sV.substring(0, (sV.length() > 10) ? 10 : sV
					.length());
		}
	}

	public int getEmplID() {
		return this.emplID;
	}

	public void setEmplID(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.emplID = Integer.parseInt(sV);
		}
	}

	public void setEmplID(int nV) {
		this.emplID = nV;
	}

	public String getDepID() {
		return this.depID;
	}

	public void setDepID(String sV) {
		if (sV != null) {
			this.depID = sV;
		}
	}

	public int getBrandID() {
		return this.brandID;
	}

	public void setBrandID(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.brandID = Integer.parseInt(sV);
		}
	}

	public void setBrandID(int nV) {
		this.brandID = nV;
	}

	public double getRegName() {
		return this.regName;
	}

	public void setRegName(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.regName = Double.parseDouble(sV);
		}
	}

	public void setRegName(double fV) {
		this.regName = fV;
	}

	public String getAuditingName() {
		return this.auditingName;
	}

	public void setAuditingName(String sV) {
		if (sV != null) {
			this.auditingName = sV;
		}
	}

	public double getMarketName() {
		return this.marketName;
	}

	public void setMarketName(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.marketName = Double.parseDouble(sV);
		}
	}

	public void setMarketName(double fV) {
		this.marketName = fV;
	}

	public String getFinName() {
		return this.finName;
	}

	public void setFinName(String sV) {
		if (sV != null) {
			this.finName = sV;
		}
	}

	public int getCustID() {
		return this.custID;
	}

	public void setCustID(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.custID = Integer.parseInt(sV);
		}
	}

	public void setCustID(int nV) {
		this.custID = nV;
	}

	public int getWarehouseCode() {
		return this.warehouseCode;
	}

	public void setWarehouseCode(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.warehouseCode = Integer.parseInt(sV);
		}
	}

	public void setWarehouseCode(int nV) {
		this.warehouseCode = nV;
	}

	public String getCurrency() {
		return this.currency;
	}

	public void setCurrency(String sV) {
		if (sV != null) {
			this.currency = sV;
		}
	}

	public double getCRate() {
		return this.cRate;
	}

	public void setCRate(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.cRate = Double.parseDouble(sV);
		}
	}

	public void setCRate(double fV) {
		this.cRate = fV;
	}

	public String getOrderID() {
		return this.orderID;
	}

	public void setOrderID(String sV) {
		if (sV != null) {
			this.orderID = sV;
		}
	}

	public String getInvoNo() {
		return this.invoNo;
	}

	public void setInvoNo(String sV) {
		if (sV != null) {
			this.invoNo = sV;
		}
	}

	public String getInvoVer() {
		return this.invoVer;
	}

	public void setInvoVer(String sV) {
		if (sV != null) {
			this.invoVer = sV;
		}
	}

	public double getQua() {
		return this.qua;
	}

	public void setQua(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.qua = Double.parseDouble(sV);
		}
	}

	public void setQua(double fV) {
		this.qua = fV;
	}

	public double getAmo() {
		return this.amo;
	}

	public void setAmo(String sV) {
		if (sV != null && !"".equals(sV)) {
			this.amo = Double.parseDouble(sV);
		}
	}

	public void setAmo(double fV) {
		this.amo = fV;
	}