/// <summary>
///
/// </summary>
/// <param name="cmdStr"></param>
/// <returns></returns>
internal static ICmd ParseSqlCmdString(string cmdStr, CoreEA.ICoreEAHander dbe)
{
ICmd curCmd = null;
if (string.IsNullOrEmpty(cmdStr))
{
ProcessException.DisplayErrors(new Exception("Empty Command"));
return(null);
}
try
{
cmdStr = cmdStr.TrimStart();
cmdStr = cmdStr.TrimEnd();
//Can't to lower , otherwise the insert data will never 大写
//cmdText = cmdText.ToLower();
string tempCmdText = cmdStr.ToLower();
if (tempCmdText.StartsWith("select"))
{
curCmd = new SelectCmd(dbe);
}
else if (tempCmdText.StartsWith("insert"))
{
curCmd = new InsertCmd(dbe);
}
else if (tempCmdText.StartsWith("update"))
{
curCmd = new UpdateCmd(dbe);
}
else if (tempCmdText.StartsWith("delete"))
{
curCmd = new DeleteCmd(dbe);
}
else if (tempCmdText.StartsWith("alter") || (tempCmdText.StartsWith("drop")))
{
curCmd = new SpecialCmd(dbe);
}
else if (tempCmdText.StartsWith("create"))
{
curCmd = new CreateCmd(dbe);
}
else if (tempCmdText.StartsWith("sp_rename"))
{
curCmd = new SpecialCmd(dbe);
}
else
{
curCmd = null;
//throw new Exception("ErrorMsg_CannotParseSqlCmd".GetFromResourece());
}
}
catch (Exception ee)
{
ProcessException.DisplayErrors(ee);
}
return(curCmd);
}
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
{
}
}
void IStep.Leave()
{
DocDbObject myInfo = (DocDbObject)MyDocDataContext;
myInfo.LoginInfo = ((LoginInfo_Oledb)((ISrcControl)this).X_Result);
try
{
CoreEA.ICoreEAHander tempHandler = null;
if ((bool)radAccess.IsChecked)
{
tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.OleDb).X_Handler;
}
else if ((bool)radCVS.IsChecked)
{
tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.CSV).X_Handler;
}
else if ((bool)radExcel.IsChecked)
{
tempHandler = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.Excel).X_Handler;
}
tempHandler.Open(myInfo.LoginInfo);
if (tempHandler.IsOpened)
{
}
else
{
throw new Exception("Password not correct");
}
}
catch (Exception ee)
{
throw ee;
}
}
public UpdateCmd(CoreEA.ICoreEAHander dbe)
: base()
{
base.CurDBE = dbe;
}
public SrcTableList(CoreEA.ICoreEAHander inCore)
{
core = inCore;
InitializeComponent();
}
public SpecialCmd(CoreEA.ICoreEAHander dbe)
: base()
{
base.CurDBE = dbe;
}
private void butGetDbList_Click(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(cmbServername.Text))
{
cmbServername.Focus();
return;
}
if (string.IsNullOrEmpty(txtUsername.Text))
{
txtUsername.Focus();
return;
}
CoreEA.ICoreEAHander core = null;
switch (X_CurUIMode)
{
case CurUIMode.ForSqlServer:
core = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.SqlServer).X_Handler;
break;
case CurUIMode.ForMySql:
core = new CoreEA.CoreE(CoreEA.CoreE.UsedDatabaseType.MySql).X_Handler;
break;
}
LoginInfo_SqlServer info = new LoginInfo_SqlServer();
X_LoginDbParas args = cmbConnMode.SelectedItem as X_LoginDbParas;
if (args.Name == ATTACH_FILE)
{
info = new LoginInfo_SqlServer()
{
X_Server = cmbServername.Text,
AttchFile = txtDbFileLocation.Text,
//attach file mode need trust connection
IsTrustedConn = true,
};
}
else
{
info = new LoginInfo_SqlServer()
{
X_Server = cmbServername.Text,
X_UserName = txtUsername.Text,
X_Pwd = passwordBox1.Password,
IsTrustedConn = (bool)chkIsTrustedConn.IsChecked,
};
}
if (cmbConnMode.SelectedItem != null)
{
info.X_CurDbConnectionMode = ((X_LoginDbParas)cmbConnMode.SelectedItem).CurConnMode;
}
try
{
core.Open(info);
}
catch (Exception ee)
{
MessageBox.Show(ee.Message);
return;
}
if (core.IsOpened)
{
cmbDbName.Items.Clear();
foreach (var item in core.GetDatabaseList())
{
cmbDbName.Items.Add(item);
}
if (cmbDbName.Items.Count > 1)
{
cmbDbName.SelectedIndex = 0;
}
core.Close();
core.Dispose();
}
}
public InsertCmd(CoreEA.ICoreEAHander dbe)
: base()
{
base.CurDBE = dbe;
}
public SelectCmd(CoreEA.ICoreEAHander dbe)
: base()
{
base.CurDBE = dbe;
}
