orderinfo.java

简易的客服管理系统,采用easyJweb框架,实现简单的功能

package com.easycrm.asp.business;

import java.text.SimpleDateFormat;
import java.util.ArrayList;
import java.util.Collection;
import java.util.Date;
import java.util.List;

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

public class OrderInfo implements IObject {
private String cid;
private String belongDept;
private String sn;
private String customersSn;
private String customersTitle;
private String vdate;
private String bdate;
private String sdate;
private String productSn;
private String productTitle;
private String types;
private String unit;
private String dianhua;
private String dizhi;
private String salePrice;
private String handPerson;
private String inputUser;
private Date inputTime;
private String isFix;
private String des;
private float totalAmount;
private float fit;
private float trit;
private Integer payment;
private Integer times;
private Integer delivery;
private String deliveryDept;


static final private SimpleDateFormat df=new SimpleDateFormat("yyyy-MM-dd");
public static OrderInfo read(String cid)
{
	EasyJDB db=EasyJDB.getInstance();		
	return (OrderInfo)db.get(OrderInfo.class,cid);
}
public static OrderInfo readBySn(String sn)
{
	EasyJDB db=EasyJDB.getInstance();
	Collection paras=new ArrayList();
	paras.add(sn);
	return (OrderInfo)db.read(OrderInfo.class,"sn=?",paras);
}

public static List query(String scope)
{
	EasyJDB db=EasyJDB.getInstance();
	return db.query(OrderInfo.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 produceColor()
{
	String ret="#CC33FF";
	EasyJDB db=EasyJDB.getInstance();
	
	Number num0=(Number)db.uniqueResult("select count(*) from OrderInfo where sn='"+this.sn+"' and delivery=0");
	Number num1=(Number)db.uniqueResult("select count(*) from OrderInfo where sn='"+this.sn+"' and delivery=1");
	
	
	if(num0.intValue()==0){
		ret="#F8FCF8";
		
	}
	if(num1.intValue()==1){
		ret="yellow";
		
	}
	
	
	return ret;
}
public String paymentTitle()
{
	if(this.payment==null)return "";
	if(this.payment.intValue()==0)
		return "未付";
	else if(this.payment.intValue()==5)
		return "已付";	
	else return "";
}
public String deliveryTitle()
{
	if(this.delivery==null)return "";
	if(this.delivery.intValue()==0)
		return "未处理";
	else if(this.delivery.intValue()==1)
		return "处理中";	
	else if(this.delivery.intValue()==5)
		return "已处理";	
	else return "";
}

public String showVdate()
{
	if(vdate==null)return "";
	return df.format(vdate);
}
	public String getTableName() {
		// TODO Auto-generated method stub
		return "OrderInfo";
	}

	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 String getCustomersSn() {
		return customersSn;
	}

	public void setCustomersSn(String customersSn) {
		this.customersSn = customersSn;
	}

	public String getHandPerson() {
		return handPerson;
	}

	public void setHandPerson(String handPerson) {
		this.handPerson = handPerson;
	}

	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 getSn() {
		return sn;
	}

	public void setSn(String sn) {
		this.sn = sn;
	}

	
	public String getDianhua() {
		return dianhua;
	}
	public void setDianhua(String dianhua) {
		this.dianhua = dianhua;
	}
	public String getDizhi() {
		return dizhi;
	}
	public void setDizhi(String dizhi) {
		this.dizhi = dizhi;
	}
	
	public String getVdate() {
		return vdate;
	}
	public void setVdate(String vdate) {
		this.vdate = vdate;
	}
	public Integer getDelivery() {
		return delivery;
	}
	public void setDelivery(Integer delivery) {
		this.delivery = delivery;
	}
	public String getDeliveryDept() {
		return deliveryDept;
	}
	public void setDeliveryDept(String deliveryDept) {
		this.deliveryDept = deliveryDept;
	}
	public Integer getPayment() {
		return payment;
	}
	public void setPayment(Integer payment) {
		this.payment = payment;
	}
	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub

	}
	
	public String getDes() {
		return des;
	}
	public void setDes(String des) {
		this.des = des;
	}
	public float getFit() {
		return fit;
	}
	public void setFit(float fit) {
		this.fit = fit;
	}
	public String getIsFix() {
		return isFix;
	}
	public void setIsFix(String isFix) {
		this.isFix = isFix;
	}
	public String getProductSn() {
		return productSn;
	}
	public void setProductSn(String productSn) {
		this.productSn = productSn;
	}
	public String getSalePrice() {
		return salePrice;
	}
	public void setSalePrice(String salePrice) {
		this.salePrice = salePrice;
	}
	
	public String getBdate() {
		return bdate;
	}
	public void setBdate(String bdate) {
		this.bdate = bdate;
	}
	public String getSdate() {
		return sdate;
	}
	public void setSdate(String sdate) {
		this.sdate = sdate;
	}
	public Integer getTimes() {
		return times;
	}
	public void setTimes(Integer times) {
		this.times = times;
	}
	public float getTotalAmount() {
		return totalAmount;
	}
	public void setTotalAmount(float totalAmount) {
		this.totalAmount = totalAmount;
	}
	public float getTrit() {
		return trit;
	}
	public void setTrit(float trit) {
		this.trit = trit;
	}
	public String getTypes() {
		return types;
	}
	public void setTypes(String types) {
		this.types = types;
	}
	public String getUnit() {
		return unit;
	}
	public void setUnit(String unit) {
		this.unit = unit;
	}
	public String getCustomersTitle() {
		return customersTitle;
	}
	public void setCustomersTitle(String customersTitle) {
		this.customersTitle = customersTitle;
	}
	public String getProductTitle() {
		return productTitle;
	}
	public void setProductTitle(String productTitle) {
		this.productTitle = productTitle;
	}
	
}