📄 nodes.cs
字号:
public int GetTotalOfNodes()
{
Database database = DatabaseFactory.CreateDatabase();
DbCommand sqlStringCommand = database.GetSqlStringCommand("select count(*) from PE_Nodes");
using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(sqlStringCommand)))
{
if (reader.Read())
{
return reader.GetInt32(0);
}
return 0;
}
}
private static NodeInfo NodesFromrdr(NullableDataReader rdr)
{
NodeInfo info = new NodeInfo();
info.NodeId = rdr.GetInt32("NodeID");
info.NodeIdentifier = rdr.GetString("NodeIdentifier");
info.NodeType = (NodeType) rdr.GetInt32("NodeType");
info.ParentId = rdr.GetInt32("ParentID");
info.ParentPath = rdr.GetString("ParentPath");
info.Depth = rdr.GetInt32("Depth");
info.RootId = rdr.GetInt32("RootID");
info.Child = rdr.GetInt32("Child");
info.ArrChildId = rdr.GetString("ArrChildID");
info.PrevId = rdr.GetInt32("PrevID");
info.NextId = rdr.GetInt32("NextID");
info.OrderId = rdr.GetInt32("OrderID");
info.NodeDir = rdr.GetString("NodeDir");
info.ParentDir = rdr.GetString("ParentDir");
info.NodeName = rdr.GetString("NodeName");
info.Tips = rdr.GetString("Tips");
info.Description = rdr.GetString("Description");
info.NodePicUrl = rdr.GetString("NodePicUrl");
info.MetaKeywords = rdr.GetString("Meta_Keywords");
info.MetaDescription = rdr.GetString("Meta_Description");
info.ShowOnMenu = rdr.GetBoolean("ShowOnMenu");
info.ShowOnPath = rdr.GetBoolean("ShowOnPath");
info.ShowOnMap = rdr.GetBoolean("ShowOnMap");
info.ShowOnListIndex = rdr.GetBoolean("ShowOnList_Index");
info.ShowOnListParent = rdr.GetBoolean("ShowOnList_Parent");
info.PurviewType = rdr.GetInt32("PurviewType");
info.Creater = rdr.GetString("Creater");
info.InheritPurviewFromParent = rdr.GetInt32("InheritPurviewFromParent");
info.WorkFlowId = rdr.GetInt32("WorkFlowID");
info.HitsOfHot = rdr.GetInt32("HitsOfHot");
info.OpenType = rdr.GetInt32("OpenType");
info.ItemCount = rdr.GetInt32("ItemCount");
info.ItemChecked = rdr.GetInt32("ItemChecked");
info.CommentCount = rdr.GetInt32("CommentCount");
info.CustomContent = rdr.GetString("Custom_Content");
info.IsCreateContentPage = rdr.GetBoolean("IsCreateContentPage");
info.IsCreateListPage = rdr.GetBoolean("IsCreateListPage");
info.AutoCreateHtmlType = (AutoCreateHtmlType) rdr.GetInt32("AutoCreateHtmlType");
info.ContentPageHtmlRule = rdr.GetString("ContentPageHtmlRule");
info.ListPageHtmlRule = rdr.GetString("ListPageHtmlRule");
info.ListPageSavePathType = (ListPagePathType) rdr.GetInt32("ListPageSavePathType");
info.ListPagePostfix = rdr.GetString("ListPagePostFix");
info.RelateNode = rdr.GetString("RelateNode");
info.RelateSpecial = rdr.GetString("RelateSpecial");
info.ItemAspxFileName = rdr.GetString("ItemAspxFileName");
info.DefaultTemplateFile = rdr.GetString("DefaultTemplateFile");
info.ContainChildTemplateFile = rdr.GetString("ContainChildTemplateFile");
info.ItemOpenType = rdr.GetInt32("ItemOpenType");
info.ItemListOrderType = rdr.GetInt32("ItemListOrderType");
info.ItemPageSize = rdr.GetInt32("ItemPageSize");
info.LinkUrl = rdr.GetString("LinkUrl");
info.Settings = DeserializeSettings(rdr.GetString("Settings"));
return info;
}
public void ReplaceTemplateDir(string oldDir, string newDir)
{
oldDir = oldDir.Replace("'", "''");
newDir = newDir.Replace("'", "''");
string str = "'" + oldDir + "%'";
DBHelper.ExecuteSql("UPDATE PE_Nodes SET DefaultTemplateFile = replace(cast(DefaultTemplateFile as nvarchar(4000)),'" + oldDir + "','" + newDir + "') WHERE DefaultTemplateFile LIKE " + str);
DBHelper.ExecuteSql("UPDATE PE_Nodes SET ContainChildTemplateFile = replace(cast(ContainChildTemplateFile as nvarchar(4000)),'" + oldDir + "','" + newDir + "') WHERE ContainChildTemplateFile LIKE " + str);
DBHelper.ExecuteSql("UPDATE PE_Nodes_Model_Template SET DefaultTemplateFile = replace(cast(DefaultTemplateFile as nvarchar(4000)),'" + oldDir + "','" + newDir + "') WHERE DefaultTemplateFile LIKE " + str);
DBHelper.ExecuteSql("UPDATE PE_Model SET DefaultTemplateFile = replace(cast(DefaultTemplateFile as nvarchar(4000)),'" + oldDir + "','" + newDir + "') WHERE DefaultTemplateFile LIKE " + str);
DBHelper.ExecuteSql("UPDATE PE_Model SET PrintTemplate = replace(cast(PrintTemplate as nvarchar(4000)),'" + oldDir + "','" + newDir + "') WHERE PrintTemplate LIKE " + str);
}
public void ReplaceTemplateFileName(string replaceFormer, string replaceAfter)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@ReplaceFormer", DbType.String, replaceFormer);
cmdParams.AddInParameter("@ReplaceAfter", DbType.String, replaceAfter);
DBHelper.ExecuteSql("UPDATE PE_Nodes SET DefaultTemplateFile = @ReplaceAfter WHERE DefaultTemplateFile = @ReplaceFormer", cmdParams);
DBHelper.ExecuteSql("UPDATE PE_Nodes SET ContainChildTemplateFile = @ReplaceAfter WHERE ContainChildTemplateFile = @ReplaceFormer", cmdParams);
DBHelper.ExecuteSql("UPDATE PE_Nodes_Model_Template SET DefaultTemplateFile = @ReplaceAfter WHERE DefaultTemplateFile = @ReplaceFormer", cmdParams);
DBHelper.ExecuteSql("UPDATE PE_Model SET DefaultTemplateFile = @ReplaceAfter WHERE DefaultTemplateFile = @ReplaceFormer", cmdParams);
DBHelper.ExecuteSql("UPDATE PE_Model SET PrintTemplate = @ReplaceAfter WHERE PrintTemplate = @ReplaceFormer", cmdParams);
}
private static string SerializeSettings(NodeSettingInfo nodeSettingInfo)
{
return ser.SerializeField(nodeSettingInfo);
}
public bool Update(NodeInfo nodeInfo)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@NodeID", DbType.Int32, nodeInfo.NodeId);
cmdParams.AddInParameter("@NodeIdentifier", DbType.String, nodeInfo.NodeIdentifier);
cmdParams.AddInParameter("@ParentId", DbType.Int32, nodeInfo.ParentId);
cmdParams.AddInParameter("@ParentPath", DbType.String, nodeInfo.ParentPath);
cmdParams.AddInParameter("@Depth", DbType.Int32, nodeInfo.Depth);
cmdParams.AddInParameter("@RootId", DbType.Int32, nodeInfo.RootId);
cmdParams.AddInParameter("@Child", DbType.Int32, nodeInfo.Child);
cmdParams.AddInParameter("@ArrChildId", DbType.String, nodeInfo.ArrChildId);
cmdParams.AddInParameter("@PrevId", DbType.Int32, nodeInfo.PrevId);
cmdParams.AddInParameter("@NextId", DbType.Int32, nodeInfo.NextId);
cmdParams.AddInParameter("@OrderId", DbType.Int32, nodeInfo.OrderId);
cmdParams.AddInParameter("@NodeDir", DbType.String, nodeInfo.NodeDir);
cmdParams.AddInParameter("@ParentDir", DbType.String, nodeInfo.ParentDir);
cmdParams.AddInParameter("@NodeName", DbType.String, nodeInfo.NodeName);
cmdParams.AddInParameter("@NodePicUrl", DbType.String, nodeInfo.NodePicUrl);
cmdParams.AddInParameter("@MetaDescription", DbType.String, nodeInfo.MetaDescription);
cmdParams.AddInParameter("@MetaKeywords", DbType.String, nodeInfo.MetaKeywords);
cmdParams.AddInParameter("@OpenType", DbType.Int32, nodeInfo.OpenType);
cmdParams.AddInParameter("@PurviewType", DbType.Int32, nodeInfo.PurviewType);
cmdParams.AddInParameter("@CommentCount", DbType.Int32, nodeInfo.CommentCount);
cmdParams.AddInParameter("@Creater", DbType.String, nodeInfo.Creater);
cmdParams.AddInParameter("@CustomContent", DbType.String, nodeInfo.CustomContent);
cmdParams.AddInParameter("@Description", DbType.String, nodeInfo.Description);
cmdParams.AddInParameter("@HitsOfHot", DbType.Int32, nodeInfo.HitsOfHot);
cmdParams.AddInParameter("@InheritPurviewFromParent", DbType.Int32, nodeInfo.InheritPurviewFromParent);
cmdParams.AddInParameter("@ItemAspxFileName", DbType.String, nodeInfo.ItemAspxFileName);
cmdParams.AddInParameter("@ItemChecked", DbType.Int32, nodeInfo.ItemChecked);
cmdParams.AddInParameter("@ItemCount", DbType.Int32, nodeInfo.ItemCount);
cmdParams.AddInParameter("@IsCreateContentPage", DbType.Boolean, nodeInfo.IsCreateContentPage);
cmdParams.AddInParameter("@IsCreateListPage", DbType.Boolean, nodeInfo.IsCreateListPage);
cmdParams.AddInParameter("@ListPageHtmlRule", DbType.String, nodeInfo.ListPageHtmlRule);
cmdParams.AddInParameter("@ListPageSavePathType", DbType.Int32, nodeInfo.ListPageSavePathType);
cmdParams.AddInParameter("@ListPagePostfix", DbType.String, nodeInfo.ListPagePostfix);
cmdParams.AddInParameter("@ContentPageHtmlRule", DbType.String, nodeInfo.ContentPageHtmlRule);
cmdParams.AddInParameter("@RelateNode", DbType.String, nodeInfo.RelateNode);
cmdParams.AddInParameter("@RelateSpecial", DbType.String, nodeInfo.RelateSpecial);
cmdParams.AddInParameter("@AutoCreateHtmlType", DbType.Int32, nodeInfo.AutoCreateHtmlType);
cmdParams.AddInParameter("@ItemListOrderType", DbType.Int32, nodeInfo.ItemListOrderType);
cmdParams.AddInParameter("@ItemOpenType", DbType.Int32, nodeInfo.ItemOpenType);
cmdParams.AddInParameter("@ItemPageSize", DbType.Int32, nodeInfo.ItemPageSize);
cmdParams.AddInParameter("@DefaultTemplateFile", DbType.String, nodeInfo.DefaultTemplateFile);
cmdParams.AddInParameter("@ContainChildTemplateFile", DbType.String, nodeInfo.ContainChildTemplateFile);
cmdParams.AddInParameter("@ShowOnListIndex", DbType.Boolean, nodeInfo.ShowOnListIndex);
cmdParams.AddInParameter("@ShowOnListParent", DbType.Boolean, nodeInfo.ShowOnListParent);
cmdParams.AddInParameter("@ShowOnMap", DbType.Boolean, nodeInfo.ShowOnMap);
cmdParams.AddInParameter("@ShowOnMenu", DbType.Boolean, nodeInfo.ShowOnMenu);
cmdParams.AddInParameter("@ShowOnPath", DbType.Boolean, nodeInfo.ShowOnPath);
cmdParams.AddInParameter("@Tips", DbType.String, nodeInfo.Tips);
cmdParams.AddInParameter("@WorkFlowId", DbType.Int32, nodeInfo.WorkFlowId);
cmdParams.AddInParameter("@LinkUrl", DbType.String, nodeInfo.LinkUrl);
cmdParams.AddInParameter("@Settings", DbType.String, SerializeSettings(nodeInfo.Settings));
return DBHelper.ExecuteProc("PR_Contents_Nodes_Update", cmdParams);
}
public bool UpdateArrChildId(int nodeId, string arrChildId)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@NodeID", DbType.Int32, nodeId);
cmdParams.AddInParameter("@ArrChildID", DbType.String, arrChildId);
return DBHelper.ExecuteSql("UPDATE PE_Nodes SET ArrChildID = @ArrChildID WHERE NodeID = @NodeID", cmdParams);
}
public bool UpdateChild(int parentId)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@ParentID", DbType.Int32, parentId);
return DBHelper.ExecuteSql("UPDATE PE_Nodes SET Child = Child+1 WHERE NodeID = @ParentID", cmdParams);
}
public bool UpdateChild(int nodeId, int child)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@NodeID", DbType.Int32, nodeId);
cmdParams.AddInParameter("@Child", DbType.Int32, child);
return DBHelper.ExecuteSql("UPDATE PE_Nodes SET Child = @Child WHERE NodeID = @NodeID", cmdParams);
}
public bool UpdateChildPurview(string arrChildId, int purviewType)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@ArrChildID", DbType.String, arrChildId);
cmdParams.AddInParameter("@PurviewType", DbType.Int32, purviewType);
return DBHelper.ExecuteSql("UPDATE PE_Nodes SET PurviewType = @PurviewType WHERE PurviewType<=@PurviewType AND NodeID IN (" + arrChildId + ")", cmdParams);
}
public bool UpdateNextId(int nodeId, int nextId)
{
Database database = DatabaseFactory.CreateDatabase();
DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Contents_Nodes_UpdateNextId");
database.AddInParameter(storedProcCommand, "@NodeID", DbType.Int32, nodeId);
database.AddInParameter(storedProcCommand, "@NextID", DbType.Int32, nextId);
try
{
return (database.ExecuteNonQuery(storedProcCommand) > 0);
}
catch
{
return false;
}
}
public bool UpdateNodePurviewType(int nodeId, int purviewType)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@NodeID", DbType.Int32, nodeId);
cmdParams.AddInParameter("@PurviewType", DbType.Int32, purviewType);
return DBHelper.ExecuteSql("UPDATE PE_Nodes SET PurviewType = @PurviewType WHERE NodeID=@NodeID", cmdParams);
}
public bool UpdateOrderId(int nodeId, int orderId)
{
Database database = DatabaseFactory.CreateDatabase();
DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Contents_Nodes_UpdateOrderId");
database.AddInParameter(storedProcCommand, "@NodeID", DbType.Int32, nodeId);
database.AddInParameter(storedProcCommand, "@OrderID", DbType.Int32, orderId);
try
{
return (database.ExecuteNonQuery(storedProcCommand) > 0);
}
catch
{
return false;
}
}
public bool UpdateOrderId(int rootId, int orderId, int addNum)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@RootID", DbType.Int32, rootId);
cmdParams.AddInParameter("@OrderID", DbType.Int32, orderId);
cmdParams.AddInParameter("@AddNum", DbType.Int32, addNum);
return DBHelper.ExecuteSql("UPDATE PE_Nodes SET OrderID = OrderID+@AddNum WHERE RootID=@RootId AND OrderID>@OrderID", cmdParams);
}
public void UpdateOrderIdByRootIdAndOrderd(int orderId, int rootId)
{
string strSql = "UPDATE PE_Nodes SET OrderId=OrderId+1 WHERE OrderId>@OrderId AND RootId=@RootId";
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@OrderId", DbType.Int32, orderId);
cmdParams.AddInParameter("@RootId", DbType.Int32, rootId);
DBHelper.ExecuteNonQuerySql(strSql, cmdParams);
}
public bool UpdateRootId(string nodeId, int rootId)
{
string strSql = "UPDATE PE_Nodes SET RootID=@RootId WHERE NodeId IN(" + nodeId + ")";
Parameters cmdParams = new Parameters("@RootId", DbType.Int32, rootId);
return DBHelper.ExecuteSql(strSql, cmdParams);
}
public bool UpdateSettings(NodeSettingInfo settingsInfo, int nodeId)
{
Parameters cmdParams = new Parameters();
cmdParams.AddInParameter("@NodeID", DbType.Int32, nodeId);
cmdParams.AddInParameter("@Settings", DbType.String, SerializeSettings(settingsInfo));
return DBHelper.ExecuteSql("UPDATE PE_Nodes SET Settings = @Settings WHERE NodeID = @NodeID", cmdParams);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -