visitinfo.java

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

package com.easycrm.asp.business;

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 VisitInfo implements IObject {
	
		private String cid;
		private String belongDept;
		private String sn;
		private String customersSn;
		private String customersTitle;
		private String visitRedcord;
		private Date inputTime;
		private String inputUser;
		private Customers customers;
		private int times;
		
		public static VisitInfo read(String cid)
		{
			EasyJDB db=EasyJDB.getInstance();		
			return (VisitInfo)db.get(VisitInfo.class,cid);
		}
		public static VisitInfo readBySn(String sn)
		{
			EasyJDB db=EasyJDB.getInstance();
			Collection paras=new ArrayList();
			paras.add(sn);
			return (VisitInfo)db.read(VisitInfo.class,"sn=?",paras);
		}

		public static List query(String scope)
		{
			EasyJDB db=EasyJDB.getInstance();
			return db.query(VisitInfo.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  int produceTimes(){
			Integer ret = 0;
			EasyJDB db = EasyJDB.getInstance();
			Number num = (Number)db.uniqueResult("select count(*) from VisitInfo where customersTitle='"+this.customersTitle+"'");
			ret = num.intValue();
			
			return ret;
		}
		
		public Customers readCustomer()
		{
			if(customers==null)
			customers=Customers.readBySn(this.customersSn);
			return customers;
		}
		public String customersTitle()
		{	
			if(readCustomer()!=null)return customers.getTitle();
			else return "";
		}
		
		
		public String getKeyField() {
			// TODO 自动生成方法存根
			return "cid";
		}

		public String getKeyGenerator() {
			// TODO 自动生成方法存根
			return "com.easyjf.dbo.IdGenerator";
		}

		public String getTableName() {
			// TODO 自动生成方法存根
			return "VisitInfo";
		}

	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 getCustomersTitle() {
			return customersTitle;
		}

		public void setCustomersTitle(String customersTitle) {
			this.customersTitle = customersTitle;
		}

		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 getVisitRedcord() {
			return visitRedcord;
		}

		public void setVisitRedcord(String visitRedcord) {
			this.visitRedcord = visitRedcord;
		}
		public int getTimes() {
			return times;
		}
		public void setTimes(int times) {
			this.times = times;
		}
	

	

}