qg_zongjingli_shenpi.vb

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

        '
        'TextBox8
        '
        Me.TextBox8.Location = New System.Drawing.Point(536, 184)
        Me.TextBox8.Name = "TextBox8"
        Me.TextBox8.Size = New System.Drawing.Size(104, 21)
        Me.TextBox8.TabIndex = 176
        Me.TextBox8.Text = "TextBox8"
        '
        'Label18
        '
        Me.Label18.ForeColor = System.Drawing.Color.Red
        Me.Label18.Location = New System.Drawing.Point(464, 184)
        Me.Label18.Name = "Label18"
        Me.Label18.Size = New System.Drawing.Size(56, 16)
        Me.Label18.TabIndex = 175
        Me.Label18.Text = "优惠金额"
        '
        'qg_zongjingli_shenpi
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(880, 582)
        Me.Controls.Add(Me.TextBox8)
        Me.Controls.Add(Me.Label18)
        Me.Controls.Add(Me.ComboBox6)
        Me.Controls.Add(Me.RadioButton3)
        Me.Controls.Add(Me.TextBox7)
        Me.Controls.Add(Me.Label1)
        Me.Controls.Add(Me.Label17)
        Me.Controls.Add(Me.TextBox12)
        Me.Controls.Add(Me.Label15)
        Me.Controls.Add(Me.TextBox10)
        Me.Controls.Add(Me.Label14)
        Me.Controls.Add(Me.GroupBox4)
        Me.Controls.Add(Me.Label4)
        Me.Controls.Add(Me.TextBox200)
        Me.Controls.Add(Me.ComboBox8)
        Me.Controls.Add(Me.Label3)
        Me.Controls.Add(Me.TextBox100)
        Me.Controls.Add(Me.Label2)
        Me.Controls.Add(Me.GroupBox2)
        Me.Controls.Add(Me.TextBox6)
        Me.Controls.Add(Me.DataGrid2)
        Me.Controls.Add(Me.TextBox5)
        Me.Controls.Add(Me.Label10)
        Me.Controls.Add(Me.TextBox4)
        Me.Controls.Add(Me.Label9)
        Me.Controls.Add(Me.ComboBox3)
        Me.Controls.Add(Me.RadioButton2)
        Me.Controls.Add(Me.DataGrid1)
        Me.Controls.Add(Me.ComboBox2)
        Me.Controls.Add(Me.ComboBox1)
        Me.Controls.Add(Me.TextBox2)
        Me.Controls.Add(Me.RadioButton1)
        Me.Controls.Add(Me.Label5)
        Me.Controls.Add(Me.Label6)
        Me.Controls.Add(Me.GroupBox3)
        Me.Controls.Add(Me.Label16)
        Me.Controls.Add(Me.ComboBox4)
        Me.Controls.Add(Me.GroupBox1)
        Me.MaximizeBox = False
        Me.Name = "qg_zongjingli_shenpi"
        Me.Text = "总经理采购审批"
        Me.GroupBox2.ResumeLayout(False)
        CType(Me.DataGrid2, System.ComponentModel.ISupportInitialize).EndInit()
        CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).EndInit()
        Me.GroupBox3.ResumeLayout(False)
        Me.ResumeLayout(False)

    End Sub

#End Region
    Dim lirong As String '物品名称
    Dim lirong1 As String '当dagrid改变时候的物品的名称
    Dim lirong2 As String ''当dagrid改变时候的物品的CD3+4编码
   
    '得到待填写的工程编号
    Private Sub gongchengbianhao()
        Dim mystr As String
        Dim mydataset As New DataSet
        mystr = "select 工程编号 from technologyInf where 请购过程标志 =" + Chr(39) + "1" + Chr(39) + " and 预算过程标志=" + Chr(39) + "6" + Chr(39)
        mydataset = GetDataFromDB(mystr)


        Dim i As Integer
        Dim y As Integer = mydataset.Tables(0).Rows.Count
        Dim str As String
        ComboBox2.Items.Clear()
        For i = 0 To (y - 1)
            str = mydataset.Tables(0).Rows(i)("工程编号")
            str = str.Trim
            ComboBox2.Items.Add(str)
        Next
        mydataset.Dispose()

    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
        End If


        Dim str As String
        str = "select 编号,[CD3+4编码],物品名称,参数,数量,[供应商（一）名称],[供应商（一）单价],[供应商（一）金额],[供应商（二）名称],[供应商（二）单价],[供应商（二）金额],[供应商（三）名称],[供应商（三）单价],[供应商（三）金额],[供应商（四）名称],[供应商（四）单价],[供应商（四）金额]  from cq_huowu_xiangxiqingkuangbiao  where 采购单编号=" + Chr(39) + ssstr + Chr(39)
        Dim mydataset As New DataSet
        mydataset = GetDataFromDB(str)
        Me.DataGrid1.DataSource = mydataset
        mydataset.Dispose()
    End Sub

    '根据TextBox17，显示物品录入窗口

    Private Sub TextBox17_DoubleClick(ByVal sender As System.Object, ByVal e As System.EventArgs)
        If MsgBox("供应商是否已经正确选择？", MsgBoxStyle.OKCancel, "确认？") = MsgBoxResult.Cancel Then
            Exit Sub

        End If

        qg_pub_gongyingshang = ComboBox4.Text.Trim
        If RadioButton2.Checked = False Then

        Else
            qg_pub_str = ComboBox3.Text.Trim
        End If
        If qg_pub_str = "现有订购单" Then
            MsgBox("请选择订购单编号！", MsgBoxStyle.Information, "提示")
            Exit Sub
        End If


        Dim myform As New qg_caigoubuwenyuanluru
        myform.Show()
        Me.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中显示现在有的请购单




            DataGrid1.Enabled = True
            ComboBox3.Text = "待审批订购单"
        End If
    End Sub


    '在ComboBox3上显示所有正在录入的请购编号
    Private Sub xianshiqinggoudan_cmb3()
        Dim str As String = "select 采购单编号 from dinggou_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 dinggou_zongbiao where  采购单编号 =" + Chr(39) + ComboBox3.Text.Trim + Chr(39) + " and 是否为退回 =" + Chr(39) + "1" + Chr(39)
            Dim mydataset As New DataSet
            mydataset = GetDataFromDB(mystr)
            If GetDataFromDB(mystr).Tables(0).Rows.Count <> 0 Then
                MsgBox("此为退回采购单！", MsgBoxStyle.Information, "提示")

            End If


            mydataset.Dispose()
        End If
        xianzhiqinggoudanzhudanneirong() '显示请购单主单内容
        xianshigongyingshang_mingcheng() '显示每个采购单的所有已经填写的供应商名称

    End Sub


    '显示每个采购单的所有已经填写的供应商名称
    Private Sub xianshigongyingshang_mingcheng()
        Dim str As String
        Dim mystr As String
        Dim mydataset As New DataSet
        Dim i, y, h, x As Integer
        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 = ComboBox6.Text.Trim

        End If
        str = "select 供应商名称 from dinggou_cailiao_baojiadan where 采购单编号 = " + Chr(39) + ssstr + Chr(39)
        mydataset = GetDataFromDB(str)
        y = mydataset.Tables(0).Rows.Count
        If y = 0 Then
            mydataset.Clear()
            DataGrid1.DataSource = mydataset
        End If
        ComboBox4.Items.Clear()
        For i = 0 To y - 1
            x = ComboBox4.Items.Count

            mystr = Trim(mydataset.Tables(0).Rows(i)("供应商名称"))

            If x = 0 Then
                ComboBox4.Items.Add(mystr)
            Else

                For h = 0 To x - 1
                    ComboBox4.SelectedIndex = h
                    If ComboBox4.Text.Trim = mystr Then
                        Exit For
                    Else
                        If h = x - 1 Then
                            ComboBox4.Items.Add(mystr)
                        End If
                    End If

                Next

                ' If ComboBox4.Items.IndexOf(mystr) <> 0 Then
                ' ComboBox4.Items.Add(mystr)

                '  End If  
            End If
        Next
    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 = ComboBox6.Text.Trim

        End If
        Dim str As String
        str = "select * from dinggou_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)("工程编号")
        TextBox2.Text = mydataset.Tables(0).Rows(0)("工程名称")
        TextBox10.Text = mydataset.Tables(0).Rows(0)("送货地点")

        DateTimePicker1.Value = mydataset.Tables(0).Rows(0)("订购日期")
        ComboBox5.Text = mydataset.Tables(0).Rows(0)("是否含运费")
        TextBox1.Text = mydataset.Tables(0).Rows(0)("发票方式")
        DateTimePicker2.Value = mydataset.Tables(0).Rows(0)("需货日期")
        TextBox3.Text = mydataset.Tables(0).Rows(0)("付款方式")
        TextBox10.Text = mydataset.Tables(0).Rows(0)("送货地点")
        TextBox4.Text = mydataset.Tables(0).Rows(0)("工地收货人")
        TextBox5.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 dinggou_zongbiao where 流程 = " + Chr(39) + "3" + 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.ComboBox1.Items.Clear()
            For i = 0 To (y - 1)
                Dim sstr As String = Trim(mydataset.Tables(0).Rows(i)("采购单编号"))
                ComboBox1.Items.Add(sstr)
            Next