prodfunbean.java

来自「电信的网厅的整站代码」· Java 代码 · 共 789 行 · 第 1/2 页

			sql.append("SetupState, ");
			sql.append("FunDesc, ");
			sql.append("FunState, ");
			sql.append("Output, ");
			sql.append("FunType, ");
			sql.append("PageAttemperPara, ");
			sql.append("FunName_bss, ");
			sql.append("IfNew");
			sql.append(" from ");
			sql.append("Td_Prodfun");
			sql.append(" where ProdfunId=?");
			Object[] aParam = new Object[1];
			aParam[0] = sProdfunId;
			DataTable dt = dbClient.executeQuery(sql.toString(),aParam);
			return dt;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**已经配置过的可变更的套餐(用于分页)
	 * 
	 * @param dbClient
	 * @param funCode
	 * @param cityCode
	 * @param pageNo
	 * @return
	 */
	public DataTable getChangeTaoCan(DacClient dbClient,String funCode,String cityCode,int pageNo) {
		try {
            StringBuffer sql = new StringBuffer();
			sql.append("select ");
			sql.append("d.USERWAREID,");
			sql.append("d.CITYCODE,");
			sql.append("d.FUNCODE,");
			sql.append("d.FUNCODE_TARGET,");
			sql.append("d.ACTION_TYPE,");
			sql.append("d.CREATETIME,");
			sql.append("d.STATE,");
			sql.append("d.PRODUCTID,");
			sql.append("d.USERWARE_TYPE from ");
			sql.append("(select c.*,rownum num from TD_USERWARE_CONF c");
		    sql.append(" where c.FUNCODE=? and c.CITYCODE=?)d");
			sql.append(" where num>="+((pageNo - 1) * pageSize)+" and num<="+(pageNo * pageSize));
			Object[] aParam = new Object[2];
			aParam[0] = funCode;
			aParam[1] = cityCode;
			DataTable dt = dbClient.executeQuery(sql.toString(),aParam);
			return dt;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**得到funCode(某套餐)可添加的变更套餐(滤掉已添加的变更套餐)
	 * 
	 * @param dbClient
	 * @param funCode
	 * @param cityCode
	 * @return
	 */
	public DataTable getChangeTaoCan(DacClient dbClient,String funCode,String cityCode) {
		try {
            StringBuffer sql = new StringBuffer();
			sql.append("select a.* from td_prodfun a ");
			sql.append("where a.funcode not in ");
			sql.append("(select b.funcode_target from td_userware_conf b ");
			sql.append("where b.citycode=? and b.productid='2' ");
			sql.append("and b.funcode=?) ");
			sql.append("and a.citycode=? ");
			sql.append("and a.productid='2' ");
			sql.append("and a.funtype='T'");
			sql.append("and a.funcode!=?");//过滤掉自己

			Object[] aParam = new Object[4];
			aParam[0] = cityCode;
			aParam[1] = funCode;
			aParam[2] = cityCode;
			aParam[3] = funCode;
			DataTable dt = dbClient.executeQuery(sql.toString(),aParam);
			return dt;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	
	public DataTable getChangeTaoCanByCode(DacClient dbClient,String funCode,String cityCode) {
		try {
            StringBuffer sql = new StringBuffer();
			sql.append("select ");
			sql.append("ProdfunId, ");
			sql.append("PRODUCTID, ");
			sql.append("FUNCODE, ");
			sql.append("FUNNAME, ");
			sql.append("AFFAIRURL, ");
			sql.append("FUNAUTO, ");
			sql.append("PwdLevel, ");
			sql.append("CallerType, ");
			sql.append("OpenState, ");
			sql.append("SetupState, ");
			sql.append("FunDesc, ");
			sql.append("FunState, ");
			sql.append("Output, ");
			sql.append("FunType, ");
			sql.append("PageAttemperPara, ");
			sql.append("FunName_bss, ");
			sql.append("IfNew");
			sql.append(" from ");
			sql.append("Td_Prodfun");
			sql.append(" Where FUNCODE=? and CITYCODE=?");
			Object[] aParam = new Object[2];
			aParam[0] = funCode;
			aParam[1] = cityCode;
			DataTable dt = dbClient.executeQuery(sql.toString(),aParam);
			return dt;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**
	 * 根据ProdfunId修改程控功能
	 * @param sProdfunId 
	 */
	public boolean UpdateProdfunByFunCode(String sProdfunId) {
		boolean ok = true;
		try {
//			查询程控功能的互斥关系
			MutexleanFunBean mfb = new MutexleanFunBean();
		    DataTable Corrprodlist1 = mfb.getMutexleanFunById(new DacClient(),sProdfunId,"1","C");
		    if(Corrprodlist1.getRows().getCount() > 0){
		    	//将互斥的程控功能同时进行修改
		    	for(int i=0;i<Corrprodlist1.getRows().getCount();i++){
//		    		将依赖于该程控功能的程控功能同时进行修改
		    		ok = this.UpdateCorrprodFun(Corrprodlist1.getRow(i).getString("Corrprodfunid"));
		    	}
		    	
		    }
//			查询程控功能的依赖关系
		    DataTable Corrprodlist2 = mfb.getMutexleanFunById(new DacClient(),sProdfunId,"C");
		    if(Corrprodlist2.getRows().getCount() > 0){
		    	for(int i=0;i<Corrprodlist2.getRows().getCount();i++){
//		    		将依赖于该程控功能的程控功能同时进行修改
			    	ok = this.UpdateCorrprodFun(Corrprodlist2.getRow(0).getString("Prodfunid"));
		    	}
		    }
		    if(ok){
		    	Td_prodFun td_prodFun = new Td_prodFun(new DacClient(),sProdfunId);
				td_prodFun.setFunName(FunName);
				td_prodFun.setAffairUrl(AffairUrl);
				td_prodFun.setPwdLevel(PwdLevel);
				td_prodFun.setCallerType(CallerType);
				td_prodFun.setOpenState(OpenState);
				td_prodFun.setFunDesc(FunDesc);
				td_prodFun.setOutPut(Output);
				td_prodFun.setIfNew(IfNew);
				td_prodFun.save();
				ok = true;
		    }
		    else ok = false;
		}
		catch (Exception ex) {
			ok = false;
			FileLogger.getLogger().info(ex);
			throw new RuntimeException(ex);
		}
		return ok;
	}
	/**
	 * 
	 * @param sProdfunId
	 * @return
	 */
	public boolean UpdateCorrprodFun(String corrprodFunId) {
		boolean ok = true;
		try {
			Td_prodFun td_prodFun = new Td_prodFun(new DacClient(),corrprodFunId);
			td_prodFun.setOutPut(Output);
			td_prodFun.save();
		}
		catch (Exception ex) {
			ok = false;
			FileLogger.getLogger().info(ex);
			throw new RuntimeException(ex);
		}
		return ok;
	}
	
	/**添加某套餐的变更套餐
	 * 
	 * @param taoCanCode
	 * @param changeTaoCanCode
	 * @param cityCode
	 * @return
	 */
	public boolean addChangeTanCan(String taoCanCode,String changeTaoCanCode,String taoCanType,String cityCode) {
		boolean ok = true;
		try {
			StringBuffer sql = new StringBuffer();
			sql.append("insert ");
			sql.append("into ");
			sql.append("TD_USERWARE_CONF(USERWAREID,CITYCODE,FUNCODE,FUNCODE_TARGET," +
			"ACTION_TYPE,CREATETIME,STATE,PRODUCTID,USERWARE_TYPE) ");
			if(taoCanCode.equals("-1")) {
				if(taoCanType.equals("1")){
				    sql.append("values(seq_userwareid.nextval,?,?,?,'A',sysdate,'E','2','1')");
				}
				else if(taoCanType.equals("2")){
					sql.append("values(seq_userwareid.nextval,?,?,?,'A',sysdate,'E','2','2')");
				}
			}
			else {
				if(taoCanType.equals("1")){
				    sql.append("values(seq_userwareid.nextval,?,?,?,'C',sysdate,'E','2','1')");
				}
				else if(taoCanType.equals("2")){
					sql.append("values(seq_userwareid.nextval,?,?,?,'C',sysdate,'E','2','2')");
				}
			}
			Object[] aParam = new Object[3];
			aParam[0] = cityCode;
			aParam[1] = taoCanCode;
			aParam[2] = changeTaoCanCode;
			String ss= cd.commitUpdateDate(sql.toString(),aParam);
			if(ss.equals("0")) {
				ok = false;
			}
		}
		catch (Exception ex) {
			ok = false;
			FileLogger.getLogger().info(ex);
			throw new RuntimeException(ex);
		}
		return ok;
	}
	/**删除某套餐的变更套餐
	 * 
	 * @param taoCanCode
	 * @param changeTaoCanCode
	 * @param cityCode
	 * @return
	 */
	public boolean delChangeTanCan(String taoCanCode,String changeTaoCanCode,String cityCode) {
		boolean ok = true;
		try {
			StringBuffer sql = new StringBuffer();
			sql.append("delete ");
			sql.append("from ");
			sql.append("TD_USERWARE_CONF ");
			sql.append("where FUNCODE=? and FUNCODE_TARGET=? and cityCode=?");
			Object[] aParam = new Object[3];
			aParam[0] = taoCanCode;
			aParam[1] = changeTaoCanCode;
			aParam[2] = cityCode;
			String ss= cd.commitUpdateDate(sql.toString(),aParam);
			if(ss.equals("0")) {
				ok = false;
			}
		}
		catch (Exception ex) {
			ok = false;
			FileLogger.getLogger().info(ex);
			throw new RuntimeException(ex);
		}
		return ok;
	}
	/**配置变更套餐
	 * 
	 * @param taoCanCode
	 * @param changeTaoCanCode
	 * @param cityCode
	 * @return
	 */
	public boolean editChangeTanCan(String taoCanCode,String changeTaoCanCode,String cityCode,String state) {
		boolean ok = true;
		try {
			StringBuffer sql = new StringBuffer();
			sql.append("update ");
			sql.append("TD_USERWARE_CONF ");
			sql.append("set state=? ");
			sql.append("where FUNCODE=? and FUNCODE_TARGET=? and cityCode=?");
			Object[] aParam = new Object[4];
			aParam[0] = state;
			aParam[1] = taoCanCode;
			aParam[2] = changeTaoCanCode;
			aParam[3] = cityCode;
			String ss= cd.commitUpdateDate(sql.toString(),aParam);
			if(ss.equals("0")) {
				ok = false;
			}
		}
		catch (Exception ex) {
			ok = false;
			FileLogger.getLogger().info(ex);
			throw new RuntimeException(ex);
		}
		return ok;
	}
	
	public String getPwdLevel(String sPwdLevel) {
		int iPwdLevel = Integer.parseInt(sPwdLevel);
		if(iPwdLevel == 1)
			return ProdfunBean.PWDLEVEL_1;
		else
			return ProdfunBean.PWDLEVEL_0;
	}	
	public String getFunState(String sState) {
		if(sState.equals("E"))
			return ProdfunBean.FUNSTATE_E;
		else
			return ProdfunBean.FUNSTATE_D;
	}	
	public String getFunType(String sFunType) {
		if(sFunType.equals("C"))
			return ProdfunBean.FUNTYPE_C;
		else if(sFunType.equals("T"))
			return ProdfunBean.FUNTYPE_T;
		else
			return ProdfunBean.FUNTYPE_N;
	}	
	public String getFunName_bss() {
		return FunName_bss;
	}
	public String getAffairUrl() {
		return AffairUrl;
	}
	public String getOpenState() {
		return OpenState;
	}
	  
	public void setFunCode(String FunCode) {
		this.FunCode = FunCode;
	}	
	public void setFunName(String FunName) {
		this.FunName = FunName;
	}	
	public void setFunAuto(String FunAuto) {
		this.FunAuto = FunAuto;
	}	
	public void setPwdLevel(String PwdLevel) {
		this.PwdLevel = PwdLevel;
	}
	public void setCallerType(String CallerType) {
		this.CallerType = CallerType;
	}
	public void setOpenState(String OpenState) {
		this.OpenState = OpenState;
	}
	public void setSetupState(String SetupState) {
		this.SetupState = SetupState;
	}
	public void setFunDesc(String FunDesc) {
		this.FunDesc = FunDesc;
	}
	public void setFunState(String FunState) {
		this.FunState = FunState;
	}
	public void setOutput(String Output) {
		this.Output = Output;
	}
	public void setFunType(String FunType) {
		this.FunType = FunType;
	}
	public void setFunName_bss(String FunName_bss) {
		this.FunName_bss = FunName_bss;
	}
	public void setIfNew(String IfNew) {
		this.IfNew = IfNew;
	}
	public void setAffairUrl(String AffairUrl) {
		this.AffairUrl = AffairUrl;
	}
	
	
	private static DataTable _entityStruct = null;
	
	protected DataTable get_entityStruct() {
		return _entityStruct;
	}
	
	protected void set_entityStruct(DataTable struct) {
		_entityStruct = struct;
	}
}