frmdh1.frm

数据库要求：SQL Server 2000 系统要求：Windows操作系统； 安装程序以前

                Case 2
                    sMeg = "商品名称"
            End Select
            sMeg = sMeg & "不能为空！"
            MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
            Combo1(intCount).SetFocus
            Exit Sub
        End If
    Next intCount
    
    If Not IsDate(Format(Trim(txtItem(4)), "yyyy-mm-dd")) Then
        MsgBox "药品的有效期限请输入日期！", vbOKOnly + vbExclamation, "警告"
        txtItem(4).SetFocus
        Exit Sub
    End If
    
    For intCount = 5 To 7
        If Not IsNumeric(Trim(txtItem(intCount))) Then
            sMeg = "请输入数字！"
            MsgBox sMeg, vbOKOnly + vbExclamation, "警告"
            txtItem(intCount).SetFocus
            Exit Sub
        End If
    Next intCount
   
    '添加判断是否有相同的ID记录
    If gintDHmode = 1 Then
        txtSQL = "select * from dh where dh_no ='" & Trim(txtItem(1)) & "'"
        Set mrc = ExecuteSQL(txtSQL, MsgText)
        If mrc.EOF = False Then
            MsgBox "已经存在此订单编号的记录！", vbOKOnly + vbExclamation, "警告"
            txtItem(1).SetFocus
            Exit Sub
        End If
        mrc.Close
    End If
    
    
    '先删除已有记录
    txtSQL = "delete from dh where dh_no ='" & Trim(txtItem(1)) & "'"
    Set mrc = ExecuteSQL(txtSQL, MsgText)
   
    
    '再加入新记录
    txtSQL = "execute dh_setup '"
    
    txtSQL = txtSQL & Trim(txtItem(0)) & "','"
    
    txtSQL = txtSQL & Trim(Combo1(0).ItemData(Combo1(0).ListIndex)) & "','"
    
    For intCount = 1 To 3
        txtSQL = txtSQL & Trim(txtItem(intCount)) & "','"
    Next intCount
    
    
    For intCount = 4 To 8
        txtSQL = txtSQL & Trim(txtItem(intCount)) & "','"
    Next intCount
    
    
    txtSQL = txtSQL & Trim(txtItem(9)) & "'"
    
    
    Set mrc = ExecuteSQL(txtSQL, MsgText)
        
    If gintDHmode = 1 Then
        MsgBox "添加记录成功！", vbOKOnly + vbExclamation, "添加记录"
        For intCount = 0 To 9
            txtItem(intCount) = ""
        Next intCount
        
        For intCount = 0 To 2
            Combo1(intCount).ListIndex = 0
        Next intCount
       
        
        txtItem(0) = Format(Now, "yyyy-mm-dd")
        
        mblChange = False
        
        Unload frmdh
        frmdh.txtSQL = "select dh_no,in_date,ywman,gfdm,wzdm,cxend,sl,in_danj,i_zk,i_zke,bz from dh"
        frmdh.Show
        
    ElseIf gintDHmode = 2 Then
        Unload Me
        Unload frmdh
        
        frmdh.txtSQL = "select dh_no,in_date,ywman,gfdm,wzdm,cxend,sl,in_danj,i_zk,i_zke,bz from dh"
        frmdh.Show
    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 = 1 Then
        
                txtItem(2) = Combo1(1).ItemData(Combo1(1).ListIndex)

    ElseIf Index = 2 Then
            txtSQL = "select dm,rkj  from dm_wz where mc = '" & Trim(Combo1(2)) & "'"
            Set mrcc = ExecuteSQL(txtSQL, MsgText)
                        
            If Not mrcc.EOF Then
                txtItem(3) = mrcc.Fields(0)
                txtItem(6) = mrcc.Fields(1)
            End If
            
            mrcc.Close
            
    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
  
    If gintDHmode = 1 Then
        Me.Caption = Me.Caption & "添加"
        For i = 0 To 9
            txtItem(i).Text = ""
        Next i
        
        For i = 0 To 2
            Combo1(i).Clear
        Next i
        
        
        
    ElseIf gintDHmode = 2 Then
        Set mrc = ExecuteSQL(txtSQL, MsgText)
        
        If mrc.EOF = False Then
            With mrc
                txtItem(0) = .Fields(0)
                
                Combo1(0).Clear
                txtSQL = "select * from dm_ywy where dm = '" & Trim(.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
            
                For intCount = 1 To 3
                    txtItem(intCount) = .Fields(intCount + 1)
                Next intCount
                
                Combo1(1).Clear
                txtSQL = "select dm,mc from dm_gf where dm = '" & Trim(txtItem(2)) & "'"
                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
                
                
                Combo1(2).Clear
                txtSQL = "select dm,mc from dm_wz where dm = '" & Trim(txtItem(3)) & "'"
                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
                
                
                For intCount = 4 To 8
                    txtItem(intCount) = .Fields(intCount + 1)
                Next intCount
               
            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_gf"
    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
    
    
    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 >= 5 And Index <= 7) Then
        dblTotal = 0
        
        If Trim(txtItem(5)) <> "" And Trim(txtItem(6)) <> "" And Trim(txtItem(7)) <> "" Then
            dblTotal = CDbl(txtItem(5)) * CDbl(txtItem(6)) * CDbl(txtItem(7)) / 100
        End If
      
        txtItem(8) = 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 >= 5 And Index <= 7 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