public void Update(Model.CMS.Comment entity) { using (IDbConnection conn = SqlString.GetSqlConnection()) { conn.Execute("UPDATE cms_comment SET ArticleId=@ArticleId,Content=@Content,CreateTime=@CreateTime,Nickname=@Nickname,Email=@Email,VoteFavour=@VoteFavour,VoteOppose=@VoteOppose WHERE Comment_Id =@Comment_Id", entity); } }
public bool Insert(Model.CMS.Comment entity) { using (IDbConnection conn = SqlString.GetSqlConnection()) { int i = conn.Execute("INSERT INTO cms_comment(ArticleId,Content,CreateTime,Nickname,Email,VoteFavour,VoteOppose)" + "VALUES(@ArticleId,@Content,@CreateTime,@Nickname,@Email,@VoteFavour,@VoteOppose)", entity); if (i > 0) { return(true); } else { return(false); } } }