Com+高手请进

2005-03-05 01:52:09 162 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

COM组件开发（二）——COM应用模型及COM库 C/S模型 COM对象与客户程序之间是基于C/S（客户端/服务器）的模型在运行的，COM服务器是组件对象的容器，由组件对象向COM客户提供服务，所以COM的应用模型继承了C/S模型的优点：高可靠与稳定性、很强的拓展性并且性能高等。包容与聚合 COM不是简单的C/S模型，有时客户可以反过来提供服务，COM对象提供服务的同时也可以向其他组件寻求服务，所以阅读详情

我用RegSvcs注册Com+时出现以下错误:
Warning:the class ‘SampleOrderCom.RuleAutoGen’ has no class interface,which means that unmanaged late bound calls cannot take advantage of AutoComplete methods,

RuleAutoGen类的代码如下:

Imports System.EnterpriseServices
Imports System.Data.SqlClient

<Transaction(TransactionOption.Required)> Public Class RuleAutoGen
Inherits ServicedComponent

Private Conn As SqlConnection
Private Cmd As SqlCommand
Private myReader As SqlDataReader
Private variable_value As String
Private running_num As Int32
Private new_running_num As Integer
Private autoGenNum As String
Private years As String
Private YearReader As SqlDataReader
Private desc As String

<AutoComplete> Public Function updateNum(ByVal vVariable As String, _
ByVal vDepartment As String, ByVal vDivision As String, Optional ByVal vNum As Integer = 1) As String

autoGenNum = "-1"

Conn = Connection.ConnectionFactory()
Try
Dim sqlYears As String = "select substring(cast(year(getdate()) as varchar (4)),3,2) as years"

Dim CmdYears As New SqlCommand(sqlYears, Conn)

Dim sqlString As String = _
"SELECT variable_value, variable_running_num,description FROM m_system_variable" & _
" WHERE variable = @variable" & _
" AND department = @department" & _
" AND division = @division"
Cmd = New SqlCommand(sqlString, Conn)
'Cmd.ExecuteNonQuery()

Dim parmVariable As SqlParameter
parmVariable = Cmd.Parameters.Add("@variable", SqlDbType.Char, 25)
parmVariable.Direction = ParameterDirection.Input
parmVariable.Value = vVariable

Dim parmDepartment As SqlParameter
parmDepartment = Cmd.Parameters.Add("@department", SqlDbType.Char, 10)
parmDepartment.Direction = ParameterDirection.Input
parmDepartment.Value = vDepartment

Dim parmDivision As SqlParameter

parmDivision = Cmd.Parameters.Add("@division", SqlDbType.Char, 8)
parmDivision.Direction = ParameterDirection.Input
parmDivision.Value = vDivision

myReader = Cmd.ExecuteReader

If (myReader.Read()) Then
variable_value = myReader.GetString(0)
running_num = myReader.GetInt32(1)
desc = myReader.GetString(2)
End If
myReader.Close()

YearReader = CmdYears.ExecuteReader
If YearReader.Read() Then
years = YearReader.GetString(0)
End If
YearReader.Close()

Select Case running_num
Case 1 To 9
autoGenNum = variable_value & "-" & years & "-" & "000" & running_num
Case 10 To 99
autoGenNum = variable_value & "-" & years & "-" & "00" & running_num
Case 100 To 999
autoGenNum = variable_value & "-" & years & "-" & "0" & running_num
Case 1000 To 9999
autoGenNum = variable_value & "-" & years & "-" & running_num
Case Else
autoGenNum = "-1" 'Error No.
End Select

new_running_num = running_num + vNum

If new_running_num <= 10000 Then
sqlString = "UPDATE m_system_variable SET variable_running_num = " & _
"@running_num WHERE variable = @variable" & _
" AND department = @department" & _
" AND division = @division"
Cmd.CommandText = sqlString

Dim parmRunningNum As SqlParameter
parmRunningNum = Cmd.Parameters.Add("@running_num", SqlDbType.Int, 4)
parmRunningNum.Direction = ParameterDirection.Input
parmRunningNum.Value = new_running_num

Cmd.ExecuteNonQuery()
End If

Conn.Close()

Catch e As Exception
'Console.WriteLine(e)
Throw e

Finally
If Not (Conn Is Nothing) Then
Conn.Close()
End If
End Try

Return autoGenNum
End Function

End Class

我感觉就是因为用了<AutoComplete>这个我特性后出错,我应该怎么修改,谢谢!!!

...全文