frmouth1.frm

一个vb开发的会员制商场管理系统 数据库要求：SQL Server 2000 系统要求：Windows操作系统； 安装程序以前

            End If
        ElseIf Option1(1).Value = False And Option1(0).Value = True Then
            txtSQL = "select lbcode,total_je  from dm_kh where dm = '" & Trim(Combo1(1).ItemData(Combo1(1).ListIndex)) & "'"
            Set mrcc = ExecuteSQL(txtSQL, MsgText)
                        
            If Not mrcc.EOF Then
                If mrcc.Fields(1) = 0 Then
                    txtItem(12) = "基本团体会员"
                    txtItem(13) = 0
                    txtItem(6) = 100
                Else
                    txtItem(13) = mrcc.Fields(1)
                    
                    txtSQL = "select lbcode,lb,least_je,mb_reb from dm_khlb where bz = '1' order by least_je "
                    Set mrcd = ExecuteSQL(txtSQL, MsgText)
                    
                    If Not mrcd.EOF Then
                        Do While Not mrcd.EOF
                            If mrcc.Fields(1) < mrcd.Fields(2) Then
                                mrcd.MovePrevious
                                txtItem(12) = mrcd.Fields(1)
                                txtItem(6) = mrcd.Fields(3)
                                
                                Exit Do
                            Else
                                mrcd.MoveNext
                            End If
                        Loop
                        
                        mrcd.Close
                    End If
                        
                        
                End If
                
                mrcc.Close
            End If
        
        End If
            

    ElseIf Index = 2 Then
                txtSQL = "select kucun.wzdm,kucun.cxend,dm_wz.lsj  from kucun inner join  dm_wz on kucun.wzdm = dm_wz.dm  where kucun.wzdm = '" & Trim(Combo1(2).ItemData(Combo1(2).ListIndex)) & "'"
                Set mrcc = ExecuteSQL(txtSQL, MsgText)
                            
                If Not mrcc.EOF Then
                    txtItem(3) = mrcc.Fields(0)
                    txtItem(11) = mrcc.Fields(1)
                    txtItem(5) = mrcc.Fields(2)
                End If
                
                mrcc.Close
    ElseIf Index = 4 Then
            txtItem(10) = Combo1(4).ItemData(Combo1(4).ListIndex)
            
            Combo1(2).Clear
            
            txtSQL = "select dm_wz.dm,dm_wz.mc  from kucun inner join dm_wz on kucun.wzdm = dm_wz.dm where kucun.ckdm = '" & Trim(txtItem(10)) & "'"
            Set mrcc = ExecuteSQL(txtSQL, MsgText)
            
            If Not mrcc.EOF Then
                Do While Not mrcc.EOF
                    Combo1(2).AddItem mrcc.Fields(1)
                    Combo1(2).ItemData(Combo1(2).NewIndex) = mrcc.Fields(0)
                    
                    mrcc.MoveNext
                Loop
                mrcc.Close
            End If
                    
                
            
    ElseIf Index = 5 Then
        If Combo1(5).ListIndex = 0 Or Combo1(5).ListIndex = 1 Then
            txtItem(8).Visible = False
            Label2(13).Visible = False
        Else
            txtItem(8).Visible = True
            Label2(13).Visible = True

        End If
    End If

End Sub

