PersonCardCouponsService.java
3.15 KB
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
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
package com.rnt.service;
import java.math.BigDecimal;
import java.text.ParseException;
import java.text.SimpleDateFormat;
import java.util.Date;
import org.beetl.sql.core.kit.StringKit;
import com.rnt.commo.enums.DataStateEnum;
import com.rnt.model.zf.CardCoupons;
import com.rnt.model.zf.ParkCardCoupons;
import com.rnt.vo.CardBuyVO;
import com.rnt.vo.PsersonCustCardVO;
/**
*
*
* Copyright: Copyright (c) 2017 zteits
*
* @ClassName: PersonCardCouponsService.java
* @Description:
* @version: v1.0.0
* @author: wangfs
* @date: 2017年6月9日 上午11:28:04
* Modification History:
* Date Author Version Description
*---------------------------------------------------------*
* 2017年6月9日 wangfs v1.0.0 创建
*/
public class PersonCardCouponsService {
/**
* 保存个人卡信息.<br/>
* @param cardCoupons
* @return 主键ID
* @throws ParseException
*/
public String savePersonCard(CardBuyVO cardBuyVO,ParkCardCoupons parkCardCoupons) throws ParseException{
SimpleDateFormat format = new SimpleDateFormat("yyyy-MM-dd");
SimpleDateFormat format1 = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
CardCoupons cardCoupons = new CardCoupons();
boolean insertFlg = false;
try{
cardCoupons.setParkCardId(Long.valueOf(cardBuyVO.getParkLotCardId()));
cardCoupons.setCustId(cardBuyVO.getPersonCustId());
cardCoupons.setCardBigType(parkCardCoupons.getGoodsBigType());
cardCoupons.setCardType(parkCardCoupons.getGoodsType());
cardCoupons.setCardPrice(parkCardCoupons.getGoodsAmount());
cardCoupons.setCardNum(Integer.valueOf(cardBuyVO.getBuyNum()));
cardCoupons.setCardTotalAmount(BigDecimal.valueOf(Long.parseLong(cardBuyVO.getTotleMoney())));
cardCoupons.setEffDate(format.parse(cardBuyVO.getStartDate()));
cardCoupons.setExpDate(format.parse(cardBuyVO.getEndDate()));
cardCoupons.setCardScope(parkCardCoupons.getParkId());
cardCoupons.setCarNumber(cardBuyVO.getCarNum());
cardCoupons.setRemark("微信公众号购买卡");
cardCoupons.setPushState(DataStateEnum.PUSH_STATE_NOT_VALID.getValue());
cardCoupons.setDataState(DataStateEnum.DATA_STATE_NOT_VALID.getValue());
cardCoupons.setCreateDate(format1.parse(format1.format(new Date())));
insertFlg = cardCoupons.save();
}catch (Exception e) {
e.printStackTrace();
}
return insertFlg==true ? cardCoupons.getId()+"" : "";
}
/**
* 查询个人卡券信息.<br>
* @return 个人卡券id（主键）
*/
public String queryPsersonCard(PsersonCustCardVO psersonCustCardVO){
String cardCouponsId = "";
StringBuffer sql = new StringBuffer("select a.id ");
sql.append(" from td_a_card_coupons a");
sql.append(" where card_big_type = 2 and data_state=1");
sql.append(" and a.car_number = ?");
sql.append(" and a.park_card_id = ? ");
CardCoupons cardCoupons = new CardCoupons().findFirst(sql.toString(),psersonCustCardVO.getCarNumber(),psersonCustCardVO.getParkCardId());
if(cardCoupons != null && cardCoupons.getId() != null){
cardCouponsId = cardCoupons.getId()+"";
}
return cardCouponsId;
}
}