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);
}
