public static ContentInfo GetContentById(int intContID) { ContentInfo model = BizBase.dbo.GetModel <ContentInfo>(" SELECT * FROM CMS_Content WHERE AutoID=" + intContID.ToString()); if (model != null) { model.Node = Node.GetCacheNodeById(model.NodeID); model.ContentUrl = ContHelper.GetContentUrl(model.NodeID, model.AutoID, model.AutoTimeStamp); model.CustomTable = Content.GetCustomContentInfo(model.AutoID, model.TableName); } return(model); }
public static ContentInfo GetTopConentByNodeID(int intNodeID, bool boolIsAudit) { ContentInfo contentInfo = new ContentInfo(); if (boolIsAudit) { contentInfo = BizBase.dbo.GetModel <ContentInfo>(" SELECT TOP 1 * FROM cms_Content WHERE NodeID=" + intNodeID + " AND Status=99 ORDER BY Sort ASC,AutoID desc "); } else { contentInfo = BizBase.dbo.GetModel <ContentInfo>(" SELECT TOP 1 * FROM cms_Content WHERE NodeID=" + intNodeID + " ORDER BY Sort ASC,AutoID desc "); } if (contentInfo != null) { contentInfo.Node = Node.GetCacheNodeById(contentInfo.NodeID); contentInfo.ContentUrl = ContHelper.GetContentUrl(contentInfo.NodeID, contentInfo.AutoID, contentInfo.AutoTimeStamp); contentInfo.CustomTable = Content.GetCustomContentInfo(contentInfo.AutoID, contentInfo.TableName); } return(contentInfo); }