qg_fengongsishenpi.vb

本软件设计为在"采购部""工程部""财务部""总经理"等部门之间的采购审核流转等事宜

        Me.Label2.Size = New System.Drawing.Size(56, 16)
        Me.Label2.TabIndex = 70
        Me.Label2.Text = "密    码"
        '
        'Label4
        '
        Me.Label4.Location = New System.Drawing.Point(8, 264)
        Me.Label4.Name = "Label4"
        Me.Label4.Size = New System.Drawing.Size(56, 16)
        Me.Label4.TabIndex = 74
        Me.Label4.Text = "审批意见"
        '
        'TextBox2
        '
        Me.TextBox2.Location = New System.Drawing.Point(72, 264)
        Me.TextBox2.Name = "TextBox2"
        Me.TextBox2.Size = New System.Drawing.Size(64, 21)
        Me.TextBox2.TabIndex = 75
        Me.TextBox2.Text = ""
        '
        'Label3
        '
        Me.Label3.Location = New System.Drawing.Point(8, 336)
        Me.Label3.Name = "Label3"
        Me.Label3.Size = New System.Drawing.Size(56, 16)
        Me.Label3.TabIndex = 72
        Me.Label3.Text = "审批结果"
        '
        'ComboBox8
        '
        Me.ComboBox8.Items.AddRange(New Object() {"同意", "不同意"})
        Me.ComboBox8.Location = New System.Drawing.Point(72, 336)
        Me.ComboBox8.Name = "ComboBox8"
        Me.ComboBox8.Size = New System.Drawing.Size(64, 20)
        Me.ComboBox8.TabIndex = 73
        Me.ComboBox8.Text = "同意"
        '
        'Button3
        '
        Me.Button3.Image = CType(resources.GetObject("Button3.Image"), System.Drawing.Image)
        Me.Button3.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft
        Me.Button3.Location = New System.Drawing.Point(32, 392)
        Me.Button3.Name = "Button3"
        Me.Button3.Size = New System.Drawing.Size(80, 32)
        Me.Button3.TabIndex = 76
        Me.Button3.Tag = ""
        Me.Button3.Text = "提  交"
        Me.Button3.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'Button1
        '
        Me.Button1.Image = CType(resources.GetObject("Button1.Image"), System.Drawing.Image)
        Me.Button1.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft
        Me.Button1.Location = New System.Drawing.Point(32, 448)
        Me.Button1.Name = "Button1"
        Me.Button1.Size = New System.Drawing.Size(80, 32)
        Me.Button1.TabIndex = 81
        Me.Button1.Tag = ""
        Me.Button1.Text = "预  览"
        Me.Button1.TextAlign = System.Drawing.ContentAlignment.MiddleRight
        '
        'qg_fengongsishenpi
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(840, 550)
        Me.Controls.Add(Me.RadioButton1)
        Me.Controls.Add(Me.Label6)
        Me.Controls.Add(Me.ComboBox4)
        Me.Controls.Add(Me.RadioButton3)
        Me.Controls.Add(Me.Label5)
        Me.Controls.Add(Me.DataGrid2)
        Me.Controls.Add(Me.RadioButton2)
        Me.Controls.Add(Me.ComboBox3)
        Me.Controls.Add(Me.DataGrid1)
        Me.Controls.Add(Me.ComboBox2)
        Me.Controls.Add(Me.TextBox16)
        Me.Controls.Add(Me.Label19)
        Me.Controls.Add(Me.TextBox3)
        Me.Controls.Add(Me.GroupBox3)
        Me.Controls.Add(Me.GroupBox2)
        Me.Controls.Add(Me.GroupBox1)
        Me.MaximizeBox = False
        Me.Name = "qg_fengongsishenpi"
        Me.Text = "分公司经理审批"
        Me.GroupBox1.ResumeLayout(False)
        CType(Me.DataGrid2, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).EndInit()
        Me.GroupBox3.ResumeLayout(False)
        Me.GroupBox2.ResumeLayout(False)
        Me.ResumeLayout(False)

    End Sub

