You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
261 lines
9.6 KiB
261 lines
9.6 KiB
Imports UtilityLibrary
|
|
Imports System.IO
|
|
Imports C1.Win.C1TrueDBGrid
|
|
Imports System.Data
|
|
Imports System.Data.SqlTypes
|
|
Imports System.Data.SqlClient
|
|
Imports System.ComponentModel
|
|
Imports UtilityLibrary.Win32
|
|
|
|
Public Class frmStellvertreterAdd
|
|
Inherits System.Windows.Forms.Form
|
|
|
|
#Region " Vom Windows Form Designer generierter Code "
|
|
|
|
Public Sub New()
|
|
MyBase.New()
|
|
|
|
' Dieser Aufruf ist für den Windows Form-Designer erforderlich.
|
|
InitializeComponent()
|
|
|
|
' Initialisierungen nach dem Aufruf InitializeComponent() hinzufügen
|
|
|
|
End Sub
|
|
|
|
' Die Form überschreibt den Löschvorgang der Basisklasse, um Komponenten zu bereinigen.
|
|
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
|
|
|
|
' Für Windows Form-Designer erforderlich
|
|
Private components As System.ComponentModel.IContainer
|
|
|
|
'HINWEIS: Die folgende Prozedur ist für den Windows Form-Designer erforderlich
|
|
'Sie kann mit dem Windows Form-Designer modifiziert werden.
|
|
'Verwenden Sie nicht den Code-Editor zur Bearbeitung.
|
|
Friend WithEvents Label1 As System.Windows.Forms.Label
|
|
Friend WithEvents DateTimePicker1 As System.Windows.Forms.DateTimePicker
|
|
Friend WithEvents DateTimePicker2 As System.Windows.Forms.DateTimePicker
|
|
Friend WithEvents Label2 As System.Windows.Forms.Label
|
|
Friend WithEvents Label3 As System.Windows.Forms.Label
|
|
Friend WithEvents Button1 As System.Windows.Forms.Button
|
|
Friend WithEvents Button2 As System.Windows.Forms.Button
|
|
Friend WithEvents cbMitarbeiter As System.Windows.Forms.ComboBox
|
|
Friend WithEvents cbfunktion As System.Windows.Forms.ComboBox
|
|
Friend WithEvents Label4 As System.Windows.Forms.Label
|
|
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
|
|
Me.Label1 = New System.Windows.Forms.Label()
|
|
Me.DateTimePicker1 = New System.Windows.Forms.DateTimePicker()
|
|
Me.DateTimePicker2 = New System.Windows.Forms.DateTimePicker()
|
|
Me.Label2 = New System.Windows.Forms.Label()
|
|
Me.Label3 = New System.Windows.Forms.Label()
|
|
Me.Button1 = New System.Windows.Forms.Button()
|
|
Me.Button2 = New System.Windows.Forms.Button()
|
|
Me.cbMitarbeiter = New System.Windows.Forms.ComboBox()
|
|
Me.cbfunktion = New System.Windows.Forms.ComboBox()
|
|
Me.Label4 = New System.Windows.Forms.Label()
|
|
Me.SuspendLayout()
|
|
'
|
|
'Label1
|
|
'
|
|
Me.Label1.Location = New System.Drawing.Point(24, 24)
|
|
Me.Label1.Name = "Label1"
|
|
Me.Label1.Size = New System.Drawing.Size(72, 23)
|
|
Me.Label1.TabIndex = 6
|
|
Me.Label1.Text = "Stellvertreter"
|
|
'
|
|
'DateTimePicker1
|
|
'
|
|
Me.DateTimePicker1.Format = System.Windows.Forms.DateTimePickerFormat.Short
|
|
Me.DateTimePicker1.Location = New System.Drawing.Point(96, 53)
|
|
Me.DateTimePicker1.Name = "DateTimePicker1"
|
|
Me.DateTimePicker1.Size = New System.Drawing.Size(88, 20)
|
|
Me.DateTimePicker1.TabIndex = 1
|
|
'
|
|
'DateTimePicker2
|
|
'
|
|
Me.DateTimePicker2.Format = System.Windows.Forms.DateTimePickerFormat.Short
|
|
Me.DateTimePicker2.Location = New System.Drawing.Point(224, 53)
|
|
Me.DateTimePicker2.Name = "DateTimePicker2"
|
|
Me.DateTimePicker2.Size = New System.Drawing.Size(88, 20)
|
|
Me.DateTimePicker2.TabIndex = 2
|
|
'
|
|
'Label2
|
|
'
|
|
Me.Label2.Location = New System.Drawing.Point(24, 53)
|
|
Me.Label2.Name = "Label2"
|
|
Me.Label2.Size = New System.Drawing.Size(64, 23)
|
|
Me.Label2.TabIndex = 9
|
|
Me.Label2.Text = "von"
|
|
'
|
|
'Label3
|
|
'
|
|
Me.Label3.Location = New System.Drawing.Point(192, 53)
|
|
Me.Label3.Name = "Label3"
|
|
Me.Label3.Size = New System.Drawing.Size(24, 23)
|
|
Me.Label3.TabIndex = 10
|
|
Me.Label3.Text = "bis"
|
|
'
|
|
'Button1
|
|
'
|
|
Me.Button1.Location = New System.Drawing.Point(224, 120)
|
|
Me.Button1.Name = "Button1"
|
|
Me.Button1.TabIndex = 3
|
|
Me.Button1.Text = "&OK"
|
|
'
|
|
'Button2
|
|
'
|
|
Me.Button2.DialogResult = System.Windows.Forms.DialogResult.Abort
|
|
Me.Button2.Location = New System.Drawing.Point(136, 120)
|
|
Me.Button2.Name = "Button2"
|
|
Me.Button2.TabIndex = 4
|
|
Me.Button2.Text = "&Abbruch"
|
|
'
|
|
'cbMitarbeiter
|
|
'
|
|
Me.cbMitarbeiter.Location = New System.Drawing.Point(96, 24)
|
|
Me.cbMitarbeiter.Name = "cbMitarbeiter"
|
|
Me.cbMitarbeiter.Size = New System.Drawing.Size(312, 21)
|
|
Me.cbMitarbeiter.TabIndex = 0
|
|
Me.cbMitarbeiter.Text = "ComboBox1"
|
|
'
|
|
'cbfunktion
|
|
'
|
|
Me.cbfunktion.Location = New System.Drawing.Point(96, 80)
|
|
Me.cbfunktion.Name = "cbfunktion"
|
|
Me.cbfunktion.Size = New System.Drawing.Size(312, 21)
|
|
Me.cbfunktion.TabIndex = 11
|
|
Me.cbfunktion.Text = "ComboBox1"
|
|
'
|
|
'Label4
|
|
'
|
|
Me.Label4.Location = New System.Drawing.Point(24, 82)
|
|
Me.Label4.Name = "Label4"
|
|
Me.Label4.Size = New System.Drawing.Size(72, 23)
|
|
Me.Label4.TabIndex = 12
|
|
Me.Label4.Text = "Umfang"
|
|
'
|
|
'frmStellvertreterAdd
|
|
'
|
|
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
|
|
Me.ClientSize = New System.Drawing.Size(448, 157)
|
|
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.cbfunktion, Me.Label4, Me.cbMitarbeiter, Me.Button2, Me.Button1, Me.Label3, Me.Label2, Me.DateTimePicker2, Me.DateTimePicker1, Me.Label1})
|
|
Me.MaximizeBox = False
|
|
Me.MinimizeBox = False
|
|
Me.Name = "frmStellvertreterAdd"
|
|
Me.ShowInTaskbar = False
|
|
Me.Text = "Neuer Stellvertreter"
|
|
Me.ResumeLayout(False)
|
|
|
|
End Sub
|
|
|
|
#End Region
|
|
|
|
Dim WithEvents mcbmitarbeiter As New MultiComboBox()
|
|
Dim WithEvents mcbStellvertretungtyp As New MultiComboBox()
|
|
|
|
Dim m_vertreter As Integer
|
|
Property vertreter() As Integer
|
|
Get
|
|
Return m_vertreter
|
|
End Get
|
|
Set(ByVal Value As Integer)
|
|
m_vertreter = Value
|
|
End Set
|
|
End Property
|
|
|
|
|
|
Dim m_stvtyp As Integer
|
|
Property Stellvertretungtyp() As Integer
|
|
Get
|
|
Return m_stvtyp
|
|
End Get
|
|
Set(ByVal Value As Integer)
|
|
m_stvtyp = Value
|
|
End Set
|
|
End Property
|
|
|
|
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
|
|
Me.vertreter = Me.mcbmitarbeiter.SelectedValue
|
|
If Me.cbfunktion.Visible = False Then
|
|
Me.Stellvertretungtyp = 0
|
|
Else
|
|
Me.Stellvertretungtyp = Me.mcbStellvertretungtyp.SelectedValue
|
|
End If
|
|
Me.DialogResult = DialogResult.OK
|
|
Me.Close()
|
|
End Sub
|
|
|
|
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
|
|
Me.DialogResult = DialogResult.Abort
|
|
Me.Close()
|
|
End Sub
|
|
|
|
Private Sub frmStellvertreterAdd_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
|
|
mcbmitarbeiter = New MultiComboBox(Me.cbMitarbeiter)
|
|
Me.mcbmitarbeiter.CheckNullValue = False
|
|
Me.mcbmitarbeiter.NullValueMessage = MyTxt.gettext(18)
|
|
Me.mcbmitarbeiter.DisplayColumnName = "mitarbeiter"
|
|
Me.mcbmitarbeiter.ValueColumnName = "mitarbeiternr"
|
|
Me.mcbmitarbeiter.Fill_Data(Generic_Select(1), False)
|
|
Me.mcbmitarbeiter.SelectedValue = Globals.MitarbeiterNr
|
|
|
|
Me.DateTimePicker1.Value = Now
|
|
Me.DateTimePicker2.Value = Now
|
|
|
|
'Prüfung, ob aktueller Mitarbeiter Sysadminrechte hat
|
|
Dim menu As New edokadb.clsMySysadminfunkion()
|
|
Dim TV As New TreeView()
|
|
menu.LoadTreeMenu(TV)
|
|
If TV.GetNodeCount(True) > 0 Then
|
|
Me.Label4.Visible = True
|
|
Me.cbfunktion.Visible = True
|
|
Me.mcbStellvertretungtyp = New MultiComboBox(Me.cbfunktion)
|
|
Me.mcbStellvertretungtyp.CheckNullValue = False
|
|
Me.mcbStellvertretungtyp.DisplayColumnName = "bezeichnung"
|
|
Me.mcbStellvertretungtyp.ValueColumnName = "stellvertretungtypnr"
|
|
Me.mcbStellvertretungtyp.Fill_Data(Generic_Select(2), False)
|
|
Dim i As Integer = 0
|
|
Me.mcbStellvertretungtyp.SelectedValue = i
|
|
Else
|
|
Me.Label4.Visible = False
|
|
Me.cbfunktion.Visible = False
|
|
End If
|
|
|
|
|
|
End Sub
|
|
|
|
Private Function Generic_Select(ByVal typ As Integer) As DataTable
|
|
Dim scmCmdToExecute As SqlCommand = New SqlCommand()
|
|
|
|
Select Case typ
|
|
Case 1
|
|
scmCmdToExecute.CommandText = "dbo.SP_stellvertretungen_mitarbeiter"
|
|
Case 2
|
|
scmCmdToExecute.CommandText = "dbo.sp_stellvertretungtyp"
|
|
Case Else
|
|
End Select
|
|
scmCmdToExecute.CommandType = CommandType.StoredProcedure
|
|
Dim dtToReturn As DataTable = New DataTable()
|
|
Dim sdaAdapter As SqlDataAdapter = New SqlDataAdapter(scmCmdToExecute)
|
|
|
|
scmCmdToExecute.Connection = conn.scoDBConnection
|
|
Try
|
|
sdaAdapter.Fill(dtToReturn)
|
|
Return dtToReturn
|
|
Catch ex As Exception
|
|
' // some error occured. Bubble it to caller and encapsulate Exception object
|
|
Throw New Exception("Dokumenterstellung::Generic_Select::" & scmCmdToExecute.CommandText & "::Error occured." & ex.Message, ex)
|
|
Finally
|
|
scmCmdToExecute.Dispose()
|
|
sdaAdapter.Dispose()
|
|
End Try
|
|
End Function
|
|
|
|
End Class
|