staffmgr.java

java阿里巴巴代码

/*
 * Created on 2006-7-24
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.ahbay.UserMgr;
import java.sql.*;
import java.util.*;
import org.apache.struts.action.Action;
import com.ahbay.commenMgr.*;
/**
 * @author: Wangrc
 * @Date: 2006-7-24 15:28:16
 * @Method Name: 
 */
public class StaffMgr extends Action
{
	public StaffMgr () {}
	DataBaseCommMgr DBQuery = new DataBaseCommMgr();
	commMethodMgr comm = new commMethodMgr();
	private String staff_id;
	private String depart_id;
	private String staff_name;
	private String passwd;
	private String job_info;
	private String manager_info;
	private String sex;
	private String email;
	private String user_pid;
	private String serial_number;
	private String cust_id;
	private String dimission_tag;
	private String birthday;
	private String staff_group_id;
	private String cust_hobyy;
	private String remark;
	private String rsvalue1;
	private String rsvalue2;
	private String update_time;
	private String update_staff_id;
	private String update_depart_id;
	private String caseid;
	private String contractId;
	// --------------------------------------------------------- Methods
	/** 
	 * Returns the staff_id.
	 * @return String
	 */
	public String getStaff_id(){return staff_id;}
	public String getDepart_id(){return depart_id;}
	public String getStaff_name(){return staff_name;}
	public String getPasswd(){return passwd;}
	public String getJob_info(){return job_info;}
	public String getManager_info(){return manager_info;}
	public String getSex(){return sex;}
	public String getEmail(){return email;}
	public String getUser_pid(){return user_pid;}
	public String getSerial_number(){return serial_number;}
	public String getCust_id(){return cust_id;}
	public String getDimission_tag(){return dimission_tag;}
	public String getBirthday(){return birthday;}
	public String getStaff_group_id(){return staff_group_id;}
	public String getCust_hobyy(){return cust_hobyy;}
	public String getRemark(){return remark;}
	public String getRsvalue1(){return rsvalue1;}
	public String getRsvalue2(){return rsvalue2;}
	public String getUpdate_time(){return update_time;}
	public String getUpdate_staff_id(){return update_staff_id;}
	public String getUpdate_depart_id(){return update_depart_id;}

	public String GetContractId(){return contractId;}	
	public String GetCaseid(){return caseid;}
	/** 
	 * Set the staff_id.
	 * @param staff_id The staff_id to set
	 */
	public void setStaff_id(String staff_id){this.staff_id=staff_id;}
	public void setDepart_id(String depart_id){this.depart_id=depart_id;}
	public void setStaff_name(String staff_name){this.staff_name=staff_name;}
	public void setPasswd(String passwd){this.passwd=passwd;}
	public void setJob_info(String job_info){this.job_info=job_info;}
	public void setManager_info(String manager_info){this.manager_info=manager_info;}
	public void setSex(String sex){this.sex=sex;}
	public void setEmail(String email){this.email=email;}
	public void setUser_pid(String user_pid){this.user_pid=user_pid;}
	public void setSerial_number(String serial_number){this.serial_number=serial_number;}
	public void setCust_id(String cust_id){this.cust_id=cust_id;}
	public void setDimission_tag(String dimission_tag){this.dimission_tag=dimission_tag;}
	public void setBirthday(String birthday){this.birthday=birthday;}
	public void setStaff_group_id(String staff_group_id){this.staff_group_id=staff_group_id;}
	public void setCust_hobyy(String cust_hobyy){this.cust_hobyy=cust_hobyy;}
	public void setRemark(String remark){this.remark=remark;}
	public void setRsvalue1(String rsvalue1){this.rsvalue1=rsvalue1;}
	public void setRsvalue2(String rsvalue2){this.rsvalue2=rsvalue2;}
	public void setUpdate_time(String update_time){this.update_time=update_time;}
	public void setUpdate_staff_id(String update_staff_id){this.update_staff_id=update_staff_id;}
	public void setUpdate_depart_id(String update_depart_id){this.update_depart_id=update_depart_id;}
	public void setContractId (String contractId ){this.contractId =contractId ;}
	public void setCaseid (String caseid ){this.caseid =caseid ;}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-27 20:41:24
	 * @Method Name: AddStaff
	 */
	public String AddStaff()
	{
		String sql = "";
		sql="insert into staffinfo values(" +
			"'"+comm.convetStrToDb(this.staff_id)+"',"+
			"'"+comm.convetStrToDb(this.depart_id)+"',"+
			"'"+comm.convetStrToDb(this.staff_name)+"',"+
			"'"+comm.convetStrToDb(this.passwd)+"',"+
			"'"+comm.convetStrToDb(this.job_info)+"',"+
			"'"+comm.convetStrToDb(this.manager_info)+"',"+
			"'"+comm.convetStrToDb(this.sex)+"',"+
			"'"+comm.convetStrToDb(this.email)+"',"+
			"'"+comm.convetStrToDb(this.user_pid)+"',"+
			"'"+comm.convetStrToDb(this.serial_number)+"',"+
			"'"+comm.convetStrToDb(this.cust_id)+"',"+
			"'"+comm.convetStrToDb(this.dimission_tag)+"',"+
			"TO_DATE('"+comm.convetStrToDb(this.birthday)+" 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),"+			 
			"'"+comm.convetStrToDb(this.staff_group_id)+"',"+
			"'"+comm.convetStrToDb(this.cust_hobyy)+"',"+
			"'"+comm.convetStrToDb(this.remark)+"',"+
			"'"+comm.convetStrToDb(this.rsvalue1)+"',"+
			"'"+comm.convetStrToDb(this.rsvalue2)+"',"+
			"sysdate,"+
			"'"+comm.convetStrToDb(this.update_staff_id)+"',"+
			"'"+comm.convetStrToDb(this.update_depart_id)+"'"+
			")";
		DBQuery.setStrQuery(sql);	
		String strRst=DBQuery.ExecBizQuery();		
		return strRst;
	}
		
