add_Batch.asp
上传用户:btntkt
上传日期:2021-04-16
资源大小:5296k
文件大小:14k
源码类别:

WEB源码(ASP,PHP,...)

开发平台:

DOS

  1. <html>
  2. <head>
  3. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  4. <link href="../images/css.css" rel="stylesheet" type="text/css">
  5. </head>
  6. <body>
  7. <table class="tableBorder" width="90%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#FFFFFF">
  8. <tr> 
  9.     <td align="center" background="../images/admin_bg_1.gif"><b>商品批量导入</b></td>
  10. </tr>
  11. <tr> 
  12. <td height="100" align="center" >
  13. <SCRIPT LANGUAGE="JavaScript">
  14. <!-- Begin by www.wrtx.cn
  15. extArray = new Array(".xls", ".csv");
  16. function LimitAttach(myform, file) {
  17. allowSubmit = false;
  18. if (!file) return;
  19. while (file.indexOf("\") != -1)
  20. file = file.slice(file.indexOf("\") + 1);
  21. ext = file.slice(file.indexOf(".")).toLowerCase();
  22. for (var i = 0; i < extArray.length; i++) {
  23. if (extArray[i] == ext) { allowSubmit = true; break; }
  24. }
  25. if (allowSubmit) form.submit();
  26. else
  27. alert("对不起,只能上传以下格式的文件:  " 
  28. + (extArray.join("  ")) + "n请重新选择上传文件.");
  29. return false;
  30. }
  31. //  End by www.wrtx.cn-->
  32. </script>
  33. <SCRIPT LANGUAGE="JavaScript">
  34. <!--
  35. function checkkk()
  36. {
  37.      if(checkspace(document.myform.uploadfile.value)) {
  38. document.myform.uploadfile.focus();
  39.     alert("请选择您要导入的Excel文件!");
  40. return false;
  41.   }
  42.     
  43. }
  44. function checkspace(checkstr) {
  45.   var str = '';
  46.   for(i = 0; i < checkstr.length; i++) {
  47.     str = str + ' ';
  48.   }
  49.   return (str == checkstr);
  50. }
  51. //-->
  52. </script>
  53. <script>
  54. function regInput(obj, reg, inputStr)
  55. {
  56. var docSel = document.selection.createRange()
  57. if (docSel.parentElement().tagName != "INPUT") return false
  58. oSel = docSel.duplicate()
  59. oSel.text = ""
  60. var srcRange = obj.createTextRange()
  61. oSel.setEndPoint("StartToStart", srcRange)
  62. var str = oSel.text + inputStr + srcRange.text.substr(oSel.text.length)
  63. return reg.test(str)
  64. }
  65. </script>
  66. </script>
  67. <script language = "JavaScript">
  68. var onecount;
  69. var threecount;
  70. onecount=0;
  71. threecount=0
  72. subcat3=new Array();
  73. subcat3[0] = new Array("子类测试一","587","67");
  74. subcat3[1] = new Array("洗涤用品子类一","586","65");
  75. subcat3[2] = new Array("324234","601","10");
  76. subcat3[3] = new Array("丰胸美乳子类一","577","25");
  77. subcat3[4] = new Array("子类一","591","74");
  78. subcat3[5] = new Array("三级分类测试一","590","15");
  79. subcat3[6] = new Array("三级分类一","571","16");
  80. subcat3[7] = new Array("情人专用","593","78");
  81. subcat3[8] = new Array("化妆工具子类一","581","50");
  82. subcat3[9] = new Array("子类一","592","77");
  83. subcat3[10] = new Array("美容工具子类一","582","54");
  84. subcat3[11] = new Array("大型机","110","1");
  85. subcat3[12] = new Array("子类测试一","585","63");
  86. subcat3[13] = new Array("收腹提臀子类一","575","18");
  87. subcat3[14] = new Array("三级分类一","574","19");
  88. subcat3[15] = new Array("三级分类测试一","584","59");
  89. subcat3[16] = new Array("三级分类测试一","583","57");
  90. subcat3[17] = new Array("三级分类测试一","589","70");
  91. subcat3[18] = new Array("男用套装","596","86");
  92. subcat3[19] = new Array("三级分类测试一","572","9");
  93. subcat3[20] = new Array("男用系列","594","81");
  94. subcat3[21] = new Array("234","109","2");
  95. subcat3[22] = new Array("芳香型","595","83");
  96. subcat3[23] = new Array("三级分类测试一","578","43");
  97. subcat3[24] = new Array("啫喱水","599","90");
  98. subcat3[25] = new Array("焗油型","598","6");
  99. subcat3[26] = new Array("234","111","3");
  100. subcat3[27] = new Array("瘦身减肥子类一","576","38");
  101. subcat3[28] = new Array("三级分类测试一","573","29");
  102. subcat3[29] = new Array("子类测试一","600","93");
  103. subcat3[30] = new Array("三级分类测试一","579","46");
  104. subcat3[31] = new Array("三级分类二","574","33");
  105. subcat3[32] = new Array("三级分类测试二","590","96");
  106. subcat3[33] = new Array("染发型","598","26");
  107. subcat3[34] = new Array("化妆工具子类二","581","51");
  108. subcat3[35] = new Array("丰胸美乳子类二","577","41");
  109. subcat3[36] = new Array("三级分类测试二","572","27");
  110. subcat3[37] = new Array("三级分类测试二","579","47");
  111. subcat3[38] = new Array("三级分类测试二","573","30");
  112. subcat3[39] = new Array("三级分类测试二","578","44");
  113. subcat3[40] = new Array("瘦身减肥子类二","576","39");
  114. subcat3[41] = new Array("子类二","591","75");
  115. subcat3[42] = new Array("子类测试二","600","94");
  116. subcat3[43] = new Array("定型剂","599","91");
  117. subcat3[44] = new Array("妇女用品","597","7");
  118. subcat3[45] = new Array("女用套装","596","87");
  119. subcat3[46] = new Array("绿茶味","595","84");
  120. subcat3[47] = new Array("子类测试二","585","64");
  121. subcat3[48] = new Array("爱人专用","593","79");
  122. subcat3[49] = new Array("美容工具子类二","582","55");
  123. subcat3[50] = new Array("三级分类测试二","589","71");
  124. subcat3[51] = new Array("三级分类二","571","17");
  125. subcat3[52] = new Array("子类测试二","587","68");
  126. subcat3[53] = new Array("洗涤用品子类二","586","66");
  127. subcat3[54] = new Array("收腹提臀子类二","575","35");
  128. subcat3[55] = new Array("三级分类测试二","584","60");
  129. subcat3[56] = new Array("三级分类测试二","583","58");
  130. subcat3[57] = new Array("女用系列","594","82");
  131. subcat3[58] = new Array("三级分类测试三","572","28");
  132. subcat3[59] = new Array("男士专用","597","8");
  133. subcat3[60] = new Array("三级分类测试三","573","31");
  134. subcat3[61] = new Array("三级分类三","574","34");
  135. subcat3[62] = new Array("护发型","598","89");
  136. subcat3[63] = new Array("三级分类测试三","589","72");
  137. subcat3[64] = new Array("子类测试三","587","69");
  138. subcat3[65] = new Array("好友专用","593","80");
  139. subcat3[66] = new Array("冰茶味","595","85");
  140. subcat3[67] = new Array("收腹提臀子类三","575","36");
  141. subcat3[68] = new Array("中老年套装","596","88");
  142. subcat3[69] = new Array("子类三","591","76");
  143. subcat3[70] = new Array("化妆工具子类三","581","52");
  144. subcat3[71] = new Array("三级分类测试三","584","61");
  145. subcat3[72] = new Array("三级分类测试三","579","48");
  146. subcat3[73] = new Array("三级分类测试三","578","45");
  147. subcat3[74] = new Array("丰胸美乳子类三","577","42");
  148. subcat3[75] = new Array("瘦身减肥子类三","576","40");
  149. subcat3[76] = new Array("子类三","599","92");
  150. subcat3[77] = new Array("子类测试三","600","95");
  151. subcat3[78] = new Array("美容工具子类三","582","56");
  152. subcat3[79] = new Array("三级分类测试四","589","73");
  153. subcat3[80] = new Array("化妆工具子类四","581","53");
  154. subcat3[81] = new Array("三级分类三","571","21");
  155. subcat3[82] = new Array("三级分类测试四","579","49");
  156. subcat3[83] = new Array("三级分类测试四","573","32");
  157. subcat3[84] = new Array("收腹提臀子类四","575","37");
  158. subcat3[85] = new Array("三级分类测试四","584","62");
  159. subcat3[86] = new Array("三级分类四","571","22");
  160. threecount=87;
  161. subcat = new Array();
  162. subcat[0] = new Array("男/女化妆品","65","585");
  163. subcat[1] = new Array("收腹提臀","63","575");
  164. subcat[2] = new Array("沐浴香体","68","597");
  165. subcat[3] = new Array("化妆工具","64","581");
  166. subcat[4] = new Array("情侣香水","67","593");
  167. subcat[5] = new Array("粉底/粉饼","62","571");
  168. subcat[6] = new Array("祛痘暗疮","66","589");
  169. subcat[7] = new Array("胭脂/眼影","62","572");
  170. subcat[8] = new Array("瘦身减肥","63","576");
  171. subcat[9] = new Array("美容工具","64","582");
  172. subcat[10] = new Array("洗护用品","65","586");
  173. subcat[11] = new Array("运动香水","67","594");
  174. subcat[12] = new Array("洗发护发","68","598");
  175. subcat[13] = new Array("祛斑/祛疤/祛皱","66","590");
  176. subcat[14] = new Array("精油/焕颜","66","591");
  177. subcat[15] = new Array("美甲工具","64","583");
  178. subcat[16] = new Array("止汗香露","67","595");
  179. subcat[17] = new Array("美颜保健品","65","587");
  180. subcat[18] = new Array("彩妆套装","62","573");
  181. subcat[19] = new Array("丰胸美乳","63","577");
  182. subcat[20] = new Array("美发定型","68","599");
  183. subcat[21] = new Array("足浴/其他","68","600");
  184. subcat[22] = new Array("其他产品","66","592");
  185. subcat[23] = new Array("美发工具","64","584");
  186. subcat[24] = new Array("美腿产品","63","578");
  187. subcat[25] = new Array("香水套装","67","596");
  188. subcat[26] = new Array("保健滋补品","65","588");
  189. subcat[27] = new Array("唇线笔/卸妆","62","574");
  190. subcat[28] = new Array("增高助长","63","579");
  191. subcat[29] = new Array("紧致瘦脸","63","580");
  192. onecount=30;
  193. function changelocation(locationid)
  194.     {
  195.     document.myform.nclassid.length = 0; 
  196.     var locationid=locationid;
  197.     var i;
  198.     for (i=0;i < onecount; i++)
  199.         {
  200.             if (subcat[i][1] == locationid)
  201.             { 
  202.              document.myform.nclassid.options[document.myform.nclassid.length] = new Option(subcat[i][0], subcat[i][2]);
  203.             }        
  204.         }
  205.      changelocation3(document.myform.nclassid.options[document.myform.nclassid.selectedIndex].value)
  206.     }
  207. function changelocation3(locationid)
  208.     {
  209.     document.myform.xclassid.length = 0; 
  210.     var locationid=locationid;
  211.     var i;
  212.     for (i=0;i < threecount; i++)
  213.         {
  214.             if (subcat3[i][1] == locationid)
  215.             { 
  216.              document.myform.xclassid.options[document.myform.xclassid.length] = new Option(subcat3[i][0], subcat3[i][2]);
  217.             }
  218.         }
  219.     } 
  220. //-->
  221. </script>
  222. <table width="99%" border="0" cellspacing="0" cellpadding="3" class="classtable">
  223.         <form action="?action=LoadExcel" method="post" name="myform" onSubmit="return checkkk()"  enctype="multipart/form-data">
  224.           <tr class="classtd"> 
  225.             <td colspan="2" align="right" class="classtd">&nbsp; </td>
  226.           </tr>
  227.           <tr class="classtd"> 
  228.             <td height="30" width="15%" class="classtd"> <INPUT TYPE="hidden" NAME="UploadCode" value="1183">
  229.               Excel文件: </td>
  230.             <td class="classtd"> <input type="file" name="uploadfile" size="15" class="form"> 
  231.             </td>
  232.           </tr>
  233.           <tr class="classtd"> 
  234.             <td width="15%" rowspan="2" valign="top" class="classtd" style="padding-top:6px;"> 
  235.               所属类别: </td>
  236.             <td width="70%">大类:
  237.               
  238.               <select name="anclassid" size="1" id="select2" onChange="changelocation(document.myform.anclassid.options[document.myform.anclassid.selectedIndex].value)">
  239.                 <option value=62>彩妆用品</option><option value=63>塑身纤体</option><option value=64>工具器械</option><option value=65>化妆保健</option><option value=66>特效护理</option><option value=67>香水系列</option><option value=68>居家洗护</option>
  240.               </select>
  241.               小类:
  242.               <select name="nclassid" size="1" id="nclassid" onChange="changelocation3(document.myform.nclassid.options[document.myform.nclassid.selectedIndex].value)">
  243.                 <option value=571>粉底/粉饼</option><option value=572>胭脂/眼影</option><option value=573>彩妆套装</option><option value=574>唇线笔/卸妆</option>
  244.               </select>
  245.               子类: 
  246.               <select name="xclassid" onChange="changelocationlb(1)">
  247.                 
  248.                 <option value="16" >三级分类一</option>
  249.                 
  250.                 <option value="17" >三级分类二</option>
  251.                 
  252.                 <option value="21" >三级分类三</option>
  253.                 
  254.                 <option value="22" >三级分类四</option>
  255.                 
  256.               </select></td>
  257.           </tr>
  258.           <tr class="classtd"> 
  259.             <td class="classtd"><input name="submit" type="submit"  value="批量导入" align="absmiddle" onclick="LimitAttach(this.form, this.form.uploadfile.value)"> 
  260.               &nbsp; <input type="submit"  value="重新填写" border="0" alt=" 重填 " onclick="reset();return false;" align="absmiddle"> 
  261.               &nbsp;</td>
  262.           </tr>
  263.         </form>
  264.         <tr> 
  265.           <td colspan="2" class="classfaq"> <div class="faq_main"> 
  266.               <p class="faq_title">使用答疑:</p>
  267.               下载Excel模板,添加完数据后导入即可,<a href="Excel/product.xls" target="_blank"><u>点此下载</u></a>; 
  268.               <br>
  269.               每个Excel模板请选则一组商品类别。 <br>
  270.               请根据Excel文件中的数据类型要求添加。 </div></td>
  271.         </tr>
  272.       </table>
  273. </td>
  274. </tr>
  275. </table><style type="text/css">
  276. <!--
  277. .back_southidc {BACKGROUND-IMAGE:url('image/titlebg.gif');COLOR:000000;}
  278. .table_southidc {BACKGROUND-COLOR: A4B6D7;}
  279. .tit {font-size: 14px;
  280. }
  281. .tr_southidc {BACKGROUND-COLOR: ECF5FF;}
  282. -->
  283. </style>
  284. <div align="center">
  285. <table width="702" border="0" align="center" cellpadding="2" cellspacing="1" class="table_southidc">
  286.   <tr>
  287.     <td height="25" colspan="2" class="back_southidc"><div align="center"><span style="font-weight: bold">程序注册说明</span></div></td>
  288.   </tr>
  289.   <tr class="tr_southidc">
  290.     <form method="post" action="Admin_DataBackup.asp?action=Backup">
  291.       <td width="563"><div align="left"><span class="tit"><span class="style6">欢迎注册《网软天下购物网站管理系统正式版,正式版无加密无限制》 每套1000元
  292. <br />
  293.         联系QQ:<span class="style11">290116505<a target=blank href=tencent://message/?uin=290116505&Site=网域高科客服为你服务&Menu=yes><img border="0" src=qqonline.gif alt="网域高科客服为你服务" /></a>314730679</span><font face=Verdana><a target=blank href=tencent://message/?uin=314730679&Site=网域高科客服为你服务&Menu=yes><img border="0" src=qqonline.gif alt="网域高科客服为你服务" /></a></font>38306293</span><font face=Verdana><a target=blank href=tencent://message/?uin=38306293&Site=网域高科客服为你服务&Menu=yes><img border="0" src=qqonline.gif alt="网域高科客服为你服务" /></a></font>454882888</span><font face=Verdana><a target=blank href=tencent://message/?uin=454882888&Site=网域高科客服为你服务&Menu=yes><img border="0" src=qqonline.gif alt="网域高科客服为你服务" /></a></font><font face=Verdana><br />
  294.           </font><span class="style11">电话:020-34700400,34506590,13719472523,13527894748<br />
  295.             MSN:webmaster@wygk.cn<br />
  296.             演示:<a href="http://www.wygk.cn/shop8">http://www.wygk.cn/shop8</a><br />
  297.       官方:<a href="http://www.wygk.cn">http://www.wygk.cn</a></span></div></td>
  298.       <td width="128"><a href="https://pay3.chinabank.com.cn/Payto?v_mid=8279"><img src="paymentsby_01.gif" width="127" height="62" border="0" /></a></td>
  299.     </form>
  300.   </tr>
  301. </table>
  302. <div align="center"><font color="#000000">Copyright &copy; 2010-2030 <a href="http://www.Wrtx.Cn" target="_blank">广州网软天下信息技术有限公司</a> 
  303.   All rights reserved. 客户服务:020-34506590   020-34700400 客服QQ:290116505<br>
  304.   </font></div>
  305. </body>
  306. </html>