File Manager

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />

<title>�к���Ǩ�ͺ��¨��¡���Թ</title>

<style type="text/css">

</style>

</head>

</table></td>
    <td align="left" valign="top">
	<%
	idkey=session("idkey")
	if idkey="" then
	idkey=request("idkey")
	end if
	sqlc="select * from payment where id_pay="&idkey&""
	 set orsc= Server.CreateObject("adodb.recordset")
	 orsc.open sqlc,conn,1,3
	 if not orsc.eof then

%>
	
      <table width="500" border="0" align="center">
        <tr>
          <td colspan="2" bgcolor="#CC99FF"><div align="center"><strong>��������´��������</strong></div></td>
        </tr>
        <tr>
          <td width="206">���ʤ�������</td>
          <td width="284"><%
		  response.write orsc("id_pay")
		  
		  %></td>
        </tr>
        <tr>
          <td bgcolor="F1F2F0">�է�����ҳ</td>
          <td bgcolor="F1F2F0"><%
		  response.write orsc("ypay")
		 
		  %></td>
        </tr>
        <tr>
          <td>������������ҳ</td>
          <td><%
		  response.write orsc("id_budget_type")
		   id_budget_type=orsc("id_budget_type")
		 ' response.write id_budget_type
		  sqlbt="select * from type_budget where id_budget_type ="&orsc("id_budget_type")&""
		  set orsbt=server.createobject("adodb.recordset")
		 ' response.write sqlbt
		 ' response.write id_budget_type
		  orsbt.open sqlbt,conn,1,3
		  if not orsbt.eof then
		 response.write orsbt("n_budget_type")
		 ' response.write id_budget_type
		  end if
		  %></td>
        </tr>
        <tr>
          <td bgcolor="F1F2F0">�Ţ�ա�</td>
          <td bgcolor="F1F2F0"><%
		  response.write orsc("id_dka")
		  
		  
		  %></td>
        </tr>
        <tr>
          <td>��������</td>
          <td><%
		  response.write orsc("id_paysub_sub")
		  sqlpss="select * from paysub_sub where id_paysub_sub ="&orsc("id_paysub_sub")&""
		  set orspss=server.createobject("adodb.recordset")
		 ' response.write sqlbt
		 ' response.write id_budget_type
		  orspss.open sqlpss,conn,1,3
		  if not orspss.eof then
		  response.write orspss("n_paysub_sub")
		 ' response.write id_budget_type
		  end if
		  
		  %></td>
        </tr>
        <tr>
          <td bgcolor="F1F2F0">��Ǵ����</td>
          <td bgcolor="F1F2F0"><%
		  response.write orsc("id_paysub")
		   sqlps="select * from paysub where id_paysub="&orsc("id_paysub")&""
		  set orsps=server.createobject("adodb.recordset")
		 ' response.write sqlbt
		 ' response.write id_budget_type
		  orsps.open sqlps,conn,1,3
		  if not orsps.eof then
		  response.write orsps("n_paysub")
		 ' response.write id_budget_type
		  end if
		  %></td>
        </tr>
        <tr>
          <td>��Ǵ��ѡ</td>
          <td><%
		  response.write orsc("id_paymain")
		   sqlpm="select * from paymain where id_paymain ="&orsc("id_paymain")&""
		  set orspm=server.createobject("adodb.recordset")
		 ' response.write sqlbt
		 ' response.write id_budget_type
		  orspm.open sqlpm,conn,1,3
		  if not orspm.eof then
		  response.write orspm("n_paymain")
		 ' response.write id_budget_type
		  end if
		  %></td>
        </tr>
        <tr>
          <td bgcolor="F1F2F0">�ѹ��͹���͡���</td>
          <td bgcolor="F1F2F0"><%
		  response.write orsc("dp")&"/"&orsc("mp")&"/"&orsc("yp")
		  
		  %></td>
        </tr>
        <tr>
          <td>�ӹǹ�Թ</td>
          <td><%
		  response.write orsc("amountp")
		  
		  %></td>
        </tr>
		 <tr>
          <td bgcolor="F1F2F0">Ἱ������ҳ</td>
          <td bgcolor="F1F2F0"><%
		  response.write orsc("plan_budget")
		  sqlpb="select * from plan_budget where id ="&orsc("plan_budget")&""
		  set orspb=server.createobject("adodb.recordset")
		 ' response.write sqlbt
		 ' response.write id_budget_type
		  orspb.open sqlpb,conn,1,3
		  if not orspb.eof then
		  response.write orspb("plan_budget_name")
		 ' response.write id_budget_type
		  end if
		  %></td>
        </tr>
		 <tr>
          <td>�ż�Ե</td>
          <td><%
		  response.write orsc("outcome")
		
		  sqlo="select * from outcome where id ="&orsc("outcome")&""
		  set orso=server.createobject("adodb.recordset")
		  orso.open sqlo,conn,1,3
		  if not orso.eof then
		  response.write orso("outcome_name")
		  end if
		  
		  %></td>
        </tr>
        <tr>
          <td bgcolor="F1F2F0">���ѹ�֡</td>
          <td bgcolor="F1F2F0"><%
		  response.write orsc("username")
		  
		  %></td>
        </tr>
        <tr>
          <td>�ѹ���ҷ��ѹ�֡</td>
          <td><%
		  response.write orsc("date_mo")
		  
		  %></td>
        </tr>
        <tr>
          <td colspan="2" bgcolor="#CC66FF"><div align="center" class="style1">[<a href="index_pay_budget.asp">Add</a>] [<a href="edit_payment.asp?idkey=<%=idkey%>">Edit</a>] [<a href="del_payment.asp">Delete</a>]</div></td>
        </tr>
      </table>
	  <%
	  else
	  response.write "no data"
	   end if
	  %>
    </td>
  </tr>
</table>
</body>
</html>

File Manager

Editing: finance/detail_payment.asp.bak