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
15 KiB
399 lines
15 KiB
Imports System
|
|
Imports System.IO
|
|
Imports System.Data
|
|
Imports System.Data.SqlTypes
|
|
Imports System.Data.SqlClient
|
|
Imports System.ComponentModel
|
|
Imports UtilityLibrary.Win32
|
|
|
|
Public Class frmDokumenttypOptions
|
|
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 Panel1 As System.Windows.Forms.Panel
|
|
Friend WithEvents GroupBox1 As System.Windows.Forms.GroupBox
|
|
Friend WithEvents Button2 As System.Windows.Forms.Button
|
|
Friend WithEvents Button1 As System.Windows.Forms.Button
|
|
Friend WithEvents ToolBar2 As System.Windows.Forms.ToolBar
|
|
Friend WithEvents RichTextBoxHS1 As EDOKAApp.RichTextBoxHS
|
|
Friend WithEvents ImageList1 As System.Windows.Forms.ImageList
|
|
Friend WithEvents FontDialog1 As System.Windows.Forms.FontDialog
|
|
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 ToolBarButton2 As System.Windows.Forms.ToolBarButton
|
|
Friend WithEvents ToolBarButton1 As System.Windows.Forms.ToolBarButton
|
|
Friend WithEvents GroupBox2 As System.Windows.Forms.GroupBox
|
|
Friend WithEvents Button3 As System.Windows.Forms.Button
|
|
Friend WithEvents Button4 As System.Windows.Forms.Button
|
|
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
|
|
Me.components = New System.ComponentModel.Container()
|
|
Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(frmDokumenttypOptions))
|
|
Me.ToolBar1 = New System.Windows.Forms.ToolBar()
|
|
Me.ToolBarButton1 = New System.Windows.Forms.ToolBarButton()
|
|
Me.ImageList1 = New System.Windows.Forms.ImageList(Me.components)
|
|
Me.Panel1 = New System.Windows.Forms.Panel()
|
|
Me.GroupBox2 = New System.Windows.Forms.GroupBox()
|
|
Me.Button3 = New System.Windows.Forms.Button()
|
|
Me.Button4 = New System.Windows.Forms.Button()
|
|
Me.GroupBox1 = New System.Windows.Forms.GroupBox()
|
|
Me.Button2 = New System.Windows.Forms.Button()
|
|
Me.Button1 = New System.Windows.Forms.Button()
|
|
Me.ToolBar2 = New System.Windows.Forms.ToolBar()
|
|
Me.ToolBarButton2 = New System.Windows.Forms.ToolBarButton()
|
|
Me.RichTextBoxHS1 = New EDOKAApp.RichTextBoxHS()
|
|
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.FontDialog1 = New System.Windows.Forms.FontDialog()
|
|
Me.Panel1.SuspendLayout()
|
|
Me.GroupBox2.SuspendLayout()
|
|
Me.GroupBox1.SuspendLayout()
|
|
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(936, 25)
|
|
Me.ToolBar1.TabIndex = 2
|
|
'
|
|
'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
|
|
'
|
|
'Panel1
|
|
'
|
|
Me.Panel1.Controls.AddRange(New System.Windows.Forms.Control() {Me.GroupBox2, Me.GroupBox1})
|
|
Me.Panel1.Dock = System.Windows.Forms.DockStyle.Top
|
|
Me.Panel1.Location = New System.Drawing.Point(0, 25)
|
|
Me.Panel1.Name = "Panel1"
|
|
Me.Panel1.Size = New System.Drawing.Size(936, 73)
|
|
Me.Panel1.TabIndex = 3
|
|
'
|
|
'GroupBox2
|
|
'
|
|
Me.GroupBox2.Controls.AddRange(New System.Windows.Forms.Control() {Me.Button3, Me.Button4})
|
|
Me.GroupBox2.Location = New System.Drawing.Point(208, 4)
|
|
Me.GroupBox2.Name = "GroupBox2"
|
|
Me.GroupBox2.Size = New System.Drawing.Size(232, 64)
|
|
Me.GroupBox2.TabIndex = 3
|
|
Me.GroupBox2.TabStop = False
|
|
Me.GroupBox2.Text = "Dokumenterstellung für EDOKA-Partner"
|
|
'
|
|
'Button3
|
|
'
|
|
Me.Button3.Location = New System.Drawing.Point(120, 24)
|
|
Me.Button3.Name = "Button3"
|
|
Me.Button3.TabIndex = 1
|
|
Me.Button3.Text = "Verhindern"
|
|
'
|
|
'Button4
|
|
'
|
|
Me.Button4.Location = New System.Drawing.Point(40, 24)
|
|
Me.Button4.Name = "Button4"
|
|
Me.Button4.TabIndex = 0
|
|
Me.Button4.Text = "Zulassen"
|
|
'
|
|
'GroupBox1
|
|
'
|
|
Me.GroupBox1.Controls.AddRange(New System.Windows.Forms.Control() {Me.Button2, Me.Button1})
|
|
Me.GroupBox1.Location = New System.Drawing.Point(8, 4)
|
|
Me.GroupBox1.Name = "GroupBox1"
|
|
Me.GroupBox1.Size = New System.Drawing.Size(192, 64)
|
|
Me.GroupBox1.TabIndex = 2
|
|
Me.GroupBox1.TabStop = False
|
|
Me.GroupBox1.Text = "Erstellung Leerdokument"
|
|
'
|
|
'Button2
|
|
'
|
|
Me.Button2.Location = New System.Drawing.Point(96, 24)
|
|
Me.Button2.Name = "Button2"
|
|
Me.Button2.TabIndex = 1
|
|
Me.Button2.Text = "Verhindern"
|
|
'
|
|
'Button1
|
|
'
|
|
Me.Button1.Location = New System.Drawing.Point(16, 24)
|
|
Me.Button1.Name = "Button1"
|
|
Me.Button1.TabIndex = 0
|
|
Me.Button1.Text = "Zulassen"
|
|
'
|
|
'ToolBar2
|
|
'
|
|
Me.ToolBar2.Buttons.AddRange(New System.Windows.Forms.ToolBarButton() {Me.ToolBarButton2})
|
|
Me.ToolBar2.DropDownArrows = True
|
|
Me.ToolBar2.ImageList = Me.ImageList1
|
|
Me.ToolBar2.Location = New System.Drawing.Point(0, 98)
|
|
Me.ToolBar2.Name = "ToolBar2"
|
|
Me.ToolBar2.ShowToolTips = True
|
|
Me.ToolBar2.Size = New System.Drawing.Size(936, 25)
|
|
Me.ToolBar2.TabIndex = 4
|
|
'
|
|
'ToolBarButton2
|
|
'
|
|
Me.ToolBarButton2.ImageIndex = 2
|
|
'
|
|
'RichTextBoxHS1
|
|
'
|
|
Me.RichTextBoxHS1.AcceptsTab = True
|
|
Me.RichTextBoxHS1.ContextMenu = Me.ContextMenu1
|
|
Me.RichTextBoxHS1.Dock = System.Windows.Forms.DockStyle.Fill
|
|
Me.RichTextBoxHS1.Font = New System.Drawing.Font("Microsoft Sans Serif", 9.75!, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, CType(0, Byte))
|
|
Me.RichTextBoxHS1.Location = New System.Drawing.Point(0, 123)
|
|
Me.RichTextBoxHS1.Name = "RichTextBoxHS1"
|
|
Me.RichTextBoxHS1.Size = New System.Drawing.Size(936, 442)
|
|
Me.RichTextBoxHS1.TabIndex = 5
|
|
Me.RichTextBoxHS1.Text = ""
|
|
'
|
|
'ContextMenu1
|
|
'
|
|
Me.ContextMenu1.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem1, Me.MenuItem2, Me.MenuItem3})
|
|
'
|
|
'MenuItem1
|
|
'
|
|
Me.MenuItem1.Index = 0
|
|
Me.MenuItem1.Text = "Schriftart..."
|
|
'
|
|
'MenuItem2
|
|
'
|
|
Me.MenuItem2.Index = 1
|
|
Me.MenuItem2.Text = "Gelb markieren"
|
|
'
|
|
'MenuItem3
|
|
'
|
|
Me.MenuItem3.Index = 2
|
|
Me.MenuItem3.Text = "&Markierungen löschen"
|
|
'
|
|
'frmDokumenttypOptions
|
|
'
|
|
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
|
|
Me.ClientSize = New System.Drawing.Size(936, 565)
|
|
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.RichTextBoxHS1, Me.ToolBar2, Me.Panel1, Me.ToolBar1})
|
|
Me.FormBorderStyle = System.Windows.Forms.FormBorderStyle.SizableToolWindow
|
|
Me.Name = "frmDokumenttypOptions"
|
|
Me.ShowInTaskbar = False
|
|
Me.Text = "Diverse Dokumenttyp-Einstellungen"
|
|
Me.Panel1.ResumeLayout(False)
|
|
Me.GroupBox2.ResumeLayout(False)
|
|
Me.GroupBox1.ResumeLayout(False)
|
|
Me.ResumeLayout(False)
|
|
|
|
End Sub
|
|
|
|
#End Region
|
|
|
|
Dim m_dokumenttypnr As Integer
|
|
Property Dokumenttypnr() As Integer
|
|
Get
|
|
Return m_dokumenttypnr
|
|
End Get
|
|
Set(ByVal Value As Integer)
|
|
m_dokumenttypnr = Value
|
|
Me.key = Value
|
|
End Set
|
|
End Property
|
|
|
|
Dim m_key As Integer = 0
|
|
Property key() As Integer
|
|
Get
|
|
Return m_key
|
|
End Get
|
|
Set(ByVal Value As Integer)
|
|
m_key = Value
|
|
End Set
|
|
End Property
|
|
|
|
Private Sub frmDokumenttypOptions_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
|
|
If DivFnkt.leererstellung(3, Me.Dokumenttypnr) = True Then
|
|
Me.Button2.Enabled = True
|
|
Me.Button1.Enabled = False
|
|
Else
|
|
Me.Button2.Enabled = False
|
|
Me.Button1.Enabled = True
|
|
End If
|
|
If DivFnkt.EDOKA_Partner_Dokument(3, Me.Dokumenttypnr) = True Then
|
|
Me.Button3.Enabled = True
|
|
Me.Button4.Enabled = False
|
|
Else
|
|
Me.Button3.Enabled = False
|
|
Me.Button4.Enabled = True
|
|
End If
|
|
Get_From_DB()
|
|
End Sub
|
|
|
|
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
|
|
DivFnkt.leererstellung(1, Me.Dokumenttypnr)
|
|
Me.Button1.Enabled = False
|
|
Me.Button2.Enabled = True
|
|
End Sub
|
|
|
|
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
|
|
DivFnkt.leererstellung(2, Me.Dokumenttypnr)
|
|
Me.Button1.Enabled = True
|
|
Me.Button2.Enabled = False
|
|
End Sub
|
|
|
|
Private Sub ToolBar1_ButtonClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolBarButtonClickEventArgs) Handles ToolBar1.ButtonClick
|
|
Me.Close()
|
|
End Sub
|
|
|
|
Private Sub ToolBar2_ButtonClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolBarButtonClickEventArgs) Handles ToolBar2.ButtonClick
|
|
Save_To_DB()
|
|
End Sub
|
|
|
|
Public Function Get_From_DB()
|
|
Dim connection As New SqlConnection()
|
|
Dim da As New SqlDataAdapter("Select * From dokumenttypbeschreibung where dokumenttypbeschreibungnr=" + Str(key), connection)
|
|
Dim CB As SqlCommandBuilder = New SqlCommandBuilder(da)
|
|
Dim ds As New DataSet()
|
|
Dim dokname As String
|
|
dokname = Globals.Applikationsdaten.Rows(Globals.AppldataRow).Item("pfad_temporaer_dokumente") + "tmp.rtf"
|
|
Try
|
|
connection.ConnectionString = Globals.sConnectionString
|
|
connection.Open()
|
|
da.Fill(ds, "docbeschreibung")
|
|
Dim myRow As DataRow
|
|
myRow = ds.Tables(0).Rows(0)
|
|
Dim MyData() As Byte
|
|
MyData = myRow.Item(1)
|
|
Dim K As Long
|
|
K = UBound(MyData)
|
|
|
|
Dim fs As New FileStream(dokname, FileMode.OpenOrCreate, FileAccess.Write)
|
|
fs.Write(MyData, 0, K)
|
|
fs.Close()
|
|
fs = Nothing
|
|
Me.RichTextBoxHS1.LoadFile(dokname)
|
|
Me.ToolBar1.Buttons(2).Enabled = True
|
|
Catch ex As Exception
|
|
Return False
|
|
Finally
|
|
CB = Nothing
|
|
ds = Nothing
|
|
da = Nothing
|
|
connection.Close()
|
|
connection = Nothing
|
|
End Try
|
|
Return True
|
|
End Function
|
|
|
|
Public Function Save_To_DB()
|
|
|
|
Dim Connection As New SqlConnection()
|
|
|
|
Dim da As New SqlDataAdapter("Select * From dokumenttypbeschreibung where dokumenttypbeschreibungnr=" + Str(key), Connection)
|
|
Dim cb As SqlCommandBuilder = New SqlCommandBuilder(da)
|
|
Dim ds As New DataSet()
|
|
Dim dokname As String
|
|
dokname = Globals.Applikationsdaten.Rows(Globals.AppldataRow).Item("pfad_temporaer_dokumente") + "tmp.rtf"
|
|
Me.RichTextBoxHS1.SaveFile(dokname)
|
|
Dim fs As New FileStream(dokname, FileMode.OpenOrCreate, FileAccess.Read)
|
|
Dim mydata(fs.Length) As Byte
|
|
Try
|
|
fs.Read(mydata, 0, fs.Length)
|
|
fs.Close()
|
|
Connection.ConnectionString = Globals.sConnectionString
|
|
Connection.Open()
|
|
da.Fill(ds, "docs")
|
|
Dim myRow As DataRow
|
|
If ds.Tables(0).Rows.Count = 0 Then
|
|
' Neues Dokument speichern
|
|
myRow = ds.Tables(0).NewRow
|
|
myRow.Item(0) = key
|
|
myRow.Item(1) = mydata
|
|
myRow.Item(2) = Now
|
|
myRow.Item(3) = Globals.MitarbeiterNr
|
|
ds.Tables(0).Rows.Add(myRow)
|
|
da.Update(ds, "docs")
|
|
Else
|
|
myRow = ds.Tables(0).Rows(0)
|
|
myRow.Item(1) = mydata
|
|
da.Update(ds, "docs")
|
|
End If
|
|
Catch ex As Exception
|
|
MsgBox(ex.Message)
|
|
MyMsg.show_standardmessage(86, MsgBoxStyle.Critical)
|
|
Return False
|
|
Finally
|
|
fs = Nothing
|
|
cb = Nothing
|
|
ds = Nothing
|
|
da = Nothing
|
|
|
|
Connection.Close()
|
|
Connection = Nothing
|
|
End Try
|
|
Return True
|
|
End Function
|
|
|
|
Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click
|
|
DivFnkt.EDOKA_Partner_Dokument(1, Me.Dokumenttypnr)
|
|
Me.Button4.Enabled = False
|
|
Me.Button3.Enabled = True
|
|
End Sub
|
|
|
|
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
|
|
DivFnkt.EDOKA_Partner_Dokument(2, Me.Dokumenttypnr)
|
|
Me.Button4.Enabled = True
|
|
Me.Button3.Enabled = False
|
|
End Sub
|
|
|
|
Private Sub MenuItem1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem1.Click
|
|
Me.FontDialog1.ShowColor = True
|
|
Me.FontDialog1.ShowApply = True
|
|
Me.FontDialog1.ShowEffects = True
|
|
Me.FontDialog1.ShowDialog()
|
|
RichTextBoxHS1.SelectionFont = Me.FontDialog1.Font
|
|
RichTextBoxHS1.SelectionColor = Me.FontDialog1.Color
|
|
End Sub
|
|
|
|
Private Sub MenuItem2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem2.Click
|
|
RichTextBoxHS1.SelectionBackColor = System.Drawing.Color.Yellow
|
|
End Sub
|
|
|
|
Private Sub MenuItem3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem3.Click
|
|
RichTextBoxHS1.BackColorSetWhole(System.Drawing.Color.White)
|
|
End Sub
|
|
End Class
|