高格-塑料管业中厂内工单列表的处理【5】
由于塑料管业生产中,一个车间多个生产线,每条生产线生产一个品名产品。因此不太合适用高格厂内工单打印方式来安排生产,
需要用列表方式比较合适。
![](https://img2020.cnblogs.com/blog/370586/202011/370586-20201114232224657-1575166772.png)
那么如何实现一览表的方式,花点时间还是成功实现了。
1、使用条文作为表格的质量要求
2、工单备注长度255个字节,作为表格说明。
SELECT ( SELECT STRING+char(10) FROM VCHRART where SRCERI = B.ERI order by SERIAL FOR XML PATH('') ) AS MYMEMO, B.MEMO, case B.CLOSETYPE when 1 then '已结案' else '' end 结案,B.SDATE,B.CODE,B.MAKER,(CASE B.WORKTYPE WHEN 0 THEN (SELECT NAME FROM BOMMAKE WHERE CODE=B.MAKER) WHEN 1 THEN (SELECT ABBR FROM SUPPLIER WHERE CODE=B.MAKER) END ) AS MAKERNAME, CASE B.SRCTRACK WHEN 0 THEN '报工单' ELSE '移转单' END SRCTRACK, B.MPROD,P.CNAME AS MPRODNAME,B.SPEC,O2.CODE AS ORDCODE, B2.PRSNO,BS.NAME AS PRSNAME,B2.QTY,(B2.SCRAPQTY + B2.RPTQTY) BQTY,B2.GQTY, B2.SCRAPQTY,B2.RPTQTY, (CASE WHEN B.CLOSETYPE=1 THEN 0 WHEN B2.QTY<B2.GQTY THEN 0 ELSE ISNULL(B2.QTY-B2.GQTY,0) END) AS NOCOMQTY, B2.GQTY+B2.SCRAPQTY+B2.RPTQTY AS TOTQTY, case when B2.SCRAPQTY+B2.RPTQTY = 0 then 100 else 100.0*B2.COMQTY/(B2.GQTY+B2.SCRAPQTY+B2.RPTQTY) end PRSRATE, B2.TOTAL, B.ERI, B.VPNO FROM BOMWORK B LEFT JOIN PRODUCT P ON B.MPROD=P.CODE LEFT JOIN ORDCORD2 O2 ON B.ORDERI=O2.ERI LEFT JOIN BOMWORK2 B2 ON B.ERI=B2.MASTERI LEFT JOIN BOMMPRS BS ON B2.PRSNO=BS.CODE WHERE B.NEEDPRS=1 AND B2.ERI IS NOT NULL AND B.SDATE BETWEEN :SDATE1 AND :SDATE2 AND B.CODE=:CODE AND B.MPROD=:PRODCODE AND O2.CODE=:ORDCODE AND B2.PRSNO=:PRSNO ORDER BY B.SDATE,B.CODE,B2.SERIAL
在打印模板设计时注意自动换行等属性值即可