public int Against(string commentID, string userID, string ip)
{
IDbHelper db = IocFactory <FYJ.Data.IDbFactory> .Instance.GetDbInstance("Comment");
string sql = string.Empty;
if (!String.IsNullOrEmpty(userID))
{
sql = "select * from blog_tb_commentSupport where commentID=@commentID and userID=@UserID and isSupport=@isSupport";
if (db.Exists(sql
, db.CreateParameter("@commentID", commentID)
, db.CreateParameter("@userID", userID)
, db.CreateParameter("@isSupport", false)
))
{
throw new CustomException("你已经反对过了");
}
}
sql = "select * from blog_tb_commentSupport where commentID=@commentID and supportIP=@supportIP and isSupport=@isSupport";
if (db.Exists(sql
, db.CreateParameter("@commentID", commentID)
, db.CreateParameter("@supportIP", ip)
, db.CreateParameter("@isSupport", false)
))
{
throw new CustomException("你已经反对过了");
}
blog_tb_commentSupport support = new blog_tb_commentSupport {
supportID = Guid.NewGuid().ToString("N"), supportIP = ip, commentID = commentID, supportDatetime = DateTime.Now, isSupport = false, UPDATE_DATE = DateTime.Now
};
FYJ.Data.Entity.EntityHelper <blog_tb_commentSupport> .Insert(support, "blog_tb_commentSupport", "supportID", true, db);
sql = "update blog_tb_comment set againstCount=IFNULL(againstCount,0)+1 where commentID=@commentID";
return(db.ExecuteSql(sql, db.CreateParameter("@commentID", commentID)));
}
public int Support(string commentID, string userID, string ip)
{
string sql = string.Empty;
if (!String.IsNullOrEmpty(userID))
{
sql = "select * from blog_tb_commentSupport where commentID=@commentID and userID=@UserID and isSupport=@isSupport";
if (DbInstance.Exists(sql
, DbInstance.CreateParameter("@commentID", commentID)
, DbInstance.CreateParameter("@userID", userID)
, DbInstance.CreateParameter("@isSupport", true)
))
{
throw new CustomException("你已经支持过了");
}
}
sql = "select * from blog_tb_commentSupport where commentID=@commentID and supportIP=@supportIP and isSupport=@isSupport";
if (DbInstance.Exists(sql
, DbInstance.CreateParameter("@commentID", commentID)
, DbInstance.CreateParameter("@supportIP", ip)
, DbInstance.CreateParameter("@isSupport", true)
))
{
throw new CustomException("你已经支持过了");
}
blog_tb_commentSupport support = new blog_tb_commentSupport {
supportID = Guid.NewGuid().ToString("N"), supportIP = ip, commentID = commentID, supportDatetime = DateTime.Now, isSupport = true, UPDATE_DATE = DateTime.Now
};
FYJ.Data.Entity.EntityHelper <blog_tb_commentSupport> .Insert(support, "blog_tb_commentSupport", "supportID", true, this.DbInstance);
sql = "update blog_tb_comment set supportCount=supportCount+1 where commentID=@commentID";
return(this.DbInstance.ExecuteSql(sql, this.DbInstance.CreateParameter("@commentID", commentID)));
}