package com.controller;

import java.util.List;

import javax.swing.JTextField;

import com.dao.SaleDaoyzz;
import com.entity.Saleyzz;


public class SaleActionyzz {
    //添加销售信息
    public void addSaleInformation(JTextField saleDateField,
                                   JTextField carTypeField,
                                   JTextField colorField,
                                   JTextField numberField,
                                   JTextField handlerField)throws Exception {
        SaleDaoyzz saleDao = new SaleDaoyzz();
        Saleyzz sale = new Saleyzz();
        sale.setSale_date(saleDateField.getText());
        sale.setCar_type(carTypeField.getText());
        sale.setColor(colorField.getText());
        sale.setNumber(Integer.parseInt(numberField.getText()));
        sale.setHandler(handlerField.getText());

        saleDao.addSale(sale);
    }
    //删除销售信息
    public void delSaleInformation(String sale_date)throws Exception {

        SaleDaoyzz saleDao = new SaleDaoyzz();
        saleDao.delSale(sale_date);
    }
    //修改销售信息
    public void changeSaleInformation(JTextField saleDateField,
                                      JTextField carTypeField,
                                      JTextField colorField,
                                      JTextField numberField,
                                      JTextField handlerField) throws Exception{
        SaleDaoyzz saleDao = new SaleDaoyzz();
        Saleyzz sale = new Saleyzz();
        sale.setSale_date(saleDateField.getText());
        sale.setCar_type(carTypeField.getText());
        sale.setColor(colorField.getText());
        sale.setNumber(Integer.parseInt(numberField.getText()));
        sale.setHandler(handlerField.getText());

        saleDao.changeSale(sale);

    }
    //查询表信息并放入二维数组中保存
    public Object[][] query(String[] columnNames) throws Exception{
        // TODO Auto-generated method stub
        SaleDaoyzz saleDao = new SaleDaoyzz();
        List<Saleyzz> list = saleDao.query();
        Object[][] results= new Object[list.size()][columnNames.length];
        for (int i = 0; i < list.size(); i++) {
            Saleyzz sale= (Saleyzz)list.get(i);

            results[i][0] = sale.getSale_date();
            results[i][1] = sale.getCar_type();
            results[i][2]=sale.getColor();
            results[i][3]=sale.getNumber();
            results[i][4]=sale.getHandler();

        }
        return results;
    }
}