/// <summary> /// 更新用户正在做的任务 /// </summary> /// <returns></returns> public static async Task <bool> UpdateDragonBallUserMissionAsync(BaseDbHelper dbHelper, DragonBallUserMissionModel model) { var sql = @" update Activity.[dbo].[tbl_DragonBallUserMission] set [MissionId] = @MissionId ,[MissionStatus] = @MissionStatus ,[DragonBallCount] = @DragonBallCount ,LastUpdateDateTime = getdate() where pkid = @pkid and LastUpdateDateTime = @LastUpdateDateTime "; using (var cmd = new SqlCommand(sql)) { cmd.AddParameter("@MissionId", model.MissionId); cmd.AddParameter("@MissionStatus", model.MissionStatus); cmd.AddParameter("@DragonBallCount", model.DragonBallCount); cmd.AddParameter("@pkid", model.PKID); cmd.AddParameter("@LastUpdateDateTime", model.LastUpdateDateTime); var result = await dbHelper.ExecuteNonQueryAsync(cmd); return(result > 0); } }
/// <summary> /// 新增用户正在做的任务 /// </summary> /// <returns></returns> public static async Task <long> InsertDragonBallUserMissionAsync(BaseDbHelper dbHelper, DragonBallUserMissionModel model) { var sql = @" insert into Activity.[dbo].[tbl_DragonBallUserMission] ( UserId, MissionId, MissionStatus, DragonBallCount, CreateDatetime, LastUpdateDateTime ) values ( @UserId, @MissionId, @MissionStatus, @DragonBallCount, getdate(), getdate() ); SELECT SCOPE_IDENTITY(); "; using (var cmd = new SqlCommand(sql)) { cmd.AddParameter("@UserId", model.UserId); cmd.AddParameter("@MissionId", model.MissionId); cmd.AddParameter("@MissionStatus", model.MissionStatus); cmd.AddParameter("@DragonBallCount", model.DragonBallCount); var result = await dbHelper.ExecuteScalarAsync(cmd); return(Convert.ToInt64(result)); } }