VB电表管理信息系统 第16页

VB电表管理信息系统 第16页
 Else        MsgBox " 没有查询到数据!  ", vbInformation
  End If
  rst.Close
  Set rst = Nothing
End Sub

Private Sub dcNum_Click(Area As Integer)
  Dim rst As New ADODB.Recordset
   
    rst.Open " select * from panelinfo  where holderid='" & dcNum.Text & "'and delflag<>true ", gCnn, adOpenKeyset, adLockBatchOptimistic
   
    If Not rst.EOF Then
        dcvalue.Text = rst.Fields(2)
        txtUserName(0) = rst.Fields(1)
        txtUserName(1) = rst.Fields!nowecount
        txtUserName(2) = rst.Fields!cendcode
        dtpwdate.Value = rst.Fields(4)
        txtUserName(3) = Format(rst.Fields!lMoney, "###0.00")
        txtUserName(4) = Format(rst.Fields!bmoney, "###0.00")
        txtUserName(6) = Format(rst.Fields(8), "####0.00")
        txtUserName(5) = Format(txtUserName(1) * txtUserName(3) * (rst.Fields!lightScale / 100) + txtUserName(1) * txtUserName(4) * (1 - rst.Fields!lightScale / 100), "####0.00")
        txtUserName(8) = rst.Fields(9)
        txtUserName(7) = Format(Val(txtUserName(5)) + Val(txtUserName(6)), "####0.00")
  End If
  rst.Close
End Sub

Private Sub dcvalue_Click(Area As Integer)
     Dim rst As New ADODB.Recordset
   
      rst.Open " select * from panelinfo  where holderid='" & dcvalue.BoundText & "' and delflag<>true ", gCnn, adOpenStatic, adLockBatchOptimistic
 
    If Not rst.EOF Then
        dcvalue.Text = rst.Fields(2)
        txtUserName(0) = rst.Fields(1)
        txtUserName(1) = rst.Fields!nowecount
        txtUserName(2) = rst.Fields!cendcode
        dtpwdate.Value = rst.Fields(4)
        txtUserName(3) = Format(rst.Fields!lMoney, "###0.00")
        txtUserName(4) = Format(rst.Fields!bmoney, "###0.00")
        txtUserName(6) = Format(rst.Fields!lsFee, "###0.00")
        'txtUserName(5) = txtUserName(1) * rst.Fields!lMoney * (rst.Fields!lightScale / 100) + txtUserName(1) * txtUserName(4) * (1 - rst.Fields!lightScale / 100)
        txtUserName(5) = Format(txtUserName(1) * rst.Fields!lMoney * (rst.Fields!lightScale / 100) + rst.Fields!nowecount * rst.Fields!bmoney * (1 - rst.Fields!lightScale / 100), "###0.00")
       
        txtUserName(8) = rst.Fields(9)
        txtUserName(7) = Format(Val(txtUserName(5)) + Val(txtUserName(6)), "####0.00")
        dcNum.Text = rst.Fields(1)
  End If
  rst.Close
  Set rst = Nothing
End Sub

Private Sub dcvalue_KeyPress(KeyAscii As Integer)
KeyAscii = 0
End Sub

Private Sub del_Click()
frmdel.Show
End Sub

Private Sub dhcb_Click()
usrcopyP.Show
End Sub

Private Sub dhcp_Click()
frmCopyP.Show
End Sub
Private Sub duohu_Click()
frmCuifei.muser1 = 2
frmCuifei.Show
End Sub
Private Sub edit_Click()
frmEdit.Show
End Sub
Private Sub exit_Click()
End
End Sub
Private Sub insert_Click()
frmInsert.Show 1
End Sub
Private Sub jiaonadianfei_Click()
frmFee.Show
End Sub
Private Sub M_USERYTPE_Click()
FRMUSERTYPE.Show 1
End Sub
Private Sub MDIForm_Load()   
    loadAdd  
End Sub
Public Sub loadAdd()
If rst.State = 1 Then
    rst.Close
End If
 rst.Open " select * from panelinfo where delflag<>true ", gCnn, adOpenKeyset, adLockBatchOptimistic

 << 上一页  [11] [12] [13] [14] [15] [16] [17] [18] [19] [20] 下一页

VB电表管理信息系统 第16页下载如图片无法显示或论文不完整，请联系qq752018766