Dim cmdExe As New ADODB.Command
Dim nowEv As Double
Dim sqlAdd As String
If Trim(txtUserName(0).Text) = "" Then
MsgBox " 没有要抄表用户，请先添加用户！ ", vbInformation
Exit Sub
End If
If Trim(txtUserName(9).Text) = "" Then
MsgBox " 请先输入数据！ ", vbInformation
Exit Sub
End If
If Trim(txtUserName(9).Text) < Trim(txtUserName(2).Text) Then
MsgBox " 输入数据错误，当前止码太小！ ", vbInformation
Exit Sub
End If
cnn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Jet OLEDB:database password= " & DbPassword & " ;Data Source= " & _
App.Path & "\data\dbdb.mdb;Persist Security Info=False"
cnn.CursorLocation = adUseClient
cnn.Open
cmdExe.ActiveConnection = cnn
rstE.Open "select nowecount from panelinfo where holderID= '" & Trim(txtUserName(0)) & "'", cnn, adOpenStatic, adLockBatchOptimistic
nowEv = Val(rstE.Fields(0).Value) + (Val(txtUserName(9)) - Val(txtUserName(2)))
sqlAdd = "update panelinfo set LEndPCode=" & Val(txtUserName(2).Text) & ",cEndCode=" & Val(txtUserName(9).Text) & ",nowEcount=" & nowEv & " ,writedate=#" & dtpwdate(1) & "# where holderID= '" & Trim(txtUserName(0)) & "'"
cmdExe.CommandText = sqlAdd
cmdExe.Execute sqlAdd
' cnn.Execute sqlAdd
txtUserName(2).Text = txtUserName(9)
txtUserName(9) = ""
cnn.Close
MsgBox " 数据保存完成！ ", vbInformation
Unload Me
End Sub
Private Sub Form_Load()
Dim rst As New ADODB.Recordset
Dim sqlEdit As String
dtpwdate(1).Value = Format(Now, "yyyy-mm-dd")
sqlEdit = "select * from panelinfo "
sqlEdit = sqlEdit & " where holderid='" & Trim(MDIme.txtUserName(0)) & "'and delflag<>true"
rst.Open sqlEdit, gCnn, adOpenStatic, adLockBatchOptimistic
If Not rst.EOF Then
txtUserName(0) = rst.Fields(1)
txtUserName(1) = rst.Fields(2)
txtUserName(2) = rst.Fields!cendcode
dtpwdate(0).Value = rst.Fields(4)
End If
buttontime = False
End Sub
Private Sub Form_Unload(Cancel As Integer)
MDIme.loadData (txtUserName(0))
Cancel = 0
End Sub
Private Sub nextuser_Click()
Dim rst As New ADODB.Recordset
Dim sqlEdit As String
sqlEdit = "select * from panelinfo "
sqlEdit = sqlEdit & " wher