以文本方式查看主题

-  Foxtable(狐表)  (http://www.foxtable.com/bbs/index.asp)
--  专家坐堂  (http://www.foxtable.com/bbs/list.asp?boardid=2)
----  [求助]AfterOpenProject事件  (http://www.foxtable.com/bbs/dispbbs.asp?boardid=2&id=117776)

--  作者:liuyixin662
--  发布时间:2018/4/19 9:06:00
--  [求助]AfterOpenProject事件
老师你好,AfterOpenProject事件代码,登录日志出现重复的行,麻烦老师看一下代码,谢谢!
 下载信息  [文件大小:   下载次数: ]
图片点击可在新窗口打开查看点击浏览该文件:afteropenproject事件,登录日志重复行.txt


图片点击可在新窗口打开查看此主题相关图片如下:登录日志行重复.bmp
图片点击可在新窗口打开查看

--  作者:有点甜
--  发布时间:2018/4/19 9:20:00
--  

 

[此贴子已经被作者于2018/4/19 9:22:08编辑过]

--  作者:有点甜
--  发布时间:2018/4/19 9:23:00
--  

Dim IPAdress As System.Net.IPAddress
Dim HostName As String
HostName = System.Net.Dns.GetHostName \'获得本机的机器名
Dim l As Integer = System.Net.Dns.GetHostByName(HostName).AddressList.Length
Dim s As String = ""
Dim s1 As String = ""
For i As Integer=0 To l-1
    IPAdress = System.Net.Dns.GetHostByName(HostName).AddressList.getValue(i) \'获得本机的IP
    s &= IPAdress.Tostring & " | "
Next
Dim query As System.Management.ManagementObjectSearcher = New System.Management.ManagementObjectSearcher("SELECT * FROM Win32_NetworkAdapterConfiguration")
Dim queryCollection As System.Management.ManagementObjectCollection = query.Get()
Dim mo As New System.Management.ManagementObject
For Each mo In queryCollection
    If IsDBNull(mo.Item("macaddress")) = False Then
        If mo.Item("macaddress") <> "" AndAlso mo.Item("IPEnabled") Then
            s1 & =  mo.Item("macaddress") & " | "
        End If
    End If
Next

Dim dr As  DataRow
dr=DataTables("登录日志").AddNew
dr("用户名")= User.Name
dr("计算机名")= HostName
dr("登录时间")= Date.now
dr("ip")= s.trim("|")
dr("MAC")= s1.trim(",")
DataTables("登录日志").save


--  作者:liuyixin662
--  发布时间:2018/4/19 9:57:00
--  
谢谢老师