派生自 MES-WEB-API
WorkM/±¨±í·ÖÎö/DefectiveDetailedYieldReport.cs
@@ -176,11 +176,13 @@ //} // DSet = SubCn.RunProcReturn("select " + "MAX(a.HMakeDate) æ±æ¥æ¥æ, a.HICMOBillNo ä»»å¡åå·, c.HProcExchBillNo æµè½¬å¡å·, c.HProcID, d.HName å·¥åºå称" + "MAX(a.HMakeDate) æ±æ¥æ¥æ, a.HICMOBillNo ä»»å¡åå·," + "case when isnull(ic.HBillSubType,0)='1055' then 'è¿å·¥' else 'æ®é订å' end ä»»å¡åç±»å , c.HProcExchBillNo æµè½¬å¡å·, c.HProcID, d.HName å·¥åºå称" + ", sum(a.HWorkTimes) å·¥æ¶, b.HName ç©æå称, a.HICMOQty ç产订åæ°é, a.HPlanQty 计åæ°é, c.HQty è¿ç«æ°é" + ", co.HQty åºç«åæ ¼æ°é, c.HQty - co.HQty - co.HWasterQty æªè¿ç«æ°é" + ", co.HWasterQty ä¸åæ ¼æ°é, co.HQty / nullif((co.HQty+co.HWasterQty),0) åºç«è¯ç,co.HBillSubType ä¸å¡ç±»å, co.HName ä¸è¯æç», co.HBadQty ä¸è¯æ°é " + " FROM Sc_StationOutBillMain a " + "left join sc_icmobillmain ic on a.HICMOInterID =ic.HInterID " + "left join Gy_Material b on a.HMaterID = b.HItemID " + "left join( " + "select sum(aa.HQty) HQty, aa.HProcExchBillNo, aa.HProcExchInterID, aa.HProcID " + @@ -203,6 +205,7 @@ "left join Gy_Process d on c.HProcID = d.HItemID " + "where 1 = 1 " + sDlgWhere + "group by a.HICMOBillNo,c.HProcExchBillNo,d.HName,b.HName,a.HICMOQty,c.HQty,a.HPlanQty" + ",case when isnull(ic.HBillSubType,0)='1055' then 'è¿å·¥' else 'æ®é订å' end " + ",co.HQty,c.HProcID,co.HWasterQty,co.HName,co.HBadQty,a.HWasterQty,co.HBillSubType " + "order by c.HProcID", "Sc_StationOutBillMain", ref ClsPub.sExeReturnInfo);
