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