appealrestoredao.java

来自「电信的网厅的整站代码」· Java 代码 · 共 211 行

/*
 * 创建日期 2005-7-23
 *
 */
package com.doone.fj1w.fjmgr.order;

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

/**
 */
public class AppealrestoreDAO extends DAO {
	/** 故障投诉建议回复序号 * */
	private String restoreid = "";

	/** 故障投诉建议序号 * */
	private String appealid = "";

	/** 回复内容* */
	private String restorecontent = "";

	/** 回复员* */
	private String restoreman = "";

	/** 回复员* */
	private String restoresource = "";

	/** 回复时间* */
	private String restoretime = "";

	/** 责任人* */
	private String burdenman = "";

	/** 责任人联系电话* */
	private String burdentel = "";

	/** 备注* */
	private String describe = "";

	public AppealrestoreDAO() {
		FileLogger.getLogger().debug("AppealrestoreDAO 数据库链接" + _dac);
	}

	/**
	 * 获取原受理单的审核id
	 * @param id
	 */
    public String getMainStoreId(String id){
		try{
			Object[] _object =new Object[1];
			_object[0] = id;
			String sql = "select RESTOREID from tf_appealrestore where APPEALID=to_number(?)";
			DataTable dataTable = _dac.executeQuery(sql,_object);
			if(dataTable != null && dataTable.getRows().getCount() > 0)
			{
				String upid = dataTable.getRow(0).getString("RESTOREID");
				return upid;
			}
		}catch(Exception ex){
			FileLogger.getLogger().warn(ex.getMessage(),ex);
		}
		return "";
	}
    
	public void insertAppealRestore() {
		String sql = "insert into tf_appealrestore(RESTOREID,APPEALID,RESTORETIME,RESTORECONTENT,"
				+ "RESTOREMAN,restoresource) values(seq_restoreid.nextval,?,sysdate"
				+ ",?,?,?)";

		if(restorecontent == null || restorecontent.equals(""))
			restorecontent = " ";
		Object[] value = new Object[4];
		value[0] = appealid;
		value[1] = restorecontent;
		value[2] = restoreman;
		value[3] = restoresource;
		FileLogger.getLogger().debug(
				" insertAppealRestore restoreid == " + restoreid);
		try {
			_dac.executeUpdate(sql, 10000, value);

		} catch (Exception e) {
			FileLogger.getLogger().error(e.getMessage());
		}

	}

	public void updateAppealRestore() {
		String sql = "update tf_appealrestore set "
				+ "RESTORECONTENT = ?,"
				+ "RESTOREMAN = ?,"
				+ "restoresource = ? " + " where restoreid= ?";

		Object[] value = new Object[4];
		value[0] = restorecontent;
		value[1] = restoreman;
		value[2] = restoresource;
		value[3] = restoreid;
		FileLogger.getLogger().debug(
				" updateAppealRestore restoreid == " + restoreid);
		try {
			_dac.executeUpdate(sql, 10000, value);

		} catch (Exception e) {
			FileLogger.getLogger().error(e.getMessage());
		}
	}

	/**
	 * 	故障投诉回复信息
	 * @param restoreID		回复单ID
	 * @return
	 */
	public DataTable getAppealrestoreInfo(String appealid) {
		
		Object[] value = new Object[1];
		value[0] = appealid;
		try {
			
			String sql1 = "select * from "+
						"(select restoreid,APPEALID,RESTORECONTENT, "+
						"RESTOREMAN,RESTORESOURCE, "+
						"to_char(RESTORETIME,'yyyy-MM-dd')RESTORETIME "+
						"from tf_appealrestore c "+ 
						"where c.appealid=? "+
						"order by c.RESTORETIME desc) "+
						"where rownum = 1";
			
		   return  _dac.executeQuery(sql1,value);
			
		} catch (Exception e) {
			FileLogger.getLogger().error(e.getMessage());
		}
		
		return null;
	}



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

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

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

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

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

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

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

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

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