init

cy

2022-06-21 129904537f66509f97b285e7eb4f42b3dc349dd0

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
package cn.ksource.web.service.record;
 
import java.util.HashMap;
import java.util.Map;
 
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
 
import cn.ksource.core.dao.BaseDao;
import cn.ksource.core.util.ConvertUtil;
import cn.ksource.core.util.DateUtil;
import cn.ksource.core.util.StringUtil;
import cn.ksource.web.Constants;
import cn.ksource.web.interfacee.InterfaceFacade;
 
@SuppressWarnings("unchecked")
@Service("scoreService")
public class ScoreServiceImpl implements ScoreService {
 
    @Autowired
    private BaseDao baseDao;
    
    @Autowired
    private InterfaceFacade interfaceFacade;
 
    @Override
    public void addScore(String userId, String scoreKey) {
        
        Map dic = interfaceFacade.getDataDictionaryByKey(scoreKey);
        String reason = ConvertUtil.obj2StrBlank(dic.get("BEIZ"));
        int addCount = ConvertUtil.obj2Int(dic.get("DATAVALUE"));
        
        String scoreRecord = "INSERT INTO NS_SCORE_RECODE(ID,MEMBER_ID,REASON,SCORE_NUM,ADD_TIME,TYPE) VALUES (:id,:userId,:reason,:addCount,:addTime,1)";
        String addScoreSql = "UPDATE NS_MEMBER SET SCORE_NUM = SCORE_NUM + :addCount WHERE ID = :userId";
        Map paramMap = new HashMap();
        paramMap.put("id", StringUtil.getUUID());
        paramMap.put("userId", userId);
        paramMap.put("reason", reason);
        paramMap.put("addCount", addCount);
        paramMap.put("addTime", DateUtil.getCurrentDate14());
        
        baseDao.execute(scoreRecord, paramMap);
        baseDao.execute(addScoreSql, paramMap);
    }
 
    
    
    @Override
    public void reduceScore(String userId, String reason, int reduceCount) {
        String scoreRecord = "INSERT INTO NS_SCORE_RECODE(ID,MEMBER_ID,REASON,SCORE_NUM,ADD_TIME,TYPE) VALUES (:id,:userId,:reason,:reduceCount,:addTime,2)";
        String addScoreSql = "UPDATE NS_MEMBER SET SCORE_NUM = SCORE_NUM - :reduceCount WHERE ID = :userId";
        Map paramMap = new HashMap();
        paramMap.put("id", StringUtil.getUUID());
        paramMap.put("userId", userId);
        paramMap.put("reason", reason);
        paramMap.put("reduceCount", reduceCount);
        paramMap.put("addTime", DateUtil.getCurrentDate14());
        
        baseDao.execute(scoreRecord, paramMap);
        baseDao.execute(addScoreSql, paramMap);
    }
 
 
    
 
    
    
    
}