/*
 * Created on 2006-7-25
 *
 * To change the template for this generated file go to
 * Window>Preferences>Java>Code Generation>Code and Comments
 */
package com.ahbay.commenMgr;
import java.sql.*;
import java.util.*;
import com.ahbay.UserMgr.*;
import com.ahbay.RightMgr.*;
 
/**
 * @author: Wangrc
 * @Date: 2006-7-25 15:27:12
 * @Method Name: 
 */
public class CommParaMgr
{
	public CommParaMgr(){}
	DataBaseCommMgr DBQuery = new DataBaseCommMgr();
	commMethodMgr commen = new commMethodMgr();
	private String subsys_code;
	private String param_attr;
	private String param_code;
	private String param_name;
	private String para_code1;
	private String para_code2;
	private String para_code3;
	private String para_code4;
	private String para_code5;
	private String para_code6;
	private String para_code7;
	private String para_code8;
	private String para_code9;
	private String para_code10;
	private String para_code11;
	private String para_code12;
	private String para_code13;
	private String para_code14;
	private String para_code15;
	private String para_code16;
	private String para_code17;
	private String para_code18;
	private String para_code19;
	private String para_code20;
	private String para_code21;
	private String para_code22;
	private String para_code23;
	private String para_code24;
	private String para_code25;
	private String para_code26;
	private String para_code27;
	private String para_code28;
	private String para_code29;
	private String para_code30;
	private String start_date;
	private String end_date;
	private String remark;
	private String update_staff_id;
	private String update_depart_id;
	private String update_time;
	public String getSubsys_code(){return subsys_code;} 
	public String getParam_attr(){return param_attr;} 
	public String getParam_code(){return param_code;} 
	public String getParam_name(){return param_name;} 
	public String getPara_code1(){return para_code1;} 
	public String getPara_code2(){return para_code2;} 
	public String getPara_code3(){return para_code3;} 
	public String getPara_code4(){return para_code4;} 
	public String getPara_code5(){return para_code5;} 
	public String getPara_code6(){return para_code6;} 
	public String getPara_code7(){return para_code7;} 
	public String getPara_code8(){return para_code8;} 
	public String getPara_code9(){return para_code9;} 
	public String getPara_code10(){return para_code10;} 
	public String getPara_code11(){return para_code11;} 
	public String getPara_code12(){return para_code12;} 
	public String getPara_code13(){return para_code13;} 
	public String getPara_code14(){return para_code14;} 
	public String getPara_code15(){return para_code15;} 
	public String getPara_code16(){return para_code16;} 
	public String getPara_code17(){return para_code17;} 
	public String getPara_code18(){return para_code18;} 
	public String getPara_code19(){return para_code19;} 
	public String getPara_code20(){return para_code20;} 
	public String getPara_code21(){return para_code21;} 
	public String getPara_code22(){return para_code22;} 
	public String getPara_code23(){return para_code23;} 
	public String getPara_code24(){return para_code24;} 
	public String getPara_code25(){return para_code25;} 
	public String getPara_code26(){return para_code26;} 
	public String getPara_code27(){return para_code27;} 
	public String getPara_code28(){return para_code28;} 
	public String getPara_code29(){return para_code29;} 
	public String getPara_code30(){return para_code30;} 
	public String getStart_date(){return start_date;} 
	public String getEnd_date(){return end_date;} 
	public String getRemark(){return remark;} 
	public String getUpdate_staff_id(){return update_staff_id;} 
	public String getUpdate_depart_id(){return update_depart_id;}  
	public String getUpdate_time(){return  update_time;} 
	public void setSubsys_code(String subsys_code){this.subsys_code=subsys_code;}
	public void setParam_attr(String param_attr){this.param_attr=param_attr;}
	public void setParam_code(String param_code){this.param_code=param_code;}
	public void setParam_name(String param_name){this.param_name=param_name;}
	public void setPara_code1(String para_code1){this.para_code1=para_code1;}
	public void setPara_code2(String para_code2){this.para_code2=para_code2;}
	public void setPara_code3(String para_code3){this.para_code3=para_code3;}
	public void setPara_code4(String para_code4){this.para_code4=para_code4;}
	public void setPara_code5(String para_code5){this.para_code5=para_code5;}
	public void setPara_code6(String para_code6){this.para_code6=para_code6;}
	public void setPara_code7(String para_code7){this.para_code7=para_code7;}
	public void setPara_code8(String para_code8){this.para_code8=para_code8;}
	public void setPara_code9(String para_code9){this.para_code9=para_code9;}
	public void setPara_code10(String para_code10){this.para_code10=para_code10;}
	public void setPara_code11(String para_code11){this.para_code11=para_code11;}
	public void setPara_code12(String para_code12){this.para_code12=para_code12;}
	public void setPara_code13(String para_code13){this.para_code13=para_code13;}
	public void setPara_code14(String para_code14){this.para_code14=para_code14;}
	public void setPara_code15(String para_code15){this.para_code15=para_code15;}
	public void setPara_code16(String para_code16){this.para_code16=para_code16;}
	public void setPara_code17(String para_code17){this.para_code17=para_code17;}
	public void setPara_code18(String para_code18){this.para_code18=para_code18;}
	public void setPara_code19(String para_code19){this.para_code19=para_code19;}
	public void setPara_code20(String para_code20){this.para_code20=para_code20;}
	public void setPara_code21(String para_code21){this.para_code21=para_code21;}
	public void setPara_code22(String para_code22){this.para_code22=para_code22;}
	public void setPara_code23(String para_code23){this.para_code23=para_code23;}
	public void setPara_code24(String para_code24){this.para_code24=para_code24;}
	public void setPara_code25(String para_code25){this.para_code25=para_code25;}
	public void setPara_code26(String para_code26){this.para_code26=para_code26;}
	public void setPara_code27(String para_code27){this.para_code27=para_code27;}
	public void setPara_code28(String para_code28){this.para_code28=para_code28;}
	public void setPara_code29(String para_code29){this.para_code29=para_code29;}
	public void setPara_code30(String para_code30){this.para_code30=para_code30;}
	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 setRemark(String remark){this.remark=remark;}
	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 setUpdate_time(String update_time){this.update_time=update_time;}
	
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-7-25 15:34:28
	 * @Method Name: GetParaList
	 */
	public ArrayList GetParaList(String X_Tag)
	{
		 
		ResultSet rst =null;
		String sql = "";
		ArrayList ParaList = new ArrayList();	
		if (X_Tag.equalsIgnoreCase("SEL_BY_ATTR"))
		{
			sql = "select * from commpara where subsys_code='WEB' and param_attr='"+this.param_attr+"'" +
				"and (sysdate between start_date and end_date) order by param_code asc";
		}

		DBQuery.setStrQuery(sql);
		rst = DBQuery.SelBizQuery();
		try
		{
			while (rst.next())
			{							
				CommParaMgr ParaData=new CommParaMgr();
				ParaData.setSubsys_code(commen.convetStrToWeb(rst.getString("subsys_code")));
				ParaData.setParam_attr(commen.convetStrToWeb(rst.getString("param_attr")));
				ParaData.setParam_code(commen.convetStrToWeb(rst.getString("param_code")));
				ParaData.setParam_name(commen.convetStrToWeb(rst.getString("param_name")));
				ParaData.setPara_code1(commen.convetStrToWeb(rst.getString("para_code1")));
				ParaData.setPara_code2(commen.convetStrToWeb(rst.getString("para_code2")));
				ParaData.setPara_code3(commen.convetStrToWeb(rst.getString("para_code3")));
				ParaData.setPara_code4(commen.convetStrToWeb(rst.getString("para_code4")));
				ParaData.setPara_code5(commen.convetStrToWeb(rst.getString("para_code5")));
				ParaData.setPara_code6(commen.convetStrToWeb(rst.getString("para_code6")));
				ParaData.setPara_code7(commen.convetStrToWeb(rst.getString("para_code7")));
				ParaData.setPara_code8(commen.convetStrToWeb(rst.getString("para_code8")));
				ParaData.setPara_code9(commen.convetStrToWeb(rst.getString("para_code9")));
				ParaData.setPara_code10(commen.convetStrToWeb(rst.getString("para_code10")));
				ParaData.setPara_code11(commen.convetStrToWeb(rst.getString("para_code11")));
				ParaData.setPara_code12(commen.convetStrToWeb(rst.getString("para_code12")));
				ParaData.setPara_code13(commen.convetStrToWeb(rst.getString("para_code13")));
				ParaData.setPara_code14(commen.convetStrToWeb(rst.getString("para_code14")));
				ParaData.setPara_code15(commen.convetStrToWeb(rst.getString("para_code15")));
				ParaData.setPara_code16(commen.convetStrToWeb(rst.getString("para_code16")));
				ParaData.setPara_code17(commen.convetStrToWeb(rst.getString("para_code17")));
				ParaData.setPara_code18(commen.convetStrToWeb(rst.getString("para_code18")));
				ParaData.setPara_code19(commen.convetStrToWeb(rst.getString("para_code19")));
				ParaData.setPara_code20(commen.convetStrToWeb(rst.getString("para_code20")));
				ParaData.setPara_code21(commen.convetStrToWeb(rst.getString("para_code21")));
				ParaData.setPara_code22(commen.convetStrToWeb(rst.getString("para_code22")));
				ParaData.setPara_code23(commen.convetStrToWeb(rst.getString("para_code23")));
				ParaData.setPara_code24(commen.convetStrToWeb(rst.getString("para_code24")));
				ParaData.setPara_code25(commen.convetStrToWeb(rst.getString("para_code25")));
				ParaData.setPara_code26(commen.convetStrToWeb(rst.getString("para_code26")));
				ParaData.setPara_code27(commen.convetStrToWeb(rst.getString("para_code27")));
				ParaData.setPara_code28(commen.convetStrToWeb(rst.getString("para_code28")));
				ParaData.setPara_code29(commen.convetStrToWeb(rst.getString("para_code29")));
				ParaData.setPara_code30(commen.convetStrToWeb(rst.getString("para_code30")));
				ParaData.setStart_date(commen.convetStrToWeb(rst.getString("start_date")));
				ParaData.setEnd_date(commen.convetStrToWeb(rst.getString("end_date")));
				ParaData.setRemark(commen.convetStrToWeb(rst.getString("remark")));
				ParaData.setUpdate_staff_id(commen.convetStrToWeb(rst.getString("update_staff_id")));
				ParaData.setUpdate_depart_id(commen.convetStrToWeb(rst.getString("update_depart_id")));
				ParaData.setUpdate_time(commen.convetStrToWeb(rst.getString("update_time")));	
				ParaList.add(ParaData);	
			}
		}
		catch (SQLException e)
		{	 
			System.out.println("SQLERROR:"+e.getMessage());		
		}
		catch (Exception e)
		{	 
			System.out.println("ERROR:"+e.getMessage());
		}
		return ParaList;
	}
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-6-9 14:33:58
	 * @Method Name:GetList
	 */
	public CommParaMgr[] GetList (ArrayList ParaItem) 
	{
		CommParaMgr[] ItemList=new CommParaMgr[ParaItem.size()];
		for(int i=0;i<ParaItem.size();i++)
		{ 
			CommParaMgr Item=(CommParaMgr)ParaItem.get(i); 
			ItemList[i]=Item; 
		}
		return ItemList;
	}
	
	/**
	 * 
	 * @author: Wangrc
	 * @Date: 2006-7-25 15:43:10
	 * @Method Name: GenSelectOption
	 */
	public String GenSelectOption(String strParaAttr)
	{
		String strResulut = "";
		this.param_attr = strParaAttr;
		ArrayList OptArry = this.GetParaList("SEL_BY_ATTR");