www.pudn.com > erp0.1.zip > OrderInfo.java

package com.easyjf.asp.business; 
 
import java.math.BigDecimal; 
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 customerSn; 
private Date vdate; 
private Date requireDate; 
private String payType; 
private String linkMan; 
private String tel; 
private String address; 
private String requirement; 
private String remark; 
private BigDecimal amount; 
private String handPerson; 
private String inputUser; 
private Date inputTime; 
private String opUser; 
private String opIntro; 
private Date opTime; 
private Integer status; 
private Integer payment; 
private Integer delivery; 
private String deliveryDept; 
private Customer customer; 
private List children; 
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 OrderInfo findLastOrder() 
{ 
	EasyJDB db=EasyJDB.getInstance();	 
	return (OrderInfo)db.read(OrderInfo.class,"status=-1 order by inputtime desc",null); 
} 
public static List query(String scope) 
{ 
	EasyJDB db=EasyJDB.getInstance(); 
	return db.query(OrderInfo.class,scope);	 
} 
public List children() 
{ 
	if(children==null){ 
	EasyJDB db=EasyJDB.getInstance(); 
	children=db.query(OrderList.class,"orderSn='"+this.sn+"' order by sequence"); 
	} 
	return children; 
} 
public List children(int types) 
{ 
	EasyJDB db=EasyJDB.getInstance(); 
	return db.query(OrderList.class,"orderSn='"+this.sn+"' and types="+types);	 
} 
 
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() 
{ 
	delChildren(); 
	EasyJDB db=EasyJDB.getInstance();	 
	return db.del(this); 
} 
public int delChildren() 
{ 
	EasyJDB db=EasyJDB.getInstance(); 
	int ret=-1; 
	try{ 
		ret=db.execute("delete from OrderList where orderSn='"+this.sn+"'");		 
	} 
	catch(Exception e) 
	{		 
	} 
	return ret; 
} 
public int delChildren(String ids) 
{ 
	EasyJDB db=EasyJDB.getInstance(); 
	int ret=-1; 
	try{ 
		//System.out.println("执行删除:"+ids); 
		if(!ids.equals(""))			 
		ret=db.execute("delete from OrderList where orderSn='"+this.sn+"' and cid not in("+ids+")"); 
		else 
		ret=db.execute("delete from OrderList where orderSn='"+this.sn+"'"); 
	} 
	catch(Exception e) 
	{		 
	} 
	return ret; 
} 
public Customer readCustomer() 
{ 
	if(customer==null) 
	customer=Customer.readBySn(this.customerSn); 
	return customer; 
} 
public String customerTitle() 
{	 
	if(readCustomer()!=null)return customer.getTitle(); 
	else return ""; 
} 
public String deliveryDeptTitle() 
{ 
	if(this.deliveryDept==null)return ""; 
	Customer cu=Customer.readBySn(this.deliveryDept); 
	if(cu!=null)return cu.getTitle(); 
	else return ""; 
} 
public String produceColor() 
{ 
	String ret="#F8FCF8"; 
	EasyJDB db=EasyJDB.getInstance(); 
	try{ 
	Number num=(Number)db.uniqueResult("select count(*) from OrderList where orderSn='"+this.sn+"' and status<2"); 
	if(num.intValue()>0)ret="yellow"; 
	} 
	catch(Exception e) 
	{		 
	} 
	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.payment.intValue()==1) 
		return "已发货";	 
	else if(this.payment.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 getAddress() { 
		return address; 
	} 
 
	public void setAddress(String address) { 
		this.address = address; 
	} 
 
	public BigDecimal getAmount() { 
		return amount; 
	} 
 
	public void setAmount(BigDecimal amount) { 
		this.amount = amount; 
	} 
 
	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 getCustomerSn() { 
		return customerSn; 
	} 
 
	public void setCustomerSn(String customerSn) { 
		this.customerSn = customerSn; 
	} 
 
	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 getLinkMan() { 
		return linkMan; 
	} 
 
	public void setLinkMan(String linkMan) { 
		this.linkMan = linkMan; 
	} 
 
	public String getOpIntro() { 
		return opIntro; 
	} 
 
	public void setOpIntro(String opIntro) { 
		this.opIntro = opIntro; 
	} 
 
	public Date getOpTime() { 
		return opTime; 
	} 
 
	public void setOpTime(Date opTime) { 
		this.opTime = opTime; 
	} 
 
	public String getOpUser() { 
		return opUser; 
	} 
 
	public void setOpUser(String opUser) { 
		this.opUser = opUser; 
	} 
 
	public String getPayType() { 
		return payType; 
	} 
 
	public void setPayType(String payType) { 
		this.payType = payType; 
	} 
 
	public String getRemark() { 
		return remark; 
	} 
 
	public void setRemark(String remark) { 
		this.remark = remark; 
	} 
 
	public Date getRequireDate() { 
		return requireDate; 
	} 
 
	public void setRequireDate(Date requireDate) { 
		this.requireDate = requireDate; 
	} 
 
	public String getRequirement() { 
		return requirement; 
	} 
 
	public void setRequirement(String requirement) { 
		this.requirement = requirement; 
	} 
 
	public String getSn() { 
		return sn; 
	} 
 
	public void setSn(String sn) { 
		this.sn = sn; 
	} 
 
	public Integer getStatus() { 
		return status; 
	} 
 
	public void setStatus(Integer status) { 
		this.status = status; 
	} 
 
	public String getTel() { 
		return tel; 
	} 
 
	public void setTel(String tel) { 
		this.tel = tel; 
	} 
	public Date getVdate() { 
		return vdate; 
	} 
	public void setVdate(Date 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 
 
	} 
 
}