「預交日工程單」:修訂間差異

出自TSK WIKI
跳至導覽 跳至搜尋
Root​(留言 | 貢獻)
新頁面: ==程式碼== <sql> SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010, (SELECT CASE WHEN TA526<>'' AND TA527<>'' THEN 'OK' WHEN TA526<>'' AND TA527='' THEN '在組裝' WHEN TA524...
 
Root​(留言 | 貢獻)
 
第1行: 第1行:
==程式碼==
==程式碼==
<sql>
<sql>
SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010,
SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010,TD001,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527,
(SELECT CASE  
(SELECT CASE  
WHEN TA526<>'' AND TA527<>'' THEN 'OK'
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 TA526<>'' AND TA527='' THEN '在組裝'
WHEN TA524<>'' AND TA525='' THEN '在端子'
WHEN TA520='' AND TA522='' AND TA524='' AND TA526='' THEN '排單中'
WHEN TA522<>'' AND TA523='' THEN '在焊接'
WHEN TA520<>'' AND TA521='' THEN '在裁線'
END) AS TA527,(SELECT CASE WHEN TC012<>'' THEN TC012 ELSE X.UDF02 END)AS TC012
END) AS TA527,(SELECT CASE WHEN TC012<>'' THEN TC012 ELSE X.UDF02 END)AS TC012
FROM v_COPTCD X
FROM v_COPTCD X
第15行: 第16行:
AND TD003=(SELECT CASE WHEN TA033<>'' AND TA028='' THEN TD003 ELSE TA028 END)  
AND TD003=(SELECT CASE WHEN TA033<>'' AND TA028='' THEN TD003 ELSE TA028 END)  
JOIN COPMA ON MA001=TC004
JOIN COPMA ON MA001=TC004
WHERE TD002>'151001000' AND TA010='20151207'
WHERE TA010='20151207'
 
</sql>
</sql>

於 2015年12月7日 (一) 12:40 的最新修訂

程式碼

<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>