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); }