public AddVirtualField(string tablename, ModelEdit parent, paraMetaInfo param)
{
InitializeComponent();
TableName_comboBox.Left = edit_TableName.Left;
TableName_comboBox.Top = edit_TableName.Top;
FieldName_comboBox.Left = edit_FieldName.Left;
FieldName_comboBox.Top = edit_FieldName.Top;
m_parent = parent;
m_paramMetaInfo = param;
if (param.m_nFieldType != 1)
{
TableName_comboBox.Visible = false;
TableName_comboBox.Enabled = false;
edit_TableName.Visible = true;
edit_TableName.Enabled = false;
edit_TableName.Text = tablename;
FieldName_comboBox.Visible = true;
FieldName_comboBox.Enabled = true;
edit_FieldName.Visible = false;
edit_FieldName.Enabled = false;
FieldName_comboBox.Items.Clear();
//DataTable table = m_parent.QueryData("SELECT * FROM " + tablename);
DataTable table = Helper.GetDataTableProxy(tablename, m_parent.m_conn);
FieldName_comboBox.Items.Clear();
for (int i = 0; i < table.Columns.Count; i++)
{
string strColumnName = table.Columns[i].ColumnName;
FieldName_comboBox.Items.AddRange(new object[] { strColumnName });
}
// 设置光标位置
FieldName_comboBox.Select();
}
else
{
TableName_comboBox.Visible = true;
TableName_comboBox.Enabled = true;
edit_TableName.Visible = false;
edit_TableName.Enabled = false;
FieldName_comboBox.Visible = false;
FieldName_comboBox.Enabled = false;
edit_FieldName.Visible = true;
edit_FieldName.Enabled = true;
FieldName_comboBox.Items.Clear();
//DataTable table = m_parent.QueryData("SELECT name FROM sysobjects WHERE xtype = 'u' order by name asc");
DataTable table = Helper.GetDataTableProxy("sysobjects", "xtype = 'u'", "name asc", m_parent.m_conn);
foreach (DataRow row in table.Rows)
{
TableName_comboBox.Items.Add(row["name"].ToString().Trim());
}
// 设置光标位置
TableName_comboBox.Select();
}
}
public AddVirtualField(string tablename, ModelEdit parent, paraMetaInfo param)
{
InitializeComponent();
TableName_comboBox.Left = edit_TableName.Left;
TableName_comboBox.Top = edit_TableName.Top;
FieldName_comboBox.Left = edit_FieldName.Left;
FieldName_comboBox.Top = edit_FieldName.Top;
m_parent = parent;
m_paramMetaInfo = param;
if (param.m_nFieldType != 1)
{
TableName_comboBox.Visible = false;
TableName_comboBox.Enabled = false;
edit_TableName.Visible = true;
edit_TableName.Enabled = false;
edit_TableName.Text = tablename;
FieldName_comboBox.Visible = true;
FieldName_comboBox.Enabled = true;
edit_FieldName.Visible = false;
edit_FieldName.Enabled = false;
FieldName_comboBox.Items.Clear();
//DataTable table = m_parent.QueryData("SELECT * FROM " + tablename);
DataTable table = Helper.GetDataTableProxy(tablename, m_parent.m_conn);
FieldName_comboBox.Items.Clear();
for (int i = 0; i < table.Columns.Count; i++)
{
string strColumnName = table.Columns[i].ColumnName;
FieldName_comboBox.Items.AddRange(new object[] { strColumnName });
}
// 设置光标位置
FieldName_comboBox.Select();
}
else
{
TableName_comboBox.Visible = true;
TableName_comboBox.Enabled = true;
edit_TableName.Visible = false;
edit_TableName.Enabled = false;
FieldName_comboBox.Visible = false;
FieldName_comboBox.Enabled = false;
edit_FieldName.Visible = true;
edit_FieldName.Enabled = true;
FieldName_comboBox.Items.Clear();
//DataTable table = m_parent.QueryData("SELECT name FROM sysobjects WHERE xtype = 'u' order by name asc");
DataTable table = Helper.GetDataTableProxy("sysobjects", "xtype = 'u'", "name asc", m_parent.m_conn);
foreach (DataRow row in table.Rows)
{
TableName_comboBox.Items.Add(row["name"].ToString().Trim());
}
// 设置光标位置
TableName_comboBox.Select();
}
}
public addField(string tbl_name, string type, MetainfoEditorForm parent, paraMetaInfo param)
{
InitializeComponent();
m_parent = parent;
m_paramMetaInfo = param;
edit_TableName.Text = tbl_name;
m_adp = new SqlDataAdapter("SELECT * FROM " + edit_TableName.Text, m_parent.m_conn);
combo_DataType.Items.AddRange(new object[] { "文本",
"浮点数" });
switch (type)
{
default:
combo_DataType.Text = "文本";
break;
}
}
public addField(string tbl_name, string type, MetainfoEditorForm parent, paraMetaInfo param)
{
InitializeComponent();
m_parent = parent;
m_paramMetaInfo = param;
edit_TableName.Text = tbl_name;
m_adp = new SqlDataAdapter("SELECT * FROM " + edit_TableName.Text, m_parent.m_conn);
combo_DataType.Items.AddRange(new object[] { "文本",
"浮点数"
});
switch (type)
{
default:
combo_DataType.Text = "文本";
break;
}
}
private void addField_button_Click(object sender, EventArgs e)
{
paraMetaInfo param = new paraMetaInfo();
param.m_strEditType = EditorTypeEn[editortype_comboBox.SelectedIndex];
param.m_strFieldNameCN = fieldcnnametxt.Text.Trim();
param.m_strCatName = catname_comboBox.Text.Trim();
param.m_strDescription = descriptiontxt.Text.Trim();
param.m_bVisible = visible_checkBox.Checked;
param.m_bReadOnly = readonly_checkBox.Checked;
switch (EditorTypeEn[editortype_comboBox.SelectedIndex])
{
case "filename":
param.m_strRelativePath = txtBoxRelativePath.Text.Trim();
break;
case "lookupcombo":
param.m_strListTable = listtable_comboBox.Text.Trim();
param.m_strKeyField = keyfield_comboBox.Text.Trim();
param.m_strListField = listfield_comboBox.Text.Trim();
param.m_strCondition = listconditiontxt.Text.Trim();
break;
case "textcombo":
param.m_strTextCombo = txtBoxListValues.Text.Trim();
break;
default:
break;
}
addField form = new addField(tablename_comboBox.Text, editortype_comboBox.Text, this, param);
DialogResult result = form.ShowDialog();
if (result == DialogResult.OK)
{
RefreshFieldname_ListBox();
DataGridViewShow();
}
}
private void addField_button_Click(object sender, EventArgs e)
{
paraMetaInfo param = new paraMetaInfo();
param.m_strEditType = EditorTypeEn[editortype_comboBox.SelectedIndex];
param.m_strFieldNameCN = fieldcnnametxt.Text.Trim();
param.m_strCatName = catname_comboBox.Text.Trim();
param.m_strDescription = descriptiontxt.Text.Trim();
param.m_bVisible = visible_checkBox.Checked;
param.m_bReadOnly = readonly_checkBox.Checked;
switch (EditorTypeEn[editortype_comboBox.SelectedIndex])
{
case "filename":
param.m_strRelativePath = txtBoxRelativePath.Text.Trim();
break;
case "lookupcombo":
param.m_strListTable = listtable_comboBox.Text.Trim();
param.m_strKeyField = keyfield_comboBox.Text.Trim();
param.m_strListField = listfield_comboBox.Text.Trim();
param.m_strCondition = listconditiontxt.Text.Trim();
break;
case "textcombo":
param.m_strTextCombo = txtBoxListValues.Text.Trim();
break;
default:
break;
}
addField form = new addField(tablename_comboBox.Text, editortype_comboBox.Text, this, param);
DialogResult result = form.ShowDialog();
if (result == DialogResult.OK)
{
RefreshFieldname_ListBox();
DataGridViewShow();
}
}
// 子字段那层的新建虚拟字段按钮
private void CreateVirtualField2_buttom_Click(object sender, EventArgs e)
{
if (treeView.SelectedNode != null)
{
if (treeView.SelectedNode.Level <= 2)
return;
int nFieldID = (int)treeView.SelectedNode.Tag;
DataRow row = m_DicMetaInfoTable.Rows.Find(new object[] { nFieldID });
if (row == null)
return;
paraMetaInfo param = new paraMetaInfo();
param.m_nFieldType = 1;
param.m_nModTableID = (int)row["modtabid"];
param.m_nParentField = (int)treeView.SelectedNode.Tag;
param.m_DicMetaInfo = m_DicMetaInfoTable;
AddVirtualField form = new AddVirtualField(null, this, param);
DialogResult result = form.ShowDialog();
if (result == DialogResult.OK)
{
if (row["fieldtype"] != null && row["fieldtype"].ToString().Trim() != "2")
{
DataRow modRow = m_DicMetaInfoTable.Rows.Find(new object[] { nFieldID });
if (modRow["fieldtype"].ToString().Trim() == "1")
return;
modRow.BeginEdit();
modRow["fieldtype"] = 2;
modRow.EndEdit();
UpdateData("SELECT * FROM sys_meta_info", m_DicMetaInfoTable, UpdateType.MOD);
}
}
}
}
private void CreateSubAttib_buttom_Click(object sender, EventArgs e)
{
if (treeView.SelectedNode != null)
{
// 检查所选的叶子节点是否为虚拟字段
DataRow row = m_DicMetaInfoTable.Rows.Find(new object[]{treeView.SelectedNode.Tag});
if (row == null)
return;
if ((int)row["fieldtype"] != 1)
return;
// 设置parentid,
paraMetaInfo param = new paraMetaInfo();
param.m_nFieldType = 0;
param.m_nModTableID = (int)row["modtabid"];
param.m_nParentField = (int)treeView.SelectedNode.Tag;
param.m_DicMetaInfo = m_DicMetaInfoTable;
AddVirtualField form = new AddVirtualField(row["tablename"].ToString().Trim(), this, param);
DialogResult result = form.ShowDialog();
}
}
// 标签那层的新建虚拟字段按钮
private void CreatVirtualField_buttom_Click(object sender, EventArgs e)
{
if (treeView.SelectedNode != null)
{
TreeNode tabNode = treeView.SelectedNode;
string strTableName = tabNode.Tag.ToString().Trim();
if (strTableName == "")
{
MessageBox.Show("请先为标签指定主表!");
return;
}
// 标签页那层以下才能建虚拟字段
if (treeView.SelectedNode.Level != 2)
return;
DataRow row = m_ModelTabDefTable.Rows.Find(tabNode.Text.Trim());
if (row == null)
return;
paraMetaInfo param = new paraMetaInfo();
param.m_nFieldType = 1;
param.m_nModTableID = (int)row["modtabid"];
param.m_DicMetaInfo = m_DicMetaInfoTable;
AddVirtualField form = new AddVirtualField(null, this, param);
form.ShowDialog();
}
}