<%@ page language="java" contentType="text/html;charset=iso-8859-1" %> <%@ page import="java.lang.*,java.sql.*,java.util.*" %> <%@ page import="com.neusoft.unieap.util.winclient.SqlUtil" %> <%@ page import="com.neusoft.unieap.util.datastore.ValueDataSet" %> <%@ include file="../../../include/common/unencode.inc"%> <%@ page import ="java.util.Date"%> <%@ page import ="java.text.SimpleDateFormat"%> <%@ page import="java.sql.*" %> <%@ page import="java.io.*" %> <%@ page import="oracle.jdbc.driver.OracleResultSet" %> <%@ page import="oracle.sql.CLOB" %> <%@ page import="com.neusoft.unieap.config.EAPConfigHelper" %> <%@ include file="../webshop/opendatabase.inc"%> <% String adminUserName = ""+session.getValue("adminUserName"); String webPath=request.getContextPath(); String sql=""; ValueDataSet rs=null; String strSno = request.getParameter("strSno"); //ID String webshopid = request.getParameter("webshopid"); //ID String shop_name="",faq_web="",img_web="",email_img="",htmlname=""; sql=" select SHOP_NAME,FAQ_WEB,IMG_WEB,EMAIL_IMG,HTML_NAME FROM T_GEN_SHOP WHERE SHOP_ID='"+webshopid+"'"; rs= SqlUtil.getInstance().executeQuery(sql); if(rs.getRowCount()>0){ rs.moveTo(1); shop_name=nullcode(rs.getString("SHOP_NAME")); faq_web=nullcode(rs.getString("FAQ_WEB")); img_web=nullcode(rs.getString("IMG_WEB")); email_img=nullcode(rs.getString("EMAIL_IMG")); htmlname=nullcode(rs.getString("HTML_NAME")); } sql=" select ROW_ID, PRODUCT_CODE, PRODUCT_NAME,DEPLOY_NAME,DEPLOY_IMG,DEPLOY_NAMEB,DEPLOY_NAMEC,DEPLOY_NAMED,DEPLOY_NAMEE,DEPLOY_NAMEF,DEPLOY_NAMEG,DEPLOY_NAMEH,DEPLOY_NAMEI,DEPLOY_NAMEJ, "; sql+=" C1B_IMG, C2B_IMG, C3B_IMG, C4B_IMG, C5B_IMG, C6B_IMG, C1S_IMG, C2S_IMG, C3S_IMG, C4S_IMG, C5S_IMG, C6S_IMG,"; sql+=" PRODUCTCONDITION, WARRANTY, WARRANTY_URL, COMBINESHIPPING, COMBINESHIPPING_URL,COMBINESHIPPING_S, COMBINESHIPPINGS_URL,"; sql+=" SHIPPINGCOST,SHIPPINGCOST_LIST, SHIPPINGCOST_URL,SHIPPINGCOST_S,SHIPPINGCOSTS_LIST,"; sql+=" SHIPPINGCOSTS_URL,EBAYLIST,EBAYLIST_URL,EBAYLISTS,EBAYLISTS_URL,FREESHIPPING,FREESHIPPING_IMG,FREESHIPPING_URL,"; sql+=" QUESTION_LINK_IMG, QUESTION_LINK_URL, TERMSCONDITIONS, PAYMENTTAX, SHIPPINGHANDLING,SHIPPINGDETAILS,SHIPPINGDETAILS_S,"; sql+=" WARRANTYRETURN, CONTACT_US, ARROW_IMG,WEBNOTE,SMESSAGE1_URL,SMESSAGE2_URL,SMESSAGE1_LIST,"; sql+=" OUR_PROD_NAME1,OUR_PROD_IMG1,OUR_PROD_URL1,OUR_PROD_NAME2,OUR_PROD_IMG2,OUR_PROD_URL2,"; sql+=" OUR_PROD_NAME3,OUR_PROD_IMG3,OUR_PROD_URL3,OUR_PROD_NAME4,OUR_PROD_IMG4,OUR_PROD_URL4,"; sql+=" OUR_PROD_NAME5,OUR_PROD_IMG5,OUR_PROD_URL5,OUR_PROD_NAME6,OUR_PROD_IMG6,OUR_PROD_URL6,"; sql+=" OUR_PROD_NAME7,OUR_PROD_IMG7,OUR_PROD_URL7,OUR_PROD_NAME8,OUR_PROD_IMG8,OUR_PROD_URL8,"; sql+=" OUR_PROD_IMG9,OUR_PROD_URL9,OUR_PROD_IMG10,OUR_PROD_URL10,"; sql+=" OUR_PROD_IMG11,OUR_PROD_URL11,OUR_PROD_IMG12,OUR_PROD_URL12,OUR_PROD_IMG13,OUR_PROD_URL13,"; sql+=" LOTS_IMG5,LOTS_URL5,LOTS_IMG10,LOTS_URL10,LOTS_IMG20,LOTS_URL20,LOTS_IMG50,LOTS_URL50,LOTS_IMG100,LOTS_URL100 "; sql+=" from T_GEN_PRODUCT WHERE ROW_ID='"+strSno+"' "; String codea=""; String namea=""; String deploy_name="",deploy_nameb=""; String deploy_img=""; String deploy_namec=""; String deploy_named=""; String deploy_namee=""; String c1b_img=""; String c2b_img=""; String c3b_img=""; String c4b_img=""; String c5b_img=""; String c6b_img=""; String c1s_img=""; String c2s_img=""; String c3s_img=""; String c4s_img=""; String c5s_img=""; String c6s_img=""; String ProductCondition=""; String Warranty=""; String Warranty_url=""; String CombineShipping=""; String CombineShipping_url=""; String CombineShippings=""; String CombineShippings_url=""; String ShippingCost=""; String ShippingCost_list=""; String ShippingCost_url=""; String ShippingCosts=""; String ShippingCosts_list=""; String ShippingCosts_url=""; String ebaylist=""; String ebaylist_url=""; String ebaylists=""; String ebaylists_url=""; String freeshipping=""; String freeshipping_img=""; String freeshipping_url=""; //String freeshippingb=""; //String freeshippingb_img=""; //String freeshippingb_url=""; String question_link_img=""; String question_link_url=""; String MainDescription=""; String TermsConditions=""; String PaymentTax=""; String ShippingHandling=""; String shippingDetails=""; String shippingDetails_s=""; String WarrantyReturn=""; String contact_us=""; String contact_us_url=""; String arrow_img=""; String webnote=""; String smessage1url=""; String smessage2url=""; String wholesale=""; String lots_img5="",lots_url5="",lots_img10="",lots_url10=""; String lots_img20="",lots_url20="",lots_img50="",lots_url50="",lots_img100="",lots_url100=""; String our_prod_name1="",our_prod_img1="",our_prod_url1=""; String our_prod_name2="",our_prod_img2="",our_prod_url2=""; String our_prod_name3="",our_prod_img3="",our_prod_url3=""; String our_prod_name4="",our_prod_img4="",our_prod_url4=""; String our_prod_name5="",our_prod_img5="",our_prod_url5=""; String our_prod_name6="",our_prod_img6="",our_prod_url6=""; String our_prod_name7="",our_prod_img7="",our_prod_url7=""; String our_prod_name8="",our_prod_img8="",our_prod_url8=""; String our_prod_name9="",our_prod_img9="",our_prod_url9=""; String our_prod_name10="",our_prod_img10="",our_prod_url10=""; String our_prod_name11="",our_prod_img11="",our_prod_url11=""; String our_prod_name12="",our_prod_img12="",our_prod_url12=""; String our_prod_name13="",our_prod_img13="",our_prod_url13=""; rs= SqlUtil.getInstance().executeQuery(sql); if(rs.getRowCount()>0){ rs.moveTo(1); codea=nullcode(rs.getString("PRODUCT_CODE")); namea=nullcode(rs.getString("PRODUCT_NAME")); deploy_name=nullcode(rs.getString("DEPLOY_NAME")); deploy_img=nullcode(rs.getString("DEPLOY_IMG")); deploy_nameb=nullcode(rs.getString("DEPLOY_NAMEB")); deploy_namec=nullcode(rs.getString("DEPLOY_NAMEC")); deploy_named=nullcode(rs.getString("DEPLOY_NAMED")); deploy_namee=nullcode(rs.getString("DEPLOY_NAMEE")); c1b_img=nullcode(rs.getString("C1B_IMG")); c2b_img=nullcode(rs.getString("C2B_IMG")); c3b_img=nullcode(rs.getString("C3B_IMG")); c4b_img=nullcode(rs.getString("C4B_IMG")); c5b_img=nullcode(rs.getString("C5B_IMG")); c6b_img=nullcode(rs.getString("C6B_IMG")); c1s_img=nullcode(rs.getString("C1S_IMG")); c2s_img=nullcode(rs.getString("C2S_IMG")); c3s_img=nullcode(rs.getString("C3S_IMG")); c4s_img=nullcode(rs.getString("C4S_IMG")); c5s_img=nullcode(rs.getString("C5S_IMG")); c6s_img=nullcode(rs.getString("C6S_IMG")); ProductCondition=rs.getString("PRODUCTCONDITION"); Warranty=rs.getString("WARRANTY"); Warranty_url=rs.getString("WARRANTY_URL"); CombineShipping=nullcode(rs.getString("COMBINESHIPPING")); CombineShipping_url=nullcode(rs.getString("COMBINESHIPPING_URL")); CombineShippings=nullcode(rs.getString("COMBINESHIPPING_S")); CombineShippings_url=rs.getString("COMBINESHIPPINGS_URL"); ShippingCost=rs.getString("SHIPPINGCOST"); ShippingCost_list=rs.getString("SHIPPINGCOST_LIST"); ShippingCost_url=rs.getString("SHIPPINGCOST_URL"); ShippingCosts=rs.getString("SHIPPINGCOST_S"); ShippingCosts_list=rs.getString("SHIPPINGCOSTS_LIST"); ShippingCosts_url=rs.getString("SHIPPINGCOSTS_URL"); ebaylist=rs.getString("EBAYLIST"); ebaylist_url=rs.getString("EBAYLIST_URL"); ebaylists=rs.getString("EBAYLISTS"); ebaylists_url=rs.getString("EBAYLISTS_URL"); freeshipping=nullcode(rs.getString("FREESHIPPING")); freeshipping_img=nullcode(rs.getString("FREESHIPPING_IMG")); freeshipping_url=nullcode(rs.getString("FREESHIPPING_URL")); question_link_img=nullcode(rs.getString("QUESTION_LINK_IMG")); question_link_url=nullcode(rs.getString("QUESTION_LINK_URL")); TermsConditions=nullcode(rs.getString("TERMSCONDITIONS")); PaymentTax=nullcode(rs.getString("PAYMENTTAX")); ShippingHandling=nullcode(rs.getString("SHIPPINGHANDLING")); shippingDetails =nullcode(rs.getString("SHIPPINGDETAILS")); shippingDetails_s =nullcode(rs.getString("SHIPPINGDETAILS_S")); WarrantyReturn=nullcode(rs.getString("WARRANTYRETURN")); contact_us=nullcode(rs.getString("CONTACT_US")); arrow_img=nullcode(rs.getString("ARROW_IMG")); webnote=nullcode(rs.getString("WEBNOTE")); smessage1url=nullcode(rs.getString("SMESSAGE1_URL")); smessage2url=nullcode(rs.getString("SMESSAGE2_URL")); wholesale = nullcode(rs.getString("SMESSAGE1_LIST")); lots_img5=nullcode(rs.getString("LOTS_IMG5")); lots_url5=nullcode(rs.getString("LOTS_URL5")); lots_img10=nullcode(rs.getString("LOTS_IMG10")); lots_url10=nullcode(rs.getString("LOTS_URL10")); lots_img20=nullcode(rs.getString("LOTS_IMG20")); lots_url20=nullcode(rs.getString("LOTS_URL20")); lots_img50=nullcode(rs.getString("LOTS_IMG50")); lots_url50=nullcode(rs.getString("LOTS_URL50")); lots_img100=nullcode(rs.getString("LOTS_IMG100")); lots_url100=nullcode(rs.getString("LOTS_URL100")); our_prod_name1=nullcode(rs.getString("OUR_PROD_NAME1")); our_prod_img1=nullcode(rs.getString("OUR_PROD_IMG1")); our_prod_url1=nullcode(rs.getString("OUR_PROD_URL1")); our_prod_name2=nullcode(rs.getString("OUR_PROD_NAME2")); our_prod_img2=nullcode(rs.getString("OUR_PROD_IMG2")); our_prod_url2=nullcode(rs.getString("OUR_PROD_URL2")); our_prod_name3=nullcode(rs.getString("OUR_PROD_NAME3")); our_prod_img3=nullcode(rs.getString("OUR_PROD_IMG3")); our_prod_url3=nullcode(rs.getString("OUR_PROD_URL3")); our_prod_name4=nullcode(rs.getString("OUR_PROD_NAME4")); our_prod_img4=nullcode(rs.getString("OUR_PROD_IMG4")); our_prod_url4=nullcode(rs.getString("OUR_PROD_URL4")); our_prod_name5=nullcode(rs.getString("OUR_PROD_NAME5")); our_prod_img5=nullcode(rs.getString("OUR_PROD_IMG5")); our_prod_url5=nullcode(rs.getString("OUR_PROD_URL5")); our_prod_name6=nullcode(rs.getString("OUR_PROD_NAME6")); our_prod_img6=nullcode(rs.getString("OUR_PROD_IMG6")); our_prod_url6=nullcode(rs.getString("OUR_PROD_URL6")); our_prod_name7=nullcode(rs.getString("OUR_PROD_NAME7")); our_prod_img7=nullcode(rs.getString("OUR_PROD_IMG7")); our_prod_url7=nullcode(rs.getString("OUR_PROD_URL7")); our_prod_name8=nullcode(rs.getString("OUR_PROD_NAME8")); our_prod_img8=nullcode(rs.getString("OUR_PROD_IMG8")); our_prod_url8=nullcode(rs.getString("OUR_PROD_URL8")); our_prod_img9=nullcode(rs.getString("OUR_PROD_IMG9")); our_prod_url9=nullcode(rs.getString("OUR_PROD_URL9")); our_prod_img10 =nullcode(rs.getString("OUR_PROD_IMG10")); our_prod_url10 =nullcode(rs.getString("OUR_PROD_URL10")); our_prod_img11 =nullcode(rs.getString("OUR_PROD_IMG11")); our_prod_url11 =nullcode(rs.getString("OUR_PROD_URL11")); our_prod_img12 =nullcode(rs.getString("OUR_PROD_IMG12")); our_prod_url12 =nullcode(rs.getString("OUR_PROD_URL12")); our_prod_img13 =nullcode(rs.getString("OUR_PROD_IMG13")); our_prod_url13 =nullcode(rs.getString("OUR_PROD_URL13")); } //MainDescription = MainDescription.replaceAll("&apos", "'"); //MainDescription = MainDescription.replaceAll(""", "\""); namea = namea.replaceAll("&apos", "'"); namea = namea.replaceAll(""", "\""); deploy_name = deploy_name.replaceAll("&apos", "'"); deploy_name = deploy_name.replaceAll(""", "\""); deploy_nameb = deploy_nameb.replaceAll("&apos", "'"); deploy_nameb = deploy_nameb.replaceAll(""", "\""); deploy_namec = deploy_namec.replaceAll("&apos", "'"); deploy_namec = deploy_namec.replaceAll(""", "\""); deploy_named = deploy_named.replaceAll("&apos", "'"); deploy_named = deploy_named.replaceAll(""", "\""); deploy_namee = deploy_namee.replaceAll("&apos", "'"); deploy_namee = deploy_namee.replaceAll(""", "\""); TermsConditions = TermsConditions.replaceAll("&apos", "'"); TermsConditions = TermsConditions.replaceAll(""", "\""); //TermsConditions = TermsConditions.replaceAll(" ", " "); PaymentTax = PaymentTax.replaceAll("&apos", "'"); PaymentTax = PaymentTax.replaceAll(""", "\""); //PaymentTax = PaymentTax.replaceAll(" ", " "); ShippingHandling = ShippingHandling.replaceAll("&apos", "'"); ShippingHandling = ShippingHandling.replaceAll(""", "\""); //ShippingHandling = ShippingHandling.replaceAll(" ", " "); shippingDetails = shippingDetails.replaceAll("&apos", "'"); shippingDetails = shippingDetails.replaceAll(""", "\""); //shippingDetails = shippingDetails.replaceAll(" ", " "); shippingDetails_s = shippingDetails_s.replaceAll("&apos", "'"); shippingDetails_s = shippingDetails_s.replaceAll(""", "\""); //shippingDetails_s = shippingDetails_s.replaceAll(" ", " "); WarrantyReturn = WarrantyReturn.replaceAll("&apos", "'"); WarrantyReturn = WarrantyReturn.replaceAll(""", "\""); //WarrantyReturn = WarrantyReturn.replaceAll(" ", " "); contact_us = contact_us.replaceAll("&apos", "'"); contact_us = contact_us.replaceAll(""", "\""); //contact_us = contact_us.replaceAll(" ", " "); freeshipping = freeshipping.replaceAll("&apos", "'"); freeshipping = freeshipping.replaceAll(""", "\""); //freeshipping = freeshipping.replaceAll(" ", " "); our_prod_name1 = our_prod_name1.replaceAll("&apos", "'"); our_prod_name1 = our_prod_name1.replaceAll(""", "\""); our_prod_name2 = our_prod_name2.replaceAll("&apos", "'"); our_prod_name2 = our_prod_name2.replaceAll(""", "\""); our_prod_name3 = our_prod_name3.replaceAll("&apos", "'"); our_prod_name3 = our_prod_name3.replaceAll(""", "\""); our_prod_name4 = our_prod_name4.replaceAll("&apos", "'"); our_prod_name4 = our_prod_name4.replaceAll(""", "\""); our_prod_name5 = our_prod_name5.replaceAll("&apos", "'"); our_prod_name5 = our_prod_name5.replaceAll(""", "\""); our_prod_name6 = our_prod_name6.replaceAll("&apos", "'"); our_prod_name6 = our_prod_name6.replaceAll(""", "\""); our_prod_name7 = our_prod_name7.replaceAll("&apos", "'"); our_prod_name7 = our_prod_name7.replaceAll(""", "\""); our_prod_name8 = our_prod_name8.replaceAll("&apos", "'"); our_prod_name8 = our_prod_name8.replaceAll(""", "\""); //clob try{ Statement stmt=con.createStatement(); sql="select MAINDESCRIPTION from T_GEN_PRODUCT where ROW_ID='"+strSno+"'"; ResultSet rsclob=stmt.executeQuery(sql); if(rsclob.next()){ CLOB clob = ((OracleResultSet)rsclob).getCLOB(1); if(clob!=null && clob.length()>0 ){ MainDescription = clob.getSubString((long)1,(int)clob.length()); } } rsclob.close(); rsclob=null; stmt.close(); con.close(); con=null; }catch(Exception ee){ System.out.println("query:"+ee); } MainDescription = MainDescription.replaceAll("&apos", "'"); MainDescription = MainDescription.replaceAll(""", "\""); //MainDescription = MainDescription.replaceAll(" ", " "); java.util.Date currData = new java.util.Date(); out.print(""); out.print(""); if(!deploy_namec.equals("")){ out.print(""); } if(!deploy_named.equals("")){ out.print(""); } if(!deploy_namee.equals("")){ out.print(""); } out.print(""); out.print(""); %>
<%=codea%> <%if(!CombineShipping.equals("")){%> eeekitonline_hot<%=CombineShipping%> <%}%> <%if(CombineShippings.equals("Y")){%> eeekitonlineRecommend <%}%> <%=smessage1url%> <%=smessage2url%>
search:
Need Help?
Contact Us
 
