public IHttpActionResult Insert(MembershipScore membershipScore) { LogHelper.WriteLog("GetMembershipScoreListByUserCode membershipScore" + membershipScore?.MembershipScoreCode); SimpleResult result = new SimpleResult(); IMembershipScoreService _service = new MembershipScoreService(); try { if (UserAuthorization) { _service.Insert(membershipScore); result.Resource = null; result.Status = Result.SUCCEED; } else { result.Status = ResultType; result.Resource = ReAccessToken; result.Msg = TokenMessage; } } catch (Exception ex) { LogHelper.WriteLog("Insert获取积分:" + ex.Message, ex); LogHelper.WriteLog("Insert获取积分:" + ex.StackTrace, ex); result.Status = Result.FAILURE; result.Msg = ex.Message; } LogHelper.WriteLog("Insert result" + Json(result)); return(Json(result)); }
public MembershipScore GetMembershipScoreByCode(string code) { DynamicParameters paras = new DynamicParameters(); paras.Add("@code", code, System.Data.DbType.String); MembershipScore record = DapperSqlHelper.FindOne <MembershipScore>("select * from [dbo].[MembershipScore] where MembershipScoreCode=@code", paras, false); return(record); }
public void Insert(MembershipScore membershipScore) { DynamicParameters paras = new DynamicParameters(); if (string.IsNullOrEmpty(membershipScore.MembershipScoreCode)) { membershipScore.MembershipScoreCode = GetMaxCode(); } paras.Add("@MembershipScoreCode", membershipScore.MembershipScoreCode, System.Data.DbType.String); paras.Add("@UserCode", membershipScore.UserCode, System.Data.DbType.String); paras.Add("@Score", membershipScore.Score, System.Data.DbType.Int16); string sql = (@"insert into [dbo].[MembershipScore] (MembershipScoreCode,UserCode,Score) values(@MembershipScoreCode,@UserCode,@Score"); DapperSqlHelper.ExcuteNonQuery <Coupon>(sql, paras, false); }
public void Update(string userCode, int score) { var list = GetMembershipScoreListByUserCode(userCode); if (list == null || list.Count == 0) { MembershipScore membershipScore = new MembershipScore() { UserCode = userCode, Score = score }; Insert(membershipScore); } else { MembershipScore membershipScore = list[0]; membershipScore.Score = membershipScore.Score + score; DynamicParameters paras = new DynamicParameters(); paras.Add("@code", membershipScore.MembershipScoreCode, System.Data.DbType.String); paras.Add("@Score", membershipScore.Score, System.Data.DbType.Int32); string sql = "update [dbo].[MembershipScore] set Score=@Score where MembershipScoreCode=@code"; DapperSqlHelper.ExcuteNonQuery <MembershipScore>(sql, paras, false); } }