<?xml version="1.0"?>
<feed xmlns="http://www.w3.org/2005/Atom" xml:lang="zh-Hant-TW">
	<id>http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%B7%A5%E7%A8%8B%E5%96%AE</id>
	<title>預交日工程單 - 修訂紀錄</title>
	<link rel="self" type="application/atom+xml" href="http://tskds213.synology.me/mediawiki/index.php?action=history&amp;feed=atom&amp;title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%B7%A5%E7%A8%8B%E5%96%AE"/>
	<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%B7%A5%E7%A8%8B%E5%96%AE&amp;action=history"/>
	<updated>2026-11-16T22:51:36Z</updated>
	<subtitle>本 wiki 上此頁面的修訂紀錄</subtitle>
	<generator>MediaWiki 1.43.5</generator>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%B7%A5%E7%A8%8B%E5%96%AE&amp;diff=1552&amp;oldid=prev</id>
		<title>Root：​/* 程式碼 */</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%B7%A5%E7%A8%8B%E5%96%AE&amp;diff=1552&amp;oldid=prev"/>
		<updated>2015-12-07T04:40:29Z</updated>

		<summary type="html">&lt;p&gt;&lt;span class=&quot;autocomment&quot;&gt;程式碼&lt;/span&gt;&lt;/p&gt;
