#

mrzhssss

2022-08-30 c5588f43f8d7ebd8a982f95c8d265a520d5e0628

 src/main/java/com/slcf/service/impl/WaitPakOutServiceImpl.java

@@ -1,9 +1,19 @@
package com.slcf.service.impl;

import java.io.IOException;
import java.io.OutputStream;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

import com.slcf.bean.WaitPakOutLogCondition;
import com.slcf.controller.param.SetEmsParam;
import com.slcf.pojo.WaitPakOutLogBean;
import com.slcf.util.DateTimeUtil;
import org.apache.ibatis.annotations.Param;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
@@ -16,6 +26,8 @@
import com.slcf.pojo.WorkMastBean;
import com.slcf.service.WaitPakOutService;

import javax.servlet.http.HttpServletResponse;

/**
 * 入库通知档接口实现
 * @author admin
@@ -25,7 +37,7 @@
public class WaitPakOutServiceImpl implements WaitPakOutService {

   @Autowired
   WaitPakOutDao WaitPakOutDao;
   WaitPakOutDao waitPakOutDao;
   
   @Autowired
   WorkFileDao workFileDao;
@@ -35,7 +47,7 @@
   public int insertWaitPakOut(WaitPakOutBean waitPakOut) {
      int result=0;
      try {
         result=WaitPakOutDao.insertWaitPakOut(waitPakOut);
         result=waitPakOutDao.insertWaitPakOut(waitPakOut);
      }catch(Exception e) {
         System.out.println(e.getMessage());
      }
@@ -61,8 +73,8 @@
   public Map<String,Object> queryWaitPakOutList(WaitPakOutCondition waitPakOutCon) {
      try {
         Map<String,Object> map=new HashMap<String, Object>();
         List<WaitPakOutBean> list=WaitPakOutDao.queryWaitPakOutList(waitPakOutCon);
         int count =WaitPakOutDao.getWaitPakOutCount(waitPakOutCon);
         List<WaitPakOutBean> list=waitPakOutDao.queryWaitPakOutList(waitPakOutCon);
         int count =waitPakOutDao.getWaitPakOutCount(waitPakOutCon);
         map.put("rows", list);
         map.put("total", count);
         return map;
@@ -80,12 +92,24 @@
//      }
//   }

   public Integer waitPakOutSetEms(SetEmsParam setEmsParam) {
      return waitPakOutDao.waitPakOutSetEms(setEmsParam.getLgnum(), setEmsParam.getTanum(), setEmsParam.getTapos());
   }

   public Integer countEmsNum() {
      return waitPakOutDao.countEmsNum();
   }

   public List<WaitPakOutBean> queryWaitOutPak(String vlpla, String matnr) {
      return waitPakOutDao.queryWaitOutPak(vlpla, matnr);
   }

   /**
    * 根据id查找
    */
   public WaitPakOutBean queryWaitPakOutById(String sheet_no,String mat_no) {
      try {
         return WaitPakOutDao.getWaitPakOutById(sheet_no,mat_no);
         return waitPakOutDao.getWaitPakOutById(sheet_no,mat_no);
      }catch(Exception e) {
         System.out.println(e.getMessage());
         return null;
@@ -97,7 +121,7 @@
    */
   public WaitPakOutBean queryWaitPakOutByLocNo(String loc_no) {
      try {
         return WaitPakOutDao.getWaitPakOutByLocNo(loc_no);
         return waitPakOutDao.getWaitPakOutByLocNo(loc_no);
      }catch(Exception e) {
         System.out.println(e.getMessage());
         return null;
@@ -109,7 +133,7 @@
    */
   public WaitPakOutBean queryWaitPakOutByMatNo(String mat_no) {
      try {
         return WaitPakOutDao.getWaitPakOutByMatNo(mat_no);
         return waitPakOutDao.getWaitPakOutByMatNo(mat_no);
      }catch(Exception e) {
         System.out.println(e.getMessage());
         return null;
@@ -120,7 +144,7 @@
   public int upWaitPakOut(WaitPakOutBean WaitPakOut, int type) {
      int result=0;
      try {
         result=WaitPakOutDao.upWaitPakOut(WaitPakOut);
         result=waitPakOutDao.upWaitPakOut(WaitPakOut);
//         if(type==2) {
//            //如果工作档有数据，调整工作档优先级
//            WorkDetailBean workDetail = workFileDao.getWorkDetlByMatNo(WaitPakOut.getMat_no());
@@ -144,7 +168,7 @@
   public int upWaitPakOutByLocNo(WaitPakOutBean WaitPakOut) {
      int result=0;
      try {
         result=WaitPakOutDao.upWaitPakOutByLocNo(WaitPakOut);
         result=waitPakOutDao.upWaitPakOutByLocNo(WaitPakOut);
      }catch(Exception e) {
         System.out.println(e.getMessage());
      }
@@ -157,7 +181,7 @@
   public int delWaitPakOut(WaitPakOutBean WaitPakOut) {
      int result=0;
      try {
         result=WaitPakOutDao.delWaitPakOutById(WaitPakOut);
         result=waitPakOutDao.delWaitPakOutById(WaitPakOut);
      }catch(Exception e) {
         System.out.println(e.getMessage());
      }
@@ -170,7 +194,7 @@
    */
   public List<WaitPakOutBean> getWaitPakOutList() {
      try {
         return WaitPakOutDao.getWaitPakOutList();
         return waitPakOutDao.getWaitPakOutList();
      }catch(Exception e) {
         System.out.println(e.getMessage());
         return null;
@@ -185,8 +209,8 @@
   public int moveToLog(WaitPakOutBean WaitPakOut) {
      int result=0;
      try {
         result=WaitPakOutDao.insertLog(WaitPakOut);
         result=WaitPakOutDao.delWaitPakOutById(WaitPakOut);
         result=waitPakOutDao.insertLog(WaitPakOut);
         result=waitPakOutDao.delWaitPakOutById(WaitPakOut);
      }catch(Exception e) {
         System.out.println(e.getMessage());
      }
@@ -199,7 +223,7 @@
    */
   public List<WaitPakOutBean> getSheetNoList() {
      try {
         return WaitPakOutDao.getSheetNoList();
         return waitPakOutDao.getSheetNoList();
      }catch(Exception e) {
         System.out.println(e.getMessage());
         return null;
@@ -211,7 +235,7 @@
    */
   public WaitPakOutBean queryWaitPakOutByNum(WaitPakOutBean waitPakOutBean) {
      try {
         return WaitPakOutDao.getWaitPakOutByNum(waitPakOutBean);
         return waitPakOutDao.getWaitPakOutByNum(waitPakOutBean);
      }catch(Exception e) {
         System.out.println(e.getMessage());
         return null;
@@ -223,7 +247,7 @@
    */
   public WaitPakOutBean queryWaitPakOutFnh() {
      try {
         return WaitPakOutDao.getWaitPakOutFnh();
         return waitPakOutDao.getWaitPakOutFnh();
      }catch(Exception e) {
         System.out.println(e.getMessage());
         return null;
@@ -235,10 +259,93 @@
    */
   public WaitPakOutBean getWaitPakOutPrint() {
      try {
         return WaitPakOutDao.getWaitPakOutPrint();
         return waitPakOutDao.getWaitPakOutPrint();
      }catch(Exception e) {
         System.out.println(e.getMessage());
         return null;
      }
   }

   public void ExportWaitPakOutList(WaitPakOutCondition condition, HttpServletResponse response) {
      //输出Excel文件
      try {
         //HSSFWorkbook对象(excel的文档对象)
         HSSFWorkbook workBook=new HSSFWorkbook();

         //sheet对象（excel的表单）
         HSSFSheet sheet=workBook.createSheet("出库通知历史档");

         //行数，参数为行索引(excel的行)
//            HSSFRow rowHead=sheet.createRow(0);//第一行  可以是0～65535之间的任何一个

//            //创建excel的单元格，参数为列索引，可以是0～255之间的任何一个
//            HSSFCell cellOne=rowHead.createCell(0);
//            cellOne.setCellValue("用户信息");//表头

         //合并单元格CellRangeAddress构造参数依次表示起始行，截至行，起始列， 截至列
//            sheet.addMergedRegion(new CellRangeAddress(0,0,0,5));

         sheet.setColumnWidth(0, (int)((10 + 0.72) * 256));
         sheet.setColumnWidth(1, (int)((20 + 0.72) * 256));
         sheet.setColumnWidth(2, (int)((15 + 0.72) * 256));
         sheet.setColumnWidth(3, (int)((15 + 0.72) * 256));
         sheet.setColumnWidth(4, (int)((15 + 0.72) * 256));
         sheet.setColumnWidth(5, (int)((25 + 0.72) * 256));
         sheet.setColumnWidth(6, (int)((10 + 0.72) * 256));
         sheet.setColumnWidth(7, (int)((8 + 0.72) * 256));
         sheet.setColumnWidth(8, (int)((10 + 0.72) * 256));
         sheet.setColumnWidth(9, (int)((10 + 0.72) * 256));
         sheet.setColumnWidth(10, (int)((10 + 0.72) * 256));
         sheet.setColumnWidth(11, (int)((25 + 0.72) * 256));
         sheet.setColumnWidth(12, (int)((25 + 0.72) * 256));
         sheet.setColumnWidth(13, (int)((25 + 0.72) * 256));

         HSSFRow rows=sheet.createRow(0);//第二行
         //创建单元格并设置单元格内容
         rows.createCell(0).setCellValue("仓库号");
         rows.createCell(1).setCellValue("转储编号");
         rows.createCell(2).setCellValue("行项目");
         rows.createCell(3).setCellValue("物料");
         rows.createCell(4).setCellValue("物料描述");
         rows.createCell(5).setCellValue("工厂");
         rows.createCell(6).setCellValue("数量");
         rows.createCell(7).setCellValue("单位");
         rows.createCell(8).setCellValue("源发地类型");
         rows.createCell(9).setCellValue("源发地仓位");
         rows.createCell(10).setCellValue("目的地类型");
         rows.createCell(11).setCellValue("目的地仓位");
         rows.createCell(12).setCellValue("用户ID");
         rows.createCell(13).setCellValue("修改时间");

         List<WaitPakOutBean> list=waitPakOutDao.getWaitPakOutAll(condition);
         for(int i=0;i<list.size();i++){
            HSSFRow row=sheet.createRow(i+1);//从第三行开始
            //创建单元格并设置单元格内容
            row.createCell(0).setCellValue(list.get(i).getLgnum());
            row.createCell(1).setCellValue(list.get(i).getTanum());
            row.createCell(2).setCellValue(list.get(i).getTapos());
            row.createCell(3).setCellValue(list.get(i).getMatnr());
            row.createCell(4).setCellValue(list.get(i).getMaktx());
            row.createCell(5).setCellValue(list.get(i).getWerks());
            row.createCell(6).setCellValue(list.get(i).getVsolm());
            row.createCell(7).setCellValue(list.get(i).getMeins());
            row.createCell(8).setCellValue(list.get(i).getVltyp());
            row.createCell(9).setCellValue(list.get(i).getVlpla());
            row.createCell(10).setCellValue(list.get(i).getNltyp());
            row.createCell(11).setCellValue(list.get(i).getNlpla());
            row.createCell(12).setCellValue(list.get(i).getBname());
            row.createCell(13).setCellValue(list.get(i).getModi_time());
         }
//         //输出Excel文件
//          try {
         OutputStream output=response.getOutputStream();
         response.reset();
         response.setHeader("Content-disposition", "attachment; filename=WaitPakOut"+ DateTimeUtil.getStringDateTime(14)+".xls");
         response.setContentType("application/msexcel");
         workBook.write(output);
         output.close();
      } catch (IOException e) {
         e.printStackTrace();
      }
   }
}