'----------不华丽的分割线--------------
sub CopyProd(lang,larCode,SmallCode)
OpenConn(lang)
set rs=server.createobject("adodb.recordset")
sql = "Select LarCode,MidCode From Db_ProdClass where LarCodeCn = '"&larCode&"' and MidCodeCn = '"& SmallCode &"'"
rs.open sql,conn,1,3
if not rs.eof then
larCode = rs("LarCode")
SmallCode = rs("MidCode")
rs.close
sql = "select * from Db_ProdMain"
rs.open sql,conn,1 , 3
rs.Addnew
rs("ProdId")=request("ProdId")
rs("ProdName")=request("ProdName")
rs("Model")=request("Model")
rs("LarCode")=larCode
rs("MidCode")=SmallCode
rs("ProdDisc")=request("ProdDisc")
rs("MemoSpec")=request("MemoSpec")
rs("photo")=request("photo")
rs("Remark")=request("Remark")
rs("tejia")=request("tejia")
rs("Online")=True
rs("AddDate")=date()
rs.update
end if
rs.close
conn.close
set rs = nothing
set conn = nothing
end sub
'----------不华丽的分割线--------------
sub OpenConn(lang)
select case lang
case "en"
Sub_DB="../database/qz368en.mdb"
case "kr"
Sub_DB="../database/qz368kr.mdb"
case "jp"
Sub_DB="../database/qz368jp.mdb"
case "fr"
Sub_DB="../database/qz368fr.mdb"
case "ru"
Sub_DB="../database/qz368ru.mdb"
case "es"
Sub_DB="../database/qz368es.mdb"
case "ar"
Sub_DB="../database/qz368ar.mdb"
case ""
Sub_DB="../database/qz368en.mdb"
end select
set conn=server.createobject("adodb.Connection")
connstr="provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(Sub_DB)
conn.Open connstr
end sub