You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
580 lines
26 KiB
580 lines
26 KiB
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Windows;
|
|
using System.Windows.Controls;
|
|
using System.Windows.Data;
|
|
using System.Windows.Documents;
|
|
using System.Windows.Input;
|
|
using System.Windows.Media;
|
|
using System.Windows.Media.Imaging;
|
|
using System.Windows.Shapes;
|
|
using System.Data;
|
|
using System.Reflection;
|
|
using System.Xml;
|
|
|
|
namespace SiaSun.LMS.WPFClient.SYS
|
|
{
|
|
/// <summary>
|
|
/// FIELD_DESCRIPTION.xaml 的交互逻辑
|
|
/// </summary>
|
|
public partial class FIELD_DESCRIPTION : AvalonDock.DocumentContent
|
|
{
|
|
DataTable tableDescription = null;
|
|
public FIELD_DESCRIPTION()
|
|
{
|
|
InitializeComponent();
|
|
this.Loaded += new RoutedEventHandler(FIELD_DESCRIPTION_Loaded);
|
|
this.listBoxModel.SelectionChanged += new SelectionChangedEventHandler(listBoxModel_SelectionChanged);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 窗体加载
|
|
/// </summary>
|
|
void FIELD_DESCRIPTION_Loaded(object sender, RoutedEventArgs e)
|
|
{
|
|
//加载所有的Models
|
|
LoadModels();
|
|
|
|
//初始化DataTable
|
|
InitDataTable();
|
|
}
|
|
|
|
//加载Model
|
|
private void LoadModels()
|
|
{
|
|
try
|
|
{
|
|
//加载所有实体类中的节点
|
|
Assembly assemblyModel = Assembly.LoadFrom(MainApp._APP_PATH + "SiaSun.LMS.Model.dll");
|
|
if (assemblyModel == null)
|
|
return;
|
|
Module moduleModel = assemblyModel.ManifestModule;
|
|
Type[] arTypeModel = moduleModel.GetTypes();
|
|
var query = from typeModel in arTypeModel where typeModel.IsClass == true orderby typeModel.Name select typeModel;
|
|
//添加节点
|
|
listBoxModel.Items.Clear();
|
|
List<string> listModelName = new List<string>();
|
|
foreach (Type type in query)
|
|
{
|
|
ListBoxItem item = new ListBoxItem();
|
|
item.Content = type.Name;
|
|
item.Tag = item.Content;
|
|
this.listBoxModel.Items.Add(item);
|
|
|
|
//记录节点列表
|
|
listModelName.Add(type.Name);
|
|
}
|
|
|
|
//加载所有已经存在的节点
|
|
SiaSun.LMS.Common.XmlFiles xmlFile = new SiaSun.LMS.Common.XmlFiles(MainApp.File_FieldDescription_Path);
|
|
XmlNodeList nodeListModel = xmlFile.SelectNodes("Tables/Table");
|
|
foreach (XmlNode xmlNode in nodeListModel)
|
|
{
|
|
//判断是否空值
|
|
if (xmlNode.Attributes.Count == 0)
|
|
{
|
|
xmlNode.RemoveAll();
|
|
continue;
|
|
}
|
|
else
|
|
{
|
|
//判断是否已经存在该节点
|
|
if (!listModelName.Contains(xmlNode.Attributes["Name"].Value))
|
|
{
|
|
ListBoxItem item = new ListBoxItem();
|
|
item.Content = xmlNode.Attributes["Name"].Value;
|
|
item.Tag = item.Content;
|
|
this.listBoxModel.Items.Add(item);
|
|
}
|
|
}
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MainApp._MessageDialog.ShowException(ex);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 选项更改
|
|
/// </summary>
|
|
void listBoxModel_SelectionChanged(object sender, SelectionChangedEventArgs e)
|
|
{
|
|
if (this.listBoxModel.SelectedItem == null)
|
|
return;
|
|
|
|
ListBoxItem item = this.listBoxModel.SelectedItem as ListBoxItem;
|
|
|
|
//显示节点
|
|
this.grpboxConfig.Header = string.Format("{0}-配置项", item.Content);
|
|
|
|
//加载数据
|
|
LoadData(item.Content.ToString());
|
|
}
|
|
|
|
//初始化DataTable
|
|
private DataTable InitDataTable()
|
|
{
|
|
try
|
|
{
|
|
//从实体类中加载属性信息
|
|
Assembly assemblyModel = Assembly.LoadFrom(MainApp._APP_PATH + "SiaSun.LMS.Model.dll");
|
|
if (assemblyModel == null)
|
|
return null;
|
|
Module moduleModel = assemblyModel.ManifestModule;
|
|
Type typeModel = moduleModel.GetType(assemblyModel.GetName().Name + ".FIELD_DESCRIPTION");
|
|
if (typeModel == null)
|
|
return null;
|
|
|
|
//声明datatable并添加列
|
|
tableDescription = new DataTable("FIELD_DESCRIPTION");
|
|
SiaSun.LMS.Model.FIELD_DESCRIPTION mFIELD_DESCRIPTION = new SiaSun.LMS.Model.FIELD_DESCRIPTION();
|
|
foreach (PropertyInfo propertyInfo in typeModel.GetProperties())
|
|
{
|
|
DataColumn column = new DataColumn(propertyInfo.Name, propertyInfo.PropertyType);
|
|
column.DefaultValue = propertyInfo.GetValue(mFIELD_DESCRIPTION, null).ToString();
|
|
tableDescription.Columns.Add(column);
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MainApp._MessageDialog.ShowException(ex);
|
|
}
|
|
return tableDescription;
|
|
}
|
|
|
|
//点击节点，加载并显示数据
|
|
private void LoadData(string TableName)
|
|
{
|
|
try
|
|
{
|
|
MainWindow.mainWin.Cursor = Cursors.Wait;
|
|
|
|
SiaSun.LMS.Common.XmlFiles xmlFile = new SiaSun.LMS.Common.XmlFiles(MainApp.File_FieldDescription_Path);
|
|
XmlNode nodeModel = xmlFile.SelectSingleNode("Tables/Table[@Name='" + TableName + "']");
|
|
//判断XML中是否有该节点，如果没有则根据实体类加载
|
|
if (nodeModel == null)
|
|
{
|
|
//如果XML中没有定义该节点，则从类中加载该描述
|
|
LoadDataTableFromModel(TableName);
|
|
}
|
|
else
|
|
{
|
|
LoadDataTableFromXml(nodeModel, TableName);
|
|
}
|
|
//数据绑定
|
|
DataGrid_Bind(TableName);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MainApp._MessageDialog.ShowException(ex);
|
|
}
|
|
finally
|
|
{
|
|
MainWindow.mainWin.Cursor = Cursors.Arrow;
|
|
}
|
|
}
|
|
|
|
//重新加载数据
|
|
private void LoadDataAgain(string TableName)
|
|
{
|
|
//记载XML信息
|
|
SiaSun.LMS.Common.XmlFiles xmlFile = new SiaSun.LMS.Common.XmlFiles(MainApp.File_FieldDescription_Path);
|
|
XmlNode nodeModel = xmlFile.SelectSingleNode("Tables/Table[@Name='" + TableName + "']");
|
|
|
|
//从XML中加载描述定义
|
|
tableDescription.Rows.Clear();
|
|
try
|
|
{
|
|
Assembly assemblyModel = Assembly.LoadFrom(MainApp._APP_PATH + "SiaSun.LMS.Model.dll");
|
|
if (assemblyModel == null)
|
|
return;
|
|
Module moduleModel = assemblyModel.ManifestModule;
|
|
Type typeModel = moduleModel.GetType(assemblyModel.GetName().Name + "." + TableName);
|
|
if (typeModel == null)
|
|
return;
|
|
//获得所有实体类的属性
|
|
PropertyInfo[] arProperty = typeModel.GetProperties();
|
|
//检查属性和XML中的列是否匹配，检查是否存在新增列
|
|
foreach (PropertyInfo propertyInfo in arProperty)
|
|
{
|
|
//添加新行
|
|
DataRow rowField = tableDescription.NewRow();
|
|
//判断XMl中是否有该列信息
|
|
XmlNode nodeFile = nodeModel.SelectSingleNode(string.Format("Field[@Column='{0}']", propertyInfo.Name));
|
|
if (nodeFile == null)
|
|
{
|
|
rowField["Column"] = propertyInfo.Name;
|
|
rowField["DbType"] = propertyInfo.PropertyType.Name;
|
|
rowField["Header"] = propertyInfo.Name;
|
|
rowField["ControlType"] = "text";
|
|
rowField["DefaultValue"] = "";
|
|
rowField["ReadOnly"] = false;
|
|
rowField["Validation"] = string.Empty;
|
|
rowField["DataBind"] = string.Empty;
|
|
rowField["Remark"] = string.Empty;
|
|
rowField["Order"] = 1;
|
|
rowField["AllowQuery"] = false;
|
|
rowField["QueryOperation"] = string.Empty;
|
|
}
|
|
else
|
|
{
|
|
rowField["Column"] = nodeFile.Attributes["Column"] == null ? string.Empty : nodeFile.Attributes["Column"].Value;
|
|
rowField["DbType"] = nodeFile.Attributes["DbType"] == null ? string.Empty : nodeFile.Attributes["DbType"].Value;
|
|
rowField["Header"] = nodeFile.Attributes["Header"] == null ? string.Empty : nodeFile.Attributes["Header"].Value;
|
|
rowField["ControlType"] = nodeFile.Attributes["ControlType"] == null ? string.Empty : nodeFile.Attributes["ControlType"].Value;
|
|
rowField["DefaultValue"] = nodeFile.Attributes["DefaultValue"] == null ? string.Empty : nodeFile.Attributes["DefaultValue"].Value;
|
|
rowField["ReadOnly"] = nodeFile.Attributes["ReadOnly"] == null ? false : Convert.ToBoolean(int.Parse(nodeFile.Attributes["ReadOnly"].Value));
|
|
rowField["Validation"] = nodeFile.Attributes["Validation"] == null ? string.Empty : nodeFile.Attributes["Validation"].Value;
|
|
rowField["DataBind"] = nodeFile.Attributes["DataBind"] == null ? string.Empty : nodeFile.Attributes["DataBind"].Value;
|
|
rowField["Remark"] = nodeFile.Attributes["Remark"] == null ? string.Empty : nodeFile.Attributes["Remark"].Value;
|
|
rowField["Order"] = nodeFile.Attributes["Order"] == null ? "1" : nodeFile.Attributes["Order"].Value;
|
|
rowField["AllowQuery"] = nodeFile.Attributes["AllowQuery"] == null ? false : Convert.ToBoolean(int.Parse(nodeFile.Attributes["AllowQuery"].Value));
|
|
rowField["QueryOperation"] = nodeFile.Attributes["QueryOperation"] == null ? string.Empty : nodeFile.Attributes["QueryOperation"].Value;
|
|
|
|
}
|
|
tableDescription.Rows.Add(rowField);
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MainApp._MessageDialog.ShowException(ex);
|
|
}
|
|
}
|
|
|
|
//绑定数据并设置显示列信息
|
|
private void DataGrid_Bind(string TableName)
|
|
{
|
|
//设置数据源
|
|
this.gridModel.ItemsSource = tableDescription.DefaultView;
|
|
//设置样式
|
|
this.gridModel.U_TranslateDataGridViewStyle(null, "FIELD_DESCRIPTION", null, true);
|
|
}
|
|
|
|
//从XML中加载数据
|
|
private void LoadDataTableFromXml(XmlNode nodeModel, string TableName)
|
|
{
|
|
//从XML中加载描述定义
|
|
tableDescription.Rows.Clear();
|
|
|
|
foreach (XmlNode nodeFile in nodeModel.SelectNodes("Field"))
|
|
{
|
|
try
|
|
{
|
|
DataRow rowField = tableDescription.NewRow();
|
|
rowField["Column"] = nodeFile.Attributes["Column"] == null ? string.Empty : nodeFile.Attributes["Column"].Value;
|
|
rowField["DbType"] = nodeFile.Attributes["DbType"] == null ? string.Empty : nodeFile.Attributes["DbType"].Value;
|
|
rowField["Header"] = nodeFile.Attributes["Header"] == null ? string.Empty : nodeFile.Attributes["Header"].Value;
|
|
rowField["ControlType"] = nodeFile.Attributes["ControlType"] == null ? string.Empty : nodeFile.Attributes["ControlType"].Value;
|
|
rowField["DefaultValue"] = nodeFile.Attributes["DefaultValue"] == null ? string.Empty : nodeFile.Attributes["DefaultValue"].Value;
|
|
rowField["ReadOnly"] = nodeFile.Attributes["ReadOnly"] == null ? false : Convert.ToBoolean(int.Parse(nodeFile.Attributes["ReadOnly"].Value));
|
|
rowField["Validation"] = nodeFile.Attributes["Validation"] == null ? string.Empty : nodeFile.Attributes["Validation"].Value;
|
|
rowField["DataBind"] = nodeFile.Attributes["DataBind"] == null ? string.Empty : nodeFile.Attributes["DataBind"].Value;
|
|
rowField["Remark"] = nodeFile.Attributes["Remark"] == null ? string.Empty : nodeFile.Attributes["Remark"].Value;
|
|
rowField["Order"] = nodeFile.Attributes["Order"] == null ? "1" : nodeFile.Attributes["Order"].Value;
|
|
rowField["AllowQuery"] = nodeFile.Attributes["AllowQuery"] == null ? false : Convert.ToBoolean(int.Parse(nodeFile.Attributes["AllowQuery"].Value));
|
|
rowField["QueryOperation"] = nodeFile.Attributes["QueryOperation"] == null ? string.Empty : nodeFile.Attributes["QueryOperation"].Value;
|
|
|
|
tableDescription.Rows.Add(rowField);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MainApp._MessageDialog.ShowException(string.Format("节点：{0}.", nodeFile.Attributes["Column"].Value) + ex.Message);
|
|
}
|
|
}
|
|
}
|
|
|
|
//根据Model类生成描述信息
|
|
private void LoadDataTableFromModel(string TableName)
|
|
{
|
|
Assembly assemblyModel = Assembly.LoadFrom(MainApp._APP_PATH + "SiaSun.LMS.Model.dll");
|
|
if (assemblyModel == null)
|
|
return;
|
|
Module moduleModel = assemblyModel.ManifestModule;
|
|
Type typeModel = moduleModel.GetType(assemblyModel.GetName().Name + "." + TableName);
|
|
if (typeModel == null)
|
|
return;
|
|
tableDescription.Rows.Clear();
|
|
try
|
|
{
|
|
//通过反射将该实体类的所有属性加载过来
|
|
int i = 1;
|
|
foreach (PropertyInfo propertyInfo in typeModel.GetProperties())
|
|
{
|
|
//获得属性描述
|
|
DataRow rowField = tableDescription.NewRow();
|
|
rowField["Column"] = propertyInfo.Name;
|
|
rowField["DbType"] = propertyInfo.PropertyType.Name;
|
|
rowField["Header"] = propertyInfo.Name;
|
|
rowField["ControlType"] = "text";
|
|
rowField["DefaultValue"] = "";
|
|
rowField["ReadOnly"] = false;
|
|
rowField["Validation"] = string.Empty;
|
|
rowField["DataBind"] = string.Empty;
|
|
rowField["Remark"] = string.Empty;
|
|
rowField["Order"] = i;
|
|
rowField["AllowQuery"] = false;
|
|
rowField["QueryOperation"] = string.Empty;
|
|
tableDescription.Rows.Add(rowField);
|
|
i++;
|
|
}
|
|
//save xml
|
|
UpdateXml(TableName);
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MainApp._MessageDialog.ShowException(ex);
|
|
}
|
|
}
|
|
|
|
//从数据库中获得该信息
|
|
private void LoadDataTableFromDataBase(XmlNode nodeModel, string TableName)
|
|
{
|
|
try
|
|
{
|
|
//从XML中加载描述定义
|
|
tableDescription.Rows.Clear();
|
|
|
|
//获得XML文件中所有数据
|
|
XmlNodeList xmlNodeList = nodeModel.SelectNodes("Field");
|
|
List<XmlNode> listNodeModel = new List<XmlNode>();
|
|
Dictionary<string, XmlNode> dicXmlNode = new Dictionary<string, XmlNode>();
|
|
foreach (XmlNode xmlNode in xmlNodeList)
|
|
{
|
|
if (xmlNode.Attributes.Count > 0)
|
|
{
|
|
dicXmlNode.Add(xmlNode.Attributes["Column"].Value, xmlNode);
|
|
}
|
|
}
|
|
|
|
string strSql = string.Format("SELECT * FROM {0} WHERE 0=1", TableName);
|
|
DataTable tableModel = MainApp._I_BaseService.GetList(strSql);
|
|
foreach (DataColumn col in tableModel.Columns)
|
|
{
|
|
//判断是否已经存在
|
|
bool blIsExist = dicXmlNode.ContainsKey(col.ColumnName);
|
|
|
|
DataRow rowField = tableDescription.NewRow();
|
|
rowField["Column"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["Column"] == null) ? col.ColumnName : dicXmlNode[col.ColumnName].Attributes["Column"].Value;
|
|
rowField["DbType"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["DbType"] == null) ? "String" : dicXmlNode[col.ColumnName].Attributes["DbType"].Value;
|
|
rowField["Header"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["Header"] == null) ? col.ColumnName : dicXmlNode[col.ColumnName].Attributes["Header"].Value;
|
|
rowField["ControlType"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["ControlType"] == null) ? string.Empty : dicXmlNode[col.ColumnName].Attributes["ControlType"].Value;
|
|
rowField["DefaultValue"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["DefaultValue"] == null) ? string.Empty : dicXmlNode[col.ColumnName].Attributes["DefaultValue"].Value;
|
|
rowField["ReadOnly"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["ReadOnly"] == null) ? false : Convert.ToBoolean(int.Parse(dicXmlNode[col.ColumnName].Attributes["ReadOnly"].Value));
|
|
rowField["Validation"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["Validation"] == null) ? string.Empty : dicXmlNode[col.ColumnName].Attributes["Validation"].Value;
|
|
rowField["DataBind"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["DataBind"] == null) ? string.Empty : dicXmlNode[col.ColumnName].Attributes["DataBind"].Value;
|
|
rowField["Remark"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["Remark"] == null) ? string.Empty : dicXmlNode[col.ColumnName].Attributes["Remark"].Value;
|
|
rowField["Order"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["Order"] == null) ? "1" : dicXmlNode[col.ColumnName].Attributes["Order"].Value;
|
|
rowField["AllowQuery"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["AllowQuery"] == null) ? false : Convert.ToBoolean(int.Parse(dicXmlNode[col.ColumnName].Attributes["AllowQuery"].Value));
|
|
rowField["QueryOperation"] = (!blIsExist || dicXmlNode[col.ColumnName].Attributes["QueryOperation"] == null) ? string.Empty : dicXmlNode[col.ColumnName].Attributes["QueryOperation"].Value;
|
|
tableDescription.Rows.Add(rowField);
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MainApp._MessageDialog.ShowException(ex);
|
|
}
|
|
}
|
|
|
|
//Update XML
|
|
private void UpdateXml(string TableName)
|
|
{
|
|
if (TableName.Length == 0)
|
|
return;
|
|
|
|
SiaSun.LMS.Common.XmlFiles xmlFile = new SiaSun.LMS.Common.XmlFiles(MainApp.File_FieldDescription_Path);
|
|
XmlNode nodeRoot = xmlFile.SelectSingleNode("Tables");
|
|
XmlNode nodeModel = nodeRoot.SelectSingleNode("Table[@Name='" + TableName + "']");
|
|
|
|
//移除所有节点
|
|
if (nodeModel != null)
|
|
{
|
|
foreach (XmlNode node in nodeModel.ChildNodes)
|
|
{
|
|
nodeModel.RemoveChild(node);
|
|
}
|
|
nodeModel.InnerXml = string.Empty;
|
|
}
|
|
|
|
if (nodeModel != null)
|
|
{
|
|
foreach (DataRow rowField in tableDescription.Rows)
|
|
{
|
|
XmlNode nodeField = xmlFile.CreateNode(XmlNodeType.Element, "Field", xmlFile.NamespaceURI);
|
|
nodeModel.AppendChild(nodeField);
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("Column")).Value = rowField["Column"].ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("DbType")).Value = rowField["DbType"].ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("Header")).Value = rowField["Header"].ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("ControlType")).Value = rowField["ControlType"].ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("DefaultValue")).Value = rowField["DefaultValue"].ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("ReadOnly")).Value = Convert.ToInt32(rowField["ReadOnly"]).ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("Validation")).Value = rowField["Validation"].ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("DataBind")).Value = rowField["DataBind"].ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("Remark")).Value = rowField["Remark"].ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("Order")).Value = rowField["Order"].ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("AllowQuery")).Value = Convert.ToInt32(rowField["AllowQuery"]).ToString();
|
|
nodeField.Attributes.Append(xmlFile.CreateAttribute("QueryOperation")).Value = rowField["QueryOperation"].ToString();
|
|
}
|
|
|
|
//移除空值节点
|
|
RemoveEmptyNode(xmlFile, nodeRoot);
|
|
|
|
//提交保存
|
|
xmlFile.Save(MainApp.File_FieldDescription_Path);
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 移除空值的节点
|
|
/// </summary>
|
|
private void RemoveEmptyNode(XmlDocument xmlDoc, XmlNode nodeRoot)
|
|
{
|
|
foreach (XmlNode node in nodeRoot.ChildNodes)
|
|
{
|
|
if (node.Attributes != null && node.Attributes.Count == 0)
|
|
{
|
|
nodeRoot.RemoveChild(node);
|
|
}
|
|
}
|
|
}
|
|
|
|
#region -------工具栏按钮操作
|
|
|
|
/// <summary>
|
|
/// 按钮操作
|
|
/// </summary>
|
|
private void ToolBar_Click(object sender, RoutedEventArgs e)
|
|
{
|
|
Button btn = e.OriginalSource as Button;
|
|
if (btn != null)
|
|
{
|
|
try
|
|
{
|
|
MainWindow.mainWin.Cursor = Cursors.Wait;
|
|
|
|
if (btn == btnLoad)
|
|
{
|
|
this.LoadModelDescription();
|
|
}
|
|
else if (btn == btnAdd)
|
|
{
|
|
this.AddModelDescription();
|
|
}
|
|
else if (btn == btnDelete)
|
|
{
|
|
this.DeleteModelDescription();
|
|
}
|
|
else if (btn == btnSave)
|
|
{
|
|
this.SaveModelDescription();
|
|
}
|
|
else if (btn == btnUpdate)
|
|
{
|
|
this.UpdateModelDescription();
|
|
}
|
|
}
|
|
catch (Exception ex)
|
|
{
|
|
MainApp._MessageDialog.ShowException(ex);
|
|
}
|
|
finally
|
|
{
|
|
MainWindow.mainWin.Cursor = Cursors.Arrow;
|
|
}
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 加载描述
|
|
/// </summary>
|
|
private void LoadModelDescription()
|
|
{
|
|
ListBoxItem itemSelected = this.listBoxModel.SelectedItem as ListBoxItem;
|
|
if (itemSelected == null)
|
|
return;
|
|
|
|
SiaSun.LMS.Common.XmlFiles xmlFile = new SiaSun.LMS.Common.XmlFiles(MainApp.File_FieldDescription_Path);
|
|
XmlNode nodeModel = xmlFile.SelectSingleNode("Tables/Table[@Name='" + itemSelected.Content + "']");
|
|
//从数据库中更新
|
|
LoadDataTableFromDataBase(nodeModel, itemSelected.Content.ToString());
|
|
|
|
//数据绑定
|
|
DataGrid_Bind(itemSelected.Content.ToString());
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加描述
|
|
/// </summary>
|
|
private void AddModelDescription()
|
|
{
|
|
ListBoxItem itemSelected = this.listBoxModel.SelectedItem as ListBoxItem;
|
|
if (itemSelected == null)
|
|
return;
|
|
|
|
DataRow rowNew = tableDescription.NewRow();
|
|
tableDescription.Rows.Add(rowNew);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 删除描述
|
|
/// </summary>
|
|
private void DeleteModelDescription()
|
|
{
|
|
if (MainApp._MessageDialog.ShowDialog("Delete",null) == Sid.Windows.Controls.TaskDialogResult.Ok)
|
|
{
|
|
//遍历所有选定的行
|
|
for (int i = gridModel.SelectedItems.Count - 1;i>=0 ; i--)
|
|
{
|
|
DataRowView viewRow = gridModel.SelectedItems[i] as DataRowView;
|
|
if (viewRow != null)
|
|
{
|
|
viewRow.Delete();
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 保存描述
|
|
/// </summary>
|
|
private void SaveModelDescription()
|
|
{
|
|
ListBoxItem itemSelected = this.listBoxModel.SelectedItem as ListBoxItem;
|
|
if (itemSelected == null)
|
|
return;
|
|
|
|
//结束编辑
|
|
this.gridModel.CommitEdit(DataGridEditingUnit.Row, true);
|
|
UpdateXml(itemSelected.Content.ToString());
|
|
MainApp._MessageDialog.Show(true);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 刷新描述
|
|
/// </summary>
|
|
private void UpdateModelDescription()
|
|
{
|
|
//获得当前选中节点
|
|
ListBoxItem itemSelected = this.listBoxModel.SelectedItem as ListBoxItem;
|
|
if (itemSelected == null)
|
|
return;
|
|
|
|
int intIndex = this.listBoxModel.SelectedIndex;
|
|
|
|
//重新加载
|
|
FIELD_DESCRIPTION_Loaded(null, null);
|
|
|
|
//设置选定项
|
|
this.listBoxModel.SelectedIndex = intIndex;
|
|
|
|
//加载数据
|
|
LoadData(itemSelected.Content.ToString());
|
|
//焦点
|
|
this.listBoxModel.Focus();
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
}
|