edit_cost.asp

oa办公系统asp程序

<!--#include file="../title.asp" -->
<%
ref=request("ref")
types=request("types")

sql="select * from cost where ref_no = '"&ref&"' and types = "&types&" "
rs.open sql,conn,1,3
if not rs.eof then
%>
<form method="POST" action="rs_cost_edit.asp?id=<%=rs("id")%>">
<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")%>" <% if rs3("id") = rs("filiale") then%>selected<%end if%> ><%=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(rs("date_time")) 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(rs("date_time")) 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(rs("date_time")) 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">
      <select size="1" name="types">
      <%
      sql4="select * from cost_type"
      rs4.open sql4,conn,3,1
      do while not rs4.eof
      %>
      <option value="<%=rs4("id")%>" <%if rs4("id")=rs("types") then%>selected<%end if%>><%=rs4("cn_name")%></option>
      <%
      rs4.movenext
      loop
      %>
      </select></td>
    <td width="64"><input type="text" name="ref_no" size="7" value="<%=rs("ref_no")%>"></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" value="<%=rs("style_no")%>"></td>
    <td width="69"><input type="text" name="order" size="7" value="<%=rs("order")%>"></td>
    <td width="98"><input type="text" name="style" size="7" value="<%=rs("style")%>"></td>
    <td width="67"><input type="text" name="guda" size="7" value="<%=rs("guda")%>"></td>
    <td width="88"><input type="text" name="access_1" size="7" value="<%=rs("access_1")%>"></td>
    <td width="69"><input type="text" name="access_2" size="7" value="<%=rs("access_2")%>"></td>
    <td width="70"><input type="text" name="operation_ma" size="7" value="<%=rs("operation_ma")%>"></td>
    <td width="64"><input type="text" name="operation" size="7" value="<%=rs("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="<%=rs("cmt_dz")%>"></td>
    <td width="64"><input type="text" name="process_1" size="7" value="<%=rs("process_1")%>"></td>
    <td width="64"><input type="text" name="process_2" size="7" value="<%=rs("process_2")%>"></td>
    <td width="69"><input type="text" name="process_3" size="7" value="<%=rs("process_3")%>"></td>
    <td width="69"><input type="text" name="commision_1" size="7" value="<%=rs("commision_1")%>"></td>
    <td width="98"><input type="text" name="commision_2" size="7" value="<%=rs("commision_2")%>"></td>
    <td width="67"><input type="text" name="overhead_expenses" size="7" value="<%=rs("overhead_expenses")%>"></td>
    <td width="88"><input type="text" name="assay" size="7" value="<%=rs("assay")%>"></td>
    <td width="69"><input type="text" name="bank" size="7" value="<%=rs("bank")%>"></td>
    <td width="70"><input type="text" name="traffic" size="7" value="<%=rs("traffic")%>"></td>
    <td width="64"><input type="text" name="fob" size="7" value="<%=rs("fob")%>"></td>
  </tr>
  <tr align=center>
    <td width="207" colspan="3">布价</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">盈亏</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="<%=rs("produce")%>"></td>
    <td width="64"><input type="text" name="knitting" size="7" value="<%=rs("knitting")%>"></td>
    <td width="64"><input type="text" name="other" size="7" value="<%=rs("other")%>"></td>
    <td width="69"><input type="text" name="delivery_1" size="7" value="<%=rs("delivery_1")%>"></td>
    <td width="69"><input type="text" name="delivery_2" size="7" value="<%=rs("delivery_2")%>"></td>
    <td width="98"><input type="text" name="s_date" size="7" value="<%=rs("s_date")%>"></td>
    <td width="67"><input type="text" name="e_date" size="7" value="<%=rs("e_date")%>"></td>
    <td width="88"><input type="text" name="sale_price_1" size="7" value="<%=rs("sale_price_1")%>"></td>
    <td width="69"><input type="text" name="sale_price_2" size="7" value="<%=rs("sale_price_2")%>"></td>
    <td width="70"><input type="text" name="gain_1" size="7" value="<%=rs("gain_1")%>"></td>
    <td width="64"><input type="text" name="gain_2" size="7" value="<%=rs("gain_2")%>"></td>
  </tr>

  </table>
      <p align="center">
      <input type="submit" value="提交" name="B1"><input type="reset" value="重置" name="B2"></p>
</p>
</td></tr></table>
    </form>

    <%
   	else 
   	response.write "<p>"
   	response.write " 对不起!该订单还没有有效的"
   	sql6="select * from cost_type where id = "&types&" "
   	rs6.open sql6,conn,1,3
   	if not rs6.eof then
   	response.write rs6("cn_name")
   	end if
   	response.write "!"
   	%>
	<meta http-equiv="refresh" content='2; URL="javascript:history.go(-1)"'>

   	<%
    end if
    rs.close
    %><!--#include file="../copyright.asp" -->