Private Sub Form_Load()
    Dim intCount As Integer
    Dim MsgText As String
    Dim i As Integer
    Dim mrcc As ADODB.Recordset
    
    
    Combo1(5).AddItem "即使付清"
    Combo1(5).ItemData(Combo1(5).NewIndex) = 0
    Combo1(5).AddItem "记    账"
    Combo1(5).ItemData(Combo1(5).NewIndex) = 1
    Combo1(5).AddItem "预    付"
    Combo1(5).ItemData(Combo1(5).NewIndex) = 2
    
    txtItem(8).Visible = False
    Label2(13).Visible = False
    
    
    'Option1 (0)


  
    If gintOUTHmode = 1 Then
        Me.Caption = Me.Caption & "添加"
        For i = 0 To 10
            txtItem(i).Text = ""
        Next i
        
        For i = 0 To 2
            Combo1(i).Clear
        Next i
        
        For i = 4 To 4
            Combo1(i).Clear
        Next i
        
        Option1(1) = vbChecked
    ElseIf gintOUTHmode = 2 Then
        Set mrc = ExecuteSQL(txtSQL, MsgText)
        
        If mrc.EOF = False Then
            With mrc
                txtItem(0) = .Fields(0)
                
                Combo1(0).Clear
                txtSQL = "select dm,mc from dm_ywy where dm = '" & .Fields(1) & "'"
                Set mrcc = ExecuteSQL(txtSQL, MsgText)
                If Not mrcc.EOF Then
                    Combo1(0).AddItem mrcc.Fields(1)
                    Combo1(0).ItemData(Combo1(0).NewIndex) = mrcc.Fields(0)
                    Combo1(0).ListIndex = 0
                    mrcc.Close
                End If
                    
                Combo1(4).Clear
                txtSQL = "select dm,mc from dm_ck where dm = '" & .Fields(4) & "'"
                Set mrcc = ExecuteSQL(txtSQL, MsgText)
                If Not mrcc.EOF Then
                    Combo1(4).AddItem mrcc.Fields(1)
                    Combo1(4).ItemData(Combo1(4).NewIndex) = mrcc.Fields(0)
                    Combo1(4).ListIndex = 0
                    mrcc.Close
                End If
                
            
                For intCount = 1 To 2
                    txtItem(intCount) = .Fields(intCount + 1)
                Next intCount
                
                
                                
                'Combo1(1).Clear
                txtSQL = "select dm,mc from dm_kh where dm = '" & .Fields(3) & "'"
                Set mrcc = ExecuteSQL(txtSQL, MsgText)
                If Not mrcc.EOF Then
                    Combo1(1).AddItem mrcc.Fields(1)
                    Combo1(1).ItemData(Combo1(1).NewIndex) = mrcc.Fields(0)
                    Combo1(1).ListIndex = 0
                    mrcc.Close
                End If
                
                
                txtItem(3) = .Fields(intCount + 2)
                
                Combo1(2).Clear
                txtSQL = "select dm,mc from dm_wz where dm = '" & .Fields(5) & "'"
                Set mrcc = ExecuteSQL(txtSQL, MsgText)
                If Not mrcc.EOF Then
                    Combo1(2).AddItem mrcc.Fields(1)
                    Combo1(2).ItemData(Combo1(2).NewIndex) = mrcc.Fields(0)
                    Combo1(2).ListIndex = 0
                    mrcc.Close
                End If
                
                txtItem(11) = .Fields(6)
                
                For intCount = 4 To 7
                    txtItem(intCount) = .Fields(intCount + 3)
                Next intCount
                
                If Trim(.Fields(11)) = "Y" Then
                    Combo1(5).ListIndex = 0
                Else
                        If Trim(.Fields(12)) = "Y" Then
                            Combo1(5).ListIndex = 1
                        Else
                            Combo1(5).ListIndex = 2
                            txtItem(8) = .Fields(13)
                        End If
                End If
                
                txtItem(9) = .Fields(14)
                
                txtCKDM = .Fields(4)
                txtWZDM = .Fields(5)
                txtQIHAO = .Fields(6)
                txtSL = .Fields(7)
                txtZKE = .Fields(10)
                
                
               
            End With
            txtItem(0).Enabled = False
        End If
        
        Me.Caption = Me.Caption & "修改"
    End If
    
    txtSQL = "select dm,mc from dm_ywy"
    Set mrcc = ExecuteSQL(txtSQL, MsgText)
    
    If Not mrcc.EOF Then
        If Trim(Combo1(0)) <> "" Then
            Do While Not mrcc.EOF
                If Combo1(0).ItemData(Combo1(0).ListIndex) <> mrcc.Fields(0) Then
                    Combo1(0).AddItem mrcc.Fields(1)
                    Combo1(0).ItemData(Combo1(0).NewIndex) = mrcc.Fields(0)
                End If
                mrcc.MoveNext
            Loop
        Else
            Do While Not mrcc.EOF
                Combo1(0).AddItem mrcc.Fields(1)
                Combo1(0).ItemData(Combo1(0).NewIndex) = mrcc.Fields(0)
                mrcc.MoveNext
            Loop
            
        End If
    End If
    
    mrcc.Close
    
    txtItem(0) = Format(Now, "yyyy-mm-dd")
    txtItem(0).Enabled = False
    
    'txtSQL = "select dm,mc from dm_kh"
    'Set mrcc = ExecuteSQL(txtSQL, MsgText)
    
    'If Not mrcc.EOF Then
    '    If Trim(Combo1(1)) <> "" Then
    '        Do While Not mrcc.EOF
    '            If Combo1(1).ItemData(Combo1(1).ListIndex) <> mrcc.Fields(0) Then
    '                Combo1(1).AddItem mrcc.Fields(1)
    '                Combo1(1).ItemData(Combo1(1).NewIndex) = mrcc.Fields(0)
    '            End If
    '            mrcc.MoveNext
    '        Loop
    '    Else
    '        Do While Not mrcc.EOF
    '            Combo1(1).AddItem mrcc.Fields(1)
    '            Combo1(1).ItemData(Combo1(1).NewIndex) = mrcc.Fields(0)
    '            mrcc.MoveNext
    '        Loop
            
    '    End If
    'End If
    
    'mrcc.Close
    
    txtSQL = "select dm,mc from dm_wz"
    Set mrcc = ExecuteSQL(txtSQL, MsgText)
    
    If Not mrcc.EOF Then
        If Trim(Combo1(2)) <> "" Then
            Do While Not mrcc.EOF
                If Combo1(2).ItemData(Combo1(2).ListIndex) <> mrcc.Fields(0) Then
                    Combo1(2).AddItem mrcc.Fields(1)
                    Combo1(2).ItemData(Combo1(2).NewIndex) = mrcc.Fields(0)
                End If
                mrcc.MoveNext
            Loop
        Else
            Do While Not mrcc.EOF
                Combo1(2).AddItem mrcc.Fields(1)
                Combo1(2).ItemData(Combo1(2).NewIndex) = mrcc.Fields(0)
                mrcc.MoveNext
            Loop
            
        End If
    End If
    
    mrcc.Close
    
   
    txtSQL = "select dm,mc from dm_ck"
    Set mrcc = ExecuteSQL(txtSQL, MsgText)
    
    If Not mrcc.EOF Then
        If Trim(Combo1(4)) <> "" Then
            Do While Not mrcc.EOF
                If Combo1(4).ItemData(Combo1(4).ListIndex) <> mrcc.Fields(0) Then
                    Combo1(4).AddItem mrcc.Fields(1)
                    Combo1(4).ItemData(Combo1(4).NewIndex) = mrcc.Fields(0)
                End If
                mrcc.MoveNext
            Loop
        Else
            Do While Not mrcc.EOF
                Combo1(4).AddItem mrcc.Fields(1)
                Combo1(4).ItemData(Combo1(4).NewIndex) = mrcc.Fields(0)
                mrcc.MoveNext
            Loop
            
        End If
    End If
    
    mrcc.Close
    mblChange = False
