rightinfomgr.java

java阿里巴巴代码

/*
 * Created on 2006-8-23
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.ahbay.RightMgr;

import org.apache.struts.action.Action;
import com.ahbay.commenMgr.*;
import java.sql.*;
import java.util.*;
/**
 * @author: Wangrc
 * @Date: 2006-8-23 19:37:18
 * @Method Name: 
 */
public class RightinfoMgr extends Action
{
	public RightinfoMgr()
	{		
	}
	DataBaseCommMgr DBQuery = new DataBaseCommMgr();
	commMethodMgr commen = new commMethodMgr(); 
	/** staff_id property */
	private String staff_id;
	private String menu_id;
	private String start_date;
	private String end_date;
	private String right_attr;
	private String rsrv_str1;
	private String rsrv_str2;
	private String rsrv_str3;
	private String rsrv_str4;
	private String rsrv_str5;
	private String rsrv_str6;
	private String rsrv_str7;
	private String rsrv_str8;
	private String rsrv_str9;
	private String rsrv_str0;
	private String in_staff_id;
	private String in_date;
	private String remark;
	// --------------------------------------------------------- Methods
	/** 
	 * Returns the staff_id.
	 * @return String
	 */
	public String getStaff_id(){return staff_id;}
	public String getMenu_id(){return menu_id;}
	public String getStart_date(){return start_date;}
	public String getEnd_date(){return end_date;}
	public String getRight_attr(){return right_attr;}
	public String getRsrv_str1(){return rsrv_str1;}
	public String getRsrv_str2(){return rsrv_str2;}
	public String getRsrv_str3(){return rsrv_str3;}
	public String getRsrv_str4(){return rsrv_str4;}
	public String getRsrv_str5(){return rsrv_str5;}
	public String getRsrv_str6(){return rsrv_str6;}
	public String getRsrv_str7(){return rsrv_str7;}
	public String getRsrv_str8(){return rsrv_str8;}
	public String getRsrv_str9(){return rsrv_str9;}
	public String getRsrv_str0(){return rsrv_str0;}
	public String getIn_staff_id(){return in_staff_id;}
	public String getIn_date(){return in_date;}
	public String getRemark(){return remark;}
	/** 
	 * 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 setMenu_id(String menu_id){this.menu_id=menu_id;}
	public void setStart_date(String start_date){this.start_date=start_date;}
	public void setEnd_date(String end_date){this.end_date=end_date;}
	public void setRight_attr(String right_attr){this.right_attr=right_attr;}
	public void setRsrv_str1(String rsrv_str1){this.rsrv_str1=rsrv_str1;}
	public void setRsrv_str2(String rsrv_str2){this.rsrv_str2=rsrv_str2;}
	public void setRsrv_str3(String rsrv_str3){this.rsrv_str3=rsrv_str3;}
	public void setRsrv_str4(String rsrv_str4){this.rsrv_str4=rsrv_str4;}
	public void setRsrv_str5(String rsrv_str5){this.rsrv_str5=rsrv_str5;}
	public void setRsrv_str6(String rsrv_str6){this.rsrv_str6=rsrv_str6;}
	public void setRsrv_str7(String rsrv_str7){this.rsrv_str7=rsrv_str7;}
	public void setRsrv_str8(String rsrv_str8){this.rsrv_str8=rsrv_str8;}
	public void setRsrv_str9(String rsrv_str9){this.rsrv_str9=rsrv_str9;}
	public void setRsrv_str0(String rsrv_str0){this.rsrv_str0=rsrv_str0;}
	public void setIn_staff_id(String in_staff_id){this.in_staff_id=in_staff_id;}
	public void setIn_date(String in_date){this.in_date=in_date;}
	public void setRemark(String remark){this.remark=remark;}
	
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-27 20:41:24
	 * @Method Name: AddRightInfo
	 */
	public String AddRightInfo()
	{
		String sql = "";
		sql="insert into rightinfo values(" +
			"'"+commen.convetStrToDb(this.staff_id)+"',"+
			"'"+commen.convetStrToDb(this.menu_id)+"',"+
			"TO_DATE('"+commen.convetStrToDb(this.start_date)+" 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),"+
			"TO_DATE('"+commen.convetStrToDb(this.end_date)+" 00:00:00', 'YYYY-MM-DD HH24:MI:SS'),"+
			"'"+commen.convetStrToDb(this.right_attr)+"',"+
			"'"+commen.convetStrToDb(this.rsrv_str1)+"',"+
			"'"+commen.convetStrToDb(this.rsrv_str2)+"',"+
			"'"+commen.convetStrToDb(this.rsrv_str3)+"',"+
			"'"+commen.convetStrToDb(this.rsrv_str4)+"',"+
			"'"+commen.convetStrToDb(this.rsrv_str5)+"',"+
			"'"+commen.convetStrToDb(this.rsrv_str6)+"',"+
			"'"+commen.convetStrToDb(this.rsrv_str7)+"',"+
			"'"+commen.convetStrToDb(this.rsrv_str8)+"',"+
			"'"+commen.convetStrToDb(this.rsrv_str9)+"',"+
			"'"+commen.convetStrToDb(this.rsrv_str0)+"',"+
			"'"+commen.convetStrToDb(this.in_staff_id)+"',"+
			"sysdate,"+
			"'"+commen.convetStrToDb(this.remark)+"'"+
			")";
		DBQuery.setStrQuery(sql);	
		String strRst=DBQuery.ExecBizQuery();		
		return strRst;
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-28 20:43:48
	 * @Method Name: GetRightList
	 */
	public ArrayList GetRightList(String X_tag)
	{
		String sql = "";
		if (X_tag.equalsIgnoreCase("SEL_BY_STAFF_SYS"))
		{
			sql= "select * from rightinfo where staff_id='"+this.staff_id+"' and end_date>sysdate and right_attr='0'";
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_STAFF_WEB"))
		{
			sql= "select * from rightinfo where staff_id='"+this.staff_id+"' and end_date>sysdate  and right_attr='1'";
		}
		else
		{
			sql= "select * from rightinfo where end_date>sysdate";
		}

		
		ResultSet rst = null;
		ArrayList RightList = new ArrayList();	
		
		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{
			while (rst.next())
			{
				RightinfoMgr rightinfo = new RightinfoMgr();	
				rightinfo.setStaff_id(commen.convetStrToWeb(rst.getString("staff_id")));
				rightinfo.setMenu_id(commen.convetStrToWeb(rst.getString("menu_id")));
				rightinfo.setStart_date(commen.convetStrToWeb(rst.getString("start_date")));
				rightinfo.setEnd_date(commen.convetStrToWeb(rst.getString("end_date")));
				rightinfo.setRight_attr(commen.convetStrToWeb(rst.getString("right_attr")));
				rightinfo.setRsrv_str1(commen.convetStrToWeb(rst.getString("rsrv_str1")));
				rightinfo.setRsrv_str2(commen.convetStrToWeb(rst.getString("rsrv_str2")));
				rightinfo.setRsrv_str3(commen.convetStrToWeb(rst.getString("rsrv_str3")));
				rightinfo.setRsrv_str4(commen.convetStrToWeb(rst.getString("rsrv_str4")));
				rightinfo.setRsrv_str5(commen.convetStrToWeb(rst.getString("rsrv_str5")));
				rightinfo.setRsrv_str6(commen.convetStrToWeb(rst.getString("rsrv_str6")));
				rightinfo.setRsrv_str7(commen.convetStrToWeb(rst.getString("rsrv_str7")));
				rightinfo.setRsrv_str8(commen.convetStrToWeb(rst.getString("rsrv_str8")));
				rightinfo.setRsrv_str9(commen.convetStrToWeb(rst.getString("rsrv_str9")));
				rightinfo.setRsrv_str0(commen.convetStrToWeb(rst.getString("rsrv_str0")));
				rightinfo.setIn_staff_id(commen.convetStrToWeb(rst.getString("in_staff_id")));
				rightinfo.setIn_date(commen.convetStrToWeb(rst.getString("in_date")));
				rightinfo.setRemark(commen.convetStrToWeb(rst.getString("remark")));
				RightList.add(rightinfo);	
			}
		}
		catch (Exception e)
		{	 	
		}
		DBQuery.CloseConn();
		return RightList;				
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-9 14:33:58
	 * @Method Name:GetList
	 */
	public RightinfoMgr[] GetList (ArrayList ParaItem) 
	{
		RightinfoMgr[] ItemList=new RightinfoMgr[ParaItem.size()];
		for(int i=0;i<ParaItem.size();i++)
		{ 
			RightinfoMgr Item=(RightinfoMgr)ParaItem.get(i); 
			ItemList[i]=Item; 
		}
		return ItemList;
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-28 20:43:48
	 * @Method Name: GetRightInfo
	 */
	public RightinfoMgr GetRightInfo(String X_tag)
	{
		String sql = "";
		if (X_tag.equalsIgnoreCase("SEL_BY_CUST"))
		{

		}

		
		ResultSet rst = null;
		RightinfoMgr rightinfo = new RightinfoMgr();	
		
		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{
			while (rst.next())
			{				
				rightinfo.setStaff_id(commen.convetStrToWeb(rst.getString("staff_id")));
				rightinfo.setMenu_id(commen.convetStrToWeb(rst.getString("menu_id")));
				rightinfo.setStart_date(commen.convetStrToWeb(rst.getString("start_date")));
				rightinfo.setEnd_date(commen.convetStrToWeb(rst.getString("end_date")));
				rightinfo.setRight_attr(commen.convetStrToWeb(rst.getString("right_attr")));
				rightinfo.setRsrv_str1(commen.convetStrToWeb(rst.getString("rsrv_str1")));
				rightinfo.setRsrv_str2(commen.convetStrToWeb(rst.getString("rsrv_str2")));
				rightinfo.setRsrv_str3(commen.convetStrToWeb(rst.getString("rsrv_str3")));
				rightinfo.setRsrv_str4(commen.convetStrToWeb(rst.getString("rsrv_str4")));
				rightinfo.setRsrv_str5(commen.convetStrToWeb(rst.getString("rsrv_str5")));
				rightinfo.setRsrv_str6(commen.convetStrToWeb(rst.getString("rsrv_str6")));
				rightinfo.setRsrv_str7(commen.convetStrToWeb(rst.getString("rsrv_str7")));
				rightinfo.setRsrv_str8(commen.convetStrToWeb(rst.getString("rsrv_str8")));
				rightinfo.setRsrv_str9(commen.convetStrToWeb(rst.getString("rsrv_str9")));
				rightinfo.setRsrv_str0(commen.convetStrToWeb(rst.getString("rsrv_str0")));
				rightinfo.setIn_staff_id(commen.convetStrToWeb(rst.getString("in_staff_id")));
				rightinfo.setIn_date(commen.convetStrToWeb(rst.getString("in_date")));
				rightinfo.setRemark(commen.convetStrToWeb(rst.getString("remark")));				
			}
		}
		catch (Exception e)
		{	 	
		}
		DBQuery.CloseConn();
		return rightinfo;				
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-7-19 10:03:57
	 * @Method Name: EndUserRight
	 */
	public String EndUserRight()
	{
		String sql = "";
		sql="delete from  rightinfo where staff_id='"+this.staff_id+"' and menu_id='"+this.menu_id+"'";
		DBQuery.setStrQuery(sql);	
		String strRst=DBQuery.ExecBizQuery();		
		return strRst;
	}
}