void item_SelectedChanged(object sender, RoutedPropertyChangedEventArgs <object> e)
{
TreeViewItem selectedItem = e.NewValue as TreeViewItem;
if (selectedItem != null)
{
MyTreeNode node = selectedItem.Tag as MyTreeNode;
if (node != null)
{
MyTrees.OpenDB();
string nodeDB = MyTrees.GetStringBySysId(node.SysId);
MyTrees.CloseDB();
if (nodeDB != null)
{
myNodeInfo.SetNode(nodeDB);
}
}
}
WindowView.Refresh_Online_time();
}
public static void Export2CSV(MyTreeNode node, string outputfile)
{
ringNodeIds.Clear();
WindowView.notify.SetProcessBarVisible(true);
WindowView.notify.SetStatusMessage("开始导出文件......");
TimingUtil.StartTiming();
StreamWriter mysw = new StreamWriter(outputfile, true, Encoding.Default);
List <string> optCols = MyTrees.GetTableOptCols();
string header = string.Join(",", optCols.ToArray());
header = "会员ID,父级ID,会员姓名,所在层级,下级层数,直接下级会员数,下级会员总数," + header;
mysw.WriteLine(header);
StringBuilder allLines = new StringBuilder();
MyTrees.OpenDB();
row = 2;
allRow = node.ChildrenCountAll + 1;
//导出所有父节点
ExportAllParents2CSV(mysw, allLines, node);
//导出该节点
string nodestr = MyTrees.GetStringBySysId(node.SysId);
mysw.WriteLine(nodestr);
//导出该节点所有子节点
ExportAllChildren2CSV(mysw, allLines, node);
MyTrees.CloseDB();
mysw.Close();
WindowView.notify.SetStatusMessage(TimingUtil.EndTiming());
WindowView.notify.SetProcessBarVisible(false);
}