public string GetSearchSql()
{
searchParams = new List <string>();
StringBuilder sb = new StringBuilder();
AddFilter(sb, "sysid", txtSysid, comboSysid);
AddFilter(sb, "topid", txtTopid, comboTopid);
AddFilter(sb, "name", txtName, comboName);
AddFilter(sb, "level", txtLevel, comboLevel);
AddFilter(sb, "sublevel", txtSubLevels, comboSubLevels);
AddFilter(sb, "subcount", txtSubCount, comboSubCount);
AddFilter(sb, "subcountall", txtAllSubCount, comboAllSubCount);
List <string> optCols = MyTrees.GetTableOptCols();
for (int i = 0; i < optCols.Count; i++)
{
AddFilter(sb, optCols[i], txtCols[i], comboCols[i]);
}
if (sb.Length > 0)
{
return("select sysid,topid,name,level,sublevel,subcount,subcountall from "
+ MyTrees.treeDB.TableName + "_calc where 1=1" + sb + " order by subcountall desc limit 0, 100");
}
else
{
return(null);
}
}
public void InitCols()
{
List <string> tableOptCols = MyTrees.GetTableOptCols();
for (int i = 0; i < tableOptCols.Count; i++)
{
GridViewColumn col = new GridViewColumn();
col.Header = tableOptCols[i];
col.DisplayMemberBinding = new Binding("[" + (i + 7) + "]");
gridView.Columns.Add(col);
}
}
internal void InitCols()
{
addCol("会员ID：");
addCol("父级ID：");
addCol("会员姓名：");
addCol("所在等级：");
addCol("下线层级数：");
addCol("直接下级数：");
addCol("下级总数：");
List <string> optCols = MyTrees.GetTableOptCols();
for (int i = 0; i < optCols.Count; i++)
{
addCol(optCols[i] + "：");
}
}
internal void InitCols()
{
List <string> optCols = MyTrees.GetTableOptCols();
for (int i = 0; i < optCols.Count; i++)
{
mainGrid.RowDefinitions.Add(new RowDefinition());
TextBlock header = new TextBlock();
header.Text = optCols[i];
mainGrid.Children.Add(header);
Grid.SetRow(header, i + 8);
ComboBox comb = new ComboBox();
ComboBoxItem comItem1 = new ComboBoxItem();
comItem1.Content = "等于";
comItem1.IsSelected = true;
comb.Items.Add(comItem1);
ComboBoxItem comItem2 = new ComboBoxItem();
comItem2.Content = "开头";
comb.Items.Add(comItem2);
ComboBoxItem comItem3 = new ComboBoxItem();
comItem3.Content = "结尾";
comb.Items.Add(comItem3);
ComboBoxItem comItem4 = new ComboBoxItem();
comItem4.Content = "包含";
comb.Items.Add(comItem4);
mainGrid.Children.Add(comb);
Grid.SetRow(comb, i + 8);
Grid.SetColumn(comb, 1);
comboCols.Add(comb);
TextBox val = new TextBox();
mainGrid.Children.Add(val);
Grid.SetRow(val, i + 8);
Grid.SetColumn(val, 2);
txtCols.Add(val);
}
}
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);
}
