prodfunfeebean.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.config;


import com.doone.data.DacClient;
import com.doone.data.DataRow;
import com.doone.data.DataTable;
import com.doone.util.FileLogger;

/**
 *　这个类是用来对程控产品的资费说明表进行配置
 * @author NewDoone
 * @CopyRight 2005-2006
 */
public class ProdfunfeeBean  {
	DataRow repositoryInfo;
	//private DacClient _dbClient;
	private String Fee;
	private String FeeDesc;
	private String prodfunid;
	private String AffectDesc ;
	
	public ProdfunfeeBean() {
	}
	
	/**
	 * 根据输入的程控功能ｉｄ取得标准资费表的信息Td_Prodfunfee
	 * @param dbClient			数据库连接池
	 * @param sProdfunId		程控功能ｉｄ
	 * @return
	 */
	public DataTable getProdfunfeeByProdfunId(DacClient dbClient,String sProdfunId) {
		try {
			StringBuffer sql = new StringBuffer();
			sql.append("select ");
			sql.append("ProdfunfeeId,");
			sql.append("Fee,");
			sql.append("FeeDesc, ");
			sql.append("AffectDesc ");
			sql.append("from ");
			sql.append("Td_Prodfunfee");
			sql.append(" where Prodfunid="+sProdfunId); 
			DataTable dt = dbClient.executeQuery(sql.toString());
			return dt;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}

	/**
	 * 更新程控资费表，根据输入的prodfunfeeId
	 * @param prodfunfeeId
	 * @return
	 */
	public boolean updateFeeById(String prodfunfeeId) {
		boolean ok = true;
		Td_Prodfunfee td_prodfunfee = null;
		try {
			td_prodfunfee = new Td_Prodfunfee(new DacClient(),Integer.parseInt(prodfunfeeId));
			td_prodfunfee.setFee(Fee);
			td_prodfunfee.setFeedesc(FeeDesc);
			td_prodfunfee.setAffectDesc(AffectDesc) ;
			td_prodfunfee.setProdfunid(Integer.parseInt(this.prodfunid));
			td_prodfunfee.save();
			ok = true;
		}
		catch (Exception ex) {
			ok = false;
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
		return ok;
	}
	/**为某个程控功能添加资费表
	 * 
	 * @param ProdfunId
	 */
	public boolean AddFeeByProdfunId() {
		boolean ok = true;
		Td_Prodfunfee td_prodfunfee = null;
		try {
			td_prodfunfee = new Td_Prodfunfee(new DacClient());
			td_prodfunfee.setFee(Fee);
			td_prodfunfee.setFeedesc(FeeDesc);
			td_prodfunfee.setAffectDesc(AffectDesc) ;
			td_prodfunfee.setProdfunid(Integer.parseInt(this.prodfunid));
			td_prodfunfee.save();
			ok = true;
		}
		catch (Exception ex) {
			ok = false;
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
		return ok;
	}
	
	
	public void setFee(String Fee) {
		this.Fee = Fee;
	}	
	public void setProdfunid(String prodfunid) {
		this.prodfunid = prodfunid;
	}
	public void setFeeDesc(String FeeDesc) {
		this.FeeDesc = FeeDesc;
	}
	public String getProdfunid() {
		return prodfunid;
	}	
	public String getFee() {
		return Fee;
	}	
	public String getFeeDesc() {
		return FeeDesc;
	}

	public String getAffectDesc() {
		return AffectDesc;
	}

	public void setAffectDesc(String affectDesc) {
		AffectDesc = affectDesc;
	}
	
	
}