private void Window_Loaded (object sender, RoutedEventArgs e) { m_CVM = new CommonValues (); m_XAMLHandling = new XAMLHandling (m_CVM); m_WebService = new WPMediaNetworkAccess.WPMediaDataBase (); m_WebService.ConnectionStringName = "WPMediaAddOnDataConnectionString"; WMB.WPMediaApplicationState.Instance.Properties ["DataBase"] = m_WebService; DataSet AvailableTablesDataSet = m_WebService.GetCommonDataSet ("Select TableName from TableDefinitions"); List<String> AvailableTables = new List<string> (); ListBox ProtokollBox = new ListBox (); RootGrid.Children.Add( ProtokollBox); this.Title = "Die folgenden Tabellen werden mit Verwaltungsdaten abgeglichen"; foreach (DataRow Row in AvailableTablesDataSet.Tables [0].Rows) { String AvailableTableName = Row ["TableName"].ToString (); if ((m_Arguments == null) || (m_Arguments.Length < 1)) { AvailableTables.Add (AvailableTableName); ProtokollBox.Items.Add (AvailableTableName); } else { if (String.Compare( m_Arguments [0], "All", true) == 0) { AvailableTables.Add (AvailableTableName); ProtokollBox.Items.Add (AvailableTableName); } else { int Index = 0; while (Index < m_Arguments.Length) { if (String.Compare (AvailableTableName, m_Arguments [Index], true) == 0) { AvailableTables.Add (AvailableTableName); ProtokollBox.Items.Add (AvailableTableName); break; } Index++; } } } } m_StartTimer = new DispatcherTimer(); m_StartTimer.Interval = TimeSpan.FromMilliseconds (1); m_StartTimer.Tick += new EventHandler (m_StartTimer_Tick); m_StartTimer.Tag = AvailableTables; m_StartTimer.Start (); }
private void Window_Loaded (object sender, RoutedEventArgs e) { m_DataBase = new WPMediaNetworkAccess.WPMediaDataBase (); m_DataBase.ConnectionStringName = "WPMediaAddOnDataConnectionString"; WMB.WPMediaApplicationState.Instance.Properties ["DataBase"] = m_DataBase; SizeToContent = SizeToContent.WidthAndHeight; PublishCalendar Publisher = new PublishCalendar (); Publisher.m_DataBase = m_DataBase; Publisher.RunPublishCalendar (); Close (); }
public bool SetData (CommonDataBase.DataBase DataBase, Object Sender, String Bereich, DataSet SchemaDataSet, TableContentDefinition [] TableContentDefinitions, TableLayoutDefinition TableLayoutDefinition) { m_Bereich = Bereich; m_SchemaDataSet = SchemaDataSet; m_TableContentDefinitions = TableContentDefinitions; m_TableLayoutDefinition = TableLayoutDefinition; if (DataBase != null) m_DataBase = DataBase; else m_DataBase = new DataBase (); if (Sender.GetType () == typeof (ListBox)) { ListBox ListBoxToProcess = (ListBox)Sender; UserData = (ControlUserData)ListBoxToProcess.Tag; if (ListBoxToProcess.SelectedIndex == -1) { return false; } m_ActiveID = ((ListBoxItem)ListBoxToProcess.Items [ListBoxToProcess.SelectedIndex]).Tag.ToString (); } if (Sender.GetType () == typeof (Microsoft.Windows.Controls.DataGrid)) { Microsoft.Windows.Controls.DataGrid DataGridToProcess = (Microsoft.Windows.Controls.DataGrid) Sender; UserData = (ControlUserData)DataGridToProcess.Tag; if (DataGridToProcess.SelectedIndex == -1) { return false; } m_ActiveID = ((DataRowView)DataGridToProcess.SelectedItems [0]).Row ["ID"].ToString (); } m_RefreshmentRoutine = UserData.m_RefreshFunctionName; m_PrimaryKeyName = UserData.m_PrimaryKeyName; //SimpleDataRowWindow DataRowWindow = new SimpleDataRowWindow (); m_ProcessingDataSet = m_DataBase.GetCommonDataSet ( "Select * from " + UserData.m_TableName + " where " + m_PrimaryKeyName + " = '" + m_ActiveID + "'"); SetRowToProcess (m_ProcessingDataSet.Tables [0].Rows [0], "Bitte ändern Sie ggf. die Daten dieser " + UserData.m_TableName, UserData.m_UpdateAble); return true; }