&lt;table style=&quot;background-color: #fff; color: #202122;&quot; data-mw=&quot;interface&quot;&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;col class=&quot;diff-marker&quot; /&gt;
				&lt;col class=&quot;diff-content&quot; /&gt;
				&lt;tr class=&quot;diff-title&quot; lang=&quot;zh-Hant-TW&quot;&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;←上個修訂&lt;/td&gt;
				&lt;td colspan=&quot;2&quot; style=&quot;background-color: #fff; color: #202122; text-align: center;&quot;&gt;於 2015年12月7日 (一) 12:40 的修訂&lt;/td&gt;
				&lt;/tr&gt;&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l1&quot;&gt;第1行：&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;第1行：&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;==程式碼==&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;==程式碼==&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010,&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;,TD001,TA520,TA521,TA522,TA523,TA524,TA525,TA526,TA527&lt;/ins&gt;,&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(SELECT CASE  &lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;(SELECT CASE  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHEN TA526&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA527&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN &amp;#039;OK&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHEN TA526&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA527&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN &amp;#039;OK&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;WHEN TA520&amp;lt;&amp;gt;&#039;&#039; AND TA521=&#039;&#039; THEN &#039;在裁線&#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;WHEN TA522&amp;lt;&amp;gt;&#039;&#039; AND TA523=&#039;&#039; THEN &#039;在焊接&#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-deleted&quot;&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;WHEN TA524&amp;lt;&amp;gt;&#039;&#039; AND TA525=&#039;&#039; THEN &#039;在端子&#039;&lt;/ins&gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHEN TA526&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA527=&amp;#039;&amp;#039; THEN &amp;#039;在組裝&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHEN TA526&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA527=&amp;#039;&amp;#039; THEN &amp;#039;在組裝&amp;#039;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHEN &lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;TA524&amp;lt;&amp;gt;&lt;/del&gt;&#039;&#039; AND &lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;TA525&lt;/del&gt;=&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;&#039;&#039; THEN &#039;在端子&#039;&lt;/del&gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHEN &lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;TA520=&lt;/ins&gt;&#039;&#039; AND &lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;TA522&lt;/ins&gt;=&#039;&#039; AND &lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;TA524&lt;/ins&gt;=&#039;&#039; AND &lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;TA526&lt;/ins&gt;=&#039;&#039; THEN &#039;&lt;ins style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;排單中&lt;/ins&gt;&#039;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;WHEN TA522&amp;lt;&amp;gt;&lt;/del&gt;&#039;&#039; AND &lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;TA523&lt;/del&gt;=&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;&#039;&#039; THEN &#039;在焊接&#039;&lt;/del&gt;&lt;/div&gt;&lt;/td&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-added&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;WHEN TA520&amp;lt;&amp;gt;&lt;/del&gt;&#039;&#039; AND &lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;TA521&lt;/del&gt;=&#039;&#039; THEN &#039;&lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;在裁線&lt;/del&gt;&#039;&lt;/div&gt;&lt;/td&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-added&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;END) AS TA527,(SELECT CASE WHEN TC012&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN TC012 ELSE X.UDF02 END)AS TC012&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;END) AS TA527,(SELECT CASE WHEN TC012&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN TC012 ELSE X.UDF02 END)AS TC012&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;FROM v_COPTCD X&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;FROM v_COPTCD X&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot; id=&quot;mw-diff-left-l15&quot;&gt;第15行：&lt;/td&gt;
&lt;td colspan=&quot;2&quot; class=&quot;diff-lineno&quot;&gt;第16行：&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;				AND TD003=(SELECT CASE WHEN TA033&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA028=&amp;#039;&amp;#039; THEN TD003 ELSE TA028 END)  &lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;				AND TD003=(SELECT CASE WHEN TA033&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA028=&amp;#039;&amp;#039; THEN TD003 ELSE TA028 END)  &lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;JOIN COPMA ON MA001=TC004&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;JOIN COPMA ON MA001=TC004&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHERE &lt;del style=&quot;font-weight: bold; text-decoration: none;&quot;&gt;TD002&amp;gt;&#039;151001000&#039; AND &lt;/del&gt;TA010=&#039;20151207&#039;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;+&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;WHERE TA010=&#039;20151207&#039;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot; data-marker=&quot;−&quot;&gt;&lt;/td&gt;&lt;td style=&quot;color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt; &lt;/div&gt;&lt;/td&gt;&lt;td colspan=&quot;2&quot; class=&quot;diff-side-added&quot;&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;tr&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;td class=&quot;diff-marker&quot;&gt;&lt;/td&gt;&lt;td style=&quot;background-color: #f8f9fa; color: #202122; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #eaecf0; vertical-align: top; white-space: pre-wrap;&quot;&gt;&lt;div&gt;&amp;lt;/sql&amp;gt;&lt;/div&gt;&lt;/td&gt;&lt;/tr&gt;
&lt;/table&gt;</summary>
		<author><name>Root</name></author>
	</entry>
	<entry>
		<id>http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%B7%A5%E7%A8%8B%E5%96%AE&amp;diff=1551&amp;oldid=prev</id>
		<title>Root：​新頁面: ==程式碼== &lt;sql&gt; SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010, (SELECT CASE  WHEN TA526&lt;&gt;&#039;&#039; AND TA527&lt;&gt;&#039;&#039; THEN &#039;OK&#039; WHEN TA526&lt;&gt;&#039;&#039; AND TA527=&#039;&#039; THEN &#039;在組裝&#039; WHEN TA524...</title>
		<link rel="alternate" type="text/html" href="http://tskds213.synology.me/mediawiki/index.php?title=%E9%A0%90%E4%BA%A4%E6%97%A5%E5%B7%A5%E7%A8%8B%E5%96%AE&amp;diff=1551&amp;oldid=prev"/>
		<updated>2015-12-07T04:20:57Z</updated>

		<summary type="html">&lt;p&gt;新頁面: ==程式碼== &amp;lt;sql&amp;gt; SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010, (SELECT CASE  WHEN TA526&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA527&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN &amp;#039;OK&amp;#039; WHEN TA526&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA527=&amp;#039;&amp;#039; THEN &amp;#039;在組裝&amp;#039; WHEN TA524...&lt;/p&gt;
&lt;p&gt;&lt;b&gt;新頁面&lt;/b&gt;&lt;/p&gt;&lt;div&gt;==程式碼==&lt;br /&gt;
&amp;lt;sql&amp;gt;&lt;br /&gt;
SELECT TD013,MA002,TA002,TD005,TD006,TD008,TD010,TA010,&lt;br /&gt;
(SELECT CASE &lt;br /&gt;
WHEN TA526&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA527&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN &amp;#039;OK&amp;#039;&lt;br /&gt;
WHEN TA526&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA527=&amp;#039;&amp;#039; THEN &amp;#039;在組裝&amp;#039;&lt;br /&gt;
WHEN TA524&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA525=&amp;#039;&amp;#039; THEN &amp;#039;在端子&amp;#039;&lt;br /&gt;
WHEN TA522&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA523=&amp;#039;&amp;#039; THEN &amp;#039;在焊接&amp;#039;&lt;br /&gt;
WHEN TA520&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA521=&amp;#039;&amp;#039; THEN &amp;#039;在裁線&amp;#039;&lt;br /&gt;
END) AS TA527,(SELECT CASE WHEN TC012&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN TC012 ELSE X.UDF02 END)AS TC012&lt;br /&gt;
FROM v_COPTCD X&lt;br /&gt;
JOIN v_MOCTANOTV ON &lt;br /&gt;
TD001=(SELECT CASE WHEN TA033&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN &amp;#039;400&amp;#039; ELSE TA026 END)&lt;br /&gt;
				AND TD002=(SELECT CASE WHEN TA033&amp;lt;&amp;gt;&amp;#039;&amp;#039; THEN REPLACE(TA033,&amp;#039;*&amp;#039;,&amp;#039;&amp;#039;) ELSE TA027 END)&lt;br /&gt;
				AND TD003=(SELECT CASE WHEN TA033&amp;lt;&amp;gt;&amp;#039;&amp;#039; AND TA028=&amp;#039;&amp;#039; THEN TD003 ELSE TA028 END) &lt;br /&gt;
JOIN COPMA ON MA001=TC004&lt;br /&gt;
WHERE TD002&amp;gt;&amp;#039;151001000&amp;#039; AND TA010=&amp;#039;20151207&amp;#039;&lt;br /&gt;
&lt;br /&gt;
&amp;lt;/sql&amp;gt;&lt;/div&gt;</summary>
		<author><name>Root</name></author>
	</entry>
</feed>