/// <summary> /// 根据传入Model更新数据并返回更新后的Model /// </summary> public int Update(UserDynamicInfo userDynamicInfo) { string sql = "UPDATE tblUserDynamicInfo " + "SET " + " UserDynamicContent = @UserDynamicContent" + ", CreateTime = @CreateTime" + ", UserInfoID = @UserInfoID" + ", UserDynamicType = @UserDynamicType" + ", UserDynamicURL = @UserDynamicURL" + " WHERE UserDynamicInfoID = @UserDynamicInfoID"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("@UserDynamicInfoID", userDynamicInfo.UserDynamicInfoID) , new MySqlParameter("@UserDynamicContent", ToDBValue(userDynamicInfo.UserDynamicContent)) , new MySqlParameter("@CreateTime", ToDBValue(userDynamicInfo.CreateTime)) , new MySqlParameter("@UserInfoID", ToDBValue(userDynamicInfo.UserInfoID)) , new MySqlParameter("@UserDynamicType", ToDBValue(userDynamicInfo.UserDynamicType)) , new MySqlParameter("@UserDynamicURL", ToDBValue(userDynamicInfo.UserDynamicURL)) }; return(MyDBHelper.ExecuteNonQuery(sql, para)); }
public BizUserDynamicInfo(UserDynamicInfo dataInfo) { UserDynamicInfoID = dataInfo.UserDynamicInfoID; UserDynamicContent = dataInfo.UserDynamicContent; CreateTime = dataInfo.CreateTime; UserInfoID = dataInfo.UserInfoID; UserDynamicType = dataInfo.UserDynamicType; UserDynamicURL = dataInfo.UserDynamicURL; }
/// <summary> /// 把DataRow转换成Model /// </summary> public UserDynamicInfo ToModel(MySqlDataReader dr) { UserDynamicInfo userDynamicInfo = new UserDynamicInfo(); userDynamicInfo.UserDynamicInfoID = (long)ToModelValue(dr, "UserDynamicInfoID"); userDynamicInfo.UserDynamicContent = (string)ToModelValue(dr, "UserDynamicContent"); userDynamicInfo.CreateTime = (DateTime)ToModelValue(dr, "CreateTime"); userDynamicInfo.UserInfoID = (long)ToModelValue(dr, "UserInfoID"); userDynamicInfo.UserDynamicType = (int)ToModelValue(dr, "UserDynamicType"); userDynamicInfo.UserDynamicURL = (string)ToModelValue(dr, "UserDynamicURL"); return(userDynamicInfo); }
public int UpdatePointsScore(UserDynamicInfo dyInfo) { var query = GetAll(); var dyItem = query.Where(o => o.UserId == dyInfo.UserId).FirstOrDefault(); if (dyItem == null) { return(InsertAndGetId(dyInfo)); } else { dyItem.TotalScore = dyItem.TotalScore + dyInfo.TotalScore; Update(dyItem); return(1); } }
/// <summary> /// 根据传入Model,并返回Model /// </summary> public bool Add(UserDynamicInfo userDynamicInfo) { string sql = "INSERT INTO tblUserDynamicInfo (UserDynamicInfoID, UserDynamicContent, CreateTime, UserInfoID, UserDynamicType, UserDynamicURL) VALUES (@UserDynamicInfoID, @UserDynamicContent, @CreateTime, @UserInfoID, @UserDynamicType, @UserDynamicURL)"; MySqlParameter[] para = new MySqlParameter[] { new MySqlParameter("@UserDynamicInfoID", ToDBValue(userDynamicInfo.UserDynamicInfoID)), new MySqlParameter("@UserDynamicContent", ToDBValue(userDynamicInfo.UserDynamicContent)), new MySqlParameter("@CreateTime", ToDBValue(userDynamicInfo.CreateTime)), new MySqlParameter("@UserInfoID", ToDBValue(userDynamicInfo.UserInfoID)), new MySqlParameter("@UserDynamicType", ToDBValue(userDynamicInfo.UserDynamicType)), new MySqlParameter("@UserDynamicURL", ToDBValue(userDynamicInfo.UserDynamicURL)), }; int AddId = (int)MyDBHelper.ExecuteNonQuery(sql, para); if (AddId > 1) { return(true); } else { return(false); } }
public int AddPointsScore(UserDynamicInfo dyInfo) { return(InsertAndGetId(dyInfo)); }
public int Update(UserDynamicInfo userDynamicInfo) { return(new UserDynamicInfoDAL().Update(userDynamicInfo)); }
public bool UserDynamicInfoAdd(UserDynamicInfo userDynamicInfo) { return(new UserDynamicInfoDAL().Add(userDynamicInfo)); }