articlebean.java

电信的网厅的整站代码

			Object[] aParam = new Object[1];
			aParam[0] = CityCode;//按地域权限的
			dt = dbClient.executeQuery(sql.toString(),aParam);
			return dt;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**
	 * 
	 * @param ArticleId
	 */
	public String UpdateArticle(String ArticleId) {
		String ss = "";
		try {
			TD_Article td_article = new TD_Article(new DacClient(),ArticleId);
			td_article.setContent(content);
			td_article.setState(state);
			td_article.save();
			ss = "1";
			return ss;
		}
		catch (Exception ex) {
			ss = "0";
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**添加产品类免责条款协议
	 * 
	 *
	 */
	public String addArticleOfP() {
		String ss = "";
		try {
			/*StringBuffer sql = new StringBuffer();
			sql.append("insert ");
			sql.append("into ");
			sql.append("Td_Article(articleId,articleType,affairId,cityCode,areaCode,content,state) ");
			sql.append("values(Seq_articleId.NEXTVAL,?,?,?,?,?,?)"); 
			Object[] aParam = new Object[6];
			aParam[0] = articleType;
			aParam[1] = affairId;
			aParam[2] = cityCode;
			aParam[3] = areaCode;
			aParam[4] = content;
			aParam[5] = state;*/
			TD_Article td_article = new TD_Article(new DacClient());
			td_article.setArticleType(articleType);
			td_article.setAffairID(affairId);
			td_article.setCityCode(cityCode);
			td_article.setAreaCode(areaCode);
			td_article.setContent(content);
			td_article.setState(state);
			td_article.save();
			ss = "1";
		}
		catch (Exception ex) {
			ss = "0";
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
		return ss;
	}
	/**添加自定义免责条款协议
	 * 
	 *
	 */
	public String addArticleOfC() {
		try {
			StringBuffer sql = new StringBuffer();
			sql.append("insert ");
			sql.append("into ");   
			sql.append("Td_Article(articleId,articleType,affairId,cityCode,areaCode,content,state) ");
			sql.append("values(Seq_articleId.NEXTVAL,?,?,?,?,?,?)"); 
			Object[] aParam = new Object[6];
			aParam[0] = articleType;
			aParam[1] = affairId;
			aParam[2] = cityCode;
			aParam[3] = areaCode;
			aParam[4] = content;
			aParam[5] = state;
			String ss = cd.commitUpdateDate(sql.toString(),aParam);				
			return ss;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	
	/**从Ts_Configsub中找paraValue添加到条款协议表中
	 * 
	 * @param dbClient
	 * @param yeWuName
	 * @return
	 */
	public String getAffairId(DacClient dbClient,String yeWuName) {
		try {
			StringBuffer sql = new StringBuffer();
			sql.append("select ");
			sql.append("paraValue");
			sql.append(" from ");
			sql.append("Ts_Configsub");
			sql.append(" where paraDesc=?");
			Object[] aParam = new Object[1];
			aParam[0] = yeWuName;
			DataTable dt = dbClient.executeQuery(sql.toString(),aParam);
			String affairId = "";
			for(int i=0;i<dt.getRows().getCount();i++){
				affairId = dt.getRow(i).getString("paraValue");
			}
			return affairId;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	
	/**
	 * 
	 * @param dbClient
	 * @param ParaValue
	 * @return
	 */
	public DataTable getCarticle(DacClient dbClient,String ParaValue) {
		try {
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("select ");
			sql.append("ParaDesc");
			sql.append(" from ");
			sql.append("Ts_Configsub");
			sql.append(" where ParaName='ArticleSELFAffairID'");
			sql.append(" and ParaValue='"+ParaValue+"'");
			dt = dbClient.executeQuery(sql.toString());
			return dt;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	
	public DataTable getAllCity(DacClient dbClient) {
		try {
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("select ");
			sql.append("cityCode,");
			sql.append("cityName");
			sql.append(" from ");
			sql.append("Td_city");
			dt = dbClient.executeQuery(sql.toString());
			return dt;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	
	public String getCityCode(DacClient dbClient,String cityName) {
		try {
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("select ");
			sql.append("cityCode");
			sql.append(" from ");
			sql.append("Td_city");
			sql.append(" where cityName='"+cityName+"'");
			dt = dbClient.executeQuery(sql.toString());
			for(int j=0;j<dt.getRows().getCount();j++) {
				cityCode = dt.getRow(j).getString("cityCode");
			}
			return cityCode;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**判断某地是否有某条产品条款协议
	 * 
	 * @param dbClient
	 * @param cityCode
	 * @param affairId
	 * @return
	 */
	public boolean pArticleIs(DacClient dbClient,String cityCode,String affairId) {
		try {
			boolean b = true;
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("select ");
			sql.append("articleId");
			sql.append(" from ");
			sql.append("td_article ");
			sql.append("where cityCode=? and affairid=? and articleType='P'" );
			Object[] aParam = new Object[2];
			aParam[0] = cityCode;
			aParam[1] = affairId;
			dt = dbClient.executeQuery(sql.toString(),aParam);
			if(dt.getRows().getCount()!=0) b=false;
			return b;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	/**判断某地是否有某条自定义条款协议
	 * 
	 * @param dbClient
	 * @param cityCode
	 * @param affairId
	 * @return
	 */
	public boolean cArticleIs(DacClient dbClient,String cityCode,String affairId) {
		try {
			boolean b = true;
			StringBuffer sql = new StringBuffer();
			DataTable dt = null;
			sql.append("select ");
			sql.append("articleId");
			sql.append(" from ");
			sql.append("td_article ");
			sql.append("where cityCode=? and affairid=? and articleType='C'" );
			Object[] aParam = new Object[2];
			aParam[0] = cityCode;
			aParam[1] = affairId;
			dt = dbClient.executeQuery(sql.toString(),aParam);
			if(dt.getRows().getCount()!=0) b=false;
			return b;
		}
		catch (Exception ex) {
			FileLogger.getLogger().warn(ex);
			ex.printStackTrace();
			throw new RuntimeException(ex);
		}
	}
	
	
	public String getParaName() {
		return paraName;
	}	
	public String getParaValue() {
		return paraValue;
	}	
	public String getContent() {
		return content;
	}	
	public String getCityCode() {
		return cityCode;
	}	
	public String getState() {
		return state;
	}
	public String getArticleType() {
		return articleType;
	}
	public String getAffairId() {
		return affairId;
	}
	public String getAreaCode() {
		return areaCode;
	}
	public String getYeWuName() {
		return yeWuName;
	}
	public void setAffairId(String affairId) {
		this.affairId = affairId;
	}
	public void setParaName(String paraName) {
		this.paraName = paraName;
	}	
	public void setParaValue(String paraValue) {
		this.paraValue= paraValue;
	}	
	public void setContent(String content) {
		this.content = content;
	}	
	public void setCityCode(String cityCode) {
		this.cityCode = cityCode;
	}
	public void setState(String state) {
		this.state = state;
	}
	public void setArticleType(String articleType) {
		this.articleType = articleType;
	}
	public void setAreaCode(String areaCode) {
		this.areaCode = areaCode;
	}
	public void setYeWuName(String yeWuName) {
		this.yeWuName = yeWuName;
	}
	
	private static DataTable _entityStruct = null;
	
	protected DataTable get_entityStruct() {
		return _entityStruct;
	}
	
	protected void set_entityStruct(DataTable struct) {
		_entityStruct = struct;
	}
}