package?cn.com.chinasoft.xia.action;

import?java.util.linkedList;
import?java.util.Map;

import?org.apache.struts2.ServletActionContext;

import?cn.com.shxt.tools.Charstools;

import?com.opensymphony.xwork2.ActionSupport;

public?class?CharsAction?extends?ActionSupport{

	/**
	?*?
	?*/
	private?static?final?long?serialVersionUID?=?1L;
	
	//動態轉向標
	private?String?tojsp;
	//公共信息提示
	private?String?message;
	//獲取選擇的id
	private?int?charsid;
	//封裝的數據
	private?linkedListject>>?rslist;
	//選擇的圖形
	private?String?graph;
	
	public?String?searchdata（）?throws?Exception{
		//會議情況查詢
		if（charsid==1）{
			String?sql=“select?count（meetingstate）?as?cnmeetingstate?from?meeting?group?by?meetingstate“;
			rslist=Charstools.getmeeting（sql）;
		}
		//部門情況查詢
		if（charsid==4）{
			String?sql=“select?count（department）?as?cndepartment?from?worker?group?by?department“;
			rslist=Charstools.getworker（sql）;
		}
		//設備情況查詢
		if（charsid==3）{
			String?sql=“select?count（mechinestate）?as?cnmechinestate?from?mechine?group?by?mechinestate“;
			rslist=Charstools.getmechine（sql）;
		}
		ServletActionContext.getRequest（）.setAttribute（“rsList“rslist）;
		ServletActionContext.getRequest（）.getSession（）.setAttribute（“graph“graph）;
	????tojsp=“sysjsp/occupation_statistics_show“;
		return?SUCCESS;
	}
	
	
	public?String?getTojsp（）?{
		return?tojsp;
	}
	public?void?setTojsp（String?tojsp）?{
		this.tojsp?=?tojsp;
	}
	public?String?getMessage（）?{
		return?message;
	}
	public?void?setMessage（String?message）?{
		this.message?=?message;
	}
	public?int?getCharsid（）?{
		return?charsid;
	}
	public?void?setCharsid（int?charsid）?{
		this.charsid?=?charsid;
	}
	public?linkedListject>>?getRslist（）?{
		return?rslist;
	}
	public?void?setRslist（linkedListject>>?rslist）?{
		this.rslist?=?rslist;
	}
	public?String?getGraph（）?{
		return?graph;
	}
	public?void?setGraph（String?graph）?{
		this.graph?=?graph;
	}
	
	

}