/// <summary> /// 根据传入Model更新数据并返回更新后的Model /// </summary> public int Update(BookmarkComment bookmarkComment) { string sql = "UPDATE tblBookmarkComment " + "SET " + " CommentTitle = @CommentTitle" + ", CommentContent = @CommentContent" + ", BookmarkInfoID = @BookmarkInfoID" + ", CriticsUserID = @CriticsUserID" + ", CreateTime = @CreateTime" + ", BookmarkUserID = @BookmarkUserID" + " WHERE BookmarkCommentID = @BookmarkCommentID"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("@BookmarkCommentID", bookmarkComment.BookmarkCommentID) , new MySqlParameter("@CommentTitle", ToDBValue(bookmarkComment.CommentTitle)) , new MySqlParameter("@CommentContent", ToDBValue(bookmarkComment.CommentContent)) , new MySqlParameter("@BookmarkInfoID", ToDBValue(bookmarkComment.BookmarkInfoID)) , new MySqlParameter("@CriticsUserID", ToDBValue(bookmarkComment.CriticsUserID)) , new MySqlParameter("@CreateTime", ToDBValue(bookmarkComment.CreateTime)) , new MySqlParameter("@BookmarkUserID", ToDBValue(bookmarkComment.BookmarkUserID)) }; return(MyDBHelper.ExecuteNonQuery(sql, para)); }
/// <summary> /// 根据传入Model,并返回Model /// </summary> public bool Add(BookmarkComment bookmarkComment) { string sql = "INSERT INTO tblBookmarkComment (CommentTitle, CommentContent, BookmarkInfoID, CriticsUserID, CreateTime, BookmarkUserID) VALUES (@CommentTitle, @CommentContent, @BookmarkInfoID, @CriticsUserID, @CreateTime, @BookmarkUserID)"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("@CommentTitle", ToDBValue(bookmarkComment.CommentTitle)), new MySqlParameter("@CommentContent", ToDBValue(bookmarkComment.CommentContent)), new MySqlParameter("@BookmarkInfoID", ToDBValue(bookmarkComment.BookmarkInfoID)), new MySqlParameter("@CriticsUserID", ToDBValue(bookmarkComment.CriticsUserID)), new MySqlParameter("@CreateTime", ToDBValue(bookmarkComment.CreateTime)), new MySqlParameter("@BookmarkUserID", ToDBValue(bookmarkComment.BookmarkUserID)), }; int AddId = (int)MyDBHelper.ExecuteScalar(sql, para); if (AddId == 1) { return(true); } else { return(false); } }
public BizBookmarkComment(BookmarkComment dataInfo) { BookmarkCommentID = dataInfo.BookmarkCommentID; CommentTitle = dataInfo.CommentTitle; CommentContent = dataInfo.CommentContent; BookmarkInfoID = dataInfo.BookmarkInfoID; CriticsUserID = dataInfo.CriticsUserID; CreateTime = dataInfo.CreateTime; BookmarkUserID = dataInfo.BookmarkUserID; }
/// <summary> /// 把DataRow转换成Model /// </summary> public BookmarkComment ToModel(MySqlDataReader dr) { BookmarkComment bookmarkComment = new BookmarkComment(); bookmarkComment.BookmarkCommentID = (long)ToModelValue(dr, "BookmarkCommentID"); bookmarkComment.CommentTitle = (string)ToModelValue(dr, "CommentTitle"); bookmarkComment.CommentContent = (string)ToModelValue(dr, "CommentContent"); bookmarkComment.BookmarkInfoID = (long)ToModelValue(dr, "BookmarkInfoID"); bookmarkComment.CriticsUserID = (long)ToModelValue(dr, "CriticsUserID"); bookmarkComment.CreateTime = (DateTime)ToModelValue(dr, "CreateTime"); bookmarkComment.BookmarkUserID = (long)ToModelValue(dr, "BookmarkUserID"); return(bookmarkComment); }
public int Update(BookmarkComment bookmarkComment) { return(new BookmarkCommentDAL().Update(bookmarkComment)); }
public bool BookmarkCommentAdd(BookmarkComment bookmarkComment) { return(new BookmarkCommentDAL().Add(bookmarkComment)); }