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.
1107 lines
69 KiB
1107 lines
69 KiB
Imports System.Data.SqlClient
|
|
Imports System.Data.SqlTypes
|
|
Imports System.Drawing
|
|
Imports System.Drawing.Color
|
|
Imports System.ComponentModel
|
|
Public Class frmDomainReportfeldregel
|
|
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 MainMenu1 As System.Windows.Forms.MainMenu
|
|
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 ImageList1 As System.Windows.Forms.ImageList
|
|
Friend WithEvents ToolBar1 As System.Windows.Forms.ToolBar
|
|
Friend WithEvents ToolBtnExit As System.Windows.Forms.ToolBarButton
|
|
Friend WithEvents ToolBtnSave As System.Windows.Forms.ToolBarButton
|
|
Friend WithEvents DataSet1 As System.Data.DataSet
|
|
Friend WithEvents SqlConnection1 As System.Data.SqlClient.SqlConnection
|
|
Friend WithEvents SqlDataAdapter2 As System.Data.SqlClient.SqlDataAdapter
|
|
Friend WithEvents SqlSelectCommand2 As System.Data.SqlClient.SqlCommand
|
|
Friend WithEvents SqlInsertCommand2 As System.Data.SqlClient.SqlCommand
|
|
Friend WithEvents SqlUpdateCommand2 As System.Data.SqlClient.SqlCommand
|
|
Friend WithEvents SqlDeleteCommand2 As System.Data.SqlClient.SqlCommand
|
|
Friend WithEvents SqlDataAdapter1 As System.Data.SqlClient.SqlDataAdapter
|
|
Friend WithEvents SqlSelectCommand1 As System.Data.SqlClient.SqlCommand
|
|
Friend WithEvents SqlInsertCommand1 As System.Data.SqlClient.SqlCommand
|
|
Friend WithEvents SqlUpdateCommand1 As System.Data.SqlClient.SqlCommand
|
|
Friend WithEvents SqlDeleteCommand1 As System.Data.SqlClient.SqlCommand
|
|
Friend WithEvents SqlConnection2 As System.Data.SqlClient.SqlConnection
|
|
Friend WithEvents Panel1 As System.Windows.Forms.Panel
|
|
Friend WithEvents DomainList As C1.Win.C1TrueDBGrid.C1TrueDBGrid
|
|
Friend WithEvents Panel3 As System.Windows.Forms.Panel
|
|
Friend WithEvents lblTyp As System.Windows.Forms.Label
|
|
Friend WithEvents lblSteuerbefehl As System.Windows.Forms.Label
|
|
Friend WithEvents lblBeschreibung As System.Windows.Forms.Label
|
|
Friend WithEvents lblDatenherkunft As System.Windows.Forms.Label
|
|
Friend WithEvents lblBezeichnung As System.Windows.Forms.Label
|
|
Friend WithEvents Panel2 As System.Windows.Forms.Panel
|
|
Friend WithEvents txtBezeichnung As System.Windows.Forms.TextBox
|
|
Friend WithEvents txtBeschreibung As System.Windows.Forms.TextBox
|
|
Friend WithEvents cboSteuerbefehl As System.Windows.Forms.ComboBox
|
|
Friend WithEvents cbofeldTyp As System.Windows.Forms.ComboBox
|
|
Friend WithEvents txtDatenherkunft As System.Windows.Forms.TextBox
|
|
<System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
|
|
Me.components = New System.ComponentModel.Container()
|
|
Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(frmDomainReportfeldregel))
|
|
Dim GridLines1 As C1.Win.C1TrueDBGrid.Util.GridLines = New C1.Win.C1TrueDBGrid.Util.GridLines()
|
|
Me.MainMenu1 = New System.Windows.Forms.MainMenu()
|
|
Me.MenuItem1 = New System.Windows.Forms.MenuItem()
|
|
Me.MenuItem2 = New System.Windows.Forms.MenuItem()
|
|
Me.MenuItem3 = New System.Windows.Forms.MenuItem()
|
|
Me.ImageList1 = New System.Windows.Forms.ImageList(Me.components)
|
|
Me.ToolBar1 = New System.Windows.Forms.ToolBar()
|
|
Me.ToolBtnExit = New System.Windows.Forms.ToolBarButton()
|
|
Me.ToolBtnSave = New System.Windows.Forms.ToolBarButton()
|
|
Me.DataSet1 = New System.Data.DataSet()
|
|
Me.SqlConnection1 = New System.Data.SqlClient.SqlConnection()
|
|
Me.SqlDataAdapter2 = New System.Data.SqlClient.SqlDataAdapter()
|
|
Me.SqlDeleteCommand2 = New System.Data.SqlClient.SqlCommand()
|
|
Me.SqlInsertCommand2 = New System.Data.SqlClient.SqlCommand()
|
|
Me.SqlSelectCommand2 = New System.Data.SqlClient.SqlCommand()
|
|
Me.SqlUpdateCommand2 = New System.Data.SqlClient.SqlCommand()
|
|
Me.SqlDataAdapter1 = New System.Data.SqlClient.SqlDataAdapter()
|
|
Me.SqlDeleteCommand1 = New System.Data.SqlClient.SqlCommand()
|
|
Me.SqlConnection2 = New System.Data.SqlClient.SqlConnection()
|
|
Me.SqlInsertCommand1 = New System.Data.SqlClient.SqlCommand()
|
|
Me.SqlSelectCommand1 = New System.Data.SqlClient.SqlCommand()
|
|
Me.SqlUpdateCommand1 = New System.Data.SqlClient.SqlCommand()
|
|
Me.Panel1 = New System.Windows.Forms.Panel()
|
|
Me.Panel2 = New System.Windows.Forms.Panel()
|
|
Me.txtBezeichnung = New System.Windows.Forms.TextBox()
|
|
Me.txtBeschreibung = New System.Windows.Forms.TextBox()
|
|
Me.cboSteuerbefehl = New System.Windows.Forms.ComboBox()
|
|
Me.cbofeldTyp = New System.Windows.Forms.ComboBox()
|
|
Me.txtDatenherkunft = New System.Windows.Forms.TextBox()
|
|
Me.Panel3 = New System.Windows.Forms.Panel()
|
|
Me.lblTyp = New System.Windows.Forms.Label()
|
|
Me.lblSteuerbefehl = New System.Windows.Forms.Label()
|
|
Me.lblBeschreibung = New System.Windows.Forms.Label()
|
|
Me.lblDatenherkunft = New System.Windows.Forms.Label()
|
|
Me.lblBezeichnung = New System.Windows.Forms.Label()
|
|
Me.DomainList = New C1.Win.C1TrueDBGrid.C1TrueDBGrid()
|
|
CType(Me.DataSet1, System.ComponentModel.ISupportInitialize).BeginInit()
|
|
Me.Panel1.SuspendLayout()
|
|
Me.Panel2.SuspendLayout()
|
|
Me.Panel3.SuspendLayout()
|
|
CType(Me.DomainList, System.ComponentModel.ISupportInitialize).BeginInit()
|
|
Me.SuspendLayout()
|
|
'
|
|
'MainMenu1
|
|
'
|
|
Me.MainMenu1.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem1})
|
|
'
|
|
'MenuItem1
|
|
'
|
|
Me.MenuItem1.Index = 0
|
|
Me.MenuItem1.MenuItems.AddRange(New System.Windows.Forms.MenuItem() {Me.MenuItem2, Me.MenuItem3})
|
|
Me.MenuItem1.MergeOrder = 1
|
|
Me.MenuItem1.MergeType = System.Windows.Forms.MenuMerge.Replace
|
|
Me.MenuItem1.Text = "&Datei"
|
|
'
|
|
'MenuItem2
|
|
'
|
|
Me.MenuItem2.Index = 0
|
|
Me.MenuItem2.MergeOrder = 1
|
|
Me.MenuItem2.Shortcut = System.Windows.Forms.Shortcut.AltF4
|
|
Me.MenuItem2.Text = "&Schliessen"
|
|
'
|
|
'MenuItem3
|
|
'
|
|
Me.MenuItem3.Index = 1
|
|
Me.MenuItem3.Shortcut = System.Windows.Forms.Shortcut.CtrlF5
|
|
Me.MenuItem3.Text = "&Daten sichern"
|
|
'
|
|
'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
|
|
'
|
|
'ToolBar1
|
|
'
|
|
Me.ToolBar1.Buttons.AddRange(New System.Windows.Forms.ToolBarButton() {Me.ToolBtnExit, Me.ToolBtnSave})
|
|
Me.ToolBar1.DropDownArrows = True
|
|
Me.ToolBar1.ImageList = Me.ImageList1
|
|
Me.ToolBar1.Name = "ToolBar1"
|
|
Me.ToolBar1.ShowToolTips = True
|
|
Me.ToolBar1.Size = New System.Drawing.Size(888, 25)
|
|
Me.ToolBar1.TabIndex = 2
|
|
'
|
|
'ToolBtnExit
|
|
'
|
|
Me.ToolBtnExit.ImageIndex = 2
|
|
'
|
|
'ToolBtnSave
|
|
'
|
|
Me.ToolBtnSave.ImageIndex = 1
|
|
'
|
|
'DataSet1
|
|
'
|
|
Me.DataSet1.DataSetName = "NewDataSet"
|
|
Me.DataSet1.Locale = New System.Globalization.CultureInfo("de-CH")
|
|
'
|
|
'SqlConnection1
|
|
'
|
|
Me.SqlConnection1.ConnectionString = "data source=TGTSQLEDOKABSSF;initial catalog=edoka;integrated security=SSPI;persis" & _
|
|
"t security info=False;user id=tgentwicklung3;workstation id=TG602640;packet size" & _
|
|
"=4096"
|
|
'
|
|
'SqlDataAdapter2
|
|
'
|
|
Me.SqlDataAdapter2.DeleteCommand = Me.SqlDeleteCommand2
|
|
Me.SqlDataAdapter2.InsertCommand = Me.SqlInsertCommand2
|
|
Me.SqlDataAdapter2.SelectCommand = Me.SqlSelectCommand2
|
|
Me.SqlDataAdapter2.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "reportfeldregel", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("reportfeldregelNr", "reportfeldregelNr"), New System.Data.Common.DataColumnMapping("bezeichnung", "bezeichnung"), New System.Data.Common.DataColumnMapping("beschreibung", "beschreibung"), New System.Data.Common.DataColumnMapping("feldtypNr", "feldtypNr"), New System.Data.Common.DataColumnMapping("feldsteuerungNr", "feldsteuerungNr"), New System.Data.Common.DataColumnMapping("datenherkunft", "datenherkunft"), New System.Data.Common.DataColumnMapping("aktiv", "aktiv"), New System.Data.Common.DataColumnMapping("mandantnr", "mandantnr"), New System.Data.Common.DataColumnMapping("mutiert_am", "mutiert_am"), New System.Data.Common.DataColumnMapping("erstellt_am", "erstellt_am"), New System.Data.Common.DataColumnMapping("mutierer", "mutierer")})})
|
|
Me.SqlDataAdapter2.UpdateCommand = Me.SqlUpdateCommand2
|
|
'
|
|
'SqlDeleteCommand2
|
|
'
|
|
Me.SqlDeleteCommand2.CommandText = "[pv_reportfeldregel_delete]"
|
|
Me.SqlDeleteCommand2.CommandType = System.Data.CommandType.StoredProcedure
|
|
Me.SqlDeleteCommand2.Connection = Me.SqlConnection1
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_reportfeldregelNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "reportfeldregelNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_aktiv", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "aktiv", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_beschreibung", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "beschreibung", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_bezeichnung", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bezeichnung", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_datenherkunft", System.Data.SqlDbType.VarChar, 2048, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "datenherkunft", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_erstellt_am", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "erstellt_am", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_feldsteuerungNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "feldsteuerungNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_feldtypNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "feldtypNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mandantnr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mandantnr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mutierer", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mutierer", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mutiert_am", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mutiert_am", System.Data.DataRowVersion.Original, Nothing))
|
|
'
|
|
'SqlInsertCommand2
|
|
'
|
|
Me.SqlInsertCommand2.CommandText = "[pv_reportfeldregel_insert]"
|
|
Me.SqlInsertCommand2.CommandType = System.Data.CommandType.StoredProcedure
|
|
Me.SqlInsertCommand2.Connection = Me.SqlConnection1
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@reportfeldregelNr", System.Data.SqlDbType.Int, 4, "reportfeldregelNr"))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@bezeichnung", System.Data.SqlDbType.VarChar, 50, "bezeichnung"))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@beschreibung", System.Data.SqlDbType.VarChar, 50, "beschreibung"))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@feldtypNr", System.Data.SqlDbType.Int, 4, "feldtypNr"))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@feldsteuerungNr", System.Data.SqlDbType.Int, 4, "feldsteuerungNr"))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@datenherkunft", System.Data.SqlDbType.VarChar, 2048, "datenherkunft"))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@aktiv", System.Data.SqlDbType.Bit, 1, "aktiv"))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mandantnr", System.Data.SqlDbType.Int, 4, "mandantnr"))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mutiert_am", System.Data.SqlDbType.DateTime, 8, "mutiert_am"))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@erstellt_am", System.Data.SqlDbType.DateTime, 8, "erstellt_am"))
|
|
Me.SqlInsertCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mutierer", System.Data.SqlDbType.Int, 4, "mutierer"))
|
|
'
|
|
'SqlSelectCommand2
|
|
'
|
|
Me.SqlSelectCommand2.CommandText = "[pv_reportfeldregel_select]"
|
|
Me.SqlSelectCommand2.CommandType = System.Data.CommandType.StoredProcedure
|
|
Me.SqlSelectCommand2.Connection = Me.SqlConnection1
|
|
Me.SqlSelectCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
|
|
Me.SqlSelectCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mandantnr", System.Data.SqlDbType.Int, 4, "mandantnr"))
|
|
'
|
|
'SqlUpdateCommand2
|
|
'
|
|
Me.SqlUpdateCommand2.CommandText = "[pv_reportfeldregel_update]"
|
|
Me.SqlUpdateCommand2.CommandType = System.Data.CommandType.StoredProcedure
|
|
Me.SqlUpdateCommand2.Connection = Me.SqlConnection1
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@reportfeldregelNr", System.Data.SqlDbType.Int, 4, "reportfeldregelNr"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@bezeichnung", System.Data.SqlDbType.VarChar, 50, "bezeichnung"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@beschreibung", System.Data.SqlDbType.VarChar, 50, "beschreibung"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@feldtypNr", System.Data.SqlDbType.Int, 4, "feldtypNr"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@feldsteuerungNr", System.Data.SqlDbType.Int, 4, "feldsteuerungNr"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@datenherkunft", System.Data.SqlDbType.VarChar, 2048, "datenherkunft"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@aktiv", System.Data.SqlDbType.Bit, 1, "aktiv"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.Int, 4, "mandantnr"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mutiert_am", System.Data.SqlDbType.DateTime, 8, "mutiert_am"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@erstellt_am", System.Data.SqlDbType.DateTime, 8, "erstellt_am"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mutierer", System.Data.SqlDbType.Int, 4, "mutierer"))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_reportfeldregelNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "reportfeldregelNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_aktiv", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "aktiv", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_beschreibung", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "beschreibung", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_bezeichnung", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bezeichnung", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_datenherkunft", System.Data.SqlDbType.VarChar, 2048, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "datenherkunft", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_erstellt_am", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "erstellt_am", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_feldsteuerungNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "feldsteuerungNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_feldtypNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "feldtypNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mandantnr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mandantnr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mutierer", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mutierer", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand2.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mutiert_am", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mutiert_am", System.Data.DataRowVersion.Original, Nothing))
|
|
'
|
|
'SqlDataAdapter1
|
|
'
|
|
Me.SqlDataAdapter1.DeleteCommand = Me.SqlDeleteCommand1
|
|
Me.SqlDataAdapter1.InsertCommand = Me.SqlInsertCommand1
|
|
Me.SqlDataAdapter1.SelectCommand = Me.SqlSelectCommand1
|
|
Me.SqlDataAdapter1.TableMappings.AddRange(New System.Data.Common.DataTableMapping() {New System.Data.Common.DataTableMapping("Table", "reportfeldregel", New System.Data.Common.DataColumnMapping() {New System.Data.Common.DataColumnMapping("reportfeldregelNr", "reportfeldregelNr"), New System.Data.Common.DataColumnMapping("Parametername", "Parametername"), New System.Data.Common.DataColumnMapping("bezeichnung", "bezeichnung"), New System.Data.Common.DataColumnMapping("beschreibung", "beschreibung"), New System.Data.Common.DataColumnMapping("feldtypNr", "feldtypNr"), New System.Data.Common.DataColumnMapping("feldsteuerungNr", "feldsteuerungNr"), New System.Data.Common.DataColumnMapping("datenherkunft", "datenherkunft"), New System.Data.Common.DataColumnMapping("aktiv", "aktiv"), New System.Data.Common.DataColumnMapping("mandantnr", "mandantnr"), New System.Data.Common.DataColumnMapping("mutiert_am", "mutiert_am"), New System.Data.Common.DataColumnMapping("erstellt_am", "erstellt_am"), New System.Data.Common.DataColumnMapping("mutierer", "mutierer"), New System.Data.Common.DataColumnMapping("eingabe_zwingend", "eingabe_zwingend")})})
|
|
Me.SqlDataAdapter1.UpdateCommand = Me.SqlUpdateCommand1
|
|
'
|
|
'SqlDeleteCommand1
|
|
'
|
|
Me.SqlDeleteCommand1.CommandText = "[pv_reportfeldregel_delete]"
|
|
Me.SqlDeleteCommand1.CommandType = System.Data.CommandType.StoredProcedure
|
|
Me.SqlDeleteCommand1.Connection = Me.SqlConnection2
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_reportfeldregelNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "reportfeldregelNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Parametername", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Parametername", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_aktiv", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "aktiv", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_beschreibung", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "beschreibung", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_bezeichnung", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bezeichnung", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_datenherkunft", System.Data.SqlDbType.VarChar, 2048, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "datenherkunft", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_eingabe_zwingend", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "eingabe_zwingend", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_erstellt_am", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "erstellt_am", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_feldsteuerungNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "feldsteuerungNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_feldtypNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "feldtypNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mandantnr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mandantnr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mutierer", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mutierer", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlDeleteCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mutiert_am", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mutiert_am", System.Data.DataRowVersion.Original, Nothing))
|
|
'
|
|
'SqlConnection2
|
|
'
|
|
Me.SqlConnection2.ConnectionString = "data source=tgtsqledokabssf;initial catalog=edoka;integrated security=SSPI;persis" & _
|
|
"t security info=False;workstation id=TG602643;packet size=4096"
|
|
'
|
|
'SqlInsertCommand1
|
|
'
|
|
Me.SqlInsertCommand1.CommandText = "[pv_reportfeldregel_insert]"
|
|
Me.SqlInsertCommand1.CommandType = System.Data.CommandType.StoredProcedure
|
|
Me.SqlInsertCommand1.Connection = Me.SqlConnection2
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@reportfeldregelNr", System.Data.SqlDbType.Int, 4, "reportfeldregelNr"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Parametername", System.Data.SqlDbType.VarChar, 50, "Parametername"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@bezeichnung", System.Data.SqlDbType.VarChar, 50, "bezeichnung"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@beschreibung", System.Data.SqlDbType.VarChar, 50, "beschreibung"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@feldtypNr", System.Data.SqlDbType.Int, 4, "feldtypNr"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@feldsteuerungNr", System.Data.SqlDbType.Int, 4, "feldsteuerungNr"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@datenherkunft", System.Data.SqlDbType.VarChar, 2048, "datenherkunft"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@aktiv", System.Data.SqlDbType.Bit, 1, "aktiv"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mandantnr", System.Data.SqlDbType.Int, 4, "mandantnr"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mutiert_am", System.Data.SqlDbType.DateTime, 8, "mutiert_am"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@erstellt_am", System.Data.SqlDbType.DateTime, 8, "erstellt_am"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mutierer", System.Data.SqlDbType.Int, 4, "mutierer"))
|
|
Me.SqlInsertCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@eingabe_zwingend", System.Data.SqlDbType.Bit, 1, "eingabe_zwingend"))
|
|
'
|
|
'SqlSelectCommand1
|
|
'
|
|
Me.SqlSelectCommand1.CommandText = "[pv_reportfeldregel_select]"
|
|
Me.SqlSelectCommand1.CommandType = System.Data.CommandType.StoredProcedure
|
|
Me.SqlSelectCommand1.Connection = Me.SqlConnection2
|
|
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
|
|
Me.SqlSelectCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mandantnr", System.Data.SqlDbType.Int, 4, "mandantnr"))
|
|
'
|
|
'SqlUpdateCommand1
|
|
'
|
|
Me.SqlUpdateCommand1.CommandText = "[pv_reportfeldregel_update]"
|
|
Me.SqlUpdateCommand1.CommandType = System.Data.CommandType.StoredProcedure
|
|
Me.SqlUpdateCommand1.Connection = Me.SqlConnection2
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, False, CType(0, Byte), CType(0, Byte), "", System.Data.DataRowVersion.Current, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@reportfeldregelNr", System.Data.SqlDbType.Int, 4, "reportfeldregelNr"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Parametername", System.Data.SqlDbType.VarChar, 50, "Parametername"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@bezeichnung", System.Data.SqlDbType.VarChar, 50, "bezeichnung"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@beschreibung", System.Data.SqlDbType.VarChar, 50, "beschreibung"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@feldtypNr", System.Data.SqlDbType.Int, 4, "feldtypNr"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@feldsteuerungNr", System.Data.SqlDbType.Int, 4, "feldsteuerungNr"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@datenherkunft", System.Data.SqlDbType.VarChar, 2048, "datenherkunft"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@aktiv", System.Data.SqlDbType.Bit, 1, "aktiv"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Param1", System.Data.SqlDbType.Int, 4, "mandantnr"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mutiert_am", System.Data.SqlDbType.DateTime, 8, "mutiert_am"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@erstellt_am", System.Data.SqlDbType.DateTime, 8, "erstellt_am"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@mutierer", System.Data.SqlDbType.Int, 4, "mutierer"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@eingabe_zwingend", System.Data.SqlDbType.Bit, 1, "eingabe_zwingend"))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_reportfeldregelNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "reportfeldregelNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_Parametername", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Parametername", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_aktiv", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "aktiv", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_beschreibung", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "beschreibung", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_bezeichnung", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "bezeichnung", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_datenherkunft", System.Data.SqlDbType.VarChar, 2048, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "datenherkunft", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_eingabe_zwingend", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "eingabe_zwingend", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_erstellt_am", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "erstellt_am", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_feldsteuerungNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "feldsteuerungNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_feldtypNr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "feldtypNr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mandantnr", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mandantnr", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mutierer", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mutierer", System.Data.DataRowVersion.Original, Nothing))
|
|
Me.SqlUpdateCommand1.Parameters.Add(New System.Data.SqlClient.SqlParameter("@Original_mutiert_am", System.Data.SqlDbType.DateTime, 8, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "mutiert_am", System.Data.DataRowVersion.Original, Nothing))
|
|
'
|
|
'Panel1
|
|
'
|
|
Me.Panel1.Controls.AddRange(New System.Windows.Forms.Control() {Me.Panel2, Me.Panel3})
|
|
Me.Panel1.Dock = System.Windows.Forms.DockStyle.Bottom
|
|
Me.Panel1.Location = New System.Drawing.Point(0, 433)
|
|
Me.Panel1.Name = "Panel1"
|
|
Me.Panel1.Size = New System.Drawing.Size(888, 160)
|
|
Me.Panel1.TabIndex = 18
|
|
'
|
|
'Panel2
|
|
'
|
|
Me.Panel2.Controls.AddRange(New System.Windows.Forms.Control() {Me.txtBezeichnung, Me.txtBeschreibung, Me.cboSteuerbefehl, Me.cbofeldTyp, Me.txtDatenherkunft})
|
|
Me.Panel2.Dock = System.Windows.Forms.DockStyle.Fill
|
|
Me.Panel2.Location = New System.Drawing.Point(96, 0)
|
|
Me.Panel2.Name = "Panel2"
|
|
Me.Panel2.Size = New System.Drawing.Size(792, 160)
|
|
Me.Panel2.TabIndex = 25
|
|
'
|
|
'txtBezeichnung
|
|
'
|
|
Me.txtBezeichnung.Location = New System.Drawing.Point(0, 6)
|
|
Me.txtBezeichnung.Name = "txtBezeichnung"
|
|
Me.txtBezeichnung.Size = New System.Drawing.Size(648, 20)
|
|
Me.txtBezeichnung.TabIndex = 28
|
|
Me.txtBezeichnung.Text = "Bezeichnung"
|
|
'
|
|
'txtBeschreibung
|
|
'
|
|
Me.txtBeschreibung.Location = New System.Drawing.Point(0, 26)
|
|
Me.txtBeschreibung.Name = "txtBeschreibung"
|
|
Me.txtBeschreibung.Size = New System.Drawing.Size(648, 20)
|
|
Me.txtBeschreibung.TabIndex = 27
|
|
Me.txtBeschreibung.Text = "Beschreibung"
|
|
'
|
|
'cboSteuerbefehl
|
|
'
|
|
Me.cboSteuerbefehl.Location = New System.Drawing.Point(0, 46)
|
|
Me.cboSteuerbefehl.Name = "cboSteuerbefehl"
|
|
Me.cboSteuerbefehl.Size = New System.Drawing.Size(648, 21)
|
|
Me.cboSteuerbefehl.TabIndex = 26
|
|
Me.cboSteuerbefehl.Text = "Steuerbefehl"
|
|
'
|
|
'cbofeldTyp
|
|
'
|
|
Me.cbofeldTyp.Location = New System.Drawing.Point(0, 67)
|
|
Me.cbofeldTyp.Name = "cbofeldTyp"
|
|
Me.cbofeldTyp.Size = New System.Drawing.Size(648, 21)
|
|
Me.cbofeldTyp.TabIndex = 25
|
|
Me.cbofeldTyp.Text = "Feldtype"
|
|
'
|
|
'txtDatenherkunft
|
|
'
|
|
Me.txtDatenherkunft.Location = New System.Drawing.Point(0, 88)
|
|
Me.txtDatenherkunft.Multiline = True
|
|
Me.txtDatenherkunft.Name = "txtDatenherkunft"
|
|
Me.txtDatenherkunft.ScrollBars = System.Windows.Forms.ScrollBars.Both
|
|
Me.txtDatenherkunft.Size = New System.Drawing.Size(648, 72)
|
|
Me.txtDatenherkunft.TabIndex = 24
|
|
Me.txtDatenherkunft.Text = "Datenherkunft"
|
|
'
|
|
'Panel3
|
|
'
|
|
Me.Panel3.Controls.AddRange(New System.Windows.Forms.Control() {Me.lblTyp, Me.lblSteuerbefehl, Me.lblBeschreibung, Me.lblDatenherkunft, Me.lblBezeichnung})
|
|
Me.Panel3.Dock = System.Windows.Forms.DockStyle.Left
|
|
Me.Panel3.Name = "Panel3"
|
|
Me.Panel3.Size = New System.Drawing.Size(96, 160)
|
|
Me.Panel3.TabIndex = 24
|
|
'
|
|
'lblTyp
|
|
'
|
|
Me.lblTyp.Location = New System.Drawing.Point(6, 69)
|
|
Me.lblTyp.Name = "lblTyp"
|
|
Me.lblTyp.Size = New System.Drawing.Size(88, 16)
|
|
Me.lblTyp.TabIndex = 27
|
|
Me.lblTyp.Text = "Feld-Typ"
|
|
Me.lblTyp.TextAlign = System.Drawing.ContentAlignment.MiddleRight
|
|
'
|
|
'lblSteuerbefehl
|
|
'
|
|
Me.lblSteuerbefehl.Location = New System.Drawing.Point(6, 48)
|
|
Me.lblSteuerbefehl.Name = "lblSteuerbefehl"
|
|
Me.lblSteuerbefehl.Size = New System.Drawing.Size(88, 16)
|
|
Me.lblSteuerbefehl.TabIndex = 26
|
|
Me.lblSteuerbefehl.Text = "Steuerbefehl"
|
|
Me.lblSteuerbefehl.TextAlign = System.Drawing.ContentAlignment.MiddleRight
|
|
'
|
|
'lblBeschreibung
|
|
'
|
|
Me.lblBeschreibung.Location = New System.Drawing.Point(6, 28)
|
|
Me.lblBeschreibung.Name = "lblBeschreibung"
|
|
Me.lblBeschreibung.Size = New System.Drawing.Size(88, 16)
|
|
Me.lblBeschreibung.TabIndex = 25
|
|
Me.lblBeschreibung.Text = "Beschreibung"
|
|
Me.lblBeschreibung.TextAlign = System.Drawing.ContentAlignment.MiddleRight
|
|
'
|
|
'lblDatenherkunft
|
|
'
|
|
Me.lblDatenherkunft.Location = New System.Drawing.Point(4, 89)
|
|
Me.lblDatenherkunft.Name = "lblDatenherkunft"
|
|
Me.lblDatenherkunft.Size = New System.Drawing.Size(88, 16)
|
|
Me.lblDatenherkunft.TabIndex = 24
|
|
Me.lblDatenherkunft.Text = "Datenherkunft"
|
|
Me.lblDatenherkunft.TextAlign = System.Drawing.ContentAlignment.MiddleRight
|
|
'
|
|
'lblBezeichnung
|
|
'
|
|
Me.lblBezeichnung.Location = New System.Drawing.Point(6, 8)
|
|
Me.lblBezeichnung.Name = "lblBezeichnung"
|
|
Me.lblBezeichnung.Size = New System.Drawing.Size(88, 16)
|
|
Me.lblBezeichnung.TabIndex = 23
|
|
Me.lblBezeichnung.Text = "Bezeichnung"
|
|
Me.lblBezeichnung.TextAlign = System.Drawing.ContentAlignment.MiddleRight
|
|
'
|
|
'DomainList
|
|
'
|
|
Me.DomainList.AllowAddNew = True
|
|
Me.DomainList.AllowFilter = True
|
|
Me.DomainList.AllowRowSizing = C1.Win.C1TrueDBGrid.RowSizingEnum.AllRows
|
|
Me.DomainList.AllowSort = True
|
|
Me.DomainList.AlternatingRows = True
|
|
Me.DomainList.CaptionHeight = 17
|
|
Me.DomainList.CellTips = C1.Win.C1TrueDBGrid.CellTipEnum.Anchored
|
|
Me.DomainList.CollapseColor = System.Drawing.Color.Black
|
|
Me.DomainList.DataChanged = False
|
|
Me.DomainList.DeadAreaBackColor = System.Drawing.Color.Gray
|
|
Me.DomainList.Dock = System.Windows.Forms.DockStyle.Fill
|
|
Me.DomainList.ExpandColor = System.Drawing.Color.Black
|
|
Me.DomainList.FilterBar = True
|
|
Me.DomainList.GroupByCaption = "Drag a column header here to group by that column"
|
|
Me.DomainList.Images.Add(CType(resources.GetObject("resource.Images"), System.Drawing.Bitmap))
|
|
Me.DomainList.Location = New System.Drawing.Point(0, 25)
|
|
Me.DomainList.MarqueeStyle = C1.Win.C1TrueDBGrid.MarqueeEnum.SolidCellBorder
|
|
Me.DomainList.Name = "DomainList"
|
|
Me.DomainList.PreviewInfo.Location = New System.Drawing.Point(0, 0)
|
|
Me.DomainList.PreviewInfo.Size = New System.Drawing.Size(0, 0)
|
|
Me.DomainList.PreviewInfo.ZoomFactor = 75
|
|
Me.DomainList.PrintInfo.ShowOptionsDialog = False
|
|
Me.DomainList.RecordSelectorWidth = 16
|
|
GridLines1.Color = System.Drawing.Color.DarkGray
|
|
GridLines1.Style = C1.Win.C1TrueDBGrid.LineStyleEnum.Single
|
|
Me.DomainList.RowDivider = GridLines1
|
|
Me.DomainList.RowHeight = 15
|
|
Me.DomainList.RowSubDividerColor = System.Drawing.Color.DarkGray
|
|
Me.DomainList.ScrollTips = True
|
|
Me.DomainList.Size = New System.Drawing.Size(888, 408)
|
|
Me.DomainList.TabAction = C1.Win.C1TrueDBGrid.TabActionEnum.ColumnNavigation
|
|
Me.DomainList.TabIndex = 19
|
|
Me.DomainList.Text = "C1TrueDBGrid1"
|
|
Me.DomainList.WrapCellPointer = True
|
|
Me.DomainList.PropBag = "<?xml version=""1.0""?><Blob><Styles type=""C1.Win.C1TrueDBGrid.Design.ContextWrappe" & _
|
|
"r""><Data>Group{AlignVert:Center;Border:None,,0, 0, 0, 0;BackColor:ControlDark;}E" & _
|
|
"ditor{}Style2{}Style5{}Style4{}Style7{}Style6{}EvenRow{BackColor:White;}Selected" & _
|
|
"{ForeColor:HighlightText;BackColor:Highlight;}Style3{}Inactive{ForeColor:Inactiv" & _
|
|
"eCaptionText;BackColor:InactiveCaption;}FilterBar{BackColor:255, 255, 128;}Foote" & _
|
|
"r{}Caption{AlignHorz:Center;}Normal{}HighlightRow{ForeColor:HighlightText;BackCo" & _
|
|
"lor:Highlight;}Style1{}OddRow{BackColor:224, 224, 224;}RecordSelector{AlignImage" & _
|
|
":Center;}Heading{Wrap:True;BackColor:Control;Border:Raised,,1, 1, 1, 1;ForeColor" & _
|
|
":ControlText;AlignVert:Center;}Style8{}Style10{AlignHorz:Near;}Style11{}Style12{" & _
|
|
"}Style13{}Style9{}</Data></Styles><Splits><C1.Win.C1TrueDBGrid.MergeView Name=""""" & _
|
|
" AlternatingRowStyle=""True"" CaptionHeight=""17"" ColumnCaptionHeight=""17"" ColumnFo" & _
|
|
"oterHeight=""17"" FilterBar=""True"" MarqueeStyle=""SolidCellBorder"" RecordSelectorWi" & _
|
|
"dth=""16"" DefRecSelWidth=""16"" VerticalScrollGroup=""1"" HorizontalScrollGroup=""1""><" & _
|
|
"ClientRect>0, 0, 884, 404</ClientRect><BorderSide>0</BorderSide><CaptionStyle pa" & _
|
|
"rent=""Style2"" me=""Style10"" /><EditorStyle parent=""Editor"" me=""Style5"" /><EvenRow" & _
|
|
"Style parent=""EvenRow"" me=""Style8"" /><FilterBarStyle parent=""FilterBar"" me=""Styl" & _
|
|
"e13"" /><FooterStyle parent=""Footer"" me=""Style3"" /><GroupStyle parent=""Group"" me=" & _
|
|
"""Style12"" /><HeadingStyle parent=""Heading"" me=""Style2"" /><HighLightRowStyle pare" & _
|
|
"nt=""HighlightRow"" me=""Style7"" /><InactiveStyle parent=""Inactive"" me=""Style4"" /><" & _
|
|
"OddRowStyle parent=""OddRow"" me=""Style9"" /><RecordSelectorStyle parent=""RecordSel" & _
|
|
"ector"" me=""Style11"" /><SelectedStyle parent=""Selected"" me=""Style6"" /><Style pare" & _
|
|
"nt=""Normal"" me=""Style1"" /></C1.Win.C1TrueDBGrid.MergeView></Splits><NamedStyles>" & _
|
|
"<Style parent="""" me=""Normal"" /><Style parent=""Normal"" me=""Heading"" /><Style pare" & _
|
|
"nt=""Heading"" me=""Footer"" /><Style parent=""Heading"" me=""Caption"" /><Style parent=" & _
|
|
"""Heading"" 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=""Headi" & _
|
|
"ng"" me=""RecordSelector"" /><Style parent=""Normal"" me=""FilterBar"" /><Style parent=" & _
|
|
"""Caption"" me=""Group"" /></NamedStyles><vertSplits>1</vertSplits><horzSplits>1</ho" & _
|
|
"rzSplits><Layout>Modified</Layout><DefaultRecSelWidth>16</DefaultRecSelWidth><Cl" & _
|
|
"ientArea>0, 0, 884, 404</ClientArea></Blob>"
|
|
'
|
|
'frmDomainReportfeldregel
|
|
'
|
|
Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13)
|
|
Me.ClientSize = New System.Drawing.Size(888, 593)
|
|
Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.DomainList, Me.Panel1, Me.ToolBar1})
|
|
Me.Icon = CType(resources.GetObject("$this.Icon"), System.Drawing.Icon)
|
|
Me.Menu = Me.MainMenu1
|
|
Me.Name = "frmDomainReportfeldregel"
|
|
Me.ShowInTaskbar = False
|
|
Me.Text = "frmDomainEdidor"
|
|
CType(Me.DataSet1, System.ComponentModel.ISupportInitialize).EndInit()
|
|
Me.Panel1.ResumeLayout(False)
|
|
Me.Panel2.ResumeLayout(False)
|
|
Me.Panel3.ResumeLayout(False)
|
|
CType(Me.DomainList, System.ComponentModel.ISupportInitialize).EndInit()
|
|
Me.ResumeLayout(False)
|
|
|
|
End Sub
|
|
|
|
#End Region
|
|
|
|
|
|
#Region " Deklarationen "
|
|
Dim WithEvents mcboFeldTyp As New MultiComboBox()
|
|
Dim WithEvents mcboSteuerbefehl As New MultiComboBox()
|
|
|
|
Dim m_TableName As String
|
|
Dim m_Eintragnr As Long
|
|
Dim m_Inaktive As Boolean
|
|
Dim m_Eintrag As String
|
|
Dim selectedrow As Integer
|
|
Dim m_TransferKey As Long
|
|
Dim m_ToSelect As Boolean
|
|
Public Enum EnumCombotyp 'bestimmt welche Combobox angesprochen wird
|
|
Feldtyp = 1
|
|
Steuerbefehl = 2
|
|
End Enum
|
|
|
|
#End Region
|
|
|
|
#Region "Properties"
|
|
Property Eintragnr() As Long
|
|
Get
|
|
Return m_Eintragnr
|
|
End Get
|
|
Set(ByVal Value As Long)
|
|
m_Eintragnr = Value
|
|
End Set
|
|
End Property
|
|
Property TableName() As String
|
|
Get
|
|
Return m_TableName
|
|
End Get
|
|
Set(ByVal Value As String)
|
|
m_TableName = Value
|
|
End Set
|
|
End Property
|
|
|
|
Property Inaktive() As Boolean
|
|
Get
|
|
Return m_Inaktive
|
|
End Get
|
|
Set(ByVal Value As Boolean)
|
|
m_Inaktive = Value
|
|
End Set
|
|
End Property
|
|
|
|
Property Eintrag() As String
|
|
Get
|
|
Return m_Eintrag
|
|
End Get
|
|
Set(ByVal Value As String)
|
|
m_Eintrag = Value
|
|
End Set
|
|
End Property
|
|
Property TransferKey() As Long
|
|
Get
|
|
Return m_TransferKey
|
|
End Get
|
|
Set(ByVal Value As Long)
|
|
m_TransferKey = Value
|
|
End Set
|
|
End Property
|
|
Property ToSelect() As Boolean
|
|
Get
|
|
Return m_ToSelect
|
|
End Get
|
|
Set(ByVal Value As Boolean)
|
|
m_ToSelect = Value
|
|
End Set
|
|
End Property
|
|
#End Region
|
|
|
|
#Region "Diverse Funktionen"
|
|
|
|
Public Sub SpaltenTitel_Aktualisieren(ByVal tblnr As Integer, ByVal tblname As String, ByVal ds As DataSet)
|
|
'Spaltentitel setzen
|
|
Dim titel As New EDOKA.MySpaltenTitel()
|
|
Dim ts As New EDOKA.Tabellenspalte()
|
|
Dim i As Integer
|
|
Dim t As New DataTable()
|
|
t = ds.Tables(0)
|
|
If tblnr = 1 Then
|
|
ts.Tabelle = tblname
|
|
For i = 0 To Me.DomainList.Columns.Count - 1
|
|
Dim s As String
|
|
s = Me.DomainList.Columns(i).DataField
|
|
ts.Feld = s
|
|
ts.getspalte()
|
|
If ts.spaltenname <> "" Then
|
|
Me.DomainList.Columns(i).Caption = ts.spaltenname
|
|
If Me.DomainList.Columns(i).Caption = "" Then
|
|
Me.DomainList.Splits(0).DisplayColumns(i).Width = 0
|
|
Else
|
|
Me.DomainList.Splits(0).DisplayColumns(i).Width = ts.ColWith
|
|
End If
|
|
If ts.locked Then
|
|
Me.DomainList.Splits(0).DisplayColumns(i).Locked = True
|
|
End If
|
|
If ts.AlsHacken Then
|
|
Me.DomainList.Columns(i).ValueItems.Presentation = C1.Win.C1TrueDBGrid.PresentationEnum.CheckBox
|
|
End If
|
|
'Präsentation von aktiv
|
|
If Me.DomainList.Columns(i).DataField = "aktiv" Then
|
|
Me.DomainList.Columns(i).ValueItems.Presentation = C1.Win.C1TrueDBGrid.PresentationEnum.CheckBox
|
|
Me.DomainList.Columns(i).ValueItems.DefaultItem = True
|
|
Me.DomainList.Columns(i).DefaultValue = True
|
|
Me.DomainList.Columns(i).FilterText = True
|
|
End If
|
|
If Me.DomainList.Columns(i).DataField = "erstellt_am" Then
|
|
Me.DomainList.Columns(i).DefaultValue = Now
|
|
End If
|
|
Else
|
|
Me.DomainList.Splits(0).DisplayColumns(i).Width = 0
|
|
End If
|
|
Next
|
|
End If
|
|
End Sub
|
|
|
|
Public Sub FormSize(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
|
|
Me.SuspendLayout()
|
|
Dim ds As New edokadb.clsSysadminfunktion()
|
|
Try
|
|
ds.cpMainConnectionProvider = conn
|
|
ds.iSysadminfnktnr = New SqlInt32(CType(m_Eintragnr, Int32))
|
|
ds.SelectOne()
|
|
If ds.iFleft.Value <> 0 Then Me.Left = ds.iFleft.Value
|
|
If ds.iFtop.Value <> 0 Then Me.Top = ds.iFtop.Value
|
|
If ds.iFwidth.Value <> 0 Then Me.Width = ds.iFwidth.Value
|
|
If ds.iFheight.Value <> 0 Then Me.Height = ds.iFheight.Value
|
|
Me.MenuItem1.Text = Me.Eintrag
|
|
Catch
|
|
'MsgBox("Error Resizing Form")
|
|
Finally
|
|
End Try
|
|
ds.Dispose()
|
|
Me.ResumeLayout()
|
|
End Sub
|
|
|
|
Private Sub DomainList_AfterInsert(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles DomainList.AfterInsert
|
|
Dim i As Integer
|
|
'Defaulwerte erstellt_am, mutiert_am, mutierer und aktiv setzen
|
|
Try
|
|
Me.DomainList.Columns("aktiv").Value = 1
|
|
Me.DomainList.Columns("erstellt_am").Value = Now
|
|
Me.DomainList.Columns("mutiert_am").Value = Now
|
|
Me.DomainList.Columns("mutierer").Value = Globals.MitarbeiterNr
|
|
'For i = 0 To DomainList.Columns.Count - 1
|
|
' If Me.DomainList.Columns(i).DataField = "aktiv" Then
|
|
' Me.DomainList.Columns(i).Value = 1
|
|
' End If
|
|
' If Me.DomainList.Columns(i).DataField = "erstellt_am" Then
|
|
' Me.DomainList.Columns(i).Value = Now
|
|
' End If
|
|
' If Me.DomainList.Columns(i).DataField = "mutiert_am" Then
|
|
' Me.DomainList.Columns(i).Value = Now
|
|
' End If
|
|
' If Me.DomainList.Columns(i).DataField = "mutierer" Then
|
|
' Me.DomainList.Columns(i).Value = Globals.MitarbeiterNr
|
|
' End If
|
|
'Next
|
|
Catch
|
|
End Try
|
|
|
|
End Sub
|
|
|
|
Private Sub domainlist_aftercellupdate(ByVal sender As System.Object, ByVal e As C1.Win.C1TrueDBGrid.ColEventArgs) Handles DomainList.AfterColEdit
|
|
'Aktualisieren von Mutierer und Mutiert_am
|
|
Dim i As Integer
|
|
Try
|
|
'For i = 0 To Me.DomainList.Columns.Count - 1
|
|
'If Me.DomainList.Columns(i).DataField = "mutiert_am" Then Me.DomainList.Columns(i).Value = Now
|
|
Me.DomainList.Columns("mutiert_am").Text = Now
|
|
'If Me.DomainList.Columns(i).DataField = "mutiert_am" Then Me.DomainList.Columns(i).Value = Now
|
|
Me.DomainList.Columns("mutierer").Value = Globals.MitarbeiterNr
|
|
'Next
|
|
|
|
'neuer DB-Key auslösen, sofern kein Key vorhanden ist
|
|
If Me.DomainList.Columns(0).Value Is DBNull.Value Then
|
|
Dim dbkey As New edokadb.clsMyKey_Tabelle()
|
|
Dim key As Long
|
|
dbkey.cpMainConnectionProvider = conn
|
|
key = dbkey.get_dbkey(TableName)
|
|
Me.DomainList.Columns(0).Value = key
|
|
|
|
Me.DomainList.Columns("mandantnr").Value = Globals.MandantNr
|
|
'For i = 0 To Me.DomainList.Columns.Count - 1
|
|
' If Me.DomainList.Columns(i).DataField = "mandantnr" Then
|
|
' Me.DomainList.Columns(i).Value = Globals.MandantNr
|
|
' End If
|
|
'Next
|
|
dbkey.Dispose()
|
|
End If
|
|
Catch ex As Exception
|
|
'MsgBox(ex.Message)
|
|
End Try
|
|
End Sub
|
|
|
|
|
|
#End Region
|
|
|
|
#Region "Formhandling"
|
|
|
|
Private Sub frmDomainReportfeldregel_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
|
|
Me.Text = Me.Eintrag
|
|
Dim i As Integer
|
|
|
|
Me.TableName = "reportfeldregel"
|
|
Me.SqlConnection1.ConnectionString = Globals.sConnectionString
|
|
Me.SqlConnection1.Open()
|
|
|
|
Me.SqlDataAdapter1.SelectCommand.Connection = Me.SqlConnection1
|
|
|
|
' Nur für den aktuell gewählten Mandanten die Daten auslesen
|
|
Me.SqlDataAdapter1.SelectCommand.Parameters.Clear()
|
|
Me.SqlDataAdapter1.SelectCommand.Parameters.AddWithValue("@mandantnr", Globals.MandantNr)
|
|
|
|
Me.SqlDataAdapter1.Fill(Me.DataSet1)
|
|
Me.DomainList.DataSource = Me.DataSet1
|
|
Me.DomainList.DataMember = Me.TableName
|
|
'SpaltenTitel_Aktualisieren(Me.DataSet1)
|
|
|
|
SpaltenTitel_Aktualisieren(Me.DataSet1, DomainList)
|
|
|
|
'===============================================================================
|
|
'Datasource Steuerbefehl
|
|
'===============================================================================
|
|
Me.mcboSteuerbefehl = New MultiComboBox(Me.cboSteuerbefehl)
|
|
|
|
|
|
Me.mcboSteuerbefehl.DisplayColumnName = "steuerung"
|
|
Me.mcboSteuerbefehl.ValueColumnName = "feldsteuerungNr"
|
|
|
|
Me.mcboSteuerbefehl.Fill_Data(Generic_Select(EnumCombotyp.Steuerbefehl), False)
|
|
Me.mcboSteuerbefehl.SelectedValue = Me.DomainList.Columns(4).Value
|
|
'===============================================================================
|
|
'Datasource Feldtyp
|
|
'===============================================================================
|
|
Me.mcboFeldTyp = New MultiComboBox(Me.cbofeldTyp)
|
|
|
|
Me.mcboFeldTyp.DisplayColumnName = "feldtyp"
|
|
Me.mcboFeldTyp.ValueColumnName = "feldtypNr"
|
|
|
|
Me.mcboFeldTyp.Fill_Data(Generic_Select(EnumCombotyp.Feldtyp), False)
|
|
Me.mcboFeldTyp.SelectedValue = Me.DomainList.Columns(3).Value
|
|
|
|
'===============================================================================
|
|
'Datasource textfelder
|
|
'===============================================================================
|
|
Me.txtBezeichnung.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.DataSet1, "Reportfeldregel.Bezeichnung"))
|
|
Me.txtBeschreibung.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.DataSet1, "Reportfeldregel.Beschreibung"))
|
|
Me.txtDatenherkunft.DataBindings.Add(New System.Windows.Forms.Binding("Text", Me.DataSet1, "Reportfeldregel.Datenherkunft"))
|
|
' Exit Sub
|
|
|
|
'Me.chkZwingend.DataBindings.Add(New System.Windows.Forms.Binding("Checked", Me.DataSet1, "Reportfeldregel.eingabe_zwingend"))
|
|
Me.WindowState = FormWindowState.Maximized
|
|
End Sub
|
|
Public Sub SpaltenTitel_Aktualisieren(ByVal ds As DataSet, ByRef grd As C1.Win.C1TrueDBGrid.C1TrueDBGrid)
|
|
|
|
'Spaltentitel setzen
|
|
Dim titel As New EDOKA.MySpaltenTitel()
|
|
Dim cols(grd.Splits(0).DisplayColumns.Count) As C1.Win.C1TrueDBGrid.C1DisplayColumn
|
|
Dim ts As New EDOKA.Tabellenspalte()
|
|
Dim i As Integer
|
|
Dim t As New DataTable()
|
|
Dim dc As C1.Win.C1TrueDBGrid.C1DisplayColumn
|
|
Dim s As String
|
|
|
|
Dim DisplayColumnsCount As Integer
|
|
Dim aSpalten(0, 0) As C1.Win.C1TrueDBGrid.C1DisplayColumn
|
|
Dim Reihe As C1.Win.C1TrueDBGrid.C1DisplayColumn
|
|
Dim iMaxSortOrderValue As Integer = 0
|
|
Dim dsMaxSortOrder As New DataSet()
|
|
Dim bSetNewSortOrder As Boolean = True
|
|
Dim iSpaltenOffset As Integer = 0 'Offset wenn Nothing in Array
|
|
|
|
'============ Bestimmt Anzahl Displaycolumn und MaxValue Sortorder
|
|
'Dim ssql As String
|
|
'ssql = "SELECT MAX(Reihenfolge) AS MaxSortOrder FROM spalten WHERE tabelle = '" & Me.TableName & "'"
|
|
Dim daMaxSortOrder As New SqlDataAdapter("SELECT MAX(Reihenfolge) AS MaxSortOrder FROM spalten WHERE tabelle = '" & Me.TableName & "'", Globals.sConnectionString)
|
|
daMaxSortOrder.Fill(dsMaxSortOrder)
|
|
DisplayColumnsCount = grd.Splits(0).DisplayColumns.Count - 1
|
|
iMaxSortOrderValue = dsMaxSortOrder.Tables(0).Rows(0).Item(0)
|
|
ReDim aSpalten(iMaxSortOrderValue - 1, 0) 'Array für Anzahlen definieren
|
|
|
|
|
|
t = ds.Tables(0)
|
|
ts.Tabelle = Me.TableName
|
|
For i = 0 To grd.Columns.Count - 1
|
|
s = grd.Columns(i).DataField
|
|
ts.Feld = s
|
|
ts.getspalte()
|
|
grd.Columns(i).Caption = ts.spaltenname
|
|
If ts.ColWith = 0 Then
|
|
grd.Splits(0).DisplayColumns(i).Width = 0
|
|
grd.Splits(0).DisplayColumns(i).Visible = False
|
|
Else
|
|
grd.Splits(0).DisplayColumns(i).Width = ts.ColWith
|
|
End If
|
|
|
|
'If grd.Columns(i).Caption = "" Then
|
|
' 'grd.Splits(0).DisplayColumns(i).Visible = False
|
|
' grd.Splits(0).DisplayColumns(i).Width = 0
|
|
' 'grd.Columns(i).Caption = grd.Columns(i).DataField
|
|
'Else
|
|
' grd.Splits(0).DisplayColumns(i).Width = ts.ColWith
|
|
'End If
|
|
If ts.locked Then
|
|
grd.Splits(0).DisplayColumns(i).Locked = True
|
|
End If
|
|
|
|
If ts.AlsHacken Then
|
|
grd.Columns(i).ValueItems.Presentation = C1.Win.C1TrueDBGrid.PresentationEnum.CheckBox
|
|
End If
|
|
|
|
'Präsentation von aktiv
|
|
If grd.Columns(i).DataField = "aktiv" Then
|
|
grd.Columns(i).ValueItems.Presentation = C1.Win.C1TrueDBGrid.PresentationEnum.CheckBox
|
|
grd.Columns(i).ValueItems.DefaultItem = True
|
|
grd.Columns(i).DefaultValue = True
|
|
grd.Columns(i).FilterText = True
|
|
End If
|
|
If grd.Columns(i).DataField = "erstellt_am" Then
|
|
grd.Columns(i).DefaultValue = Now
|
|
End If
|
|
|
|
|
|
'============ Aktuelle Spalte in ArraySpalten schreiben
|
|
'============ Sortorder darf nicht 0 sein
|
|
If iMaxSortOrderValue > 0 Then
|
|
If ts.Order = 0 Then
|
|
MessageBox.Show("Fehler Reihenfolge" & vbCrLf & "Tabelle " & Me.TableName & vbCrLf & "Spalte " & s & vbCrLf & "Sortierreihenfolge mit dem Wert 0 sind nicht erlaubt!" & vbCrLf & "Prüfen Sie die Reihenfolge der Tabelle " & Me.TableName & " in der Systemadministration Spalten", "Sortierreihenfolge 0", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)
|
|
Else
|
|
Reihe = grd.Splits(0).DisplayColumns(i)
|
|
If Not aSpalten(ts.Order - 1, 0) Is Nothing Then
|
|
'============ Arrayplatz bereits bleget
|
|
' MessageBox.Show("Doppelte Sortier-Nummer!" & vbCrLf & "Tabelle " & Me.TableName & vbCrLf & "Spalte " & s & vbCrLf & "Prüfen Sie die Sortierreihenfoge der Tabelle " & Me.TableName & " in der Systemadministration Spalten!", MessageBoxButtons.OK, "Sortierreihenfolge ", MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)
|
|
MessageBox.Show("Doppelte Sortier-Nummer!" & vbCrLf & "Tabelle " & Me.TableName & vbCrLf & "Spalte " & s & vbCrLf & "Sortierreihenfolge mit 2 gleichen Werten sind nicht erlaubt!" & vbCrLf & "Prüfen Sie die Reihenfolge der Tabelle " & Me.TableName & " in der Systemadministration Spalten", "Doppelte Sortier-Nummer " & ts.Order, MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1)
|
|
'bSetNewSortOrder = False
|
|
End If
|
|
If ts.Order > 0 And aSpalten(ts.Order - 1, 0) Is Nothing Then
|
|
'============ Aktuelle Spalte in ArraySpalten schreiben
|
|
aSpalten(ts.Order - 1, 0) = Reihe
|
|
End If
|
|
End If
|
|
End If
|
|
Next
|
|
|
|
If iMaxSortOrderValue > 0 And bSetNewSortOrder = True Then
|
|
'===============================================================================
|
|
'Wenn in der Sortierreihenfoge keine 0 steht werden die Spalten neu Sortiert
|
|
'===============================================================================
|
|
Try
|
|
'============ Spalten löschen
|
|
For i = 0 To DisplayColumnsCount
|
|
grd.Splits(0).DisplayColumns.RemoveAt(0)
|
|
Next
|
|
Catch
|
|
End Try
|
|
'============ Spalten nachh Sortorder einfügen
|
|
For i = 0 To iMaxSortOrderValue - 1
|
|
Try
|
|
If Not aSpalten(i, 0) Is Nothing Then
|
|
If aSpalten(i, 0).Width > 0 Then
|
|
grd.Splits(0).DisplayColumns.Insert(i - iSpaltenOffset, aSpalten(i, 0))
|
|
Else
|
|
iSpaltenOffset += 1
|
|
End If
|
|
Else
|
|
iSpaltenOffset += 1
|
|
End If
|
|
Catch ex As Exception
|
|
MsgBox(ex.Message)
|
|
End Try
|
|
|
|
Next
|
|
End If
|
|
dsMaxSortOrder = Nothing
|
|
daMaxSortOrder = Nothing
|
|
|
|
|
|
End Sub
|
|
|
|
Private Sub ToolBar1_ButtonClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolBarButtonClickEventArgs) Handles ToolBar1.ButtonClick
|
|
Select Case ToolBar1.Buttons.IndexOf(e.Button)
|
|
Case 0 'close button
|
|
Close()
|
|
Case 1 'Speichern
|
|
Save_Data()
|
|
Save_Reportfeldregel_Data()
|
|
Case Else
|
|
End Select
|
|
End Sub
|
|
|
|
Private Sub MenuItem2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MenuItem2.Click
|
|
Close()
|
|
End Sub
|
|
|
|
Private Sub frmClose(ByVal sender As System.Object, ByVal e As CancelEventArgs) Handles MyBase.Closing
|
|
Dim msg As MsgBoxResult
|
|
If Me.DataSet1.HasChanges Then
|
|
msg = Globals.MyMsg.Show_MessageYesNoCancel(2)
|
|
If msg = MsgBoxResult.No Then
|
|
e.Cancel = False
|
|
End If
|
|
If msg = MsgBoxResult.Yes Then
|
|
If Save_Reportfeldregel_Data() And Save_Data() Then e.Cancel = False Else e.Cancel = True
|
|
End If
|
|
End If
|
|
If msg = MsgBoxResult.Cancel Then e.Cancel = True
|
|
Try
|
|
Globals.WinPos.Set_Position(Me)
|
|
Catch
|
|
End Try
|
|
End Sub
|
|
|
|
#End Region
|
|
|
|
#Region "Datahandling"
|
|
|
|
Private Function Save_Data() As Boolean
|
|
|
|
Save_Data = True
|
|
Try
|
|
|
|
SqlDataAdapter1.Update(Me.DataSet1)
|
|
Catch ex As Exception
|
|
MsgBox(ex.Message)
|
|
MsgBox(Globals.MyMsg.Get_Meldungstext(902))
|
|
Save_Data = False
|
|
End Try
|
|
End Function
|
|
|
|
Private Sub Check_Changes()
|
|
Dim msg As MsgBoxResult
|
|
If Me.DataSet1.HasChanges Then
|
|
msg = Globals.MyMsg.Show_MessageYesNo(12)
|
|
If msg = MsgBoxResult.Yes Then
|
|
Save_Data()
|
|
End If
|
|
End If
|
|
End Sub
|
|
Private Function check_Reportfeldregel_changes() As Boolean
|
|
Dim msg As MsgBoxResult
|
|
If Me.DataSet1.HasChanges Then
|
|
msg = Globals.MyMsg.Show_MessageYesNo(13)
|
|
If msg = MsgBoxResult.Yes Then
|
|
If Save_Reportfeldregel_Data() = True Then
|
|
check_Reportfeldregel_changes = True
|
|
Else
|
|
check_Reportfeldregel_changes = False
|
|
End If
|
|
End If
|
|
End If
|
|
End Function
|
|
|
|
Private Function Save_Reportfeldregel_Data() As Boolean
|
|
Try
|
|
Save_Reportfeldregel_Data = True
|
|
SqlDataAdapter1.Update(Me.DataSet1)
|
|
Catch ex As Exception
|
|
MsgBox(ex.Message)
|
|
MsgBox(Globals.MyMsg.Get_Meldungstext(902))
|
|
Save_Reportfeldregel_Data = False
|
|
End Try
|
|
End Function
|
|
|
|
Private Function Generic_Select(ByVal typ As EnumCombotyp) As DataTable
|
|
|
|
Dim scmCmdToExecute As SqlCommand = New SqlCommand()
|
|
|
|
Select Case typ
|
|
Case EnumCombotyp.Feldtyp
|
|
scmCmdToExecute.CommandText = "pv_Feldtyp_Select"
|
|
Case EnumCombotyp.Steuerbefehl
|
|
scmCmdToExecute.CommandText = "pv_Steuerbefehl_Select"
|
|
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 EnumCombotyp.Feldtyp
|
|
scmCmdToExecute.Parameters.Add(New SqlParameter("@mandantnr", Globals.MandantNr))
|
|
Case EnumCombotyp.Steuerbefehl
|
|
scmCmdToExecute.Parameters.Add(New SqlParameter("@mandantnr", Globals.MandantNr))
|
|
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
|
|
|
|
Private Sub DomainList_RowColChange(ByVal sender As Object, ByVal e As C1.Win.C1TrueDBGrid.RowColChangeEventArgs) Handles DomainList.RowColChange
|
|
Me.mcboFeldTyp.SelectedValue = Me.DomainList.Columns("feldtypNr").Value 'feldtypNr
|
|
Me.mcboSteuerbefehl.SelectedValue = Me.DomainList.Columns("feldsteuerungNr").Value 'feldsteuerungNr
|
|
|
|
End Sub
|
|
|
|
Private Sub mcboFeldTyp_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles mcboFeldTyp.Validating
|
|
Me.DomainList.Columns("feldtypNr").Value = Me.mcboFeldTyp.SelectedValue 'feldtypNr
|
|
|
|
End Sub
|
|
Private Sub mcboSteuerbefehl_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles mcboSteuerbefehl.Validating
|
|
Me.DomainList.Columns("feldsteuerungNr").Value = (Me.mcboSteuerbefehl.SelectedValue) 'feldsteuerungNr
|
|
End Sub
|
|
|
|
|
|
#End Region
|
|
|
|
#Region " Kontrollfunktionen "
|
|
Private Sub txtBeschreibung_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles txtBeschreibung.Validating
|
|
If DomainList.Columns("Beschreibung").Text <> txtBeschreibung.Text Then
|
|
DomainList.Columns("Beschreibung").Text = txtBeschreibung.Text
|
|
moveDataPointer()
|
|
End If
|
|
|
|
End Sub
|
|
Private Sub txtBezeichnung_Validating(ByVal sender As Object, ByVal e As System.ComponentModel.CancelEventArgs) Handles txtBezeichnung.Validating
|
|
If DomainList.Columns("Bezeichnung").Text <> txtBezeichnung.Text Then
|
|
DomainList.Columns("Bezeichnung").Text = txtBezeichnung.Text
|
|
moveDataPointer()
|
|
End If
|
|
End Sub
|
|
|
|
#End Region
|
|
|
|
#Region " Extra Funktionen "
|
|
Private Sub moveDataPointer()
|
|
Dim iBookmanrk As Integer
|
|
iBookmanrk = DomainList.Bookmark
|
|
If iBookmanrk > 1 Then
|
|
DomainList.Bookmark = iBookmanrk - 1
|
|
DomainList.Bookmark = iBookmanrk
|
|
End If
|
|
End Sub
|
|
#End Region
|
|
|
|
|
|
|
|
End Class
|