private void AddCondition(Rotation rotation, AdvTree advTree)
 {
     var node = new Node();
     node.Text = rotation.Name;
     node.Tag = rotation;
     AddNode(node, advTree);
 }

        public TreeDragDropEventArgs(eTreeAction action, Node[] nodes, Node oldParentNode, Node newParentNode, int insertPosition)
            : base(action, nodes)
		{
			this.NewParentNode = newParentNode;
			this.OldParentNode = oldParentNode;
            this.InsertPosition = insertPosition;
		}

 /// <summary>
 /// Initializes a new instance of the TreeDragFeedbackEventArgs class.
 /// </summary>
 /// <param name="parentNode"></param>
 /// <param name="insertPosition"></param>
 public TreeDragFeedbackEventArgs(Node parentNode, int insertPosition, Node dragNode, DragDropEffects effect)
 {
     ParentNode = parentNode;
     InsertPosition = insertPosition;
     _DragNode = dragNode;
     _Effect = effect;
 }

        public FormLoadSettings(Tileset[] tilesets)
        {
            InitializeComponent();

            this.tilesets = tilesets;

            foreach (var tileset in tilesets)
            {
                Node node = new Node(tileset.File);

                if (String.IsNullOrEmpty(tileset.File))
                {
                    node.Text = String.Format("Not Specified [w: {0}, h: {1}]", tileset.Size.X, tileset.Size.Y);
                }

                node.Cells.Add(new Cell("<browse for file>"));

                node.Cells[0].Editable = false;
                node.Cells[1].Editable = false;

                node.NodeDoubleClick += node_NodeDoubleClick;

                tilesetFilesList.Nodes.Add(node);
            }
        }

        public FormSaveSettings(string saveLocation, FormWorld world)
        {
            InitializeComponent();

            this.saveLocation = saveLocation;
            this.world = world;

            var saveUri = new Uri(saveLocation);

            foreach (var tileset in world.Tilesets)
            {
                string relative = saveUri.MakeRelativeUri(new Uri(tileset.Filename)).ToString();

                Node node = new Node(Path.GetFileName(tileset.Filename))
                {
                    CheckBoxVisible = true,
                    Checked = tileset.ShouldBuild
                };

                Cell cell = new Cell()
                {
                    Text = tileset.BuildLocation != null ? tileset.BuildLocation : 
                           Path.Combine(Path.GetDirectoryName(relative), Path.GetFileNameWithoutExtension(relative)),
                    Editable = true
                };

                node.Cells[0].Editable = false;

                node.Cells.Add(cell);

                tilesetFilesList.Nodes.Add(node);
            }
        }

        /// <summary>
        /// Called when the selected world changes
        /// </summary>
        void onWorldChange()
        {
            // closed last world open
            if (world == null)
            {
                layersList.Nodes.Clear();
                btnAddLayer.Enabled = false;
                return;
            }

            btnAddLayer.Enabled = true;

            // cache index before it gets changed from
            // modifying the list
            int index = world.SelectedLayer;

            layersList.Nodes.Clear();

            // collision layer
            Node collision = new Node("Collision Layer")
            {
                CheckBoxVisible = true,
                Checked = true,
                ImageIndex = 1,
                Editable = false
            };

            layersList.Nodes.Add(collision);
         
            // add layers from new world
            for (int i = world.LayerCount - 2; i >= 0; i--)
                addLayer(world.GetLayerName(i), i == world.SelectedLayer, world.GetLayerVisibility(i));

            SetLayer(index);
        }

 private void AddCondition(Rule rule, AdvTree advTree)
 {
     var node = new Node();
     node.Text = rule.Name;
     node.Tag = rule;
     AddNode(node, advTree);
 }

		/// <summary>
		/// Gets the last child tree node. The LastNode is the last child Node in the NodeCollection stored in the Nodes property of the current tree node. If the Node has no child tree node, the LastNode property returns a null reference (Nothing in Visual Basic).
		/// </summary>
		/// <param name="node">Reference node.</param>
		/// <returns>Last node if found or null if there is no last node.</returns>
		public static Node GetLastNode(Node node)
		{
			if(node.Nodes.Count>0)
			{
				return node.Nodes[node.Nodes.Count-1];
			}
			return null;
		}

 private void AddSchool(string name)
 {
     var add = new Node(name);
     add.Tag = name;
     ListSchoolItems.BeginUpdate();
     ListSchoolItems.Nodes.Add(add);
     ListSchoolItems.EndUpdate();
 }

		public TreeNodeMouseEventArgs(Node node, MouseButtons button, int clicks, int delta, int x, int y)
		{
			this.Node = node;
			this.Button = button;
			this.Clicks = clicks;
			this.Delta = delta;
			this.X = x;
			this.Y = y;
		}

 public Node CreateControl(string name, string tag, Control control)
 {
     var node = new Node();
     node.Expanded = true;
     node.Name = name;
     node.Tag = tag;
     node.HostedControl = control;
     node.DragDropEnabled = false;
     return node;
 }

 public Node CreateRadioButton(string name, string text, string tag, bool selected = false)
 {
     var node = new Node();
     node.CheckBoxStyle = eCheckBoxStyle.RadioButton;
     node.CheckBoxVisible = true;
     node.Expanded = true;
     node.Name = name;
     node.Text = text;
     node.Tag = tag;
     node.Checked = selected;
     node.DragDropEnabled = false;
     return node;
 }

		/// <summary>
		/// Returns full path to the given node.
		/// </summary>
		/// <param name="node">Node to return path to.</param>
		/// <returns>Full path to the node.</returns>
		public static string GetFullPath(Node node,string pathSeparator)
		{
			if(node==null)
				throw new ArgumentNullException("node");
			
			StringBuilder sb=new StringBuilder(node.Text);
			node=node.Parent;
			while(node!=null)
			{
                sb.Insert(0, node.Text + pathSeparator);
				node=node.Parent;
			}

			return sb.ToString();
		}

        /// <summary>
        /// Adds a temporary property to the list
        /// </summary>
        void addProperty(string name = newPropertyText, string value = "", bool valueEditable = false)
        {
            Node node = new Node(name)
            {
                ContextMenu = propertyMenu
            };

            Cell cell = new Cell(value)
            {
                Editable = valueEditable
            };

            node.Cells.Add(cell);

            propertiesList.Nodes.Add(node);
        }

        /// <summary>
        /// Adds new object to the collection and provides information about the source of the command
        /// </summary>
        /// <param name="node">Node to add</param>
        /// <param name="action">Source action</param>
        /// <returns></returns>
        public override int Add(Node node, eTreeAction action)
        {
            if (this.List.Contains(node)) return -1;

            if (TreeSelectionControl.MultiSelect)
            {
                if (TreeSelectionControl.MultiSelectRule == eMultiSelectRule.SameParent && this.Count>0)
                {
                    if (this[0].Parent != node.Parent)
                        throw new InvalidOperationException("Node being added does not belong to the same parent as currently selected nodes. See AdvTree.MultiSelectRule property");
                }
                if (!SuspendEvents)
                {
                    AdvTreeNodeCancelEventArgs cancelArgs = new AdvTreeNodeCancelEventArgs(action, node);
                    TreeSelectionControl.InvokeOnBeforeNodeSelect(cancelArgs);
                    if (cancelArgs.Cancel)
                        return -1;
                }
            }
            return base.Add(node, action);
        }

        private void Populate()
        {
            nodeNewTables.Nodes.Clear();
            advTreeTables.BeginUpdate();

            try
            {
                // Fetch all schemas for
                IDatabaseLoader loader = FormDatabase.Instance.CreateDatabaseLoader();
                IDatabase newDb = loader.LoadDatabase(loader.DatabaseObjectsToFetch, null);

                foreach (var schema in newDb.Tables.Select(s => s.Schema).Distinct().Where(s => !ExistingSchemas.Contains(s)).OrderBy(s => s))
                {
                    Node schemaNode = new Node(schema)
                        {
                            CheckBoxVisible = true,
                            Checked = false
                        };
                    nodeNewTables.Nodes.Add(schemaNode);

                    foreach (var table in newDb.Tables.Where(t => t.Schema == schema).Select(t => t.Name).OrderBy(t => t))
                    {
                        Node tableNode = new Node(table)
                        {
                            CheckBoxVisible = true,
                            Checked = false
                        };
                        schemaNode.Nodes.Add(tableNode);
                    }
                }
            }
            finally
            {
                advTreeTables.EndUpdate();
            }
        }

        public void Fill(DatabaseMergeResult results, IDatabase db1, IDatabase db2)
        {
            if (InvokeRequired)
            {
                Invoke(new MethodInvoker(() => Fill(results, db1, db2)));
                return;
            }
            DB1 = db1;
            DB2 = db2;

            advTreeTables.BeginUpdate();
            nodeNewEntities.Nodes.Clear();
            nodeModifiedEntities.Nodes.Clear();
            nodeRemovedEntities.Nodes.Clear();

            nodeNewEntities.Checked = true;
            nodeModifiedEntities.Checked = true;
            nodeRemovedEntities.Checked = false;

            try
            {
                #region Database-only

                foreach (TableAdditionOperation addedTableOperation in results.TableOperations.Where(r => r is TableAdditionOperation))
                {
                    Node node = new Node(string.Format("{0}.{1}", addedTableOperation.Object.Schema, addedTableOperation.Object.Name));
                    node.Tag = addedTableOperation;
                    node.CheckBoxVisible = true;
                    node.Checked = false;
                    node.ImageIndex = IMG_NEW;
                    nodeRemovedEntities.Nodes.Add(node);
                }

                #endregion

                #region Model-only
                IList<SynchroGrid.SynchroCanvas.TableMatch> MatchesModelOnly = new List<SynchroGrid.SynchroCanvas.TableMatch>();

                foreach (TableRemovalOperation removedTableOperation in results.TableOperations.Where(r => r is TableRemovalOperation))
                {
                    Node node = new Node(string.Format("{0}.{1}", removedTableOperation.Object.Schema, removedTableOperation.Object.Name));
                    node.Tag = removedTableOperation;
                    node.CheckBoxVisible = true;
                    node.Checked = true;
                    node.ImageIndex = IMG_REMOVED;
                    nodeNewEntities.Nodes.Add(node);
                }

                #endregion

                #region Changes
                HashSet<string> changedTables = new HashSet<string>();

                #region Get tables with changes
                foreach (var result in results.ColumnOperations)
                    changedTables.Add(string.Format("{0}.{1}", result.Object.Parent.Schema, result.Object.Parent.Name));

                foreach (var result in results.IndexOperations)
                    changedTables.Add(string.Format("{0}.{1}", result.Object.Parent.Schema, result.Object.Parent.Name));

                foreach (var result in results.KeyOperations)
                    changedTables.Add(string.Format("{0}.{1}", result.Object.Parent.Schema, result.Object.Parent.Name));

                //foreach (var result in results.RelationshipOperations)
                //    changedTables.Add(string.Format("{0}.{1}", result.Object.PrimaryTable.Schema, result.Object.PrimaryTable.Name));

                #endregion

                foreach (string changedTable in changedTables)
                {
                    Node node = new Node(changedTable);
                    node.Tag = changedTable;
                    node.CheckBoxVisible = true;
                    node.Checked = true;
                    node.ImageIndex = IMG_CHANGED;
                    nodeModifiedEntities.Nodes.Add(node);

                    #region Columns
                    foreach (ColumnAdditionOperation newColumn in results.ColumnOperations.Where(r => r is ColumnAdditionOperation).Where(c => string.Format("{0}.{1}", c.Object.Parent.Schema, c.Object.Parent.Name) == changedTable))
                    {
                        Node columnnode = new Node(string.Format("Remove column from database: [{0}]", newColumn.Object.Name));
                        columnnode.Tag = newColumn;
                        node.Nodes.Add(columnnode);
                    }
                    foreach (ColumnChangeOperation changedColumn in results.ColumnOperations.Where(r => r is ColumnChangeOperation).Where(c => string.Format("{0}.{1}", c.Object.Parent.Schema, c.Object.Parent.Name) == changedTable))
                    {
                        Node columnnode = new Node(string.Format("Update column in database [{0}]", changedColumn.Object.Name));
                        columnnode.Tag = changedColumn;
                        node.Nodes.Add(columnnode);

                        foreach (string d in changedColumn.Description.Split(','))
                            columnnode.Nodes.Add(new Node(d));
                    }
                    foreach (ColumnRemovalOperation removedColumn in results.ColumnOperations.Where(r => r is ColumnRemovalOperation).Where(c => string.Format("{0}.{1}", c.Object.Parent.Schema, c.Object.Parent.Name) == changedTable))
                    {
                        Node columnnode = new Node(string.Format("Add column to database: [{0}]", removedColumn.Object.Name));
                        columnnode.Tag = removedColumn;
                        node.Nodes.Add(columnnode);
                    }
                    #endregion
//.........这里部分代码省略.........

        /// <summary>
        /// 根據未排時數更新班級列表，同時考量到關鍵字搜尋
        /// </summary>
        private void RefreshByUnAlloc(string idWho)
        {
            int Total = 0;

            //根據分課的未排時數進行分類
            SortedDictionary<int, List<string>> UnAllocWhos = new SortedDictionary<int, List<string>>();

            foreach (Class Whom in schLocal.Classes)
            {
                if (Whom.Name.Equals("無"))
                    continue;

                int UnAlloc = Whom.TotalHour - Whom.AllocHour;

                //若未排時數不在字典中則新增
                if (!UnAllocWhos.ContainsKey(UnAlloc))
                    UnAllocWhos.Add(UnAlloc, new List<string>());

                if (IsAddWhom(Whom.ClassID))
                    if (!UnAllocWhos[UnAlloc].Contains(Whom.ClassID))
                        UnAllocWhos[UnAlloc].Add(Whom.ClassID);
            }

            nodeTree.Nodes.Clear();

            Node nodeRoot = new Node("所有班級");
            nodeRoot.TagString = "所有班級";

            Node nodeNull = new Node("無班級");
            nodeNull.TagString = "無";

            nodeTree.Nodes.Add(nodeRoot);
            nodeTree.Nodes.Add(nodeNull);

            foreach (int vUnAlloc in UnAllocWhos.Keys.ToList().OrderByDescending(x => x))
            {
                Node UnAlloc = new Node("" + vUnAlloc);
                List<string> Names = new List<string>();

                foreach (string vWhomID in UnAllocWhos[vUnAlloc])
                {
                    if (schLocal.Classes.Exists(vWhomID))
                    {
                        Class whomPaint = schLocal.Classes[vWhomID];

                        if (whomPaint.TotalHour > 0)
                        {
                            int UnAllocHour = whomPaint.TotalHour - whomPaint.AllocHour;

                            Node nodeWhom = new Node(whomPaint.Name + "(" + UnAllocHour + "/" + whomPaint.TotalHour + ")");
                            nodeWhom.TagString = whomPaint.ClassID;
                            Names.Add(whomPaint.ClassID);
                            UnAlloc.Nodes.Add(nodeWhom);
                            Total++;
                        }
                    }
                }

                if (UnAlloc.Nodes.Count > 0)
                {
                    UnAlloc.Text = UnAlloc.Text + "(" + UnAlloc.Nodes.Count + ")";
                    UnAlloc.TagString = string.Join(";", Names.ToArray());
                    nodeRoot.Nodes.Add(UnAlloc);
                    nodeRoot.Expand();
                }
            }

            nodeRoot.Text = nodeRoot.Text + "(" + schLocal.Classes.HasTotalHourCount + ")";
            nodeRoot.ExpandAll();
        }

        /// <summary>
        /// 根據總時數更新班級列表，同時考量到關鍵字搜尋
        /// </summary>
        private void RefreshByTotalHour(string idWhom)
        {
            int Total = 0;

            //根據分課的總時數進行分類
            SortedDictionary<int, List<string>> TotalWhoms = new SortedDictionary<int, List<string>>();

            foreach (Class Whom in schLocal.Classes)
            {
                if (Whom.Name.Equals("無"))
                    continue;

                int TotalHour = Whom.TotalHour;

                if (!TotalWhoms.ContainsKey(TotalHour))
                    TotalWhoms.Add(TotalHour, new List<string>());

                if (IsAddWhom(Whom.Name))
                    if (!TotalWhoms[TotalHour].Contains(Whom.ClassID))
                        TotalWhoms[TotalHour].Add(Whom.ClassID);
            }

            nodeTree.Nodes.Clear();

            Node nodeRoot = new Node("所有班級");
            nodeRoot.TagString = "所有班級";

            Node nodeNull = new Node("無班級");
            nodeNull.TagString = "無";

            nodeTree.Nodes.Add(nodeRoot);
            nodeTree.Nodes.Add(nodeNull);

            foreach (int vTotalHour in TotalWhoms.Keys.ToList().OrderByDescending(x => x))
            {
                Node nodeTotalHour = new Node("" + vTotalHour);
                List<string> Names = new List<string>();

                foreach (string vWhomID in TotalWhoms[vTotalHour])
                {
                    if (schLocal.Classes.Exists(vWhomID))
                    {
                        Class whomPaint = schLocal.Classes[vWhomID];

                        if (whomPaint.TotalHour > 0)
                        {
                            int UnAllocHour = whomPaint.TotalHour - whomPaint.AllocHour;

                            Node nodeWhom = new Node(whomPaint.Name + "(" + UnAllocHour + "/" + whomPaint.TotalHour + ")");
                            nodeWhom.TagString = whomPaint.ClassID;
                            Names.Add(whomPaint.ClassID);
                            nodeTotalHour.Nodes.Add(nodeWhom);
                            Total++;
                        }
                    }
                }

                if (nodeTotalHour.Nodes.Count > 0)
                {
                    nodeTotalHour.Text = nodeTotalHour.Text + "(" + nodeTotalHour.Nodes.Count + ")";
                    nodeTotalHour.TagString = string.Join(";", Names.ToArray());
                    nodeRoot.Nodes.Add(nodeTotalHour);
                    nodeRoot.Expand();
                }
            }

            nodeRoot.Text = nodeRoot.Text + "(" + schLocal.Classes.HasTotalHourCount + ")";
            nodeRoot.ExpandAll();
        }

        /// <summary>
        /// 根據學校更新班級列表，同時考量到關鍵字搜尋
        /// </summary>
        private void RefreshBySchool(string idWhom)
        {
            int Total = 0;

            //根據分課的總時數進行分類
            SortedDictionary<string, List<string>> TotalClasses = new SortedDictionary<string, List<string>>();

            foreach (Class Class in schLocal.Classes)
            {
                if (Class.Name.Equals("無"))
                    continue;

                string[] ClassIDs = Class.ClassID.Split(new char[] { ',' });

                string DSNS = ClassIDs[0];

                string SchoolName = DSNS;

                if (Global.AvailDSNSNames != null)
                {
                    SchoolDSNSName School = Global.AvailDSNSNames
                    .Find(x => x.DSNSName.Equals(DSNS));

                    if (School != null)
                        SchoolName = School.SchoolName;
                }

                if (!TotalClasses.ContainsKey(SchoolName))
                        TotalClasses.Add(SchoolName, new List<string>());

                    if (IsAddWhom(Class.Name))
                        if (!TotalClasses[SchoolName].Contains(Class.ClassID))
                            TotalClasses[SchoolName].Add(Class.ClassID);
            }

            nodeTree.Nodes.Clear();

            //Node nodeRoot = new Node("所有班級");
            //nodeRoot.TagString = "所有班級";

            //Node nodeNull = new Node("無班級");
            //nodeNull.TagString = "無";

            //nodeTree.Nodes.Add(nodeRoot);
            //nodeTree.Nodes.Add(nodeNull);

            foreach (string School in TotalClasses.Keys.ToList().OrderByDescending(x => x))
            {
                Node nodeTotalHour = new Node("" + School);
                List<string> Names = new List<string>();

                TotalClasses[School].Sort();

                foreach (string vWhomID in TotalClasses[School])
                {
                    if (schLocal.Classes.Exists(vWhomID))
                    {
                        Class whomPaint = schLocal.Classes[vWhomID];

                        if (whomPaint.TotalHour > 0)
                        {
                            int UnAllocHour = whomPaint.TotalHour - whomPaint.AllocHour;

                            Node nodeWhom = new Node(whomPaint.Name + "(" + UnAllocHour + "/" + whomPaint.TotalHour + ")");
                            nodeWhom.TagString = whomPaint.ClassID;
                            Names.Add(whomPaint.ClassID);
                            nodeTotalHour.Nodes.Add(nodeWhom);
                            Total++;
                        }
                    }
                }

                if (nodeTotalHour.Nodes.Count > 0)
                {
                    nodeTotalHour.Text = nodeTotalHour.Text + "(" + nodeTotalHour.Nodes.Count + ")";
                    nodeTotalHour.TagString = string.Join(";", Names.ToArray());
                    nodeTotalHour.Expand();

                    nodeTree.Nodes.Add(nodeTotalHour);

                    //nodeRoot.Nodes.Add(nodeTotalHour);
                    //nodeRoot.Expand();
                }
            }

            //nodeRoot.Text = nodeRoot.Text + "(" + schLocal.Classes.HasTotalHourCount + ")";
            //nodeRoot.ExpandAll();
        }