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.
399 lines
18 KiB
399 lines
18 KiB
Imports System.Data
|
|
Imports System.Data.SqlClient
|
|
Imports System.Data.SqlTypes
|
|
|
|
Public Class frmSerienbriefe_Load
|
|
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 ListBox1 As System.Windows.Forms.ListBox
|
|
Friend WithEvents Button1 As System.Windows.Forms.Button
|
|
Friend WithEvents Button2 As System.Windows.Forms.Button
|
|
Friend WithEvents Panel1 As System.Windows.Forms.Panel
|
|
Friend WithEvents Panel2 As System.Windows.Forms.Panel
|
|
Friend WithEvents Panel3 As System.Windows.Forms.Panel
|
|
Friend WithEvents TVStatus As System.Windows.Forms.TreeView
|
|
Friend WithEvents sblist As C1.Win.C1TrueDBGrid.C1TrueDBGrid
|
|
Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox
|
|
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
|
|
Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(frmSerienbriefe_Load))
|
|
Dim GridLines1 As C1.Win.C1TrueDBGrid.Util.GridLines = New C1.Win.C1TrueDBGrid.Util.GridLines()
|
|
Me.ListBox1 = New System.Windows.Forms.ListBox()
|
|
Me.Button1 = New System.Windows.Forms.Button()
|
|
Me.Button2 = New System.Windows.Forms.Button()
|
|
Me.Panel1 = New System.Windows.Forms.Panel()
|
|
Me.Panel2 = New System.Windows.Forms.Panel()
|
|
Me.Panel3 = New System.Windows.Forms.Panel()
|
|
Me.TVStatus = New System.Windows.Forms.TreeView()
|
|
Me.sblist = New C1.Win.C1TrueDBGrid.C1TrueDBGrid()
|
|
Me.GroupBox1 = New System.Windows.Forms.GroupBox()
|
|
Me.Panel1.SuspendLayout()
|
|
Me.Panel2.SuspendLayout()
|
|
Me.Panel3.SuspendLayout()
|
|
CType(Me.sblist, System.ComponentModel.ISupportInitialize).BeginInit()
|
|
Me.GroupBox1.SuspendLayout()
|
|
Me.SuspendLayout()
|
|
'
|
|
'ListBox1
|
|
'
|
|
Me.ListBox1.Location = New System.Drawing.Point(176, 448)
|
|
Me.ListBox1.Name = "ListBox1"
|
|
Me.ListBox1.Size = New System.Drawing.Size(368, 30)
|
|
Me.ListBox1.TabIndex = 0
|
|
'
|
|
'Button1
|
|
'
|
|
Me.Button1.Anchor = (System.Windows.Forms.AnchorStyles.Top Or System.Windows.Forms.AnchorStyles.Right)
|
|
Me.Button1.Location = New System.Drawing.Point(688, 16)
|
|
Me.Button1.Name = "Button1"
|
|
Me.Button1.TabIndex = 1
|
|
Me.Button1.Text = "&OK"
|
|
'
|
|
'Button2
|
|
'
|
|
Me.Button2.Location = New System.Drawing.Point(8, 16)
|
|
Me.Button2.Name = "Button2"
|
|
Me.Button2.TabIndex = 2
|
|
Me.Button2.Text = "&Abbruch"
|
|
'
|
|
'Panel1
|
|
'
|
|
Me.Panel1.Controls.AddRange(New System.Windows.Forms.Control() {Me.Button2, Me.Button1})
|
|
Me.Panel1.Dock = System.Windows.Forms.DockStyle.Bottom
|
|
Me.Panel1.Location = New System.Drawing.Point(0, 253)
|
|
Me.Panel1.Name = "Panel1"
|
|
Me.Panel1.Size = New System.Drawing.Size(768, 48)
|
|
Me.Panel1.TabIndex = 28
|
|
'
|
|
'Panel2
|
|
'
|
|
Me.Panel2.Controls.AddRange(New System.Windows.Forms.Control() {Me.sblist})
|
|
Me.Panel2.Dock = System.Windows.Forms.DockStyle.Left
|
|
Me.Panel2.Name = "Panel2"
|
|
Me.Panel2.Size = New System.Drawing.Size(528, 253)
|
|
Me.Panel2.TabIndex = 29
|
|
'
|
|
'Panel3
|
|
'
|
|
Me.Panel3.Controls.AddRange(New System.Windows.Forms.Control() {Me.TVStatus})
|
|
Me.Panel3.Dock = System.Windows.Forms.DockStyle.Fill
|
|
Me.Panel3.Location = New System.Drawing.Point(3, 16)
|
|
Me.Panel3.Name = "Panel3"
|
|
Me.Panel3.Size = New System.Drawing.Size(234, 234)
|
|
Me.Panel3.TabIndex = 30
|
|
'
|
|
'TVStatus
|
|
'
|
|
Me.TVStatus.BackColor = System.Drawing.Color.FromArgb(CType(255, Byte), CType(255, Byte), CType(192, Byte))
|
|
Me.TVStatus.Dock = System.Windows.Forms.DockStyle.Fill
|
|
Me.TVStatus.ImageIndex = -1
|
|
Me.TVStatus.Name = "TVStatus"
|
|
Me.TVStatus.SelectedImageIndex = -1
|
|
Me.TVStatus.Size = New System.Drawing.Size(234, 234)
|
|
Me.TVStatus.TabIndex = 1
|
|
'
|
|
'sblist
|
|
'
|
|
Me.sblist.AllowFilter = True
|
|
Me.sblist.AllowSort = True
|
|
Me.sblist.AllowUpdate = False
|
|
Me.sblist.AllowUpdateOnBlur = False
|
|
Me.sblist.AlternatingRows = True
|
|
Me.sblist.CaptionHeight = 17
|
|
Me.sblist.CollapseColor = System.Drawing.Color.Black
|
|
Me.sblist.Cursor = System.Windows.Forms.Cursors.Default
|
|
Me.sblist.DataChanged = False
|
|
Me.sblist.DeadAreaBackColor = System.Drawing.Color.Empty
|
|
Me.sblist.Dock = System.Windows.Forms.DockStyle.Fill
|
|
Me.sblist.ExpandColor = System.Drawing.Color.Black
|
|
Me.sblist.FetchRowStyles = True
|
|
Me.sblist.FilterBar = True
|
|
Me.sblist.GroupByCaption = "Drag a column header here to group by that column"
|
|
Me.sblist.Images.Add(CType(resources.GetObject("resource.Images"), System.Drawing.Bitmap))
|
|
Me.sblist.MarqueeStyle = C1.Win.C1TrueDBGrid.MarqueeEnum.DottedCellBorder
|
|
Me.sblist.MultiSelect = C1.Win.C1TrueDBGrid.MultiSelectEnum.None
|
|
Me.sblist.Name = "sblist"
|
|
Me.sblist.PreviewInfo.Location = New System.Drawing.Point(0, 0)
|
|
Me.sblist.PreviewInfo.Size = New System.Drawing.Size(0, 0)
|
|
Me.sblist.PreviewInfo.ZoomFactor = 75
|
|
Me.sblist.PrintInfo.ShowOptionsDialog = False
|
|
Me.sblist.RecordSelectorWidth = 16
|
|
GridLines1.Color = System.Drawing.Color.DarkGray
|
|
GridLines1.Style = C1.Win.C1TrueDBGrid.LineStyleEnum.Single
|
|
Me.sblist.RowDivider = GridLines1
|
|
Me.sblist.RowHeight = 15
|
|
Me.sblist.RowSubDividerColor = System.Drawing.Color.DarkGray
|
|
Me.sblist.ScrollTips = True
|
|
Me.sblist.Size = New System.Drawing.Size(528, 253)
|
|
Me.sblist.TabIndex = 29
|
|
Me.sblist.Text = "C1TrueDBGrid1"
|
|
Me.sblist.PropBag = "<?xml version=""1.0""?><Blob><Styles type=""C1.Win.C1TrueDBGrid.Design.ContextWrappe" & _
|
|
"r""><Data>Style11{}Style12{}Style13{}Style5{}Style4{}Style7{}Style6{}EvenRow{Wrap" & _
|
|
":True;Trimming:None;BackColor:White;}Selected{ForeColor:HighlightText;BackColor:" & _
|
|
"Highlight;}Heading{Wrap:True;BackColor:Control;Border:Raised,,1, 1, 1, 1;ForeCol" & _
|
|
"or:ControlText;AlignVert:Center;}Inactive{ForeColor:InactiveCaptionText;BackColo" & _
|
|
"r:InactiveCaption;}FilterBar{BackColor:255, 255, 192;}Footer{}Caption{AlignHorz:" & _
|
|
"Center;}Editor{}Normal{Wrap:True;BackColor:Control;}Style27{}Style26{}HighlightR" & _
|
|
"ow{ForeColor:HighlightText;BackColor:Highlight;}Style1{}OddRow{Wrap:True;AlignHo" & _
|
|
"rz:General;BackColor:224, 224, 224;}RecordSelector{AlignImage:Center;}Style9{}St" & _
|
|
"yle8{}Style3{}Style2{}Group{AlignVert:Center;Border:None,,0, 0, 0, 0;BackColor:C" & _
|
|
"ontrolDark;}Style10{AlignHorz:Near;}</Data></Styles><Splits><C1.Win.C1TrueDBGrid" & _
|
|
".MergeView Name="""" AllowRowSizing=""IndividualRows"" AlternatingRowStyle=""True"" Ca" & _
|
|
"ptionHeight=""17"" ColumnCaptionHeight=""17"" ColumnFooterHeight=""17"" FetchRowStyles" & _
|
|
"=""True"" FilterBar=""True"" MarqueeStyle=""DottedCellBorder"" RecordSelectorWidth=""16" & _
|
|
""" DefRecSelWidth=""16"" VerticalScrollGroup=""1"" HorizontalScrollGroup=""1""><ClientR" & _
|
|
"ect>0, 0, 524, 249</ClientRect><BorderSide>0</BorderSide><CaptionStyle parent=""H" & _
|
|
"eading"" me=""Style10"" /><EditorStyle parent=""Editor"" me=""Style2"" /><EvenRowStyle " & _
|
|
"parent=""EvenRow"" me=""Style8"" /><FilterBarStyle parent=""FilterBar"" me=""Style27"" /" & _
|
|
"><FooterStyle parent=""Footer"" me=""Style4"" /><GroupStyle parent=""Group"" me=""Style" & _
|
|
"12"" /><HeadingStyle parent=""Heading"" me=""Style3"" /><HighLightRowStyle parent=""Hi" & _
|
|
"ghlightRow"" me=""Style7"" /><InactiveStyle parent=""Inactive"" me=""Style6"" /><OddRow" & _
|
|
"Style parent=""OddRow"" me=""Style9"" /><RecordSelectorStyle parent=""RecordSelector""" & _
|
|
" me=""Style11"" /><SelectedStyle parent=""Selected"" me=""Style5"" /><Style parent=""No" & _
|
|
"rmal"" me=""Style1"" /></C1.Win.C1TrueDBGrid.MergeView></Splits><NamedStyles><Style" & _
|
|
" parent="""" me=""Normal"" /><Style parent=""Normal"" me=""Heading"" /><Style parent=""He" & _
|
|
"ading"" me=""Footer"" /><Style parent=""Heading"" me=""Caption"" /><Style parent=""Headi" & _
|
|
"ng"" me=""Inactive"" /><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" & _
|
|
"=""RecordSelector"" /><Style parent=""Normal"" me=""FilterBar"" /><Style parent=""Capti" & _
|
|
"on"" me=""Group"" /></NamedStyles><vertSplits>1</vertSplits><horzSplits>1</horzSpli" & _
|
|
"ts><Layout>Modified</Layout><DefaultRecSelWidth>16</DefaultRecSelWidth><ClientAr" & _
|
|
"ea>0, 0, 524, 249</ClientArea></Blob>"
|
|
'
|
|
'GroupBox1
|
|
'
|
|
Me.GroupBox1.Controls.AddRange(New System.Windows.Forms.Control() {Me.Panel3})
|
|
Me.GroupBox1.Dock = System.Windows.Forms.DockStyle.Fill
|
|
Me.GroupBox1.Location = New System.Drawing.Point(528, 0)
|
|
Me.GroupBox1.Name = "GroupBox1"
|
|
Me.GroupBox1.Size = New System.Drawing.Size(240, 253)
|
|
Me.GroupBox1.TabIndex = 31
|
|
Me.GroupBox1.TabStop = False
|
|
Me.GroupBox1.Text = "Details zum Serienbrief"
|
|
'
|
|
'frmSerienbriefe_Load
|
|
'
|
|
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
|
|
Me.ClientSize = New System.Drawing.Size(768, 301)
|
|
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.GroupBox1, Me.Panel2, Me.Panel1, Me.ListBox1})
|
|
Me.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle
|
|
Me.Icon = CType(resources.GetObject("$this.Icon"), System.Drawing.Icon)
|
|
Me.Name = "frmSerienbriefe_Load"
|
|
Me.Text = "Serienbrief laden"
|
|
Me.Panel1.ResumeLayout(False)
|
|
Me.Panel2.ResumeLayout(False)
|
|
Me.Panel3.ResumeLayout(False)
|
|
CType(Me.sblist, System.ComponentModel.ISupportInitialize).EndInit()
|
|
Me.GroupBox1.ResumeLayout(False)
|
|
Me.ResumeLayout(False)
|
|
|
|
End Sub
|
|
|
|
#End Region
|
|
|
|
Dim m_serienbriefnr As Integer
|
|
Property Serienbriefnr() As Integer
|
|
Get
|
|
Return m_serienbriefnr
|
|
End Get
|
|
Set(ByVal Value As Integer)
|
|
m_serienbriefnr = Value
|
|
End Set
|
|
End Property
|
|
Private Sub frmSerienbriefe_Load_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
|
|
Dim dt As New DataTable()
|
|
dt = Load_Serienbriefe()
|
|
Me.sblist.DataSource = dt
|
|
Me.sblist.DataMember = dt.TableName
|
|
Me.sblist.Splits(0).DisplayColumns(0).Visible = False
|
|
Dim i As Integer
|
|
For i = 5 To Me.sblist.Splits(0).DisplayColumns.Count - 1
|
|
Me.sblist.Splits(0).DisplayColumns(i).Visible = False
|
|
Next
|
|
'Me.sblist.AllowRowSizing = C1.Win.C1TrueDBGrid.RowSizingEnum.IndividualRows
|
|
Me.sblist.Splits(0).DisplayColumns(1).Width = 170
|
|
Me.sblist.Splits(0).DisplayColumns(2).Width = 80
|
|
Me.sblist.Splits(0).DisplayColumns(3).Width = 120
|
|
Me.sblist.Splits(0).DisplayColumns(4).Width = 100
|
|
|
|
For i = 0 To Me.sblist.Splits(0).Rows.Count - 1
|
|
Me.sblist.Splits(0).Rows(i).AutoSize()
|
|
Next
|
|
If dt.Rows.Count < 1 Then
|
|
Me.Button1.Enabled = False
|
|
End If
|
|
' Me.sblist.Columns("Status").FilterText = "in Bearbeitung"
|
|
End Sub
|
|
|
|
Private Function Load_Serienbriefe() 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_sb_get_serienbriefe"
|
|
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))
|
|
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
|
|
Try
|
|
Me.Serienbriefnr = Me.sblist.Columns(0).Value
|
|
Catch
|
|
Exit Sub
|
|
End Try
|
|
|
|
'Me.Serienbriefnr = Me.ListBox1.SelectedValue
|
|
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.Serienbriefnr = -1
|
|
Me.Close()
|
|
End Sub
|
|
|
|
Private Sub ListBox1_DoubleClick(ByVal sender As Object, ByVal e As System.EventArgs) Handles ListBox1.DoubleClick
|
|
Me.Button1_Click(sender, e)
|
|
End Sub
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Private Sub sblist_DoubleClick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles sblist.DoubleClick
|
|
Try
|
|
Me.Button1_Click(sender, e)
|
|
Catch
|
|
End Try
|
|
End Sub
|
|
|
|
Private Sub sblist_RowColChange(ByVal sender As System.Object, ByVal e As C1.Win.C1TrueDBGrid.RowColChangeEventArgs) Handles sblist.RowColChange
|
|
Try
|
|
Me.TVStatus.BeginUpdate()
|
|
Me.TVStatus.Nodes.Clear()
|
|
Dim tn As New TreeNode()
|
|
Dim tn1 As New TreeNode()
|
|
Dim tn2 As New TreeNode()
|
|
|
|
Dim iFehlerhaft As Integer
|
|
Dim iInBearbeitung As Integer
|
|
Dim iNichtgeneriert As Integer
|
|
Dim iAusgeloest As Integer
|
|
Dim iErstellt As Integer
|
|
Dim iGedruckt As Integer
|
|
Dim iBestaetigt As Integer
|
|
|
|
iFehlerhaft = Me.sblist.Columns("fehlerhaft").Value
|
|
iNichtgeneriert = Me.sblist.Columns("inBearbeitung").Value
|
|
iAusgeloest = Me.sblist.Columns("ausgeloest").Value
|
|
iErstellt = Me.sblist.Columns("erstellt").Value
|
|
iGedruckt = Me.sblist.Columns("gedruckt").Value
|
|
iBestaetigt = Me.sblist.Columns("bestaetigt").Value
|
|
|
|
tn = Me.TVStatus.Nodes.Add(Me.sblist.Columns(1).Text)
|
|
|
|
tn.SelectedImageIndex = 0
|
|
tn.ImageIndex = -99
|
|
tn.Tag = -3
|
|
If Me.sblist.Columns("sbstatus").Value > 0 Then
|
|
tn1 = tn.Nodes.Add("in Bearbeitung (0)")
|
|
Else
|
|
tn1 = tn.Nodes.Add("in Bearbeitung (" + Str(iFehlerhaft + iNichtgeneriert + iErstellt + iGedruckt + iBestaetigt).Trim + ")")
|
|
End If
|
|
|
|
tn1.Tag = -9
|
|
tn1.SelectedImageIndex = 0
|
|
tn1.ImageIndex = -99
|
|
If Me.sblist.Columns("sbstatus").Value > 0 Then
|
|
tn1 = tn.Nodes.Add("Dokumentgenerierung ausgelöst " + "(" + Str(iAusgeloest).Trim + ")")
|
|
tn1.Tag = 1
|
|
tn1.SelectedImageIndex = 0
|
|
tn1.ImageIndex = -99
|
|
tn1 = tn.Nodes.Add("Abgeschlossen (" + Str(iFehlerhaft + iNichtgeneriert + iErstellt + iGedruckt + iBestaetigt).Trim + ")")
|
|
tn1.Tag = -4
|
|
tn1.SelectedImageIndex = 0
|
|
tn1.ImageIndex = -99
|
|
End If
|
|
tn2 = tn1.Nodes.Add("Fehlerhaft " + "(" + Str(iFehlerhaft).Trim + ")")
|
|
tn2.Tag = -1
|
|
tn2.SelectedImageIndex = 0
|
|
tn2.ImageIndex = -99
|
|
tn2 = tn1.Nodes.Add("Empfänger in Bearbeitung " + "(" + Str(iNichtgeneriert).Trim + ")")
|
|
tn2.Tag = 0
|
|
tn2.SelectedImageIndex = 0
|
|
tn2.ImageIndex = -99
|
|
tn2 = tn1.Nodes.Add("Dokumente erstellt " + "(" + Str(iErstellt).Trim + ")")
|
|
tn2.Tag = 2
|
|
tn2.SelectedImageIndex = 0
|
|
tn2.ImageIndex = -99
|
|
|
|
|
|
tn2 = tn1.Nodes.Add("Dokumente gedruckt " + "(" + Str(iGedruckt).Trim + ")")
|
|
tn2.Tag = 3
|
|
tn2.SelectedImageIndex = 0
|
|
tn2.ImageIndex = -99
|
|
|
|
tn2 = tn1.Nodes.Add("Dokumente bestätigt " + "(" + Str(iBestaetigt).Trim + ")")
|
|
tn2.Tag = 4
|
|
tn2.SelectedImageIndex = 0
|
|
tn2.ImageIndex = -99
|
|
Me.TVStatus.ExpandAll()
|
|
If Me.sblist.Columns("sbstatus").Value < 1 Then
|
|
tn1 = tn.Nodes.Add("Dokumentgenerierung ausgelöst " + "(" + Str(iAusgeloest).Trim + ")")
|
|
tn1.Tag = 1
|
|
tn1.SelectedImageIndex = 0
|
|
tn1.ImageIndex = -99
|
|
tn1 = tn.Nodes.Add("Abgeschlossen")
|
|
tn1.Tag = -4
|
|
tn1.SelectedImageIndex = 0
|
|
tn1.ImageIndex = -99
|
|
|
|
End If
|
|
Catch
|
|
Finally
|
|
Me.TVStatus.EndUpdate()
|
|
End Try
|
|
End Sub
|
|
End Class
|