package?call;
import?java.sql.*;
import?java.util.*;
import?DB.*;

public?class?calling{
	private?String?CphoneNo;//電話號(hào)碼?
	private?String?YWID;//YWID
	private?String?FYWID;
	private?String?CName;
	private?String?CPay;
	private?String?YWName;
	private?String?YWMemo;
	private?int?RNo;
	private?ResultSet?yewurs;//業(yè)務(wù)信息結(jié)果集來(lái)自yewu表
	private?ResultSet?kehurs;//客戶信息結(jié)果集來(lái)自kehu表
	private?ResultSet?callinfors;//外呼號(hào)碼結(jié)果集來(lái)自callinfo表
	private?DBConn?conn;
	
//---------------------用于在話務(wù)員頁(yè)面顯示-------------------------------------
	public?calling（）{//構(gòu)造函數(shù)，進(jìn)行初始化，呼叫過(guò)程開(kāi)始
		this.CphoneNo=““;
		this.YWID=““;
		conn?=?new?DBConn（）;
	}
	
	public?void?setYWID（String?YWID）{//得到Y(jié)WID（從session中得到）
		this.YWID=YWID;
	}

	public?String?getYWID（）{//返回YWID
		return?YWID;
	}

	public?String?getFYWID（）{
		return?FYWID;
	}

	public?synchronized?void?setCphoneNo（）?throws?SQLException{//得到電話號(hào)碼
		String?sql?=?“select?*?from?callinfo?where?issend=‘N‘?and?YWID=‘“+getYWID（）+“‘?order?by?CphoneNo“;
		callinfors?=?conn.executeQuery（sql）;//得到電話號(hào)碼信息（可優(yōu)化）
		if?（callinfors.next（））?{
			CphoneNo=callinfors.getString（“CphoneNo“）;
			RNo=callinfors.getInt（“RNo“）;
			FYWID=callinfors.getString（“FYWID“）;
		}
		sql?=?“update?callinfo?set?issend=‘Y‘?where?RNo=‘“+callinfors.getInt（“RNo“）+“‘“;
		conn.executeUpdate（sql）;//設(shè)置記錄的issend為N保證其不會(huì)再被分配（以后應(yīng)優(yōu)化為存儲(chǔ)過(guò)程）
	}

	public?synchronized?void?setCphoneNo（String?taixiIP）?throws?SQLException{//得到電話號(hào)碼
		String?sql?=?“select?*?from?callinfo?where?issend=‘N‘?and?YWID=‘“+getYWID（）+“‘?order?by?CphoneNo“;
		callinfors?=?conn.executeQuery（sql）;//得到電話號(hào)碼信息（可優(yōu)化）
		if?（callinfors.next（））?{
			CphoneNo=callinfors.getString（“CphoneNo“）;
			RNo=callinfors.getInt（“RNo“）;
			FYWID=callinfors.getString（“FYWID“）;
			sql?=?“update?taixi?set?CphoneNo=‘“+CphoneNo+“‘?where?taixiIP=‘“+taixiIP+“‘“;
			conn.executeUpdate（sql）;//設(shè)置臺(tái)席對(duì)應(yīng)的外呼號(hào)碼
		}
		sql?=?“update?callinfo?set?issend=‘Y‘?where?RNo=‘“+callinfors.getInt（“RNo“）+“‘“;
		conn.executeUpdate（sql）;//設(shè)置記錄的issend為N保證其不會(huì)再被分配（以后應(yīng)優(yōu)化為存儲(chǔ)過(guò)程）
	}

	public?void?setkehurs（）?throws?SQLException{//得到客戶信息
		//DBConn?kehuconn?=?new?DBConn（）;
		String?sql?=?“select?CphoneNoCNameCPayYWID?from?kehu?where?CphoneNo=‘“+?getCphoneNo（）+“‘?and?YWID=‘“+YWID+“‘“;
		kehurs?=?conn.executeQuery（sql）;//可優(yōu)化
		if?（kehurs.next（））{
			CName=kehurs.getString（“CName“）;
			CPay=kehurs.getString（“CPay“）;
		}
		//kehuconn.dropConnection（）;
	}
	
	public?int?getyewuonly（String?YWID）?throws?SQLException{//得到only信息
		int?jg=0;
		ResultSet?rs;
		String?sql?=?“select?only?from?yewu?where?YWID=‘“+YWID+“‘“;
		rs?=?conn.executeQuery（sql）;
		rs.next（）;
		jg=rs.getInt（“only“）;
		return?jg;
	}
	
	public?int?getwithmemo（String?YWID）?throws?SQLException{//得到only信息
		int?jg=0;
		ResultSet?rs;
		String?sql?=?“select?withmemo?from?yewu?where?YWID=‘“+YWID+“‘“;
		rs?=?conn.executeQuery（sql）;
		rs.next（）;
		jg=rs.getInt（“withmemo“）;
		return?jg;
	}

	public?void?setyewurs（）?throws?SQLException{//

?屬性????????????大小?????日期????時(shí)間???名稱
-----------?---------??----------?-----??----

?????文件???????2403??2008-09-20?01:36??huiyou\checkuser.jsp

?????文件????????480??2008-09-19?21:10??huiyou\content.jsp

?????文件??????63632??2007-11-13?08:45??huiyou\editor\backup_KindEditor.js

?????文件????????671??2007-11-13?08:45??huiyou\editor\icons\etc_01.gif

?????文件????????687??2007-11-13?08:45??huiyou\editor\icons\etc_02.gif

?????文件????????682??2007-11-13?08:45??huiyou\editor\icons\etc_03.gif

?????文件????????655??2007-11-13?08:45??huiyou\editor\icons\etc_04.gif

?????文件????????643??2007-11-13?08:45??huiyou\editor\icons\etc_05.gif

?????文件????????660??2007-11-13?08:45??huiyou\editor\icons\etc_06.gif

?????文件????????657??2007-11-13?08:45??huiyou\editor\icons\etc_07.gif

?????文件????????680??2007-11-13?08:45??huiyou\editor\icons\etc_08.gif

?????文件????????670??2007-11-13?08:45??huiyou\editor\icons\etc_09.gif

?????文件????????657??2007-11-13?08:45??huiyou\editor\icons\etc_10.gif

?????文件????????655??2007-11-13?08:45??huiyou\editor\icons\etc_11.gif

?????文件????????687??2007-11-13?08:45??huiyou\editor\icons\etc_12.gif

?????文件????????666??2007-11-13?08:45??huiyou\editor\icons\etc_13.gif

?????文件????????657??2007-11-13?08:45??huiyou\editor\icons\etc_14.gif

?????文件????????683??2007-11-13?08:45??huiyou\editor\icons\etc_15.gif

?????文件????????685??2007-11-13?08:45??huiyou\editor\icons\etc_16.gif

?????文件????????445??2007-11-13?08:45??huiyou\editor\icons\etc_17.gif

?????文件????????453??2007-11-13?08:45??huiyou\editor\icons\etc_18.gif

?????文件????????423??2007-11-13?08:45??huiyou\editor\icons\etc_19.gif

?????文件????????453??2007-11-13?08:45??huiyou\editor\icons\etc_20.gif

?????文件????????322??2007-11-13?08:45??huiyou\editor\icons\etc_21.gif

?????文件????????473??2007-11-13?08:45??huiyou\editor\icons\etc_22.gif

?????文件????????444??2007-11-13?08:45??huiyou\editor\icons\etc_23.gif

?????文件???????1077??2007-11-13?08:45??huiyou\editor\icons\etc_24.gif

?????文件???????1030??2007-11-13?08:45??huiyou\editor\icons\etc_25.gif

?????文件???????1012??2007-11-13?08:45??huiyou\editor\icons\etc_26.gif

?????文件????????978??2007-11-13?08:45??huiyou\editor\icons\etc_27.gif

............此處省略375個(gè)文件信息