預交日工程單

出自TSK WIKI
於 2015年12月7日 (一) 12:40 由 Root​(留言 | 貢獻) 所做的修訂 (→程式碼)
(差異) ←上個修訂 | 最新修訂 (差異) | 下個修訂→ (差異)
跳至導覽 跳至搜尋

程式碼

<sql> SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010,TD001,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527, (SELECT CASE WHEN TA526<> AND TA527<> THEN 'OK' WHEN TA520<> AND TA521= THEN '在裁線' WHEN TA522<> AND TA523= THEN '在焊接' WHEN TA524<> AND TA525= THEN '在端子' WHEN TA526<> AND TA527= THEN '在組裝' WHEN TA520= AND TA522= AND TA524= AND TA526= THEN '排單中' END) AS TA527,(SELECT CASE WHEN TC012<> THEN TC012 ELSE X.UDF02 END)AS TC012 FROM v_COPTCD X JOIN v_MOCTANOTV ON TD001=(SELECT CASE WHEN TA033<> THEN '400' ELSE TA026 END) AND TD002=(SELECT CASE WHEN TA033<> THEN REPLACE(TA033,'*',) ELSE TA027 END) AND TD003=(SELECT CASE WHEN TA033<> AND TA028= THEN TD003 ELSE TA028 END) JOIN COPMA ON MA001=TC004 WHERE TA010='20151207' </sql>