private void trvNev_DragDrop(object sender, DragEventArgs e) { TreeNode nodeOver = null; Point p = trvNev.PointToClient(new Point(e.X, e.Y)); nodeOver = trvNev.GetNodeAt(p.X, p.Y); string teamid = (System.String)e.Data.GetData(typeof(System.String)); if (trans.Tree.VisibleFlag == 1) { MessageBox.Show("This tree is used. Can't be added.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } else { if (!_repo.CheckTeamInTree(trans.Tree.TreeViewId, teamid)) { nodeOver.TreeView.SelectedNode = nodeOver; TreeNode nodeChild = new TreeNode(teamid); nodeChild.Tag = teamid; nodeOver.Nodes.Add(nodeChild); nodeOver.Expand(); TeamHierarchyModel model = new TeamHierarchyModel(); model.TreeViewId = trans.Tree.TreeViewId; model.TeamId = teamid; model.ParentId = nodeOver.Tag.ToString(); trans.Hierarchy = _repo.InsertTeam(epiSession, model).ToList(); } else { MessageBox.Show("This team [" + teamid + "] has already.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } }
public IEnumerable <TeamHierarchyModel> InsertTeam(Ice.Core.Session session, TeamHierarchyModel model) { string sql = string.Format(@"INSERT INTO Custom_TeamNode (TreeViewId ,TeamId ,ParentId ,VisibleFlag ,CreateBy ,LastUpdateBy) VALUES ( {0} --<TreeViewId, int,> , '{1}' --<TeamId, nvarchar(50),> , '{2}' --<ParentId, nvarchar(50),> , {3} --<VisibleFlag, int,> , '{4}' --<CreateBy, nvarchar(50),> , '{4}')" + Environment.NewLine , model.TreeViewId , model.TeamId , model.ParentId , 1 , session.UserID); Repository.Instance.ExecuteWithTransaction(sql, "Add node"); return(GetAllHierarchy(model.TreeViewId)); }
private void DeleteNodes(TreeNode node) { TeamHierarchyModel model = new TeamHierarchyModel(); model.TreeViewId = trans.Tree.TreeViewId; model.TeamId = node.Tag.ToString(); trans.Hierarchy = _repo.DeleteNode(epiSession, model).ToList(); foreach (TreeNode oSubNode in node.Nodes) { DeleteNodes(oSubNode); } }
public IEnumerable <TeamHierarchyModel> DeleteNode(Ice.Core.Session session, TeamHierarchyModel model) { string sql = string.Format(@"DELETE FROM Custom_AuthTree WHERE TreeViewId = {0} AND TeamId = '{1}' " + Environment.NewLine , model.TreeViewId , model.TeamId); sql = sql + string.Format(@"DELETE FROM Custom_TeamNode WHERE TreeViewId = {0} AND TeamId = '{1}' " + Environment.NewLine , model.TreeViewId , model.TeamId); sql = sql + string.Format(@"DELETE FROM Custom_Authorized WHERE TreeViewId = {0} AND TeamId = '{1}' " + Environment.NewLine , model.TreeViewId , model.TeamId); Repository.Instance.ExecuteWithTransaction(sql, "Delete node"); return(GetAllHierarchy(model.TreeViewId)); }
public TeamHierarchyModel GetHierarchy(TeamHierarchyModel model) { throw new NotImplementedException(); }
public IEnumerable <TeamHierarchyModel> GetHierarchiesByFilter(TeamHierarchyModel model) { throw new NotImplementedException(); }