nodes.cs

动易SiteFactory&#8482 网上商店系统1.0源代码

                }
                info = new NodeInfo(true);
                NodeSettingInfo info2 = new NodeSettingInfo(true);
                info.Settings = info2;
            }
            return info;
        }

        public DataTable GetNodeNameByModelId(int modelId, NodeType nodeType)
        {
            DataTable table = new DataTable();
            table.Columns.Add("NodeId");
            table.Columns.Add("NodeName");
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ModelId", DbType.Int32, modelId);
            cmdParams.AddInParameter("@NodeType", DbType.Int32, nodeType);
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT N.NodeId,N.NodeName FROM PE_Nodes_Model_Template R INNER JOIN PE_Nodes N ON R.NodeId=N.NodeId WHERE R.ModelId=@ModelId AND N.NodeType=@NodeType", cmdParams))
            {
                while (reader.Read())
                {
                    DataRow row = table.NewRow();
                    row["NodeId"] = reader.GetInt32("NodeId");
                    row["NodeName"] = reader.GetString("NodeName");
                    table.Rows.Add(row);
                }
            }
            return table;
        }

        public IList<NodeInfo> GetNodesList(NodeType nodeType)
        {
            IList<NodeInfo> list = new List<NodeInfo>();
            Parameters cmdParams = null;
            string str = string.Empty;
            if (nodeType != NodeType.None)
            {
                cmdParams = new Parameters();
                cmdParams.AddInParameter("@NodeType", DbType.Int32, nodeType);
                str = "AND NodeType=@NodeType";
            }
            string format = "SELECT * FROM PE_Nodes WHERE 1=1 {0} ORDER BY RootID,OrderID ASC";
            format = string.Format(format, str);
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, format, cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(NodesFromrdr(reader));
                }
            }
            return list;
        }

        public IList<NodeInfo> GetNodesList(string nodesId)
        {
            List<NodeInfo> list = new List<NodeInfo>();
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql("SELECT * FROM PE_Nodes WHERE NodeID IN (" + nodesId + ")"))
            {
                while (reader.Read())
                {
                    list.Add(NodesFromrdr(reader));
                }
            }
            return list;
        }

        public IList<NodeInfo> GetNodesListByParentId(int parentId)
        {
            IList<NodeInfo> list = new List<NodeInfo>();
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ParentID", DbType.Int32, parentId);
            string strCommand = "SELECT * FROM PE_Nodes WHERE ParentID=@ParentID ORDER BY RootID,OrderID ASC";
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(NodesFromrdr(reader));
                }
            }
            return list;
        }

        public IList<NodeInfo> GetNodesListByRootId(int rootId)
        {
            IList<NodeInfo> list = new List<NodeInfo>();
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@RootID", DbType.Int32, rootId);
            string strCommand = "SELECT * FROM PE_Nodes WHERE RootID =@RootID AND ParentID>0 ORDER BY OrderID";
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                while (reader.Read())
                {
                    list.Add(NodesFromrdr(reader));
                }
            }
            return list;
        }

        public IList<NodeInfo> GetNodesListInArrChildId(string arrChildId)
        {
            IList<NodeInfo> list = new List<NodeInfo>();
            string strCommand = "SELECT * FROM PE_Nodes WHERE NodeID IN (" + arrChildId + ")";
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, null))
            {
                while (reader.Read())
                {
                    list.Add(NodesFromrdr(reader));
                }
            }
            return list;
        }

        public IList<NodeInfo> GetNodesListInParentPath(string parentPath)
        {
            IList<NodeInfo> list = new List<NodeInfo>();
            string strCommand = "SELECT NodeID,arrChildID,Child,NodeName FROM PE_Nodes WHERE NodeID IN (" + parentPath + ") ORDER BY Depth ASC";
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, null))
            {
                while (reader.Read())
                {
                    NodeInfo item = new NodeInfo();
                    item.NodeId = reader.GetInt32("NodeID");
                    item.ArrChildId = reader.GetString("arrChildID");
                    item.Child = reader.GetInt32("Child");
                    item.NodeName = reader.GetString("NodeName");
                    list.Add(item);
                }
            }
            return list;
        }

        public int GetNodeWorkFlowId(int nodeId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@NodeID", DbType.Int32, nodeId);
            object obj2 = DBHelper.ExecuteScalarSql("SELECT WorkFlowID FROM PE_Nodes WHERE NodeID=@NodeID", cmdParams);
            if (obj2 == null)
            {
                return 0;
            }
            return (int) obj2;
        }

        private static Parameters GetParameters(NodeInfo nodeInfo)
        {
            Parameters parameters = new Parameters();
            parameters.AddInParameter("@NodeId", DbType.Int32, nodeInfo.NodeId);
            parameters.AddInParameter("@ArrChildId", DbType.String, nodeInfo.ArrChildId);
            parameters.AddInParameter("@Child", DbType.Int32, nodeInfo.Child);
            parameters.AddInParameter("@CommentCount", DbType.Int32, nodeInfo.CommentCount);
            parameters.AddInParameter("@Creater", DbType.String, nodeInfo.Creater);
            parameters.AddInParameter("@CustomContent", DbType.String, nodeInfo.CustomContent);
            parameters.AddInParameter("@Depth", DbType.Int32, nodeInfo.Depth);
            parameters.AddInParameter("@Description", DbType.String, nodeInfo.Description);
            parameters.AddInParameter("@HitsOfHot", DbType.Int32, nodeInfo.HitsOfHot);
            parameters.AddInParameter("@InheritPurviewFromParent", DbType.Int32, nodeInfo.InheritPurviewFromParent);
            parameters.AddInParameter("@ItemAspxFileName", DbType.String, nodeInfo.ItemAspxFileName);
            parameters.AddInParameter("@ItemChecked", DbType.Int32, nodeInfo.ItemChecked);
            parameters.AddInParameter("@ItemCount", DbType.Int32, nodeInfo.ItemCount);
            parameters.AddInParameter("@IsCreateContentPage", DbType.Boolean, nodeInfo.IsCreateContentPage);
            parameters.AddInParameter("@IsCreateListPage", DbType.Boolean, nodeInfo.IsCreateListPage);
            parameters.AddInParameter("@AutoCreateHtmlType", DbType.Int32, nodeInfo.AutoCreateHtmlType);
            parameters.AddInParameter("@ListPageHtmlRule", DbType.String, nodeInfo.ListPageHtmlRule);
            parameters.AddInParameter("@ListPageSavePathType", DbType.Int32, nodeInfo.ListPageSavePathType);
            parameters.AddInParameter("@ListPagePostfix", DbType.String, nodeInfo.ListPagePostfix);
            parameters.AddInParameter("@ContentPageHtmlRule", DbType.String, nodeInfo.ContentPageHtmlRule);
            parameters.AddInParameter("@RelateNode", DbType.String, nodeInfo.RelateNode);
            parameters.AddInParameter("@RelateSpecial", DbType.String, nodeInfo.RelateSpecial);
            parameters.AddInParameter("@ItemListOrderType", DbType.Int32, nodeInfo.ItemListOrderType);
            parameters.AddInParameter("@ItemOpenType", DbType.Int32, nodeInfo.ItemOpenType);
            parameters.AddInParameter("@ItemPageSize", DbType.Int32, nodeInfo.ItemPageSize);
            parameters.AddInParameter("@DefaultTemplateFile", DbType.String, nodeInfo.DefaultTemplateFile);
            parameters.AddInParameter("@ContainChildTemplateFile", DbType.String, nodeInfo.ContainChildTemplateFile);
            parameters.AddInParameter("@MetaDescription", DbType.String, nodeInfo.MetaDescription);
            parameters.AddInParameter("@MetaKeywords", DbType.String, nodeInfo.MetaKeywords);
            parameters.AddInParameter("@NextId", DbType.Int32, nodeInfo.NextId);
            parameters.AddInParameter("@NodeDir", DbType.String, nodeInfo.NodeDir);
            parameters.AddInParameter("@NodeIdentifier", DbType.String, nodeInfo.NodeIdentifier);
            parameters.AddInParameter("@NodeName", DbType.String, nodeInfo.NodeName);
            parameters.AddInParameter("@NodePicUrl", DbType.String, nodeInfo.NodePicUrl);
            parameters.AddInParameter("@NodeType", DbType.Int32, nodeInfo.NodeType);
            parameters.AddInParameter("@OpenType", DbType.Int32, nodeInfo.OpenType);
            parameters.AddInParameter("@OrderId", DbType.Int32, nodeInfo.OrderId);
            parameters.AddInParameter("@ParentDir", DbType.String, nodeInfo.ParentDir);
            parameters.AddInParameter("@ParentId", DbType.Int32, nodeInfo.ParentId);
            parameters.AddInParameter("@ParentPath", DbType.String, nodeInfo.ParentPath);
            parameters.AddInParameter("@PrevId", DbType.Int32, nodeInfo.PrevId);
            parameters.AddInParameter("@PurviewType", DbType.Int32, nodeInfo.PurviewType);
            parameters.AddInParameter("@RootId", DbType.Int32, nodeInfo.RootId);
            parameters.AddInParameter("@ShowOnListIndex", DbType.Boolean, nodeInfo.ShowOnListIndex);
            parameters.AddInParameter("@ShowOnListParent", DbType.Boolean, nodeInfo.ShowOnListParent);
            parameters.AddInParameter("@ShowOnMap", DbType.Boolean, nodeInfo.ShowOnMap);
            parameters.AddInParameter("@ShowOnMenu", DbType.Boolean, nodeInfo.ShowOnMenu);
            parameters.AddInParameter("@ShowOnPath", DbType.Boolean, nodeInfo.ShowOnPath);
            parameters.AddInParameter("@Tips", DbType.String, nodeInfo.Tips);
            parameters.AddInParameter("@WorkFlowId", DbType.Int32, nodeInfo.WorkFlowId);
            parameters.AddInParameter("@LinkUrl", DbType.String, nodeInfo.LinkUrl);
            parameters.AddInParameter("@Settings", DbType.String, SerializeSettings(nodeInfo.Settings));
            return parameters;
        }

        public NodeInfo GetParentNodeByNodeId(int parentId, int nodeId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ParentID", DbType.Int32, parentId);
            cmdParams.AddInParameter("@NodeID", DbType.Int32, nodeId);
            string strCommand = "SELECT NodeID,RootID,NodeDir FROM PE_Nodes WHERE ParentID=@ParentID AND NodeID=@NodeID";
            NodeInfo info = new NodeInfo();
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, cmdParams))
            {
                if (reader.Read())
                {
                    info.NodeId = reader.GetInt32("NodeID");
                    info.RootId = reader.GetInt32("RootID");
                    info.NodeDir = reader.GetString("NodeDir");
                    return info;
                }
                return new NodeInfo(true);
            }
        }

        public Dictionary<int, string> GetParentPathArrChildId(string parentPath)
        {
            Dictionary<int, string> dictionary = new Dictionary<int, string>();
            string strCommand = "SELECT NodeID,arrChildID FROM PE_Nodes WHERE NodeID IN ( " + parentPath + " )";
            using (NullableDataReader reader = DBHelper.ExecuteReader(CommandType.Text, strCommand, null))
            {
                while (reader.Read())
                {
                    dictionary.Add(reader.GetInt32("NodeID"), reader.GetString("ArrChildID"));
                }
            }
            return dictionary;
        }

        public int GetPrevId(int parentId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@ParentID", DbType.Int32, parentId);
            return DataConverter.CLng(DBHelper.ExecuteScalarSql("SELECT TOP 1 NodeID FROM PE_Nodes WHERE ParentID=@ParentID ORDER BY OrderID DESC", cmdParams));
        }

        public int GetPrevOrderId(string arrChildId)
        {
            return DataConverter.CLng(DBHelper.ExecuteScalarSql("SELECT Max(OrderID) FROM PE_Nodes WHERE NodeID IN ( " + arrChildId + " )"));
        }

        public int GetRootPrevId(int maxRootId)
        {
            Parameters cmdParams = new Parameters();
            cmdParams.AddInParameter("@RootID", DbType.Int32, maxRootId);
            return DataConverter.CLng(DBHelper.ExecuteScalarSql("SELECT NodeID FROM PE_Nodes WHERE RootID=@RootID AND Depth=0", cmdParams));
        }

        public IList<NodeInfo> GetShopNodeList()
        {
            string strSql = "SELECT * FROM PE_Nodes WHERE Nodetype=@NodeType and NodeID in (select NodeID from PE_Nodes_Model_Template where modelID in (select ModelID from PE_Model where IsEshop=1))";
            IList<NodeInfo> list = new List<NodeInfo>();
            using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, new Parameters("@NodeType", DbType.Int32, NodeType.Container)))
            {
                while (reader.Read())
                {
                    list.Add(NodesFromrdr(reader));
                }
            }
            return list;
        }