VB开发的ERP系统

                .Buttons("shsh").Enabled = False    '审核
                .Buttons("shqs").Enabled = False    '弃审
                .Buttons("dk").Enabled = False      '打开
                .Buttons("gb").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)
            Case "30"   '修改(（录入）调入修改功能、（列表）调入修改功能)
                '工具条
                .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("dk").Enabled = False      '打开
                .Buttons("gb").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

End Sub

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

End Sub
Private Sub Sub_OpenStatus()                                       '设置打开关闭按钮状态(亦可设置其他动作按钮状态)
    
    '根据当前单据状态来确定打开关闭按钮状态
    If Trim(LrText(14).Text) <> "" And Trim(LrText(16).Text) <> "" Then
        Tlb_Action.Buttons("dk").Enabled = True      '打开
    Else
        Tlb_Action.Buttons("dk").Enabled = False   '打开
    End If
    If Trim(LrText(14).Text) <> "" And Trim(LrText(16).Text) = "" Then
        Tlb_Action.Buttons("gb").Enabled = True      '关闭
    Else
        Tlb_Action.Buttons("gb").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                        '临时使用查询字符串
    Dim Jsq As Integer
    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,SaleUnitName,ConsultPrice,Cess From Gy_Material Where (MNumber='" & Str_JudgeText & "' Or MName='" & Str_JudgeText & "') and isSale='1'"
                    If RecTemp.State = 1 Then RecTemp.Close
                    Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
                    If RecTemp.EOF Then
                        Tsxx = "此存货编码不存在!"
                        GoTo Lrcwcl
                    End If
                    For Jsq = .FixedRows To .Cols - 1
                        If .TextMatrix(Jsq, 0) <> "*" Then
                            Exit For
                        End If
                        If Jsq <> Dqpdwgh Then
                            If Trim(.TextMatrix(Jsq, Sydz("001", GridStr(), Szzls))) = Trim(.TextMatrix(Dqpdwgh, Sydz("001", GridStr(), Szzls))) Then
                                Tsxx = "不能重复录入货物编码!"
                                GoTo Lrcwcl
                            End If
                        End If
                    Next
                    '2.放置字段事后处理程序
                    .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)) = RecTemp.Fields("SaleUnitName")              '单位
                    If LrText(6) <> "" Then
                        If LrText(7).Tag <> "1" Or LrText(7).Tag = True Then
                            .TextMatrix(Dqpdwgh, Sydz("014", GridStr(), Szzls)) = Format(Val(RecTemp.Fields("ConsultPrice")) / LrText(7).Text, "###0." + String(Xtdjxsws, "0"))             '单价
                        Else
                            .TextMatrix(Dqpdwgh, Sydz("014", GridStr(), Szzls)) = Format(Val(RecTemp.Fields("ConsultPrice")) * LrText(7).Text, "###0." + String(Xtdjxsws, "0"))           '单价
                        End If
                    End If
                    .TextMatrix(Dqpdwgh, Sydz("008", GridStr(), Szzls)) = RecTemp.Fields("Cess") / 100                  '税率
                    Sqlstr = "SELECT * From Xs_PriceList Where WareCode='" & Str_JudgeText & "' and cuscode='" & LrText(2).Tag & "'"
                    If RecTemp.State = 1 Then RecTemp.Close
                    Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
                    If RecTemp.EOF Then
                        .TextMatrix(Dqpdwgh, Sydz("005", GridStr(), Szzls)) = 1
                        .TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls)) = .TextMatrix(Dqpdwgh, Sydz("014", GridStr(), Szzls))
                    Else
                        .TextMatrix(Dqpdwgh, Sydz("005", GridStr(), Szzls)) = Trim(RecTemp.Fields("quantity") & "")
                        If LrText(6) <> "" Then
                            If LrText(7).Tag <> "1" Or LrText(7).Tag = True Then
                                .TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls)) = Format(Val(RecTemp.Fields("CapitalUnitTaxPrice")) / LrText(7).Text, "###0." + String(Xtdjxsws, "0"))             '单价
                            Else
                                .TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls)) = Format(Val(RecTemp.Fields("CapitalUnitTaxPrice")) * LrText(7).Text, "###0." + String(Xtdjxsws, "0"))           '单价
                            End If
                        End If
                    End If
                    '根据公式计算结果
                    Call Sub_JoinCount(Dqpdwgh, Sydz("005", GridStr(), Szzls))   '数量
                Else
                    '3.清空相关字段
                    .TextMatrix(Dqpdwgh, Sydz("002", GridStr(), Szzls)) = ""                                             '存货名称
                    .TextMatrix(Dqpdwgh, Sydz("003", GridStr(), Szzls)) = ""                                             '存货规格型号
                End If
            Case "006"          '单价
                '1.放置字段有效性判断
                
                '2.放置字段事后处理程序
                Call Sub_JoinCount(Dqpdwgh, Sydz("006", GridStr(), Szzls))   '单价(根据公式计算结果)
            Case "005"          '数量
                '1.放置字段有效性判断
                '2.放置字段事后处理程序
                Call Sub_JoinCount(Dqpdwgh, Sydz("005", GridStr(), Szzls))   '数量(根据公式计算结果)
            Case "009"          '价税合计
                '1.放置字段有效性判断
                '2.放置字段事后处理程序
                Call Sub_JoinCount(Dqpdwgh, Sydz("009", GridStr(), Szzls))   '价税合计（根据公式计算结果)
            Case "010"          '无税单价
                '1.放置字段有效性判断
                
                '2.放置字段事后处理程序
                Call Sub_JoinCount(Dqpdwgh, Sydz("010", GridStr(), Szzls))   '无税单价(根据公式计算结果)
            Case "011"          '无税金额
                '1.放置字段有效性判断
                
                '2.放置字段事后处理程序
                Call Sub_JoinCount(Dqpdwgh, Sydz("011", GridStr(), Szzls))   '无税金额(根据公式计算结果)
            Case "012"          '预发货日期
                '1.放置字段有效性判断
                If Not IsDate(.TextMatrix(Dqpdwgh, Sydz("012", GridStr(), Szzls))) And Trim(.TextMatrix(Dqpdwgh, Sydz("012", GridStr(), Szzls))) <> "" Then
                    Tsxx = "非法公历日期!(格式:" & Xtrq & ")"
                    GoTo Lrcwcl
                End If
                If Trim(.TextMatrix(Dqpdwgh, Sydz("012", GridStr(), Szzls))) <> "" Then
                    If CDate(.TextMatrix(Dqpdwgh, Sydz("012", GridStr(), Szzls))) < CDate(LrText(1).Text) Then
                        Tsxx = "预发货日期必须大于等于报价单日期!"
                        GoTo Lrcwcl
                    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 "005"    '数量
                '(1).价税合计＝数量＊含税单价；
                '(2).无税单价＝含税单价/（1+税率）
                '(3).无税金额＝数量＊无税单价；
                '(4).税额＝价税合计-无税金额；
                If Val(.TextMatrix(Lng_CountRow, Sydz("005", GridStr(), Szzls))) <> 0 Then
                    .TextMatrix(Lng_CountRow, Sydz("009", GridStr(), Szzls)) = Format(Val(.TextMatrix(Lng_CountRow, Sydz("005", GridStr(), Szzls))) * Val(.TextMatrix(Lng_CountRow, Sydz("006", GridStr(), Szzls))), "###0." + String(Xtjexsws, "0"))
                    .TextMatrix(Lng_CountRow, Sydz("010", GridStr(), Szzls)) = Format(Val(.TextMatrix(Lng_CountRow, Sydz("006", GridStr(), Szzls))) / (1 + Val(.TextMatrix(Lng_CountRow, Sydz("008", GridStr(), Szzls)))), "###0." + String(Xtdjxsws, "0"))
                    .TextMatrix(Lng_CountRo