goodscanceldao.java~13~

销售管理系统 随着我国国民经济的持续发展

package com.dao;

import java.util.*;
import java.sql.*;
import com.tool.JDBConnection;
import com.domain.GoodsCancelVO;

//退货信息
public class GoodsCancelDao {
  private JDBConnection connection = null;
  public GoodsCancelDao() {
    connection = new JDBConnection();
    this.connection.creatConnection(); //利用构造方法调用类中的对象对数据库创建连接
  }

//添加退货信息
  public void cancelInsert(GoodsCancelVO vo) {
    String sql = "insert into tb_goodsCancel values ('" + vo.getCancel_number() +
        "','" + vo.getAccounts() + "','" + vo.getGoods_number() +
        "','" + vo.getOrder_number() + "','" + vo.getReason() + "','" +
        vo.getBack() + "','" + vo.getMoney() + "','" + vo.getEmployeeNumber() +
        "','" + vo.getNumber() + "',getDate(),'" + vo.getClient() + "')";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

  public GoodsCancelVO cancelSelectOne(String number) {
    GoodsCancelVO vo = null;
    String sql = "select * from tb_goodsCancel where cancel_number='" + number +
        "'";
    ResultSet rs = connection.executeQuery(sql);
    try {
      while (rs.next()) {
        vo = new GoodsCancelVO();
        vo.setId(Integer.valueOf(rs.getString(1)));
        vo.setCancel_number(rs.getString(2));
        vo.setAccounts(rs.getString(3));
        vo.setGoods_number(rs.getString(4));
        vo.setOrder_number(rs.getString(5));
        vo.setReason(rs.getString(6));
        vo.setBack(Integer.parseInt(rs.getString(7)));
        vo.setMoney(Float.parseFloat(rs.getString(8)));
        vo.setEmployeeNumber(rs.getString(9));
        vo.setNumber(rs.getString(10));
        vo.setCancelTime(rs.getString(11));
        vo.setClient(rs.getString(12));
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return vo;
  }

  public void cancelUpdateNumber(Integer id, String number) {
    String unNumber = "cancel-" + String.valueOf(id);
    String sql = "update tb_goodsCancel set cancel_number='" + unNumber +
        "'  where cancel_number='" + number + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }


  public List goodsCancelSelectTime(String start, String over, int title) {
      List list = new ArrayList();
      GoodsCancelVO vo = null;
      String startime = start + " " + "00:00:00";
      String overtime = over + " " + "00:00:00";
      String sql = "";
      if (over == null) {
        sql = "select * from tb_goodsOrder where ordertime  between '" + startime +
            "' and getDate() and title='" + title + "'";
      }
      else {
        sql = "select * from tb_goodsOrder where ordertime  between '"+startime+"' and '"+over+"' and title='"+title+"'";
      }
      ResultSet rs = connection.executeQuery(sql);
      System.out.println("sql="+sql);
      try {
        while (rs.next()) {
          vo = new GoodsCancelVO();
        vo.setId(Integer.valueOf(rs.getString(1)));
        vo.setCancel_number(rs.getString(2));
        vo.setAccounts(rs.getString(3));
        vo.setGoods_number(rs.getString(4));
        vo.setOrder_number(rs.getString(5));
        vo.setReason(rs.getString(6));
        vo.setBack(Integer.parseInt(rs.getString(7)));
        vo.setMoney(Float.parseFloat(rs.getString(8)));
        vo.setEmployeeNumber(rs.getString(9));
        vo.setNumber(rs.getString(10));
        vo.setCancelTime(rs.getString(11));
        vo.setClient(rs.getString(12));
        list.add(vo);

        }
      }
      catch (SQLException ex) {
      }
      connection.closeConnection();
      return list;
  }




  public List cancelSelect(String back) {
    String sql = "";
    List list = new ArrayList();
    GoodsCancelVO vo = null;
    if (back.equals("")) {
      sql = "select * from tb_goodsCancel";
    }
    else {
      sql = "select * from tb_goodsCancel where back='" + back + "'";
    }
    ResultSet rs = connection.executeQuery(sql);
    System.out.println("sql=" + sql);
    try {
      while (rs.next()) {
        vo = new GoodsCancelVO();
        vo.setId(Integer.valueOf(rs.getString(1)));
        vo.setCancel_number(rs.getString(2));
        vo.setAccounts(rs.getString(3));
        vo.setGoods_number(rs.getString(4));
        vo.setOrder_number(rs.getString(5));
        vo.setReason(rs.getString(6));
        vo.setBack(Integer.parseInt(rs.getString(7)));
        vo.setMoney(Float.parseFloat(rs.getString(8)));
        vo.setEmployeeNumber(rs.getString(9));
        vo.setNumber(rs.getString(10));
        vo.setCancelTime(rs.getString(11));
        vo.setClient(rs.getString(12));
        list.add(vo);
      }
    }
    catch (SQLException ex) {
    }
    connection.closeConnection();
    return list;
  }

//把货品返回供应商
  public void backCompany(int accounts, int id) {
    String sql = "update tb_goodsCancel set back='" + accounts + "' where id='" +
        id + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

//删除退货信息
  public void deleteCancel(Integer id) {
    String sql = "delete from tb_goodsCancel where id='" + id + "'";
    connection.executeUpdate(sql);
    connection.closeConnection();
  }

}