frmwx1.frm

用sql和VB制作的小型通用汽车管理系统。该系统可实现了汽车管理的自动化技术。

                    Exit Sub
                End If
            Else
                sMeg = "仓库中没有指定商品，请首先从其他仓库调拨！"
                MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
                Exit Sub
            End If
            
        Else
            txtSQL = "select update_date,sl,total_je from kucun where ckdm = '" & txtItem(0) & "'"
            txtSQL = txtSQL & " and wzdm = '" & txtItem(1) & "'"
            txtSQL = txtSQL & " and qihao = '" & txtItem(2) & "'"

            
            Set mrc = ExecuteSQL(txtSQL, MsgText)
            
            If Not mrc.EOF Then
                If mrc.Fields(1) >= CDbl(txtItem(4)) Then
                    mrc.Close
                Else
                    mrc.Close
                    sMeg = "库存商品数量不够，请首先从其他仓库调拨！"
                    MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
                    Exit Sub
                End If
            Else
                    sMeg = "仓库没有指定商品，请首先从其他仓库调拨！"
                    MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
                    Exit Sub
            End If
            
        End If
    End If
    
    
    
    '先删除已有记录
    txtSQL = "delete from outh where outh_no ='" & Trim(txtM_NO) & "' and wzdm = '" & Trim(txtItem(1)) & "' and ckdm = '" & Trim(txtItem(0)) & "'"
    Set mrc = ExecuteSQL(txtSQL, MsgText)
   
    
    '再加入新记录
    txtSQL = "insert outh (out_date,ywman,outh_no,khdm,ckdm,wzdm,qihao,out_danj,sl,o_zke,o_zk,bz1) values ('"
    
    txtSQL = txtSQL & Trim(txtM_DATE) & "','"
    
    txtSQL = txtSQL & Trim(txtYWDM) & "','"
    txtSQL = txtSQL & Trim(txtM_NO) & "','"
    

    
    txtSQL = txtSQL & Trim(txtKHDM) & "','"
    
    For intCount = 0 To 5
        txtSQL = txtSQL & Trim(txtItem(intCount)) & "','"
    Next intCount
    
    txtSQL = txtSQL & Trim(txtREB) & "','"
    
    txtSQL = txtSQL & "N')"
    
    
    
    Set mrc = ExecuteSQL(txtSQL, MsgText)
        
    If gintPLmode = 1 Then
        MsgBox "添加记录成功！", vbOKOnly + vbExclamation, "添加记录"
        For intCount = 0 To 5
            txtItem(intCount) = ""
        Next intCount
        
        For intCount = 0 To 1
            Combo1(intCount).ListIndex = 0
        Next intCount
        
        mblChange = False
        
        gintPLLISTmode = 2
        frmWX.txtSQL = "select outh.outh_no,dm_wz.dm,dm_wz.mc,dm_ck.mc,outh.qihao,outh.sl,outh.out_danj,outh.o_zk,outh.o_zke from outh inner join dm_wz on outh.wzdm = dm_wz.dm inner join dm_ck on outh.ckdm = dm_ck.dm where outh_no = '" & txtM_NO & "'"
        Unload frmWX1
        frmWX.ShowData
        
    ElseIf gintPLmode = 2 Then
        frmWX.txtSQL = "select outh.outh_no,dm_wz.dm,dm_wz.mc,dm_ck.mc,outh.qihao,outh.sl,outh.out_danj,outh.o_zk,outh.o_zke from outh inner join dm_wz on outh.wzdm = dm_wz.dm inner join dm_ck on outh.ckdm = dm_ck.dm where outh_no = '" & txtM_NO & "'"
        Unload frmWX1
        frmWX.ShowData
    End If
    
End Sub

Private Sub Combo1_Change(Index As Integer)
    mblChange = True
    
    
End Sub

