serviceobject.java~75~

超值周末现场管理软件,用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 {

 String sql = "insert into [一折起抢购$] values(?,?,?,?,?,(select * from [一折起商品数据库$] where 商品名称 = ?),?";
 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(record.getProductName());
 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);
   */

  }


}