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.
509 lines
23 KiB
509 lines
23 KiB
Imports System.Data
|
|
Imports System.Data.SqlTypes
|
|
Imports System.Data.SqlClient
|
|
Imports System.ComponentModel
|
|
Imports System.Drawing
|
|
Imports System.Drawing.Color
|
|
|
|
Public Class frmDefekteDokumente
|
|
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 ToolBar1 As System.Windows.Forms.ToolBar
|
|
Friend WithEvents Label1 As System.Windows.Forms.Label
|
|
Friend WithEvents ImageList1 As System.Windows.Forms.ImageList
|
|
Friend WithEvents ToolBarButton1 As System.Windows.Forms.ToolBarButton
|
|
Friend WithEvents ContextMenu1 As System.Windows.Forms.ContextMenu
|
|
Friend WithEvents MenuItem1 As System.Windows.Forms.MenuItem
|
|
Friend WithEvents MenuItem2 As System.Windows.Forms.MenuItem
|
|
Friend WithEvents MenuItem3 As System.Windows.Forms.MenuItem
|
|
Friend WithEvents C1TrueDBGrid1 As C1.Win.C1TrueDBGrid.C1TrueDBGrid
|
|
Friend WithEvents MenuItem4 As System.Windows.Forms.MenuItem
|
|
Friend WithEvents MenuItem5 As System.Windows.Forms.MenuItem
|
|
Friend WithEvents MenuItem6 As System.Windows.Forms.MenuItem
|
|
Friend WithEvents MenuItem7 As System.Windows.Forms.MenuItem
|
|
Friend WithEvents Label2 As System.Windows.Forms.Label
|
|
Friend WithEvents Label3 As System.Windows.Forms.Label
|
|
Friend WithEvents Label4 As System.Windows.Forms.Label
|
|
Friend WithEvents Label5 As System.Windows.Forms.Label
|
|
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
|
|
Me.components = New System.ComponentModel.Container()
|
|
Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(frmDefekteDokumente))
|
|
Dim GridLines1 As C1.Win.C1TrueDBGrid.Util.GridLines = New C1.Win.C1TrueDBGrid.Util.GridLines()
|
|
Me.ToolBar1 = New System.Windows.Forms.ToolBar()
|
|
Me.ToolBarButton1 = New System.Windows.Forms.ToolBarButton()
|
|
Me.ImageList1 = New System.Windows.Forms.ImageList(Me.components)
|
|
Me.Label1 = New System.Windows.Forms.Label()
|
|
Me.ContextMenu1 = New System.Windows.Forms.ContextMenu()
|
|
Me.MenuItem1 = New System.Windows.Forms.MenuItem()
|
|
Me.MenuItem2 = New System.Windows.Forms.MenuItem()
|
|
Me.MenuItem3 = New System.Windows.Forms.MenuItem()
|
|
Me.MenuItem4 = New System.Windows.Forms.MenuItem()
|
|
Me.MenuItem5 = New System.Windows.Forms.MenuItem()
|
|
Me.MenuItem6 = New System.Windows.Forms.MenuItem()
|
|
Me.MenuItem7 = New System.Windows.Forms.MenuItem()
|
|
Me.C1TrueDBGrid1 = New C1.Win.C1TrueDBGrid.C1TrueDBGrid()
|
|
Me.Label2 = New System.Windows.Forms.Label()
|
|
Me.Label3 = New System.Windows.Forms.Label()
|
|
Me.Label4 = New System.Windows.Forms.Label()
|
|
Me.Label5 = New System.Windows.Forms.Label()
|
|
CType(Me.C1TrueDBGrid1, System.ComponentModel.ISupportInitialize).BeginInit()
|
|
Me.SuspendLayout()
|
|
'
|
|
'ToolBar1
|
|
'
|
|
Me.ToolBar1.Buttons.AddRange(New System.Windows.Forms.ToolBarButton() {Me.ToolBarButton1})
|
|
Me.ToolBar1.DropDownArrows = True
|
|
Me.ToolBar1.ImageList = Me.ImageList1
|
|
Me.ToolBar1.Name = "ToolBar1"
|
|
Me.ToolBar1.ShowToolTips = True
|
|
Me.ToolBar1.Size = New System.Drawing.Size(664, 25)
|
|
Me.ToolBar1.TabIndex = 0
|
|
'
|
|
'ToolBarButton1
|
|
'
|
|
Me.ToolBarButton1.ImageIndex = 0
|
|
'
|
|
'ImageList1
|
|
'
|
|
Me.ImageList1.ColorDepth = System.Windows.Forms.ColorDepth.Depth8Bit
|
|
Me.ImageList1.ImageSize = New System.Drawing.Size(16, 16)
|
|
Me.ImageList1.ImageStream = CType(resources.GetObject("ImageList1.ImageStream"), System.Windows.Forms.ImageListStreamer)
|
|
Me.ImageList1.TransparentColor = System.Drawing.Color.Transparent
|
|
'
|
|
'Label1
|
|
'
|
|
Me.Label1.Dock = System.Windows.Forms.DockStyle.Top
|
|
Me.Label1.Location = New System.Drawing.Point(0, 25)
|
|
Me.Label1.Name = "Label1"
|
|
Me.Label1.Size = New System.Drawing.Size(664, 47)
|
|
Me.Label1.TabIndex = 1
|
|
'
|
|
'ContextMenu1
|
|
'
|
|
Me.ContextMenu1.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem1, Me.MenuItem2, Me.MenuItem3, Me.MenuItem4, Me.MenuItem5, Me.MenuItem6, Me.MenuItem7})
|
|
'
|
|
'MenuItem1
|
|
'
|
|
Me.MenuItem1.Index = 0
|
|
Me.MenuItem1.Text = "Versuchen, Dokument auf der Datenbank zu sichern"
|
|
'
|
|
'MenuItem2
|
|
'
|
|
Me.MenuItem2.Index = 1
|
|
Me.MenuItem2.Text = "Eintrag löschen"
|
|
Me.MenuItem2.Visible = False
|
|
'
|
|
'MenuItem3
|
|
'
|
|
Me.MenuItem3.Index = 2
|
|
Me.MenuItem3.Text = "Dokument anzeigen"
|
|
Me.MenuItem3.Visible = False
|
|
'
|
|
'MenuItem4
|
|
'
|
|
Me.MenuItem4.Index = 3
|
|
Me.MenuItem4.Text = "Dokument löschen"
|
|
'
|
|
'MenuItem5
|
|
'
|
|
Me.MenuItem5.Index = 4
|
|
Me.MenuItem5.Text = "Partner-Dossier anzeigen"
|
|
'
|
|
'MenuItem6
|
|
'
|
|
Me.MenuItem6.Index = 5
|
|
Me.MenuItem6.Text = "-"
|
|
'
|
|
'MenuItem7
|
|
'
|
|
Me.MenuItem7.Index = 6
|
|
Me.MenuItem7.Shortcut = System.Windows.Forms.Shortcut.F5
|
|
Me.MenuItem7.Text = "Liste aktualisieren"
|
|
'
|
|
'C1TrueDBGrid1
|
|
'
|
|
Me.C1TrueDBGrid1.AllowFilter = True
|
|
Me.C1TrueDBGrid1.AllowRowSizing = C1.Win.C1TrueDBGrid.RowSizingEnum.AllRows
|
|
Me.C1TrueDBGrid1.AllowSort = True
|
|
Me.C1TrueDBGrid1.AllowUpdate = False
|
|
Me.C1TrueDBGrid1.AllowUpdateOnBlur = False
|
|
Me.C1TrueDBGrid1.AlternatingRows = True
|
|
Me.C1TrueDBGrid1.CaptionHeight = 17
|
|
Me.C1TrueDBGrid1.CollapseColor = System.Drawing.Color.Black
|
|
Me.C1TrueDBGrid1.ContextMenu = Me.ContextMenu1
|
|
Me.C1TrueDBGrid1.Cursor = System.Windows.Forms.Cursors.Default
|
|
Me.C1TrueDBGrid1.DataChanged = False
|
|
Me.C1TrueDBGrid1.DeadAreaBackColor = System.Drawing.Color.Empty
|
|
Me.C1TrueDBGrid1.Dock = System.Windows.Forms.DockStyle.Fill
|
|
Me.C1TrueDBGrid1.ExpandColor = System.Drawing.Color.Black
|
|
Me.C1TrueDBGrid1.FetchRowStyles = True
|
|
Me.C1TrueDBGrid1.FilterBar = True
|
|
Me.C1TrueDBGrid1.GroupByCaption = "Drag a column header here to group by that column"
|
|
Me.C1TrueDBGrid1.Images.Add(CType(resources.GetObject("resource.Images"), System.Drawing.Bitmap))
|
|
Me.C1TrueDBGrid1.Location = New System.Drawing.Point(0, 72)
|
|
Me.C1TrueDBGrid1.MarqueeStyle = C1.Win.C1TrueDBGrid.MarqueeEnum.DottedCellBorder
|
|
Me.C1TrueDBGrid1.MultiSelect = C1.Win.C1TrueDBGrid.MultiSelectEnum.None
|
|
Me.C1TrueDBGrid1.Name = "C1TrueDBGrid1"
|
|
Me.C1TrueDBGrid1.PreviewInfo.Location = New System.Drawing.Point(0, 0)
|
|
Me.C1TrueDBGrid1.PreviewInfo.Size = New System.Drawing.Size(0, 0)
|
|
Me.C1TrueDBGrid1.PreviewInfo.ZoomFactor = 75
|
|
Me.C1TrueDBGrid1.PrintInfo.ShowOptionsDialog = False
|
|
Me.C1TrueDBGrid1.RecordSelectorWidth = 17
|
|
GridLines1.Color = System.Drawing.Color.DarkGray
|
|
GridLines1.Style = C1.Win.C1TrueDBGrid.LineStyleEnum.Single
|
|
Me.C1TrueDBGrid1.RowDivider = GridLines1
|
|
Me.C1TrueDBGrid1.RowHeight = 15
|
|
Me.C1TrueDBGrid1.RowSubDividerColor = System.Drawing.Color.DarkGray
|
|
Me.C1TrueDBGrid1.ScrollTips = True
|
|
Me.C1TrueDBGrid1.Size = New System.Drawing.Size(664, 245)
|
|
Me.C1TrueDBGrid1.TabIndex = 26
|
|
Me.C1TrueDBGrid1.Text = "C1TrueDBGrid1"
|
|
Me.C1TrueDBGrid1.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=""17"" DefRecSelWid" & _
|
|
"th=""17"" VerticalScrollGroup=""1"" HorizontalScrollGroup=""1""><ClientRect>0, 0, 660," & _
|
|
" 241</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>17</DefaultRecSelWidth><ClientArea>0, 0, 660, " & _
|
|
"241</ClientArea></Blob>"
|
|
'
|
|
'Label2
|
|
'
|
|
Me.Label2.Location = New System.Drawing.Point(8, 48)
|
|
Me.Label2.Name = "Label2"
|
|
Me.Label2.Size = New System.Drawing.Size(272, 23)
|
|
Me.Label2.TabIndex = 27
|
|
Me.Label2.Text = "Bearbeiten Sie die Dokumente mittels Kontextmenü."
|
|
'
|
|
'Label3
|
|
'
|
|
Me.Label3.Location = New System.Drawing.Point(8, 32)
|
|
Me.Label3.Name = "Label3"
|
|
Me.Label3.Size = New System.Drawing.Size(488, 23)
|
|
Me.Label3.TabIndex = 28
|
|
Me.Label3.Text = "Die unten aufgeführten Dokumente sind nicht ordnungsgemäss auf der Datenbank gesp" & _
|
|
"eichert."
|
|
'
|
|
'Label4
|
|
'
|
|
Me.Label4.BackColor = System.Drawing.SystemColors.ActiveCaption
|
|
Me.Label4.Location = New System.Drawing.Point(328, 48)
|
|
Me.Label4.Name = "Label4"
|
|
Me.Label4.Size = New System.Drawing.Size(16, 8)
|
|
Me.Label4.TabIndex = 30
|
|
'
|
|
'Label5
|
|
'
|
|
Me.Label5.BackColor = System.Drawing.SystemColors.ActiveCaption
|
|
Me.Label5.Location = New System.Drawing.Point(0, 32)
|
|
Me.Label5.Name = "Label5"
|
|
Me.Label5.Size = New System.Drawing.Size(4, 32)
|
|
Me.Label5.TabIndex = 31
|
|
'
|
|
'frmDefekteDokumente
|
|
'
|
|
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
|
|
Me.ClientSize = New System.Drawing.Size(664, 317)
|
|
Me.ControlBox = False
|
|
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.Label5, Me.Label4, Me.Label2, Me.Label3, Me.C1TrueDBGrid1, Me.Label1, Me.ToolBar1})
|
|
Me.Icon = CType(resources.GetObject("$this.Icon"), System.Drawing.Icon)
|
|
Me.MaximizeBox = False
|
|
Me.MinimizeBox = False
|
|
Me.Name = "frmDefekteDokumente"
|
|
Me.Text = "Problemdokumente"
|
|
CType(Me.C1TrueDBGrid1, System.ComponentModel.ISupportInitialize).EndInit()
|
|
Me.ResumeLayout(False)
|
|
|
|
End Sub
|
|
|
|
#End Region
|
|
Dim hiddenbuttonpressed As Boolean = False
|
|
Dim m_start As Boolean
|
|
Property Start() As Boolean
|
|
Get
|
|
Return False
|
|
End Get
|
|
Set(ByVal Value As Boolean)
|
|
m_start = Value
|
|
End Set
|
|
End Property
|
|
Dim m_fnkt As Integer
|
|
Property fnkt() As Integer
|
|
Get
|
|
Return m_fnkt
|
|
End Get
|
|
Set(ByVal Value As Integer)
|
|
m_fnkt = Value
|
|
End Set
|
|
End Property
|
|
Dim mt As DataTable
|
|
Property t() As DataTable
|
|
Get
|
|
Return mt
|
|
End Get
|
|
Set(ByVal Value As DataTable)
|
|
mt = Value
|
|
End Set
|
|
End Property
|
|
|
|
Private Sub ToolBar1_ButtonClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolBarButtonClickEventArgs) Handles ToolBar1.ButtonClick
|
|
'SHU&BUD - Closebutton ist aktiv, sofern das Programm in der Testumgebung löuft
|
|
If Globals.Applikationsdaten.Rows(0).Item("showlogin") = True Then
|
|
Me.hiddenbuttonpressed = True
|
|
Globals.Bearbeitung_Problemdokumente = False
|
|
End If
|
|
|
|
If Me.hiddenbuttonpressed = True Then
|
|
Globals.Bearbeitung_Problemdokumente = False
|
|
End If
|
|
If Globals.Bearbeitung_Problemdokumente = True And Me.C1TrueDBGrid1.Splits(0).Rows.Count > 0 Then
|
|
MyMsg.show_standardmessage(230, MsgBoxStyle.Critical)
|
|
Exit Sub
|
|
Else
|
|
Globals.Bearbeitung_Problemdokumente = False
|
|
Me.Hide()
|
|
Me.fnkt = 1
|
|
End If
|
|
'Me.Close()
|
|
End Sub
|
|
|
|
Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click
|
|
Dim d As New DocMgmt()
|
|
If d.Save_To_DB(Me.C1TrueDBGrid1.Columns(0).Text, Globals.Applikationsdaten.Rows(Globals.AppldataRow).Item("pfad_temporaer_dokumente") + Me.C1TrueDBGrid1.Columns("Dokumentname").Text) = True Then
|
|
Globals.PerfMon.Insert_DocRestore("Dokument auf DB gespeichert: " + Me.C1TrueDBGrid1.Columns(0).Text)
|
|
DivFnkt.Status_Dokumentbearbeitung(2, Me.C1TrueDBGrid1.Columns(0).Text, 0, "")
|
|
Else
|
|
MsgBox("Das Dokumente konnte nicht in der Datenbank gespeichert werden.")
|
|
End If
|
|
refresh_list()
|
|
End Sub
|
|
|
|
Private Sub MenuItem2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem2.Click
|
|
DivFnkt.Status_Dokumentbearbeitung(2, Me.C1TrueDBGrid1.Columns(0).Text, 0, "")
|
|
Globals.PerfMon.Insert_DocRestore("Dokumenteintrag ohne Speicherversuch gelöscht: " + Me.C1TrueDBGrid1.Columns(0).Text)
|
|
refresh_list()
|
|
End Sub
|
|
|
|
Public Sub refresh_list()
|
|
Dim d As New DocMgmt()
|
|
t = d.check_doc(fnkt)
|
|
Me.C1TrueDBGrid1.DataSource = t
|
|
Me.C1TrueDBGrid1.DataMember = t.TableName
|
|
d = Nothing
|
|
Dim i As Integer
|
|
For i = 0 To Me.C1TrueDBGrid1.Columns.Count - 1
|
|
Me.C1TrueDBGrid1.Splits(0).DisplayColumns(i).AutoSize()
|
|
Next
|
|
Me.C1TrueDBGrid1.Splits(0).DisplayColumns("dokumentname").Visible = False
|
|
End Sub
|
|
|
|
Private Sub MenuItem3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem3.Click
|
|
DivFnkt.ShowDoc(Me.C1TrueDBGrid1.Columns(0).Text, Me)
|
|
End Sub
|
|
|
|
Private Sub frmDefekteDokumente_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
|
|
Me.Label4.BackColor = Me.BackColor
|
|
'08.11.2004 BUD
|
|
If Globals.Applikationsdaten.Rows(0).Item("showlogin") = False Then
|
|
Me.Label5.BackColor = Me.BackColor
|
|
End If
|
|
|
|
Dim i As Integer
|
|
For i = 0 To Me.C1TrueDBGrid1.Columns.Count - 1
|
|
Me.C1TrueDBGrid1.Splits(0).DisplayColumns(i).AutoSize()
|
|
Next
|
|
Me.C1TrueDBGrid1.Splits(0).DisplayColumns("dokumentname").Visible = False
|
|
End Sub
|
|
|
|
Private Sub ContextMenu1_Popup(ByVal sender As Object, ByVal e As System.EventArgs) Handles ContextMenu1.Popup
|
|
If Me.C1TrueDBGrid1.Splits(0).Rows.Count = 0 Then
|
|
Me.MenuItem1.Enabled = False
|
|
Me.MenuItem2.Enabled = False
|
|
Me.MenuItem3.Enabled = False
|
|
Me.MenuItem4.Enabled = False
|
|
Me.MenuItem5.Enabled = False
|
|
Me.MenuItem6.Enabled = False
|
|
Me.MenuItem7.Enabled = False
|
|
Else
|
|
Me.MenuItem1.Enabled = True
|
|
Me.MenuItem3.Enabled = True
|
|
Me.MenuItem4.Enabled = True
|
|
Me.MenuItem5.Enabled = True
|
|
Me.MenuItem6.Enabled = True
|
|
Me.MenuItem7.Enabled = True
|
|
End If
|
|
If System.IO.File.Exists(Globals.Applikationsdaten.Rows(Globals.AppldataRow).Item("pfad_temporaer_dokumente") + Me.C1TrueDBGrid1.Columns("Dokumentname").Text) Then
|
|
Me.MenuItem1.Enabled = True
|
|
Else
|
|
Me.MenuItem1.Enabled = False
|
|
End If
|
|
End Sub
|
|
|
|
|
|
Private Sub MenuItem5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem5.Click
|
|
'DivFnkt.Status_Dokumentbearbeitung(2, Me.C1TrueDBGrid1.Columns(0).Text, 0, "")
|
|
Dim f As New frmSearchDoc()
|
|
f.txtbcknr.Text = Me.C1TrueDBGrid1.Columns("Dokumentid").Text
|
|
f.Visible = False
|
|
'f.Show()
|
|
f.Visible = False
|
|
f.MdiParent = Me.MdiParent
|
|
f.Show_Doc()
|
|
f.Hide()
|
|
End Sub
|
|
|
|
Private Sub MenuItem4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem4.Click
|
|
Dim f As New frmLoeschgrund()
|
|
f.txtLoeschgrund.Text = ""
|
|
f.ShowDialog()
|
|
If f.DialogResult = DialogResult.OK Then
|
|
Dim scmCmdToExecute As SqlCommand = New SqlCommand()
|
|
scmCmdToExecute.CommandText = "dbo.SP_Dokument_delete"
|
|
scmCmdToExecute.CommandType = CommandType.StoredProcedure
|
|
scmCmdToExecute.Connection = conn.scoDBConnection
|
|
conn.OpenConnection()
|
|
Try
|
|
Dim loeschgrund As String
|
|
If f.txtLoeschgrund.Text.Length > 254 Then 'begrentzt durch dbo.dokument.loeschgrund
|
|
loeschgrund = f.txtLoeschgrund.Text.Substring(0, 254)
|
|
Else
|
|
loeschgrund = f.txtLoeschgrund.Text
|
|
End If
|
|
|
|
scmCmdToExecute.Parameters.Add(New SqlParameter("@dokumentid", SqlDbType.VarChar, 22, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, Me.C1TrueDBGrid1.Columns("dokumentid").Value))
|
|
scmCmdToExecute.Parameters.Add(New SqlParameter("@mitarbeiter", SqlDbType.Int, 4, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, Globals.MitarbeiterNr))
|
|
'scmCmdToExecute.Parameters.Add(New SqlParameter("@loeschgrund", SqlDbType.VarChar, 1024, ParameterDirection.Input, True, 10, 0, "", DataRowVersion.Proposed, loeschgrund))
|
|
scmCmdToExecute.Parameters.Add("@loeschgrund", loeschgrund)
|
|
scmCmdToExecute.ExecuteNonQuery()
|
|
DivFnkt.Status_Dokumentbearbeitung(2, Me.C1TrueDBGrid1.Columns(0).Text, 0, "")
|
|
Catch ex As Exception
|
|
Throw New Exception("Dokument löschen::" & scmCmdToExecute.CommandText & "::Error occured." & ex.Message, ex)
|
|
Finally
|
|
scmCmdToExecute.Dispose()
|
|
conn.CloseConnection(True)
|
|
'gelöschtes item aus der liste entfernen, ohne refresh
|
|
'RST 2006-07-18
|
|
'old: refresh_list()
|
|
Dim dataRow As DataRow
|
|
dataRow = t.Rows.Item(C1TrueDBGrid1.Row)
|
|
t.Rows.Remove(dataRow)
|
|
C1TrueDBGrid1.Rebind()
|
|
Dim i As Integer
|
|
For i = 0 To Me.C1TrueDBGrid1.Columns.Count - 1
|
|
Me.C1TrueDBGrid1.Splits(0).DisplayColumns(i).AutoSize()
|
|
Next
|
|
End Try
|
|
End If
|
|
|
|
End Sub
|
|
|
|
Private Sub frmDefekteDokumente_Activated(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Activated
|
|
If Globals.Applikationsdaten.Rows(0).Item("showlogin") = False Then
|
|
Me.Label5.BackColor = Me.BackColor
|
|
End If
|
|
refresh_list()
|
|
End Sub
|
|
|
|
Private Sub frmDefekteDokumente_Closing(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles MyBase.Closing
|
|
If Globals.Global_ForceExit = True Then Exit Sub
|
|
If Me.hiddenbuttonpressed = True Then
|
|
Globals.Bearbeitung_Problemdokumente = False
|
|
Exit Sub
|
|
End If
|
|
If Start And Me.C1TrueDBGrid1.Splits(0).Rows.Count < 1 Then
|
|
Start = False
|
|
e.Cancel = True
|
|
Me.fnkt = 1
|
|
Me.Hide()
|
|
Exit Sub
|
|
End If
|
|
If Globals.Bearbeitung_Problemdokumente = True And Me.C1TrueDBGrid1.Splits(0).Rows.Count > 0 Then
|
|
MyMsg.show_standardmessage(230, MsgBoxStyle.Critical)
|
|
e.Cancel = True
|
|
Exit Sub
|
|
Else
|
|
Globals.Bearbeitung_Problemdokumente = False
|
|
End If
|
|
e.Cancel = True
|
|
Me.fnkt = 1
|
|
Me.Hide()
|
|
End Sub
|
|
|
|
Private Sub MenuItem7_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem7.Click
|
|
Me.refresh_list()
|
|
End Sub
|
|
|
|
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs)
|
|
Me.hiddenbuttonpressed = True
|
|
Globals.Bearbeitung_Problemdokumente = False
|
|
End Sub
|
|
|
|
Private Sub Label4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label4.Click
|
|
Me.hiddenbuttonpressed = True
|
|
Globals.Bearbeitung_Problemdokumente = False
|
|
End Sub
|
|
|
|
Private Sub Label5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Label5.Click
|
|
'***********************
|
|
'Release 3.3
|
|
'08.11.2004 / BUD
|
|
'***********************
|
|
If Globals.Applikationsdaten.Rows(0).Item("showlogin") = True Then
|
|
Me.hiddenbuttonpressed = True
|
|
Globals.Bearbeitung_Problemdokumente = False
|
|
End If
|
|
End Sub
|
|
End Class
|