appealdao.java

电信的网厅的整站代码

	 */
	public static void archvieFailSheet(){
		StringBuffer sql = new StringBuffer();
		sql.append("update tf_appeal t set t.BOSOMPROGRESSSTATE='A' where");
		sql.append(" t.PROGRESSSTATE='3' and t.BOSOMPROGRESSSTATE='9' and sysdate-t.createtime > ?");
		
		try{
			_dac.executeUpdate(sql.toString(), 20000,new Object[]{getFailArchivalDay()});
		}catch(Exception ex){
			_logger.warn("Appeal 故障单归档失败： " + ex.getMessage());
		}
	}
	
	/**
	 * <p>建议投诉归档</p>
	 *
	 */
	public static void archvieAdviceSheet(){
		StringBuffer sql = new StringBuffer();
		sql.append("update tf_appeal t set t.BOSOMPROGRESSSTATE='A' where");
		sql.append(" t.PROGRESSSTATE='3' and t.BOSOMPROGRESSSTATE='9' and sysdate-t.createtime > ?");
		
		try{
			_dac.executeUpdate(sql.toString(), 20000,new Object[]{getAdviceArchivalDay()});
		}catch(Exception ex){
			_logger.warn("Appeal 建议投诉单归档失败： " + ex.getMessage());
		}
	}
	
	/**
	 * 作废订单
	 *
	 * @param APPEALID
	 *            订单ID
	 */
	public void blankOut(String APPEALID) {
		String sql = "update tf_appeal t set PROGRESSSTATE = '3',BOSOMPROGRESSSTATE= '8', LOCKSTAFFID ='' where APPEALID = ? ";
		Object[] value = new Object[1];
		value[0] = APPEALID;

		try {
			_dac.executeUpdate(sql, 10000, value);
		} catch (Exception e) {
			_logger.warn(e.getMessage(),e);

		}
	}

	/**
	 * 设置进度状态
	 *
	 * @param state
	 *            1、等待处理 2、处理中 （分二种，一种已提供给第三方系统，一种是审核岗查阅过但还未提供给第三方系统，
	 *            他们根据Tf_ProdOrderInterface表中的第三方定单流水号字段来区分） 3、处理结束
	 * @param prodorderID
	 */
	public void setProcessState(String state, String APPEALID) {
		String sql = "update tf_appeal t set PROGRESSSTATE = ? where APPEALID = to_number(?)";
		Object[] value = new Object[2];
		value[0] = state;
		value[1] = APPEALID;
		try {
			_dac.executeUpdate(sql, 10000, value);
		} catch (Exception e) {
			_logger.warn(e.getMessage(),e);

		}
	}

	/**
	 * 设置超时限
	 *
	 * @param date
	 *            超时日期
	 */
	public void updateOutDate(String date, String APPEALID) {
		String sql = "update tf_appeal set OUTDATE=sysdate where APPEALID=to_number(?)";
		Object[] value = new Object[1];
		value[0] = APPEALID;
		try {
			_dac.executeUpdate(sql, 10000, value);

		} catch (Exception e) {
			_logger.warn(" 超时时限更新失败 " + e.getMessage());
		}
	}

	/**
	 * 受理单处理过程状态设置
	 *
	 * @param state
	 *            状态 1、待处理 2、转派 3、暂存 8、作废（作废的受理单也纳入完成范围内） 9、完成
	 * @param prodorderID
	 *            受理单ID
	 */
	public void setBosomprogressstate(String state, String APPEALID) {
		String sql = "update tf_appeal set BOSOMPROGRESSSTATE=? where APPEALID=to_number(?)";
		Object[] value = new Object[2];
		value[0] = state;
		value[1] = APPEALID;
		try {
			_dac.executeUpdate(sql, 10000, value);
		} catch (Exception e) {
			_logger.warn("受理单处理过程状态  " + e.getMessage());
		}
	}

	public boolean setThirdOrderToAppeal(String thirdOrder,String appealid){
		try{
			String sql = "update tf_appeal set OTHERORDER=? where APPEALID=?";
			Object[] value = new Object[2];
			value[0] = thirdOrder;
			value[1] = appealid;

			int i = _dac.executeUpdate(sql, 10000, value);
			if(i > 0 )
				 return true;

		}catch(Exception ex){
			_logger.warn("受理单处理过程状态  " + ex.getMessage());
		}
		return false;
	}


	/**
	 * 更新第三方流水号
	 *
	 * @param OherorderID
	 *            第三方流水号
	 * @param AppealID
	 *            故障ID
	 */
	static public boolean updateOherorder(String OherorderID, String AppealID) {
		String sql = "update tf_appeal t set OTHERORDER=?,PROGRESSSTATE='2'," +
				     "BOSOMPROGRESSSTATE='2' where APPEALID=?";
		Object[] value = new Object[2];
		value[0] = OherorderID;
		value[1] = AppealID;
		try {
			int i = _dac.executeUpdate(sql, 10000, value);
			 if(i > 0)
				 return true;
		} catch (Exception e) {
            _logger.warn("updateOherorder  " + e.getMessage());
		}
		return false;
	}

	/**
	 * 取性别名称
	 *
	 * @param citycode
	 *            地市代码
	 * @param sex
	 *            性别代码
	 */
	public String getAppealSexName(String citycode,String sex) {
		String name = "";
		Object[] _object = null;
		String sql = "select TYPEDETAILCODE,TYPEDETAILNAME from td_180codeconf where STATE='E' and TYPEDETAILCODE=? and TYPECODE=? and citycode=?";
		_object = new Object[3];
		_object[0] = sex;
		_object[1] = "102";//fb.getString("TYPECODE");
		_object[2] = citycode;
		
		try {
			DataTable dt = _dac.executeQuery(sql, _object);
			if (dt==null||dt.getRows().getCount()<=0){
				if (sex.equals("A")){
					name = "男";
				}else if (sex.equals("B")){
					name = "女";
				}else{
					name = "保密";
				}
			}else{
				name = dt.getRow(0).getString("TYPEDETAILNAME");
			}
		} catch (Exception ex) {
		}
		return name==null?"":name;
	}	
	/**
	 * @param accountno
	 *            要设置的 accountno。
	 */
	public void setAccountno(String accountno) {
		this.accountno = accountno;
	}

	/**
	 * @param appeacontent
	 *            要设置的 appeacontent。
	 */
	public void setAppeacontent(String appeacontent) {
		this.appeacontent = appeacontent;
	}

	/**
	 * @param appealid
	 *            要设置的 appealid。
	 */
	public void setAppealid(String appealid) {
		this.appealid = appealid;
	}

	/**
	 * @param appealmode
	 *            要设置的 appealmode。
	 */
	public void setAppealmode(String appealmode) {
		this.appealmode = appealmode;
	}

	/**
	 * @param appealtitle
	 *            要设置的 appealtitle。
	 */
	public void setAppealtitle(String appealtitle) {
		this.appealtitle = appealtitle;
	}

	/**
	 * @param appealtypeid
	 *            要设置的 appealtypeid。
	 */
	public void setAppealtypeid(String appealtypeid) {
		this.appealtypeid = appealtypeid;
	}

	/**
	 * @param citycode
	 *            要设置的 citycode。
	 */
	public void setCitycode(String citycode) {
		this.citycode = citycode;
	}

	/**
	 * @param createtime
	 *            要设置的 createtime。
	 */
	public void setCreatetime(String createtime) {
		this.createtime = createtime;
	}

	/**
	 * @param email
	 *            要设置的 email。
	 */
	public void setEmail(String email) {
		this.email = email;
	}

	/**
	 * @param failuretel
	 *            要设置的 failuretel。
	 */
	public void setFailuretel(String failuretel) {
		this.failuretel = failuretel;
	}

	/**
	 * @param importancedegree
	 *            要设置的 importancedegree。
	 */
	public void setImportancedegree(String importancedegree) {
		this.importancedegree = importancedegree;
	}

	/**
	 * @param otherorder
	 *            要设置的 otherorder。
	 */
	public void setOtherorder(String otherorder) {
		this.otherorder = otherorder;
	}

	/**
	 * @param progressstate
	 *            要设置的 progressstate。
	 */
	public void setProgressstate(String progressstate) {
		this.progressstate = progressstate;
	}

	/**
	 * @param relationtel
	 *            要设置的 relationtel。
	 */
	public void setRelationtel(String relationtel) {
		this.relationtel = relationtel;
	}

	/**
	 * @param requresttime
	 *            要设置的 requresttime。
	 */
	public void setRequresttime(String requresttime) {
		this.requresttime = requresttime;
	}

	/**
	 * @param sex
	 *            要设置的 sex。
	 */
	public void setSex(String sex) {
		this.sex = sex;
	}

	/**
	 * @param userid
	 *            要设置的 userid。
	 */
	public void setUserid(String userid) {
		this.userid = userid;
	}

	/**
	 * @param pageSize
	 *            要设置的 pageSize。
	 */
	public void setPageSize(int pageSize) {
		this.pageSize = pageSize;
	}

	public String getUpappealid() {
		return upappealid;
	}

	public void setUpappealid(String upappealid) {
		this.upappealid = upappealid;
	}

	public String getLOCKSTAFFID() {
		return LOCKSTAFFID;
	}

	public void setLOCKSTAFFID(String lockstaffid) {
		LOCKSTAFFID = lockstaffid;
	}

	public String getOutdate() {
		return outdate;
	}

	public void setOutdate(String outdate) {
		this.outdate = outdate;
	}

	public String getAppealid() {
		return appealid;
	}

	public String getAccountno() {
		return accountno;
	}

	public String getAppeacontent() {
		return appeacontent;
	}

	public String getAppealmode() {
		return appealmode;
	}

	public String getAppealtitle() {
		return appealtitle;
	}

	public String getAppealtypeid() {
		return appealtypeid;
	}

	public String getCitycode() {
		return citycode;
	}

	public String getCreatetime() {
		return createtime;
	}

	public String getEmail() {
		return email;
	}

	public String getFailuretel() {
		return failuretel;
	}

	public String getImportancedegree() {
		return importancedegree;
	}

	public String getOtherorder() {
		return otherorder;
	}

	public String getProgressstate() {
		return progressstate;
	}

	public String getRelationtel() {
		return relationtel;
	}

	public String getRequresttime() {
		return requresttime;
	}

	public String getSex() {
		return sex;
	}

	public String getUserid() {
		return userid;
	}

	public String getCUSTTYPE() {
		return CUSTTYPE;
	}

	public void setCUSTTYPE(String custtype) {
		CUSTTYPE = custtype;
	}

	public String getWEBORDER() {
		return WEBORDER;
	}

	public void setWEBORDER(String weborder) {
		WEBORDER = weborder;
	}

	public String getAPPEALORDERNUM() {
		return APPEALORDERNUM;
	}

	public void setAPPEALORDERNUM(String appealordernum) {
		APPEALORDERNUM = appealordernum;
	}

}