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 ClassinfoMgr extends Action{
	Logger log  = new Logger(this);
	public ClassinfoMgr(){}
	  DataBaseCommMgr DBQuery = new DataBaseCommMgr();
	  commMethodMgr commen = new commMethodMgr(); 

	  private String class_id ;     
	  private String class_name ;    
	  private String up_class_id  ;  
	  private String class_level  ;  
	  private String class_type ;    
	  private String class_desc ;    
	  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 getClass_desc()
		{
			return class_desc;
		}
	public void setClass_desc(String class_desc)
		{
			this.class_desc = class_desc;
		}
	public String getClass_id()
		{
			return class_id;
		}
	public void setClass_id(String class_id)
		{
			this.class_id = class_id;
		}
	public String getClass_level()
		{
			return class_level;
		}
	public void setClass_level(String class_level)
		{
			this.class_level = class_level;
		}
	public String getClass_name()
		{
			return class_name;
		}
	public void setClass_name(String class_name)
		{
			this.class_name = class_name;
		}
	public String getClass_type()
		{
			return class_type;
		}
	public void setClass_type(String class_type)
		{
			this.class_type = class_type;
		}
	public String getEnable_tag()
		{
			return enable_tag;
		}
	public void setEnable_tag(String enable_tag)
		{
			this.enable_tag = enable_tag;
		}
	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;
		}
	public String getUp_class_id()
		{
			return up_class_id;
		}
	public void setUp_class_id(String up_class_id)
		{
			this.up_class_id = up_class_id;
		}   
	/*
	 * add  by sjp date :2007-06-18
	 */
	public String AddClassinfo()
		{
			String sql = "";
			sql="insert into menuinfo values(" +
				"'"+commen.convetStrToDb(this.class_id)+"',"+
				"'"+commen.convetStrToDb(this.class_name)+"',"+
				"'"+commen.convetStrToDb(this.up_class_id)+"',"+
				"'"+commen.convetStrToDb(this.class_level)+"',"+
				"'"+commen.convetStrToDb(this.class_type)+"',"+
				"'"+commen.convetStrToDb(this.class_desc)+"',"+
				"'"+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_PRO"))
			{
				sql = "select * from td_b_productclass where class_level='1' and enable_tag='0' and class_type='2'";
			}
			else
			if (X_tag.equalsIgnoreCase("SEL_BY_CLASS_1"))
			{
				sql = "select * from td_b_productclass where class_level='1' and enable_tag='0' and class_type='"+this.class_type+"'";
			}
			else if (X_tag.equalsIgnoreCase("SEL_BY_PROUP"))
			{
				sql = "select * from td_b_productclass where up_class_id='"+this.up_class_id+"' and enable_tag='0' and class_type='2'";
			}
			else if (X_tag.equalsIgnoreCase("SEL_BY_UP"))
			{
				sql = "select * from td_b_productclass where up_class_id='"+this.up_class_id+"' and enable_tag='0' and class_type='"+this.class_type+"'";
			}
			ResultSet rst = null;
			ArrayList classList = new ArrayList();				
			DBQuery.setStrQuery(sql);
			rst = DBQuery.SelBizQuery();
			try
			{	log.LOG_INFO("X_tag................"+X_tag);
				log.LOG_INFO("sql..........."+sql);
				while (rst.next())
				{			
					log.LOG_INFO("xxxxxxxxxxxxxxxxx");
					ClassinfoMgr classinfo = new ClassinfoMgr();	
					classinfo.setClass_id(rst.getString("class_id"));					
					classinfo.setClass_name(rst.getString("class_name"));
					classinfo.setClass_desc(rst.getString("class_desc"));
					classinfo.setClass_level(rst.getString("class_level"));	
					classinfo.setClass_type(rst.getString("class_type"));					
					classinfo.setEnable_tag(rst.getString("enable_tag"));				
					classinfo.setUp_class_id(rst.getString("up_class_id"));	
					classinfo.setRsrv_str1(rst.getString("rsrv_str1"));
					classinfo.setRsrv_str2(rst.getString("rsrv_str2"));
					classinfo.setRsrv_str3(rst.getString("rsrv_str3"));
					classinfo.setRsrv_str4(rst.getString("rsrv_str4"));
					classinfo.setRsrv_str5(rst.getString("rsrv_str5"));
					classinfo.setRsrv_str6(rst.getString("rsrv_str6"));
					classinfo.setRsrv_str7(rst.getString("rsrv_str7"));
					classinfo.setRsrv_str8(rst.getString("rsrv_str8"));
					classinfo.setRsrv_str9(rst.getString("rsrv_str9"));
					classinfo.setRsrv_str10(rst.getString("rsrv_str10"));
					classinfo.setRemark(rst.getString("remark"));
					classList.add(classinfo);
				}
				
			}
			catch (Exception e)
			{	 	
			}
			DBQuery.CloseConn();
			return classList;				
		}
	public ClassinfoMgr[] GetList (ArrayList ParaItem) 
		{
			ClassinfoMgr[] ItemList=new ClassinfoMgr[ParaItem.size()];
			for(int i=0;i<ParaItem.size();i++)
			{ 
				ClassinfoMgr Item=(ClassinfoMgr)ParaItem.get(i); 
				ItemList[i]=Item; 
			}
			return ItemList;
		}
	public ClassinfoMgr GetMenuInfo(String X_tag)
		{
			String sql = "";
			if (X_tag.equalsIgnoreCase("SEL_BY_CUST"))
			{

			}

			
			ResultSet rst = null;
			ClassinfoMgr classinfo = new ClassinfoMgr();	
			
			DBQuery.setStrQuery(sql);
			rst = DBQuery.SelBizQuery();
			try
			{
				while (rst.next())
				{
					classinfo.setClass_id(rst.getString("class_id"));
					classinfo.setClass_name(rst.getString("class_name"));
					classinfo.setClass_level(rst.getString("class_level"));
					classinfo.setClass_type(rst.getString("class_type"));
					classinfo.setEnable_tag(rst.getString("enable_tag"));
					classinfo.setClass_desc(rst.getString("class_desc"));
					classinfo.setUp_class_id(rst.getString("up_class_id"));
					classinfo.setRsrv_str1(commen.convetStrToWeb(rst.getString("rsrv_str1")));
					classinfo.setRsrv_str2(commen.convetStrToWeb(rst.getString("rsrv_str2")));
					classinfo.setRsrv_str3(commen.convetStrToWeb(rst.getString("rsrv_str3")));
					classinfo.setRsrv_str4(commen.convetStrToWeb(rst.getString("rsrv_str4")));
					classinfo.setRsrv_str5(commen.convetStrToWeb(rst.getString("rsrv_str5")));
					classinfo.setRsrv_str6(commen.convetStrToWeb(rst.getString("rsrv_str6")));
					classinfo.setRsrv_str7(commen.convetStrToWeb(rst.getString("rsrv_str7")));
					classinfo.setRsrv_str8(commen.convetStrToWeb(rst.getString("rsrv_str8")));
					classinfo.setRsrv_str9(commen.convetStrToWeb(rst.getString("rsrv_str9")));
					classinfo.setRsrv_str10(commen.convetStrToWeb(rst.getString("rsrv_str10")));
					classinfo.setRemark(commen.convetStrToWeb(rst.getString("remark")));
				}
			}
			catch (Exception e)
			{	 	
			}
			DBQuery.CloseConn();
			return classinfo;				
		}
	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;
		}
		
}