%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%> <% ' *** Restrict Access To Page: Grant or deny access to this page MM_authorizedUsers="ADMIN,VENDEDOR,GERENTE,RESP_ZONA,ESPECIALISTA" MM_authFailedURL="login.asp" MM_grantAccess=false If Session("MM_Username") <> "" Then If (false Or CStr(Session("MM_UserAuthorization"))="") Or _ (InStr(1,MM_authorizedUsers,Session("MM_UserAuthorization"))>=1) Then MM_grantAccess = true End If End If If Not MM_grantAccess Then MM_qsChar = "?" If (InStr(1,MM_authFailedURL,"?") >= 1) Then MM_qsChar = "&" MM_referrer = Request.ServerVariables("URL") if (Len(Request.QueryString()) > 0) Then MM_referrer = MM_referrer & "?" & Request.QueryString() MM_authFailedURL = MM_authFailedURL & MM_qsChar & "accessdenied=" & Server.URLEncode(MM_referrer) Response.Redirect(MM_authFailedURL) End If %> <% if request("ENCA")<>"" THEN Response.Cookies("ENCA")=cstr(request("ENCA")) END IF %> <% Dim ct__VIDCOT ct__VIDCOT = "1" If (request("id") <> "") Then ct__VIDCOT = request("id") End If %> <% Dim ct Dim ct_numRows Set ct = Server.CreateObject("ADODB.Recordset") ct.ActiveConnection = MM_maq_STRING ct.Source = "SELECT * FROM COTS WHERE IDCOTIZACION=" + strreplace(ct__VIDCOT, "'", "''") + "" ct.CursorType = 0 ct.CursorLocation = 2 ct.LockType = 1 ct.Open() ct_numRows = 0 %> <% IDMQ="1" IDPROSP="1" IF NOT ct.EOF then IDMQ=cstr(ct("IDMAQUINA")) IDPROSP=cstr(ct("IDPROSPECTO")) END IF %> <% Dim ents__VDMQ ents__VDMQ = "-1" If (IDMQ <> "") Then ents__VDMQ = IDMQ End If %> <% Dim ents Dim ents_numRows Set ents = Server.CreateObject("ADODB.Recordset") ents.ActiveConnection = MM_maq_STRING ents.Source = "SELECT COTDET.CLAVE, COTDET.DESCR FROM COTDET WHERE COTDET.IDMAQUINA=" + strreplace(ents__VDMQ, "'", "''") + " ORDER BY IDACCESORIO" ents.CursorType = 0 ents.CursorLocation = 2 ents.LockType = 1 ents.Open() ents_numRows = 0 %> <% oclt="MAQUINA" %> <% Dim tt Dim tt_numRows Set tt = Server.CreateObject("ADODB.Recordset") tt.ActiveConnection = MM_maq_STRING tt.Source = "SELECT * FROM MAQUINA WHERE IDMAQUINA=" +IDMQ tt.CursorType = 0 tt.CursorLocation = 2 tt.LockType = 1 tt.Open() tt_numRows = 0 %> <% Dim cte__IDDBS cte__IDDBS = "05070" If (IDPROSP <> "") Then cte__IDDBS = IDPROSP End If %> <% Dim cte Dim cte_numRows Set cte = Server.CreateObject("ADODB.Recordset") cte.ActiveConnection = MM_maq_STRING cte.Source = "SELECT * FROM PROSPECTOS WHERE IDCLIENTE='" + strreplace(cte__IDDBS, "'", "''") + "'" cte.CursorType = 0 cte.CursorLocation = 2 cte.LockType = 1 cte.Open() cte_numRows = 0 %> <% Dim mqdescr__IDMQ mqdescr__IDMQ = "1" If (IDMQ <> "") Then mqdescr__IDMQ = IDMQ End If %> <% Dim mqdescr Dim mqdescr_numRows Set mqdescr = Server.CreateObject("ADODB.Recordset") mqdescr.ActiveConnection = MM_maq_STRING mqdescr.Source = "SELECT DESCR, MAQUINA,DESCRIPCION,CONFBC FROM MAQUINA WHERE IDMAQUINA=" + strreplace(mqdescr__IDMQ, "'", "''") + "" mqdescr.CursorType = 0 mqdescr.CursorLocation = 2 mqdescr.LockType = 1 mqdescr.Open() mqdescr_numRows = 0 %> <% set fin = Server.CreateObject("ADODB.Recordset") fin.ActiveConnection = MM_maq_STRING fin.Source = "SELECT * FROM FINANCIAMIENTO" fin.CursorType = 0 fin.CursorLocation = 2 fin.LockType = 3 fin.Open() fin_numRows = 0 %> <% Dim valco Dim valco_numRows Set valco = Server.CreateObject("ADODB.Recordset") valco.ActiveConnection = MM_maq_STRING valco.Source = "SELECT * FROM VALCOTS" valco.CursorType = 0 valco.CursorLocation = 2 valco.LockType = 1 valco.Open() valco_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = 30 Repeat1__index = 0 ents_numRows = ents_numRows + Repeat1__numRows %> <% dim SZ() dim DT() dim head() dim cpos() KEYFL="" imgfld="STATUS" oclt="" redim SZ(ents.Fields.Count) redim DT(ents.Fields.Count) redim head(ents.Fields.Count) redim cpos(ents.Fields.Count) for n=0 to ents.Fields.Count-1 SZ(n)= cstr(ents.Fields.Item(n).DefinedSize ) DT(n)= cstr(ents.Fields.Item(n).Type ) head(n)=cstr(ents.Fields.Item(n).name) cpos(n)=cstr(ents.Fields.Item(n).name) next %> <%rem response.Redirect("es.asp?cmd="+cpos(4))%>