'*****************************************************************************************************
'//开始日期：2002年5月21日
'//结束日期：2002年5月
'*****************************************************************************************************
Option Explicit On
'Option Strict On
'//***************************************************************************************************
Imports System.Data.SqlClient
'//***************************************************************************************************
'//Begin defined namespace
'//Begin defined Class
Namespace Sunerp.CommClass.UserLogin
Public Class ActiveDsLogin
'//Defined Function LoginActiveDs
'//Function descriptoin
'//本函数以用户提供的证书验证用户，使用 LDAP 传输用户的证书，
'//使用 ActiveDs 对象的IADsOpenDSObject和 IADs 接口连接Active Directory，
'//使用参数ActiveDs.__MIDL___MIDL_itf_ads_0000_0018.ADS_SECURE_AUTHENTICATION
'//强制使用证书绑定用户。
'//本函数没有参数,用类ActiveDsLogin的属性ADserverName（主域控制器名），ADUserName（用户名）,
'//ADUserPWD（用户密码），ADUserDeptVal（用户所在组织结构）传值
'//Begin define function LoginActiveDs
Public Function LoginActiveDs() As Boolean
' Opens an Active Directory object
' Using specific credentials.
'定义 LDAP 绑定字符串，调用函数ParseDomainName(DomainName)解析域名
Dim strLDAP As String
strLDAP = "LDAP://" & ExchangeServerName & "/" & _
"cn=" & AccountNameVal & ",ou=" & ActiveDsOrganizationUnitNameVal & _
"," & ParseDomainName(DomainName)
Dim dso As ActiveDs.IADsOpenDSObject
Dim sobj As ActiveDs.IADs
Try
dso = GetObject("LDAP:")
sobj = dso.OpenDSObject(strLDAP, _
AccountNameVal, AccountPassword, _
ActiveDs.__MIDL___MIDL_itf_ads_0000_0018.ADS_SECURE_AUTHENTICATION)
sobj = Nothing
dso = Nothing
LoginActiveDs = True
State = True
Catch
' MsgBox("用户名或密码错误，请重新输入。")
LoginActiveDs = False
State = False
End Try
End Function
'//End define function LoginActiveDs
''//私有的解析域名函数 ParseDomainName
''//根域名 如:com net 等
''//主域域控制器名 如:sunrise Microsoft 等
''//子域名 如:msdn 等 (msdn.microsoft.com)
''//本函数有1个参数，为域名字符串，此处为 DomainName 属性的值
''//返回 LDAP 字符串 如 "DC=sunrise,DC=com"
Private Function ParseDomainName(ByVal IDomainName As String) As String
'解析域名
' DomainName 域名属性
Dim domainDC As String
Dim domTokens 'As String
domTokens = Split(Trim(IDomainName), ".", -1, 1)
domainDC = Join(domTokens, ",DC=")
domainDC = "DC=" & domainDC
ParseDomainName = domainDC
End Function
''定义类UserMailService的属性ExchangeServerName（Exchange DNS服务器名）
Private ExchangeServerNameVal As String
Public Property ExchangeServerName() As String
Get '''<WebMethod(EnableSession:=True)>
Return ExchangeServerNameVal ' Same As Prop1 = PropVal
End Get
Set(ByVal Value As String)
ExchangeServerNameVal = Trim(Value)
End Set
End Property
''定义类UserMailService的属性DomainName（DNS主域名）
Private DomainNameVal As String
Public Property DomainName() As String
Get
Return DomainNameVal ' Same As Prop1 = PropVal
End Get
Set(ByVal Value As String)
DomainNameVal = Trim(Value)
End Set
End Property
''定义类UserMailService的属性ExchangeFirstOrganizationName（Exchange邮件存储系统组织名）
Private ExchangeFirstOrganizationNameVal As String
Public Property ExchangeFirstOrganizationName() As String
Get
Return ExchangeFirstOrganizationNameVal
End Get
Set(ByVal Value As String)
ExchangeFirstOrganizationNameVal = Trim(Value)
End Set
End Property
''定义类UserMailService的属性ADUserDept（用户所在组织单元OU）
Private ActiveDsOrganizationUnitNameVal As String
Public Property ActiveDsOrganizationUnitName() As String
Get
Return ActiveDsOrganizationUnitNameVal
End Get
Set(ByVal Value As String)
ActiveDsOrganizationUnitNameVal = Trim(Value)
End Set
End Property
''定义类UserMailService的属性UserGroupName（用户所加入的组）
Private UserGroupNameVal As String
Public Property UserGroupName() As String
Get
Return UserGroupNameVal
End Get
Set(ByVal Value As String)
UserGroupNameVal = Trim(Value)
End Set
End Property
''定义类UserMailService的属性AccountName（用户账户名）
Private AccountNameVal As String
Public Property AccountName() As String
Get
Return AccountNameVal
End Get
Set(ByVal Value As String)
AccountNameVal = Trim(Value)
End Set
End Property
''定义类UserMailService的属性AccountPassword（用户密码）
Private AccountPasswordVal As String
Public Property AccountPassword() As String
Get
Return AccountPasswordVal
End Get
Set(ByVal Value As String)
AccountPasswordVal = Trim(Value)
End Set
End Property
''定义类UserMailService的属性UserFirstName（用户姓氏）
Private UserFirstNameVal As String
Public Property UserFirstName() As String
Get
Return UserFirstNameVal
End Get
Set(ByVal Value As String)
UserFirstNameVal = Trim(Value)
End Set
End Property
''定义类UserMailService的属性UserLastName（用户名字）
Private UserLastNameVal As String
Public Property UserLastName() As String
Get
Return UserLastNameVal
End Get
Set(ByVal Value As String)
UserLastNameVal = Trim(Value)
End Set
End Property
''定义类UserMailService的属性UserMailBoxName（用邮箱名）
Private UserMailBoxNameVal As String
Public Property UserMailBoxName() As String
Get
Return UserMailBoxNameVal
End Get
Set(ByVal Value As String)
UserMailBoxNameVal = Trim(Value)
End Set
End Property
''定义类UserMailService的ReadOnly属性State（创建连接的状态）
''True(创建成功），False（创建失败）
Private StateVal As Boolean
Public Property State() As Boolean
Get
Return StateVal
End Get
Set(ByVal Value As Boolean)
StateVal = Value
End Set
End Property
End Class
Public Class DBaseLogin
'//Defined Function LoginDBase
'//Function descriptoin
'//本函数获取数据表中的当前登录的用户的信息，使用DataSet绑定数据库和007user表,
'//本函数有2个参数，ILinkedSqlServer为公共函数LinkedSqlServer的返回值SqlConnection，
'// IPublicApplication为公共数据结构PublicApplicationVal
'//本函数返回查询到的 DataSet，包含字段所有字段
'//Begin define function LoginDBase
Public Function LoginDBase(ByVal ILinkedSqlServer As SqlConnection, _
ByVal IPublicApplication As Comm.PublicApplicationVal) As DataSet
Dim strSql As String
Dim objDA As SqlDataAdapter
Dim objDS As New DataSet()
''//查询条件是字符型字段
strSql = "select * from " & IPublicApplication.DBTable & _
" WHERE " & IPublicApplication.QueryFieldName & _
"='" & IPublicApplication.QueryFieldVale & "'"
objDA = New SqlDataAdapter(strSql, ILinkedSqlServer)
objDA.Fill(objDS, "'" & IPublicApplication.DBTable & "'")
objDA = Nothing
LoginDBase = objDS
End Function
'//End define function LoginDBase
End Class
End Namespace
