求来电显示并能调用库的程序

[tianhe2006]

我正在开发一个客户接待系统，不知道该怎样通过model来显示电话号码。另外还要实现调用数据库中预存的信息。希望高手指点，如有整套程序代码则更好。
我的mail: [e-mail]

[vansoft]

購買還索取？

[zjn12]

说的不是很清楚,最好描述清楚点,帮你顶

[带着蜗牛去散步^]

来电话的时候用at指令 可以从串口 读取相应的电话
然后 查数据库
什么功能都有了

[enjoy21cn]

上面的兄弟那个数据库是那个的呢？是不是要自己建一个呢！

[bluesen]

看看我们的平台，完全免费，除了支持TAPI3的语音modem外，还支持各种语音卡，免费下载地址是：
http://www.bluespace.com.cn/koodoo/download_tapi3.htm

[bluesen]

来电显示和连数据库都是小case了，网站上很多例子。
http://www.bluespace.com.cn/koodoo/

[vansoft]

来电显示的实现
MODEM的AT命令CID和VCID是设置是不是来电显示的，如果电信开通了来电显示功能
就能通过MODEM来显示对方的电话号码。那么首先设置CID=1或是VCID=1
般来说来电显示的信息为：
DATE = MMDD "来电日期 MMDD
TIME = HHMM "来电时间 HHMM
NMBR = ######## "来电号码
程序实现如下,设置MSComm1的相关设置，并建两个Label为Label1和Label2
Function OpenCID(OpenCLose As Boolean) As Boolean
'打开或是关毕来电显示功能
On Error Resume Next
Dim ArrCID(1) As String
ArrCID(0) = "at#cid=" & IIf(openclode, 1, 0)
ArrCID(1) = "at#vcid=" & IIf(openclode, 1, 0)
MSComm1.RThreshold = 0
For i = 0 To 1
MSComm1.Output = ArrCID(i) & vbCr
EndTime = Timer + 0.5
Do While bStop = False
nTemp = nTemp + 1
If MSComm1.InBufferCount >= 2 Then
sTemp = MSComm1.Input
If InStr(sTemp, "OK") = 0 Then
bStop = True
OpenCID = True
Exit Function
End If
End If
If Timer >= EndTime Or ErrorCode Then Exit Do
Loop
Next i
OpenCID = False
MSComm1.RThreshold = 1
End Function
下面的函数显示来电号码并在窗体上的Label1的Label2上显示出来
Private Sub MSComm1_OnComm()
On Error Resume Next
Static Buffer As String
' 收到多于 RThreshold 属性设置的字符数（RThreshold 属性必须大于 0）。
'label1 = "收到" + Str(MSComm1.InBufferCount) + "个字符"
Buffer = Buffer + MSComm1.Input
Buffer = UCase(Buffer)
' Exit Sub
If InStr(1, Buffer, "RING", vbTextCompare) Then
'收到震铃
'Comm1.Output = "ATA" + Chr(13) '命令 Modem 摘机响应
Buffer = "" '清缓冲区字符
'mciExecute "sound " & SystemPath & "\ringin.wav"
Label1 = "状态：收到震铃"
Zhen = True
frmCallID.Show
frmCallID.ChangRing


ElseIf InStr(1, Buffer, "CONNECT", vbTextCompare) Then
'对方应答呼叫
Buffer = "" '清缓冲区字符
Label1 = "状态：已经建立连接"
ElseIf InStr(1, Buffer, "BUSY", vbTextCompare) Then
'对方线路忙
Buffer = "" '清缓冲区字符
Label1 = "状态：对方线路忙"
ElseIf InStr(1, Buffer, "No DIA", vbTextCompare) Then
Buffer = "" '清缓冲区字符
Label1 = "状态：拨出号码错,请检查电话线"
Command1_Click
ElseIf InStr(1, Buffer, "No CARRIER", vbTextCompare) Then
'对方未摘机或未响应
Buffer = "" '清缓冲区字符
Label1 = "状态：对方未摘机"

ElseIf InStr(1, Buffer, "NMBR =", vbTextCompare) Then
tmpStr = InStr(1, Buffer, "NMBR", vbTextCompare)
CallNum = Right(Buffer, Len(Buffer) - lll - 6)
Label2.Caption = "对方电话：" + CallNum
'Buffer = "" '清缓冲区字符
ElseIf InStr(1, Buffer, "OK", vbTextCompare) And Asc(Right(Buffer, 1)) = 10 Then
If Zhen = False Then Buffer = "" '清缓冲区字符
If Command1.Caption = "挂断" Then
Label2.Caption = "状态：已经播通电话：" + txtCallNum
End If
End If
End Sub
Option Explicit
Const DEBFLG = 1
Public COMX, BEEPNO, HANGUP, PNLOC As Integer
Public COMBUF, COMLIN As String
Dim h
Private Sub Command1_Click()

