| | |
| | | @ExcelProperty("装备名称") |
| | | private String name; |
| | | |
| | | /** |
| | | * 编号 |
| | | */ |
| | | @ColumnWidth(20) |
| | | @ExcelProperty("编号") |
| | | private String number; |
| | | |
| | | /** |
| | | * 规格 |
| | | */ |
| | | @ColumnWidth(20) |
| | | @ExcelProperty("规格") |
| | | private String specifications; |
| | | // /** |
| | | // * 编号 |
| | | // */ |
| | | // @ColumnWidth(20) |
| | | // @ExcelProperty("编号") |
| | | // private String number; |
| | | // |
| | | // /** |
| | | // * 规格 |
| | | // */ |
| | | // @ColumnWidth(20) |
| | | // @ExcelProperty("规格") |
| | | // private String specifications; |
| | | |
| | | /** |
| | | * 型号 |
| | |
| | | <if test="car.carType!=null and car.carType!=''"> |
| | | and sc.car_type like concat('%', #{car.carType},'%') |
| | | </if> |
| | | <if test="car.brand!=null and car.brand!=''"> |
| | | and sc.brand like concat('%', #{car.brand},'%') |
| | | </if> |
| | | <if test="car.mode!=null and car.mode!=''"> |
| | | and sc.mode like concat('%', #{car.mode},'%') |
| | | </if> |
| | | <if test="car.personInCharge!=null and car.personInCharge!=''"> |
| | | and sc.person_in_charge like concat('%', #{car.personInCharge},'%') |
| | | </if> |
| | |
| | | <if test="equipage.name!=null and equipage.name!=''"> |
| | | and se.name like concat('%', #{equipage.name},'%') |
| | | </if> |
| | | <if test="equipage.brand!=null and equipage.brand!=''"> |
| | | and se.brand like concat('%', #{equipage.brand},'%') |
| | | </if> |
| | | <if test="equipage.personInCharge!=null and equipage.personInCharge!=''"> |
| | | and se.person_in_charge like concat('%', #{equipage.personInCharge},'%') |
| | | </if> |
| | |
| | | equipage.setName(equipageExcel.getName()); |
| | | } |
| | | |
| | | if (null!=equipageExcel.getNumber() && equipageExcel.getNumber()!="") { |
| | | equipage.setNumber(equipageExcel.getNumber()); |
| | | } |
| | | |
| | | if (null!=equipageExcel.getSpecifications() && equipageExcel.getSpecifications()!="") { |
| | | equipage.setSpecifications(equipageExcel.getSpecifications()); |
| | | } |
| | | // if (null!=equipageExcel.getNumber() && equipageExcel.getNumber()!="") { |
| | | // equipage.setNumber(equipageExcel.getNumber()); |
| | | // } |
| | | // |
| | | // if (null!=equipageExcel.getSpecifications() && equipageExcel.getSpecifications()!="") { |
| | | // equipage.setSpecifications(equipageExcel.getSpecifications()); |
| | | // } |
| | | |
| | | //插入数据 |
| | | this.save(equipage); |