mainframe.java~310~

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

  }

  private void showMsgs(java.util.List msgs) {
    StringBuffer sb = new StringBuffer();
    for (int i = 0; i < msgs.size(); i++) {
      sb.append(msgs.get(i) + "\n");
    }

    JOptionPane.showMessageDialog(this, sb);

  }

  void ldl_ok_actionPerformed(ActionEvent e) {
    String customerName = ldlCustomerNameTxt.getText().trim();
    String customerIdCard = ldlCustomerIDCardTxt.getText().trim();
    String account = ldlAccountTxt.getText().trim();
    String amount = ldlAmountTxt.getText().trim();
    String authNum = ldlAuthNumTxt.getText().trim();
    String dateString = ldlDealDateTxt.getText().trim();

    Map map = new HashMap();
    map.put("customerName", customerName);
    map.put("customerIdCard", customerIdCard);
    map.put("account", account);
    map.put("amount", amount);
    map.put("authNum", authNum);
    map.put("dateString", dateString);

    ArrayList errors = new ArrayList();
    boolean inputValid = lrv.isRecordValid(map, errors);

    if (!inputValid) {
      showMsgs(errors);
      return;
    }

    Date dealDate = null;
    try {
      dealDate = Common.getInstance().getDateFormat().parse(dateString);
    }
    catch (ParseException ex) {
      java.util.List er = Arrays.asList(new Object[] {"交易日期不合格式"});
      this.showMsgs(er);
      return;
    }

    //核对身份证唯一性


    if(!StringUtils.isBlank(customerIdCard)){
      boolean idCardUnique = true;
    try {
      idCardUnique = so.checkLDLIdCardUnique(customerIdCard, dealDate);
    }
    catch (DBException ex2) {
      logger.error("",ex2);
      java.util.List er = Arrays.asList(new Object[] {dbError});
      this.showMsgs(er);
      return;
    }
    if (!idCardUnique) {
      java.util.List er = Arrays.asList(new Object[] {"此身份证号已于当日使用"});
      this.showMsgs(er);
      return;
    }


    }


    //核对银行卡唯一性
    boolean accountUnique = true;
    try {
      accountUnique = so.checkLDLAccountUnique(account, dealDate);
    }
    catch (DBException ex2) {
       logger.error("",ex2);
      java.util.List er = Arrays.asList(new Object[] {dbError});
      this.showMsgs(er);
      return;
    }

    if (!accountUnique) {
      java.util.List er = Arrays.asList(new Object[] {"此银行卡号已于当日使用"});
      this.showMsgs(er);
      return;
    }

    //生成Bean
    LDLRecord ldlRecord = new LDLRecord(customerName, customerIdCard, account,
                                        amount, authNum, dealDate);

    //插入
    try {
      so.saveLDLRecord(ldlRecord);
    }
    catch (DBException ex1) {
       logger.error("",ex1);
      java.util.List er = Arrays.asList(new Object[] {dbError});
      this.showMsgs(er);
      return;
    }

    ldl_resetAllFields();
    return;
  }

  void ldl_reset_actionPerformed(ActionEvent e) {
    ldl_resetAllFields();
  }

  void ldl_resetAllFields() {
    ldlCustomerNameTxt.setText("");
    ldlCustomerIDCardTxt.setText("");
    ldlAccountTxt.setText("");
    ldlAmountTxt.setText("");
    ldlAuthNumTxt.setText("");
    ldlDealDateTxt.setText(Common.getInstance().getDateFormat().format(new Date()));

  }

  void fvo_resetAllFields() {
    fvoCustomerNameTxt.setText("");
    fvoCustomerIDCardTxt.setText("");
    fvoAccountTxt.setText("");
    fvoAmountTxt.setText("");
    fvoAuthNumTxt.setText("");
    fvoDealDateTxt.setText(Common.getInstance().getDateFormat().format(new Date()));
  }

  void yzq_resetAllFields() {
    yzqCustomerNameTxt.setText("");
    yzqCustomerIDCardTxt.setText("");
    yzqAccountTxt.setText("");
    yzqAmountTxt.setText("");
    yzqAuthNumTxt.setText("");
    yzqDealDateTxt.setText(Common.getInstance().getDateFormat().format(new Date()));
    yzqProductNameCmb.setSelectedItem("");
  }

  void check_fvodcard_unique_actionPerformed(ActionEvent e) {
    String customerIdCard = this.fvoCustomerIDCardTxt.getText().trim();
    String dateString = this.fvoDealDateTxt.getText().trim();

    java.util.List errors = new ArrayList();
    boolean idCardValid = frv.isCustomerIdCardValid(customerIdCard, errors);
    boolean dateValid = frv.isDealDateValid(dateString, errors);
    boolean inputValid = idCardValid && dateValid;
    if (!inputValid) {
      showMsgs(errors);
      return;
    }

    Date dealDate = null;
    try {
      dealDate = Common.getInstance().getDateFormat().parse(dateString);
    }
    catch (ParseException ex) {
      java.util.List er = Arrays.asList(new Object[] {"交易日期不合格式"});
      this.showMsgs(er);
      return;
    }

    boolean isUnique = false;
    try {
      isUnique = so.checkFVOIdCardUnique(customerIdCard, dealDate);
    }
    catch (DBException ex) {
       logger.error("",ex);
      java.util.List er = Arrays.asList(new Object[] {dbError});
      this.showMsgs(er);
      return;

    }

    if (!isUnique) {
      java.util.List er = Arrays.asList(new Object[] {"此身份证号已于当日使用"});
      this.showMsgs(er);
      return;
    }
    else {
      java.util.List ok = Arrays.asList(new Object[] {"尚未于当日使用"});
      this.showMsgs(ok);
      return;
    }

  }

  void fvo_reset_actionPerformed(ActionEvent e) {
    fvo_resetAllFields();
  }

  void check_fvoAccount_unique_actionPerformed(ActionEvent e) {
    String dateString = this.fvoDealDateTxt.getText().trim();
    String account = fvoAccountTxt.getText().trim();

    java.util.List errors = new ArrayList();
    boolean accountValid = frv.isAccountValid(account, errors);
    boolean dateValid = frv.isDealDateValid(dateString, errors);
    boolean inputValid = accountValid && dateValid;

    if (!inputValid) {
      showMsgs(errors);
      return;
    }

    Date dealDate = null;
    try {
      dealDate = Common.getInstance().getDateFormat().parse(dateString);
    }
    catch (ParseException ex) {
      java.util.List er = Arrays.asList(new Object[] {"交易日期不合格式"});
      this.showMsgs(er);
      return;
    }

    boolean isUnique = false;

    try {
      isUnique = so.checkFVOAccountUnique(account, dealDate);
    }
    catch (DBException ex1) {
       logger.error("",ex1);
      java.util.List er = Arrays.asList(new Object[] {dbError});
      this.showMsgs(er);
      return;
    }

    if (!isUnique) {
      java.util.List er = Arrays.asList(new Object[] {"此银行卡号已于当日使用"});
      this.showMsgs(er);
      return;
    }
    else {
      java.util.List ok = Arrays.asList(new Object[] {"尚未于当日使用"});
      this.showMsgs(ok);
      return;
    }

  }

  /**
   * 按下“满500送100”--“确定”按钮
   * @param e
   */
  void fvo_ok_actionPerformed(ActionEvent e) {
    String customerName = fvoCustomerNameTxt.getText().trim();
    String customerIdCard = fvoCustomerIDCardTxt.getText().trim();
    String account = fvoAccountTxt.getText().trim();
    String amount = fvoAmountTxt.getText().trim();
    String authNum = fvoAuthNumTxt.getText().trim();
    String dateString = fvoDealDateTxt.getText().trim();

    Map map = new HashMap();
    map.put("customerName", customerName);
    map.put("customerIdCard", customerIdCard);
    map.put("account", account);
    map.put("amount", amount);
    map.put("authNum", authNum);
    map.put("dateString", dateString);

    ArrayList errors = new ArrayList();
    boolean inputValid = frv.isRecordValid(map, errors);

    if (!inputValid) {
      showMsgs(errors);
      return;
    }

    Date dealDate = null;
    try {
      dealDate = Common.getInstance().getDateFormat().parse(dateString);
    }
    catch (ParseException ex) {
      java.util.List er = Arrays.asList(new Object[] {"交易日期不合格式"});
      this.showMsgs(er);
      return;
    }

    //核对身份证唯一性
    boolean idCardUnique = true;
    try {
      idCardUnique = so.checkFVOIdCardUnique(customerIdCard, dealDate);
    }
    catch (DBException ex2) {
       logger.error("",ex2);
      java.util.List er = Arrays.asList(new Object[] {dbError});
      this.showMsgs(er);
      return;
    }
    if (!idCardUnique) {
      java.util.List er = Arrays.asList(new Object[] {"此身份证号已于当日使用"});
      this.showMsgs(er);
      return;
    }

    //核对银行卡唯一性
    boolean accountUnique = true;
    try {
      accountUnique = so.checkFVOAccountUnique(account, dealDate);
    }
    catch (DBException ex2) {
       logger.error("",ex2);
      java.util.List er = Arrays.asList(new Object[] {dbError});
      this.showMsgs(er);
      return;
    }

    if (!accountUnique) {
      java.util.List er = Arrays.asList(new Object[] {"此银行卡号已于当日使用"});
      this.showMsgs(er);
      return;
    }

    //生成Bean
    FVORecord fvoRecord = new FVORecord(customerName, customerIdCard, account,
                                        amount, authNum, dealDate);

    //插入
    try {
      so.saveFVORecord(fvoRecord);
    }
    catch (DBException ex1) {
       logger.error("",ex1);
      java.util.List er = Arrays.asList(new Object[] {dbError});
      this.showMsgs(er);
      return;
    }

    fvo_resetAllFields();
    return;
  }

  void yzq_reset_actionPerformed(ActionEvent e) {
    yzq_resetAllFields();
  }

  void check_yzqdcard_unique_actionPerformed(ActionEvent e) {
    String customerIdCard = this.yzqCustomerIDCardTxt.getText().trim();
    String dateString = this.yzqDealDateTxt.getText().trim();

    java.util.List errors = new ArrayList();
    boolean idCardValid = yrv.isCustomerIdCardValid(customerIdCard, errors);
    boolean dateValid = yrv.isDealDateValid(dateString, errors);
    boolean inputValid = idCardValid && dateValid;
    if (!inputValid) {
      showMsgs(errors);
      return;
    }