📄 merestoneaccess.vb
字号:
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzfww_jl3", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzfww_jl3"))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzwww_mc1", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzwww_mc1"))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzwww_mc2", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzwww_mc2"))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("jzzwww_mc3", System.Data.OleDb.OleDbType.VarWChar, 30, "jzzwww_mc3"))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("lx", System.Data.OleDb.OleDbType.VarWChar, 20, "lx"))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("qt", System.Data.OleDb.OleDbType.VarWChar, 254, "qt"))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("sm", System.Data.OleDb.OleDbType.VarWChar, 254, "sm"))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_MAPINFO_ID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "MAPINFO_ID", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_bw", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bw", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_bw1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bw", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_bz", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bz", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_bz1", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bz", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_cz", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "cz", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_cz1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "cz", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_dj", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "dj", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_dj1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "dj", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzbh", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzbh", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzbh1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzbh", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzmc", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzmc", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzmc1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzmc", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj1", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj11", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj1", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj2", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj2", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj21", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj2", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj3", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj3", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj31", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj3", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl1", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl11", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl1", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl2", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl2", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl21", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl2", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl3", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl3", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl31", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl3", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc1", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc11", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc1", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc2", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc2", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc21", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc2", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc3", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc3", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc31", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc3", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_lx", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "lx", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_lx1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "lx", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_qt", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "qt", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_qt1", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "qt", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_sm", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "sm", System.Data.DataRowVersion.Original, Nothing))
Me.updateCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_sm1", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "sm", System.Data.DataRowVersion.Original, Nothing))
'
'deleteCommand
'
Me.deleteCommand.CommandText = "DELETE FROM MereStone WHERE (MAPINFO_ID = ?) AND (bw = ? OR ? IS NULL AND bw IS N" & _
"ULL) 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 j" & _
"zbh 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 jz" & _
"zfww_cfwj2 IS NULL) 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 jzzfww_jl2 IS NULL) AND (jzzfww_jl3 = ? OR ? IS NULL AND jzzfww_j" & _
"l3 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 A" & _
"ND 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.deleteCommand.Connection = Me.dsConnection
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_MAPINFO_ID", System.Data.OleDb.OleDbType.Integer, 0, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "MAPINFO_ID", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_bw", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bw", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_bw1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bw", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_bz", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bz", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_bz1", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bz", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_cz", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "cz", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_cz1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "cz", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_dj", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "dj", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_dj1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "dj", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzbh", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzbh", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzbh1", System.Data.OleDb.OleDbType.VarWChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzbh", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzmc", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzmc", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzmc1", System.Data.OleDb.OleDbType.VarWChar, 100, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzmc", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj1", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj11", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj1", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj2", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj2", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj21", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj2", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj3", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj3", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_cfwj31", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_cfwj3", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl1", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl11", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl1", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl2", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl2", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl21", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl2", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl3", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl3", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzfww_jl31", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzfww_jl3", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc1", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc1", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc11", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc1", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc2", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc2", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc21", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc2", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc3", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc3", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_jzzwww_mc31", System.Data.OleDb.OleDbType.VarWChar, 30, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "jzzwww_mc3", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_lx", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "lx", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_lx1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "lx", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_qt", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "qt", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_qt1", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "qt", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_sm", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "sm", System.Data.DataRowVersion.Original, Nothing))
Me.deleteCommand.Parameters.Add(New System.Data.OleDb.OleDbParameter("Original_sm1", System.Data.OleDb.OleDbType.VarWChar, 254, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "sm", System.Data.DataRowVersion.Original, Nothing))
'
'dsConnection
'
Me.dsConnection.ConnectionString = "Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database L" & _
"ocking Mode=1;Data Source=""D:\Me_Sky\定陶界桩\MereStone\bin\merestone.mdb"";Jet OLEDB" & _
":Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet" & _
" OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Den" & _
"y None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;J" & _
"et OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Re" & _
"pair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1"
'
'dsCommand
'
Me.dsCommand.DeleteCommand = Me.deleteCommand
Me.dsCommand.InsertCommand = Me.insertCommand
Me.dsCommand.SelectCommand = Me.loadCommand
Me.dsCommand.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "MereStone", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("bw", "bw"), New System.Data.Common.DataColumnMapping("bz", "bz"), New System.Data.Common.DataColumnMapping("cz", "cz"), New System.Data.Common.DataColumnMapping("dj", "dj"), New System.Data.Common.DataColumnMapping("jzbh", "jzbh"), New System.Data.Common.DataColumnMapping("jzmc", "jzmc"), New System.Data.Common.DataColumnMapping("jzzfww_cfwj1", "jzzfww_cfwj1"), New System.Data.Common.DataColumnMapping("jzzfww_cfwj2", "jzzfww_cfwj2"), New System.Data.Common.DataColumnMapping("jzzfww_cfwj3", "jzzfww_cfwj3"), New System.Data.Common.DataColumnMapping("jzzfww_jl1", "jzzfww_jl1"), New System.Data.Common.DataColumnMapping("jzzfww_jl2", "jzzfww_jl2"), New System.Data.Common.DataColumnMapping("jzzfww_jl3", "jzzfww_jl3"), New System.Data.Common.DataColumnMapping("jzzwww_mc1", "jzzwww_mc1"), New System.Data.Common.DataColumnMapping("jzzwww_mc2", "jzzwww_mc2"), New System.Data.Common.DataColumnMapping("jzzwww_mc3", "jzzwww_mc3"), New System.Data.Common.DataColumnMapping("lx", "lx"), New System.Data.Common.DataColumnMapping("MAPINFO_ID", "MAPINFO_ID"), New System.Data.Common.DataColumnMapping("qt", "qt"), New System.Data.Common.DataColumnMapping("sm", "sm")})})
Me.dsCommand.UpdateCommand = Me.updateCommand
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -