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