VB开发的ERP系统

                .Buttons("dy").Enabled = False      '打印
                .Buttons("yl").Enabled = False      '预览
                .Buttons("xz").Enabled = False      '新增
                .Buttons("xg").Enabled = False      '修改
                .Buttons("sc").Enabled = False      '删除
                .Buttons("zh").Enabled = True       '增行
                .Buttons("sh").Enabled = True       '删行
                .Buttons("bc").Enabled = True       '保存
                .Buttons("fq").Enabled = True       '放弃
                .Buttons("shsh").Enabled = False    '审核
                .Buttons("shqs").Enabled = False    '弃审
                .Buttons("first").Enabled = False   '首张
                .Buttons("prev").Enabled = False    '上张
                .Buttons("next").Enabled = False    '下张
                .Buttons("last").Enabled = False    '末张
                .Buttons("bz").Enabled = True       '帮助
                .Buttons("fh").Enabled = True       '退出
                
                '设置文本框录入状态
                Call Sub_LrtextStatus(True)
        End Select
    End With

End Sub

Private Sub Sub_LrtextStatus(TextEnabled As Boolean)                            '设置录入文本框状态

    '录入文本框状态设置
    If TextEnabled Then
        For jsqte = Max_Text_Index To 0 Step -1
            '判断文本框是否可编辑
            If Textboolean(jsqte, 5) Then
                LrText(jsqte).Enabled = True
            Else
                LrText(jsqte).Enabled = False
            End If
        Next jsqte
    Else
        For jsqte = Max_Text_Index To 0 Step -1
            LrText(jsqte).Enabled = False
        Next jsqte
    End If
    '免检选择是否有效
    If TextEnabled = True Then
        NoCheck.Enabled = True
    Else
        NoCheck.Enabled = False
    End If
    

End Sub

Private Sub Sub_CheckStatus()                                       '设置审核弃审按钮状态(亦可设置其他动作按钮状态)
    
    '根据当前单据状态来确定审核弃审按钮状态
    If Trim(LrText(14).Text) = "" And Trim(LrText(15).Text) = "" Then
        Tlb_Action.Buttons("shsh").Enabled = True      '审核
        Tlb_Action.Buttons("shqs").Enabled = False      '弃审
    ElseIf Trim(LrText(14).Text) <> "" And Trim(LrText(15).Text) = "" Then
        Tlb_Action.Buttons("shsh").Enabled = False      '审核
        Tlb_Action.Buttons("shqs").Enabled = True      '弃审
    Else
        Tlb_Action.Buttons("shsh").Enabled = False      '审核
        Tlb_Action.Buttons("shqs").Enabled = False     '弃审
    End If
    If Trim(LrText(13).Text) = "" Then
        Tlb_Action.Buttons("shsh").Enabled = False      '审核
        Tlb_Action.Buttons("shqs").Enabled = False     '弃审
    End If
    
End Sub

Private Sub Wbkcl()                                                 '文本框录入之前处理(根据实际情况)
    
    Dim xswbrr As String
    With WglrGrid
        Zdlrqnr = Trim(.Text)
        xswbrr = Trim(.Text)
        If GridBoolean(.Col, 3) Then   '列表框录入
            '填充列表框程序
            Call FillCombo(YdCombo, GridStr(.Col, 5), xswbrr, 0)
        Else
            Wbkbhlock = True
       
            '====以下为用户自定义
            Ydtext.Text = xswbrr
            '====以上为用户自定义
         
            Wbkbhlock = False
            Ydtext.SelStart = Len(Ydtext.Text)
        End If
    End With

End Sub

