Java tutorial
package com.selfsoft.baseinformation.service.impl; import java.util.ArrayList; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import org.hibernate.criterion.DetachedCriteria; import org.hibernate.criterion.Restrictions; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import com.selfsoft.baseinformation.dao.ITbCardHisDao; import com.selfsoft.baseinformation.dao.ITmCardTypeDao; import com.selfsoft.baseinformation.model.TbCardHis; import com.selfsoft.baseinformation.model.TbMembershipCard; import com.selfsoft.baseinformation.service.ITbCardHisService; import com.selfsoft.baseinformation.service.ITmCardTypeService; import com.selfsoft.framework.common.CommonMethod; import com.selfsoft.framework.common.Constants; import com.selfsoft.secrity.model.TmUser; import com.selfsoft.secrity.service.ITmUserService; @Service("tbCardHisService") public class TbCardHisServiceImpl implements ITbCardHisService { @Autowired private ITbCardHisDao tbCardHisDao; @Autowired private ITmCardTypeService tmCardTypeService; @Autowired private ITmUserService tmUserService; public List<TbCardHis> findByTbCardHis(TbCardHis tbCardHis) { DetachedCriteria detachedCriteria = DetachedCriteria.forClass(TbCardHis.class); if (null != tbCardHis) { if (null != tbCardHis.getCardNo() && !"".equals(tbCardHis.getCardNo())) { detachedCriteria.add(Restrictions.like("cardNo", "%" + tbCardHis.getCardNo() + "%")); } if (null != tbCardHis.getOperationDateFrom()) { detachedCriteria.add(Restrictions.ge("operationDate", tbCardHis.getOperationDateFrom())); } if (null != tbCardHis.getOperationDateTo()) { detachedCriteria.add( Restrictions.le("operationDate", CommonMethod.addDate(tbCardHis.getOperationDateTo(), 1))); } if (null != tbCardHis.getLicenseCode() && !"".equals(tbCardHis.getLicenseCode())) { detachedCriteria.add(Restrictions.like("licenseCode", "%" + tbCardHis.getLicenseCode() + "%")); } if (null != tbCardHis.getOperationType() && !"".equals(tbCardHis.getOperationType())) { detachedCriteria.add(Restrictions.eq("operationType", tbCardHis.getOperationType())); } if (null != tbCardHis.getBalanceCode() && !"".equals(tbCardHis.getBalanceCode())) { detachedCriteria.add(Restrictions.like("balanceCode", "%" + tbCardHis.getBalanceCode() + "%")); } if (null != tbCardHis.getCustomerCode() && !"".equals(tbCardHis.getCustomerCode())) { detachedCriteria.add(Restrictions.eq("customerCode", tbCardHis.getCustomerCode())); } if (null != tbCardHis.getCustomerName() && !"".equals(tbCardHis.getCustomerName())) { detachedCriteria.add(Restrictions.eq("customerName", tbCardHis.getCustomerName())); } } else { return null; } /*List<TbCardHis> list = tbCardHisDao.findByCriteria(detachedCriteria, tbCardHis); List<TbCardHis> tbCardHisList = null; if(null != list && list.size() > 0){ tbCardHisList = new ArrayList<TbCardHis>(); for(TbCardHis _tbCardHis : list){ TmUser tmUser = tmUserService.findById(_tbCardHis.getUserId()); _tbCardHis.setTmUser(tmUser); tbCardHisList.add(_tbCardHis); } }*/ return tbCardHisDao.findByCriteria(detachedCriteria, tbCardHis); } /** * ? * */ public void insertCardHis(TbMembershipCard tbMembershipCard, TmUser tmUser, String desc) { TbCardHis tbCardHis = new TbCardHis(); tbCardHis.setCardId(tbMembershipCard.getId()); tbCardHis.setCardNo(tbMembershipCard.getCardNo()); /** * ??? */ tbCardHis.setOriCardPoint(tbMembershipCard.getOriCardPoint()); tbCardHis.setOriCardSaving(tbMembershipCard.getOriCardSaving()); tbCardHis.setAftCardPoint(tbMembershipCard.getCardPoint()); tbCardHis.setAftCardSaving(tbMembershipCard.getCardSaving()); tbCardHis.setGiveMoney(tbMembershipCard.getGiveMoney()); tbCardHis.setGivePoint(tbMembershipCard.getGivePoint()); tbCardHis.setCzje(tbMembershipCard.getCzje()); tbCardHis.setOperationDate(new Date()); tbCardHis.setOperationDesc(desc); tbCardHis.setOperationType(Constants.CARD_XG); //tbCardHis.setUserId(userId); tbCardHis.setLicenseCode(tbMembershipCard.getLicenseCode()); tbCardHis.setUserName(tmUser.getUserName()); tbCardHis.setUserRealName(tmUser.getUserRealName()); tbCardHis.setCustomerId(tbMembershipCard.getTbCustomer().getId()); tbCardHis.setCustomerCode(tbMembershipCard.getTbCustomer().getCustomerCode()); tbCardHis.setCustomerName(tbMembershipCard.getTbCustomer().getCustomerName()); tbCardHisDao.insert(tbCardHis); } /** * ? * @param tbMembershipCard * @param userId */ public void insertCzCardHis(TbMembershipCard tbMembershipCard, TmUser tmUser) { TbCardHis tbCardHis = new TbCardHis(); tbCardHis.setCardId(tbMembershipCard.getId()); tbCardHis.setCardNo(tbMembershipCard.getCardNo()); /** * ??? */ tbCardHis.setOriCardPoint(tbMembershipCard.getOriCardPoint()); tbCardHis.setOriCardSaving(tbMembershipCard.getOriCardSaving()); tbCardHis.setAftCardPoint(tbMembershipCard.getCardPoint()); tbCardHis.setAftCardSaving(tbMembershipCard.getCardSaving()); tbCardHis.setGiveMoney(tbMembershipCard.getGiveMoney()); tbCardHis.setGivePoint(tbMembershipCard.getGivePoint()); tbCardHis.setCzje(tbMembershipCard.getCzje()); tbCardHis.setOperationDate(new Date()); tbCardHis.setOperationDesc("?? " + tbMembershipCard.getCzje() + ",?? " + tbMembershipCard.getOriCardSaving() + ",? " + tbMembershipCard.getOriCardPoint() + ",??? " + tbMembershipCard.getCardSaving() + ",?? " + tbMembershipCard.getCardPoint() + ""); tbCardHis.setOperationType(Constants.CARD_CZ); //tbCardHis.setUserId(userId); tbCardHis.setLicenseCode(tbMembershipCard.getLicenseCode()); tbCardHis.setUserName(tmUser.getUserName()); tbCardHis.setUserRealName(tmUser.getUserRealName()); tbCardHis.setCustomerId(tbMembershipCard.getTbCustomer().getId()); tbCardHis.setCustomerCode(tbMembershipCard.getTbCustomer().getCustomerCode()); tbCardHis.setCustomerName(tbMembershipCard.getTbCustomer().getCustomerName()); tbCardHisDao.insert(tbCardHis); } /** * ?? * @param tbMembershipCard * @param userId */ public void insertKkCardHis(TbMembershipCard tbMembershipCard, TmUser tmUser) { TbCardHis tbCardHis = new TbCardHis(); tbCardHis.setCardId(tbMembershipCard.getId()); tbCardHis.setCardNo(tbMembershipCard.getCardNo()); tbCardHis.setOriCardPoint(0l); tbCardHis.setOriCardSaving(0d); tbCardHis.setAftCardPoint(tbMembershipCard.getCardPoint()); tbCardHis.setAftCardSaving(tbMembershipCard.getCardSaving()); tbCardHis.setOperationDate(new Date()); tbCardHis.setOperationDesc("??" + tbMembershipCard.getTbCustomer().getCustomerCode() + "?" + tbMembershipCard.getTbCustomer().getCustomerName() + "??" + tbMembershipCard.getTmCardType().getCardDesc() + "???" + tbMembershipCard.getCardNo() + "??? " + tbMembershipCard.getCardSaving() + ";? ?" + tbMembershipCard.getCardPoint() + ""); tbCardHis.setOperationType(Constants.CARD_KK); //tbCardHis.setUserId(userId); tbCardHis.setLicenseCode(tbMembershipCard.getLicenseCode()); tbCardHis.setUserName(tmUser.getUserName()); tbCardHis.setUserRealName(tmUser.getUserRealName()); tbCardHis.setCustomerId(tbMembershipCard.getTbCustomer().getId()); tbCardHis.setCustomerName(tbMembershipCard.getTbCustomer().getCustomerName()); tbCardHis.setCustomerCode(tbMembershipCard.getTbCustomer().getCustomerCode()); tbCardHisDao.insert(tbCardHis); } /** * ? * @param tbMembershipCard * @param userId */ public void insertCjfCardHis(TbMembershipCard tbMembershipCard, TmUser tmUser) { TbCardHis tbCardHis = new TbCardHis(); tbCardHis.setCardId(tbMembershipCard.getId()); tbCardHis.setCardNo(tbMembershipCard.getCardNo()); /** * ??? */ tbCardHis.setOriCardPoint(tbMembershipCard.getOriCardPoint()); tbCardHis.setOriCardSaving(tbMembershipCard.getOriCardSaving()); tbCardHis.setAftCardPoint(tbMembershipCard.getCardPoint()); tbCardHis.setAftCardSaving(tbMembershipCard.getCardSaving()); tbCardHis.setGiveMoney(tbMembershipCard.getGiveMoney()); tbCardHis.setGivePoint(tbMembershipCard.getGivePoint()); tbCardHis.setCzjf(tbMembershipCard.getCzjf()); tbCardHis.setOperationDate(new Date()); tbCardHis.setOperationDesc("?? " + tbMembershipCard.getCzjf() + ",?? " + tbMembershipCard.getOriCardSaving() + ",? " + tbMembershipCard.getOriCardPoint() + ",??? " + tbMembershipCard.getCardSaving() + ",?? " + tbMembershipCard.getCardPoint() + ""); tbCardHis.setOperationType(Constants.CARD_CJF); //tbCardHis.setUserId(userId); tbCardHis.setLicenseCode(tbMembershipCard.getLicenseCode()); tbCardHis.setUserName(tmUser.getUserName()); tbCardHis.setUserRealName(tmUser.getUserRealName()); tbCardHis.setCustomerId(tbMembershipCard.getTbCustomer().getId()); tbCardHis.setCustomerName(tbMembershipCard.getTbCustomer().getCustomerName()); tbCardHis.setCustomerCode(tbMembershipCard.getTbCustomer().getCustomerCode()); tbCardHisDao.insert(tbCardHis); } /** * ??? * @param tbMembershipCard * @param userId */ public void insertHkCardHis(TbMembershipCard tbMembershipCard, TmUser tmUser) { TbCardHis tbCardHis = new TbCardHis(); tbCardHis.setCardId(tbMembershipCard.getId()); tbCardHis.setCardNo(tbMembershipCard.getCardNo()); tbCardHis.setOriCardPoint(tbMembershipCard.getCardPoint()); tbCardHis.setOriCardSaving(tbMembershipCard.getCardSaving()); tbCardHis.setAftCardPoint(tbMembershipCard.getCardPoint()); tbCardHis.setAftCardSaving(tbMembershipCard.getCardSaving()); tbCardHis.setOperationDate(new Date()); tbCardHis.setOperationDesc("??? " + tbMembershipCard.getPreviousCardNo() + ";??? " + tbMembershipCard.getCardNo() + "?? " + tbMembershipCard.getCardSaving() + ",? " + tbMembershipCard.getCardPoint() + ",??? " + tbMembershipCard.getCardSaving() + ",?? " + tbMembershipCard.getCardPoint() + ""); tbCardHis.setOperationType(Constants.CARD_HK); //tbCardHis.setUserId(userId); tbCardHis.setLicenseCode(tbMembershipCard.getLicenseCode()); tbCardHis.setUserName(tmUser.getUserName()); tbCardHis.setUserRealName(tmUser.getUserRealName()); tbCardHis.setCustomerId(tbMembershipCard.getTbCustomer().getId()); tbCardHis.setCustomerName(tbMembershipCard.getTbCustomer().getCustomerName()); tbCardHis.setCustomerCode(tbMembershipCard.getTbCustomer().getCustomerCode()); tbCardHisDao.insert(tbCardHis); } /** * * @param tbMembershipCard * @param tmUser */ public void insertJSCardHis(TbMembershipCard tbMembershipCard, TmUser tmUser) { TbCardHis tbCardHis = new TbCardHis(); tbCardHis.setCardId(tbMembershipCard.getId()); tbCardHis.setCardNo(tbMembershipCard.getCardNo()); /** * ?? */ tbCardHis.setOriCardPoint(tbMembershipCard.getOriCardPoint()); tbCardHis.setOriCardSaving(tbMembershipCard.getOriCardSaving()); /** * ?? */ tbCardHis.setAftCardPoint(tbMembershipCard.getCardPoint()); tbCardHis.setAftCardSaving(tbMembershipCard.getCardSaving()); /** * ? */ tbCardHis.setGsGiveMoney(tbMembershipCard.getGsGiveMoney()); /** *?? */ tbCardHis.setPjGiveMoney(tbMembershipCard.getPjGiveMoney()); /** * */ tbCardHis.setGsGivePoint(tbMembershipCard.getGsGivePoint()); /** * ? */ tbCardHis.setPjGivePoint(tbMembershipCard.getPjGivePoint()); /** * ? */ tbCardHis.setGiveMoney(tbMembershipCard.getGiveMoney()); /** * */ tbCardHis.setGivePoint(tbMembershipCard.getGivePoint()); /** * ? */ tbCardHis.setJexf(tbMembershipCard.getJexf()); /** * */ tbCardHis.setJfxf(0); /** * ? */ tbCardHis.setGsJexf(tbMembershipCard.getGsJexf()); /** * ?? */ tbCardHis.setPjJexf(tbMembershipCard.getPjJexf()); tbCardHis.setOperationDate(new Date()); tbCardHis.setOperationDesc("??" + tbMembershipCard.getBalanceCode() + "?" + tbCardHis.getJexf() + ",?" + tbCardHis.getGsJexf() + "?" + tbCardHis.getGsGiveMoney() + "?" + tbCardHis.getGsGivePoint() + ",??" + tbCardHis.getPjJexf() + "?" + tbCardHis.getPjGiveMoney() + "?" + tbCardHis.getPjGivePoint() + ",?" + tbMembershipCard.getYhMoney() + "?" + tbMembershipCard.getYhMinusPoint() + ",?" + tbCardHis.getGiveMoney() + "?" + tbCardHis.getGivePoint() + ",??" + tbMembershipCard.getCardZFJE() + ",??" + tbMembershipCard.getDhMoney() + ""); tbCardHis.setBalanceCode(tbMembershipCard.getBalanceCode()); tbCardHis.setBalanceId(tbMembershipCard.getBalanceId()); tbCardHis.setOperationType(Constants.CARD_JS); //tbCardHis.setUserId(userId); tbCardHis.setLicenseCode(tbMembershipCard.getLicenseCode()); tbCardHis.setUserName(tmUser.getUserName()); tbCardHis.setUserRealName(tmUser.getUserRealName()); tbCardHis.setCustomerId(tbMembershipCard.getPayTbCustomer().getId()); tbCardHis.setCustomerName(tbMembershipCard.getPayTbCustomer().getCustomerName()); tbCardHis.setCustomerCode(tbMembershipCard.getPayTbCustomer().getCustomerCode()); tbCardHisDao.insert(tbCardHis); } /** * * @param tbMembershipCard * @param tmUser */ public void insertSmartBalanceCardHis(TbMembershipCard tbMembershipCard, TmUser tmUser) { TbCardHis tbCardHis = new TbCardHis(); tbCardHis.setCardId(tbMembershipCard.getId()); tbCardHis.setCardNo(tbMembershipCard.getCardNo()); /** * ?? */ tbCardHis.setOriCardPoint(tbMembershipCard.getOriCardPoint()); tbCardHis.setOriCardSaving(tbMembershipCard.getOriCardSaving()); /** * ?? */ tbCardHis.setAftCardPoint(tbMembershipCard.getCardPoint()); tbCardHis.setAftCardSaving(tbMembershipCard.getCardSaving()); /** * ? */ tbCardHis.setJexf(tbMembershipCard.getJexf()); /** * */ //tbCardHis.setJfxf(0); tbCardHis.setOperationDate(new Date()); tbCardHis.setOperationDesc(tbMembershipCard.getServiceName() + ",?" + tbCardHis.getJexf() + ",??" + tbMembershipCard.getJexf() + ".?? " + tbMembershipCard.getOriCardSaving() + ",? " + tbMembershipCard.getOriCardPoint() + ",??? " + tbMembershipCard.getCardSaving() + ",?? " + tbMembershipCard.getCardPoint() + ""); tbCardHis.setOperationType(Constants.CARD_JS); tbCardHis.setLicenseCode(tbMembershipCard.getLicenseCode()); tbCardHis.setUserName(tmUser.getUserName()); tbCardHis.setUserRealName(tmUser.getUserRealName()); tbCardHis.setCustomerId(tbMembershipCard.getTbCustomer().getId()); tbCardHis.setCustomerName(tbMembershipCard.getTbCustomer().getCustomerName()); tbCardHis.setCustomerCode(tbMembershipCard.getTbCustomer().getCustomerCode()); tbCardHisDao.insert(tbCardHis); } /** * * @param tbMembershipCard * @param tmUser */ public void insertSmartBalanceUseServiceCardHis(TbMembershipCard tbMembershipCard, TmUser tmUser) { TbCardHis tbCardHis = new TbCardHis(); tbCardHis.setCardId(tbMembershipCard.getId()); tbCardHis.setCardNo(tbMembershipCard.getCardNo()); /** * ?? */ tbCardHis.setOriCardPoint(tbMembershipCard.getOriCardPoint()); tbCardHis.setOriCardSaving(tbMembershipCard.getOriCardSaving()); /** * ?? */ tbCardHis.setAftCardPoint(tbMembershipCard.getCardPoint()); tbCardHis.setAftCardSaving(tbMembershipCard.getCardSaving()); /** * ? */ tbCardHis.setJexf(tbMembershipCard.getJexf()); /** * */ //tbCardHis.setJfxf(0); tbCardHis.setOperationDate(new Date()); tbCardHis.setOperationDesc(tbMembershipCard.getServiceName() + ",?" + tbCardHis.getJexf() + ",???" + tbMembershipCard.getServiceName() + "1.?? " + tbMembershipCard.getOriCardSaving() + ",? " + tbMembershipCard.getOriCardPoint() + ",??? " + tbMembershipCard.getCardSaving() + ",?? " + tbMembershipCard.getCardPoint() + ""); tbCardHis.setOperationType(Constants.CARD_JS); tbCardHis.setLicenseCode(tbMembershipCard.getLicenseCode()); tbCardHis.setUserName(tmUser.getUserName()); tbCardHis.setUserRealName(tmUser.getUserRealName()); tbCardHis.setCustomerId(tbMembershipCard.getTbCustomer().getId()); tbCardHis.setCustomerName(tbMembershipCard.getTbCustomer().getCustomerName()); tbCardHis.setCustomerCode(tbMembershipCard.getTbCustomer().getCustomerCode()); tbCardHisDao.insert(tbCardHis); } /** * ??? */ public Map putCardHisReportParamMap(List<TbCardHis> tbCardHisList, HttpServletRequest request) { @SuppressWarnings("rawtypes") Map map = new HashMap(); map.put("dataSourceList", tbCardHisList); map.put("jrxmlPath", "/reportfiles/tbCardHis.jrxml"); map.put("reportTpl", "/tbCardHis_pdf_tpl.properties"); return map; } /** * ? * @param tbMembershipCard * @param userId */ public void insertJfxfCardHis(TbMembershipCard tbMembershipCard, TmUser tmUser) { TbCardHis tbCardHis = new TbCardHis(); tbCardHis.setCardId(tbMembershipCard.getId()); tbCardHis.setCardNo(tbMembershipCard.getCardNo()); /** * ??? */ tbCardHis.setOriCardPoint(tbMembershipCard.getOriCardPoint()); tbCardHis.setOriCardSaving(tbMembershipCard.getOriCardSaving()); tbCardHis.setAftCardPoint(tbMembershipCard.getCardPoint()); tbCardHis.setAftCardSaving(tbMembershipCard.getCardSaving()); tbCardHis.setGiveMoney(0); tbCardHis.setGivePoint(0); tbCardHis.setCzjf(tbMembershipCard.getCzjf()); tbCardHis.setOperationDate(new Date()); tbCardHis.setOperationDesc("? " + tbMembershipCard.getCzjf() + "," + tbMembershipCard.getRemark() + ",?? " + tbMembershipCard.getOriCardSaving() + ",? " + tbMembershipCard.getOriCardPoint() + ",??? " + tbMembershipCard.getCardSaving() + ",?? " + tbMembershipCard.getCardPoint() + ""); tbCardHis.setOperationType(Constants.CARD_JFXF); //tbCardHis.setUserId(userId); tbCardHis.setLicenseCode(tbMembershipCard.getLicenseCode()); tbCardHis.setUserName(tmUser.getUserName()); tbCardHis.setUserRealName(tmUser.getUserRealName()); tbCardHis.setCustomerId(tbMembershipCard.getTbCustomer().getId()); tbCardHis.setCustomerName(tbMembershipCard.getTbCustomer().getCustomerName()); tbCardHis.setCustomerCode(tbMembershipCard.getTbCustomer().getCustomerCode()); tbCardHisDao.insert(tbCardHis); } public List<TbCardHis> findCardHisByBalanceId(Long balanceId) { return tbCardHisDao.findBySQL( "select tbCardHis from TbCardHis tbCardHis where tbCardHis.balanceId =" + balanceId, null); } }