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