<%
set rs = server.CreateObject("Adodb.recordSet")
set rs1 = server.CreateObject("Adodb.recordSet")
Sql = "select * from Class where id in (6,7,14)"
rs.open sql,Conn,1,1
while(not rs.eof)
%>
<%=rs("ename")%>
<%
Sql1 = "select * from PudClass where classid="&rs("id")
rs1.open sql1,Conn,1,1
while(not rs1.eof)
%>
<%
rs1.movenext
wend
rs1.close
rs.movenext
wend
rs.close
set rs=nothing
set rs1=nothing
%>
Our Clients
Lockheed Martin
KFC
UCLA
GUESS
Deloitte
Microsoft
Mercedes-Benz
Sino-Pec
ARA
Bank Of China
Tour de France
Discovery
PGP
Thales
Arsenal Football Club
Sasol
IBM
Astra Zeneca
SEE MORE CLIENTS
Testimonials
"You guys always care customer requirements, the crystal trophies arrived in good shape, good job! "
- Jon Clark
"Many of our customers are attracted by those beautiful crystal paperweights, and we will buy more and more from your company, thank you very much. "
- Emma Campbell
"Our customer liked this award very much, and they would like to proceed some new incentive programs with us, I really appreciate the great job you've been doing. "
Crystal Awards, Glass Awards, Custom Trophy Here Amazing Crystal Awards and Trophies from Crystal Awards Corporation In China, which is One Of the Best Crystal Awards Manufacturer in China.
<%
set RsUGObj=server.CreateObject("Adodb.RecordSet")
sql = "select * from Pud where id > 0 "
if request("ClassId") <> "" then
sql = sql + "And Class= '"&request.QueryString("ClassId")&"'"
elseif request("keywords") <> "" then
sql = sql + "And Description like '%"& request("keywords")&"%'"
end if
'response.Write(sql)
sql = sql&" order by id desc"
RsUGObj.open sql,conn,1,3
if RsUGObj.eof then response.Write("Sorry, the result is empty.")
if Not RsUGObj.eof then
Dim page_size,page_no,page_total,record_all,PageNums
page_size=Request.QueryString("page_size")
if page_size<=0 or page_size="" then page_size=10
If isnumeric(Request.Form("PageNums")) then
if Request.Form("PageNums")<>0 then
page_size = Cint(Request.Form("PageNums"))
end if
End if
page_no=request.querystring("page_no")
if page_no<=1 or page_no="" then page_no=1
If Request.QueryString("page_no")="" then
page_no=1
end if
RsUGObj.PageSize=page_size
page_total=RsUGObj.PageCount
if (cint(page_no)>page_total) then page_no=page_total
RsUGObj.AbsolutePage=page_no
record_all=RsUGObj.RecordCount
Dim i
for i=1 to RsUGObj.PageSize
if RsUGObj.eof then exit for
%>
<%
if RsUGObj("Description")<>"" then
%>
<%=RsUGObj("Description")%>
<%
else
%>
This crystal monolith flares into the five sharp arms of a star, symbolizing transformation. Present these crystal awards to your company's star performers today!
<%
end if
price = RsUGObj("price")
%>
<%
if i mod 2=0 then
%>
<%
else
%>
<%
end if
%>
<%
RsUGObj.MoveNext
Next
end if
%>
<%if page_total>1 then%>
<% = "NO."& page_no &", " %>
<% = "Totel:"& page_total &", RecordCounts:" & record_all &" "%>
<%
if Page_Total=1 then
response.Write " "
response.Write " "
response.Write " "
response.Write " "
else
if cint(Page_No)<>1 and cint(Page_No)<>Page_Total then
response.Write " "
response.Write " "
response.Write " "
response.Write " "
elseif cint(Page_No)=1 then
response.Write " "
response.Write " "
response.Write " "
response.Write " "
else
response.Write " "
response.Write " "
response.Write " next "
response.Write " "
end if
end if
%>
<%end if%>
What's the package of your crystal awards?
We use individual satin lined presentation box (gift box) to wrap the awards.
How shall we place an order?
You can send item number, dimension and required QTY to us by email, and we will forward the pricing to you ASAP .
For custom awards order, you can send specification, pictures or drawing, dimension, custom art and required QTY to us by email, and we will forward the pricing to you ASAP.
Would you ship the awards by UPS or FedEx?
For courier express shipping, we use DHL, UPS or FedEx to ship the awards.
Can you make custom project?
Sure, we make many custom projects every season. And custom design project is one of our best products.
Do you have price break based on different QTY?
Yes, larger quantities, better prices.
Can we order personalized gifts from your company?
Sure, we produce many personalized crystal gifts every month.
Do you produce glass paperweights?
We produce both crystal paperweight and glass paperweight, either for custom engraved or blank.
Do you sell blank crystal awards or blank crystal trophies?
Yes, we sell either blank crystal awards or engraved crystal awards. Depends on customer's requirement.