zhifangtu5.asp

一个很好的在线购物系统

AAEAAQACAP///wACAAAAAAAAAAEAAgD///8AAgCAwP8AAAA9AAAACQAAAAEA
////////BAAAAAAABAAAAAQAAAA+AAAADQAAAAkAAAAAAEBBAAAAAAIAAAAA
AAQAAAD//2QAAAAAAAAAAAAAAAwBAAAAAAAAAQA/AAAABQAAAAAABgAAAAQA
AAAAAAAADAEAAAAAAAAAAAAADAEAAAAAAAAAAAQAAABAAAAAEQAAAAEAAQAD
AAAAAQAEAAAAQQAAABUAAABCAAAAEQAAAAUAAQADAAAAAAAEAAAA////////
//////////////////8AAAEAFgAAAEMAAAAXAAAAAAAAAAAAWUD//wYAAAAE
AAAA////////RAAAAAUAAAADADEwMAAGAAAABAAAAAAAAAwAAAABAAAAAAAC
AAAA//9FAAAABwAAAAEAAQABAAIAAAAAAAIAAAAAAAAAAADIQgAAyEIAAAEA
AgAAAAAAAgD///8AAACgQQAARgAAAAgAAAABAAEAAgD///8AAgAAAAAAAAAB
AAIA////AAIAgMD/AAAARwAAAAkAAAABAP///////wQAAAAAAAQAAAAEAAAA
SAAAAA0AAAAJAAAAAABAQQAAAAACAAAAAAAEAAAA//9kAAAAoAAAAOcMAAAI
AgAA8w0AAAEARAAAAGgBAAAMAQAAoAAAAOcMAAAIAgAA8w0AAAAABAAAAAAA
AAAAAP//AAAAAAEAAQABAAAAAAAAAAAAAAAAAP//AAAAAAQAAQAAAAAAAAAA
AAEABAAAAEkAAAAUAAAAAAD//woAAAABAAEAAAAAAAIAAAAAAAAAAAAAAEBA
AQABAAAAAAACAAAAAAAAAAAAAABAQAEAAQAAAAAAAgAAAAAAAAAAAAAAQEAA
APBCAABwQkoAAAAMAAAAAQAAAAIAAgAAAP//SwAAAAcAAAABAAEAAQACAAAA
AAACAAAAAAAAAAAAyEIAAMhCAAABAAIAAAAAAAIA////AAAAoEEAAEwAAAAI
AAAAAQABAAIA////AAIAAAAAAAAAAQACAP///wACAIDA/wAAAE0AAAAJAAAA
AQD///////8EAAAAAAAEAAAABAAAAE4AAAANAAAACQAAAAAAQEEAAAAAAgAA
AAAABAAAAP//ZAAAAAAAAAAAAAAAAAAAAAwBAAABAE8AAAAFAAAAAAAGAAAA
BAAAAAAAAAAMAQAAAAAAAAAAAAAAAAAADAEAAAAABAAAAFAAAAARAAAAAQAB
AAMAAAABAAQAAABRAAAAFQAAAFIAAAARAAAABQABAAMAAAAAAAQAAAD/////
/////////////////////wAAAAAWAAAAAgAAAP///////1MAAAAFAAAAAgBD
MQAGAAAABAAAAPAAAAwAAAABAAAAAgACAAAAAABUAAAABwAAAAEAAQABAAIA
AAAAAAIAAAAAAAAAAADIQgAAyEIAAAEAAgAAAAAAAgD///8AAACgQQAAVQAA
AAgAAAABAAEAAgD///8AAgAAAAAAAAABAAIA////AAIAgMD/AAAAVgAAAAkA
AAABAP///////wQAAAAAAAQAAAAEAAAAVwAAAA0AAABYAAAABQAAAA8AVGlt
ZXMgTmV3IFJvbWFuAAYAAAAEAAAAAABAQQAAAAACAAAAAAAEAAAAAABkAAAA
zAAAAJD+//95AwAAnP///wEAUwAAABgBAAAMAQAAzAAAAJD+///kAQAAnP//
/wAABAAAAAAAAAAAAP//AAAAAAEAAQABAAAAAAAAAAAAAAAAAP//AAAAAAQA
AQAAAAAAAAAAAAIABAAAAP//AAC0QgAAtELD9ag+AACAPx+FKz8EAM3MzD3/
/1kAAAAYAAAADgBWdFN1cmZhY2VEZXNjAAEAAQABAAIA////AAIAAAAAAAAA
AQABAAAAAAACAAAAAAAAAAAAAABAQAAAAAAAAFoAAAARAAAAAAABAAMAAAAA
AAQAAABbAAAAFAAAAAAAAAAKAAAAAQAAAAAAAAACAAAAAAAAAAAAAABAQAEA
AAAAAAAAAgAAAAAAAAAAAAAAQEABAAAAAAAAAAIAAAAAAAAAAAAAAEBAAAAA
AAAAAABcAAAADAAAAAEAAAACAAIAAAD///////9dAAAADQAAAAkAAAAAAEBB
AAAAAAIAAAAAAAQAAAAAAGQAAAAAAAAAAAAAAAAAAAAAAAAAAAD/////AAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAXgAAABEAAAAAAAEAAwAAAAAA
BAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAIAAAAA
AAAAAAAAAAAABAAAAP//XwAAABkAAAAMAFZ0Q0xpbmVJdGVtAAEAAAAAAAAA
AAABAAEAAgD/AAAAAgAAAAAAAAABAAkAAAAAAAIA/wAAAAAAoEEAAEBA////
/wQAAABgAAAAGQAAAAAAAAAAAAAAAQABAAIA//8AAAIAAAAAAAAAAQAJAAAA
AAACAP//AAAAAKBBAABAQP////8EAAAAAAAAAAAAAQABAAEAAAAEAAAA////
/wAAAQAAAAEAAQAAAA4AAADwAPAAAQD//wAAcEMAAHBDABwJRgCohEUBAGEA
AAAHAAAAAQABAAEAAgAAAAAAAgAAAAAAAAAAAMhCAADIQgAAAQACAAAAAAAC
AP///wAAAKBBAABiAAAACAAAAAEAAQACAP///wACAAAAAAAAAAEAAgD///8A
AgCAwP8AAABjAAAACQAAAAEA////////BAAAAAAABAAAAAQAAAAEAAAAZAAA
ABEAAAABAAEAAwAAAAEABAAAAGUAAAAaAAAACQBWdFNlcmllcwAEAAEAAQAA
AAIAAgD/AAAAAAAgQgAAQEABAAEAAAAAAAIA/wAAgAAAAAAAAEBAAQABAAIA
/wAAAAIAAAAAAAAA/////2YAAAARAAAABQABAAMAAAAFAAQAAABnAAAAGwAA
AA4AVnRTZXJpZXNQb2ludAABAGgAAAAcAAAADgBWdFNlcmllc0xhYmVsAAEA
DAAAAAEAAAACAAIAAAD///////9pAAAADQAAAAkAAAAAAEBBAAAAAAIAAAAA
AAQAAAD//2QAAAAyBAAA4AsAADIEAADgCwAAAQD/////AAAAAAAAAAAyBAAA
4AsAADIEAADgCwAAAAAEAAAAAAAAADIEAADgCwAA//////////8EAAAAagAA
ABsAAABrAAAAHAAAAAwAAAABAAAAAgACAAAA////////bAAAAA0AAAAJAAAA
AABAQQAAAAACAAAAAAAEAAAA//9kAAAAVwsAAOALAABXCwAA4AsAAAEA////
/wAAAAAAAAAAVwsAAOALAABXCwAA4AsAAAAABAAAAAAAAABXCwAA4AsAAP//
////////BAAAAG0AAAAbAAAAbgAAABwAAAAMAAAAAQAAAAIAAgAAAP//////
/28AAAANAAAACQAAAAAAQEEAAAAAAgAAAAAABAAAAP//ZAAAAHwSAADgCwAA
fBIAAOALAAABAP////8AAAAAAAAAAHwSAADgCwAAfBIAAOALAAAAAAQAAAAA
AAAAfBIAAOALAAD//////////wQAAABwAAAAGwAAAHEAAAAcAAAADAAAAAEA
AAACAAIAAAD///////9yAAAADQAAAAkAAAAAAEBBAAAAAAIAAAAAAAQAAAD/
/2QAAADFBwAAtgMAAMUHAAC2AwAAAQD/////AAAAAAAAAADFBwAAtgMAAMUH
AAC2AwAAAAAEAAAAAAAAAMUHAAC2AwAA//////////8EAAAAcwAAABsAAAB0
AAAAHAAAAAwAAAABAAAAAgACAAAA////////dQAAAA0AAAAJAAAAAABAQQAA
AAACAAAAAAAEAAAA//9kAAAA6g4AALYDAADqDgAAtgMAAAEA/////wAAAAAA
AAAA6g4AALYDAADqDgAAtgMAAAAABAAAAAAAAADqDgAAtgMAAP//////////
BAAAAP//AAAAAAAAAQABAAAAAAACAAAAAAAAAAAAAABAQAwAAAAAAAAAAAAA
AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAAAAAAAAgAAAACAAACAvwAA
QEB2AAAABQAAAAIAQzEABgAAAAQAAAB3AAAAHAAAAAwAAAABAAAAAgACAAAA
////////eAAAAA0AAAAJAAAAAABAQQAAAAACAAAAAAAEAAAAAABkAAAAAAAA
AAAAAAAAAAAAAAAAAAAAdgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
BAAAAHkAAAAMAAAAAQAAAAAAAgAAAP///////3oAAAANAAAAEAAAAAAAQEEA
AAAAAgDAAAAABAAAAP//AAAAAAAAAAAAAAAAGAEAAAwBAAABAHYAAAAYAQAA
DAEAAAAAAAAAAAAAGAEAAAwBAAAAAAQAAAABAHsAAAAdAAAADQBWdFRleHRG
b3JtYXQAAQAEAAAAAAB8AAAABQAAAAAABgAAAAQAAAB9AAAAHQAAAAQAAAAA
AH4AAAAFAAAAAAAGAAAABAAAAH8AAAAcAAAADAAAAAEAAAACAAIAAAD/////
//+AAAAADQAAAAkAAAAAAEBBAAAAAAIAAAAAAAQAAAD//2QAAAAAAAAAAAAA
AAAAAAAAAAAAAQD/////AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAA
AAD//wIAAQABAAAAAAACAP8AAAAAACBCAABAQAAAcEMAAAIA/wAAAIEAAAAJ
AAAAAQAAAP////8EAAAAAQAAAAQAAACAPwIA/wAAgAIA/wAAgAAAGwAAAAEA
BQAGAAcACAAJAAoAAAABAP//////////GAD//wsA////////////////////
//////8FAAIAAgACAAYACAAAAAAAAAAAAAAABAAAAIIAAAAeAAAADQBWdENo
YXJ0VGl0bGUAAQALAAAAgwAAAAwAAAABAAAAAgACAAAA////////hAAAAA0A
AAAJAAAAAABAQQAAAAACAAAAAAAEAAAAAABkAAAAAAAAAAAAAAAAAAAAAAAA
AAAAhQAAAAUAAAAAAAYAAAAEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA
AAAEAAAADgAAAPAAZAABAAAAAAAAAAAAAAAAAAAAAAAAAAEAhgAAAAcAAAAB
AAEAAQACAAAAAAACAAAAAAAAAAAAyEIAAMhCAAABAAIAAAAAAAIA////AAAA
oEEAAIcAAAAIAAAAAQABAAIA////AAIAAAAAAAAAAQACAP///wACAIDA/wAA
AIgAAAAJAAAAAQD///////8EAAAAAAAEAAAABAAAAAQAAACJAAAAHwAAAAcA
VnRMaXN0AAIAAwAAAAAABAAAAAAAAQAAAAAA//////////////////8DAAAA
AAAgAAAACQBWdFdpbmRvdwADAAQAAAAAAP//AAAAAA==
" 
	height=300 id=DMSChart1 style="HEIGHT: 300px; LEFT: 0px; TOP: 0px; WIDTH: 602px" 
	width=602></OBJECT>
