📄 dailydataset.designer.vb
字号:
End Try
End Get
Set
Me(Me.tableLook_Config.FontColumn) = value
End Set
End Property
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Property F_Size() As Short
Get
Try
Return CType(Me(Me.tableLook_Config.F_SizeColumn),Short)
Catch e As System.InvalidCastException
Throw New System.Data.StrongTypingException("表““Look_Config””中列““F_Size””的值为 DBNull。", e)
End Try
End Get
Set
Me(Me.tableLook_Config.F_SizeColumn) = value
End Set
End Property
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Property Backcolor() As Double
Get
Try
Return CType(Me(Me.tableLook_Config.BackcolorColumn),Double)
Catch e As System.InvalidCastException
Throw New System.Data.StrongTypingException("表““Look_Config””中列““Backcolor””的值为 DBNull。", e)
End Try
End Get
Set
Me(Me.tableLook_Config.BackcolorColumn) = value
End Set
End Property
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Function IsFontNull() As Boolean
Return Me.IsNull(Me.tableLook_Config.FontColumn)
End Function
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Sub SetFontNull()
Me(Me.tableLook_Config.FontColumn) = System.Convert.DBNull
End Sub
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Function IsF_SizeNull() As Boolean
Return Me.IsNull(Me.tableLook_Config.F_SizeColumn)
End Function
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Sub SetF_SizeNull()
Me(Me.tableLook_Config.F_SizeColumn) = System.Convert.DBNull
End Sub
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Function IsBackcolorNull() As Boolean
Return Me.IsNull(Me.tableLook_Config.BackcolorColumn)
End Function
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Sub SetBackcolorNull()
Me(Me.tableLook_Config.BackcolorColumn) = System.Convert.DBNull
End Sub
End Class
Public Class DailyRowChangeEvent
Inherits System.EventArgs
Private eventRow As DailyRow
Private eventAction As System.Data.DataRowAction
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Sub New(ByVal row As DailyRow, ByVal action As System.Data.DataRowAction)
MyBase.New
Me.eventRow = row
Me.eventAction = action
End Sub
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public ReadOnly Property Row() As DailyRow
Get
Return Me.eventRow
End Get
End Property
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public ReadOnly Property Action() As System.Data.DataRowAction
Get
Return Me.eventAction
End Get
End Property
End Class
Public Class Look_ConfigRowChangeEvent
Inherits System.EventArgs
Private eventRow As Look_ConfigRow
Private eventAction As System.Data.DataRowAction
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Sub New(ByVal row As Look_ConfigRow, ByVal action As System.Data.DataRowAction)
MyBase.New
Me.eventRow = row
Me.eventAction = action
End Sub
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public ReadOnly Property Row() As Look_ConfigRow
Get
Return Me.eventRow
End Get
End Property
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public ReadOnly Property Action() As System.Data.DataRowAction
Get
Return Me.eventAction
End Get
End Property
End Class
End Class
Namespace dailyDataSetTableAdapters
<System.ComponentModel.DesignerCategoryAttribute("code"), _
System.ComponentModel.DataObjectAttribute(true)> _
Partial Public Class DailyTableAdapter
Inherits System.ComponentModel.Component
Private WithEvents _adapter As System.Data.SqlServerCe.SqlCeDataAdapter
Private _connection As System.Data.SqlServerCe.SqlCeConnection
Private _commandCollection() As System.Data.SqlServerCe.SqlCeCommand
Private _clearBeforeFill As Boolean
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Sub New()
MyBase.New
Me.ClearBeforeFill = true
End Sub
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Private ReadOnly Property Adapter() As System.Data.SqlServerCe.SqlCeDataAdapter
Get
If (Me._adapter Is Nothing) Then
Me.InitAdapter
End If
Return Me._adapter
End Get
End Property
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Friend Property Connection() As System.Data.SqlServerCe.SqlCeConnection
Get
If (Me._connection Is Nothing) Then
Me.InitConnection
End If
Return Me._connection
End Get
Set
Me._connection = value
If (Not (Me.Adapter.InsertCommand) Is Nothing) Then
Me.Adapter.InsertCommand.Connection = value
End If
If (Not (Me.Adapter.DeleteCommand) Is Nothing) Then
Me.Adapter.DeleteCommand.Connection = value
End If
If (Not (Me.Adapter.UpdateCommand) Is Nothing) Then
Me.Adapter.UpdateCommand.Connection = value
End If
Dim i As Integer = 0
Do While (i < Me.CommandCollection.Length)
If (Not (Me.CommandCollection(i)) Is Nothing) Then
CType(Me.CommandCollection(i),System.Data.SqlServerCe.SqlCeCommand).Connection = value
End If
i = (i + 1)
Loop
End Set
End Property
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Protected ReadOnly Property CommandCollection() As System.Data.SqlServerCe.SqlCeCommand()
Get
If (Me._commandCollection Is Nothing) Then
Me.InitCommandCollection
End If
Return Me._commandCollection
End Get
End Property
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Public Property ClearBeforeFill() As Boolean
Get
Return Me._clearBeforeFill
End Get
Set
Me._clearBeforeFill = value
End Set
End Property
<System.Diagnostics.DebuggerNonUserCodeAttribute()> _
Private Sub InitAdapter()
Me._adapter = New System.Data.SqlServerCe.SqlCeDataAdapter
Dim tableMapping As System.Data.Common.DataTableMapping = New System.Data.Common.DataTableMapping
tableMapping.SourceTable = "Table"
tableMapping.DataSetTable = "Daily"
tableMapping.ColumnMappings.Add("W_year", "W_year")
tableMapping.ColumnMappings.Add("W_month", "W_month")
tableMapping.ColumnMappings.Add("w_day", "w_day")
tableMapping.ColumnMappings.Add("Weather", "Weather")
tableMapping.ColumnMappings.Add("R_time", "R_time")
tableMapping.ColumnMappings.Add("M_daily", "M_daily")
tableMapping.ColumnMappings.Add("M_ID", "M_ID")
tableMapping.ColumnMappings.Add("M_mood", "M_mood")
Me._adapter.TableMappings.Add(tableMapping)
Me._adapter.DeleteCommand = New System.Data.SqlServerCe.SqlCeCommand
Me._adapter.DeleteCommand.Connection = Me.Connection
Me._adapter.DeleteCommand.CommandText = "DELETE FROM [Daily] WHERE (([M_ID] = @p1))"
Me._adapter.DeleteCommand.CommandType = System.Data.CommandType.Text
Dim param As System.Data.SqlServerCe.SqlCeParameter = New System.Data.SqlServerCe.SqlCeParameter
param.ParameterName = "@p1"
param.DbType = System.Data.DbType.Int32
param.IsNullable = true
param.SourceColumn = "M_ID"
param.SourceVersion = System.Data.DataRowVersion.Original
Me._adapter.DeleteCommand.Parameters.Add(param)
Me._adapter.InsertCommand = New System.Data.SqlServerCe.SqlCeCommand
Me._adapter.InsertCommand.Connection = Me.Connection
Me._adapter.InsertCommand.CommandText = "INSERT INTO [Daily] ([W_year], [W_month], [w_day], [Weather], [R_time], [M_daily]"& _
", [M_mood]) VALUES (@p1, @p2, @p3, @p4, @p5, @p6, @p7)"
Me._adapter.InsertCommand.CommandType = System.Data.CommandType.Text
param = New System.Data.SqlServerCe.SqlCeParameter
param.ParameterName = "@p1"
param.DbType = System.Data.DbType.Int32
param.IsNullable = true
param.SourceColumn = "W_year"
Me._adapter.InsertCommand.Parameters.Add(param)
param = New System.Data.SqlServerCe.SqlCeParameter
param.ParameterName = "@p2"
param.DbType = System.Data.DbType.Int32
param.IsNullable = true
param.SourceColumn = "W_month"
Me._adapter.InsertCommand.Parameters.Add(param)
param = New System.Data.SqlServerCe.SqlCeParameter
param.ParameterName = "@p3"
param.DbType = System.Data.DbType.Int32
param.IsNullable = true
param.SourceColumn = "w_day"
Me._adapter.InsertCommand.Parameters.Add(param)
param = New System.Data.SqlServerCe.SqlCeParameter
param.ParameterName = "@p4"
param.IsNullable = true
param.SourceColumn = "Weather"
Me._adapter.InsertCommand.Parameters.Add(param)
param = New System.Data.SqlServerCe.SqlCeParameter
param.ParameterName = "@p5"
param.DbType = System.Data.DbType.DateTime
param.IsNullable = true
param.SourceColumn = "R_time"
Me._adapter.InsertCommand.Parameters.Add(param)
param = New System.Data.SqlServerCe.SqlCeParameter
param.ParameterName = "@p6"
param.IsNullable = true
param.SourceColumn = "M_daily"
Me._adapter.InsertCommand.Parameters.Add(param)
param = New System.Data.SqlServerCe.SqlCeParameter
param.ParameterName = "@p7"
param.IsNullable = true
param.SourceColumn = "M_mood"
Me._adapter.InsertCommand.Parameters.Add(param)
Me._adapter.UpdateCommand = New System.Data.SqlServerCe.SqlCeCommand
Me._adapter.UpdateCommand.Connection = Me.Connection
Me._adapter.UpdateCommand.CommandText = "UPDATE [Daily] SET [W_year] = @p1, [W_month] = @p2, [w_day] = @p3, [Weather] = @p"& _
"4, [R_time] = @p5, [M_daily] = @p6, [M_mood] = @p7 WHERE (([M_ID] = @p8))"
Me._adapter.UpdateCommand.CommandType = System.Data.CommandType.Text
param = New System.Data.SqlServerCe.SqlCeParameter
param.ParameterName = "@p1"
param.DbType = System.Data.DbType.Int32
param.IsNullable = true
param.SourceColumn = "W_year"
Me._adapter.UpdateCommand.Parameters.Add(param)
param = New System.Data.SqlServerCe.SqlCeParameter
param.ParameterName = "@p2"
param.DbType = System.Data.DbType.Int32
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -