
11/11/2005, 18:37
|
 | | | Fecha de Ingreso: abril-2005
Mensajes: 35
Antigüedad: 20 años Puntos: 0 | |
<%@LANGUAGE="JAVASCRIPT"%>
<!--#include file="Connections/Conn_incidencias.asp" -->
<%
var Rs_index = Server.CreateObject("ADODB.Recordset");
Rs_index.ActiveConnection = MM_Conn_incidencias_STRING;
Rs_index.Source = "SELECT * FROM incidencias ORDER BY numero_incidencia DESC";
Rs_index.CursorType = 0;
Rs_index.CursorLocation = 2;
Rs_index.LockType = 1;
Rs_index.Open();
var Rs_index_numRows = 0;
%>
<%
var Rs_solo = Server.CreateObject("ADODB.Recordset");
Rs_solo.ActiveConnection = MM_Conn_incidencias_STRING;
Rs_solo.Source = "SELECT * FROM instalaciones";
Rs_solo.CursorType = 0;
Rs_solo.CursorLocation = 2;
Rs_solo.LockType = 1;
Rs_solo.Open();
var Rs_solo_numRows = 0;
%>
<%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
Rs_index_numRows += Repeat1__numRows;
%>
<% var MM_paramName = ""; %>
<%
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters
// create the list of parameters which should not be maintained
var MM_removeList = "&index=";
if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "=";
var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_kee pNone="";
// add the URL parameters to the MM_keepURL string
for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
var nextItem = "&" + items.item().toLowerCase() + "=";
if (MM_removeList.indexOf(nextItem) == -1) {
MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item()) );
}
}
// add the Form variables to the MM_keepForm string
for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) {
var nextItem = "&" + items.item().toLowerCase() + "=";
if (MM_removeList.indexOf(nextItem) == -1) {
MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item()));
}
}
// create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL + MM_keepForm;
if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1);
if (MM_keepURL.length > 0) MM_keepURL = MM_keepURL.substring(1);
if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1);
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<title>Documento sin título</title>
<style type="text/css">
<!--
body {
background-color: #CCCCCC;
}
.Estilo3 {
font-family: Arial, Helvetica, sans-serif;
font-size: 24px;
}
.Estilo7 {
font-size: 12px;
color: #003366;
}
.Estilo10 {
font-size: 12px;
color: #FFFFFF;
}
a:link {
text-decoration: none;
}
a:visited {
text-decoration: none;
}
a:hover {
text-decoration: none;
}
a:active {
text-decoration: none;
}
.Estilo11 {font-size: 12px}
-->
</style>
</head>
<body>
<div align="center">
<form action="" method="post" name="form_solo" id="form_solo">
<table width="600" border="0" cellspacing="4" cellpadding="0">
<tr>
<td width="300"><div align="right"><a href="#" class="Estilo11">Mostrar solo </a></div></td>
<td width="300"><div align="left">
<p>
<select name="select" onChange="window.location = 'centro.asp?id=' + this.value;">
<%
while (!Rs_solo.EOF) {
%>
<option value="<%=Rs_solo("id")%>">
<%=Rs_solo ("nombre_de_instalacion")%>
</option>
<%
Rs_solo.MoveNext();
}
if (Rs_solo.CursorType > 0) {
if (!Rs_solo.BOF) Rs_solo.MoveFirst();
} else {
Rs_solo.Requery();
}
%>
</select>
</p>
</div></td>
</tr>
</table>
<p> </p>
<table width="46" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="25"><a href="nuevaincidencia.asp" target="_self"><img src="img/botones/icosolotexto.gif" alt="nueva incidencia" width="21" height="24" border="0"></a></td>
<td width="21"><a href="borrar.asp" target="_self"><img src="img/botones/icosoloBORRAR.GIF" alt="Borrar incidencia" width="21" height="24" border="0"></a></td>
</tr>
</table>
<br>
<table width="700" border="0" cellpadding="0" cellspacing="0" bordercolor="#FF0000">
<tr>
<td width="700" bgcolor="#FFFFFF"><div align="center" class="Estilo3">Incidencias</div></td>
</tr>
<tr>
<td><% while ((Repeat1__numRows-- != 0) && (!Rs_index.EOF)) { %>
<br>
<table width="750" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#666666">
<tr><td width="75" align="center" valign="middle" bgcolor="#0000FF"><span class="Estilo10"><%=(Rs_index.Fields.Item("numero_ incidencia").Value)%></span></td>
<td width="250" align="center" valign="middle" bgcolor="#E5E5E5"><strong><font face="Arial, Helvetica, sans-serif" color="#0033CC" size="2"><%=(Rs_index.Fields.Item("nombre de instalacion").Value)%></font></strong></td>
<td width="350" align="left" bgcolor="#E5E5E5"><div align="left"><font face="Arial,Helvetica, sans-serif" size="2"><%=(Rs_index.Fields.Item("titulo").Value) %></font></div></td>
<td width="75" align="center" bgcolor="#E5E5E5"><div align="center"><font face="Arial,Helvetica, sans-serif" size="2"><%=(Rs_index.Fields.Item("fecha_de_incide ncia").Value)%></font></div></td>
<td width="50" bgcolor="#E5E5E5"><div align="center"><span class="Estilo7"><A HREF="detalle_inc.asp?<%= Server.HTMLEncode(MM_keepNone) + ((MM_keepNone!="")?"&":"") + "Id=" + Rs_index.Fields.Item("Id").Value %>" target="_self">Detalle</A></span></div></td>
<td width="50"><div align="center"><span class="Estilo7"> <A HREF="modifincidencia.asp?<%= Server.HTMLEncode(MM_keepNone) + ((MM_keepNone!="")?"&":"") + "Id=" + Rs_index.Fields.Item("Id").Value %>">Modificar</A> </span></div></td>
</tr>
</table>
<table border="0" cellspacing="0" cellpadding="0" bgcolor="#000000" align="center" width="100%">
<tr>
</tr>
</table>
<input type="hidden" name="MM_recordId">
<%
Repeat1__index++;
Rs_index.MoveNext();
}
%>
</td>
</tr>
</table>
</form>
</div>
</body>
</html>
<%
Rs_index.Close();
%>
<%
Rs_solo.Close();
%> |