serviceobject.java~83~

超值周末现场管理软件,用Excel存储数据

package service;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2006</p>
 * <p>Company: </p>
 * @author not attributable
 * @version 1.0
 */

import java.util.*;
import bean.*;
import common.Common;
import java.text.DateFormat;

public class ServiceObject {
  public ServiceObject() {
  }

  private DateFormat df = Common.getInstance().getDateFormat();

  /**
   * 存储来店礼记录
   * @param record
   * @throws DBException
   */
  public void saveLDLRecord(LDLRecord record) throws DBException {

    String sql = "insert into [来店礼$] values(?,?,?,?,?,?)";
    List params = new ArrayList();
    params.add(record.getCustomerName());
    params.add(record.getCustomerIdCard());
    params.add(record.getAccount());
    params.add(record.getAmount());
    params.add(record.getAuthNum());
    params.add(Common.getInstance().getDateFormat().format(record.getDealDate()));
    DBManager.execSql(sql, params);
  }

  /**
   * 存储满500送100记录
   * @param record
   * @throws DBException
   */
  public void saveFVORecord(FVORecord record) throws DBException {

    String sql = "insert into [满500送100$] values(?,?,?,?,?,?)";
    List params = new ArrayList();
    params.add(record.getCustomerName());
    params.add(record.getCustomerIdCard());
    params.add(record.getAccount());
    params.add(record.getAmount());
    params.add(record.getAuthNum());
    params.add(Common.getInstance().getDateFormat().format(record.getDealDate()));
    DBManager.execSql(sql, params);
  }

  /**
   * 存储一折起抢购记录
   * @param record
   * @throws DBException
   */
  public void saveYZQRecord(YZQRecord record) throws DBException, MoreThanOneRecordException,NoRecordException{
    String pSql = "select * from [一折起商品数据库$] where 商品名称 = ?";
    List pParams = Arrays.asList(new String[] {record.getProductName()});
    List product = DBManager.getMapsBySql(pSql,pParams);

    if(product.size() > 1){
      throw new MoreThanOneRecordException();
    }

    if(product.size() < 0){
      throw new NoRecordException();
    }

    Map p = (Map)product.get(0);


    String sql = "insert into [一折起抢购$] values(?,?,?,?,?,?,?,?,?";
    List params = new ArrayList();
    params.add(record.getCustomerName());
    params.add(record.getCustomerIdCard());
    params.add(record.getAccount());
    params.add(record.getAmount());
    params.add(record.getAuthNum());

    params.add(p.get("商品名称"));
    params.add(p.get("商品市价"));
    params.add(p.get("抢购价"));


    params.add(Common.getInstance().getDateFormat().format(record.getDealDate()));
    DBManager.execSql(sql, params);
  }

  /**
   * 检查来店礼身份证号是否唯一
   * @param customerIdCard
   * @param dealDate
   * @return
   * @throws DBException
   */
  public boolean checkLDLIdCardUnique(String customerIdCard, Date dealDate) throws
      DBException {

    String sql = "select 身份证号 from [来店礼$] where 身份证号 = ? and 刷卡交易日期 = ?";
    List params = new ArrayList();
    params.add(customerIdCard);
    params.add(Common.getInstance().getDateFormat().format(dealDate));

    List a = DBManager.getValueListBySql(sql, params);

    return a.size() == 0;
  }

  /**
   * 检查满500送100身份证号是否唯一
   * @param customerIdCard
   * @param dealDate
   * @return
   * @throws DBException
   */
  public boolean checkFVOIdCardUnique(String customerIdCard, Date dealDate) throws
      DBException {

    String sql = "select 身份证号 from [满500送100$] where 身份证号 = ? and 刷卡交易日期 = ?";
    List params = new ArrayList();
    params.add(customerIdCard);
    params.add(Common.getInstance().getDateFormat().format(dealDate));
    List a = DBManager.getValueListBySql(sql, params);

    return a.size() == 0;
  }

  /**
   * 检查来店礼银行卡号是否唯一
   * @param account
   * @param dealDate
   * @return
   * @throws DBException
   */
  public boolean checkLDLAccountUnique(String account, Date dealDate) throws
      DBException {

    String sql = "select 银行卡号 from [来店礼$] where 银行卡号 = ? and 刷卡交易日期 = ?";
    List params = new ArrayList();
    params.add(account);
    params.add(Common.getInstance().getDateFormat().format(dealDate));
    List a = DBManager.getValueListBySql(sql, params);
    return a.size() == 0;
  }

  /**
   * 检查满500送100银行卡号是否唯一
   * @param account
   * @param dealDate
   * @return
   * @throws DBException
   */
  public boolean checkFVOAccountUnique(String account, Date dealDate) throws
      DBException {

    String sql = "select 银行卡号 from [满500送100$] where 银行卡号 = ? and 刷卡交易日期 = ?";
    List params = new ArrayList();
    params.add(account);
    params.add(Common.getInstance().getDateFormat().format(dealDate));
    List a = DBManager.getValueListBySql(sql, params);
    return a.size() == 0;
  }

  /**
   * 检查一折起抢购身份证号是否唯一
   * @param customerIdCard
   * @param dealDate
   * @return
   * @throws DBException
   */
  public boolean checkYZQIdCardUnique(String customerIdCard, Date dealDate) throws
      DBException {
    String sql = "select 身份证号 from [一折起抢购$] where 身份证号 = ? and 刷卡交易日期 = ?";
    List params = new ArrayList();
    params.add(customerIdCard);
    params.add(Common.getInstance().getDateFormat().format(dealDate));
    List a = DBManager.getValueListBySql(sql, params);

    return a.size() == 0;

  }

  /**
   * 检查一折起抢购银行卡号是否唯一
   * @param account
   * @param dealDate
   * @return
   * @throws DBException
   */
  public boolean checkYZQAccountUnique(String account, Date dealDate) throws
      DBException {

    String sql = "select 银行卡号 from [一折起抢购$] where 银行卡号 = ? and 刷卡交易日期 = ?";
    List params = new ArrayList();
    params.add(account);
    params.add(Common.getInstance().getDateFormat().format(dealDate));
    List a = DBManager.getValueListBySql(sql, params);
    return a.size() == 0;
  }

  public List getAllProductNames() throws DBException {
    String sql = "select 商品名称 from [一折起商品数据库$]";
    List roughList = DBManager.getValueListBySql(sql, null);
    List list = new ArrayList();

    for (int i = 0; i < roughList.size(); i++) {
      List single = (List) roughList.get(i);
      list.add(single.get(0));
    }

    return list;

  }

  public static void main(String args[]) throws Exception {
    //System.out.println(DBManager.getValueListBySql("select * from [来店礼$]",null));

    /*
      List l = new ArrayList();
      l.add("chenjian");
      l.add("1");
      l.add("2");
      l.add("3");
      l.add("4");
      l.add("5");
      DBManager.execSql("insert into [满500送100$] values(?,?,?,?,?,?)", l);
     */

  }

}