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

	}

}