public int GetRepliesByData(int dataId, String dataType)
{
OpenCommentCount objCount = OpenCommentCount.find("DataType=:dtype and DataId=" + dataId)
.set("dtype", dataType)
.first();
return(objCount == null ? 0 : objCount.Replies);
}
public int GetRepliesByUrl(String url)
{
OpenCommentCount objCount = OpenCommentCount.find("TargetUrl=:url")
.set("url", url)
.first();
return(objCount == null ? 0 : objCount.Replies);
}
private static void insertCommentCount(OpenComment c, int replies)
{
OpenCommentCount objCount = new OpenCommentCount();
objCount.TargetUrl = c.TargetUrl;
objCount.DataType = c.TargetDataType;
objCount.DataId = c.TargetDataId;
objCount.Replies = replies;
objCount.insert();
}
private static void clearRootTargetRepliesByUrl(String url)
{
OpenCommentCount objCount = OpenCommentCount.find("TargetUrl=:url")
.set("url", url)
.first();
if (objCount == null)
{
return;
}
objCount.Replies = 0;
objCount.update();
}
private static void clearRootTargetRepliesByData(int dataId, string dataType)
{
OpenCommentCount objCount = OpenCommentCount.find("DataType=:dtype and DataId=" + dataId)
.set("dtype", dataType)
.first();
if (objCount == null)
{
return;
}
objCount.Replies = 0;
objCount.update();
}
private void updateRootTargetReplies(OpenComment c)
{
int replies;
OpenCommentCount objCount;
if (c.TargetDataId > 0 && strUtil.HasText(c.TargetDataType))
{
replies = OpenComment.find("TargetDataType=:dtype and TargetDataId=" + c.TargetDataId)
.set("dtype", c.TargetDataType)
.count();
objCount = OpenCommentCount.find("DataType=:dtype and DataId=" + c.TargetDataId)
.set("dtype", c.TargetDataType)
.first();
}
else
{
if (c.TargetUrl == null)
{
replies = 0;
objCount = null;
}
else
{
replies = OpenComment.find("TargetUrl=:url")
.set("url", c.TargetUrl)
.count();
objCount = OpenCommentCount.find("TargetUrl=:url")
.set("url", c.TargetUrl)
.first();
}
}
if (objCount == null)
{
insertCommentCount(c, replies);
}
else
{
updateCommentCount(objCount, replies);
}
updateTargetReplies(c, replies);
}
private static void updateCommentCount(OpenCommentCount objCount, int replies)
{
objCount.Replies = replies;
objCount.update();
}