/*
 * Created on 2006-8-24
 *
 * 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-24 19:55:51
 * @Method Name: 
 */
public class ModuleMgr extends Action
{
	public ModuleMgr()
	{		
	}
	DataBaseCommMgr DBQuery = new DataBaseCommMgr();
	commMethodMgr commen = new commMethodMgr(); 
	private String module_id;
	private String module_name;
	private String module_file;
	private String module_dir;
	private String module_type;
	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;
	
	public String getModule_id(){return module_id;}
	public String getModule_name(){return module_name;}
	public String getModule_file(){return module_file;}
	public String getModule_dir(){return module_dir;}
	public String getModule_type(){return module_type;}
	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;}
	
	public void setModule_id(String module_id){this.module_id=module_id;}
	public void setModule_name(String module_name){this.module_name=module_name;}
	public void setModule_file(String module_file){this.module_file=module_file;}
	public void setModule_dir(String module_dir){this.module_dir=module_dir;}
	public void setModule_type(String module_type){this.module_type=module_type;}
	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-28 20:43:48
	 * @Method Name: GetModuleList
	 */
	public ArrayList GetModuleList(String X_tag)
	{
		String sql = "";
		if (X_tag.equalsIgnoreCase("SEL_BY_ALL"))
		{
			sql = "select * from moduleinfo order by module_id asc";
		}

		
		ResultSet rst = null;
		ArrayList ModuleList = new ArrayList();	
		
		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{
			while (rst.next())
			{
				ModuleMgr moduleinfo = new ModuleMgr();	
				moduleinfo.setModule_id(rst.getString("module_id"));
				moduleinfo.setModule_name(rst.getString("module_name"));
				moduleinfo.setModule_file(rst.getString("module_file"));
				moduleinfo.setModule_dir(rst.getString("module_dir"));
				moduleinfo.setModule_type(rst.getString("module_type"));
				moduleinfo.setRsrv_str1(rst.getString("rsrv_str1"));
				moduleinfo.setRsrv_str2(rst.getString("rsrv_str2"));
				moduleinfo.setRsrv_str3(rst.getString("rsrv_str3"));
				moduleinfo.setRsrv_str4(rst.getString("rsrv_str4"));
				moduleinfo.setRsrv_str5(rst.getString("rsrv_str5"));
				moduleinfo.setRsrv_str6(rst.getString("rsrv_str6"));
				moduleinfo.setRsrv_str7(rst.getString("rsrv_str7"));
				moduleinfo.setRsrv_str8(rst.getString("rsrv_str8"));
				moduleinfo.setRsrv_str9(rst.getString("rsrv_str9"));
				moduleinfo.setRsrv_str0(rst.getString("rsrv_str0"));
				moduleinfo.setIn_staff_id(rst.getString("in_staff_id"));
				moduleinfo.setIn_date(rst.getString("in_date"));
				moduleinfo.setRemark(rst.getString("remark"));
				ModuleList.add(moduleinfo);	
			}
		}
		catch (Exception e)
		{	 	
		}
		DBQuery.CloseConn();
		return ModuleList;				
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-9 14:33:58
	 * @Method Name:GetList
	 */
	public ModuleMgr[] GetList (ArrayList ParaItem) 
	{
		ModuleMgr[] ItemList=new ModuleMgr[ParaItem.size()];
		for(int i=0;i<ParaItem.size();i++)
		{ 
			ModuleMgr Item=(ModuleMgr)ParaItem.get(i); 
			ItemList[i]=Item; 
		}
		return ItemList;
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-28 20:43:48
	 * @Method Name: GetModuleInfo
	 */
	public ModuleMgr GetModuleInfo(String X_tag)
	{
		String sql = "";
		if (X_tag.equalsIgnoreCase("SEL_BY_ID"))
		{
			sql = "select * from moduleinfo where module_id='"+this.module_id+"'";
		}

		
		ResultSet rst = null; 
		ModuleMgr moduleinfo = new ModuleMgr();	
		
		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{
			while (rst.next())
			{				
				moduleinfo.setModule_id(commen.convetStrToWeb(rst.getString("module_id")));
				moduleinfo.setModule_name(commen.convetStrToWeb(rst.getString("module_name")));
				moduleinfo.setModule_file(commen.convetStrToWeb(rst.getString("module_file")));
				moduleinfo.setModule_dir(commen.convetStrToWeb(rst.getString("module_dir")));
				moduleinfo.setModule_type(commen.convetStrToWeb(rst.getString("module_type")));
				moduleinfo.setRsrv_str1(commen.convetStrToWeb(rst.getString("rsrv_str1")));
				moduleinfo.setRsrv_str2(commen.convetStrToWeb(rst.getString("rsrv_str2")));
				moduleinfo.setRsrv_str3(commen.convetStrToWeb(rst.getString("rsrv_str3")));
				moduleinfo.setRsrv_str4(commen.convetStrToWeb(rst.getString("rsrv_str4")));
				moduleinfo.setRsrv_str5(commen.convetStrToWeb(rst.getString("rsrv_str5")));
				moduleinfo.setRsrv_str6(commen.convetStrToWeb(rst.getString("rsrv_str6")));
				moduleinfo.setRsrv_str7(commen.convetStrToWeb(rst.getString("rsrv_str7")));
				moduleinfo.setRsrv_str8(commen.convetStrToWeb(rst.getString("rsrv_str8")));
				moduleinfo.setRsrv_str9(commen.convetStrToWeb(rst.getString("rsrv_str9")));
				moduleinfo.setRsrv_str0(commen.convetStrToWeb(rst.getString("rsrv_str0")));
				moduleinfo.setIn_staff_id(commen.convetStrToWeb(rst.getString("in_staff_id")));
				moduleinfo.setIn_date(commen.convetStrToWeb(rst.getString("in_date")));
				moduleinfo.setRemark(commen.convetStrToWeb(rst.getString("remark")));
			}
		}
		catch (Exception e)
		{	 	
		}
		DBQuery.CloseConn();
		return moduleinfo;				
	}
}