Contact us
Customer Satisfaction is invaluable for us. Any questions, please let us know first.
Online Chat
Email to Us
Please send your email directly to ebaysales@eeekit.com, We will reply all you questions in one working day.
Payment and Sales Tax

• We do accept PayPal ONLY.
• Our Paypal account is paypal@eeekit.com
• We charge sales tax for items shipped to: CA (9.250%).


Shipping and Handing

• We offer Free Shipping for USA and Canada shipping. Including APO/FPO address, Puerto Rico, Hawaii, Virgin Islands, etc. We do not send this item to other foreign countries temporarily.
• We offer Combined Shipping Discount: $2 off on each additional no-free shipping item within USA.
• Combined shipping is only limited to the listed under the seller account: EeeKitOnline. No Combined Shipping for international order.
• We only ship to Paypal confirmed address. Please make sure your shipping address is updated. If the package is returned by address issue, buyer will be charged for return shipping and reshipping fee or we will refund the original amount deducted from return shipping cost.
• Canada buyers, please note: Import duties, taxes, and charges (typically collected upon delivery or pickup) are the buyer's responsibility and are not included in the item price or shipping charges. Please check with Canada's customs office prior to bidding/buying to determine what these additional costs will be.


Return Policy

• Merchandise must be returned within 30 days and with all original accessories.
• Please send email to ebaysales@eeekit.com to REQUEST an RMA # first.
• Buyer is responsible for all return shipping charges.
• Please also write a note to show your item number and Ebay user name when you return item for whatever reason.
• Shipping & Handling fee is non-refundable in any case.
• Please allow up to 10 business days for returns to be processed.


Contact Us

• Customer Satisfaction is invaluable for us. Any questions, please let us know first. Our email address is ebaysales@eeekit.com.
• If you want to send email to us via Ebay system, please don't select "Hide email address" function.
 
  • <%=codea%>
    •
  • <%if(!CombineShipping.equals("")){%> eeekitonline_hot<%=CombineShipping%> <%}%> <%if(CombineShippings.equals("Y")){%> eeekitonlineRecommend <%}%> <%=smessage1url%> <%=smessage2url%>