'''Applikations Parameter (verwaltet Programmeinstellungen für einzelne oder alle Benutzer in einer sql-tabelle)
'''um auf die parameter abzufragen bitte die klasse BF.Config verwenden. diese klasse cached die parameter.
Public Class Parameter
#Region "Member"
Private _parameterId As Integer
Private _benutzerNr As Integer
Private _name As String
Private _wert As String = ""
Private _datentyp As Datentyp
Private _beschreibung As String
Private _aktiv As Boolean
Private _mutiererId As Integer
Private _mutiertAm As DateTime
#End Region
#Region "Enums"
Public Enum Datentyp
[Integer] = 1
[String] = 2
[Boolean] = 3
End Enum
#End Region
#Region "Constructors"
Public Sub New()
End Sub
'''load the parameter for all users (benutzerNr=0)
'''parameterName
Public Sub New(ByVal parameterName As String)
ConstructorHelper(parameterName, 0)
End Sub
'''lädt einen parameter für einen bestimmten benutzer oder für alle
'''parameterName
'''BenutzerNr oder 0 = gültig für alle benutzer
Public Sub New(ByVal parameterName As String, ByVal benutzerNr As Integer)
ConstructorHelper(parameterName, benutzerNr)
End Sub
#End Region
#Region "Private Functions"
'''workaround für fehlendes konstruktor überladen
'''
'''
Private Sub ConstructorHelper(ByVal parameterName As String, ByVal benutzerNr As Integer)
Try
Dim ds As New DataSet()
DataAccess.Parameter.GetParameter(ds, benutzerNr, parameterName)
LoadData(ds)
Catch ex As Exception
TKBLib.Errorhandling.TraceHelper.Msg("EDOKALib.BF.Parameter.ConstructorHelper", ex.Message + " " + ex.StackTrace, TraceLevel.Error)
Throw ex
End Try
End Sub
'''lädt die daten in die klassen member
'''
Private Sub LoadData(ByVal ds As DataSet)
Try
If Not Common.Tools.ValidateDS(ds) Then
Return
End If
_parameterId = ds.Tables(0).Rows(0).Item("ParameterId")
_benutzerNr = ds.Tables(0).Rows(0).Item("BenutzerNr")
_name = ds.Tables(0).Rows(0).Item("Name")
_wert = ds.Tables(0).Rows(0).Item("Wert")
_datentyp = CType(ds.Tables(0).Rows(0).Item("Datentyp"), Datentyp)
_beschreibung = ds.Tables(0).Rows(0).Item("Beschreibung")
_aktiv = ds.Tables(0).Rows(0).Item("Aktiv")
_mutiererId = ds.Tables(0).Rows(0).Item("MutiererId")
_mutiertAm = ds.Tables(0).Rows(0).Item("MutiertAm")
Catch ex As Exception
TKBLib.Errorhandling.TraceHelper.Msg("EDOKALib.BF.Parameter.LoadData", ex.Message + " " + ex.StackTrace, TraceLevel.Error)
Throw ex
End Try
End Sub
#End Region
#Region "Properties"
Public Property ParameterId() As Integer
Get
Return _parameterId
End Get
Set(ByVal Value As Integer)
_parameterId = Value
End Set
End Property
Public Property BenutzerNr() As Integer
Get
Return _benutzerNr
End Get
Set(ByVal Value As Integer)
_benutzerNr = Value
End Set
End Property
Public Property Name() As String
Get
Return _name
End Get
Set(ByVal Value As String)
_name = Value
End Set
End Property
Public Property Wert() As String
Get
Return _wert
End Get
Set(ByVal Value As String)
_wert = Value
End Set
End Property
Public Property Typ() As Datentyp
Get
Return _datentyp
End Get
Set(ByVal Value As Datentyp)
_datentyp = Value
End Set
End Property
Public Property Beschreibung() As String
Get
Return _beschreibung
End Get
Set(ByVal Value As String)
_beschreibung = Value
End Set
End Property
Public Property Aktiv() As Boolean
Get
Return _aktiv
End Get
Set(ByVal Value As Boolean)
_aktiv = Value
End Set
End Property
Public Property MutiererId() As Integer
Get
Return _mutiererId
End Get
Set(ByVal Value As Integer)
_mutiererId = Value
End Set
End Property
Public Property MutiertAm() As DateTime
Get
Return _mutiertAm
End Get
Set(ByVal Value As DateTime)
_mutiertAm = Value
End Set
End Property
#End Region
End Class