menuinfomgr.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:51:16
 * @Method Name: 
 */
public class MenuinfoMgr extends Action
{
	public MenuinfoMgr()
	{		
	}
	DataBaseCommMgr DBQuery = new DataBaseCommMgr();
	commMethodMgr commen = new commMethodMgr(); 
	/** subsys_code property */
	private String subsys_code;
	private String menu_id;
	private String menu_name;
	private String up_menu_id;
	private String menu_class;
	private String menu_type;
	private String module_id;
	private String in_param_code1;
	private String in_param_value1;
	private String in_param_code2;
	private String in_param_value2;
	private String in_param_code3;
	private String in_param_value3;
	private String remove_tag;
	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 subsys_code.
	 * @return String
	 */
	public String getSubsys_code(){return subsys_code;}
	public String getMenu_id(){return menu_id;}
	public String getMenu_name(){return menu_name;}
	public String getUp_menu_id(){return up_menu_id;}
	public String getMenu_class(){return menu_class;}
	public String getMenu_type(){return menu_type;}
	public String getModule_id(){return module_id;}
	public String getIn_param_code1(){return in_param_code1;}
	public String getIn_param_value1(){return in_param_value1;}
	public String getIn_param_code2(){return in_param_code2;}
	public String getIn_param_value2(){return in_param_value2;}
	public String getIn_param_code3(){return in_param_code3;}
	public String getIn_param_value3(){return in_param_value3;}
	public String getRemove_tag(){return remove_tag;}
	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 subsys_code.
	 * @param subsys_code The subsys_code to set
	 */
	public void setSubsys_code(String subsys_code){this.subsys_code=subsys_code;}
	public void setMenu_id(String menu_id){this.menu_id=menu_id;}
	public void setMenu_name(String menu_name){this.menu_name=menu_name;}
	public void setUp_menu_id(String up_menu_id){this.up_menu_id=up_menu_id;}
	public void setMenu_class(String menu_class){this.menu_class=menu_class;}
	public void setMenu_type(String menu_type){this.menu_type=menu_type;}
	public void setModule_id(String module_id){this.module_id=module_id;}
	public void setIn_param_code1(String in_param_code1){this.in_param_code1=in_param_code1;}
	public void setIn_param_value1(String in_param_value1){this.in_param_value1=in_param_value1;}
	public void setIn_param_code2(String in_param_code2){this.in_param_code2=in_param_code2;}
	public void setIn_param_value2(String in_param_value2){this.in_param_value2=in_param_value2;}
	public void setIn_param_code3(String in_param_code3){this.in_param_code3=in_param_code3;}
	public void setIn_param_value3(String in_param_value3){this.in_param_value3=in_param_value3;}
	public void setRemove_tag(String remove_tag){this.remove_tag=remove_tag;}
	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: AddMenuinfo
	 */
	public String AddMenuinfo()
	{
		String sql = "";
		sql="insert into menuinfo values(" +
			"'"+commen.convetStrToDb(this.subsys_code)+"',"+
			"'"+commen.convetStrToDb(this.menu_id)+"',"+
			"'"+commen.convetStrToDb(this.menu_name)+"',"+
			"'"+commen.convetStrToDb(this.up_menu_id)+"',"+
			"'"+commen.convetStrToDb(this.menu_class)+"',"+
			"'"+commen.convetStrToDb(this.menu_type)+"',"+
			"'"+commen.convetStrToDb(this.module_id)+"',"+
			"'"+commen.convetStrToDb(this.in_param_code1)+"',"+
			"'"+commen.convetStrToDb(this.in_param_value1)+"',"+
			"'"+commen.convetStrToDb(this.in_param_code2)+"',"+
			"'"+commen.convetStrToDb(this.in_param_value2)+"',"+
			"'"+commen.convetStrToDb(this.in_param_code3)+"',"+
			"'"+commen.convetStrToDb(this.in_param_value3)+"',"+
			"'"+commen.convetStrToDb(this.remove_tag)+"',"+
			"'"+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)+"',"+
			"now(),"+
			"'"+commen.convetStrToDb(this.remark)+"'"+
			")";
		DBQuery.setStrQuery(sql);	
		String strRst=DBQuery.ExecBizQuery();		
		return strRst;
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-28 20:43:48
	 * @Method Name: GetMenuList
	 */
	public ArrayList GetMenuList(String X_tag)
	{
		String sql = "";
		if (X_tag.equalsIgnoreCase("SEL_BY_CLASS_1"))
		{
			sql = "select * from menuinfo where menu_class='1' and remove_tag='0' and subsys_code='"+this.subsys_code+"' order by subsys_code desc";
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_UP"))
		{
			sql = "select * from menuinfo where up_menu_id='"+this.up_menu_id+"' and remove_tag='0' and subsys_code='"+this.subsys_code+"' order by subsys_code desc";
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_RIGHT"))
		{
			sql = "select * from menuinfo where menu_id not in " +
				"(select menu_id from rightinfo where staff_id='"+this.rsrv_str0+"' and end_date>=now() and right_attr='0')" +
					" order by up_menu_id";
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_STAFF_RIGHT_1"))
		{
			sql = "select * from menuinfo where ((menu_id  in " +
				"(select menu_id from rightinfo where staff_id='"+this.rsrv_str0+"' and end_date>=now()  and right_attr='0')) or " +
					"('admin'='"+this.rsrv_str0+"'))" +
					"and menu_class=1 order by in_date";
		}
		else if (X_tag.equalsIgnoreCase("SEL_BY_STAFF_RIGHT_UP"))
		{
			sql = "select * from menuinfo where ((menu_id  in " +
				"(select menu_id from rightinfo where staff_id='"+this.rsrv_str0+"' and end_date>=now() and right_attr='0' )) or " +
					"('admin'='"+this.rsrv_str0+"'))" +
					"and menu_class=2 and up_menu_id='"+this.up_menu_id+"' order by in_date";
		}
		ResultSet rst = null;
		ArrayList MenuList = new ArrayList();	
		
		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{
			while (rst.next())
			{
				MenuinfoMgr menuinfo = new MenuinfoMgr();	
				menuinfo.setSubsys_code(rst.getString("subsys_code"));
				menuinfo.setMenu_id(rst.getString("menu_id"));
				menuinfo.setMenu_name(rst.getString("menu_name"));
				menuinfo.setUp_menu_id(rst.getString("up_menu_id"));
				menuinfo.setMenu_class(rst.getString("menu_class"));
				menuinfo.setMenu_type(rst.getString("menu_type"));
				menuinfo.setModule_id(rst.getString("module_id"));
				menuinfo.setIn_param_code1(rst.getString("in_param_code1"));
				menuinfo.setIn_param_value1(rst.getString("in_param_value1"));
				menuinfo.setIn_param_code2(rst.getString("in_param_code2"));
				menuinfo.setIn_param_value2(rst.getString("in_param_value2"));
				menuinfo.setIn_param_code3(rst.getString("in_param_code3"));
				menuinfo.setIn_param_value3(rst.getString("in_param_value3"));
				menuinfo.setRemove_tag(rst.getString("remove_tag"));
				menuinfo.setRsrv_str1(rst.getString("rsrv_str1"));
				menuinfo.setRsrv_str2(rst.getString("rsrv_str2"));
				menuinfo.setRsrv_str3(rst.getString("rsrv_str3"));
				menuinfo.setRsrv_str4(rst.getString("rsrv_str4"));
				menuinfo.setRsrv_str5(rst.getString("rsrv_str5"));
				menuinfo.setRsrv_str6(rst.getString("rsrv_str6"));
				menuinfo.setRsrv_str7(rst.getString("rsrv_str7"));
				menuinfo.setRsrv_str8(rst.getString("rsrv_str8"));
				menuinfo.setRsrv_str9(rst.getString("rsrv_str9"));
				menuinfo.setRsrv_str0(rst.getString("rsrv_str0"));
				menuinfo.setIn_staff_id(rst.getString("in_staff_id"));
				menuinfo.setIn_date(rst.getString("in_date"));
				menuinfo.setRemark(rst.getString("remark"));
				MenuList.add(menuinfo);	
			}
		}
		catch (Exception e)
		{	 	
		}
		DBQuery.CloseConn();
		return MenuList;				
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-9 14:33:58
	 * @Method Name:GetList
	 */
	public MenuinfoMgr[] GetList (ArrayList ParaItem) 
	{
		MenuinfoMgr[] ItemList=new MenuinfoMgr[ParaItem.size()];
		for(int i=0;i<ParaItem.size();i++)
		{ 
			MenuinfoMgr Item=(MenuinfoMgr)ParaItem.get(i); 
			ItemList[i]=Item; 
		}
		return ItemList;
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-28 20:43:48
	 * @Method Name: GetMenuInfo
	 */
	public MenuinfoMgr GetMenuInfo(String X_tag)
	{
		String sql = "";
		if (X_tag.equalsIgnoreCase("SEL_BY_CUST"))
		{

		}

		
		ResultSet rst = null;
		MenuinfoMgr menuinfo = new MenuinfoMgr();	
		
		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{
			while (rst.next())
			{
				menuinfo.setSubsys_code(commen.convetStrToWeb(rst.getString("subsys_code")));
				menuinfo.setMenu_id(commen.convetStrToWeb(rst.getString("menu_id")));
				menuinfo.setMenu_name(commen.convetStrToWeb(rst.getString("menu_name")));
				menuinfo.setUp_menu_id(commen.convetStrToWeb(rst.getString("up_menu_id")));
				menuinfo.setMenu_class(commen.convetStrToWeb(rst.getString("menu_class")));
				menuinfo.setMenu_type(commen.convetStrToWeb(rst.getString("menu_type")));
				menuinfo.setModule_id(commen.convetStrToWeb(rst.getString("module_id")));
				menuinfo.setIn_param_code1(commen.convetStrToWeb(rst.getString("in_param_code1")));
				menuinfo.setIn_param_value1(commen.convetStrToWeb(rst.getString("in_param_value1")));
				menuinfo.setIn_param_code2(commen.convetStrToWeb(rst.getString("in_param_code2")));
				menuinfo.setIn_param_value2(commen.convetStrToWeb(rst.getString("in_param_value2")));
				menuinfo.setIn_param_code3(commen.convetStrToWeb(rst.getString("in_param_code3")));
				menuinfo.setIn_param_value3(commen.convetStrToWeb(rst.getString("in_param_value3")));
				menuinfo.setRemove_tag(commen.convetStrToWeb(rst.getString("remove_tag")));
				menuinfo.setRsrv_str1(commen.convetStrToWeb(rst.getString("rsrv_str1")));
				menuinfo.setRsrv_str2(commen.convetStrToWeb(rst.getString("rsrv_str2")));
				menuinfo.setRsrv_str3(commen.convetStrToWeb(rst.getString("rsrv_str3")));
				menuinfo.setRsrv_str4(commen.convetStrToWeb(rst.getString("rsrv_str4")));
				menuinfo.setRsrv_str5(commen.convetStrToWeb(rst.getString("rsrv_str5")));
				menuinfo.setRsrv_str6(commen.convetStrToWeb(rst.getString("rsrv_str6")));
				menuinfo.setRsrv_str7(commen.convetStrToWeb(rst.getString("rsrv_str7")));
				menuinfo.setRsrv_str8(commen.convetStrToWeb(rst.getString("rsrv_str8")));
				menuinfo.setRsrv_str9(commen.convetStrToWeb(rst.getString("rsrv_str9")));
				menuinfo.setRsrv_str0(commen.convetStrToWeb(rst.getString("rsrv_str0")));
				menuinfo.setIn_staff_id(commen.convetStrToWeb(rst.getString("in_staff_id")));
				menuinfo.setIn_date(commen.convetStrToWeb(rst.getString("in_date")));
				menuinfo.setRemark(commen.convetStrToWeb(rst.getString("remark")));
			}
		}
		catch (Exception e)
		{	 	
		}
		DBQuery.CloseConn();
		return menuinfo;				
	}
	
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-7-19 10:03:57
	 * @Method Name: DelMenu
	 */
	public String DelMenu()
	{
		String sql = "";
		sql="delete from menuinfo where menu_id='"+this.menu_id+"'";
		DBQuery.setStrQuery(sql);	
		String strRst=DBQuery.ExecBizQuery();		
		return strRst;
	}
}