merestoneaccess.vb

界桩信息管理系统代码,VB写的。。。。。。。

Imports System
Imports System.Data
Imports System.Data.OleDb.OleDbType
Imports System.Data.OleDb

Public Class MereStoneAccess
    Inherits System.ComponentModel.Component

#Region " 组件设计器生成的代码 "

    Public Sub New(ByVal Container As System.ComponentModel.IContainer)
        MyClass.New()

        'Windows.Forms 类撰写设计器支持所必需的
        Container.Add(Me)
    End Sub

    Public Sub New()
        MyBase.New()

        '该调用是组件设计器所必需的。
        InitializeComponent()
        dsConnection.ConnectionString = AppConfiguration.ConnectionString()
    End Sub

    '组件重写 dispose 以清理组件列表。
    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

    '组件设计器所必需的
    Private components As System.ComponentModel.IContainer

    '注意: 以下过程是组件设计器所必需的
    '可以使用组件设计器修改此过程。
    '不要使用代码编辑器修改它。
    Friend WithEvents loadCommand As System.Data.OleDb.OleDbCommand
    Friend WithEvents insertCommand As System.Data.OleDb.OleDbCommand
    Friend WithEvents updateCommand As System.Data.OleDb.OleDbCommand
    Friend WithEvents deleteCommand As System.Data.OleDb.OleDbCommand
    Friend WithEvents dsConnection As System.Data.OleDb.OleDbConnection
    Friend WithEvents dsCommand As System.Data.OleDb.OleDbDataAdapter
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.loadCommand = New System.Data.OleDb.OleDbCommand
        Me.insertCommand = New System.Data.OleDb.OleDbCommand
        Me.updateCommand = New System.Data.OleDb.OleDbCommand
        Me.deleteCommand = New System.Data.OleDb.OleDbCommand
        Me.dsConnection = New System.Data.OleDb.OleDbConnection
        Me.dsCommand = New System.Data.OleDb.OleDbDataAdapter
        '
        'loadCommand
        '
        Me.loadCommand.CommandText = "SELECT bw, bz, cz, dj, jzbh, jzmc, jzzfww_cfwj1, jzzfww_cfwj2, jzzfww_cfwj3, jzzf" & _
        "ww_jl1, jzzfww_jl2, jzzfww_jl3, jzzwww_mc1, jzzwww_mc2, jzzwww_mc3, lx, MAPINFO_" & _
        "ID, qt, sm FROM MereStone"
        Me.loadCommand.Connection = Me.dsConnection
        '
        'insertCommand
        '
        Me.insertCommand.CommandText = "INSERT INTO MereStone(bw, bz, cz, dj, jzbh, jzmc, jzzfww_cfwj1, jzzfww_cfwj2, jzz" & _
        "fww_cfwj3, jzzfww_jl1, jzzfww_jl2, jzzfww_jl3, jzzwww_mc1, jzzwww_mc2, jzzwww_mc" & _
        "3, lx, qt, sm) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
        Me.insertCommand.Connection = Me.dsConnection
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("bw", System.Data.OleDb.OleDbType.VarWChar, 20, "bw"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("bz", System.Data.OleDb.OleDbType.VarWChar, 254, "bz"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("cz", System.Data.OleDb.OleDbType.VarWChar, 20, "cz"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("dj", System.Data.OleDb.OleDbType.VarWChar, 20, "dj"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzbh", System.Data.OleDb.OleDbType.VarWChar, 50, "jzbh"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzmc", System.Data.OleDb.OleDbType.VarWChar, 100, "jzmc"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_cfwj1", System.Data.OleDb.OleDbType.VarWChar, 20, "jzzfww_cfwj1"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_cfwj2", System.Data.OleDb.OleDbType.VarWChar, 20, "jzzfww_cfwj2"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_cfwj3", System.Data.OleDb.OleDbType.VarWChar, 20, "jzzfww_cfwj3"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_jl1", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzfww_jl1"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_jl2", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzfww_jl2"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_jl3", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzfww_jl3"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzwww_mc1", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzwww_mc1"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzwww_mc2", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzwww_mc2"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzwww_mc3", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzwww_mc3"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("lx", System.Data.OleDb.OleDbType.VarWChar, 20, "lx"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("qt", System.Data.OleDb.OleDbType.VarWChar, 254, "qt"))
        Me.insertCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("sm", System.Data.OleDb.OleDbType.VarWChar, 254, "sm"))
        '
        'updateCommand
        '
        Me.updateCommand.CommandText = "UPDATE MereStone SET bw = ?, bz = ?, cz = ?, dj = ?, jzbh = ?, jzmc = ?, jzzfww_c" & _
        "fwj1 = ?, jzzfww_cfwj2 = ?, jzzfww_cfwj3 = ?, jzzfww_jl1 = ?, jzzfww_jl2 = ?, jz" & _
        "zfww_jl3 = ?, jzzwww_mc1 = ?, jzzwww_mc2 = ?, jzzwww_mc3 = ?, lx = ?, qt = ?, sm" & _
        " = ? WHERE (MAPINFO_ID = ?) AND (bw = ? OR ? IS NULL AND bw IS NULL) AND (bz = ?" & _
        " OR ? IS NULL AND bz IS NULL) AND (cz = ? OR ? IS NULL AND cz IS NULL) AND (dj =" & _
        " ? OR ? IS NULL AND dj IS NULL) AND (jzbh = ? OR ? IS NULL AND jzbh IS NULL) AND" & _
        " (jzmc = ? OR ? IS NULL AND jzmc IS NULL) AND (jzzfww_cfwj1 = ? OR ? IS NULL AND" & _
        " jzzfww_cfwj1 IS NULL) AND (jzzfww_cfwj2 = ? OR ? IS NULL AND jzzfww_cfwj2 IS NU" & _
        "LL) AND (jzzfww_cfwj3 = ? OR ? IS NULL AND jzzfww_cfwj3 IS NULL) AND (jzzfww_jl1" & _
        " = ? OR ? IS NULL AND jzzfww_jl1 IS NULL) AND (jzzfww_jl2 = ? OR ? IS NULL AND j" & _
        "zzfww_jl2 IS NULL) AND (jzzfww_jl3 = ? OR ? IS NULL AND jzzfww_jl3 IS NULL) AND " & _
        "(jzzwww_mc1 = ? OR ? IS NULL AND jzzwww_mc1 IS NULL) AND (jzzwww_mc2 = ? OR ? IS" & _
        " NULL AND jzzwww_mc2 IS NULL) AND (jzzwww_mc3 = ? OR ? IS NULL AND jzzwww_mc3 IS" & _
        " NULL) AND (lx = ? OR ? IS NULL AND lx IS NULL) AND (qt = ? OR ? IS NULL AND qt " & _
        "IS NULL) AND (sm = ? OR ? IS NULL AND sm IS NULL)"
        Me.updateCommand.Connection = Me.dsConnection
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("bw", System.Data.OleDb.OleDbType.VarWChar, 20, "bw"))
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("bz", System.Data.OleDb.OleDbType.VarWChar, 254, "bz"))
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("cz", System.Data.OleDb.OleDbType.VarWChar, 20, "cz"))
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("dj", System.Data.OleDb.OleDbType.VarWChar, 20, "dj"))
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzbh", System.Data.OleDb.OleDbType.VarWChar, 50, "jzbh"))
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzmc", System.Data.OleDb.OleDbType.VarWChar, 100, "jzmc"))
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_cfwj1", System.Data.OleDb.OleDbType.VarWChar, 20, "jzzfww_cfwj1"))
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_cfwj2", System.Data.OleDb.OleDbType.VarWChar, 20, "jzzfww_cfwj2"))
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_cfwj3", System.Data.OleDb.OleDbType.VarWChar, 20, "jzzfww_cfwj3"))
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_jl1", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzfww_jl1"))
        Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_jl2", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzfww_jl2"))