cost.asp

oa办公系统asp程序

<!--#include file="../title.asp" -->

    <form method="POST" action="rs_cost.asp">
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111"id="AutoNumber1">
<tr><td>
  <p align="center"><b><font size="6" face="黑体" 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">
      <select size="1" name="filiale">
         <%
         sql3="select * from filiale"
         rs3.open sql3,conn,3,1
         do while not rs3.eof
         %>
         <option value="<%=rs3("id")%>"><%=rs3("cn_name")%></option>
         <%
         rs3.movenext
         loop
         rs3.close
         %>
         </select></td>
    <td width="67">
      　</td>
    <td width="88">
      　</td>
    <td width="203" colspan="3">
      <p align="right">
      <select size="1" name="date_year">
      <%
      x=2000
      do while x<=2012
      %>
      <option value="<%=x%>" <%if x=year(now) then %>selected<%end if%>><%=x%></option>
<%
x=x+1
loop
%>
      </select>年<select size="1" name="date_month">
      <%
      x=1
      do while x<=12
      %>	
      <option value="<%=x%>" <%if x=month(now) then %>selected<%end if%>><%=x%></option>
<%
x=x+1
loop
%>
      </select>月<select size="1" name="date_day">
      <%
      x=1
      do while x<=31
      %>	
      <option value="<%=x%>" <%if x=day(now) then %>selected<%end if%>><%=x%></option>
<%
x=x+1
loop
%>
      </select>日</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"></td>
    <td width="64">
            <select size="1" name="client">
         <%
         sql5="select * from client"
         rs5.open sql5,conn,1,3
         do while not rs5.eof
         %>
         <option value="<%=rs5("id")%>"><%=rs5("en_name")%></option>
         <%
         rs5.movenext
         loop
         rs5.close
         %>
         </select></td>
    <td width="69">
      <input type="text" name="style_no" size="7"></td>
    <td width="69">
      <input type="text" name="order" size="7"></td>
    <td width="98">
      <input type="text" name="style" size="7"></td>
    <td width="67">
      <input type="text" name="guda" size="7"></td>
    <td width="88">
      <input type="text" name="access_1" size="7"></td>
    <td width="69">
      <input type="text" name="access_2" size="7"></td>
    <td width="70">
      <input type="text" name="operation_ma" size="7"></td>
    <td width="64">
      <input type="text" name="operation" size="7"></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<span lang="zh-cn"> </span>US$/DZ</td>
  </tr>
  <tr align="center">
    <td width="77">
      <input type="text" name="cmt_dz" size="8"></td>
    <td width="64">
      <input type="text" name="process_1" size="7"></td>
    <td width="64">
      <input type="text" name="process_2" size="7"></td>
    <td width="69">
      <input type="text" name="process_3" size="7"></td>
    <td width="69">
      <input type="text" name="commision_1" size="7"></td>
    <td width="98">
      <input type="text" name="commision_2" size="7"></td>
    <td width="67">
      <input type="text" name="overhead_expenses" size="7"></td>
    <td width="88">
      <input type="text" name="assay" size="7"></td>
    <td width="69">
      <input type="text" name="bank" size="7"></td>
    <td width="70">
      <input type="text" name="traffic" size="7"></td>
    <td width="64">
      <input type="text" name="fob" size="7"></td>
  </tr>
  <tr align=center>
    <td width="207" colspan="3">
    <p align="center">布价</td>
    <td width="139" colspan="2"><span lang="zh-cn">大货布状况</span></td>
    <td width="98">L/C</td>
    <td width="67">L/C</td>
    <td width="88">卖价</td>
    <td width="69">(出)卖价</td>
    <td width="70"><span lang="zh-cn">盈亏</span></td>
    <td width="64"><span lang="zh-cn">实盈亏</span></td>
  </tr>
  <tr align=center>
    <td width="77">供应</td>
    <td width="64">针织</td>
    <td width="64">其它</td>
    <td width="69"><span lang="zh-cn">交布期</span></td>
    <td width="69"><span lang="zh-cn">布实际</span></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">
      <p align="center">
      <input type="text" name="produce" size="8"></td>
    <td width="64">
      <input type="text" name="kitting" size="7"></td>
    <td width="64">
      <input type="text" name="other" size="7"></td>
    <td width="69">
      <input type="text" name="delivery_1" size="7"></td>
    <td width="69">
      <input type="text" name="delivery_2" size="7"></td>
    <td width="98">
      <p align="center">
      <input type="text" name="d_date" size="7"></td>
    <td width="67">
      <input type="text" name="e_date" size="7"></td>
    <td width="88">
      <input type="text" name="sale_price_1" size="7"></td>
    <td width="69">
      <input type="text" name="sale_price_2" size="7"></td>
    <td width="70">
      <input type="text" name="gain_1" size="7"></td>
    <td width="64">
      <input type="text" name="gain_2" size="7"></td>
  </tr>

  </table>
<p align="center">
<input type="submit" value="提交" name="B1"><input type="reset" value="重置" name="B2">
</p>
</p>
</td></tr></table>
    </form>
<!--#include file="../copyright.asp" -->