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