Private Function sjzdyxxpd(Dqpdwgh As Long, Dqpdwgl As Long) As Boolean       '录入数据字段有效性判断,同时进行字段录入事后处理
 
    '函数参数:Dqpdwgh, Dqpdwgl 当前要判断网格单元所处行列值

    Dim Str_JudgeText As String                 '临时有效性判断字段内容
    Dim Coljsq As Long                          '临时列计数器
    Dim RecTemp As New ADODB.Recordset          '临时使用动态集
    Dim Sqlstr As String                        '临时使用查询字符串

    With WglrGrid
        '非录入状态或非数据行则其有效性为合法
        If Yxxpdlock Or .Row < .FixedRows Then
            sjzdyxxpd = True
            Exit Function
        End If
        
        '取得当前要判断字段内容
        Str_JudgeText = Trim(.TextMatrix(Dqpdwgh, Dqpdwgl))
      
        '根据不同字段进行相应的处理(依据其逻辑编号)
        Select Case GridStr(Dqpdwgl, 1)
            '[>>以下为自定义部分
            Case "001"                   '存货编码
                If Not Trim(Str_JudgeText) = "" Then
                    '1.放置字段有效性判断
                    Sqlstr = "SELECT MNumber,MName,Model,PurUnitName,IsCheck From Gy_Material Where (MNumber='" & Str_JudgeText & "' Or MName='" & Str_JudgeText & "') and IsPurchase=1 "
                    Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
                    If RecTemp.EOF Then
                        Tsxx = "此物料编码不存在或不具备采购属性!"
                        GoTo Lrcwcl
                    End If
                    '2.放置字段事后处理程序
                    For Coljsq = .FixedRows To .Rows - 1
                        If .TextMatrix(Coljsq, 0) = "*" And Coljsq <> Dqpdwgh Then
                            If Trim(.TextMatrix(Coljsq, Sydz("001", GridStr(), Szzls))) = _
                                Trim(RecTemp.Fields("MNumber") & "") Then
                                Tsxx = "在这张单据中，此物料编码已存在!"
                                GoTo Lrcwcl
                                Exit For
                            End If
                        End If
                    Next Coljsq
                    .TextMatrix(Dqpdwgh, Sydz("001", GridStr(), Szzls)) = Trim(RecTemp.Fields("MNumber") & "")      '显示物料编码
                    .TextMatrix(Dqpdwgh, Sydz("002", GridStr(), Szzls)) = Trim(RecTemp.Fields("MName") & "")      '显示物料名称
                    .TextMatrix(Dqpdwgh, Sydz("003", GridStr(), Szzls)) = Trim(RecTemp.Fields("Model") & "")     '显示物料规格型号
                    .TextMatrix(Dqpdwgh, Sydz("004", GridStr(), Szzls)) = Trim("" & RecTemp.Fields("PurUnitName"))           '计量单位
                    .TextMatrix(Dqpdwgh, Sydz("011", GridStr(), Szzls)) = RecTemp.Fields("IsCheck")           '计量单位
                    
                Else
                    .TextMatrix(Dqpdwgh, Sydz("002", GridStr(), Szzls)) = ""
                    .TextMatrix(Dqpdwgh, Sydz("003", GridStr(), Szzls)) = ""
                    .TextMatrix(Dqpdwgh, Sydz("004", GridStr(), Szzls)) = ""
                    .TextMatrix(Dqpdwgh, Sydz("011", GridStr(), Szzls)) = "False"
                End If
            Case "006"          '数量
                
                '1.放置字段有效性判断
                
                
                If (Not IsNumeric(Trim(.TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls))))) And Trim(.TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls))) <> "" Then
                    Tsxx = "请输入数字!"
                    GoTo Lrcwcl
                Else
                    .TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls)) = S2N(Trim(.TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls))))
                    If S2N(Trim(.TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls)))) < 0 Then
                        Tsxx = "数量不能小于零!"
                        GoTo Lrcwcl

                    End If
         
                End If
                '2.放置字段事后处理程序
                    '根据公式计算结果
                Call Sub_JoinCount(Dqpdwgh, Sydz("006", GridStr(), Szzls))   '数量
            Case "007"          '单价
                '1.放置字段有效性判断
                '2.放置字段事后处理程序
                If (Not IsNumeric(Trim(.TextMatrix(Dqpdwgh, Sydz("007", GridStr(), Szzls))))) And Trim(.TextMatrix(Dqpdwgh, Sydz("007", GridStr(), Szzls))) <> "" Then
                    Tsxx = "请输入数字!"
                    GoTo Lrcwcl
                Else
                    .TextMatrix(Dqpdwgh, Sydz("007", GridStr(), Szzls)) = S2N(Trim(.TextMatrix(Dqpdwgh, Sydz("007", GridStr(), Szzls))))
                    If S2N(Trim(.TextMatrix(Dqpdwgh, Sydz("007", GridStr(), Szzls)))) < 0 Then
                        Tsxx = "单价不能小于零!"
                        GoTo Lrcwcl

                    End If
         
                End If
                Call Sub_JoinCount(Dqpdwgh, Sydz("007", GridStr(), Szzls))   '单价(根据公式计算结果)
            Case "008"          '金额
                '1.放置字段有效性判断
                '2.放置字段事后处理程序
                If (Not IsNumeric(Trim(.TextMatrix(Dqpdwgh, Sydz("008", GridStr(), Szzls))))) And Trim(.TextMatrix(Dqpdwgh, Sydz("008", GridStr(), Szzls))) <> "" Then
                    Tsxx = "请输入数字!"
                    GoTo Lrcwcl
                Else
                    .TextMatrix(Dqpdwgh, Sydz("008", GridStr(), Szzls)) = S2N(Trim(.TextMatrix(Dqpdwgh, Sydz("008", GridStr(), Szzls))))
                    If S2N(Trim(.TextMatrix(Dqpdwgh, Sydz("008", GridStr(), Szzls)))) < 0 Then
                        Tsxx = "金额不能小于零!"
                        GoTo Lrcwcl

                    End If
         
                End If
                Call Sub_JoinCount(Dqpdwgh, Sydz("008", GridStr(), Szzls))   '金额(根据公式计算结果)
                '<<以上为自定义部分]
           Case "009"     '保质期
                If Len(Trim(Str_JudgeText)) <> 0 Then
                    If Trim(.TextMatrix(Dqpdwgh, Sydz("005", GridStr(), Szzls))) = "" Then
                        .TextMatrix(Dqpdwgh, Sydz("009", GridStr(), Szzls)) = ""
                        Tsxx = "请先录入批号!"
                        Dqpdwgl = Sydz("005", GridStr(), Szzls)
                        GoTo Lrcwcl
                    Else
                        If IsDate(.TextMatrix(Dqpdwgh, Sydz("009", GridStr(), Szzls))) Then 'remonstrate
                            If CDate(.TextMatrix(Dqpdwgh, Sydz("009", GridStr(), Szzls))) < CDate(LrText(0).Text) Then
                            Tsxx = "失效日期不能小于收料日期!"
                            GoTo Lrcwcl
                            End If
                        Else
                            Tsxx = "第(" & Trim("" & Dqpdwgh - .FixedRows + 1) & ")条分录失效日期为非法公历日期!(格式:" + Format(Xtrq, "yyyy-mm-dd") + ")"
                            GoTo Lrcwcl
                        End If
                    End If
                End If
        End Select
        
        '字段录入正确后为零字段清空(Fixed)
        Call Qkwlzd(Dqpdwgh, Dqpdwgl)
     
        '字段录入正确后进行数据合计(Fixed)
        For Coljsq = Qslz To .Cols - 1
            Call Sjhj(Coljsq)
        Next Coljsq
     
        '字段有效性判断通过,将字段有效性判断加锁直至再次改变(Fixed)
        sjzdyxxpd = True
        Yxxpdlock = True
        Exit Function
    End With
  
