/// <summary>
/// 根据传入Model，并返回Model
/// </summary>
public bool Add(WebpageComment webpageComment)
{
string sql = "INSERT INTO tblWebpageComment (CommentUserID, URLInfoID, WebpageUserInfoID, CommentTitle, CommentContent, CommentType, CreateTime) VALUES (@CommentUserID, @URLInfoID, @WebpageUserInfoID, @CommentTitle, @CommentContent, @CommentType, @CreateTime)";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@CommentUserID", ToDBValue(webpageComment.CommentUserID)),
new MySqlParameter("@URLInfoID", ToDBValue(webpageComment.URLInfoID)),
new MySqlParameter("@WebpageUserInfoID", ToDBValue(webpageComment.WebpageUserInfoID)),
new MySqlParameter("@CommentTitle", ToDBValue(webpageComment.CommentTitle)),
new MySqlParameter("@CommentContent", ToDBValue(webpageComment.CommentContent)),
new MySqlParameter("@CommentType", ToDBValue(webpageComment.CommentType)),
new MySqlParameter("@CreateTime", ToDBValue(webpageComment.CreateTime)),
};
int AddId = (int)MyDBHelper.ExecuteScalar(sql, para);
if (AddId == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据传入Model更新数据并返回更新后的Model
/// </summary>
public int Update(WebpageComment webpageComment)
{
string sql =
"UPDATE tblWebpageComment " +
"SET " +
" CommentUserID = @CommentUserID"
+ ", URLInfoID = @URLInfoID"
+ ", WebpageUserInfoID = @WebpageUserInfoID"
+ ", CommentTitle = @CommentTitle"
+ ", CommentContent = @CommentContent"
+ ", CommentType = @CommentType"
+ ", CreateTime = @CreateTime"
+ " WHERE WebpageCommentID = @WebpageCommentID";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@WebpageCommentID", webpageComment.WebpageCommentID)
, new MySqlParameter("@CommentUserID", ToDBValue(webpageComment.CommentUserID))
, new MySqlParameter("@URLInfoID", ToDBValue(webpageComment.URLInfoID))
, new MySqlParameter("@WebpageUserInfoID", ToDBValue(webpageComment.WebpageUserInfoID))
, new MySqlParameter("@CommentTitle", ToDBValue(webpageComment.CommentTitle))
, new MySqlParameter("@CommentContent", ToDBValue(webpageComment.CommentContent))
, new MySqlParameter("@CommentType", ToDBValue(webpageComment.CommentType))
, new MySqlParameter("@CreateTime", ToDBValue(webpageComment.CreateTime))
};
return(MyDBHelper.ExecuteNonQuery(sql, para));
}
/// <summary>
/// 把DataRow转换成Model
/// </summary>
public WebpageComment ToModel(MySqlDataReader dr)
{
WebpageComment webpageComment = new WebpageComment();
webpageComment.WebpageCommentID = (long)ToModelValue(dr, "WebpageCommentID");
webpageComment.CommentUserID = (long)ToModelValue(dr, "CommentUserID");
webpageComment.URLInfoID = (long)ToModelValue(dr, "URLInfoID");
webpageComment.WebpageUserInfoID = (long)ToModelValue(dr, "WebpageUserInfoID");
webpageComment.CommentTitle = (string)ToModelValue(dr, "CommentTitle");
webpageComment.CommentContent = (string)ToModelValue(dr, "CommentContent");
webpageComment.CommentType = (int)ToModelValue(dr, "CommentType");
webpageComment.CreateTime = (DateTime)ToModelValue(dr, "CreateTime");
return(webpageComment);
}
