<%@LANGUAGE="JAVASCRIPT"%> <% // *** Edit Operations: declare variables // set the form action variable var MM_editAction = Request.ServerVariables("SCRIPT_NAME"); if (Request.QueryString) { MM_editAction += "?" + Server.HTMLEncode(Request.QueryString); } // boolean to abort record edit var MM_abortEdit = false; // query string to execute var MM_editQuery = ""; %> <% // *** Redirect if username exists var MM_flag="MM_insert"; if (String(Request(MM_flag)) != "undefined") { var MM_dupKeyRedirect="e-Gform.asp"; var MM_rsKeyConnection=MM_web_STRING; var MM_dupKeyUsernameValue = String(Request.Form("Company Name")); var MM_dupKeySQL = "SELECT e_company FROM dbo.new_e_interestinquiry WHERE e_company='" + MM_dupKeyUsernameValue + "'" var MM_adodbRecordset = "ADODB.Recordset"; var MM_rsKey = Server.CreateObject(MM_adodbRecordset); MM_rsKey.ActiveConnection = MM_rsKeyConnection; MM_rsKey.Source = MM_dupKeySQL; MM_rsKey.CursorType=0; MM_rsKey.CursorLocation=2; MM_rsKey.LockType=3; MM_rsKey.Open(); if (!MM_rsKey.EOF || !MM_rsKey.BOF) { // the username was found - can not add the requested username var MM_qsChar = "?"; if (MM_dupKeyRedirect.indexOf("?") >= 0) MM_qsChar = "&"; MM_dupKeyRedirect = MM_dupKeyRedirect + MM_qsChar + "requsername=" + MM_dupKeyUsernameValue; Response.Redirect(MM_dupKeyRedirect); } MM_rsKey.Close(); } %> <% // *** Edit Operations: declare variables // set the form action variable var MM_editAction = Request.ServerVariables("SCRIPT_NAME"); if (Request.QueryString) { MM_editAction += "?" + Server.HTMLEncode(Request.QueryString); } // boolean to abort record edit var MM_abortEdit = false; // query string to execute var MM_editQuery = ""; %> <% // *** Insert Record: set variables if (String(Request("MM_insert")) == "form") { var MM_editConnection = MM_web_STRING; var MM_editTable = "dbo.new_e_interestinquiry"; var MM_editRedirectUrl = "e-sucess.asp"; var MM_fieldsStr = "Company Name|value|Company Holder|value|Tel|value|Fax|value|No.of Employee|value|No.of Sales|value|checkbox1|value|checkbox2|value|checkbox3|value|checkbox4|value|checkbox5|value|modelother|value|Monthly Revenue|value|Company Address|value|Invoice Address|value|Person of Contact|value|Position of Contact Person|value|E-mail|value|Mobile Phone Number|value|Bussiness Associations or Chain Management|value|checkbox6|value|checkbox7|value|checkbox8|value|Current Selling Product or Services|value|checkbox9|value|checkbox10|value|checkbox11|value"; var MM_columnsStr = "e_company|',none,''|e_holder|',none,''|e_tel|',none,''|e_fax|',none,''|e_employee_no|',none,''|e_sales_no|',none,''|e_model1|',none,''|e_model2|',none,''|e_model3|',none,''|e_model4|',none,''|e_model5|',none,''|e_modelother|',none,''|e_monthlyr|',none,''|e_address|',none,''|e_invoiceadd|',none,''|e_maincontact|',none,''|e_dept|',none,''|e_email|',none,''|e_phone|',none,''|e_baocm|',none,''|e_sellproduct1|',none,''|e_sellproduct2|',none,''|e_sellproduct3|',none,''|e_sellproduct4|',none,''|e_buyproduct1|',none,''|e_buyproduct2|',none,''|e_buyproduct3|',none,''"; // create the MM_fields and MM_columns arrays var MM_fields = MM_fieldsStr.split("|"); var MM_columns = MM_columnsStr.split("|"); // set the form values for (var i=0; i+1 < MM_fields.length; i+=2) { MM_fields[i+1] = String(Request.Form(MM_fields[i])); } // append the query string to the redirect URL if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) { MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + Request.QueryString; } } %> <% // *** Insert Record: construct a sql insert statement and execute it if (String(Request("MM_insert")) != "undefined") { // create the sql insert statement var MM_tableValues = "", MM_dbValues = ""; for (var i=0; i+1 < MM_fields.length; i+=2) { var formVal = MM_fields[i+1]; var MM_typesArray = MM_columns[i+1].split(","); var delim = (MM_typesArray[0] != "none") ? MM_typesArray[0] : ""; var altVal = (MM_typesArray[1] != "none") ? MM_typesArray[1] : ""; var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : ""; if (formVal == "" || formVal == "undefined") { formVal = emptyVal; } else { if (altVal != "") { formVal = altVal; } else if (delim == "'") { // escape quotes formVal = "'" + formVal.replace(/'/g,"''") + "'"; } else { formVal = delim + formVal + delim; } } MM_tableValues += ((i != 0) ? "," : "") + MM_columns[i]; MM_dbValues += ((i != 0) ? "," : "") + formVal; } MM_editQuery = "insert into " + MM_editTable + " (" + MM_tableValues + ") values (" + MM_dbValues + ")"; if (!MM_abortEdit) { // execute the insert var MM_editCmd = Server.CreateObject('ADODB.Command'); MM_editCmd.ActiveConnection = MM_editConnection; MM_editCmd.CommandText = MM_editQuery; MM_editCmd.Execute(); MM_editCmd.ActiveConnection.Close(); if (MM_editRedirectUrl) { Response.Redirect(MM_editRedirectUrl); } } } %> <% var Recordset1 = Server.CreateObject("ADODB.Recordset"); Recordset1.ActiveConnection = MM_web_STRING; Recordset1.Source = "SELECT e_company FROM dbo.new_e_interestinquiry"; Recordset1.CursorType = 0; Recordset1.CursorLocation = 2; Recordset1.LockType = 1; Recordset1.Open(); var Recordset1_numRows = 0; %> Welcome to Artec Web Site-Reseller
　
　
　


We treasure our customers as well as our partners. We provide quality and innovative products highly demanded by the consumer market and are devoted in providing greatest support to our distributing partners. We also provide ODM services for brand customers. If you are interested in carrying our products, please provide us with your information and fill out the form below. If you like to purchase our products in bulk, please e-mail your request to us directly at sales@ultima.com.tw We would provide quick response to all your inquiries.

Data
Company Name：
Company Holder：
Tel：
Fax：
No. of Employee：
No. of Sales：
Business Type：
 Resell/Distribution Retail Chain Store VAR/SI
Others  
Monthly Revenue：
Company Address：
Invoice Address：
  
Person of Contact：

Position of Contact Person：

E-mail：
Mobile Phone Number：
Business Associations or Chain Management：

* Interested in selling ARTEC products：

 ATV/DTV/DVD Players Digital TV Box Series Optical Disc Drives

Current Selling Products or Services:

* Interested in buying ARTEC products：

 ATV/DTV/DVD Players Digital TV Box Series Optical Disc Drives


© 2007 Artec Electronics Corp., All Rights Reserved.
<% Recordset1.Close(); %>