/// <summary>
/// 当天通过某种方式获得积分 一天仅一次
/// </summary>
/// <param name="dbHelper"></param>
/// <param name="data"></param>
/// <returns></returns>
public static async Task <long> InsertTodayGameUserPointDetailAsync(GameUserPointDetailModel data)
{
var sql = @" IF NOT EXISTS
(
SELECT *
FROM Activity..tbl_GameUserPointDetail
WHERE ActivityId = @ActivityId
AND UserId = @UserId
AND Status = @Status
AND DATEDIFF(dd, CreateDatetime, GETDATE()) = 0
)
INSERT INTO Activity.[dbo].[tbl_GameUserPointDetail]
(
UserId,
ActivityId,
Point,
CreateDatetime,
LastUpdateDateTime,
[Status],
IsUsed,
[Memo]
)
VALUES
(
@UserId,
@ActivityId,
@Point,
GETDATE(),
GETDATE(),
@Status,
0,
@Memo
);
SELECT SCOPE_IDENTITY();
";
using (var cmd = new SqlCommand(sql))
{
cmd.AddParameter("@ActivityId", data.ActivityId);
cmd.AddParameter("@UserId", data.UserId);
cmd.AddParameter("@Point", data.Point);
cmd.AddParameter("@Status", data.Status ?? "");
cmd.AddParameter("@Memo", data.Memo ?? "");
int.TryParse((await DbHelper.ExecuteScalarAsync(cmd)).ToString(), out int result);
return(result);
}
}
/// <summary>
/// 新增 - 小游戏 - 用户积分变动明细
/// </summary>
/// <returns></returns>
public static async Task <long> InsertGameUserPointDetailAsync(BaseDbHelper dbHelper,
GameUserPointDetailModel data)
{
var sql = @" insert into Activity.[dbo].[tbl_GameUserPointDetail]
(
UserId,
ActivityId,
Point,
CreateDatetime,
LastUpdateDateTime,
[Status],
[Memo],
IsUsed
)
values (
@UserId,
@ActivityId,
@Point,
getdate(),
getdate(),
@Status,
@Memo,
0
);
SELECT SCOPE_IDENTITY();
";
using (var cmd = new SqlCommand(sql))
{
cmd.AddParameter("@ActivityId", data.ActivityId);
cmd.AddParameter("@userId", data.UserId);
cmd.AddParameter("@Point", data.Point);
cmd.AddParameter("@Status", data.Status ?? "");
cmd.AddParameter("@Memo", data.Memo ?? "");
var result = await dbHelper.ExecuteScalarAsync(cmd);
return(Convert.ToInt64(result));
}
}
