CSP材料申请总结

1.合同组距统计，根据交货期以及组距对合同进行统计，具体统计代码,其中交货期也是根据合同表统计出来的

WITH DT AS  
(SELECT F.LG_ST,F.ST_NO,F.OUT_MAT_WIDTH, F.DELIVERY_DATE_IN, 
VALUE(CAST(SUM(LACK_WT) AS DECIMAL(8, 3)), 0) AS LACK_WT  
FROM  
(SELECT D.LG_ST,D.ST_NO,  C.OUT_MAT_WIDTH AS OUT_MAT_WIDTH, A.DELIVERY_DATE_IN, B.LACK_WT 
FROM  
OMPOMA.TOMPOMA01 A, 
PMOFMA.TPMOFMA02 B,
QMTOMA.TQMTOMAN1 C,
QMTOMA.TQMTOMA11 D,
QMTOMA.TQMTOMA02 E 
WHERE  A.ORDER_NO = B.ORDER_NO  
AND A.ORDER_NO = C.ORDER_NO 
AND B.BACKLOG = C.BACKLOG 
AND A.ORDER_NO = D.ORDER_NO
AND B.BACKLOG = D.BACKLOG  
AND A.ORDER_NO = E.ORDER_NO 
AND B.BACKLOG = E.BACKLOG  
AND E.BACKLOG LIKE '1__1%'  
AND B.WHOLE_BACKLOG_SEQ = 1 
AND C.BACKLOG_POS = '04' 
AND E.BACKLOG_FLAG = '0'  
AND A.ORDER_DELIVERY_DATE BETWEEN  '' AND '99999999' 
AND  A.PROD_CLASS_CODE IN ('L','M','N','O','X','I','Q','S') 
AND A.ORDER_TYPE_CODE IN ('QZA','CZA','QPA','QYA','QZ1','QZ2')
AND A.ORDER_STATUS BETWEEN '41' AND '49'
AND A.ORDER_NO='I1A0401004'
) F  

GROUP BY  F.LG_ST,F.ST_NO, F.OUT_MAT_WIDTH, F.DELIVERY_DATE_IN),  
DT1 AS(SELECT LG_ST,ST_NO, OUT_MAT_WIDTH, DELIVERY_DATE_IN, 
(CASE WHEN DELIVERY_DATE_IN = '20210531' THEN LACK_WT ELSE 0 END) AS "20210531", 
(CASE WHEN DELIVERY_DATE_IN = '20210630' THEN LACK_WT ELSE 0 END) AS "20210630", 
(CASE WHEN DELIVERY_DATE_IN = '20210731' THEN LACK_WT ELSE 0 END) AS "20210731", 
(CASE WHEN DELIVERY_DATE_IN = '20210831' THEN LACK_WT ELSE 0 END) AS "20210831", 
(CASE WHEN DELIVERY_DATE_IN = '20210930' THEN LACK_WT ELSE 0 END) AS "20210930",  LACK_WT FROM DT) 
SELECT  LG_ST,ST_NO, OUT_MAT_WIDTH,  
SUM("20210531") AS "20210531", 
SUM("20210630") AS "20210630", 
SUM("20210731") AS "20210731",  
SUM("20210831") AS "20210831", 
SUM("20210930") AS "20210930"  
FROM DT1 
GROUP BY LG_ST,ST_NO,OUT_MAT_WIDTH  ORDER BY LG_ST,ST_NO,OUT_MAT_WIDTH

2.收池：根据所选合同信息，进行收池，指定厚度收池，指定当前收池合同厚度。调用后台都是pmommmacs10_chs

3.宽度设计：对收池完的合同订单进行宽度设计，一键修改若没有填写宽度，则使用的是额定轧制宽度来做订单宽度，根据现场提供厚度来控制宽度上下限。

4.长度设计：对收池完成的合同订单进行长度设计，根据钢水比重和额定宽度以及轧制厚度进行板坯块数的计算，更新板坯块数以及板坯长度。其中保存是对设计状态的更改。

5.虚拟板坯生成：根据csp合同表中板坯块数信息将对应的信息写入材料申请主档表TPMOMMA00

6.虚拟板坯查询：对生成的虚拟板坯进行查询

7.板坯退池：根据所选虚拟板坯信息，判断板坯状态是否为池状态，删除。

8.未产出板坯删除：根据所选板坯信息判断材料申请状态是否排入轧制计划，查询炼钢计划状态是否炉次确定，调用轧制计划删除函数，更新材料申请主档状态为8未产出。

9.轧制计划收池：根据分解的虚拟板坯，进行轧制计划的形成

10：轧制计划编辑：形成轧制计划号

11.流炉设计：根据用户输入炉数向上取整，进行流炉设计，抓取炉内板坯，填充，当炉内板坯重量大于炉重时，判断当前所需板坯重量与板坯单重的1/2比较，判断当前板坯落在当前炉还是下一炉。