package com.easyjf.asp.business;

import java.util.Date;
import java.util.List;

import com.easyjf.dbo.DBMapping;
import com.easyjf.dbo.EasyJDB;
import com.easyjf.dbo.IObject;

public class Ration implements IObject {
	private String cid;
	private String belongDept;
	private String productSn;
	private String materialSn;
	private Float rate;
	private String unit;
	private String remark;
	private String inputUser;
	private Date inputTime;
	private Integer status;
	public static Ration read(String cid)
	{
		EasyJDB db=EasyJDB.getInstance();		
		return (Ration)db.get(Ration.class,cid);
	}
	public String readProductTitle()
	{
		EasyJDB db=EasyJDB.getInstance();		
		String obj=(String)db.uniqueResult("select title from "+ DBMapping.getInstance().findTable(Product.class).getName()+" where sn='"+this.productSn+"'");
		return  obj;
	}
	public String readMaterialTitle()
	{
		EasyJDB db=EasyJDB.getInstance();		
		String obj=(String)db.uniqueResult("select title from "+ DBMapping.getInstance().findTable(Material.class).getName()+" where cid='"+this.materialSn+"'");
		return  obj;
	}
	public static List query(String scope)
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.query(Ration.class,scope);	
	}
	public boolean save()
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.add(this);
	}
	public boolean update()
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.update(this);
	}
	public boolean del()
	{
		EasyJDB db=EasyJDB.getInstance();
		return db.del(this);
	}
	public String getTableName() {		
		// TODO Auto-generated method stub
		return "Ration";
	}

	public String getKeyField() {
		// TODO Auto-generated method stub
		return "cid";
	}

	public String getKeyGenerator() {
		// TODO Auto-generated method stub
		return "com.easyjf.dbo.IdGenerator";
	}

	public String getBelongDept() {
		return belongDept;
	}

	public void setBelongDept(String belongDept) {
		this.belongDept = belongDept;
	}

	public String getCid() {
		return cid;
	}

	public void setCid(String cid) {
		this.cid = cid;
	}

	public Date getInputTime() {
		return inputTime;
	}

	public void setInputTime(Date inputTime) {
		this.inputTime = inputTime;
	}

	public String getInputUser() {
		return inputUser;
	}

	public void setInputUser(String inputUser) {
		this.inputUser = inputUser;
	}

	public String getMaterialSn() {
		return materialSn;
	}

	public void setMaterialSn(String materialSn) {
		this.materialSn = materialSn;
	}

	public String getProductSn() {
		return productSn;
	}

	public void setProductSn(String productSn) {
		this.productSn = productSn;
	}

	public Float getRate() {
		return rate;
	}

	public void setRate(Float rate) {
		this.rate = rate;
	}

	public String getRemark() {
		return remark;
	}

	public void setRemark(String remark) {
		this.remark = remark;
	}

	public Integer getStatus() {
		return status;
	}

	public void setStatus(Integer status) {
		this.status = status;
	}

	public String getUnit() {
		return unit;
	}

	public void setUnit(String unit) {
		this.unit = unit;
	}


}