pldrkp.java

java操作excel数据批量导入

/*
 * Created on 2004-5-19
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com;

/**
 * @author Administrator
 *
 * To change the template for this generated type comment go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
import java.util.Date;
public class PLDRKP {
	
	private long xh; //序号
	private long kpbh;  //卡片编号
	private long ykpbh;  
	private int kpxz;
	private String zcmc; 
	private String zcbh; 
	private String zcml;
	private int zcfl;
	private int zcgs;
	private int zygs ;
	private String cpsx;//产品属性
	private int zczt;
	private int zjff;
	private int qbnynx;//全部耐用年限
	private int zjnx;//折旧年限	
	private double yz;
	private double jz;/
	private double jcz;//
	private double ljzj;//累计折旧
	private double ljjz;//累计减值
	private final double czl=0.03;//残值率
	private double yzjl;//月折旧率
	private double yzje;//月折旧额
	private String kmdh;//会计科目代码
	private String pzhm;//资产凭证号码
	private String syr ;//使用人
	private String jgggcs;//结构规格程式
	private double sl;//数量
	private String dwbh;//单位编号
	private String sydd;//使用地点或起讫地点
	private Date gmrq;//购建日期
	private Date jkrq;//建卡日期
	private Date kssyrq;//开始使用日期
	private String sybm;//使用部门
	private String glbm;//专业部门
	private String bgy;//责任人
	private String gcbh;//工程编号
	private String gcmc;//工程项目名称
	private String swzcbh;//实物资产编号
	private int zgf;//暂估否
	private int shf;//审核否
	private int fz;//父子
	private long glkpbh;//关联卡片编号
	
	private int sksynx;//尚可使用年限
	private String zyft;//专业分摊
	private String cpft;//产品分摊
	private long fkpbh;//父卡片编号
	private long fkpxh;//父卡片序号
	private int zjlx;  //增加类型
	private String abc;
	private Date rzrq;
	private int zjzt;
	private int sfjt;
	private String khst;
	private String bz;
	private int jslx;
	private int pyf;//盘盈否
	private String zdybm;
	private String jkr;
	private int khsx;
	private String sccj;//生产厂家
	private String tmbh;//条码编号
	private double mgyzje;//美国月折旧额
	private double xgyzje;//香港月折旧额
	
	private String qybm;//使用地点编码
	private String gly;//管理员
	private String sbwzh;//设备位置号
	private String gys;//供应商
	private double bklyl;//板卡利用率
	private double yhszl;//用户实装率
	private double yzmyz;//原帐面原值
	private double yzmjz;//原帐面净值
	private double cxl;//成新率
    private String ywrq ;                  //新:业务日期


    private int k_zclx;//资产类型   1-正常，2-低值一号品   3-科研项目 4-大修项目
	
	
	/**
	 * @return Returns the k_zclx.
	 */
	public int getK_zclx() {
		return k_zclx;
	}
	/**
	 * @param k_zclx The k_zclx to set.
	 */
	public void setK_zclx(int k_zclx) {
		this.k_zclx = k_zclx;
	}
	public long getXh(){
		return this.xh;
	}
	public void setXh(long xh){
		this.xh = xh;
	}
	public long getKpbh(){
		return this.kpbh;
	}
	public void setKpbh(long kpbh){
		this.kpbh = kpbh;
	}
	

	
	public String getbgy() {
		return bgy;
	}

	
	public String getCpsx() {
		return cpsx;
	}

	
	public double getCzl() {
		return czl;
	}

	
	public String getDwbh() {
		return dwbh;
	}

	
	public int getFz() {
		return fz;
	}

	
	public String getGcbh() {
		return gcbh;
	}

	
	public String getGcmc() {
		return gcmc;
	}

	
	public String getGlbm() {
		return glbm;
	}

	
	public long getGlkpbh() {
		return glkpbh;
	}

	
	public Date getGmrq() {
		return gmrq;
	}

	
	public double getJcz() {
		return jcz;
	}


	public String getJgggcs() {
		return jgggcs;
	}


	public Date getJkrq() {
		return jkrq;
	}

	
	public double getJz() {
		return jz;
	}

	
	public String getKmdh() {
		return kmdh;
	}

	
	public int getKpxz() {
		return kpxz;
	}

	
	public Date getKssyrq() {
		return kssyrq;
	}

	
	public double getLjjz() {
		return ljjz;
	}

	
	public double getLjzj() {
		return ljzj;
	}

	
	public String getPzhm() {
		return pzhm;
	}

    public String getSyr() {
		return syr;
	}
	
	public int getQbnynx() {
		return qbnynx;
	}

	
	public int getShf() {
		return shf;
	}

	
	public double getSl() {
		return sl;
	}

	
	public String getSwzcbh() {
		return swzcbh;
	}

	
	public String getSybm() {
		return sybm;
	}

	
	public String getSydd() {
		return sydd;
	}

    public String getYwrq() {
		return ywrq;
	}

    public void setYwrq(String ywrq) {
		this.ywrq = ywrq;
	}

    public long getYkpbh() {
		return ykpbh;
	}

	
	public double getYz() {
		return yz;
	}

	
	public double getYzje() {
		return yzje;
	}

	
	public double getYzjl() {
		return yzjl;
	}

	
	public String getZcbh() {
		return zcbh;
	}

	
	public int getZcfl() {
		return zcfl;
	}

	
	public int getZcgs() {
		return zcgs;
	}

	
	public String getZcmc() {
		return zcmc;
	}

	
	public String getZcml() {
		return zcml;
	}

	public int getZczt() {
		return zczt;
	}

	
	public int getZgf() {
		return zgf;
	}

	
	public int getZjff() {
		return zjff;
	}

	
	public int getZjnx() {
		return zjnx;
	}

	
	public int getZygs() {
		return zygs;
	}

	
	public void setbgy(String bgy) {
		this.bgy = bgy;
	}

	
	public void setCpsx(String cpsx) {
		this.cpsx = cpsx;
	}

	
	
	public void setDwbh(String dwbh) {
		this.dwbh = dwbh;
	}

	
	public void setFz(int fz) {
		this.fz = fz;
	}

	
	public void setGcbh(String gcbh) {
		this.gcbh = gcbh;
	}

	
	public void setGcmc(String gcmc) {
		this.gcmc = gcmc;
	}


	public void setGlbm(String glbm) {
		this.glbm = glbm;
	}

	
	public void setGlkpbh(long glkpbh) {
		this.glkpbh = glkpbh;
	}

	
	public void setGmrq(Date gmrq) {
		this.gmrq = gmrq;
	}

	
	public void setJcz(double jcz) {
		this.jcz = jcz;
	}

	
	public void setJgggcs(String jgggcs) {
		this.jgggcs = jgggcs;
	}

	
	public void setJkrq(Date jkrq) {
		this.jkrq = jkrq;
	}

	
	public void setJz(double jz) {
		this.jz = jz;
	}

	
	public void setKmdh(String kmdh) {
		this.kmdh = kmdh;
	}

	
	public void setKpxz(int kpxz) {
		this.kpxz = kpxz;
	}

	
	public void setKssyrq(Date kssyrq) {
		this.kssyrq = kssyrq;
	}

	
	public void setLjjz(double ljjz) {
		this.ljjz = ljjz;
	}

	
	public void setLjzj(double ljzj) {
		this.ljzj = ljzj;
	}

	
	public void setPzhm(String pzhm) {
		this.pzhm = pzhm;
	}

	public void setSyr(String syr) {
		this.syr = syr;
	}
	public void setQbnynx(int qbnynx) {
		this.qbnynx = qbnynx;
	}

	
	public void setShf(int shf) {
		this.shf = shf;
	}

	
	public void setSl(double sl) {
		this.sl = sl;
	}

	
	public void setSwzcbh(String swzcbh) {
		this.swzcbh = swzcbh;
	}

	
	public void setSybm(String sybm) {
		this.sybm = sybm;
	}

	
	public void setSydd(String sydd) {
		this.sydd = sydd;
	}

	
	public void setYkpbh(long ykpbh) {
		this.ykpbh = ykpbh;
	}

	
	public void setYz(double yz) {
		this.yz = yz;
	}

	
	public void setYzje(double yzje) {
		this.yzje = yzje;
	}

	
	public void setYzjl(double yzjl) {
		this.yzjl = yzjl;
	}

	
	public void setZcbh(String zcbh) {
		this.zcbh = zcbh;
	}

	
	public void setZcfl(int zcfl) {
		this.zcfl = zcfl;
	}

	
	public void setZcgs(int zcfl) {
		this.zcgs = zcfl;
	}

	
	public void setZcmc(String zcmc) {
		this.zcmc = zcmc;
	}

	
	public void setZcml(String zcml) {
		this.zcml = zcml;
	}

	
	public void setZczt(int zczt) {
		this.zczt = zczt;
	}


	public void setZgf(int zgf) {
		this.zgf = zgf;
	}

	
	public void setZjff(int zjff) {
		this.zjff = zjff;
	}

	
	public void setZjnx(int zjnx) {
		this.zjnx = zjnx;
	}

	
	public void setZygs(int zygs) {
		this.zygs = zygs;
	}

	
	public int getSksynx() {
		return sksynx;
	}

	
	public void setSksynx(int sksynx) {
		this.sksynx = sksynx;
	}


	public String getAbc() {
		return abc;
	}


	public String getBz() {
		return bz;
	}


	public String getCpft() {
		return cpft;
	}


	public long getFkpbh() {
		return fkpbh;
	}


	public String getJkr() {
		return jkr;
	}


	public int getJslx() {
		return jslx;
	}


	public String getKhst() {
		return khst;
	}


	public int getPyf() {
		return pyf;
	}


	public Date getRzrq() {
		return rzrq;
	}


	public int getSfjt() {
		return sfjt;
	}


	public int getZjlx() {
		return zjlx;
	}


	public int getZjzt() {
		return zjzt;
	}


	public String getZyft() {
		return zyft;
	}


	public void setAbc(String string) {
		abc = string;
	}


	public void setBz(String string) {
		bz = string;
	}


	public void setCpft(String string) {
		cpft = string;
	}


	public void setFkpbh(long l) {
		fkpbh = l;
	}
	/*//通过序号设置卡片编号
	public void setFkpbh(long fkpxh,String tableName) throws Exception {
		DBConnection db = new DBConnection();
		String sql = " select kpbh from "
		          + tableName  
		          + " where xh = "
		          + fkpxh;
		ResultSet rs = db.executeQuery(sql);
		rs.next();		
		this.setFkpbh(rs.getLong(1));
		rs.close();
	}
	*/

	/**
	 * @param string
	 */
	public void setJkr(String string) {
		jkr = string;
	}


	public void setJslx(int i) {
		jslx = i;
	}


	public void setKhst(String string) {
		khst = string;
	}


	public void setPyf(int i) {
		pyf = i;
	}


	public void setRzrq(Date date) {
		rzrq = date;
	}


	public void setSfjt(int i) {
		sfjt = i;
	}


	public void setZjlx(int i) {
		zjlx = i;
	}


	public void setZjzt(int i) {
		zjzt = i;
	}


	public void setZyft(String string) {
		zyft = string;
	}


	public int getKhsx() {
		return khsx;
	}


	public String getSccj() {
		return sccj;
	}


	public String getTmbh() {
		return tmbh;
	}


	public String getZdybm() {
		return zdybm;
	}


	public void setKhsx(int khsx) {
		khsx = khsx;
	}


	public void setSccj(String string) {
		sccj = string;
	}


	public void setTmbh(String string) {
		tmbh = string;
	}


	public void setZdybm(String string) {
		zdybm = string;
	}


    public long getFkpxh()
    {
        return fkpxh;
    }


    public void setFkpxh(long string)
    {
        fkpxh = string;
    }


    public double getMgyzje()
    {
        return mgyzje;
    }


    public double getXgyzje()
    {
        return xgyzje;
    }


    public void setMgyzje(double d)
    {
        mgyzje = d;
    }


    public void setXgyzje(double d)
    {
        xgyzje = d;
    }


    public double getBklyl()
    {
        return bklyl;
    }


    public double getCxl()
    {
        return cxl;
    }


    public String getGly()
    {
        return gly;
    }


    public String getGys()
    {
        return gys;
    }


    public String getSbwzh()
    {
        return sbwzh;
    }


    public String getQybm()
    {
        return qybm;
    }


    public double getYhszl()
    {
        return yhszl;
    }


    public double getYzmjz()
    {
        return yzmjz;
    }


    public double getYzmyz()
    {
        return yzmyz;
    }


    public void setBklyl(double d)
    {
        bklyl = d;
    }


    public void setCxl(double d)
    {
        cxl = d;
    }


    public void setGly(String string)
    {
        gly = string;
    }


    public void setGys(String string)
    {
        gys = string;
    }


    public void setSbwzh(String string)
    {
        sbwzh = string;
    }


    public void setQybm(String string)
    {
        qybm = string;
    }


    public void setYhszl(double d)
    {
        yhszl = d;
    }


    public void setYzmjz(double d)
    {
        yzmjz = d;
    }

    public void setYzmyz(double d)
    {
        yzmyz = d;
    }

}