	public StaffMgr GetUserInfo(String X_tag) 
	{	
		String sql = "";
		String result = "0";
		int i = 0;
		if (X_tag.equalsIgnoreCase("SEL_BY_PWD"))
		{
			sql="select * from staffinfo where staff_id='"+this.staff_id+"' and passwd='"+this.passwd+"'"; 
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_ID"))
		{
			sql="select * from staffinfo where staff_id='"+this.staff_id+"'"; 
		}
		
		ResultSet rst = null;	
		StaffMgr staffinfo = new StaffMgr();
		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{			
			while(rst.next())
			{					
				staffinfo.setStaff_id(comm.convetStrToWeb(rst.getString("staff_id")));
				staffinfo.setDepart_id(comm.convetStrToWeb(rst.getString("depart_id")));
				staffinfo.setStaff_name(comm.convetStrToWeb(rst.getString("staff_name")));
				staffinfo.setPasswd(comm.convetStrToWeb(rst.getString("passwd")));
				staffinfo.setJob_info(comm.convetStrToWeb(rst.getString("job_info")));
				staffinfo.setManager_info(comm.convetStrToWeb(rst.getString("manager_info")));
				staffinfo.setSex(comm.convetStrToWeb(rst.getString("sex")));
				staffinfo.setEmail(comm.convetStrToWeb(rst.getString("email")));
				staffinfo.setUser_pid(comm.convetStrToWeb(rst.getString("user_pid")));
				staffinfo.setSerial_number(comm.convetStrToWeb(rst.getString("serial_number")));
				staffinfo.setCust_id(comm.convetStrToWeb(rst.getString("cust_id")));
				staffinfo.setDimission_tag(comm.convetStrToWeb(rst.getString("dimission_tag")));
				staffinfo.setBirthday(comm.convetStrToWeb(rst.getString("birthday")));
				staffinfo.setStaff_group_id(comm.convetStrToWeb(rst.getString("staff_group_id")));
				staffinfo.setCust_hobyy(comm.convetStrToWeb(rst.getString("cust_hobyy")));
				staffinfo.setRemark(comm.convetStrToWeb(rst.getString("remark")));
				staffinfo.setRsvalue1(comm.convetStrToWeb(rst.getString("rsvalue1")));
				staffinfo.setRsvalue2(comm.convetStrToWeb(rst.getString("rsvalue2")));
				staffinfo.setUpdate_time(comm.convetStrToWeb(rst.getString("update_time")));
				staffinfo.setUpdate_staff_id(comm.convetStrToWeb(rst.getString("update_staff_id")));
				staffinfo.setUpdate_depart_id(comm.convetStrToWeb(rst.getString("update_depart_id")));			
			}
		}
		catch (Exception e)
		{		
			System.out.println("ERROR:"+e.getMessage());		
		}	 
		
		DBQuery.CloseConn();	
		return staffinfo;	 			  	   
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-28 20:43:48
	 * @Method Name: GetUserList
	 */
	public ArrayList GetUserList(String X_tag)
	{
		String sql = "";
		if (X_tag.equalsIgnoreCase("SEL_BY_DEPART"))
		{
			sql="";
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_CASE"))
		{
			sql="select * from staffinfo a where a.staff_id!='"+this.staff_id+"' and a.staff_id not in " +
				"(select b.staff_id from workstaffinfo b where b.case_id='"+this.caseid+"' and b.remove_tag='0')";
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_ALL"))
		{
			sql="select * from staffinfo";
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_EXP_THIS"))
		{
			sql="select * from staffinfo where staff_id!='"+this.staff_id+"'";
		}
		else
		{
			sql="select * from staffinfo where staff_id='"+this.staff_id+"'";
		}

		
		
		ResultSet rst = null;
		ArrayList UserList = new ArrayList();	
		
		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{
			while (rst.next())
			{
				StaffMgr staffinfo = new StaffMgr();	
				staffinfo.setStaff_id(rst.getString("staff_id"));
				staffinfo.setDepart_id(comm.convetStrToWeb(rst.getString("depart_id")));
				staffinfo.setStaff_name(comm.convetStrToWeb(rst.getString("staff_name")));
				staffinfo.setPasswd(comm.convetStrToWeb(rst.getString("passwd")));
				staffinfo.setJob_info(comm.convetStrToWeb(rst.getString("job_info")));
				staffinfo.setManager_info(comm.convetStrToWeb(rst.getString("manager_info")));
				staffinfo.setSex(comm.convetStrToWeb(rst.getString("sex")));
				staffinfo.setEmail(comm.convetStrToWeb(rst.getString("email")));
				staffinfo.setUser_pid(comm.convetStrToWeb(rst.getString("user_pid")));
				staffinfo.setSerial_number(comm.convetStrToWeb(rst.getString("serial_number")));
				staffinfo.setCust_id(comm.convetStrToWeb(rst.getString("cust_id")));
				staffinfo.setDimission_tag(comm.convetStrToWeb(rst.getString("dimission_tag")));
				staffinfo.setBirthday(comm.convetStrToWeb(rst.getString("birthday")));
				staffinfo.setStaff_group_id(comm.convetStrToWeb(rst.getString("staff_group_id")));
				staffinfo.setCust_hobyy(comm.convetStrToWeb(rst.getString("cust_hobyy")));
				staffinfo.setRemark(comm.convetStrToWeb(rst.getString("remark")));
				staffinfo.setRsvalue1(comm.convetStrToWeb(rst.getString("rsvalue1")));
				staffinfo.setRsvalue2(comm.convetStrToWeb(rst.getString("rsvalue2")));
				staffinfo.setUpdate_time(comm.convetStrToWeb(rst.getString("update_time")));
				staffinfo.setUpdate_staff_id(comm.convetStrToWeb(rst.getString("update_staff_id")));
				staffinfo.setUpdate_depart_id(comm.convetStrToWeb(rst.getString("update_depart_id")));
				UserList.add(staffinfo);	
			}
		}
		catch (Exception e)
		{	 	
		}
		DBQuery.CloseConn();
		return UserList;				
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-9 14:33:58
	 * @Method Name:GetList
	 */
	public StaffMgr[] GetList (ArrayList ParaItem) 
	{
		StaffMgr[] ItemList=new StaffMgr[ParaItem.size()];
		for(int i=0;i<ParaItem.size();i++)
		{ 
			StaffMgr Item=(StaffMgr)ParaItem.get(i); 
			ItemList[i]=Item; 
		}
		return ItemList;
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-7-19 10:03:57
	 * @Method Name: ModifyPwd
	 */
	public String ModifyPwd()
	{
		String sql = "";
		sql="update staffinfo set passwd='"+this.passwd+"' where staff_id='"+this.staff_id+"'";
		DBQuery.setStrQuery(sql);	
		String strRst=DBQuery.ExecBizQuery();		
		return strRst;
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-7-19 10:03:57
	 * @Method Name: DelStaff
	 */
	public String DelStaff()
	{
		String sql = "";
		sql="delete from staffinfo where staff_id='"+this.staff_id+"'";
		DBQuery.setStrQuery(sql);	
		String strRst=DBQuery.ExecBizQuery();		
		return strRst;
	}
}