public BizLikeLog(LikeLog dataInfo)
{
LikeLogID = dataInfo.LikeLogID;
UserInfoID = dataInfo.UserInfoID;
InfoID = dataInfo.InfoID;
InfoType = dataInfo.InfoType;
}
/// <summary>
/// 把DataRow转换成Model
/// </summary>
public LikeLog ToModel(MySqlDataReader dr)
{
LikeLog likeLog = new LikeLog();
likeLog.LikeLogID = (long)ToModelValue(dr, "LikeLogID");
likeLog.UserInfoID = (long)ToModelValue(dr, "UserInfoID");
likeLog.InfoID = (long)ToModelValue(dr, "InfoID");
likeLog.InfoType = (int)ToModelValue(dr, "InfoType");
return(likeLog);
}
/// <summary>
/// 新增一個讚
/// </summary>
/// <param name="memberId"></param>
/// <param name="outerKey"></param>
/// <param name="isMsg"></param>
/// <returns></returns>
public bool Add(int memberId, Guid outerKey, bool?isMsg)
{
var db = _uow.DbContext;
var dt = DateTime.UtcNow;
var _type = false;
if (isMsg == true)
{
_type = true;
}
var checkLike = db.LikeLog.Where(t => t.OuterKey == outerKey && t.MemberId == memberId);
//有按讚，就刪除
if (checkLike.Any())
{
var boolLike = checkLike.FirstOrDefault();
db.LikeLog.Remove(boolLike);
}
else
{
#region // 1. 建立點讚活動物件
var objLikeLog = new LikeLog()
{
MemberId = memberId,
CreateUser = memberId,
Created = TimeData.Create(dt),
Updated = TimeData.Create(null),
Deleted = TimeData.Create(null),
IsMsg = _type,
OuterKey = outerKey
};
#endregion
// 3. 寫入DB
db.LikeLog.Add(objLikeLog);
#region // 回傳給APP的物件
}
db.SaveChanges();
#endregion
return(true);
}
/// <summary>
/// 根据传入Model更新数据并返回更新后的Model
/// </summary>
public int Update(LikeLog likeLog)
{
string sql =
"UPDATE tblLikeLog " +
"SET " +
" UserInfoID = @UserInfoID"
+ ", InfoID = @InfoID"
+ ", InfoType = @InfoType"
+ " WHERE LikeLogID = @LikeLogID";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@LikeLogID", likeLog.LikeLogID)
, new MySqlParameter("@UserInfoID", ToDBValue(likeLog.UserInfoID))
, new MySqlParameter("@InfoID", ToDBValue(likeLog.InfoID))
, new MySqlParameter("@InfoType", ToDBValue(likeLog.InfoType))
};
return(MyDBHelper.ExecuteNonQuery(sql, para));
}
/// <summary>
/// 根据传入Model，并返回Model
/// </summary>
public bool Add(LikeLog likeLog)
{
string sql = "INSERT INTO tblLikeLog (UserInfoID, InfoID, InfoType) VALUES (@UserInfoID, @InfoID, @InfoType)";
MySqlParameter[] para = new MySqlParameter[]
{
new MySqlParameter("@UserInfoID", ToDBValue(likeLog.UserInfoID)),
new MySqlParameter("@InfoID", ToDBValue(likeLog.InfoID)),
new MySqlParameter("@InfoType", ToDBValue(likeLog.InfoType)),
};
int AddId = (int)MyDBHelper.ExecuteScalar(sql, para);
if (AddId == 1)
{
return(true);
}
else
{
return(false);
}
}
public int Update(LikeLog likeLog)
{
return(new LikeLogDAL().Update(likeLog));
}
public bool LikeLogAdd(LikeLog likeLog)
{
return(new LikeLogDAL().Add(likeLog));
}
