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