?? seach_info.asp
字號:
<p>
<table>
<tr>
<td>
<%
sql4="select * from cost where ref_no = '"&rs("ref_no")&"' and types = 1"
rs4.open sql4,conn,1,3
if not rs4.eof then
%>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"id="AutoNumber1">
<tr><td>
<p align="center"><b><font color="#FFFFFF">威康紡織成衣成本分析表</font></b></td></tr><tr><td>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1" width="737">
<tr align=center>
<td width="77">
<span lang="zh-cn">分廠</span></td>
<td width="367" colspan="5" align="left">
<%
sql7="select * from filiale where id = "&rs4("filiale")&" "
rs7.open sql7,conn,3,1
if not rs7.eof then
response.write rs7("cn_name")
rs7.close
end if
%> </td>
<td width="67">
</td>
<td width="88">
</td>
<td width="203" colspan="3"><%=rs4("date_time")%>
</td>
</tr>
<tr align="center">
<td width="77">類型</td>
<td width="64">LD.NO</td>
<td width="64">客戶</td>
<td width="69">款號</td>
<td width="69">訂量</td>
<td width="98">款式</td>
<td width="67">固打</td>
<td width="88">副料</td>
<td width="69">副料<span lang="zh-cn">（實）</span></td>
<td width="70">業務經理</td>
<td width="64">業務</td>
</tr>
<tr align="center">
<td width="77">成本分析</td>
<td width="64"><input type="text" name="ref_no" size="7" value="<%=rs4("ref_no")%>"></td>
<td width="64">
<%
sql9="select * from client"
rs9.open sql9,conn,1,3
if not rs9.eof then
%>
<input type="text" name="client" size="7" value="<%=rs9("en_name")%>">
<%
rs9.movenext
rs9.close
end if
%>
</td>
<td width="69"><input type="text" name="style_no" size="7" value="<%=rs4("style_no")%>" ></td>
<td width="69"><input type="text" name="order" size="7" value="<%=rs4("order")%>" ></td>
<td width="98"><input type="text" name="style" size="7" value="<%=rs4("style")%>" ></td>
<td width="67"><input type="text" name="guda" size="7" value="<%=rs4("guda")%>" ></td>
<td width="88"><input type="text" name="access_1" size="7" value="<%=rs4("access_1")%>" ></td>
<td width="69"><input type="text" name="access_2" size="7" value="<%=rs4("access_2")%>" ></td>
<td width="70"><input type="text" name="operation_ma" size="7" value="<%=rs4("operation_ma")%>" ></td>
<td width="64"><input type="text" name="operation" size="7" value="<%=rs4("operation")%>" ></td>
</tr>
<tr align="center">
<td width="77">CMT/DZ</td>
<td width="64">工繳US$</td>
<td width="64">（本）工繳</td>
<td width="69">（代）工繳</td>
<td width="69">傭金US$</td>
<td width="98">傭金(出)US$</td>
<td width="67">管理費US$</td>
<td width="88">化驗費US$</td>
<td width="69">銀行費US$</td>
<td width="70">運費US$</td>
<td width="64">FOB US$/DZ</td>
</tr>
<tr align="center">
<td width="77"><input type="text" name="cmt_dz" size="8" value="<%=rs4("cmt_dz")%>"></td>
<td width="64"><input type="text" name="process_1" size="7" value="<%=rs4("process_1")%>"></td>
<td width="64"><input type="text" name="process_2" size="7" value="<%=rs4("process_2")%>"></td>
<td width="69"><input type="text" name="process_3" size="7" value="<%=rs4("process_3")%>"></td>
<td width="69"><input type="text" name="commision_1" size="7" value="<%=rs4("commision_1")%>"></td>
<td width="98"><input type="text" name="commision_2" size="7" value="<%=rs4("commision_2")%>"></td>
<td width="67"><input type="text" name="overhead_expenses" size="7" value="<%=rs4("overhead_expenses")%>"></td>
<td width="88"><input type="text" name="assay" size="7" value="<%=rs4("assay")%>"></td>
<td width="69"><input type="text" name="bank" size="7" value="<%=rs4("bank")%>"></td>
<td width="70"><input type="text" name="traffic" size="7" value="<%=rs4("traffic")%>"></td>
<td width="64"><input type="text" name="fob" size="7" value="<%=rs4("fob")%>"></td>
</tr>
<tr align=center>
<td width="207" colspan="3">
<p align="center">布價</td>
<td width="139" colspan="2">大貨布狀況</td>
<td width="98">L/C</td>
<td width="67">L/C</td>
<td width="88">賣價</td>
<td width="69">(出)賣價</td>
<td width="70">盈虧</td>
<td width="64">實盈虧</td>
</tr>
<tr align=center>
<td width="77">供應</td>
<td width="64">針織</td>
<td width="64">其它</td>
<td width="69">交布期</td>
<td width="69">布實際</td>
<td width="98">S.DATE</td>
<td width="67">E.DATE</td>
<td width="88">US$</td>
<td width="69">US$</td>
<td width="70">US$</td>
<td width="64">US$</td>
</tr>
<tr>
<td width="77"><input type="text" name="produce" size="8" value="<%=rs4("produce")%>"></td>
<td width="64"><input type="text" name="knitting" size="7" value="<%=rs4("knitting")%>"></td>
<td width="64"><input type="text" name="other" size="7" value="<%=rs4("other")%>"></td>
<td width="69"><input type="text" name="delivery_1" size="7" value="<%=rs4("delivery_1")%>"></td>
<td width="69"><input type="text" name="delivery_2" size="7" value="<%=rs4("delivery_2")%>"></td>
<td width="98"><input type="text" name="s_date" size="7" value="<%=rs4("s_date")%>"></td>
<td width="67"><input type="text" name="e_date" size="7" value="<%=rs4("e_date")%>"></td>
<td width="88"><input type="text" name="sale_price_1" size="7" value="<%=rs4("sale_price_1")%>"></td>
<td width="69"><input type="text" name="sale_price_2" size="7" value="<%=rs4("sale_price_2")%>"></td>
<td width="70"><input type="text" name="gain_1" size="7" value="<%=rs4("gain_1")%>"></td>
<td width="64"><input type="text" name="gain_2" size="7" value="<%=rs4("gain_2")%>"></td>
</tr>
</table>
<%
rs4.close
else
response.write "<br>"
response.write "該訂單還沒有輸入有效的成本分析!"
rs4.close
end if
%>
<p align=right>
<a href=#top>Back</a>
<p>
<a name="cost2">
<%
sql4="select * from cost where ref_no = '"&rs("ref_no")&"' and types = 2"
rs4.open sql4,conn,1,3
if not rs4.eof then
%>
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"id="AutoNumber1">
<tr><td>
<p align="center"><b><font color="#FFFFFF">威康紡織成衣實際成本表</font></b></td></tr><tr><td>
<table border="1" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" id="AutoNumber1" width="737">
<tr align=center>
<td width="77">
<span lang="zh-cn">分廠</span></td>
<td width="367" colspan="5" align="left">
<%
sql7="select * from filiale where id = "&rs4("filiale")&" "
rs7.open sql7,conn,3,1
if not rs7.eof then
response.write rs7("cn_name")
rs7.close
end if
%> </td>
<td width="67">
</td>
<td width="88">
</td>
<td width="203" colspan="3"><%=rs4("date_time")%>
</td>
</tr>
<tr align="center">
<td width="77">類型</td>
<td width="64">LD.NO</td>
<td width="64">客戶</td>
<td width="69">款號</td>
<td width="69">訂量</td>
<td width="98">款式</td>
<td width="67">固打</td>
<td width="88">副料</td>
<td width="69">副料<span lang="zh-cn">（實）</span></td>
<td width="70">業務經理</td>
<td width="64">業務</td>
</tr>
<tr align="center">
<td width="77">成本分析</td>
<td width="64"><input type="text" name="ref_no" size="7" value="<%=rs4("ref_no")%>"></td>
<td width="64">
<%
sql9="select * from client"
rs9.open sql9,conn,1,3
if not rs9.eof then
%>
<input type="text" name="client" size="7" value="<%=rs9("en_name")%>">
<%
rs9.movenext
rs9.close
end if
%>
</td>
<td width="69"><input type="text" name="style_no" size="7" value="<%=rs4("style_no")%>" ></td>
<td width="69"><input type="text" name="order" size="7" value="<%=rs4("order")%>" ></td>
<td width="98"><input type="text" name="style" size="7" value="<%=rs4("style")%>" ></td>
<td width="67"><input type="text" name="guda" size="7" value="<%=rs4("guda")%>" ></td>
<td width="88"><input type="text" name="access_1" size="7" value="<%=rs4("access_1")%>" ></td>
<td width="69"><input type="text" name="access_2" size="7" value="<%=rs4("access_2")%>" ></td>
<td width="70"><input type="text" name="operation_ma" size="7" value="<%=rs4("operation_ma")%>" ></td>
<td width="64"><input type="text" name="operation" size="7" value="<%=rs4("operation")%>" ></td>
</tr>
<tr align="center">
<td width="77">CMT/DZ</td>
<td width="64">工繳US$</td>
<td width="64">（本）工繳</td>
<td width="69">（代）工繳</td>
<td width="69">傭金US$</td>
<td width="98">傭金(出)US$</td>
<td width="67">管理費US$</td>
<td width="88">化驗費US$</td>
<td width="69">銀行費US$</td>
<td width="70">運費US$</td>
<td width="64">FOB US$/DZ</td>
</tr>
<tr align="center">
<td width="77"><input type="text" name="cmt_dz" size="8" value="<%=rs4("cmt_dz")%>"></td>
<td width="64"><input type="text" name="process_1" size="7" value="<%=rs4("process_1")%>"></td>
<td width="64"><input type="text" name="process_2" size="7" value="<%=rs4("process_2")%>"></td>
<td width="69"><input type="text" name="process_3" size="7" value="<%=rs4("process_3")%>"></td>
<td width="69"><input type="text" name="commision_1" size="7" value="<%=rs4("commision_1")%>"></td>
<td width="98"><input type="text" name="commision_2" size="7" value="<%=rs4("commision_2")%>"></td>
<td width="67"><input type="text" name="overhead_expenses" size="7" value="<%=rs4("overhead_expenses")%>"></td>
<td width="88"><input type="text" name="assay" size="7" value="<%=rs4("assay")%>"></td>
<td width="69"><input type="text" name="bank" size="7" value="<%=rs4("bank")%>"></td>
<td width="70"><input type="text" name="traffic" size="7" value="<%=rs4("traffic")%>"></td>
<td width="64"><input type="text" name="fob" size="7" value="<%=rs4("fob")%>"></td>
</tr>
<tr align=center>
<td width="207" colspan="3">
<p align="center">布價</td>
<td width="139" colspan="2">大貨布狀況</td>
<td width="98">L/C</td>
<td width="67">L/C</td>
<td width="88">賣價</td>
<td width="69">(出)賣價</td>
<td width="70">盈虧</td>
<td width="64">實盈虧</td>
</tr>
<tr align=center>
<td width="77">供應</td>
<td width="64">針織</td>
<td width="64">其它</td>
<td width="69">交布期</td>
<td width="69">布實際</td>
<td width="98">S.DATE</td>
<td width="67">E.DATE</td>
<td width="88">US$</td>
<td width="69">US$</td>
<td width="70">US$</td>
<td width="64">US$</td>
</tr>
<tr>
<td width="77"><input type="text" name="produce" size="8" value="<%=rs4("produce")%>"></td>
<td width="64"><input type="text" name="knitting" size="7" value="<%=rs4("knitting")%>"></td>
<td width="64"><input type="text" name="other" size="7" value="<%=rs4("other")%>"></td>
<td width="69"><input type="text" name="delivery_1" size="7" value="<%=rs4("delivery_1")%>"></td>
<td width="69"><input type="text" name="delivery_2" size="7" value="<%=rs4("delivery_2")%>"></td>
<td width="98"><input type="text" name="s_date" size="7" value="<%=rs4("s_date")%>"></td>
<td width="67"><input type="text" name="e_date" size="7" value="<%=rs4("e_date")%>"></td>
<td width="88"><input type="text" name="sale_price_1" size="7" value="<%=rs4("sale_price_1")%>"></td>
<td width="69"><input type="text" name="sale_price_2" size="7" value="<%=rs4("sale_price_2")%>"></td>
<td width="70"><input type="text" name="gain_1" size="7" value="<%=rs4("gain_1")%>"></td>
<td width="64"><input type="text" name="gain_2" size="7" value="<%=rs4("gain_2")%>"></td>
</tr>
</table>
</td></tr></table>
<%
rs4.close
else
response.write "<br>"
response.write "該訂單還沒有輸入有效的實際成本!"
end if
%>
<p align=right><a href=#top>Back</a></td></tr></table></center>
</table>
</a>
<!--#include file="../copyright.asp" -->?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -