package com.saas.biz.ClassMgr;

import java.sql.ResultSet;
import java.util.ArrayList;
import org.apache.struts.action.Action;
import com.ahbay.commenMgr.DataBaseCommMgr;
import com.ahbay.commenMgr.commMethodMgr;
import com.saas.sys.log.Logger;

public class AttrMgr extends Action{
	Logger log  = new Logger(this);
	public AttrMgr(){}
	  DataBaseCommMgr DBQuery = new DataBaseCommMgr();
	  commMethodMgr commen = new commMethodMgr(); 
	  private String   class_id ; 
	  private String   attr_id   ; 
	  private String   attr_name  ; 
	  private String   attr_desc ; 
	  private String   attr_no ; 
	  private String   default_tag ; 
	  private String   default_value; 
	  private String   enable_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_str10 ; 
	  private String   remark; 

	  /*
	   * subsys_code property
	   */
	public String Addattrinfo()
			{
				String sql = "";
				sql="insert into menuinfo values(" +
					"'"+commen.convetStrToDb(this.class_id)+"',"+
					"'"+commen.convetStrToDb(this.attr_name)+"',"+
					"'"+commen.convetStrToDb(this.attr_id)+"',"+
					"'"+commen.convetStrToDb(this.attr_desc)+"',"+
					"'"+commen.convetStrToDb(this.attr_no)+"',"+
					"'"+commen.convetStrToDb(this.default_tag)+"',"+
					"'"+commen.convetStrToDb(this.default_value)+"',"+
					"'"+commen.convetStrToDb(this.enable_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_str10)+"',"+
					"'"+commen.convetStrToDb(this.remark)+"'"+
					")";
				DBQuery.setStrQuery(sql);	
				String strRst=DBQuery.ExecBizQuery();		
				return strRst;
	}
	public ArrayList GetClassList(String X_tag)
		{
			String sql = "";
			if (X_tag.equalsIgnoreCase("SEL_BY_CLASS_ID"))
			{
				sql = "select * from td_b_productattr  where class_id='"+this.class_id+"'";
			}
			ResultSet rst = null;
			ArrayList attrList = new ArrayList();				
			DBQuery.setStrQuery(sql);
			rst = DBQuery.SelBizQuery();
			try
			{
				while (rst.next())
				{				
					AttrMgr attrinfo = new AttrMgr();	
					attrinfo.setAttr_desc(rst.getString("attr_desc"));
					attrinfo.setAttr_id(rst.getString("attr_id"));
					attrinfo.setClass_id(rst.getString("class_id"));
					attrinfo.setAttr_name(rst.getString("attr_name"));
					attrinfo.setAttr_no(rst.getString("attr_no"));
					attrinfo.setDefault_tag(rst.getString("default_tag"));
					attrinfo.setDefault_value(rst.getString("default_value"));
					attrinfo.setEnable_tag(rst.getString("enable_tag"));
					attrinfo.setRsrv_str1(rst.getString("rsrv_str1"));
					attrinfo.setRsrv_str2(rst.getString("rsrv_str2"));
					attrinfo.setRsrv_str3(rst.getString("rsrv_str3"));
					attrinfo.setRsrv_str4(rst.getString("rsrv_str4"));
					attrinfo.setRsrv_str5(rst.getString("rsrv_str5"));
					attrinfo.setRsrv_str6(rst.getString("rsrv_str6"));
					attrinfo.setRsrv_str7(rst.getString("rsrv_str7"));
					attrinfo.setRsrv_str8(rst.getString("rsrv_str8"));
					attrinfo.setRsrv_str9(rst.getString("rsrv_str9"));
					attrinfo.setRsrv_str10(rst.getString("rsrv_str10"));
					attrinfo.setRemark(rst.getString("remark"));
					attrList.add(attrinfo);
				}
			}
			catch (Exception e)
			{	 	
			}
			DBQuery.CloseConn();
			return attrList;				
		}
	public AttrMgr[] GetList (ArrayList ParaItem) 
		{
			AttrMgr[] ItemList=new AttrMgr[ParaItem.size()];
			for(int i=0;i<ParaItem.size();i++)
			{ 
				AttrMgr Item=(AttrMgr)ParaItem.get(i); 
				ItemList[i]=Item; 
			}
			return ItemList;
		}
	public AttrMgr GetAttrInfo(String X_tag)
		{
			String sql = "";
			if (X_tag.equalsIgnoreCase("SEL_BY_CUST"))
			{
			}
			ResultSet rst = null;
			AttrMgr attrinfo = new AttrMgr();	
			
			DBQuery.setStrQuery(sql);
			rst = DBQuery.SelBizQuery();
			try
			{
				while (rst.next())
				{
					attrinfo.setAttr_desc(rst.getString("attr_desc"));
					attrinfo.setAttr_id(rst.getString("attr_id"));
					attrinfo.setClass_id(rst.getString("class_id"));
					attrinfo.setAttr_name(rst.getString("attr_name"));
					attrinfo.setAttr_no(rst.getString("attr_no"));
					attrinfo.setDefault_tag(rst.getString("default_tag"));
					attrinfo.setDefault_value(rst.getString("default_value"));
					attrinfo.setEnable_tag(rst.getString("enable_tag"));
					attrinfo.setRsrv_str1(commen.convetStrToWeb(rst.getString("rsrv_str1")));
					attrinfo.setRsrv_str2(commen.convetStrToWeb(rst.getString("rsrv_str2")));
					attrinfo.setRsrv_str3(commen.convetStrToWeb(rst.getString("rsrv_str3")));
					attrinfo.setRsrv_str4(commen.convetStrToWeb(rst.getString("rsrv_str4")));
					attrinfo.setRsrv_str5(commen.convetStrToWeb(rst.getString("rsrv_str5")));
					attrinfo.setRsrv_str6(commen.convetStrToWeb(rst.getString("rsrv_str6")));
					attrinfo.setRsrv_str7(commen.convetStrToWeb(rst.getString("rsrv_str7")));
					attrinfo.setRsrv_str8(commen.convetStrToWeb(rst.getString("rsrv_str8")));
					attrinfo.setRsrv_str9(commen.convetStrToWeb(rst.getString("rsrv_str9")));
					attrinfo.setRsrv_str10(commen.convetStrToWeb(rst.getString("rsrv_str10")));
					attrinfo.setRemark(commen.convetStrToWeb(rst.getString("remark")));
				}
			}
			catch (Exception e)
			{	 	
			}
			DBQuery.CloseConn();
			return attrinfo;				
		}
	public String DelClass()
		{
			String sql = "";
			sql="delete td_b_productclass where class_id='"+this.class_id+"'";
			DBQuery.setStrQuery(sql);	
			String strRst=DBQuery.ExecBizQuery();		
			return strRst;
		}
	public String getAttr_desc()
		{
			return attr_desc;
		}
	public void setAttr_desc(String attr_desc)
		{
			this.attr_desc = attr_desc;
		}
	public String getAttr_id()
		{
			return attr_id;
		}
	public void setAttr_id(String attr_id)
		{
			this.attr_id = attr_id;
		}
	public String getAttr_name()
		{
			return attr_name;
		}
	public void setAttr_name(String attr_name)
		{
			this.attr_name = attr_name;
		}
	public String getAttr_no()
		{
			return attr_no;
		}
	public void setAttr_no(String attr_no)
		{
			this.attr_no = attr_no;
		}
	public String getClass_id()
		{
			return class_id;
		}
	public void setClass_id(String class_id)
		{
			this.class_id = class_id;
		}
	public commMethodMgr getCommen()
		{
			return commen;
		}
	public void setCommen(commMethodMgr commen)
		{
			this.commen = commen;
		}
	public DataBaseCommMgr getDBQuery()
		{
			return DBQuery;
		}
	public void setDBQuery(DataBaseCommMgr query)
		{
			DBQuery = query;
		}
	public String getDefault_tag()
		{
			return default_tag;
		}
	public void setDefault_tag(String default_tag)
		{
			this.default_tag = default_tag;
		}
	public String getDefault_value()
		{
			return default_value;
		}
	public void setDefault_value(String default_value)
		{
			this.default_value = default_value;
		}
	public String getEnable_tag()
		{
			return enable_tag;
		}
	public void setEnable_tag(String enable_tag)
		{
			this.enable_tag = enable_tag;
		}
	public Logger getLog()
		{
			return log;
		}
	public void setLog(Logger log)
		{
			this.log = log;
		}
	public String getRemark()
		{
			return remark;
		}
	public void setRemark(String remark)
		{
			this.remark = remark;
		}
	public String getRsrv_str1()
		{
			return rsrv_str1;
		}
	public void setRsrv_str1(String rsrv_str1)
		{
			this.rsrv_str1 = rsrv_str1;
		}
	public String getRsrv_str10()
		{
			return rsrv_str10;
		}
	public void setRsrv_str10(String rsrv_str10)
		{
			this.rsrv_str10 = rsrv_str10;
		}
	public String getRsrv_str2()
		{
			return rsrv_str2;
		}
	public void setRsrv_str2(String rsrv_str2)
		{
			this.rsrv_str2 = rsrv_str2;
		}
	public String getRsrv_str3()
		{
			return rsrv_str3;
		}
	public void setRsrv_str3(String rsrv_str3)
		{
			this.rsrv_str3 = rsrv_str3;
		}
	public String getRsrv_str4()
		{
			return rsrv_str4;
		}
	public void setRsrv_str4(String rsrv_str4)
		{
			this.rsrv_str4 = rsrv_str4;
		}
	public String getRsrv_str5()
		{
			return rsrv_str5;
		}
	public void setRsrv_str5(String rsrv_str5)
		{
			this.rsrv_str5 = rsrv_str5;
		}
	public String getRsrv_str6()
		{
			return rsrv_str6;
		}
	public void setRsrv_str6(String rsrv_str6)
		{
			this.rsrv_str6 = rsrv_str6;
		}
	public String getRsrv_str7()
		{
			return rsrv_str7;
		}
	public void setRsrv_str7(String rsrv_str7)
		{
			this.rsrv_str7 = rsrv_str7;
		}
	public String getRsrv_str8()
		{
			return rsrv_str8;
		}
	public void setRsrv_str8(String rsrv_str8)
		{
			this.rsrv_str8 = rsrv_str8;
		}
	public String getRsrv_str9()
		{
			return rsrv_str9;
		}
	public void setRsrv_str9(String rsrv_str9)
		{
			this.rsrv_str9 = rsrv_str9;
		}
		

}