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