private void ModificationValue_Editor_FinishEditing(object sender, AT.STO.UI.Win.DropDownValueChangedEventArgs e)
{
if (ModificationList.ActiveSheet.ActiveRow.Tag == null)
{
ModificationList.ActiveSheet.ActiveRow.Tag = new ExpressionInfo();
}
ExpressionInfo expressionInfo = ModificationList.ActiveSheet.ActiveRow.Tag as ExpressionInfo;
DropDownNode dropDownNode = e.Value as DropDownNode;
expressionInfo.DataValue = dropDownNode.Tag as FieldInfo;
ModificationList.ActiveSheet.Cells[ModificationList.ActiveSheet.ActiveRowIndex, 2].Value = dropDownNode.Tag as FieldInfo;
ModificationValue_Editor.SendToBack();
}
protected void createChildDropDownsRec(Panel parent, DropDownNode ddn)
{
if (ddn.ddl.Items.Count > 0)
{
ddn.ddl.CssClass = "btn btn-default";
DropDownButton ddb = new DropDownButton(ddn.ddl); //a drop-down button is just a button that knows a ddl.
ddb.Text = "Select";
ddb.CssClass = "btn btn-default";
ddb.Click += new EventHandler(ddb_select_OnClick);
parent.Controls.Add(ddn.ddl);
parent.Controls.Add(ddb);
parent.Controls.Add(new LiteralControl("<br />"));
ddn.next = new DropDownNode(ddn.ddl.SelectedValue);
ddn.next.ddl.DataBind();
createChildDropDownsRec(parent, ddn.next);
}
}
private void WriteToTable_Value_Editor_FinishEditing(object sender, AT.STO.UI.Win.DropDownValueChangedEventArgs e)
{
if (ConditionList.ActiveSheet.ActiveRow.Tag == null)
{
ConditionList.ActiveSheet.ActiveRow.Tag = new ExpressionInfo();
}
ExpressionInfo expressionInfo = ConditionList.ActiveSheet.ActiveRow.Tag as ExpressionInfo;
DropDownNode dropDownNode = e.Value as DropDownNode;
if (dropDownNode.Tag is FieldInfo && dropDownNode.Parent != null)
{
ReadFromTableName = dropDownNode.Parent.Name;
}
expressionInfo.DataValue = dropDownNode.Tag as FieldInfo;
ConditionList.ActiveSheet.Cells[ConditionList.ActiveSheet.ActiveRowIndex, 2].Value = dropDownNode.Tag as FieldInfo;
WriteToTable_Value_Editor.SendToBack();
}
//DropDownNode is a class in App_Code. It sets its own sqldatasource and
//sets its own methods. OnSelectedIndexChanged, it updates the lower drop
//down lists
protected void createChildDropDowns(Panel parent, string entity)
{
DropDownNode ddn = new DropDownNode(entity);
ddn.ddl.DataBind();
createChildDropDownsRec(parent, ddn);
}
private TreeNode SearchNode(TreeNodeCollection Nodes, DropDownNode SearchFor)
{
if (SearchFor != null)
{
foreach (DropDownNode node in Nodes)
{
if (node.Id == SearchFor.Id)
{
return node;
}
else
{
TreeNode found = SearchNode(node.Nodes, SearchFor);
if (found != null)
{
return found;
}
}
}
}
return null;
}
private void ComboBoxTreeTree(DropDownNode ParentNode, object ParentID, DataRowView ParentDV, DataTable dt)
{
DataTable temptbl = dt.Copy();
DataView viewinfo = new DataView(temptbl);
viewinfo.RowFilter = temptbl.Columns[2].ColumnName + " = " + ParentID;
foreach (DataRowView drv in viewinfo)
{
DropDownNode node2 = new DropDownNode(Convert.ToInt32(drv[0]), drv[1].ToString());
ParentNode.Nodes.Add(node2);
ComboBoxTreeTree(node2, drv[0], drv, dt);
}
}
/// <summary>
/// ����ֵ������
/// </summary>
/// <param name="value">ֵ</param>
/// <param name="text">Text�������д,��Ȼ�������ʲô��дʲô</param>
public void SelectedByValue(object value, object text)
{
DropDownNodeValue = new DropDownNode(Convert.ToInt32(value), text.ToString());
}
/// <summary>
/// ���Tree
/// </summary>
/// <param name="ParentID">�������</param>
/// <param name="dt">��ʽ�����У�Id,Name,ParentId,ֻҪ˳��һ���Ϳ�����</param>
public void Fill(DataTable dt, object ParentID)
{
DropDownControl.Size = new Size(200, 300);
DataTable temptbl = dt.Copy();
DataView viewinfo = new DataView(temptbl);
viewinfo.RowFilter = temptbl.Columns[2].ColumnName + " = " + ParentID;
DropDownTree tree = DropDownControl;
//DropDownNode root = new DropDownNode(-1, "==��ѡ��==");
//tree.Nodes.Clear();
//tree.Nodes.Add(root);
if (viewinfo.Count > 0)
{
foreach (DataRowView drv in viewinfo)
{
DropDownNode node = new DropDownNode(Convert.ToInt32(drv[0]), drv[1].ToString());
tree.Nodes.Add(node);
ComboBoxTreeTree(node, drv[0], drv, dt);
}
}
if (tree.Nodes.Count > 0)
{
tree.Nodes[0].Expand();
SelectedByValue(viewinfo[0][0], viewinfo[0][1]);
}
//cbxTree.SelectedByValue(1, "==��ѡ��==");
}
/// <summary>
///加载模板中所有表单的数据项值
/// </summary>
/// <param name="Schemas"></param>
public void InitDataItems()
{
foreach (SheetConfiguration Sheet in Module.Sheets)
{
DataTableSchema DataTable = Sheet.DataTableSchema;
TreeView treeView = WriteToTable_Value_Editor.DropDownControl;
treeView.Nodes.Clear();
if (DataTable.Schema != null)
{
TableDefineInfo TableInfo = DataTable.Schema;
DropDownNode Node = new DropDownNode(TableInfo.GetHashCode(), TableInfo.Description);
Node.Name = TableInfo.Name;
treeView.Nodes.Add(Node);
#region 时间戳字段
DropDownNode SubNode = new DropDownNode((int)DateTime.Now.Ticks, "时间戳");
SubNode.Name = "scts";
FieldInfo fieldInfo = new FieldInfo();
fieldInfo.Name = "scts";
fieldInfo.Text = "时间戳";
SubNode.Tag = fieldInfo;
Node.Nodes.Add(SubNode);
#endregion 时间戳字段
foreach (FieldDefineInfo FieldInfo in TableInfo.FieldInfos)
{
if (!ColumnRegular.JudgeColumnName(FieldInfo.Description))
{
SubNode = new DropDownNode(FieldInfo.GetHashCode(), FieldInfo.Description);
SubNode.Name = FieldInfo.FieldName;
fieldInfo = new FieldInfo();
fieldInfo.Name = FieldInfo.FieldName;
fieldInfo.Text = FieldInfo.Description;
SubNode.Tag = fieldInfo;
Node.Nodes.Add(SubNode);
}
}
}
treeView.ExpandAll();
treeView = ModificationValue_Editor.DropDownControl;
treeView.Nodes.Clear();
if (DataTable.Schema != null)
{
TableDefineInfo TableInfo = DataTable.Schema;
DropDownNode Node = new DropDownNode(TableInfo.GetHashCode(), TableInfo.Description);
Node.Name = TableInfo.Name;
treeView.Nodes.Add(Node);
#region 时间戳字段
DropDownNode SubNode = new DropDownNode((int)DateTime.Now.Ticks, "时间戳");
SubNode.Name = "scts";
FieldInfo fieldInfo = new FieldInfo();
fieldInfo.Name = "scts";
fieldInfo.Text = "时间戳";
SubNode.Tag = fieldInfo;
Node.Nodes.Add(SubNode);
#endregion 时间戳字段
foreach (FieldDefineInfo FieldInfo in TableInfo.FieldInfos)
{
if (!ColumnRegular.JudgeColumnName(FieldInfo.Description))
{
SubNode = new DropDownNode(FieldInfo.GetHashCode(), FieldInfo.Description);
SubNode.Name = FieldInfo.FieldName;
fieldInfo = new FieldInfo();
fieldInfo.Name = FieldInfo.FieldName;
fieldInfo.Text = FieldInfo.Description;
SubNode.Tag = fieldInfo;
Node.Nodes.Add(SubNode);
}
}
}
treeView.ExpandAll();
}
}
