📄 seach_info.asp

📁 oa办公系统asp程序
💻 ASP
📖 第 1 页 / 共 2 页
字号:
上一页 12
<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" -->
上一页 12
💿 文件大小 272 K
👤 上传用户 zhangpeng
📂 所属分类 OA系统
🏷️ 相关标签

#asp #程序
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -