clientdocuments.vb

这是一个VBA开发的项目实例

Imports System.Data.OleDb
Public Class ClientDocuments
    Inherits System.Windows.Forms.Form
    Private varCompanyName As New StartApplication.ShareClass()
    Private ourConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\EasySelling\EasySelling.mdb;Persist Security Info=False"
    Private clientConnection As OleDbConnection = New OleDbConnection(ourConn)
    Private clientCommand As OleDbCommand
    Private clientDataReader As OleDbDataReader
    Friend WithEvents grpDocumentOption As System.Windows.Forms.GroupBox
    Friend WithEvents radbAnalysis As System.Windows.Forms.RadioButton
    Friend WithEvents radbPresentation As System.Windows.Forms.RadioButton
    Friend WithEvents radbProposal As System.Windows.Forms.RadioButton
    Private strSqlStatement As String
    Friend WithEvents chkbGlueStic As System.Windows.Forms.CheckBox
    Friend WithEvents chkbScotchTape As System.Windows.Forms.CheckBox
    Friend WithEvents chkbHighlighter As System.Windows.Forms.CheckBox
    Friend WithEvents chkbGelInkPen As System.Windows.Forms.CheckBox
    Friend WithEvents chkbCompPaper As System.Windows.Forms.CheckBox
    Friend WithEvents chkbCopyPaper As System.Windows.Forms.CheckBox
    Friend WithEvents ExpiryDate As System.Windows.Forms.TextBox
    Friend WithEvents ProposalDate As System.Windows.Forms.TextBox
    Private docApp As Word.Application
