<%@LANGUAGE="VBSCRIPT"%> <% Dim MM_editAction MM_editAction = CStr(Request.ServerVariables("SCRIPT_NAME")) If (Request.QueryString <> "") Then MM_editAction = MM_editAction & "?" & Server.HTMLEncode(Request.QueryString) End If ' boolean to abort record edit Dim MM_abortEdit MM_abortEdit = false %> <% If (CStr(Request("MM_insert")) = "form1") Then If (Not MM_abortEdit) Then ' execute the insert Dim MM_editCmd Set MM_editCmd = Server.CreateObject ("ADODB.Command") MM_editCmd.ActiveConnection = MM_padrao_STRING MM_editCmd.CommandText = "INSERT INTO pedidos (data_hora, responsavel, empresa, cnpj, inscricao, endereco, telefone, email, produto, quantidade, obs) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)" MM_editCmd.Prepared = true MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param1", 202, 1, 255, Request.Form("data_hora")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param2", 202, 1, 255, Request.Form("responsavel")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param3", 202, 1, 255, Request.Form("empresa")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param4", 202, 1, 255, Request.Form("cnpj")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param5", 202, 1, 255, Request.Form("inscricao")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param6", 203, 1, 536870910, Request.Form("endereco")) ' adLongVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param7", 202, 1, 255, Request.Form("telefone")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param8", 202, 1, 255, Request.Form("email")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param9", 202, 1, 255, Request.Form("produto")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param10", 202, 1, 255, Request.Form("quantidade")) ' adVarWChar MM_editCmd.Parameters.Append MM_editCmd.CreateParameter("param11", 203, 1, 536870910, Request.Form("obs")) ' adLongVarWChar MM_editCmd.Execute MM_editCmd.ActiveConnection.Close ' append the query string to the redirect URL Dim MM_editRedirectUrl MM_editRedirectUrl = "pedido_sucesso.asp" If (Request.QueryString <> "") Then If (InStr(1, MM_editRedirectUrl, "?", vbTextCompare) = 0) Then MM_editRedirectUrl = MM_editRedirectUrl & "?" & Request.QueryString Else MM_editRedirectUrl = MM_editRedirectUrl & "&" & Request.QueryString End If End If Response.Redirect(MM_editRedirectUrl) End If End If %> <% Dim rs_menu Dim rs_menu_cmd Dim rs_menu_numRows Set rs_menu_cmd = Server.CreateObject ("ADODB.Command") rs_menu_cmd.ActiveConnection = MM_padrao_STRING rs_menu_cmd.CommandText = "SELECT * FROM menu_produto ORDER BY menu ASC" rs_menu_cmd.Prepared = true Set rs_menu = rs_menu_cmd.Execute rs_menu_numRows = 0 %> <% Dim rs_pedido__MMColParam rs_pedido__MMColParam = "1" If (Request.QueryString("id") <> "") Then rs_pedido__MMColParam = Request.QueryString("id") End If %> <% Dim rs_pedido Dim rs_pedido_cmd Dim rs_pedido_numRows Set rs_pedido_cmd = Server.CreateObject ("ADODB.Command") rs_pedido_cmd.ActiveConnection = MM_padrao_STRING rs_pedido_cmd.CommandText = "SELECT * FROM produto WHERE id = ?" rs_pedido_cmd.Prepared = true rs_pedido_cmd.Parameters.Append rs_pedido_cmd.CreateParameter("param1", 5, 1, -1, rs_pedido__MMColParam) ' adDouble Set rs_pedido = rs_pedido_cmd.Execute rs_pedido_numRows = 0 %> <% Dim rs_busca Dim rs_busca_cmd Dim rs_busca_numRows Set rs_busca_cmd = Server.CreateObject ("ADODB.Command") rs_busca_cmd.ActiveConnection = MM_padrao_STRING rs_busca_cmd.CommandText = "SELECT * FROM menu_produto ORDER BY menu ASC" rs_busca_cmd.Prepared = true Set rs_busca = rs_busca_cmd.Execute rs_busca_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rs_menu_numRows = rs_menu_numRows + Repeat1__numRows %> <% Dim HLooper1__numRows HLooper1__numRows = 30 Dim HLooper1__index HLooper1__index = 0 rs_produto_numRows = rs_produto_numRows + HLooper1__numRows %> :: FastCut ::

<% While ((Repeat1__numRows <> 0) AND (NOT rs_menu.EOF)) %>
" class="style3 style4"><%=(rs_menu.Fields.Item("menu").Value)%>
<% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rs_menu.MoveNext() Wend %>

 


















Pedido de Orçamento

" width="182" height="181" />

Data/Hora:
Responsável:
Empresa:
CNPJ:
Inscrição:
Endereço:
Telefone:
E-mail:
Produto: " size="32" /> Digite o nome do produto.
Quantidade:
Obs. Digite a quantidade.
 

 

<% rs_menu.Close() Set rs_menu = Nothing %> <% rs_pedido.Close() Set rs_pedido = Nothing %> <% rs_busca.Close() Set rs_busca = Nothing %>