phonenummardao.java

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

package com.doone.fj1w.fjmgr.order;

import java.sql.SQLException;

import com.doone.data.DacClient;
import com.doone.data.DataTable;
import com.doone.iossp.EMessage;
import com.doone.util.FileLogger;

/**
 * 处理预选号的一些操作。
 * @author bellone
 *
 */
public class PhoneNumMarDAO {
    private DacClient _dac = null;
    private DataTable _dataTable = null;
    private int time = 1000;
    public PhoneNumMarDAO() {
        try {
            _dac = new DacClient();
            FileLogger.getLogger().debug("PhoneNumDAO数据库链接：" + _dac);
        } catch (Exception ex) {
            FileLogger.getLogger().debug("PhoneNumDAO数据库链接出错：" +
                                         ex.getMessage());
        }

    }
    
    /**
     * 检查某个工单，是否有预占某个号码。
     * @param id
     * @return
     */
	   public DataTable CheckIsPhoneNumOrder(String id){ 
	    	DataTable dt = null;
	    	Object[] values = null;
	        String Sql_ProdFunOrder = null;
	            values = new Object[1];
	            values[0] = id;
	            Sql_ProdFunOrder = "select * from tf_phonenum where prodorderid=?";
	            
	            try {
	            	dt = _dac.executeQuery(Sql_ProdFunOrder, values);
	            	
	            } catch (Exception ex) {
	                FileLogger.getLogger().debug("CheckIsPhoneNumOrder ：" +ex.getMessage());
	            }
	    	return dt;
	    }
	   
	   /**
	    * 撤消预选号
	    */
	   public int RepealPhoneNum(String id) {

			   /**
			    * 更新预占状态.说明受理成功。
			    */
		        String Sql_Ins_Trad =
		                "update tf_phonenum set state='1',preengagetime=null,accepttime=null,prodorderid=null where prodorderid=?";

		        Object[] value = new Object[1];
		        value[0] = id;
		        int doExp = 0;
		        //String twoXml = null;
		        try {
		            _dac.beginTransaction(1000);
		            doExp = _dac.executeUpdate(Sql_Ins_Trad, time, value);
		           /* twoXml = new Integer(doExp).toString();
		            EMessage ems = new EMessage();
		            ems.setBody(twoXml);
		            twoXml = ems.getXmlMsg();*/
		            _dac.endTransaction(true);
		            
		        } catch (Exception ex) {
		            try {
		                _dac.endTransaction(false);
		            } catch (SQLException ex2) {
		                FileLogger.getLogger().debug("撤消占用某个选中的号码(DAO)" +
		                                             ex);
		            }
		            FileLogger.getLogger().debug("撤消占用某个选中的号码(DAO)" +
		                                         ex);
		        }
		        return doExp;
		 }

}