<% senden = request.form("senden") matgrp = " "&request.form("matgrp")&"," anz = 1 if instr(matgrp," 1,") then anz = anz + 5 if instr(matgrp," 2,") then anz = anz + 10 if instr(matgrp," 3,") then anz = anz + 6 if instr(matgrp," 4,") then anz = anz + 15 if instr(matgrp," 5,") then anz = anz + 9 if instr(matgrp," 6,") then anz = anz + 7 if instr(matgrp," 7,") then anz = anz + 7 if instr(matgrp," 8,") then anz = anz + 5 if instr(matgrp," 9,") then anz = anz + 6 if instr(matgrp," 10,") then anz = anz + 12 if instr(matgrp," 11,") then anz = anz + 10 if instr(matgrp," 12,") then anz = anz + 11 if instr(matgrp," 13,") then anz = anz + 20 if instr(matgrp," 14,") then anz = anz + 1 %> Rittal Purchasing

Information form

Make your application!

<% if not senden = "ja" then %>
Material selection:
Which material groups would you like to receive enquiries for? (Use the "Ctrl" key to select more than one)
What products do you offer? (Use the "Ctrl" key to select more than one)
General data:
Company name:
Legal form of company:
Street / No.:
Postal code / Town:
Country:
Contact:
Telephone:
Fax:
E-mail:
In which of the listed countries do you have offices? (Use the "Ctrl" key to select more than one):
Company data:
Established (year):
Managing Director:
Turnover last year: Thousand Euros
Turnover previous year: Thousand Euros
Permanent staff:
Other employees:
Quality certificates:
Machinery relevant for the selected products:
(Manufacturer, type, number, year of construction)
Reference customers:
Logistics competence:
KanBan: Yes No
JIT (Just In Time): Yes No
Own fleet: Yes No
Size and number of own trucks:
IT equipment: IT accessories
Do you use SAP? SAP R/2
SAP R/3
Do you use an alternative ERP system?
Reset
Submit
<% else On Error Resume Next '---- CursorTypeEnum-Werte ---- Const adOpenForwardOnly = 0 Const adOpenKeyset = 1 Const adOpenDynamic = 2 Const adOpenStatic = 3 '---- LockTypeEnum-Werte ---- Const adLockReadOnly = 1 Const adLockPessimistic = 2 Const adLockOptimistic = 3 Const adLockBatchOptimistic = 4 Dim db_con Dim db_path Dim rs Dim strSql Dim name Dim nummer Dim strConInfo Dim kanban Dim jit Set db_con = Server.CreateObject("ADODB.Connection") Set datensatz = Server.CreateObject("ADODB.RecordSet") db_con.Open "SQL_Lieferanten","InternetNutzer","rittal" ' ein RecordSet-Objekt zum einfügen der neuen Daten in die DB erstellen und öffnen Set rs = Server.CreateObject("ADODB.RecordSet") rs.Open "Lieferanten", db_con,1,3 Adresse = request.form("strasse") &chr(13) & request.form("plzort") ansprech = request.form("ansprechpartner") &chr(13)& "Tel.: " &request.form("telefon") &chr(13)& "Fax: " & request.form("fax") &chr(13)&request.form("email") ' die neuen Daten einfügen rs.AddNew if instr(matgrp," 1,") then rs("m01") = 1 if instr(matgrp," 2,") then rs("m02") = 1 if instr(matgrp," 3,") then rs("m03") = 1 if instr(matgrp," 4,") then rs("m04") = 1 if instr(matgrp," 5,") then rs("m05") = 1 if instr(matgrp," 6,") then rs("m06") = 1 if instr(matgrp," 7,") then rs("m07") = 1 if instr(matgrp," 8,") then rs("m08") = 1 if instr(matgrp," 9,") then rs("m09") = 1 if instr(matgrp," 10,") then rs("m10") = 1 if instr(matgrp," 11,") then rs("m11") = 1 if instr(matgrp," 12,") then rs("m12") = 1 if instr(matgrp," 13,") then rs("m13") = 1 if instr(matgrp," 14,") then rs("m14") = 1 rs("Lieferprogramm") = request.form("prod") rs("Firmen_Adresse") = Adresse rs("Firmen_Land") = request.form("Land ") rs("tgs") = request.form("vertretung") rs("AP1") = ansprech rs("Firmen_Name") = request.form("Firma") rs("gesellschaftsform") = request.form("Gesellschaftsform") rs("gruendungsjahr") = request.form("Gruendungsjahr ") rs("gesch_fuehrer") = request.form("Gesch-fuehrer ") rs("ums_vorjahr") = request.form("Umsatz Vorjahr ") rs("ums_vorvorjahr") = request.form("Umsatz Vorvorjahr") rs("kundenref") = request.form("Kundenreferenz ") rs("angestellte") = request.form("Angestellte ") rs("arbeiter") = request.form("Arbeiter ") rs("zertifikate") = request.form("Zertifikate ") rs("maschinenpark") = request.form("Maschinenpark ") rs("internet") = "ja" rs("lkw") = request.form("LKW ") rs("angelegt") = now kanban = request.form("KanBan ") if kanban = "ja" then rs("kanban") = true else rs("kanban") = false end if jit = request.form("JIT " ) if jit = "ja" then rs("jit") = true else rs("jit") = false end if fuhrpark = request.form("fuhrpark " ) if fuhrpark = "ja" then rs("fuhrpark") = true else rs("fuhrpark") = false end if rs("sap") = request.form("SAP ") rs("alt_warenwirtsch_prg") = request.form("Alternatives Warenwirtschafts-System") rs.update ' Verbindungen schließen rs.Close db_con.Close Set rs = Nothing Set db_con = Nothing 'Materialgruppe = request.form("Materialgruppe ") prod = request.form("prod") Firma = request.form("Firma") 'Adresse = request.form("Adresse") Strasse = request.form("Strasse") PLZPostfach = request.form("PLZ/Postfach ") Postfach = request.form("Postfach ") PLZOrt = request.form("PLZ/Ort ") Ort = request.form("Ort") Land = request.form("Land ") Telefon = request.form("Telefon") Fax = request.form("Fax") Internet = request.form("Internet ") NameAnspr = request.form("NameAnspr") VornameAnspr = request.form("VornameAnspr") 'AdresseAnspr = request.form("AP_Adresse") TelefonAnspr = request.form("TelefonAnspr") FaxAnsprech = request.form("FaxAnsprech") eMailAnsprech = request.form("email") Sprache = request.form("Sprache ") Gesellschaftsform= request.form("Gesellschaftsform") Gruendungsjahr = request.form("Gruendungsjahr ") Geschfuehrer = request.form("Gesch-fuehrer ") UmsatzVorjahr = request.form("Umsatz Vorjahr ") UmsatzVorvorjahr = request.form("Umsatz Vorvorjahr") Kundenreferenz = request.form("Kundenreferenz ") Branche = request.form("Branche ") Angestellte = request.form("Angestellte ") Arbeiter = request.form("Arbeiter ") Zertifikate = request.form("Zertifikate ") Maschinenpark = request.form("Maschinenpark ") KanBan = request.form("KanBan ") JIT = request.form("JIT ") fuhrpark = request.form("fuhrpark ") lkw = request.form("LKW ") SAP = request.form("SAP ") AWS = request.form("Alternatives Warenwirtschafts-System") vertretungen = request.form("vertretung") body = "Materialgruppe: " &matgrp &chr(13) body = body & "Produkte: " &prod &chr(13) body = body & "Firma: " &Firma &chr(13)&chr(13) body = body & "Adresse: " &chr(13)&Adresse &chr(13)&chr(13) body = body & "Land: " &Land &chr(13)&chr(13) body = body & "AdresseAnspr: " &chr(13)&ansprech &chr(13)&chr(13) body = body & "Vertretungen in: " &vertretungen &chr(13) body = body & "Gesellschaftsform: " &Gesellschaftsform &chr(13) body = body & "Gruendungsjahr: " &Gruendungsjahr &chr(13) body = body & "Geschaeftsfuehrer: " &Geschfuehrer &chr(13) body = body & "Umsatz Vorjahr: " &UmsatzVorjahr &chr(13) body = body & "Umsatz Vorvorjahr: " &UmsatzVorvorjahr &chr(13) body = body & "Kundenreferenz: " &Kundenreferenz &chr(13) body = body & "Angestellte: " &Angestellte &chr(13) body = body & "Arbeiter: " &Arbeiter &chr(13) body = body & "Zertifikate: " &Zertifikate &chr(13) body = body & "Maschinenpark: " &Maschinenpark &chr(13) body = body & "KanBan: " &KanBan &chr(13) body = body & "JIT: " &JIT &chr(13) body = body & "Eigener Fuhrpark: " &fuhrpark &chr(13) body = body & "Größe und Anzahl eigene LKW: " &lkw &chr(13) body = body & "SAP: " &SAP &chr(13) body = body & "Alternatives Warenwirtschafts-System: " &AWS Inhalt = "Hallo Herr Rink,"&chr(13)&chr(13) Inhalt = Inhalt & "anbei eine Lieferanten-Selbstauskunft:"&chr(13)&chr(13) Inhalt = Inhalt & body Inhalt = Inhalt &chr(13)&chr(13)&chr(13)& "--------------" &chr(13)&"Automatisch versendet über www.rittal.de" If instr(eMailAnsprech,"@") Then absender = eMailAnsprech Else absender = "Gast" End If %> <% Dim mySmartMail Set mySmartMail = Server.CreateObject("aspSmartMail.SmartMail") mySmartMail.Server = SMTP_IP mySmartMail.ServerTimeOut = 35 mySmartMail.SenderName = request.form("ansprechpartner") mySmartMail.SenderAddress = absender mySmartMail.Recipients.Add "rink.a@rittal.de" ' mySmartMail.Recipients.Add "funk.m@rittal.de" mySmartMail.Subject = "Selbstauskunft" mySmartMail.Priority = 3 mySmartMail.Body = Inhalt mySmartMail.SendMail set mySmartMail = nothing %> Thank you for your application.
We will review your details as soon as possible.

Back <% end if %>