Private Sub startserver() bstop = False Dim OrderForm, ddh, matnrh As String Dim MyLocalDataReader As SqlDataReader Dim MyprdDataReader As SqlDataReader Dim mykc As SqlDataReader Dim kcsl, prdsl, tempsl As Long Dim flag As Boolean = False Dim mat As String Dim vrm As Long While Not bstop Try SqlCMDtemp.CommandText = "delete from tb_ty_cctemp" SqlCMDtemp.Connection = SqlConnection_local SqlCMDtemp.ExecuteNonQuery() If SqlCMDtemp.ExecuteNonQuery() = 0 Then mythread.Sleep(180000) End If End While mythread.Sleep(180000) Catch ex As Exception bstop = True End Try End While End Sub Private Sub stopserver() Dim i As Integer = 0 bstop = True Try SqlConnection_local.Close() SCMlocal.CommandText = "insert into MyServiceLog(vc_status,dt_created) values('服務關閉',getdate())" SqlConnection_local.Open() SCMlocal.Connection = SqlConnection_local i = SCMlocal.ExecuteNonQuery Catch ex As Exception bstop = True End Try End Sub Protected Overrides Sub OnStart(ByVal args() As String) ' 在此處添加啟動服務的代碼。此方法應設置具體的操作 ' 以便服務可以執行它的工作。 Dim i As Integer Try SqlConnection_local.Close() SCMlocal.CommandText = "" SCMlocal.CommandText = "insert into MyServiceLog(vc_status,dt_created) values('服務啟動',getdate())" SqlConnection_local.Open() SCMlocal.Connection = SqlConnection_local i = SCMlocal.ExecuteNonQuery Catch ex As Exception bstop = True End Try mythread = New Thread(AddressOf startserver) mythread.Start() End Sub Protected Overrides Sub OnPause() mythread.Suspend() End Sub Protected Overrides Sub OnContinue() mythread.Resume() End Sub Protected Overrides Sub OnStop() ' 在此處添加代碼以執行停止服務所需的關閉操作。 Me.stopserver() End SubEnd Class假如需要把服務時間寫入windows事件日志,以下的代碼片斷使用eventlog對象把一個項放入application日志中:dim log as new eventlog("application")log.source="program name"log.writeentry("message to place into the event log")log.close添加安裝在設計視圖右擊,選擇添加安裝程序并進行相應的設置使用installutil程序進行安裝