Lrcwcl:    '录入错误处理
    With WglrGrid
  
        '给出错误提示信息
        Call Xtxxts(Tsxx, 0, 1)
          
        '返回网格错误位置(ChangeLock避免再次引发RowColChange有效性判断),装入录入载体
        Changelock = True
        .Select Dqpdwgh, Dqpdwgl
        Changelock = False
        Call xswbk
          
        '函数返回False
        sjzdyxxpd = False
        Exit Function
    End With

End Function

Private Sub Sub_JoinCount(Lng_CountRow As Long, Lng_CountCol As Long)       '当网格列值发生改变时,处理网格列之间的关联计算(可选)
  
  '过程参数:Lng_CountRow,Lng_CountCol 网格改变内容所处行列值
   
    With WglrGrid
        Select Case GridStr(Lng_CountCol, 1)         '判断网格列对应逻辑编号
               
            '[>>以下为自定义部分
            Case "006"    '数量改变
                '计算公式:单价*数量=金额
                If S2N(.TextMatrix(Lng_CountRow, Sydz("007", GridStr(), Szzls))) * S2N(.TextMatrix(Lng_CountRow, Sydz("006", GridStr(), Szzls))) <> 0 Then
                    .TextMatrix(Lng_CountRow, Sydz("008", GridStr(), Szzls)) = Format(S2N(.TextMatrix(Lng_CountRow, Sydz("007", GridStr(), Szzls))) * S2N(.TextMatrix(Lng_CountRow, Sydz("006", GridStr(), Szzls))), "###0." + String(Xtjexsws, "0"))
                Else
                    .TextMatrix(Lng_CountRow, Sydz("008", GridStr(), Szzls)) = ""
                End If
            Case "008"    '金额改变
                '计算公式:金额/数量=单价
                If S2N(.TextMatrix(Lng_CountRow, Sydz("006", GridStr(), Szzls))) <> 0 Then
                    If S2N(.TextMatrix(Lng_CountRow, Sydz("008", GridStr(), Szzls))) / S2N(.TextMatrix(Lng_CountRow, Sydz("006", GridStr(), Szzls))) <> 0 Then
                        .TextMatrix(Lng_CountRow, Sydz("007", GridStr(), Szzls)) = Format(S2N(.TextMatrix(Lng_CountRow, Sydz("008", GridStr(), Szzls))) / S2N(.TextMatrix(Lng_CountRow, Sydz("006", GridStr(), Szzls))), "###0." + String(Xtdjxsws, "0"))
                    Else
                        .TextMatrix(Lng_CountRow, Sydz("007", GridStr(), Szzls)) = ""
                    End If
                Else
                    .TextMatrix(Lng_CountRow, Sydz("006", GridStr(), Szzls)) = ""
                    .TextMatrix(Lng_CountRow, Sydz("007", GridStr(), Szzls)) = ""
                    .TextMatrix(Lng_CountRow, Sydz("008", Grid