/// <summary> /// 保存到工作区 /// </summary> /// <param name="checkedNodes">选中的节点</param> public static bool SaveToWorkspace(List <LineBean> checkedNodes) { bool isScud = false; try { foreach (LineBean checkedLb in checkedNodes) { DataTable dt = LineObsBll.Instance.GetDataTable("select obvdate,obvvalue from t_obsrvtntb where OBSLINECODE = '" + checkedLb.OBSLINECODE + "'"); NpoiCreator npcreator = new NpoiCreator(); string savefile = Application.StartupPath + "/远程信息库缓存"; npcreator.TemplateFile = savefile; npcreator.NpoiExcel(dt, checkedLb.OBSLINECODE + ".xls", savefile + "/" + checkedLb.OBSLINECODE + ".xls"); TreeBean tb = new TreeBean(); tb.KeyFieldName = checkedLb.OBSLINECODE; tb.ParentFieldName = checkedLb.SITECODE; tb.Caption = checkedLb.OBSLINENAME; } isScud = true; } catch (Exception ex) { isScud = false; throw new Exception(ex.Message); } return(isScud); }
/// <summary> /// 获取场地选择状态的数据主键ID集合 lwl /// </summary> /// <param name="parentNode">父级节点</param> private void GetSiteCheckedNode(TreeListNode parentNode, ref List <SiteBean> lblist) { if (parentNode.Nodes.Count == 0) { return;//递归终止 } foreach (TreeListNode node in parentNode.Nodes) { if (node.CheckState == CheckState.Checked) { TreeBean nodeInfo = node.TreeList.GetDataRecordByNode(node) as TreeBean; LineBean lb = nodeInfo.Tag as LineBean; if (lb == null) { SiteBean tag = SiteBll.Instance.GetWhere(new { SITECODE = nodeInfo.Tag.ToString() }).ToList()[0]; if (tag != null) { lblist.Add(tag); } } } GetSiteCheckedNode(node, ref lblist); } }
/// <summary> /// 刷新 /// </summary> public void RefreshWorkspace(bool isnewlinename) { try { List <TreeBean> treebData = null; TreeList treelist = this.treeListData; // treelist.Cursor = Cursors.WaitCursor; treebData = treelist.DataSource as List <TreeBean>; List <String> excelList = new List <string>(); excelList = getFile(SystemInfo.DatabaseCache); foreach (string lineCode in excelList) { try { string subLineCode = lineCode.Substring(0, lineCode.Length - 4); TreeBean tb = new TreeBean(); tb.KeyFieldName = subLineCode; string obslinename = isnewlinename ? "OBSLINENAME" : "NAMEBEFORE"; tb.Caption = LineBll.Instance.GetNameByID(obslinename, "OBSLINECODE", subLineCode); string sitecode = LineBll.Instance.GetNameByID("SITECODE", "OBSLINECODE", subLineCode); if (string.IsNullOrEmpty(sitecode)) { continue; } tb.ParentFieldName = sitecode; tb.Tag = LineBll.Instance.GetInfoByID(subLineCode); if (treebData.Find(n => n.KeyFieldName == subLineCode) == null) { treebData.Add(tb); } } catch { continue; } } treelist.RefreshDataSource(); treelist.Cursor = Cursors.Arrow; } catch { } }
private List <TreeBean> GetCheckedNode() { List <TreeBean> tblist = new List <TreeBean>(); foreach (TreeListNode node in this.treeListData.Nodes) { if (node.CheckState == CheckState.Checked) { TreeBean nodeInfo = node.TreeList.GetDataRecordByNode(node) as TreeBean; tblist.Add(nodeInfo); } } return(tblist); }
/// <summary> /// 刷新场地节点 /// </summary> /// <param name="sitecode">场地编码</param> public void RefreshSiteNode(string sitecode) { SiteBean sb = SiteBll.Instance.GetWhere(new { SiteCode = sitecode }).ToList()[0]; List <TreeBean> treeData = this.treeListData.DataSource as List <TreeBean>; TreeBean tb = treeData.Find(n => n.KeyFieldName == sitecode); tb.KeyFieldName = sitecode; tb.ParentFieldName = sb.UnitCode; tb.Caption = sb.SiteName; tb.SiteType = sb.SiteType; tb.Tag = sb.SiteCode; //treeData.Add(tb); treeListData.RefreshDataSource(); }
private void GetSiteNodesRec(TreeListNode parentNode, string keyfieldname, ref List <TreeListNode> lblist) { if (parentNode.Nodes.Count == 0) { return;//递归终止 } foreach (TreeListNode node in parentNode.Nodes) { TreeBean nodeInfo = node.TreeList.GetDataRecordByNode(node) as TreeBean; if (nodeInfo.KeyFieldName == keyfieldname) { lblist.Add(node); } GetSiteNodesRec(node, keyfieldname, ref lblist); } }
/// <summary> /// 获取测线选择状态的数据主键ID集合 lwl /// </summary> /// <param name="parentNode">父级节点</param> private void GetCheckedNode(TreeListNode parentNode, ref List <LineBean> lblist) { if (parentNode.Nodes.Count == 0) { return;//递归终止 } foreach (TreeListNode node in parentNode.Nodes) { if (node.CheckState == CheckState.Checked) { TreeBean nodeInfo = node.TreeList.GetDataRecordByNode(node) as TreeBean; LineBean tag = nodeInfo.Tag as LineBean; if (tag != null) { lblist.Add(tag); } } GetCheckedNode(node, ref lblist); } }
/// <summary> /// 初始化测项树列表 /// </summary> private void InitTree() { List <String> remoteExcelList = new List <string>(); remoteExcelList = getFile(SystemInfo.DatabaseCache); List <TreeBean> tblist = new List <TreeBean>(); foreach (string remoteLineCode in remoteExcelList) { try { string subLineCode = remoteLineCode.Substring(0, remoteLineCode.Length - 4); LineBean ol = LineBll.Instance.GetInfoByID(subLineCode); TreeBean tb = new TreeBean(); tb.KeyFieldName = ol.OBSLINECODE; tb.ParentFieldName = ol.SITECODE; tb.Caption = ol.OBSLINENAME; tb.Tag = ol;//lwl tblist.Add(tb); } catch (Exception ex) { continue; } } this.treeListData.ClearNodes(); this.treeListData.DataSource = tblist; //树列表显示 this.treeListData.KeyFieldName = "KeyFieldName"; //这里绑定的ID的值必须是独一无二的 this.treeListData.ParentFieldName = "ParentFieldName"; //表示使用parentID进行树形绑定 this.treeListData.OptionsView.ShowCheckBoxes = true; this.treeListData.OptionsBehavior.AllowRecursiveNodeChecking = true; this.treeListData.OptionsBehavior.Editable = false; this.treeListData.ExpandAll(); }
/// <summary> /// 加载远程库树列表 /// </summary> /// <param name="gmmkks">GMAP控件</param> public void bSignDbTree() { try { this.treeListData.ClearNodes(); this.treeListData.DataSource = null; List <TreeBean> treeData = new List <TreeBean>(); DataTable ubEnumt = UnitInfoBll.Instance.GetDataTable("select UNITNAME,UNITCODE from t_unittb where HASSITES=1"); foreach (DataRow dr in ubEnumt.Rows) { TreeBean tb = new TreeBean(); tb.TreeName = treeListData.Name; tb.KeyFieldName = dr["UNITCODE"].ToString(); tb.ParentFieldName = "0"; tb.Caption = dr["UNITNAME"].ToString(); tb.SiteType = ""; tb.LineStatus = ""; tb.Tag = new UnitInfoBean { UnitName = dr["UNITNAME"].ToString(), UnitCode = dr["UNITCODE"].ToString(), HASSITES = 1 }; //lwl treeData.Add(tb); } List <SiteBean> sbEnumt = new List <SiteBean>(); DataTable sitedt = SiteBll.Instance.GetDataTable(@"select sitecode, unitcode,sitename from t_siteinfodb"); foreach (DataRow sitedr in sitedt.Rows) { SiteBean sgsb = new SiteBean(); sgsb.SiteCode = sitedr["sitecode"].ToString(); sgsb.SiteName = sitedr["sitename"].ToString(); sgsb.UnitCode = sitedr["unitcode"].ToString(); sbEnumt.Add(sgsb); } //场地列表显示 List <string> olSiteCode = new List <string>(); foreach (SiteBean sb in sbEnumt) { olSiteCode.Add(sb.SiteCode); TreeBean tb = new TreeBean(); tb.KeyFieldName = sb.SiteCode; tb.ParentFieldName = sb.UnitCode; tb.Caption = sb.SiteName; tb.SiteType = sb.SiteType; tb.Tag = sb.SiteCode;//lwl treeData.Add(tb); } //树列表显示 this.treeListData.KeyFieldName = "KeyFieldName"; //这里绑定的ID的值必须是独一无二的 this.treeListData.ParentFieldName = "ParentFieldName"; //表示使用parentID进行树形绑定 this.treeListData.DataSource = treeData; //绑定数据源 this.treeListData.OptionsView.ShowCheckBoxes = true; this.treeListData.OptionsBehavior.AllowRecursiveNodeChecking = true; this.treeListData.OptionsBehavior.Editable = false; } catch (Exception ex) { XtraMessageBox.Show(ex.Message, "错误"); } }
/// <summary> /// 加载测项合并数列表 /// </summary> /// <returns></returns> public List <TreeBean> ObslineMergeTree() { List <TreeBean> tblist = new List <TreeBean>(); try { IEnumerable <UnitInfoBean> ubEnumt = UnitInfoBll.Instance.GetAll(); foreach (UnitInfoBean sb in ubEnumt) { TreeBean tb = new TreeBean(); if (sb.UnitCode == "152002" || sb.UnitCode == "152003" || sb.UnitCode == "152006" || sb.UnitCode == "152008" || sb.UnitCode == "152009" || sb.UnitCode == "152010" || sb.UnitCode == "152012" || sb.UnitCode == "152015" || sb.UnitCode == "152022" || sb.UnitCode == "152023" || sb.UnitCode == "152026" || sb.UnitCode == "152029" || sb.UnitCode == "152032" || sb.UnitCode == "152034" || sb.UnitCode == "152035" || sb.UnitCode == "152036" || sb.UnitCode == "152039" || sb.UnitCode == "152040" || sb.UnitCode == "152041" || sb.UnitCode == "152042" || sb.UnitCode == "152043" || sb.UnitCode == "152044" || sb.UnitCode == "152045" || sb.UnitCode == "152046" || sb.UnitCode == "152001" || sb.UnitCode == "152047") { continue; } tb.KeyFieldName = sb.UnitCode; tb.ParentFieldName = "0"; tb.Caption = sb.UnitName; tb.SiteType = ""; tb.LineStatus = ""; tb.Tag = sb;//lwl tblist.Add(tb); } List <SiteBean> sbEnumt = new List <SiteBean>(); DataTable dt = SiteBll.Instance.GetDataTable(@"select sitecode, unitcode,sitename from t_siteinfodb"); foreach (DataRow dr in dt.Rows) { SiteBean sgsb = new SiteBean(); sgsb.SiteCode = dr["sitecode"].ToString(); sgsb.SiteName = dr["sitename"].ToString(); sgsb.UnitCode = dr["unitcode"].ToString(); sbEnumt.Add(sgsb); } //场地列表显示 List <string> olSiteCode = new List <string>(); foreach (SiteBean sb in sbEnumt) { olSiteCode.Add(sb.SiteCode); TreeBean tb = new TreeBean(); tb.KeyFieldName = sb.SiteCode; tb.ParentFieldName = sb.UnitCode; tb.Caption = sb.SiteName; tb.SiteType = sb.SiteCode.Substring(0, 1) == "L" ? "流动" : "定点"; tb.Tag = sb.SiteCode;//lwl tblist.Add(tb); } List <String> remoteExcelList = new List <string>(); remoteExcelList = getFile(SystemInfo.DatabaseCache); foreach (string remoteLineCode in remoteExcelList) { string subLineCode = remoteLineCode.Substring(0, remoteLineCode.Length - 4); LineBean ol = LineBll.Instance.GetInfoByID(subLineCode); if (olSiteCode.Contains(ol.SITECODE)) { TreeBean tb = new TreeBean(); tb.KeyFieldName = ol.OBSLINECODE; tb.ParentFieldName = ol.SITECODE; tb.Caption = ol.OBSLINENAME; tb.Tag = ol;//lwl tblist.Add(tb); } } } catch { //throw new Exception(ex.Message); } return(tblist); }