Watercolor Painting Animal
Flower
Landscape Seascape Still life Paint from photo Printed painting Decoration Painting 1.Group Painting 2. Simple Oil Painting 
Abstract
Flower
Landscape Portrait Still life 3.Realistic Oil Painting
Flower
Fruit 4.Knife Painting
Ka
Kb
Kc Frame
Frame
Moulding
Stretcher Bar
Person
Classic character
Maidens Ballet  Children Nude Fat people Model Abstract
Oriental Religion America Sports Cartoon Landscape Seascape Paris street Mediterranean Ship Animal Dog & Cat
Lion & Tiger
Horse
Bird Other animals Venice Jazz Garden Scenery Fantasy
Picasso Van Gogh Monet  Rubens Vinci Pissarro Delacroix Kandinsky Gauguin Michelangel Dali Repin Rousseau Daumi
| |
 | Contact us |  |
|
| Address: |
No 782, Wushipu, Xiamen China |
| Contact
Person: |
Import
& Export Department |
| Telephone:
|
0086-0592-8750382 | | Fax:
|
0086-0592-3852113 | | E-mail:
| jandmoilpainting@gmail.com
|
| | Website:
| http://www.jandm.cn |
Please contact us with any questions you have using the e-mail from above. You may also leave your message here.or click our online service. |
| | <% set frs=server.CreateObject("adodb.recordset")
' if request("skey")<>"" then
' sql="select * from product where typeid="& request("menu1")&" and product like'%"& request("skey") & "%' order by paixu desc"
' else
' classid=request("classid")
' if classid<>"" or request("nclassid")<>"" then
' if classid<>"" and request("nclassid")<>"" then
' sql="select * from product where typeid="& classid & " and ntypeid=" & request("nclassid") & " order by paixu desc"
' elseif classid<>"" and request("nclassid")="" then
' sql="select * from product where typeid=" & classid&" order by paixu desc"
' elseif classid="" and request("nclassid")<>"" then
' sql="select * from product where ntypeid="& request("nclassid")&" order by paixu desc"
' end if
' else
' sql="select * from product order by paixu desc"
' end if
' end if
if request("classid")<>"" then
ji=" and typeid="&request("classid")
else
if request("nclassid")<>"" then
ji=" and ntypeid="&request("nclassid")
else
ji=" and typeid<>37 "
end if
end if
if trim(request("skey"))<>"" then
ji1=" and product like '%"&request("skey")&"%'"
else
ji1=""
end if
sql="select * from product where id is not null "
sql=sql+ji+ji1+" order by paixu desc"
'response.Write(sql)
'response.End()
frs.open sql,con,1,1
%>
<%
if frs.bof or frs.eof then
response.write"没有发布产品!"
'response.end
else
if request("page")="" then
page=1
else
page=request("page")
end if%>
<% if Trim(Request.Form("skey"))<>"" then
set frs=server.CreateObject("adodb.recordset")
sql = "select * from product where product like '%"&Trim(Request.Form("skey"))&"%' order by id desc"
'response.write sql
'response.end()
frs.open sql,con,1,1
end if
if frs.eof then
response.Write("没有记录!")
response.End()
end if%>
<% '=request("text")%><% if trim(request("text"))<>"" then
'response.Write(request("text"))
if cint(request("text"))<1 then
page=1
elseif cint(request("text"))>cint(request("rsmax")) then
page=int(request("rsmax"))
else
page=request("text")
end if
end if
'response.Write(page)
frs.pagesize=12
frs.AbsolutePage=page%>
| <% c=0
d=0
do while not frs.eof%>
<% c=c+1%><% if c>3 then%> <% c=0 %><% end if%><%d=d+1%><% if not frs.eof then%><% frs.movenext%><% else
exit do
end if%>
<% if d>frs.pagesize-1 then exit do%><%loop%> <% End If %> |
|
|
| |
| | |