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.
349 lines
14 KiB
349 lines
14 KiB
Imports System.Data
|
|
Imports System.Data.SqlTypes
|
|
Imports System.Data.SqlClient
|
|
Imports System.ComponentModel
|
|
Imports UtilityLibrary.Win32
|
|
Public Class frmMessageWeiterleitung
|
|
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 Button1 As System.Windows.Forms.Button
|
|
Friend WithEvents Button2 As System.Windows.Forms.Button
|
|
Friend WithEvents cbMitarbeiter As System.Windows.Forms.ComboBox
|
|
Friend WithEvents Label2 As System.Windows.Forms.Label
|
|
Friend WithEvents TextBox1 As System.Windows.Forms.TextBox
|
|
Friend WithEvents Label1 As System.Windows.Forms.Label
|
|
Friend WithEvents Label3 As System.Windows.Forms.Label
|
|
Friend WithEvents TextBox2 As System.Windows.Forms.TextBox
|
|
Friend WithEvents txtBez As System.Windows.Forms.Label
|
|
Friend WithEvents txtDokID As System.Windows.Forms.Label
|
|
Friend WithEvents txtPartnerID As System.Windows.Forms.Label
|
|
Friend WithEvents txtBezText As System.Windows.Forms.Label
|
|
Friend WithEvents txtdokIDText As System.Windows.Forms.Label
|
|
Friend WithEvents txtPartnerIDText As System.Windows.Forms.Label
|
|
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
|
|
Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(frmMessageWeiterleitung))
|
|
Me.Button1 = New System.Windows.Forms.Button()
|
|
Me.Button2 = New System.Windows.Forms.Button()
|
|
Me.cbMitarbeiter = New System.Windows.Forms.ComboBox()
|
|
Me.Label2 = New System.Windows.Forms.Label()
|
|
Me.TextBox1 = New System.Windows.Forms.TextBox()
|
|
Me.Label1 = New System.Windows.Forms.Label()
|
|
Me.Label3 = New System.Windows.Forms.Label()
|
|
Me.TextBox2 = New System.Windows.Forms.TextBox()
|
|
Me.txtBez = New System.Windows.Forms.Label()
|
|
Me.txtDokID = New System.Windows.Forms.Label()
|
|
Me.txtPartnerID = New System.Windows.Forms.Label()
|
|
Me.txtBezText = New System.Windows.Forms.Label()
|
|
Me.txtdokIDText = New System.Windows.Forms.Label()
|
|
Me.txtPartnerIDText = New System.Windows.Forms.Label()
|
|
Me.SuspendLayout()
|
|
'
|
|
'Button1
|
|
'
|
|
Me.Button1.Location = New System.Drawing.Point(8, 176)
|
|
Me.Button1.Name = "Button1"
|
|
Me.Button1.TabIndex = 4
|
|
Me.Button1.Text = "&Abbruch"
|
|
'
|
|
'Button2
|
|
'
|
|
Me.Button2.Location = New System.Drawing.Point(296, 176)
|
|
Me.Button2.Name = "Button2"
|
|
Me.Button2.TabIndex = 3
|
|
Me.Button2.Text = "&OK"
|
|
'
|
|
'cbMitarbeiter
|
|
'
|
|
Me.cbMitarbeiter.Location = New System.Drawing.Point(96, 16)
|
|
Me.cbMitarbeiter.Name = "cbMitarbeiter"
|
|
Me.cbMitarbeiter.Size = New System.Drawing.Size(264, 21)
|
|
Me.cbMitarbeiter.TabIndex = 0
|
|
Me.cbMitarbeiter.Text = "ComboBox1"
|
|
'
|
|
'Label2
|
|
'
|
|
Me.Label2.Location = New System.Drawing.Point(8, 16)
|
|
Me.Label2.Name = "Label2"
|
|
Me.Label2.Size = New System.Drawing.Size(80, 23)
|
|
Me.Label2.TabIndex = 5
|
|
Me.Label2.Text = "Empfänger"
|
|
'
|
|
'TextBox1
|
|
'
|
|
Me.TextBox1.Location = New System.Drawing.Point(96, 64)
|
|
Me.TextBox1.Multiline = True
|
|
Me.TextBox1.Name = "TextBox1"
|
|
Me.TextBox1.Size = New System.Drawing.Size(264, 104)
|
|
Me.TextBox1.TabIndex = 2
|
|
Me.TextBox1.Text = "TextBox1"
|
|
'
|
|
'Label1
|
|
'
|
|
Me.Label1.Location = New System.Drawing.Point(8, 64)
|
|
Me.Label1.Name = "Label1"
|
|
Me.Label1.Size = New System.Drawing.Size(80, 23)
|
|
Me.Label1.TabIndex = 7
|
|
Me.Label1.Text = "Meldung"
|
|
'
|
|
'Label3
|
|
'
|
|
Me.Label3.Location = New System.Drawing.Point(8, 40)
|
|
Me.Label3.Name = "Label3"
|
|
Me.Label3.Size = New System.Drawing.Size(80, 23)
|
|
Me.Label3.TabIndex = 8
|
|
Me.Label3.Text = "Betreff"
|
|
'
|
|
'TextBox2
|
|
'
|
|
Me.TextBox2.Location = New System.Drawing.Point(96, 40)
|
|
Me.TextBox2.Name = "TextBox2"
|
|
Me.TextBox2.Size = New System.Drawing.Size(264, 20)
|
|
Me.TextBox2.TabIndex = 1
|
|
Me.TextBox2.Text = ""
|
|
'
|
|
'txtBez
|
|
'
|
|
Me.txtBez.Location = New System.Drawing.Point(8, 216)
|
|
Me.txtBez.Name = "txtBez"
|
|
Me.txtBez.Size = New System.Drawing.Size(80, 16)
|
|
Me.txtBez.TabIndex = 9
|
|
'
|
|
'txtDokID
|
|
'
|
|
Me.txtDokID.Location = New System.Drawing.Point(8, 264)
|
|
Me.txtDokID.Name = "txtDokID"
|
|
Me.txtDokID.Size = New System.Drawing.Size(96, 16)
|
|
Me.txtDokID.TabIndex = 10
|
|
'
|
|
'txtPartnerID
|
|
'
|
|
Me.txtPartnerID.Location = New System.Drawing.Point(8, 240)
|
|
Me.txtPartnerID.Name = "txtPartnerID"
|
|
Me.txtPartnerID.Size = New System.Drawing.Size(80, 16)
|
|
Me.txtPartnerID.TabIndex = 11
|
|
'
|
|
'txtBezText
|
|
'
|
|
Me.txtBezText.Location = New System.Drawing.Point(96, 216)
|
|
Me.txtBezText.Name = "txtBezText"
|
|
Me.txtBezText.Size = New System.Drawing.Size(272, 16)
|
|
Me.txtBezText.TabIndex = 12
|
|
'
|
|
'txtdokIDText
|
|
'
|
|
Me.txtdokIDText.Location = New System.Drawing.Point(96, 264)
|
|
Me.txtdokIDText.Name = "txtdokIDText"
|
|
Me.txtdokIDText.Size = New System.Drawing.Size(272, 16)
|
|
Me.txtdokIDText.TabIndex = 13
|
|
'
|
|
'txtPartnerIDText
|
|
'
|
|
Me.txtPartnerIDText.Location = New System.Drawing.Point(96, 240)
|
|
Me.txtPartnerIDText.Name = "txtPartnerIDText"
|
|
Me.txtPartnerIDText.Size = New System.Drawing.Size(272, 16)
|
|
Me.txtPartnerIDText.TabIndex = 14
|
|
'
|
|
'frmMessageWeiterleitung
|
|
'
|
|
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
|
|
Me.ClientSize = New System.Drawing.Size(384, 286)
|
|
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.txtPartnerIDText, Me.txtdokIDText, Me.txtBezText, Me.txtPartnerID, Me.txtDokID, Me.txtBez, Me.TextBox2, Me.Label3, Me.Label1, Me.TextBox1, Me.Label2, Me.cbMitarbeiter, Me.Button2, Me.Button1})
|
|
Me.Icon = CType(resources.GetObject("$this.Icon"), System.Drawing.Icon)
|
|
Me.Name = "frmMessageWeiterleitung"
|
|
Me.StartPosition = System.Windows.Forms.FormStartPosition.CenterScreen
|
|
Me.Text = "Meldung "
|
|
Me.ResumeLayout(False)
|
|
|
|
End Sub
|
|
|
|
#End Region
|
|
|
|
Dim m_meldungstext As String
|
|
Property Meldungstext() As String
|
|
Get
|
|
Return m_meldungstext
|
|
End Get
|
|
Set(ByVal Value As String)
|
|
m_meldungstext = Value
|
|
End Set
|
|
End Property
|
|
|
|
Dim m_empfaenger As Integer
|
|
Property Empfaenger() As Integer
|
|
Get
|
|
Return m_empfaenger
|
|
End Get
|
|
Set(ByVal Value As Integer)
|
|
m_empfaenger = Value
|
|
End Set
|
|
End Property
|
|
|
|
Dim m_Bezeichnung As String
|
|
Dim m_INFO As String
|
|
Dim m_PartnerNR As String
|
|
WriteOnly Property propBezeichnung() As String
|
|
Set(ByVal Value As String)
|
|
m_Bezeichnung = Value
|
|
End Set
|
|
End Property
|
|
WriteOnly Property propINFO() As String
|
|
Set(ByVal Value As String)
|
|
m_INFO = Value
|
|
End Set
|
|
End Property
|
|
WriteOnly Property propPartnerNR() As String
|
|
Set(ByVal Value As String)
|
|
m_PartnerNR = Value
|
|
End Set
|
|
End Property
|
|
|
|
Dim WithEvents mcbmitarbeiter As New MultiComboBox()
|
|
|
|
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
|
|
mcbmitarbeiter = New MultiComboBox(Me.cbMitarbeiter)
|
|
Me.mcbmitarbeiter.CheckNullValue = True
|
|
Me.mcbmitarbeiter.NullValueMessage = MyTxt.gettext(18)
|
|
Me.mcbmitarbeiter.DisplayColumnName = "mitarbeiter"
|
|
Me.mcbmitarbeiter.ValueColumnName = "mitarbeiternr"
|
|
Me.mcbmitarbeiter.SelectedValue = 0
|
|
Me.mcbmitarbeiter.Fill_Data(Generic_Select(1), False)
|
|
Me.mcbmitarbeiter.Focus()
|
|
Me.mcbmitarbeiter.SelectAll()
|
|
Me.mcbmitarbeiter.Focus()
|
|
If m_Bezeichnung = "" Or m_PartnerNR = "" Or m_INFO = "" Then
|
|
Me.txtBez.Text = ""
|
|
Me.txtBezText.Text = ""
|
|
Me.txtDokID.Text = ""
|
|
Me.txtdokIDText.Text = ""
|
|
Me.txtPartnerID.Text = ""
|
|
Me.txtPartnerIDText.Text = ""
|
|
Else
|
|
Me.txtBez.Text = "Bezeichnung"
|
|
Me.txtBezText.Text = m_Bezeichnung
|
|
Me.txtDokID.Text = "Erstellungsdatum"
|
|
Me.txtdokIDText.Text = m_INFO
|
|
Me.txtPartnerID.Text = "Partner-Nr."
|
|
Me.txtPartnerIDText.Text = m_PartnerNR
|
|
End If
|
|
|
|
|
|
End Sub
|
|
|
|
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
|
|
Me.Empfaenger = 0
|
|
Me.Close()
|
|
End Sub
|
|
|
|
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
|
|
Dim sMessage As String
|
|
Me.Empfaenger = Me.mcbmitarbeiter.SelectedValue
|
|
Me.Meldungstext = Me.TextBox1.Text
|
|
' Prüfen ob der Empfänger den Empfang von Meldungen oder Emails eingeschaltet hat.
|
|
If ChechMeldungEmpfang(Me.Empfaenger) = 0 Then
|
|
MyMsg.show_standardmessage(259, MsgBoxStyle.Information)
|
|
Exit Sub
|
|
End If
|
|
If m_Bezeichnung <> "" Or m_PartnerNR <> "" Or m_INFO <> "" Then
|
|
sMessage = Me.Meldungstext + vbCrLf + vbCrLf + "Bezeichnung: " + m_Bezeichnung
|
|
sMessage = sMessage + vbCrLf + "Partner-Nr.: " + m_PartnerNR
|
|
sMessage = sMessage + vbCrLf + "Erstellungsdatum: " + m_INFO
|
|
Me.Meldungstext = sMessage
|
|
Me.TextBox1.Text = sMessage
|
|
End If
|
|
Me.Close()
|
|
End Sub
|
|
|
|
Private Function ChechMeldungEmpfang(ByVal MitarbeiterID As Integer) As Integer
|
|
'===============================================================================
|
|
'Description : Überprüft ob der Mitarbeiter mit der übergebenen ID Meldungen oder
|
|
' Mails aus EDOKA ein- oder ausgeschaltet hat.
|
|
'Input : Mitarbeiter ID
|
|
'Criteria :
|
|
'Output : 0/1 (0=Benachrichtigung ausgeschaltet )
|
|
'Date : bud 17.08.2004
|
|
'Modified :
|
|
'===============================================================================
|
|
'
|
|
'===============================================================================
|
|
Dim scmCmdToExecute As SqlCommand = New SqlCommand()
|
|
Dim iReturn As SqlInt32
|
|
scmCmdToExecute.CommandText = "dbo.sp_check_MeldungVersand"
|
|
scmCmdToExecute.CommandType = CommandType.StoredProcedure
|
|
scmCmdToExecute.Connection = conn.scoDBConnection
|
|
conn.OpenConnection()
|
|
ChechMeldungEmpfang = 1
|
|
Try
|
|
scmCmdToExecute.Parameters.Add(New SqlParameter("@iMANR", SqlDbType.Int, 22, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, MitarbeiterID))
|
|
scmCmdToExecute.Parameters.Add(New SqlParameter("@iResult", SqlDbType.Int, 4, ParameterDirection.Output, True, 10, 0, "", DataRowVersion.Proposed, ChechMeldungEmpfang))
|
|
scmCmdToExecute.ExecuteNonQuery()
|
|
iReturn = New SqlInt32(CType(scmCmdToExecute.Parameters.Item("@iResult").Value, Integer))
|
|
ChechMeldungEmpfang = iReturn.Value
|
|
Catch ex As Exception
|
|
Throw New Exception("Dokument_Information_Wert::" & scmCmdToExecute.CommandText & "::Error occured." & ex.Message, ex)
|
|
Finally
|
|
scmCmdToExecute.Dispose()
|
|
conn.CloseConnection(True)
|
|
End Try
|
|
End Function
|
|
|
|
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_message_getmitarbeiter"
|
|
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
|
|
Select Case typ
|
|
Case Else
|
|
End Select
|
|
If typ = 1 Then
|
|
End If
|
|
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
|