private void Menu_AfterSelect(object sender, TreeViewEventArgs e) { lblMsg.Visible = true; lblMsg.Refresh(); switch (e.Node.Text) { case "表": //MenuSplitContainer.Panel2.Controls.Clear(); var compareTable = new CompareTable(txtSourceDB.Text, txtTargetDB.Text); splMenu.Panel2.Controls.Clear(); compareTable.Dock = DockStyle.Fill; compareTable.TopLevel = false; compareTable.WindowState = FormWindowState.Maximized; compareTable.FormBorderStyle = FormBorderStyle.None; compareTable.Parent = splMenu.Panel2; compareTable.Show(); break; case "视图": break; case "存储过程": break; case "函数": break; default: break; } Thread.Sleep(2000); lblMsg.Visible = false; lblMsg.Refresh(); }
private void InitExchanges( ) { foreach (var exchange in Exchanges.Values) { exchange.ClearObservers( ); Observers[exchange.Id] = new CryptoExchangeObserver(exchange); exchange.Changed += (e, coin) => { if (!pendingUpdates.Contains(e.Id)) { pendingUpdates.Enqueue(e.Id); } }; var observer = Observers[exchange.Id]; observer.Next += (e, coin) => Logger.Debug($"{e.Name,-10} {e[coin.Symbol]}"); exchange.Subscribe(observer); CompareTable.AddExchange(exchange); try { Task.Run(() => exchange.StartMonitor(cts.Token), cts.Token); } catch (Exception e) { Logger.Error(e); throw; } } }
public DataTable ExecuteComparison() { DataRow compareRow; foreach (DataRow masterRow in MasterTable.Rows) { foreach (DataRow testRow in TestTable.Rows) { compareRow = CompareTable.NewRow(); for (int i = 0; i < this.TableHeaders.Length; i++) { if (masterRow[this.TableHeaders[i]].ToString().Equals(testRow[this.TableHeaders[i]].ToString())) { compareRow[this.TableHeaders[i]] = "0"; } else { compareRow[this.TableHeaders[i]] = masterRow[this.TableHeaders[i]].ToString() + " | " + testRow[this.TableHeaders[i]].ToString(); } } CompareTable.Rows.Add(compareRow); } } return(CompareTable); }
private void InitExchanges( ) { foreach (var exchange in Exchanges.Values) { //exchange.Next += UpdateExchangeLastUpdateInDb; exchange.Changed += (e, coin) => Logger.Debug($"{e.Name,-10} {e[coin.Id]}"); //exchange.Changed += StoreCoinValueInDb; CompareTable.AddExchange(exchange); try { Task.Run(() => exchange.StartMonitor(Cts.Token), Cts.Token); } catch (Exception e) { Logger.Error(e); throw; } } IsInitialized = true; }
private void compareDB_DoWork(object sender, System.ComponentModel.DoWorkEventArgs e) { foreach (SQLTables tab in this.Data.DB1Tables) { CompareTable table = new CompareTable(); table.TableName = tab.TableName; table.TableName1 = tab.TableName; table.TableName2 = ""; table.DB1 = true; this.Data.CompareTables.Add(table); } foreach (SQLTables tab in this.Data.DB2Tables) { int cnt = this.Data.DB1Tables.FindAll(o => o.TableName == tab.TableName).Count; if (cnt == 0) { CompareTable table = new CompareTable(); table.TableName = tab.TableName; table.TableName1 = ""; table.TableName2 = tab.TableName; table.DB2 = true; this.Data.CompareTables.Add(table); } else { try { this.Data.CompareTables.FirstOrDefault(o => o.TableName == tab.TableName).DB2 = true; this.Data.CompareTables.FirstOrDefault(o => o.TableName == tab.TableName).TableName2 = tab.TableName; } catch (Exception ex) { } } } this.Data.CompareTables = this.Data.CompareTables.OrderBy(o => o.TableName).ToList <CompareTable>(); }
public void Dispose() { Table?.Dispose(); CompareTable?.Dispose(); }
private void Menu_NodeMouseClick(object sender, TreeNodeMouseClickEventArgs e) { try { lblMsg.Visible = true; lblMsg.Refresh(); if (tvwMenu.SelectedNode != null) { tvwMenu.SelectedNode.ToolTipText = tvwMenu.SelectedNode.Text; } tvwMenu.SelectedNode = e.Node; tvwMenu.SelectedNode.ToolTipText = "点击刷新"; //var maskLayer = new MaskLayerForm(new Size(this.ClientRectangle.Width, this.ClientRectangle.Height), new Point(this.Left, this.Top + this.Height - this.ClientRectangle.Height), "正在加载..."); //maskLayer.ShowDialog(this); tvwMenu.Enabled = false; tvwMenu.Cursor = Cursors.WaitCursor; var label = new Label(); label.Text = "正在加载..."; label.Location = new Point(10, 10); splMenu.Panel2.Controls.Clear(); splMenu.Panel2.Controls.Add(label); splMenu.Panel2.Refresh(); switch (e.Node.Text) { case "表": var compareTable = new CompareTable(txtSourceDB.Text, txtTargetDB.Text); splMenu.Panel2.Controls.Remove(label); showSubForm(compareTable); //compareTable.Dock = DockStyle.Fill; //compareTable.TopLevel = false; //compareTable.WindowState = FormWindowState.Maximized; //compareTable.FormBorderStyle = FormBorderStyle.None; //compareTable.Parent = splMenu.Panel2; //compareTable.Show(); break; case "视图": //splMenu.Panel2.Controls.Clear(); var compareView = new CompareView(txtSourceDB.Text, txtTargetDB.Text); splMenu.Panel2.Controls.Remove(label); showSubForm(compareView); //compareView.Dock = DockStyle.Fill; //compareView.TopLevel = false; //compareView.WindowState = FormWindowState.Maximized; //compareView.FormBorderStyle = FormBorderStyle.None; //compareView.Parent = splMenu.Panel2; //compareView.Show(); break; case "存储过程": //splMenu.Panel2.Controls.Clear(); var compareProcedure = new CompareProcedure(txtSourceDB.Text, txtTargetDB.Text); splMenu.Panel2.Controls.Remove(label); showSubForm(compareProcedure); //compareProcedure.Dock = DockStyle.Fill; //compareProcedure.TopLevel = false; //compareProcedure.WindowState = FormWindowState.Maximized; //compareProcedure.FormBorderStyle = FormBorderStyle.None; //compareProcedure.Parent = splMenu.Panel2; //compareProcedure.Show(); break; case "函数": //splMenu.Panel2.Controls.Clear(); var compareFunction = new CompareFunction(txtSourceDB.Text, txtTargetDB.Text); splMenu.Panel2.Controls.Remove(label); showSubForm(compareFunction); //compareFunction.Dock = DockStyle.Fill; //compareFunction.TopLevel = false; //compareFunction.WindowState = FormWindowState.Maximized; //compareFunction.FormBorderStyle = FormBorderStyle.None; //compareFunction.Parent = splMenu.Panel2; //compareFunction.Show(); break; default: break; } } catch { } finally { lblMsg.Visible = false; lblMsg.Refresh(); tvwMenu.Enabled = true; tvwMenu.Cursor = Cursors.Hand; //wait = false; } }
public CompareFormVM(GroupVM group, CompareTable compareTable) : base(group) { this.groupModel = group.GroupModel; this.compareTable = compareTable; rows = new ObservableCollection <CompareRowVM>(); }