<%
	m_spdl=request("spdl")
	m_spxl=request("spxl")
	m_ddate=request("ddate")
	m_edate=request("edate")
	
	
	set rs=server.createobject("adodb.recordset")     
	
              
 sql="select sum(quantity) as zsl,sum(money) as zje,clientnum from viewtzd where ordernum<>'' "      
      
      
	if m_spdl<>"" then     
		sql=replace(sql,"from",",prodcode from")     
		sql=sql&"and prodcode like '"&m_spdl&"%'"     
	end if     
	
     if m_spxl<>"" then     
  sql=replace(sql,"from",",model from")     
  sql=sql&" and model='"&m_spxl&"'"     
  end if   
	
       
	if m_ddate<>"" and m_edate="" then     
		sql=sql&" and orddate>='"&m_ddate&"' and orddate<='"&date()&"'"     
	end if     
	if m_ddate="" and m_edate<>"" then     
		sql=sql&" and orddate<='"&m_edate&"'"     
	end if     
	if m_ddate<>"" and m_edate<>"" then     
		sql=sql&" and orddate>='"&m_ddate&"' and orddate<='"&m_edate&"'"     
	end if     
       
	sql=sql&" group by"     
     
   if m_spdl<>"" then 
 sql=sql&" prodcode,"     
  end if        
       
  if m_spxl<>"" then     
  sql=sql&" model,"     
  end if    
          
  sql=sql&" clientnum order by sum(money) desc"  	  
  
