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.
275 lines
13 KiB
275 lines
13 KiB
Imports System.Data
|
|
Imports System.Data.SqlClient
|
|
Imports System.Data.SqlTypes
|
|
|
|
Public Class frmpersvorlageladen
|
|
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 vorlagenlist As C1.Win.C1TrueDBGrid.C1TrueDBGrid
|
|
Friend WithEvents Button1 As System.Windows.Forms.Button
|
|
Friend WithEvents ContextMenu1 As System.Windows.Forms.ContextMenu
|
|
Friend WithEvents mnuload As System.Windows.Forms.MenuItem
|
|
Friend WithEvents mnudelete As System.Windows.Forms.MenuItem
|
|
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
|
|
Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(frmpersvorlageladen))
|
|
Dim GridLines1 As C1.Win.C1TrueDBGrid.Util.GridLines = New C1.Win.C1TrueDBGrid.Util.GridLines()
|
|
Me.vorlagenlist = New C1.Win.C1TrueDBGrid.C1TrueDBGrid()
|
|
Me.ContextMenu1 = New System.Windows.Forms.ContextMenu()
|
|
Me.mnuload = New System.Windows.Forms.MenuItem()
|
|
Me.mnudelete = New System.Windows.Forms.MenuItem()
|
|
Me.Button1 = New System.Windows.Forms.Button()
|
|
CType(Me.vorlagenlist, System.ComponentModel.ISupportInitialize).BeginInit()
|
|
Me.SuspendLayout()
|
|
'
|
|
'vorlagenlist
|
|
'
|
|
Me.vorlagenlist.AllowFilter = True
|
|
Me.vorlagenlist.AllowRowSizing = C1.Win.C1TrueDBGrid.RowSizingEnum.AllRows
|
|
Me.vorlagenlist.AllowSort = True
|
|
Me.vorlagenlist.AlternatingRows = True
|
|
Me.vorlagenlist.CaptionHeight = 17
|
|
Me.vorlagenlist.CellTips = C1.Win.C1TrueDBGrid.CellTipEnum.Floating
|
|
Me.vorlagenlist.CollapseColor = System.Drawing.Color.Black
|
|
Me.vorlagenlist.ContextMenu = Me.ContextMenu1
|
|
Me.vorlagenlist.Cursor = System.Windows.Forms.Cursors.Default
|
|
Me.vorlagenlist.DataChanged = False
|
|
Me.vorlagenlist.DeadAreaBackColor = System.Drawing.Color.Empty
|
|
Me.vorlagenlist.Dock = System.Windows.Forms.DockStyle.Top
|
|
Me.vorlagenlist.ExpandColor = System.Drawing.Color.Black
|
|
Me.vorlagenlist.FetchRowStyles = True
|
|
Me.vorlagenlist.FilterBar = True
|
|
Me.vorlagenlist.GroupByCaption = "Drag a column header here to group by that column"
|
|
Me.vorlagenlist.Images.Add(CType(resources.GetObject("resource.Images"), System.Drawing.Bitmap))
|
|
Me.vorlagenlist.MarqueeStyle = C1.Win.C1TrueDBGrid.MarqueeEnum.DottedCellBorder
|
|
Me.vorlagenlist.Name = "vorlagenlist"
|
|
Me.vorlagenlist.PreviewInfo.Location = New System.Drawing.Point(0, 0)
|
|
Me.vorlagenlist.PreviewInfo.Size = New System.Drawing.Size(0, 0)
|
|
Me.vorlagenlist.PreviewInfo.ZoomFactor = 75
|
|
Me.vorlagenlist.PrintInfo.ShowOptionsDialog = False
|
|
Me.vorlagenlist.RecordSelectorWidth = 16
|
|
GridLines1.Color = System.Drawing.Color.DarkGray
|
|
GridLines1.Style = C1.Win.C1TrueDBGrid.LineStyleEnum.Single
|
|
Me.vorlagenlist.RowDivider = GridLines1
|
|
Me.vorlagenlist.RowHeight = 15
|
|
Me.vorlagenlist.RowSubDividerColor = System.Drawing.Color.DarkGray
|
|
Me.vorlagenlist.ScrollTips = True
|
|
Me.vorlagenlist.Size = New System.Drawing.Size(368, 176)
|
|
Me.vorlagenlist.TabAction = C1.Win.C1TrueDBGrid.TabActionEnum.ColumnNavigation
|
|
Me.vorlagenlist.TabIndex = 27
|
|
Me.vorlagenlist.Text = "C1TrueDBGrid1"
|
|
Me.vorlagenlist.PropBag = "<?xml version=""1.0""?><Blob><Styles type=""C1.Win.C1TrueDBGrid.Design.ContextWrappe" & _
|
|
"r""><Data>Style11{}Style12{}Style13{}Style5{}Style4{}Style7{}Style6{}EvenRow{Back" & _
|
|
"Color:White;}Selected{ForeColor:HighlightText;BackColor:Highlight;}Heading{Wrap:" & _
|
|
"True;BackColor:Control;Border:Raised,,1, 1, 1, 1;ForeColor:ControlText;AlignVert" & _
|
|
":Center;}Inactive{ForeColor:InactiveCaptionText;BackColor:InactiveCaption;}Filte" & _
|
|
"rBar{BackColor:255, 255, 192;}Footer{}Caption{AlignHorz:Center;}Editor{}Normal{B" & _
|
|
"ackColor:Control;}Style27{}Style26{}HighlightRow{ForeColor:HighlightText;BackCol" & _
|
|
"or:Highlight;}Style1{}OddRow{BackColor:224, 224, 224;}RecordSelector{AlignImage:" & _
|
|
"Center;}Style9{}Style8{}Style3{}Style2{}Group{AlignVert:Center;Border:None,,0, 0" & _
|
|
", 0, 0;BackColor:ControlDark;}Style10{AlignHorz:Near;}</Data></Styles><Splits><C" & _
|
|
"1.Win.C1TrueDBGrid.MergeView Name="""" AlternatingRowStyle=""True"" CaptionHeight=""1" & _
|
|
"7"" ColumnCaptionHeight=""17"" ColumnFooterHeight=""17"" FetchRowStyles=""True"" Filter" & _
|
|
"Bar=""True"" MarqueeStyle=""DottedCellBorder"" RecordSelectorWidth=""16"" DefRecSelWid" & _
|
|
"th=""16"" VerticalScrollGroup=""1"" HorizontalScrollGroup=""1""><ClientRect>0, 0, 364," & _
|
|
" 172</ClientRect><BorderSide>0</BorderSide><CaptionStyle parent=""Heading"" me=""St" & _
|
|
"yle10"" /><EditorStyle parent=""Editor"" me=""Style2"" /><EvenRowStyle parent=""EvenRo" & _
|
|
"w"" me=""Style8"" /><FilterBarStyle parent=""FilterBar"" me=""Style27"" /><FooterStyle " & _
|
|
"parent=""Footer"" me=""Style4"" /><GroupStyle parent=""Group"" me=""Style12"" /><Heading" & _
|
|
"Style parent=""Heading"" me=""Style3"" /><HighLightRowStyle parent=""HighlightRow"" me" & _
|
|
"=""Style7"" /><InactiveStyle parent=""Inactive"" me=""Style6"" /><OddRowStyle parent=""" & _
|
|
"OddRow"" me=""Style9"" /><RecordSelectorStyle parent=""RecordSelector"" me=""Style11"" " & _
|
|
"/><SelectedStyle parent=""Selected"" me=""Style5"" /><Style parent=""Normal"" me=""Styl" & _
|
|
"e1"" /></C1.Win.C1TrueDBGrid.MergeView></Splits><NamedStyles><Style parent="""" me=" & _
|
|
"""Normal"" /><Style parent=""Normal"" me=""Heading"" /><Style parent=""Heading"" me=""Foo" & _
|
|
"ter"" /><Style parent=""Heading"" me=""Caption"" /><Style parent=""Heading"" me=""Inacti" & _
|
|
"ve"" /><Style parent=""Normal"" me=""Selected"" /><Style parent=""Normal"" me=""Editor"" " & _
|
|
"/><Style parent=""Normal"" me=""HighlightRow"" /><Style parent=""Normal"" me=""EvenRow""" & _
|
|
" /><Style parent=""Normal"" me=""OddRow"" /><Style parent=""Heading"" me=""RecordSelect" & _
|
|
"or"" /><Style parent=""Normal"" me=""FilterBar"" /><Style parent=""Caption"" me=""Group""" & _
|
|
" /></NamedStyles><vertSplits>1</vertSplits><horzSplits>1</horzSplits><Layout>Mod" & _
|
|
"ified</Layout><DefaultRecSelWidth>16</DefaultRecSelWidth><ClientArea>0, 0, 364, " & _
|
|
"172</ClientArea></Blob>"
|
|
'
|
|
'ContextMenu1
|
|
'
|
|
Me.ContextMenu1.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.mnuload, Me.mnudelete})
|
|
'
|
|
'mnuload
|
|
'
|
|
Me.mnuload.Index = 0
|
|
Me.mnuload.Text = "&Vorlage laden"
|
|
'
|
|
'mnudelete
|
|
'
|
|
Me.mnudelete.Index = 1
|
|
Me.mnudelete.Text = "Vorlage &löschen"
|
|
'
|
|
'Button1
|
|
'
|
|
Me.Button1.Location = New System.Drawing.Point(152, 184)
|
|
Me.Button1.Name = "Button1"
|
|
Me.Button1.TabIndex = 28
|
|
Me.Button1.Text = "&Schliessen"
|
|
'
|
|
'frmpersvorlageladen
|
|
'
|
|
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
|
|
Me.ClientSize = New System.Drawing.Size(368, 213)
|
|
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.Button1, Me.vorlagenlist})
|
|
Me.Icon = CType(resources.GetObject("$this.Icon"), System.Drawing.Icon)
|
|
Me.Name = "frmpersvorlageladen"
|
|
Me.Text = "Persönliche Serienbriefvorlage laden"
|
|
CType(Me.vorlagenlist, System.ComponentModel.ISupportInitialize).EndInit()
|
|
Me.ResumeLayout(False)
|
|
|
|
End Sub
|
|
|
|
#End Region
|
|
|
|
#Region "Deklarationen"
|
|
Dim m_PersVorlageNr As Integer
|
|
Property PersVorlageNr() As Integer
|
|
Get
|
|
Return m_PersVorlageNr
|
|
End Get
|
|
Set(ByVal Value As Integer)
|
|
m_PersVorlageNr = Value
|
|
End Set
|
|
End Property
|
|
|
|
Dim dokumenttypnr As Integer
|
|
#End Region
|
|
|
|
Public Sub New(ByVal dokumenttypnr As Integer)
|
|
MyBase.New()
|
|
|
|
' Dieser Aufruf ist für den Windows Form-Designer erforderlich.
|
|
InitializeComponent()
|
|
Me.dokumenttypnr = dokumenttypnr
|
|
' Initialisierungen nach dem Aufruf InitializeComponent() hinzufügen
|
|
|
|
End Sub
|
|
|
|
|
|
Private Sub frmpersvorlageladen_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
|
|
Me.PersVorlageNr = 0
|
|
Load_data()
|
|
End Sub
|
|
|
|
Private Sub Load_data()
|
|
Me.vorlagenlist.DataSource = Nothing
|
|
Me.vorlagenlist.DataMember = Nothing
|
|
Dim dt As New DataTable()
|
|
dt = get_data()
|
|
Me.vorlagenlist.DataSource = dt
|
|
Me.vorlagenlist.DataMember = dt.TableName
|
|
If dt.Rows.Count = 0 Then
|
|
Me.mnudelete.Enabled = False
|
|
Me.mnuload.Enabled = False
|
|
Else
|
|
Me.mnudelete.Enabled = True
|
|
Me.mnuload.Enabled = True
|
|
End If
|
|
Me.vorlagenlist.Splits(0).DisplayColumns(0).Width = 0
|
|
Me.vorlagenlist.Splits(0).DisplayColumns(1).Width = Me.vorlagenlist.Width - 50
|
|
End Sub
|
|
|
|
Private Function get_data() As DataTable
|
|
Dim scmCmdToExecute As SqlCommand = New SqlCommand()
|
|
Dim i As Integer
|
|
Dim dtToReturn As DataTable = New DataTable()
|
|
Dim sdaAdapter As SqlDataAdapter = New SqlDataAdapter(scmCmdToExecute)
|
|
scmCmdToExecute.CommandText = "dbo.sp_edex_get_persvorlagen"
|
|
scmCmdToExecute.CommandType = CommandType.StoredProcedure
|
|
scmCmdToExecute.Connection = conn.scoDBConnection
|
|
Try
|
|
scmCmdToExecute.Parameters.Add(New SqlParameter("@mitarbeiternr", SqlDbType.Int, 22, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, Globals.MitarbeiterNr))
|
|
scmCmdToExecute.Parameters.Add(New SqlParameter("@dokumenttypnr", SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, Me.dokumenttypnr))
|
|
sdaAdapter.Fill(dtToReturn)
|
|
Return dtToReturn
|
|
Catch ex As Exception
|
|
Throw New Exception("sp_check_dokumentreaktivierung::" & scmCmdToExecute.CommandText & "::Error occured." & ex.Message, ex)
|
|
Finally
|
|
scmCmdToExecute.Dispose()
|
|
sdaAdapter.Dispose()
|
|
End Try
|
|
End Function
|
|
|
|
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
|
|
Me.PersVorlageNr = 0
|
|
Me.Close()
|
|
End Sub
|
|
|
|
Private Function delete_vorlage() As DataTable
|
|
Dim scmCmdToExecute As SqlCommand = New SqlCommand()
|
|
Dim i As Integer
|
|
Dim dtToReturn As DataTable = New DataTable()
|
|
Dim sdaAdapter As SqlDataAdapter = New SqlDataAdapter(scmCmdToExecute)
|
|
scmCmdToExecute.CommandText = "dbo.sp_edex_delte_persvorlagen"
|
|
scmCmdToExecute.CommandType = CommandType.StoredProcedure
|
|
scmCmdToExecute.Connection = conn.scoDBConnection
|
|
Try
|
|
scmCmdToExecute.Parameters.Add(New SqlParameter("@vorlagenr", SqlDbType.Int, 22, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, Me.vorlagenlist.Columns(0).Text))
|
|
sdaAdapter.Fill(dtToReturn)
|
|
Return dtToReturn
|
|
Catch ex As Exception
|
|
Throw New Exception("sp_check_dokumentreaktivierung::" & scmCmdToExecute.CommandText & "::Error occured." & ex.Message, ex)
|
|
Finally
|
|
scmCmdToExecute.Dispose()
|
|
sdaAdapter.Dispose()
|
|
End Try
|
|
End Function
|
|
|
|
|
|
Private Sub mnudelete_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles mnudelete.Click
|
|
Try
|
|
If MyMsg.Show_MessageYesNo(739) = MsgBoxResult.Yes Then
|
|
delete_vorlage()
|
|
Load_data()
|
|
End If
|
|
Catch
|
|
End Try
|
|
End Sub
|
|
|
|
|
|
Private Sub mnuload_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles mnuload.Click
|
|
Try
|
|
Me.PersVorlageNr = Me.vorlagenlist.Columns(0).Text
|
|
Me.Close()
|
|
Catch
|
|
End Try
|
|
End Sub
|
|
|
|
Private Sub vorlagenlist_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles vorlagenlist.DoubleClick
|
|
mnuload_Click(sender, e)
|
|
End Sub
|
|
End Class
|