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