--+

VB开发的ERP系统

                .Buttons("first").Enabled = True    '首张
                .Buttons("prev").Enabled = True     '上张
                .Buttons("next").Enabled = True     '下张
                .Buttons("last").Enabled = True     '末张
                .Buttons("bz").Enabled = True       '帮助
                .Buttons("fh").Enabled = True       '退出
        
                '设置审核弃审按钮状态
                Call Sub_CheckStatus
        
                '设置文本框录入状态
                Call Sub_LrtextStatus(False)
            Case "20"   '新增单据(（录入）新增一张单据 、（列表）新增一张单据)
                '工具条
                .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)
            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("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(12).Text) <> "" And Trim(LrText(13).Text) = "" Then
        Tlb_Action.Buttons("shsh").Enabled = True      '审核
    Else
        Tlb_Action.Buttons("shsh").Enabled = False   '审核
    End If
    If Trim(LrText(12).Text) <> "" And Trim(LrText(13).Text) <> "" Then
        Tlb_Action.Buttons("shqs").Enabled = True      '弃审
    Else
        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                        '临时使用查询字符串
    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.放置字段有效性判断
                    If Trim(LrText(2).Text) <> "" Then
                        Sqlstr = "SELECT * From Xs_V_ConsignBill Where ConsignCode='" & Trim(LrText(2).Text) & "' and (warecode='" & Str_JudgeText & "' Or MName='" & Str_JudgeText & "')"
                    Else
                        Sqlstr = "SELECT * From xs_v_Material Where mnumber='" & Str_JudgeText & "' Or MName='" & Str_JudgeText & "'"
                    End If
                    Set RecTemp = Cw_DataEnvi.DataConnect.Execute(Sqlstr)
                    If RecTemp.EOF Then
                        If Trim(LrText(2).Text) <> "" Then
                            Tsxx = "当前发货单中不存在此货物!"
                        Else
                            Tsxx = "此货物不存在!"
                        End If
                        GoTo Lrcwcl
                    Else
                        If Trim(LrText(2).Text) = "" Then
                            If RecTemp.Fields("issale") = 0 Or RecTemp.Fields("StopFlag") = 1 Then
                                Tsxx = "此货物不具销售属性或被停用!"
                                GoTo Lrcwcl
                            End If
                        End If
                    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.放置字段事后处理程序
                    If Trim(LrText(2).Text) <> "" Then
                        .TextMatrix(Dqpdwgh, Sydz("001", GridStr(), Szzls)) = Trim(RecTemp.Fields("warecode") & "")      '货物编码
                        .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("saleUnitName"))       '单位
                        .TextMatrix(Dqpdwgh, Sydz("005", GridStr(), Szzls)) = Val(RecTemp.Fields("Recquantity") & "")    '实收数量
                        .TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls)) = Val(RecTemp.Fields("Recquantity") & "")    '退货数量
                        .TextMatrix(Dqpdwgh, Sydz("007", GridStr(), Szzls)) = Val(RecTemp.Fields("taxUnitPrice") & "")   '含税单价
                        .TextMatrix(Dqpdwgh, Sydz("008", GridStr(), Szzls)) = Val(RecTemp.Fields("taxMoney") & "")       '税额
                        .TextMatrix(Dqpdwgh, Sydz("009", GridStr(), Szzls)) = Val(RecTemp.Fields("wholeMoney") & "")     '含税金额
                        .TextMatrix(Dqpdwgh, Sydz("010", GridStr(), Szzls)) = Val(RecTemp.Fields("consignMoney") & "")   '不含税金额
                        .TextMatrix(Dqpdwgh, Sydz("011", GridStr(), Szzls)) = Trim(RecTemp.Fields("remark"))             '备注
                        .TextMatrix(Dqpdwgh, Sydz("012", GridStr(), Szzls)) = Val(RecTemp.Fields("taxrate"))             '税率
                        .TextMatrix(Dqpdwgh, Sydz("013", GridStr(), Szzls)) = Val(RecTemp.Fields("unitPrice") & "")      '不含税单价
                    Else
                        .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("PrimaryUnitName")         '单位
                        .TextMatrix(Dqpdwgh, Sydz("012", GridStr(), Szzls)) = RecTemp.Fields("cess") / 100              '税率
                    End If
                    If Trim(LrText(2).Text) = "" Then
                        If Trim(LrText(8).Text) <> "" Then
                            If Trim(LrText(8).Tag) Then
                                .TextMatrix(Dqlrwgh, Sydz("007", GridStr(), Szzls)) = RecTemp!consultprice * Val(LrText(8).Text)     '含税单价
                            Else
                                .TextMatrix(Dqlrwgh, Sydz("007", GridStr(), Szzls)) = RecTemp!consultprice / Val(LrText(8).Text)     '含税单价
                            End If
                        Else
                            .TextMatrix(Dqlrwgh, Sydz("007", GridStr(), Szzls)) = RecTemp!consultprice      '含税单价
                        End If
                    End If
                    '根据公式计算结果
                    Call Sub_JoinCount(Dqpdwgh, Sydz("007", GridStr(), Szzls))   '单价
                
                Else
                    '3.清空相关字段
                    .TextMatrix(Dqpdwgh, Sydz("001", GridStr(), Szzls)) = ""      '货物编码
                    .TextMatrix(Dqpdwgh, Sydz("002", GridStr(), Szzls)) = ""      '货物名称
                    .TextMatrix(Dqpdwgh, Sydz("003", GridStr(), Szzls)) = ""      '规格型号
                    .TextMatrix(Dqpdwgh, Sydz("004", GridStr(), Szzls)) = ""      '单位
                    .TextMatrix(Dqpdwgh, Sydz("005", GridStr(), Szzls)) = ""      '实收数量
                    .TextMatrix(Dqpdwgh, Sydz("012", GridStr(), Szzls)) = ""      '税率
                End If
                
            Case "006"          '退货数量
                '1.放置字段有效性判断
                If Not Trim(Str_JudgeText) = "" Then
                    If Val(.TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls))) < 0 Then
                        Tsxx = "退货数量必须大于等于0!"
                        Lrywlz = Sydz("006", GridStr(), Szzls)
                        GoTo Lrcwcl
                    End If
                    If Val(.TextMatrix(Dqpdwgh, Sydz("005", GridStr(), Szzls))) > 0 Then
                        If Val(.TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls))) > Val(.TextMatrix(Dqpdwgh, Sydz("005", GridStr(), Szzls))) Then
                            Tsxx = "退货数量必须小于等于实收数量!"
                            Lrywlz = Sydz("006", GridStr(), Szzls)
                            GoTo Lrcwcl
                        End If
                    End If
                    If Not IsNumeric(Trim(.TextMatrix(Dqpdwgh, Sydz("006", GridStr(), Szzls)))) Then
                        Tsxx = "数据格式有误!"
                        Lrywlz = Sydz("006", GridStr(), Szzls)
                        GoTo Lrcwcl
                    End If
                End If

                '2.放置字段事后处理程序
                Call Sub_JoinCount(Dqpdwgh, Sydz("006", GridStr(), Szzls))   '退货数量
            
            Case "007"          '含税单价
                If Not Trim(Str_JudgeText) = "" Then
                    If Val(.TextMatrix(Dqpdwgh, Sydz("007", GridStr(), Szzls))) < 0 Then
                        Tsxx = "含税单价必须大于等于0!"
                        Lrywlz = Sydz("007", GridStr(), Szzls)
                        GoTo Lrcwcl
                    End If
                    If Not IsNumeric(Trim(.TextMatrix(Dqpdwgh, Sydz("007", GridStr(), Szzls)))) Then
                        Tsxx = "数据格式有误!"
                        Lrywlz = Sydz("007", GridStr(), Szzls)
                        GoTo Lrcwcl
                    End If
                End If
                
                Call Sub_JoinCount(Dqpdwgh, Sydz("007", GridStr(), Szzls))
                
            Case "009"          '总金额
                If Not Trim(Str_JudgeText) = "" Then
                    If Val(.TextMatrix(Dqpdwgh, Sydz("009", GridStr(), Szzls))) < 0 Then
                        Tsxx = "总金额必须大于等于0!"
                        Lrywlz = Sydz("009", GridStr(), Szzls)
                        GoTo Lrcwcl
                    End If
                    If Not IsNumeric(Trim(.TextMatrix(Dqpdwgh, Sydz("009", GridStr(), Szzls)))) Then
                        Tsxx = "数据格式有误!"
                        Lrywlz = Sydz("009", GridStr(), Szzls)
                        GoTo Lrcwcl
                    End If
                End If
                
                Call Sub_JoinCount(Dqpdwgh, Sydz("009", GridStr(), Szzls))
                
            Case "010"          '无税金额
                If Not Trim(Str_JudgeText) = "" Then
                    If Val(.TextMatrix(Dqpdwgh, Sydz("010", GridStr(), Szzls))) < 0 Then
                        Tsxx = "无税金额必须大于等于0!"
                        Lrywlz = Sydz("010", GridStr(), Szzls)
                        GoTo Lrcwcl
                    End If
                    If Not IsNumeric(Trim(.TextMatrix(Dqpdwgh, Sydz("010", GridSt