public void Delete(UserGameRecordEntity entity) { if (entity == null) { throw new ArgumentNullException("No room Entity"); } Delete(entity.roomUid); }
public void Update(UserGameRecordEntity entity) { if (entity == null) { throw new ArgumentNullException("No UserGameRecordEntity Entity"); } var sql = String.Format("UPDATE lucifer_community.user_game_record SET " + " `uId` = {0}, `zoneId`= {1}, `roomUid`= {2}, `regDate`= '{3}', " + "`updateDate`= '{4}' WHERE (`uId` = {0});", entity.uId, entity.zoneId, entity.roomUid, entity.regDate, entity.updateDate); Connection.Execute( sql, transaction: Transaction ); }
public void Add(UserGameRecordEntity entity) { if (entity == null) { throw new ArgumentNullException("No Account Entity"); } var sql = String.Format("INSERT INTO lucifer_community.user_game_record" + " (`uId`, `zoneId`, `roomUid`, `regDate`, `updateDate`)" + " VALUES('{0}', '{1}', '{2}', '{3}', '{4}');", entity.uId, entity.zoneId, entity.roomUid, entity.regDate, entity.updateDate); entity.uId = Connection.ExecuteScalar <long>( sql, transaction: Transaction ); }