#Region " Windows Form Designer generated code "

    Public Sub New()
        MyBase.New()

        'This call is required by the Windows Form Designer.
        InitializeComponent()

        'Add any initialization after the InitializeComponent() call

    End Sub

    'Form overrides dispose to clean up the component list.
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub
    Friend WithEvents lblLabelFormDes As System.Windows.Forms.Label
    Friend WithEvents Button1 As System.Windows.Forms.Button
    Friend WithEvents btnUpdate As System.Windows.Forms.Button
    Friend WithEvents TabControl1 As System.Windows.Forms.TabControl
    Friend WithEvents TabPage1 As System.Windows.Forms.TabPage
    Friend WithEvents Panel1 As System.Windows.Forms.Panel
    Friend WithEvents Label2 As System.Windows.Forms.Label
    Friend WithEvents Label1 As System.Windows.Forms.Label
    Friend WithEvents lblClient_Name As System.Windows.Forms.Label

    'Required by the Windows Form Designer
    Private components As System.ComponentModel.IContainer

    'NOTE: The following procedure is required by the Windows Form Designer
    'It can be modified using the Windows Form Designer.  
    'Do not modify it using the code editor.
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.lblLabelFormDes = New System.Windows.Forms.Label()
        Me.grpDocumentOption = New System.Windows.Forms.GroupBox()
        Me.radbAnalysis = New System.Windows.Forms.RadioButton()
        Me.radbPresentation = New System.Windows.Forms.RadioButton()
        Me.radbProposal = New System.Windows.Forms.RadioButton()
        Me.Button1 = New System.Windows.Forms.Button()
        Me.btnUpdate = New System.Windows.Forms.Button()
        Me.TabControl1 = New System.Windows.Forms.TabControl()
        Me.TabPage1 = New System.Windows.Forms.TabPage()
        Me.Panel1 = New System.Windows.Forms.Panel()
        Me.chkbGlueStic = New System.Windows.Forms.CheckBox()
        Me.chkbScotchTape = New System.Windows.Forms.CheckBox()
        Me.chkbHighlighter = New System.Windows.Forms.CheckBox()
        Me.chkbGelInkPen = New System.Windows.Forms.CheckBox()
        Me.chkbCopyPaper = New System.Windows.Forms.CheckBox()
        Me.chkbCompPaper = New System.Windows.Forms.CheckBox()
        Me.Label2 = New System.Windows.Forms.Label()
        Me.Label1 = New System.Windows.Forms.Label()
        Me.ExpiryDate = New System.Windows.Forms.TextBox()
        Me.lblClient_Name = New System.Windows.Forms.Label()
        Me.ProposalDate = New System.Windows.Forms.TextBox()
        Me.grpDocumentOption.SuspendLayout()
        Me.TabControl1.SuspendLayout()
        Me.TabPage1.SuspendLayout()
        Me.Panel1.SuspendLayout()
        Me.SuspendLayout()
        '
        'lblLabelFormDes
        '
        Me.lblLabelFormDes.Font = New System.Drawing.Font("Tahoma", 9.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.lblLabelFormDes.Location = New System.Drawing.Point(21, 14)
        Me.lblLabelFormDes.Name = "lblLabelFormDes"
        Me.lblLabelFormDes.Size = New System.Drawing.Size(475, 56)
        Me.lblLabelFormDes.TabIndex = 78
        Me.lblLabelFormDes.Text = "Based on inputs stored for the Customers the following documents can be generated" & _
        ":"
        Me.lblLabelFormDes.TextAlign = System.Drawing.ContentAlignment.MiddleLeft
        '
        'grpDocumentOption
        '
        Me.grpDocumentOption.Controls.AddRange(New System.Windows.Forms.Control() {Me.radbAnalysis, Me.radbPresentation, Me.radbProposal})
        Me.grpDocumentOption.Font = New System.Drawing.Font("Tahoma", 9.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.grpDocumentOption.Location = New System.Drawing.Point(21, 78)
        Me.grpDocumentOption.Name = "grpDocumentOption"
        Me.grpDocumentOption.Size = New System.Drawing.Size(523, 130)
        Me.grpDocumentOption.TabIndex = 79
        Me.grpDocumentOption.TabStop = False
        Me.grpDocumentOption.Text = "Select a Document:"
        '
        'radbAnalysis
        '
        Me.radbAnalysis.Location = New System.Drawing.Point(64, 90)
        Me.radbAnalysis.Name = "radbAnalysis"
        Me.radbAnalysis.Size = New System.Drawing.Size(304, 24)
        Me.radbAnalysis.TabIndex = 2
        Me.radbAnalysis.Text = "Competitors Analysis Report for this Client"
        '
        'radbPresentation
        '
        Me.radbPresentation.Location = New System.Drawing.Point(64, 61)
        Me.radbPresentation.Name = "radbPresentation"
        Me.radbPresentation.Size = New System.Drawing.Size(304, 24)
        Me.radbPresentation.TabIndex = 1
        Me.radbPresentation.Text = "Presentation for Review"
        '
        'radbProposal
        '
        Me.radbProposal.Location = New System.Drawing.Point(64, 33)
        Me.radbProposal.Name = "radbProposal"
        Me.radbProposal.Size = New System.Drawing.Size(304, 24)
        Me.radbProposal.TabIndex = 0
        Me.radbProposal.Text = "Proposal for Products"
        '
        'Button1
        '
        Me.Button1.Font = New System.Drawing.Font("Tahoma", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.Button1.Location = New System.Drawing.Point(455, 413)
        Me.Button1.Name = "Button1"
        Me.Button1.Size = New System.Drawing.Size(88, 24)
        Me.Button1.TabIndex = 82
        Me.Button1.Text = "&Close"
        '
        'btnUpdate
        '
        Me.btnUpdate.Font = New System.Drawing.Font("Tahoma", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.btnUpdate.Location = New System.Drawing.Point(353, 413)
        Me.btnUpdate.Name = "btnUpdate"
        Me.btnUpdate.Size = New System.Drawing.Size(96, 24)
        Me.btnUpdate.TabIndex = 81
        Me.btnUpdate.Text = "&Proceed > >"
        '
        'TabControl1
        '
        Me.TabControl1.Controls.AddRange(New System.Windows.Forms.Control() {Me.TabPage1})
        Me.TabControl1.Font = New System.Drawing.Font("Tahoma", 9.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TabControl1.Location = New System.Drawing.Point(21, 216)
        Me.TabControl1.Name = "TabControl1"
        Me.TabControl1.SelectedIndex = 0
        Me.TabControl1.Size = New System.Drawing.Size(523, 192)
        Me.TabControl1.TabIndex = 83
        '
        'TabPage1
        '
        Me.TabPage1.Controls.AddRange(New System.Windows.Forms.Control() {Me.Panel1})
        Me.TabPage1.Font = New System.Drawing.Font("Tahoma", 9.0!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.TabPage1.Location = New System.Drawing.Point(4, 23)
        Me.TabPage1.Name = "TabPage1"
        Me.TabPage1.Size = New System.Drawing.Size(515, 165)
        Me.TabPage1.TabIndex = 0
        Me.TabPage1.Text = "More Information For Proposal"
        '
        'Panel1
        '
        Me.Panel1.BackColor = System.Drawing.Color.PowderBlue
        Me.Panel1.Controls.AddRange(New System.Windows.Forms.Control() {Me.chkbGlueStic, Me.chkbScotchTape, Me.chkbHighlighter, Me.chkbGelInkPen, Me.chkbCopyPaper, Me.chkbCompPaper, Me.Label2, Me.Label1, Me.ExpiryDate, Me.lblClient_Name, Me.ProposalDate})
        Me.Panel1.Dock = System.Windows.Forms.DockStyle.Fill
        Me.Panel1.Name = "Panel1"
        Me.Panel1.Size = New System.Drawing.Size(515, 165)
        Me.Panel1.TabIndex = 0
        '
        'chkbGlueStic
        '
        Me.chkbGlueStic.Font = New System.Drawing.Font("Tahoma", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.chkbGlueStic.Location = New System.Drawing.Point(152, 120)
        Me.chkbGlueStic.Name = "chkbGlueStic"
        Me.chkbGlueStic.Size = New System.Drawing.Size(97, 16)
        Me.chkbGlueStic.TabIndex = 71
        Me.chkbGlueStic.Text = "Glue Stic"
        '
        'chkbScotchTape
        '
        Me.chkbScotchTape.Font = New System.Drawing.Font("Tahoma", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.chkbScotchTape.Location = New System.Drawing.Point(16, 120)
        Me.chkbScotchTape.Name = "chkbScotchTape"
        Me.chkbScotchTape.Size = New System.Drawing.Size(128, 16)
        Me.chkbScotchTape.TabIndex = 70
        Me.chkbScotchTape.Text = "Scotch Tape"
        '
        'chkbHighlighter
        '
        Me.chkbHighlighter.Font = New System.Drawing.Font("Tahoma", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.chkbHighlighter.Location = New System.Drawing.Point(152, 96)
        Me.chkbHighlighter.Name = "chkbHighlighter"
        Me.chkbHighlighter.Size = New System.Drawing.Size(97, 16)
        Me.chkbHighlighter.TabIndex = 69
        Me.chkbHighlighter.Text = "HighLighter"
        '
        'chkbGelInkPen
        '
        Me.chkbGelInkPen.Font = New System.Drawing.Font("Tahoma", 8.25!, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
        Me.chkbGelInkPen.Location = New System.Drawing.Point(16, 96)
        Me.chkbGelInkPen.Name = "chkbGelInkPen"
        Me.chkbGelInkPen.Size = New System.Drawing.Size(128, 16)
        Me.chkbGelInkPen.TabIndex = 68
        Me.chkbGelInkPen.Text = "Gel Ink Pen"
        '
        'chkbCopyPaper
        '