Private Sub Combo1_Click(Index As Integer)
    Dim mrcc As ADODB.Recordset
    Dim mrcd As ADODB.Recordset
    Dim MsgText As String
    
    
    If Index = 0 Then
            txtItem(0) = Combo1(0).ItemData(Combo1(0).ListIndex)
            
            Combo1(1).Clear
            
            txtSQL = "select dm_wz.dm,dm_wz.mc from kucun inner join dm_wz on kucun.wzdm = dm_wz.dm inner join dm_wzlb on dm_wz.lbdm = dm_wzlb.lbcode1 inner join dm_kh on dm_kh.lbdm = dm_wzlb.lb1 inner join dm_ck on kucun.ckdm = dm_ck.dm where dm_wzlb.lb1 = '" & Trim(txtLB) & "'"
            txtSQL = txtSQL & " and dm_ck.dm = '" & Trim(Combo1(0).ItemData(Combo1(0).ListIndex)) & "'"
            Set mrcc = ExecuteSQL(txtSQL, MsgText)
                        
            If Not mrcc.EOF Then
                Do While Not mrcc.EOF
                    If Trim(mrcc.Fields(1)) <> Trim(Combo1(1)) Then
                        Combo1(1).AddItem mrcc.Fields(1)
                        Combo1(1).ItemData(Combo1(1).NewIndex) = mrcc.Fields(0)
                    End If
                    
                    mrcc.MoveNext
                Loop
                mrcc.Close
            Else
                MsgBox "指定仓库中没有相应车型的配件，请进货！", vbOKOnly + vbExclamation, "警告"
                
            End If
    ElseIf Index = 1 Then
        txtItem(1) = Combo1(1).ItemData(Combo1(1).ListIndex)
        
        txtSQL = "select kucun.qihao,dm_wz.lsj from kucun inner join dm_wz on kucun.wzdm = dm_wz.dm where kucun.ckdm = '" & Trim(txtItem(0)) & "'"
        txtSQL = txtSQL & " and kucun.wzdm = '" & Trim(txtItem(1)) & "'"
        
        Set mrcc = ExecuteSQL(txtSQL, MsgText)
        
        If Not mrcc.EOF Then
            txtItem(2) = mrcc.Fields(0)
            txtItem(3) = mrcc.Fields(1)
            mrcc.Close
        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(0).Clear
  
    If gintPLmode = 1 Then
        Me.Caption = Me.Caption & "添加"
        For i = 0 To 4
            txtItem(i).Text = ""
        Next i
        
        Combo1(0).Clear
        
    ElseIf gintPLmode = 2 Then
        Set mrc = ExecuteSQL(txtSQL, MsgText)
        
        If mrc.EOF = False Then
            With mrc
                txtItem(0) = .Fields(0)
                txtCKDM = .Fields(0)
                
                Combo1(0).Clear
                Combo1(0).AddItem .Fields(1)
                Combo1(0).ItemData(Combo1(0).NewIndex) = .Fields(0)
                Combo1(0).ListIndex = 0
                
                txtItem(1) = .Fields(2)
                txtWZDM = .Fields(2)
                
                For i = 0 To Combo1(1).ListCount - 1
                    Combo1(1).ListIndex = i
                    
                    If Trim(Combo1(1)) = Trim(.Fields(3)) Then
                        i = Combo1(1).ListCount - 1
                    End If
                Next i
                
                For intCount = 2 To 5
                    txtItem(intCount) = .Fields(intCount + 2)
                Next intCount
                
                txtQIHAO = .Fields(4)
                txtSL = .Fields(6)
                txtZKE = .Fields(7)
                
            End With
            txtItem(0).Enabled = False
        End If
        
        Me.Caption = Me.Caption & "修改"
    End If
    
    
        
    txtSQL = "select dm,mc from dm_ck"
    Set mrcc = ExecuteSQL(txtSQL, MsgText)
    
    If Not mrcc.EOF Then
        Do While Not mrcc.EOF
            If Trim(mrcc.Fields(1)) <> Trim(Combo1(0)) Then
                Combo1(0).AddItem mrcc.Fields(1)
                Combo1(0).ItemData(Combo1(0).NewIndex) = mrcc.Fields(0)
            End If
                
            mrcc.MoveNext
        Loop
    End If
    
    mrcc.Close
    
    mblChange = False
End Sub

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



Private Sub txtItem_Change(Index As Integer)
    Dim intCount As Integer
    '用于计算工资
    Dim dblTotal As Double
    
  
    '有变化设置gblchange
    mblChange = True
    
    If (Index = 4) Then
        dblTotal = 0
        
        If Trim(txtItem(3)) <> "" And Trim(txtREB) <> "" Then
            dblTotal = CDbl(txtItem(3)) * txtREB * CDbl(txtItem(4)) / 100
        End If
      
        txtItem(5) = 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 <= 4 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