prodorderrestoredao.java

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

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

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

/**
 * @author huzx
 *  
 */
public class ProdOrderRestoreDAO extends DAO {

	static FileLogger _logger = new FileLogger();
	
    private static DataTable _dataTable = null;
	private String prodorderrestore = "";	//受理单回复序号
	
	private String prodorderid = "";	 	//订单ID

	private String submittime = ""; 		//提交时间

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

	private String restoreman = ""; 		//回复人

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

	private String restoresource = "";
	/** 1、fj10000
		2、180
		3、112
		4、BSS
	*/

	public ProdOrderRestoreDAO() {
		FileLogger.getLogger().debug("ProdOrderRestoreDAO 数据库链接" + _dac);
	}
	
	/**
	 * 获取当前受理单的审核id
	 * @param id
	 */
    static public String getMainStoreId(String id){
		try{
			Object[] _object =new Object[1];
			_object[0] = id;
			String sql = "select PRODORDERRESTORE from Tf_ProdOrderRestore where PRODORDERID=to_number(?)";
			DataTable dataTable = _dac.executeQuery(sql,_object);
			if(dataTable != null && dataTable.getRows().getCount() > 0)
			{
				String upid = dataTable.getRow(0).getString("PRODORDERRESTORE");
				return upid;
			}
		}catch(Exception ex){
            _logger.warn(ex.getMessage(),ex);
		}
		return "";
	}
	
    /**
     * <code>
     *  获取用户的地市编码
     * </code>
     * @param prodorderid
     * @return
     */
    static public String getUserCityCode(String prodorderid){
        try{
            Object[] _object =new Object[1];
            _object[0] = prodorderid;
            String sql = "SELECT c.citycode FROM tf_prodorder t "+
                        "JOIN tf_custinfoweb c ON t.userid = c.userid "+
                        "WHERE t.prodorderid=?";
            _dataTable = _dac.executeQuery(sql,_object);
            if(_dataTable != null 
                    && _dataTable.getRows().getCount() > 0)
                return _dataTable.getRow(0).getString("citycode");
             
        }catch(Exception ex){
            _logger.warn(ex.getMessage(),ex);
        }
        return "0590";
    }

	public void insertProdOrderRestore() {
		String sql = "insert into Tf_ProdOrderRestore(PRODORDERRESTORE,prodorderid,submittime,restorecontent,"
				+ "restoreman,restoretime,restoresource) values(seq_PRODORDERRESTORE.Nextval,?,sysdate"
				+ ",?,?,to_date(?,'yyyy-MM-dd HH24:mi'),?)";
		
		Object[] value = new Object[5];
		value[0] = prodorderid;
		value[1] = restorecontent;
		value[2] = restoreman;
		value[3] = restoretime;
		value[4] = restoresource;
		FileLogger.getLogger().debug(" insertProdOrderRestore prodorderid == " + prodorderid );
		try {
			 _dac.executeUpdate(sql, 10000, value);

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

	}
	public DataTable getProdOrderRestoreInfo(String prodorderid){
		DataTable dataTable = null;
		Object[] value = new Object[1];
		value[0] = prodorderid;
		try {
			
			String sql = "select * from "+
			"(select PRODORDERRESTORE,SUBMITTIME,PRODORDERID, "+
			"RESTORECONTENT,RESTOREMAN,RESTORETIME "+
			"from tf_prodorderrestore c  "+
			"where c.prodorderid=? "+
			"order by c.submittime desc) "+
			"where rownum = 1";
			
			dataTable = _dac.executeQuery(sql,value);
			
		} catch (Exception e) {
			FileLogger.getLogger().error(e.getMessage());
		}
		return dataTable;
	}
	
	public void updateProdOrderRestore() {
		String sql = "update tf_prodorderrestore set RESTORETIME =to_date(?,'yyyy-MM-dd HH24:mi'),"
				+ "RESTORECONTENT = ?,"
				+ "RESTOREMAN = ?, submittime=sysdate,"
				+ "restoresource = ? " + " where PRODORDERRESTORE= ?";

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

		} catch (Exception e) {
			FileLogger.getLogger().error(e.getMessage());
		}
	}
	
	
	/**
	 * @param prodorderid
	 *            要设置的 prodorderid。
	 */
	public void setProdorderid(String prodorderid) {
		this.prodorderid = prodorderid;
	}

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

	/**
	 * @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;
	}

	/**
	 * @param submittime
	 *            要设置的 submittime。
	 */
	public void setSubmittime(String submittime) {
		this.submittime = submittime;
	}
	/**
	 * @param prodorderrestore 要设置的 prodorderrestore。
	 */
	public void setProdorderrestore(String prodorderrestore) {
		this.prodorderrestore = prodorderrestore;
	}
}