private void butGetTableList_Click(object sender, RoutedEventArgs e) { WPFCommonControl.SqlServerLoginControl.X_CollectionData controlResult = sqlServerLoginControl1.X_Result; string server = controlResult.Server; string database = controlResult.DbName; string username = controlResult.UID; string pwd = controlResult.PWD; if (string.IsNullOrEmpty(server) || string.IsNullOrEmpty(database) || string.IsNullOrEmpty(username)) { MessageBox.Show("ImportEachElement".GetFromResourece()); return; } //This core will be used later , do not dispose it core = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler; LoginInfo_SqlServer info = new LoginInfo_SqlServer() { X_Server = controlResult.Server, X_UserName = controlResult.UID, X_Pwd = controlResult.PWD, X_Port = sqlServerLoginControl1.X_Result.Port.ToString(), IsTrustedConn = sqlServerLoginControl1.X_Result.IsTrust, X_CurDbConnectionMode = sqlServerLoginControl1.X_Result.CurType.CurConnMode, }; try { core.Open(info); if (core.IsOpened) { this.tableList.Items.Clear(); foreach (string item in core.GetTableListInDatabase(database)) { tableList.Items.Add(item); } } } catch (Exception ee) { ee.HandleMyException(); } finally { } }
private void butCreateDb_Click(object sender, RoutedEventArgs e) { WPFCommonControl.SqlServerLoginControl.X_CollectionData controlResult = this.sqlServerLoginControl1.X_Result; if (string.IsNullOrEmpty(controlResult.Server) || string.IsNullOrEmpty(controlResult.DbName) || string.IsNullOrEmpty(controlResult.UID)) { "ImportEachElement".GetFromResourece().Notify(); return; } CreateDatabase createDbWin = new CreateDatabase(); createDbWin.Args = controlResult; createDbWin.Show(); }
private void DoConnectCmd_Executed(object sender, ExecutedRoutedEventArgs e) { WPFCommonControl.SqlServerLoginControl.X_CollectionData controlResult = this.sqlServerLoginControl1.X_Result; if (controlResult.IsUseFileDirectly) { } else { if (string.IsNullOrEmpty(controlResult.Server) || string.IsNullOrEmpty(controlResult.DbName) || string.IsNullOrEmpty(controlResult.UID)) { "ImportEachElement".GetFromResourece().Notify(); return; } } LoginInSqlServer(controlResult); }
public void TestSchmea() { testContextInstance.RecordTestMethod(); WPFCommonControl.SqlServerLoginControl.X_CollectionData data = new WPFCommonControl.SqlServerLoginControl.X_CollectionData() { DbName = "Master", CurType = new WPFCommonControl.SqlServerLoginControl.X_LoginDbParas() { CurConnMode = CoreEA.Args.CurDbServerConnMode.SqlServer2005Express, Name = "SqlServer2008", }, PWD = "1", Server = "Leond-xp\\sql2008", UID = "sa", }; SqlServerEntry_Accessor main = new SqlServerEntry_Accessor(); main.LoginInSqlServer(data); TestGlobalExtension.RecordTestMethod(); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void butBackupDb_Click(object sender, RoutedEventArgs e) { WPFCommonControl.SqlServerLoginControl.X_CollectionData controlResult = this.sqlServerLoginControl1.X_Result; if (string.IsNullOrEmpty(controlResult.Server) || string.IsNullOrEmpty(controlResult.DbName) || string.IsNullOrEmpty(controlResult.UID)) { "ImportEachElement".GetFromResourece().Notify(); return; } App.MainEngineer = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler; LoginInfo_SqlServer info = new LoginInfo_SqlServer() { X_Server = controlResult.Server, X_Database = controlResult.DbName, X_Pwd = controlResult.PWD, X_UserName = controlResult.UID, X_Port = controlResult.Port.ToString(), X_CurDbConnectionMode = controlResult.CurType.CurConnMode, IsTrustedConn = controlResult.IsTrust, }; PageSwitchProgressBar dp = null; try { App.MainEngineer.Open(info); if (App.MainEngineer.IsOpened) { if (!"InfoBackupDb".GetFromResourece().Confirm()) { return; } SaveFileDialog sf = new SaveFileDialog(); sf.Filter = MyGlobal.BackupDatabase_FILE_FILTER; if ((bool)sf.ShowDialog()) { string cmdStr = string.Format("BACKUP DATABASE {0} TO DISK = N'{1}' WITH NOFORMAT, NOINIT,NAME = N'{2}', SKIP, NOREWIND, NOUNLOAD, STATS = 10", App.MainEngineer.CurDatabase, sf.FileName, "BackupDataFile"); IDbCommand cmd = App.MainEngineer.GetNewStringCommand(cmdStr); cmd.CommandTimeout = int.MaxValue / 2; dp = PageSwitchProgressBar.X_BeginLoadingDialog(); cmd.ExecuteNonQuery(); dp.X_EndLoadingDialog(); dp = null; "InfoBackupSuccesful".GetFromResourece().Show(); } } } catch (Exception ee) { ee.HandleMyException(); } finally { if (null != dp) { dp.X_EndLoadingDialog(); } App.ResetMainEngineer(); } }
private void LoginInSqlServer(WPFCommonControl.SqlServerLoginControl.X_CollectionData controlResult) { try { App.MainEngineer = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler; } catch (Exception ee) { MessageBox.Show(ee.Message); return; } LoginInfo_SqlServer info = new LoginInfo_SqlServer() { X_Server = controlResult.Server, X_Database = controlResult.DbName, X_Pwd = controlResult.PWD, X_UserName = controlResult.UID, X_Port = controlResult.Port.ToString(), X_CurDbConnectionMode = controlResult.CurType.CurConnMode, IsTrustedConn = controlResult.IsTrust, AttchFile = controlResult.DbFileLocation, }; try { App.MainEngineer.Open(info); if (App.MainEngineer.IsOpened) { #region Save to Opened History Info SqlServerObjects sqlserverItem = new SqlServerObjects(); sqlserverItem.ServerAddress = info.X_Server; if (info.X_Port.IsNotEmpty()) { sqlserverItem.Port = int.Parse(info.X_Port); } sqlserverItem.Username = info.X_UserName; if (!SerializeClass.DatabaseHistoryInfo.SqlServerHistory.IsContainSubValue(sqlserverItem.ServerAddress)) { HistoryObject oldObject = SerializeClass.DatabaseHistoryInfo; oldObject.SqlServerHistory.Add(sqlserverItem); SerializeClass.DatabaseHistoryInfo = oldObject; } #endregion App.MainEngineer.CurDatabase = controlResult.DbName; RibbionIDE ide = new RibbionIDE(); //this.Visibility = Visibility.Hidden; //ide.Closed += (a, b) => { this.Visibility = Visibility.Visible; }; ide.Title = info.X_Server; ide.ShowDialog(); } } catch (Exception ee) { App.ResetMainEngineer(); ee.HandleMyException(); } }