#End Region

    
    '改变“提交”按钮的text，为“退回”
    Private Sub ComboBox8_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox8.SelectedIndexChanged
        If ComboBox8.Text = "不同意" Then
            Button3.Text = "退  回"
        Else
            Button3.Text = "提  交"
        End If
    End Sub

    '本窗体的load事件
    Private Sub qg_fengongsishenpi_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load


        TextBox9.Text = UserName
    End Sub


    '提交给下面一级操作，或者退回
    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
        '判断用户提交的合法性
        Dim mystr As String = TextBox1.Text.Trim
        Dim str As String = "select user_pwd from UserInfo where user_id =" + Chr(39) + user_id_yj.Trim + Chr(39) + " and user_pwd =" + Chr(39) + mystr + Chr(39)

        If GetDataFromDB(str).Tables(0).Rows.Count = 0 Then
            MsgBox("您的密码错误,请重新输入！", MsgBoxStyle.Information, "提示")
            TextBox1.Text = ""
            TextBox1.Focus()
            Exit Sub
        End If


        If RadioButton2.Checked = False Or ComboBox1.Text.Trim = "待处理请购单" Then
            MsgBox("现在不能提交，请选择要提交的工程编号！", MsgBoxStyle.Information, "提示")
            Exit Sub
        End If


        '提交过程或者退回操作
        If ComboBox8.Text.Trim = "同意" Then
            If MsgBox("注意：请再好好复查一下，如果确定无误后再提交，提交后您将不能再进行修改了。你确定要提交吗？", MsgBoxStyle.OKCancel, "提示") = MsgBoxResult.OK Then
                Dim sqlstr As String
                Dim mysqlstr As String
                sqlstr = "UPDATE qinggou_zongbiao SET  分公司经理审批时间=" + Chr(39) + Now.Date.ToString + Chr(39) + " , 分公司经理 =" + Chr(39) + UserName + Chr(39) + ",分公司经理审批意见=" + Chr(39) + TextBox2.Text.Trim + Chr(39) + ",分公司经理审批结果=" + Chr(39) + ComboBox8.Text.Trim + Chr(39) + ",流程=" + Chr(39) + "3" + Chr(39) + ",是否为退回=" + Chr(39) + "0" + Chr(39) + "where 请购单编号=" + Chr(39) + ComboBox3.Text.Trim + Chr(39)

                If UpdateData(sqlstr) = True Then
                    MsgBox("已经成功提交了该请购资料", MsgBoxStyle.OKOnly + _
                    MsgBoxStyle.Exclamation, "提示")
                    Me.RadioButton2.Checked = True
                Else
                    MsgBox("没能成功提交该请购资料，请与管理员联系", MsgBoxStyle.OKOnly + _
                                MsgBoxStyle.Exclamation, "提示")
                    Exit Sub
                End If
            Else
                Exit Sub
            End If
        Else
            If MsgBox("您确定不同意该请购单要退回重新处理吗？", MsgBoxStyle.OKCancel, "提示") = MsgBoxResult.OK Then

                Dim sqlstr As String
                sqlstr = "UPDATE qinggou_zongbiao SET  分公司经理审批时间=" + Chr(39) + Now.Date.ToString + Chr(39) + " , 分公司经理 =" + Chr(39) + UserName + Chr(39) + ",分公司经理审批意见=" + Chr(39) + TextBox2.Text.Trim + Chr(39) + ",分公司经理审批结果=" + Chr(39) + ComboBox8.Text.Trim + Chr(39) + ",流程=" + Chr(39) + "0" + Chr(39) + ", 是否为退回=" + Chr(39) + "1" + Chr(39) + "where 请购单编号=" + Chr(39) + ComboBox3.Text.Trim + Chr(39)
                If UpdateData(sqlstr) = True Then
                    MsgBox("您已经退回了该请购单！", MsgBoxStyle.Information, "提示")
                    Exit Sub
                End If
            Else
                MsgBox("请确认后重新提交该请购单！", MsgBoxStyle.Information, "提示")
                Exit Sub
            End If



        End If

    End Sub


    '显示已有请购单的请购内容
    Private Sub xianshicailiaoxinxi()
        Dim ssstr As String
        If RadioButton2.Checked = True Then
            ssstr = ComboBox3.Text.Trim
        ElseIf RadioButton1.Checked = True Then
            ssstr = ComboBox1.Text.Trim
        ElseIf RadioButton3.Checked = True Then
            ssstr = ComboBox4.Text.Trim
        End If


        Dim str As String
        str = "select 编号,费用编码,[CD1+2编码],[CD3+4编码],物品名称,参数,数量 from qg_huowu_xiangxiqingkuang  where 请购单编号=" + Chr(39) + ssstr + Chr(39)
        Dim mydataset As New DataSet
        mydataset = GetDataFromDB(str)
        Me.DataGrid1.DataSource = mydataset
        mydataset.Dispose()
    End Sub



    '在ComboBox3中显示现在有的请购单
    Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged
        If RadioButton2.Checked = True Then
            xianshiqinggoudan_cmb3() '在ComboBox3中显示现在有的请购单

            TextBox16.Enabled = False
            DataGrid1.Enabled = True
            ComboBox3.Text = "待处理请购单"
        End If
    End Sub


    '在ComboBox3上显示所有正在录入的请购编号
    Private Sub xianshiqinggoudan_cmb3()
        Dim str As String = "select 请购单编号 from qinggou_zongbiao where 流程 = " + Chr(39) + "2" + Chr(39)
        Dim mydataset As New DataSet
        mydataset = GetDataFromDB(str)
        Dim i As Integer = 0
        Dim y As Integer = mydataset.Tables(0).Rows.Count
        Me.ComboBox3.Items.Clear()
        For i = 0 To (y - 1)
            Dim sstr As String = Trim(mydataset.Tables(0).Rows(i)("请购单编号"))
            ComboBox3.Items.Add(sstr)
        Next
        mydataset.Dispose()
    End Sub


    '根据请购单编号，显示请购单的内容
    Private Sub ComboBox3_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox3.SelectedIndexChanged
        '判断是否是退回审批
        If Me.RadioButton2.Checked = True Then
            Dim mystr As String
            mystr = "select * from qinggou_zongbiao where  请购单编号 =" + Chr(39) + ComboBox3.Text.Trim + Chr(39) + " and 是否为退回 =" + "1"
            Dim mydataset As New DataSet
            mydataset = GetDataFromDB(mystr)

            If mydataset.Tables(0).Rows.Count <> 0 Then
                MsgBox("注意：该请购单是退回请购单！", MsgBoxStyle.Information, "提示")

            End If
            mydataset.Dispose()
        End If
        xianshicailiaoxinxi() '根据请购单编号，显示请购单的内容
        xianzhiqinggoudanzhudanneirong() '显示请购单主单内容
    End Sub

    '显示请购单主单内容
    Private Sub xianzhiqinggoudanzhudanneirong()
        Dim ssstr As String
        If RadioButton2.Checked = True Then
            ssstr = ComboBox3.Text.Trim
        ElseIf RadioButton1.Checked = True Then
            ssstr = ComboBox1.Text.Trim
        ElseIf RadioButton3.Checked = True Then
            ssstr = ComboBox4.Text.Trim
        End If
        Dim str As String
        str = "select * from qinggou_zongbiao where 请购单编号=" + Chr(39) + ssstr + Chr(39)
        Dim mydataset As New DataSet
        mydataset = GetDataFromDB(str)

        DataGrid2.DataSource = mydataset

        ComboBox2.Text = mydataset.Tables(0).Rows(0)("工程编号")
        TextBox3.Text = mydataset.Tables(0).Rows(0)("工程名称")

        TextBox10.Text = mydataset.Tables(0).Rows(0)("送货地点")
        TextBox12.Text = mydataset.Tables(0).Rows(0)("其它事项")
        mydataset.Dispose()
    End Sub



    '已经提交请购单
    Private Sub RadioButton1_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton1.CheckedChanged
        If RadioButton1.Checked = True Then
            ComboBox1.Text = "已提交请购单"


            Dim str As String
            str = "select 请购单编号 from qinggou_zongbiao where 流程 = 3" + "and 是否分离 = 0"
            Dim mydataset As New DataSet
            mydataset = GetDataFromDB(str)


            Dim i As Integer = 0
            Dim y As Integer = mydataset.Tables(0).Rows.Count
            Me.ComboBox1.Items.Clear()
            For i = 0 To (y - 1)
                Dim sstr As String = Trim(mydataset.Tables(0).Rows(i)("请购单编号"))
                ComboBox1.Items.Add(sstr)
            Next
            mydataset.Dispose()
        End If
    End Sub



    '改变已提交请购编号，显示详细的请购信息
    Private Sub ComboBox1_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox1.SelectedIndexChanged
        If ComboBox1.Text.Trim = "已提交请购单" Then
            Exit Sub

        End If
        xianzhiqinggoudanzhudanneirong() '显示请购单内容
        xianshicailiaoxinxi() '根据请购单编号，显示请购单的内容
    End Sub

    '得到采购部门已经分离的请购单
    Private Sub RadioButton3_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton3.CheckedChanged
        If RadioButton3.Checked = True Then
            ComboBox3.Text = "采购部收到的请购单"


            Dim str As String
            str = "select 请购单编号 from qinggou_zongbiao where 是否分离 = 1 "
            Dim mydataset As New DataSet
            mydataset = GetDataFromDB(str)


            Dim i As Integer = 0
            Dim y As Integer = mydataset.Tables(0).Rows.Count
            Me.ComboBox4.Items.Clear()
            For i = 0 To (y - 1)
                Dim sstr As String = Trim(mydataset.Tables(0).Rows(i)("请购单编号"))
                ComboBox4.Items.Add(sstr)
            Next
            mydataset.Dispose()
        End If
    End Sub

    Private Sub ComboBox4_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox4.SelectedIndexChanged
        If ComboBox4.Text.Trim = "采购部收到的请购单" Then
            Exit Sub

        End If
        xianzhiqinggoudanzhudanneirong() '显示请购单内容
        xianshicailiaoxinxi() '根据请购单编号，显示请购单的内容
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        If RadioButton2.Checked = False Or ComboBox3.Text = "待处理请购单" Then
            MsgBox("请选择要提交的请购单号！", MsgBoxStyle.Information, "提示！")
            Exit Sub
        End If
        baobiao_str = ComboBox3.Text.Trim
        '显示报表
        Dim myform As New qg_baobiao
        myform.Show()

    End Sub
End Class