End Sub

Private Sub Form_Unload(Cancel As Integer)
    gintOUTHmode = 0
End Sub



Private Sub Option1_Click(Index As Integer)
    Dim mrc As ADODB.Recordset
    Dim txtSQL As String
    Dim MsgText As String
    
    If Index = 0 Then
        Option1(0).Value = True
        Option1(1).Value = False
        
        txtSQL = "select dm,mc from dm_kh"
        Set mrc = ExecuteSQL(txtSQL, MsgText)
        
        Combo1(1).Clear
        If Not mrc.EOF Then
            
            
            Do While Not mrc.EOF
                Combo1(1).AddItem mrc.Fields(1)
                Combo1(1).ItemData(Combo1(1).NewIndex) = mrc.Fields(0)
                mrc.MoveNext
            Loop
            mrc.Close
        End If
        
    ElseIf Index = 1 Then
        Option1(1).Value = True
        Option1(0).Value = False
        
        txtSQL = "select dm,mc from dm_khs"
        Set mrc = ExecuteSQL(txtSQL, MsgText)
        
        
        Combo1(1).Clear
        If Not mrc.EOF Then

            
            Do While Not mrc.EOF
                Combo1(1).AddItem mrc.Fields(1)
                Combo1(1).ItemData(Combo1(1).NewIndex) = mrc.Fields(0)
                mrc.MoveNext
            Loop
            mrc.Close
        End If
        
    End If
End Sub

Private Sub txtItem_Change(Index As Integer)
    Dim intCount As Integer
    '用于计算工资
    Dim dblTotal As Double
    
  
    '有变化设置gblchange
    mblChange = True
    
    If (Index >= 4 And Index <= 6) Then
        dblTotal = 0
        
        If Trim(txtItem(4)) <> "" And Trim(txtItem(5)) <> "" And Trim(txtItem(6)) <> "" Then
            dblTotal = CDbl(txtItem(4)) * CDbl(txtItem(5)) * CDbl(txtItem(6)) / 100
        End If
      
        txtItem(7) = Format(dblTotal, "#0.00")
        
    End If
            
    Exit Sub
End Sub

Private Sub txtItem_GotFocus(Index As Integer)
    txtItem(Index).SelStart = 0
    txtItem(Index).SelLength = Len(txtItem(Index))
End Sub

Private Sub txtItem_KeyDown(Index As Integer, KeyCode As Integer, Shift As Integer)
    EnterToTab KeyCode
End Sub

Private Sub txtItem_KeyPress(Index As Integer, KeyAscii As Integer)
    
    If Index >= 4 And Index <= 6 Then
        'MsgBox KeyCode
        '对键入字符进行控制
        'txtQuantity(Index).Locked = False
        '小数点只允许输入一次
        If KeyAscii = 190 Then
            If InStr(Trim(txtItem(Index)), ".") = 0 Then
                If Len(Trim(txtItem(Index))) > 0 Then
                    txtItem(Index).Locked = False
                Else
                    txtItem(Index).Locked = True
                End If
            Else
                txtItem(Index).Locked = True
            End If
            Exit Sub
        End If
        '非数字不能输入
        If KeyAscii > 57 Or KeyAscii < 48 Then
            txtItem(Index).Locked = True
        Else
            txtItem(Index).Locked = False
        End If
        '允许Backspace
        If KeyAscii = 8 Then
            txtItem(Index).Locked = False
        End If
        'Delete键
        If KeyAscii = 46 Then
            txtItem(Index).Locked = False
        End If
    End If
    
    
End Sub