void ConnectCmd_Executed(object sender, ExecutedRoutedEventArgs e)
{
if (string.IsNullOrEmpty(txtServername.Text))
{
return;
}
if (string.IsNullOrEmpty(txtUsername.Text))
{
return;
}
LoginInfo_MySql info = new LoginInfo_MySql()
{
Server = txtServername.Text,
Database = txtDbName.Text,
Username = txtUsername.Text,
Pwd = passwordBox1.Password,
Port = int.Parse(txtPort.Text),
ConnectionTimeOut = 2000,
};
try
{
App.MainEngineer = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler;
App.MainEngineer.Open(info);
if (App.MainEngineer.IsOpened)
{
#region Save to Opened History Info
MySqlObjects mysqlItem = new MySqlObjects();
mysqlItem.ServerAddress = info.Server;
mysqlItem.Port = info.Port;
mysqlItem.Username = info.Username;
if (!SerializeClass.DatabaseHistoryInfo.MySqlHistory.IsContainSubValue(mysqlItem.ServerAddress))
{
HistoryObject oldObject = SerializeClass.DatabaseHistoryInfo;
oldObject.MySqlHistory.Add(mysqlItem);
SerializeClass.DatabaseHistoryInfo = oldObject;
}
#endregion
App.MainEngineer.CurDatabase = txtDbName.Text;
App.MainEngineer.CurPwd = passwordBox1.Password;
RibbionIDE ide = new RibbionIDE();
ide.Title = info.Server;
ide.ShowDialog();
}
}
catch (Exception ee)
{
//ee._获取我的异常详细信息().Show();
App.ResetMainEngineer();
ee.HandleMyException();
}
}
private void InitDBs()
{
if (string.IsNullOrEmpty(txtServername.Text))
{
return;
}
if (string.IsNullOrEmpty(txtUsername.Text))
{
return;
}
LoginInfo_MySql info = new LoginInfo_MySql()
{
Server = txtServername.Text,
Username = txtUsername.Text,
Pwd = passwordBox1.Password,
Port = int.Parse(txtPort.Text),
};
try
{
App.MainEngineer = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler;
App.MainEngineer.Open(info);
if (App.MainEngineer.IsOpened)
{
List <string> dblist = App.MainEngineer.GetDatabaseList();
txtDbName.ItemsSource = null;
txtDbName.ItemsSource = dblist;
currentDbList.Clear();
currentDbList = dblist;
}
}
catch (Exception ce)
{
ce.Message.Show();
}
finally
{
App.ResetMainEngineer();
}
}
void CreateCmd_Executed(object sender, ExecutedRoutedEventArgs e)
{
if ("CreateDatabaseNotifyMsg".GetFromResourece().Confirm())
{
//Should notice there we didn't specify database name
LoginInfo_MySql info = new LoginInfo_MySql()
{
Server = txtServername.Text,
Username = txtUsername.Text,
Pwd = passwordBox1.Password,
Port = int.Parse(txtPort.Text),
};
App.MainEngineer = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler;
App.MainEngineer.Open(info);
try
{
if (App.MainEngineer.IsOpened)
{
App.MainEngineer.DoExecuteNonQuery(
string.Format("Create database {0} CHARACTER SET {1}",
txtDbName.Text,
txtCharset.Text));
"CreateDatabaseOkMsg".GetFromResourece().Show();
}
}
catch (Exception ee)
{
ee.Message.Show();
}
finally
{
App.ResetMainEngineer();
}
InitDBs();
}
}
public sealed override void Open(BaseLoginInfo pInfo)
{
//Record to base class (Vital)
baseLoginInfo = pInfo;
LoginInfo_MySql myInfo = pInfo as LoginInfo_MySql;
LoginInfo_ForAllDbTypes allInfo = pInfo as LoginInfo_ForAllDbTypes;
if ((myInfo == null) && (allInfo == null))
{
throw new ArgumentException("Only Support MySql login info and AllDBTypes Info");
}
if (IsOpened)
{
return;
}
try
{
string myConnString = string.Empty;
if (allInfo != null)
{
myInfo = new LoginInfo_MySql();
myInfo.Database = allInfo.Database;
myInfo.Pwd = allInfo.Pwd;
myInfo.Server = allInfo.Server;
myInfo.Username = allInfo.Username;
myInfo.Port = allInfo.Port;
}
myConnString = DbConnectionString.MySql.GetMySqlConnectionString(
myInfo.Server,
myInfo.Username,
myInfo.Pwd,
myInfo.Port,
myInfo.Database,
myInfo.ConnectionTimeOut,
50,
myInfo.IsPolling
);
baseConn = new MySqlConnection(myConnString);
baseConn.Open();
Debug.WriteLine("Connection Timeout is " + baseConn.ConnectionTimeout);
invalidator = new InvalidatorForMySql();
//Set Current Opened Database
base.CurDatabase = myInfo.Database;
base.CurPwd = myInfo.Pwd;
if (string.IsNullOrEmpty(myInfo.Database))
{
DoExecuteNonQuery("use mysql;");
}
else
{
DoExecuteNonQuery("use " + myInfo.Database + ";");
}
}
catch (Exception ee)
{
throw ee;
}
}
