private void MenuItem_导出数据_Click_1(object sender, RoutedEventArgs e)
{
DatabaseItemNode selectedItem = ((FrameworkElement)e.OriginalSource).DataContext as DatabaseItemNode;
Forms.OutputDBTableData frm = new Forms.OutputDBTableData(selectedItem);
frm.Owner = this;
frm.ShowDialog();
}
private void MenuItem_新建数据表_Click_1(object sender, RoutedEventArgs e)
{
MenuItem item = (MenuItem)sender;
ContextMenu menu = (ContextMenu)item.Parent;
var obj = (StackPanel)menu.PlacementTarget;
DatabaseItemNode dbnode = (DatabaseItemNode)obj.Tag;
Forms.DBTableEditor frm = new Forms.DBTableEditor(dbnode, null);
frm.Owner = this;
frm.ShowDialog();
}
private void MenuItem_数据库属性_Click_1(object sender, RoutedEventArgs e)
{
DatabaseItemNode databaseItemNode = tree1.SelectedItem as DatabaseItemNode;
ProjectNode projectNode = databaseItemNode.Parent.Parent as ProjectNode;
Forms.DatabaseEditor form = new Forms.DatabaseEditor(projectNode.Project.id.Value, databaseItemNode.Database);
form.Title = "数据库属性";
form.Owner = this;
if (form.ShowDialog() == true)
{
databaseItemNode.Parent.ReBindItems();
}
}
private void MenuItem_导入数据_Click_1(object sender, RoutedEventArgs e)
{
DatabaseItemNode selectedItem = ((FrameworkElement)e.OriginalSource).DataContext as DatabaseItemNode;
using (System.Windows.Forms.OpenFileDialog f = new System.Windows.Forms.OpenFileDialog())
{
f.Filter = "*.xml|*.xml";
if (f.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
Forms.ImportData frm = new Forms.ImportData(f.FileName, selectedItem);
frm.ShowDialog();
}
}
}
void MenuItem_从其他数据库导入表结构_Click_1(object sender, RoutedEventArgs e)
{
DatabaseItemNode selectedItem = ((FrameworkElement)e.OriginalSource).DataContext as DatabaseItemNode;
Forms.DatabaseSchema frm = new Forms.DatabaseSchema(selectedItem.Database);
frm.Owner = this;
if (frm.ShowDialog() == true)
{
var node = selectedItem.Children.FirstOrDefault(m => m is 数据表Node) as 数据表Node;
selectedItem.IsExpanded = true;
node.IsExpanded = true;
node.ReBindItems();
Helper.ShowMessage(this, "成功生成数据表");
}
}
private void MenuItem_移除数据库_Click_1(object sender, RoutedEventArgs e)
{
DatabaseItemNode selectedItem = ((FrameworkElement)e.OriginalSource).DataContext as DatabaseItemNode;
if (MessageBox.Show("确定移除" + selectedItem.Name + "吗？", "", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
try
{
selectedItem.Delete();
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message);
}
}
}
private void MenuItem_重置表结构变更历史_Click(object sender, RoutedEventArgs e)
{
if (MessageBox.Show(this, "重置表结构变更历史，会把所有表设置为新建的数据表，即把表结构历史清空，把所有表都认为是新建的数据表。\r\n\r\n此操作不会影响目前的表结构，但是如果此数据库已经应用到程序上，不建议重置表结构变更历史。\r\n\r\n确定重置吗？", "", MessageBoxButton.OKCancel) == MessageBoxResult.OK)
{
try
{
DatabaseItemNode selectedItem = ((FrameworkElement)e.OriginalSource).DataContext as DatabaseItemNode;
Helper.Client.InvokeSync <bool>("RebuildDatabaseActions", selectedItem.Database.id);
MessageBox.Show(this, "成功重置表结构变更历史！");
}
catch (Exception ex)
{
MessageBox.Show(this, ex.GetBaseException().Message);
}
}
}
void 新建数据表(object sender, RoutedEventArgs e)
{
TreeNodeBase parent = this.ModuleNode.Parent;
while (!(parent is DatabaseItemNode))
{
parent = parent.Parent;
}
DatabaseItemNode databaseitemNode = (DatabaseItemNode)parent;
Forms.DBTableEditor frm = new Forms.DBTableEditor(databaseitemNode, null);
frm.Owner = MainWindow.instance;
if (frm.ShowDialog() == true)
{
AddTable2Me((DBTableNode)databaseitemNode.Children.FirstOrDefault(m => m is TreeNode.数据表Node).Children[0], m_newTableLocation);
}
}
private void MenuItem_导出更新_Click_1(object sender, RoutedEventArgs e)
{
DatabaseItemNode selectedItem = ((FrameworkElement)e.OriginalSource).DataContext as DatabaseItemNode;
try
{
using (System.Windows.Forms.SaveFileDialog fd = new System.Windows.Forms.SaveFileDialog())
{
fd.Filter = "*.action|*.action";
fd.FileName = selectedItem.Database.Name + "_更新脚本.action";
if (fd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
selectedItem.OutputAction(fd.FileName);
MessageBox.Show("导出完毕！");
}
}
}
catch (Exception ex)
{
MessageBox.Show(this, ex.Message);
}
}
void downloadClass(DatabaseItemNode selectedItem, string url)
{
using (System.Windows.Forms.SaveFileDialog fd = new System.Windows.Forms.SaveFileDialog())
{
var savepath = this.Cache[$"{url}_{selectedItem.Database.id}"];
if (!string.IsNullOrEmpty(savepath))
{
try
{
fd.InitialDirectory = System.IO.Path.GetDirectoryName(savepath);
fd.FileName = System.IO.Path.GetFileName(savepath);
}
catch
{
fd.FileName = selectedItem.Database.Name + ".cs";
}
}
else
{
fd.FileName = selectedItem.Database.Name + ".cs";
}
if (fd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
try
{
Forms.BuildeCode code = new Forms.BuildeCode(selectedItem.Database.id.Value, fd.FileName, url);
code.Owner = this;
code.ShowDialog();
this.Cache[$"{url}_{selectedItem.Database.id}"] = fd.FileName;
this.Cache.Save();
}
catch (Exception ex)
{
Helper.ShowError(ex);
}
}
}
}
private void MenuItem_生成简单模型代码_Click_1(object sender, RoutedEventArgs e)
{
DatabaseItemNode selectedItem = ((FrameworkElement)e.OriginalSource).DataContext as DatabaseItemNode;
using (System.Windows.Forms.SaveFileDialog fd = new System.Windows.Forms.SaveFileDialog())
{
if (!string.IsNullOrEmpty(selectedItem.Database.dllPath) && selectedItem.Database.dllPath.StartsWith("{"))
{
var json = (Newtonsoft.Json.Linq.JToken)Newtonsoft.Json.JsonConvert.DeserializeObject(selectedItem.Database.dllPath);
try
{
fd.InitialDirectory = System.IO.Path.GetDirectoryName(json.Value <string>("simple"));
fd.FileName = System.IO.Path.GetFileName(json.Value <string>("simple"));
}
catch
{
fd.FileName = selectedItem.Database.Name + ".cs";
}
}
else
{
fd.FileName = selectedItem.Database.Name + ".cs";
}
if (fd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
try
{
Forms.BuildeCode code = new Forms.BuildeCode(selectedItem.Database.id.Value, fd.FileName, "DownLoadSimpleCodeHandler.aspx");
code.Owner = this;
code.ShowDialog();
}
catch (Exception ex)
{
Helper.ShowError(ex);
}
}
}
}
private void MenuItem_生成最简化模型代码_Click_1(object sender, RoutedEventArgs e)
{
DatabaseItemNode selectedItem = ((FrameworkElement)e.OriginalSource).DataContext as DatabaseItemNode;
downloadClass(selectedItem, "DownLoadVerySimpleCodeHandler.aspx");
}