frmWelcome.Visible = False

End Sub

Private Sub Option1_Click(Index As Integer)
COMX = Index + 1
Call INIT_MODEM
End Sub
Private Sub Form_Load()

''''电话号码置空
PhoneNumber = "" ''''用来存放从猫中的电话号码
getNumber = "" ''''存放去掉区号后的号码


With MSComm1
.InBufferSize = 1024
.InputLen = 0
.InputMode = 0
.RThreshold = 1
.RTSEnable = True
.Settings = "9600,N,8,1"
.SThreshold = 0
End With


''''检测串行口
Dim I, C As Integer
COMX = 0
COMBUF = ""
COMLIN = ""
BEEPNO = 0
HANGUP = 0
On Error GoTo ERROR_FORM_LOAD
''''检测可用串口
For C = 1 To 4
If MSComm1.PortOpen Then MSComm1.PortOpen = False

MSComm1.CommPort = C
If Not MSComm1.PortOpen Then

MSComm1.PortOpen = True
End If
If MSComm1.PortOpen Then MSComm1.PortOpen = False

If COMX = 0 Then COMX = C

FORM_LOAD_1:
Next C
If COMX = 0 Then End
On Error GoTo 0
Option1(COMX - 1).Value = True
Exit Sub
ERROR_FORM_LOAD:
Option1(C - 1).Enabled = False
Resume FORM_LOAD_1
Exit Sub

Exit Sub
why:
MsgBox Err.Description
End Sub

''''检测串行口

''''检查Modem命令是否完成
Private Sub CHK_MODEM()
On Error GoTo why
Dim T As Single
Dim L As Integer
T = Timer
Do
COMBUF = COMBUF + MSComm1.Input
L = InStr(1, COMBUF, "OK")
Loop Until L <> 0 Or Timer - T > 1
If L = 0 Then

MsgBox "端口" & COMX & "上没有发现Modem,请选择别的端口试试.", vbOKOnly + vbCritical, "测试MODEM"
Else
MsgBox "来电显示已经启动,确定此按钮后,如果返回ok,说明计算机与Modem能正常通信，否则,请重试其它端口"
End If
Exit Sub
why: MsgBox Err.Description
End Sub
''''串行口接收事件处理
Private Sub MSComm1_OnComm()
Dim a
Dim b
On Error GoTo why
Dim inStrData As String, tm As String
Dim iPos As Integer
inStrData = MSComm1.Input & MSComm1.Input
iPos = InStr(inStrData, "NMBR=")
''''记录程序是否第一次打开，不是话下次就不显示猫的返回信息

If TimeOpen = 0 Then
MsgBox inStrData
TimeOpen = 54 ''''写成什么都可以，但0不可以,
MsgBox "恭喜!来电显示和Modem都已经成功设置." ''''成功了，哈哈，我有钱可以赚了
frmWelcome.Visible = False
Command2.Visible = False
End If
a = InStr(1, inStrData, "NMBR = ", vbTextCompare)
If a <> 0 Then
b = InStr(a, inStrData, vbCr, vbTextCompare)
PhoneNumber = Mid(inStrData, a + 7, b - a - 7)
frmReg.Show
Else:
End If
Exit Sub
why:
MsgBox Err.Description
End Sub
Private Sub INIT_MODEM()
On Error GoTo why
If MSComm1.PortOpen Then MSComm1.PortOpen = False
MSComm1.CommPort = COMX
If Not MSComm1.PortOpen Then MSComm1.PortOpen = True
MSComm1.Output = "AT+VCID=1" + vbCr
''''检查Modem命令是否完成
Call CHK_MODEM
MSComm1.Output = "ATS0=0" + vbCr
Exit Sub
why:
MsgBox Err.Description
End Sub

[lianghong]

收藏！

[fxy_2002]

记号

[缪军]

好！顶一下

[yuanzhihua520]

up

[pilicat]

好啊！

[adwance]

并不是所有的Modem 都能检测到来电的号码的。有的Modem在运营商提供的信号上根本就检测不到来电号码。如果是做着玩那就算了。如果打算赚钱，那建议用语言卡。

[bluesen]

就是啊。好猫不多见了。