private List <Treeview> GetMenuList(DataTable dtSource) { List <Treeview> rst = new List <Treeview>(); DataRow[] pArr = dtSource.Select("(parent_no='0' or parent_no='')", "ordno,menu_no"); foreach (DataRow dr in pArr) { Treeview pTr = new Treeview(); pTr.id = CommFunc.ConvertDBNullToString(dr["prog_id"]); pTr.text = CommFunc.ConvertDBNullToString(dr["descr"]); pTr.attributes = CommFunc.ConvertDBNullToInt32(dr["disabled"]); pTr.nodes = new List <Treeview>(); this.GetMenuList(ref dtSource, ref pTr, CommFunc.ConvertDBNullToString(dr["menu_no"])); rst.Add(pTr); } return(rst); }
public List <Treeview> GetTreeListForAttrSet(string AttributeSetID) { List <Treeview> TreeListData = null; try { using (SqlConnection con = _databaseFactory.GetDBConnection()) { using (SqlCommand cmd = new SqlCommand()) { if (con.State == ConnectionState.Closed) { con.Open(); } cmd.Connection = con; cmd.CommandText = "[GetAttributesforTreeUsingAttributeSet]"; cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ID", SqlDbType.Int).Value = int.Parse(AttributeSetID); using (SqlDataReader sdr = cmd.ExecuteReader()) { if ((sdr != null) && (sdr.HasRows)) { TreeListData = new List <Treeview>(); while (sdr.Read()) { Treeview TreeviewObj = new Treeview(); { TreeviewObj.ID = sdr["ID"].ToString(); TreeviewObj.ParentID = (sdr["ParentID"].ToString() != "" ? int.Parse(sdr["ParentID"].ToString()) : TreeviewObj.ParentID); TreeviewObj.Name = sdr["Name"].ToString(); TreeviewObj.level = sdr["level"].ToString(); TreeviewObj.icon = sdr["icon"].ToString(); } TreeListData.Add(TreeviewObj); } } } } } } catch (Exception ex) { throw ex; } return(TreeListData); }
private void RenderPlaceholderRecomendations() { var listOfSelectedRenderings = new List <Item>(); if (HttpContext.Current.Request.Form["__EVENTTARGET"] != null) { if (Treeview != null && HttpContext.Current.Request.Form["__EVENTTARGET"] == Treeview.ID) { if (Treeview.SelectedIDs.Any(q => !String.IsNullOrWhiteSpace(q))) { var selected = Treeview.GetSelectedItems(); if (selected != null) { var selectedrendering = selected.FirstOrDefault(); if (selectedrendering != null) { listOfSelectedRenderings.Add(selectedrendering); } } } } if (RecommendedTreeview != null && HttpContext.Current.Request.Form["__EVENTTARGET"] == RecommendedTreeview.ID) { var rrSelected = RecommendedTreeview.GetSelectionItem(); if (rrSelected != null) { var selectedrendering = rrSelected.FirstOrDefault(); if (selectedrendering != null) { listOfSelectedRenderings.Add(selectedrendering); } } } if (listOfSelectedRenderings.Any()) { RenderPlaceholderRecomendations(listOfSelectedRenderings.First()); } else { RecommendedPlaceholders.InnerHtml = String.Empty; } } }
private List <Treeview> GetPduTree(DataTable dtSource) { List <Treeview> rst = new List <Treeview>(); DataRow[] pArr = dtSource.Select("Parent_id=0", "Co_id"); foreach (DataRow dr in pArr) { Treeview pTr = new Treeview(); pTr.id = CommFunc.ConvertDBNullToString(dr["Co_id"]); pTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]); //pTr.attributes = CommFunc.ConvertDBNullToInt32(dr["power"]); pTr.nodes = new List <Treeview>(); this.GetPduTree(ref dtSource, ref pTr, CommFunc.ConvertDBNullToString(dr["Co_id"])); rst.Add(pTr); } return(rst); }
private List <Treeview> GetAreaTreeList(DataTable dtSource) { List <Treeview> rst = new List <Treeview>(); DataRow[] pArr = dtSource.Select("Parent_id=0", "Co_id"); foreach (DataRow dr in pArr) { int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]); Treeview pTr = new Treeview(); pTr.id = co_id.ToString(); pTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]); pTr.attributes = 0; //;new { areaId = co_id, attrib = CoAttrib.Area, parent_id = 0 }; this.GetAreaTreeList(co_id, ref pTr, ref dtSource); rst.Add(pTr); } return(rst); }
private List <Treeview> GetMenuList2(DataTable dtSource, string power) { List <Treeview> rst = new List <Treeview>(); DataRow[] pArr = dtSource.Select("Parent_id=0", "CoNo"); string[] powers = power.Split(','); foreach (DataRow dr in pArr) { Treeview pTr = new Treeview(); pTr.id = CommFunc.ConvertDBNullToString(dr["Co_id"]); pTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]); pTr.attributes = powers.ToList().Exists(p => p.Trim().Equals(pTr.id)); pTr.nodes = new List <Treeview>(); this.GetMenuList2(ref dtSource, ref pTr, CommFunc.ConvertDBNullToString(dr["Co_id"]), ref powers); rst.Add(pTr); } return(rst); }
private void GetMenuList(ref DataTable dtSource, ref Treeview pTr, string Co_id) { DataRow[] pArr = dtSource.Select("Parent_id=" + Co_id, "Co_id"); int pRows = pArr.Count(); if (pRows > 0) { pTr.nodes = new List <Treeview>(); } foreach (DataRow dr in pArr) { Treeview cTr = new Treeview(); cTr.id = CommFunc.ConvertDBNullToString(dr["Co_id"]); cTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]); //cTr.attributes = CommFunc.ConvertDBNullToInt32(dr["power"]); pTr.nodes.Add(cTr); this.GetMenuList(ref dtSource, ref cTr, CommFunc.ConvertDBNullToString(dr["Co_id"])); } }
private void GetMenuList2(ref DataTable dtSource, ref Treeview pTr, string Bd_id, ref string[] powers) { DataRow[] pArr = dtSource.Select("Parent_id=" + Bd_id, "CoNo"); int pRows = pArr.Count(); if (pRows > 0) { pTr.nodes = new List <Treeview>(); } foreach (DataRow dr in pArr) { Treeview cTr = new Treeview(); cTr.id = CommFunc.ConvertDBNullToString(dr["Co_id"]); cTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]); cTr.attributes = powers.ToList().Exists(p => p.Trim().Equals(cTr.id)); pTr.nodes.Add(cTr); this.GetMenuList2(ref dtSource, ref cTr, CommFunc.ConvertDBNullToString(dr["Co_id"]), ref powers); } }
static Treeview LoadTreeview(Stream fs) { var obj = new Treeview(ReadString(fs), ReadFont(fs), ReadInt(fs), ReadInt(fs), ReadInt(fs), ReadInt(fs)) { Enabled = ReadBool(fs), Visible = ReadBool(fs), SelectedTextColor = ReadColor(fs), TextColor = ReadColor(fs) }; var len = ReadInt(fs); for (var i = 0; i < len; i++) { obj.AddNode(LoadTreeviewNode(fs)); } return(obj); }
private void GetMenuList(ref DataTable dtSource, ref Treeview pTr, string menu_no) { DataRow[] pArr = dtSource.Select("parent_no='" + menu_no + "'", "menu_no"); int pRows = pArr.Count(); if (pRows > 0) { pTr.nodes = new List <Treeview>(); } foreach (DataRow dr in pArr) { Treeview cTr = new Treeview(); cTr.id = CommFunc.ConvertDBNullToString(dr["prog_id"]); cTr.text = CommFunc.ConvertDBNullToString(dr["descr"]); cTr.attributes = CommFunc.ConvertDBNullToInt32(dr["power"]); pTr.nodes.Add(cTr); this.GetMenuList(ref dtSource, ref cTr, CommFunc.ConvertDBNullToString(dr["menu_no"])); } }
private void TreeView1_DragDrop(object sender, DragEventArgs e) { var rowToMove = e.Data.GetData(typeof(DataGridViewRow)) as DataGridViewRow; var itemnumber = Convert.ToString(rowToMove.Cells[0].Value); if (itemnumber == assynotxt.Text) { MessageBox.Show("Cannot add parent item as child", "SPM Conect", MessageBoxButtons.OK, MessageBoxIcon.Information); itemnotxt.Clear(); return; } var description = Convert.ToString(rowToMove.Cells[1].Value); var family = Convert.ToString(rowToMove.Cells[2].Value); var oem = Convert.ToString(rowToMove.Cells[3].Value); var oemitem = Convert.ToString(rowToMove.Cells[4].Value); SearchNodes(itemnumber, Treeview.Nodes[0]); if (itemexists != "yes") { bool isrevised = IsRevised(); var child = new TreeNode { Text = itemnumber + " - " + description + " (1)", Tag = itemnumber + "][" + description + "][" + family + "][" + oem + "][" + oemitem + "][1][ ][" + (isrevised ? "1" : "0") + "][0" }; child.BackColor = isrevised ? Color.LightYellow : Color.LightGreen; root.Nodes.Add(child); CallRecursive(); if (!root.IsExpanded) { Treeview.ExpandAll(); } savbttn.Visible = true; } else { itemexists = null; } }
/// <summary> /// 双击treeview /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tview_NodeMouseDoubleClick(object sender, TreeNodeMouseClickEventArgs e) { TreeNode node = Treeview.SelectedNode; if (node.Level == 0) { node.Nodes.Clear(); getServers(); Treeview.ExpandAll(); } else if (node.Level == 1) { node.Nodes.Clear(); getDatabaseinfo(); } else if (node.Level == 4) { if (null != newcontentForm) { Connection conModel = _ConnectList.Find(delegate(Connection con) { return(con.ID.ToString().Equals(Treeview.SelectedNode.Parent.Parent.Parent.Tag.ToString())); }); if (conModel.DbType.Equals(DatabaseType.MongoDB.ToString())) { //todo MongoDBTool.Connect(conModel.ConnectionString).GetList(node.Parent.Parent.Text, node.Text, "{\"find\":\"Account\", limit:20, sort:{AddTime:-1}}"); } else { conConnectionString = Treeview.SelectedNode.Parent.Parent.Tag.ToString(); try { conModel.TableName = Treeview.SelectedNode.Text; conModel.Database = Treeview.SelectedNode.Parent.Parent.Text; conModel.IsView = Treeview.SelectedNode.Tag.ToString().Equals("V"); newcontentForm?.Invoke(conModel); } catch { } } } } }
private void GetAreaTreeList(int parent_id, ref Treeview pTr, ref DataTable dtSource) { DataRow[] pArr = dtSource.Select("Parent_id=" + parent_id, "Co_id"); int pRows = pArr.Count(); if (pRows > 0) { pTr.nodes = new List <Treeview>(); } foreach (DataRow dr in pArr) { int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]); Treeview cTr = new Treeview(); cTr.id = co_id.ToString(); cTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]); cTr.attributes = parent_id; // new { areaId = co_id, attrib = CoAttrib.Area, parent_id = parent_id }; pTr.nodes.Add(cTr); this.GetAreaTreeList(co_id, ref cTr, ref dtSource); } }
public void FindPrevious() { if (SearchedItems != null && SearchedItems.Count > 0) { if (matchindex - 1 < SearchedItems.Count && matchindex != 0) { ApplyInline(SearchedItems[matchindex], false); ApplyInline(SearchedItems[matchindex - 1], true); Treeview.BringIntoView(SearchedItems[matchindex - 1]); matchindex--; } else { ApplyInline(SearchedItems[matchindex], false); matchindex = SearchedItems.Count - 1; ApplyInline(SearchedItems[matchindex], true); Treeview.BringIntoView(SearchedItems[matchindex]); } } }
public void FindNext() { if (SearchedItems != null && SearchedItems.Count > 0) { ApplyInline(SearchedItems[matchindex], false); if (matchindex + 1 < SearchedItems.Count) { ApplyInline(SearchedItems[matchindex + 1], true); Treeview.BringIntoView(SearchedItems[matchindex + 1]); matchindex++; } else { ApplyInline(SearchedItems[matchindex], false); matchindex = 0; ApplyInline(SearchedItems[0], true); Treeview.BringIntoView(SearchedItems[0]); } } }
public ActionResult Create([Bind(Include = "Id,Name")] Base @base) { if (ModelState.IsValid) { db.Bases.Add(@base); db.SaveChanges(); var treeview = new Treeview { Label = @base.Name, HierarchyTypeId = (int)Enums.Base, KeyOfThatHierarchy = @base.Id }; treeview = db.Treeviews.Add(treeview); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(@base)); }
/// <summary> /// Handles a click on the OK button. /// </summary> /// <param name="sender"/><param name="args"/> /// <remarks> /// When the user clicks OK, the dialog is closed by calling /// the <see cref="M:Sitecore.Web.UI.Sheer.ClientResponse.CloseWindow">CloseWindow</see> method. /// </remarks> /// <contract><requires name="sender" condition="not null"/><requires name="args" condition="not null"/></contract> protected override void OnOK(object sender, EventArgs args) { Assert.ArgumentNotNull(sender, "sender"); Assert.ArgumentNotNull((object)args, "args"); if (!string.IsNullOrEmpty(SelectedItemId)) { SetDialogResult(ShortID.Parse(SelectedItemId).ToID().ToString()); } else { Item selectionItem = Treeview.GetSelectionItem(); if (selectionItem != null && IsItemRendering(selectionItem)) { SetDialogResult(selectionItem.ID.ToString()); } else { SheerResponse.Alert("Please select a rendering item", new string[0]); } } }
private static void ReturnSelection(Treeview tv1, Textbox txt1) { if (tv1.Nodes != null) { if (tv1.SelectedNode == null) { tv1.SelectedNode = tv1.Nodes[0]; } _inputResult = Strings.NormalizeDirectory((string)tv1.SelectedNode.Tag) + txt1.Text; if (_checkExist && File.Exists(_inputResult)) { //_prompt = "Are you sure you wish to overwrite '" + _inputResult + "'?"; new Thread(DoCheck).Start(); return; } } _activeBlock.Set(); }
private List <Treeview> GetMenuTreeList(DataTable dtSource) { List <Treeview> rst = new List <Treeview>(); DataRow[] pArr = dtSource.Select("(parent_no='0' or parent_no='') and attrib=0", "ordno,menu_no"); foreach (DataRow dr in pArr) { Treeview pTr = new Treeview(); pTr.id = CommFunc.ConvertDBNullToString(dr["menu_no"]); pTr.text = CommFunc.ConvertDBNullToString(dr["descr"]); pTr.icon = CommFunc.ConvertDBNullToString(dr["icon"]); string child = this.GetPower(pTr.id, ref dtSource); int isShow = (CommFunc.ConvertDBNullToInt32(dr["pass"]) > 0 ? 1 : 0); pTr.nodes = new List <Treeview>(); int cc = this.GetMenuTreeList(ref dtSource, ref pTr); isShow = cc == 1 ? 1 : isShow; pTr.attributes = new { path = CommFunc.ConvertDBNullToString(dr["path"]), power = CommFunc.ConvertDBNullToString(dr["Power"]), show = isShow, child = child }; rst.Add(pTr); } return(rst); }
private void ProcessSaveButton() { Treeview.SelectedNode = Treeview.Nodes[0]; if (Treeview.SelectedNode != null && Treeview.SelectedNode.Parent == null) { Treeview.PathSeparator = "."; // Get the count of the child tree nodes contained in the SelectedNode. var myNodeCount = Treeview.SelectedNode.GetNodeCount(true); // MessageBox.Show(myNodeCount.ToString()); _ = (decimal)myNodeCount / (decimal)Treeview.GetNodeCount(true) * 100; if (myNodeCount > 0) { connectapi.Deleteassy(releaseLogNumber); if (Itemstodiscard.Count > 0) { Performdiscarditem(); } CheckItems(); if (itemcleartosave) { AddItems(); } } else { connectapi.Deleteassy(releaseLogNumber); if (Itemstodiscard.Count > 0) { Performdiscarditem(); } Lockdownsave(); // MessageBox.Show("Assembly list cannot be empty in order to save to AutoCad Catalog.", "SPM Connect", MessageBoxButtons.OK, MessageBoxIcon.Stop); } } Itemstodiscard.Clear(); }
private void Fillrootnode() { try { Treeview.Nodes.Clear(); RemoveChildNodes(root); Treeview.ResetText(); root.Text = assydesctxt.Text + " - " + releasetypetxt.Text; root.Tag = jobnotxt.Text + "][" + wotxt.Text + "][" + releaselognotxt.Text + "][" + releasetypetxt.Text; Setimageaccordingtofamily("AS", root); Treeview.Nodes.Add(root); PopulateTreeView(releaseLogNumber, root); } catch { Treeview.TopNode.Nodes.Clear(); Treeview.Nodes.Clear(); RemoveChildNodes(root); Treeview.ResetText(); } }
/// <summary> /// 获取服务器列表 /// </summary> private void getServers() { Treeview.Nodes.Clear(); Treeview.Nodes.Add("服务器", "数据库服务器", 0); _ConnectList = UtilsHelper.GetConnectionList(); TreeNode node = Treeview.Nodes[0]; node.ContextMenuStrip = contextMenuStripTop; foreach (Connection connection in _ConnectList) { TreeNode nnode = new TreeNode(connection.Name, 0, 0); nnode.ContextMenuStrip = contextMenuStripDatabase; nnode.Tag = connection.ID.ToString(); node.Nodes.Add(nnode); } Treeview.ExpandAll(); }
private int GetSelectObject(int parent_id, ref Treeview pTr, ref DataTable dtSource, ref DataTable dtMeter) { DataRow[] pArr = dtSource.Select("Parent_id=" + parent_id, "Co_id"); int pRows = pArr.Count(); pTr.nodes = new List <Treeview>(); int meterCnt = 0; foreach (DataRow dr in pArr) { int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]); int attrib = CommFunc.ConvertDBNullToInt32(dr["Attrib"]); string type = attrib == (int)CoAttrib.Area ? "A" : attrib == (int)CoAttrib.Station ? "S" : "R"; Treeview cTr = new Treeview(); cTr.id = type + "-" + co_id.ToString(); cTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]); cTr.attributes = type; pTr.nodes.Add(cTr); this.GetSelectObject(co_id, ref cTr, ref dtSource, ref dtMeter); if (attrib == (int)CoAttrib.Room) { #region 增加站点 DataRow[] meterArr = dtMeter.Select("Co_id=" + co_id, "Meter_id"); meterCnt = meterArr.Count(); cTr.nodes = new List <Treeview>(); foreach (DataRow drMeter in meterArr) { int mid = CommFunc.ConvertDBNullToInt32(drMeter["Meter_id"]); Treeview mTr = new Treeview(); mTr.id = "M-" + mid; mTr.text = CommFunc.ConvertDBNullToString(drMeter["MeterName"]); mTr.attributes = "M"; } #endregion } } return(meterCnt); }
private void Fillrootnode() { try { Treeview.Nodes.Clear(); RemoveChildNodes(root); Treeview.ResetText(); Expandchk.Checked = false; DataRow[] dr = treeTB.Select("[Parent] ='" + workOrder + "'"); if (dr.Length > 0) { if (isJob) { root.Text = "(" + dr[0]["JobNo"].ToString() + ") - " + assyNumber + " - " + dr[0]["JobDescription"].ToString(); root.Tag = treeTB.Rows.IndexOf(dr[0]); Setimageaccordingtofamily("JOB", root); Treeview.Nodes.Add(root); PopulateTreeView(workOrder, root); } else { root.Text = "WO " + dr[0]["Parent"].ToString() + " - " + dr[0]["Description"].ToString() + " - " + dr[0]["AssyNo"].ToString(); root.Tag = treeTB.Rows.IndexOf(dr[0]); Setimageaccordingtofamily("AS", root); Treeview.Nodes.Add(root); PopulateTreeViewFirst(workOrder, root); } } } catch { Treeview.TopNode.Nodes.Clear(); Treeview.Nodes.Clear(); RemoveChildNodes(root); Treeview.ResetText(); } }
public ActionResult Create([Bind(Include = "Id,Name,BaseId")] Division division) { if (ModelState.IsValid) { db.Divisions.Add(division); db.SaveChanges(); int parentId = 0; var parent = db.Treeviews.Where(i => i.HierarchyTypeId == (int)Enums.Base && i.KeyOfThatHierarchy == division.BaseId); if (parent != null) { parentId = parent.FirstOrDefault().Id; } var treeview = new Treeview { HierarchyTypeId = (int)Enums.Division, KeyOfThatHierarchy = division.Id, Label = division.Name, ParentId = parentId }; db.Treeviews.Add(treeview); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.BaseId = new SelectList(db.Bases, "Id", "Name", division.BaseId); return(View(division)); }
/// <summary> /// 获取支路信息 /// </summary> /// <returns></returns> public object GetTree() { List <Treeview> rst = new List <Treeview>(); DataTable dtPro = dal.GetProList(); DataTable dtSource = dal.GetBuildList(); foreach (DataRow dr in dtPro.Rows) { Treeview pro = new Treeview(); int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]); pro.id = co_id.ToString(); pro.text = CommFunc.ConvertDBNullToString(dr["CoName"]); pro.attributes = null; rst.Add(pro); this.GetTree(ref pro, ref dtSource, ref co_id); } //foreach (DataRow dr in dtSource.Select("IsAdd==0")) //{ // dr["IsAdd"] = 1; // int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]); // Treeview tb = new Treeview(); // tb.id = co_id.ToString(); // tb.text = CommFunc.ConvertDBNullToString(dr["CoName"]); // tb.attributes = new // { // Id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]), // BuildName = CommFunc.ConvertDBNullToString(dr["CoName"]), // BuildAddr = CommFunc.ConvertDBNullToString(dr["CustAddr"]), // TelNo = CommFunc.ConvertDBNullToString(dr["Mobile"]), // Email = CommFunc.ConvertDBNullToString(dr["Email"]), // Parent_id = CommFunc.ConvertDBNullToInt32(dr["Parent_id"]), // }; // rst.Add(tb); // this.GetTree(ref tb, ref dtSource, ref co_id); //} return(rst); }
public ActionResult Create([Bind(Include = "Id,Name,UnionId")] Village village) { if (ModelState.IsValid) { db.Villages.Add(village); db.SaveChanges(); int parentId = 0; var parent = db.Treeviews.Where(i => i.HierarchyTypeId == (int)Enums.Union && i.KeyOfThatHierarchy == village.UnionId); if (parent != null) { parentId = parent.FirstOrDefault().Id; } var treeview = new Treeview { HierarchyTypeId = (int)Enums.Village, KeyOfThatHierarchy = village.Id, Label = village.Name, ParentId = parentId }; db.Treeviews.Add(treeview); db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.UnionId = new SelectList(db.Unions, "Id", "Name", village.UnionId); return(View(village)); }
/// <summary> /// 获取对象选择树形列表 /// </summary> /// <param name="total"></param> /// <returns></returns> public List <Treeview> GetSelectObject(out int total) { DataTable dtSource = dal.GetAreaList(); DataTable dtMeter = dal.GetMeterList(); total = dtSource.Rows.Count; List <Treeview> rst = new List <Treeview>(); DataRow[] pArr = dtSource.Select("Parent_id=0", "Co_id"); foreach (DataRow dr in pArr) { int co_id = CommFunc.ConvertDBNullToInt32(dr["Co_id"]); int attrib = CommFunc.ConvertDBNullToInt32(dr["Attrib"]); string type = attrib == (int)CoAttrib.Area ? "A" : attrib == (int)CoAttrib.Station ? "S" : "R"; Treeview pTr = new Treeview(); pTr.id = type + "-" + co_id.ToString(); pTr.text = CommFunc.ConvertDBNullToString(dr["CoName"]); pTr.attributes = type; // total = total + this.GetSelectObject(co_id, ref pTr, ref dtSource, ref dtMeter); rst.Add(pTr); } return(rst); }
private void Addbutton_Click(object sender, EventArgs e) { try { errorProvider1.Clear(); if (qtytxtbox.Text.Length > 0 && qtytxtbox.Text != "0" && itemnotxt.Text.Length > 0) { if (itemnotxt.Text == assynotxt.Text) { MessageBox.Show("Cannot add parent item as child", "SPM Conect", MessageBoxButtons.OK, MessageBoxIcon.Information); itemnotxt.Clear(); return; } var iteminfo = new DataTable(); iteminfo.Clear(); iteminfo = connectapi.GetIteminfo(itemnotxt.Text); var r = iteminfo.Rows[0]; if (iteminfo.Rows.Count > 0) { var _itemno = itemnotxt.Text; var _description = r["Description"].ToString(); var _family = r["FamilyCode"].ToString(); var _oem = r["Manufacturer"].ToString(); var _manufacturer = r["ManufacturerItemNumber"].ToString(); var qty = qtytxtbox.Text; var notes = itemnotestxt.Text; SearchNodes(_itemno, Treeview.Nodes[0]); if (itemexists != "yes") { bool isrevised = IsRevised(); var child = new TreeNode { Text = _itemno + " - " + _description + " (" + qty + ")", Tag = _itemno + "][" + _description + "][" + _family + "][" + _manufacturer + "][" + _oem + "][" + qty + "][" + notes + "][" + (isrevised ? "1" : "0") + "][5445" }; Treeview.SelectedNode = Treeview.Nodes[0]; child.BackColor = isrevised ? Color.LightYellow : Color.LightGreen; root.Nodes.Add(child); CallRecursive(); if (!root.IsExpanded) { Treeview.ExpandAll(); } savbttn.Visible = true; itemnotxt.Clear(); } else { savbttn.Visible = false; itemexists = null; itemnotxt.Clear(); } } } else { if (itemnotxt.Text.Length > 0) { errorProvider1.SetError(qtytxtbox, "Qty cannot be null"); } else { errorProvider1.SetError(itemnotxt, "ItemNo cannot be null"); } } } catch { return; } }
private void shareButton_Click(object sender, RoutedEventArgs e) { SQLDAL.SQLDAL.WriteListToDB(Treeview.GetSharedFileList(Treeview.GetCurrentDataGrid())); }