if m_ddate="--" then
 sql="select sum(quantity) as zsl,sum(money) as zje,clientnum from viewtzd where ordernum<>'' group by clientnum order by sum(money) desc"      
	end if
	
	
  
	rs.open sql,pubconn,1,3     
	%>
	
	<%if rs.recordcount>0 then%>           
		<input type="hidden" name="count" value=<%=rs.RecordCount%>>           
		<%do while not rs.eof           
	%>         
	         
			<input type="hidden" name="money" value=<%=eval(trim(rs.Fields("zje")))%>>           
			<%           
			set rst1=server.CreateObject("adodb.recordset")         
			if rst1.State =1 then         
				rst1.Close          
			end if         
			rst1.Open "select clientname from d_clientInfo where clientnum='" & rs.Fields("clientnum") & "'",pubconn,1,3         
			if rst1.RecordCount >0 then%>         
				<input type="hidden" name="prod" value=<%=trim(rst1.Fields("clientname"))%>>           
			<%end if           
			%>         
			         
	<%           
			rs.movenext         
		loop         
	end if         
	rs.close         
	set rs=nothing         
%>         
<P><center><input type="button" value="返回" name="back" onclick="bb()" class=hand style="background-color: #D1D1D1; border-style: solid; border-width: 1">          
</center></P>                
</form>         
         
</BODY>         
</HTML>