public BizBookmarkTagInfo(BookmarkTagInfo dataInfo)
{
BookmarkTagInfoID = dataInfo.BookmarkTagInfoID;
BookmarkInfoID = dataInfo.BookmarkInfoID;
UserInfoID = dataInfo.UserInfoID;
CreateTime = dataInfo.CreateTime;
TagInfoID = dataInfo.TagInfoID;
}
/// <summary>
/// 把DataRow转换成Model
/// </summary>
public BookmarkTagInfo ToModel(MySqlDataReader dr)
{
BookmarkTagInfo bookmarkTagInfo = new BookmarkTagInfo();
bookmarkTagInfo.BookmarkTagInfoID = (long)ToModelValue(dr, "BookmarkTagInfoID");
bookmarkTagInfo.BookmarkInfoID = (long)ToModelValue(dr, "BookmarkInfoID");
bookmarkTagInfo.UserInfoID = (long)ToModelValue(dr, "UserInfoID");
bookmarkTagInfo.CreateTime = (DateTime)ToModelValue(dr, "CreateTime");
bookmarkTagInfo.TagInfoID = (long)ToModelValue(dr, "TagInfoID");
return(bookmarkTagInfo);
}
/// <summary>
/// 根据传入Model，并返回Model
/// </summary>
public bool Add(BookmarkTagInfo bookmarkTagInfo)
{
string sql = "INSERT INTO tblBookmarkTagInfo (BookmarkInfoID, UserInfoID, CreateTime, TagInfoID) VALUES (@BookmarkInfoID, @UserInfoID, @CreateTime, @TagInfoID)";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@BookmarkInfoID", ToDBValue(bookmarkTagInfo.BookmarkInfoID)),
new MySqlParameter("@UserInfoID", ToDBValue(bookmarkTagInfo.UserInfoID)),
new MySqlParameter("@CreateTime", ToDBValue(bookmarkTagInfo.CreateTime)),
new MySqlParameter("@TagInfoID", ToDBValue(bookmarkTagInfo.TagInfoID)),
};
int AddId = (int)MyDBHelper.ExecuteScalar(sql, para);
if (AddId == 1)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 根据传入Model更新数据并返回更新后的Model
/// </summary>
public int Update(BookmarkTagInfo bookmarkTagInfo)
{
string sql =
"UPDATE tblBookmarkTagInfo " +
"SET " +
" BookmarkInfoID = @BookmarkInfoID"
+ ", UserInfoID = @UserInfoID"
+ ", CreateTime = @CreateTime"
+ ", TagInfoID = @TagInfoID"
+ " WHERE BookmarkTagInfoID = @BookmarkTagInfoID";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@BookmarkTagInfoID", bookmarkTagInfo.BookmarkTagInfoID)
, new MySqlParameter("@BookmarkInfoID", ToDBValue(bookmarkTagInfo.BookmarkInfoID))
, new MySqlParameter("@UserInfoID", ToDBValue(bookmarkTagInfo.UserInfoID))
, new MySqlParameter("@CreateTime", ToDBValue(bookmarkTagInfo.CreateTime))
, new MySqlParameter("@TagInfoID", ToDBValue(bookmarkTagInfo.TagInfoID))
};
return(MyDBHelper.ExecuteNonQuery(sql, para));
}
public int Update(BookmarkTagInfo bookmarkTagInfo)
{
return(new BookmarkTagInfoDAL().Update(bookmarkTagInfo));
}
public bool BookmarkTagInfoAdd(BookmarkTagInfo bookmarkTagInfo)
{
return(new BookmarkTagInfoDAL().Add(bookmarkTagInfo));
}
