asp判断会员等级_百度知道
asp判断会员等级
用户设一个积分,根据积分来查询用户的等级
例如:用户表中的用户积分分别为15,等级表中,10-20为初级,20-30为中级,已知用户积分,如何显示等级
我有更好的答案
ASP判断会员等级,需要做如下两个动作: 1.需要在数据库中的用户表增加一个字段名如中级会员&quot呵呵,建议用session变量记录用户的等级;flag&flag& end if %& 2;20 and session(&flag&)&)&20 then response,欲显示用户的等级时&% if session(&flag&30 then response.write&quot.在登录页面中,可以这样写 &% if 用户名与密码正确 then session(&)&10 and session(&quot.write&初级会员& elseif session(&flag&)&gt
在表中建立一个字段（比如叫dengji的字段）;)&=10 then打开数据库rs(dengji)=rs(&quot，初始值为0，初级为1，中级为2;)=1 thenresponse.write &初级&elseif rs(&dengji&)=2 thenrssponse.write &dengji&quot，高级为3，会员在积分时候做判断做判断，if rs(&jifen&)+1rs.updaters.close然后等级在会员直接读if rs(&dengji&中级&quot
为您推荐：
其他类似问题
换一换
回答问题，赢新手礼包
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。他的最新文章
他的热门文章
您举报文章：
举报原因：
原文地址：
原因补充：
(最多只允许输入30个字)>> ASP中会员查询功能
ASP中会员查询功能
所属分类：
下载地址：
aspprint.rar文件大小：5.31 kB
分享有礼！ 》
请点击右侧的分享按钮，把本代码分享到各社交媒体。
通过您的分享链接访问Codeforge，每来2个新的IP，您将获得0.1 积分的奖励。
通过您的分享链接，每成功注册一个用户，该用户在Codeforge上所获得的每1个积分，您都将获得0.2 积分的分成奖励。
if request.Cookies("shiwei_username")="" then
&script language="javascript"&
top.location.href="../index.asp"
& response.end
&!-- #include file="../conn2.asp" --&
&!-- #include file="../const.asp" --&
&title&&%=dianming%& - 销售费用报表查询打印&/title&
&meta http-equiv="Content-Type" content="text/ charset=gb2312"&
&link href="../style/style.css" rel="stylesheet" type="text/css"&
background-color:#FFFFFF;
&script language="javascript"&
function collapse(img, objName)
obj = document.getElementById(objName);
if (img.src.indexOf('open') != -1)
img.src = img.src.replace('open', 'close');
obj.style.display = 'none';
img.src = img.src.replace('close', 'open');
obj.style.display = '';
function collapseall(img)
if (img.src.indexOf('open') != -1)
img.src = img.src.replace('open', 'close');
for (x=1;x&=&%=maxrecord%&;x++)
obj = document.getElementById("buy"+x);
obj.style.display = 'none';
img.src = img.src.replace('close', 'open');
for (x=1;x&=&%=maxrecord%&;x++)
obj = document.getElementById("buy"+x);
obj.style.display = '';
&script language=javascript&
function preview() {&
bdhtml=window.document.body.innerHTML;&
sprnstr="&!--startprint--&";&
eprnstr="&!--endprint--&";&
prnhtml=bdhtml.substr(bdhtml.indexOf(sprnstr)+17);&
prnhtml=prnhtml.substring(0,prnhtml.indexOf(eprnstr));&
window.document.body.innerHTML=&
window.print();&
window.document.body.innerHTML=&
& & & & &}
function CheckAll(form) &{
& for (var i=0;i&form.elements.i++) & &{
& & var e = form.elements[i];
& & if (e.name != 'chkall') & & & e.checked = form.chkall.&
if fla30="0" and request.Cookies("shiwei_id")&&"1" then
&br&&center&&img src="../images/note.gif" align="absmiddle"&&&font color="#FF0000"&你不具备此权限，请与管理员联系！&/font&&/center&
& response.end
'取得当前页码
currentpage=request("page")
'response.write currentpage
'response.end
if currentpage&1 or currentpage="" then
& currentpage="1"
'取得搜索关键字 &
nowstartdate=request("startdate")&
if nowstartdate="" then
& nowstartdate=date()-day(date()-1)
nowenddate=request("enddate")&
if nowenddate="" then
& nowenddate=date()
nowku=request("ku")
nowkeyword=request("keyword")&
if request.Cookies("shiwei_id")="1" or fla88="1" then
&sql="select * from ku order by id"
&set rs_ku=conn.execute(sql)
&sql="select * from ku where instr(login,',"&request.Cookies("shiwei_id")&",')&0 order by id"
&set rs_ku=conn.execute(sql)
&if rs_ku.eof then
& &nowku="0"
&elseif request("ku")="" then
& &nowku=rs_ku("id")
& sql="select * from bj where type=0 and zu and isok"
& if request.Cookies("shiwei_id")&&1 and lookbuysell="yes" and fla89="0" then
& & sql=sql&" and id_login="&request.Cookies("shiwei_id")
&if nowstartdate&&"" then
& & sql=sql&" and selldate-#"&nowstartdate&"#&=0"
& end if &
& if nowenddate&&"" then
& & sql=sql&" and selldate-#"&nowenddate&"#&=0"
& if nowku&&"" then
sql=sql&" and bianhao in (select bianhao from bj where type=0 and id_ku="&nowku&" and zu=false)"
& end if &
& if nowkeyword&&"" then
& & sql=sql&" and (bianhao = '"&nowkeyword&"' or id_huiyuan in (select id from huiyuan where username like '%"&nowkeyword&"%') or id_login in (select id from login where username like '%"&nowkeyword&"%') or bianhao in (select bianhao from bj where type=0 and (title like '%"&nowkeyword&"%' or huohao like '%"&nowkeyword&"%')))"
& if request("order1")&&"" then
& & sql=sql&" order by bianhao "&request("order1")
& elseif request("order2")&&"" then
& & sql=sql&" order by huohao "&request("order2")
& elseif request("order3")&&"" then
& & sql=sql&" order by title "&request("order3")&
& elseif request("order4")&&"" then
& & sql=sql&" order by selldate "&request("order4")&
& elseif request("order5")&&"" then
& & sql=sql&" order by id_login "&request("order5")&
& elseif request("order6")&&"" then
& & sql=sql&" order by (price-price2) "&request("order6")
& elseif request("order7")&&"" then
& & sql=sql&" order by shulian "&request("order7")
& elseif request("order8")&&"" then
& & sql=sql&" order by price2 "&request("order8")
& elseif request("order9")&&"" then
& & sql=sql&" order by price "&request("order9")
& elseif request("order10")&&"" then
& & sql=sql&" order by id_huiyuan "&request("order10") & & & &
& & sql=sql&" order by selldate desc" &
& sql2="select * from buy where type=1 and zu and isok"
& if nowstartdate&&"" then
& & sql2=sql2&" and selldate-#"&nowstartdate&"#&=0"
& end if &
& if nowenddate&&"" then
& & sql2=sql2&" and selldate-#"&nowenddate&"#&=0"
& if nowku&&"" then
sql2=sql2&" and bianhao in (select bianhao from buy where type=1 and id_ku="&nowku&" and zu=false)"
& end if &
& if nowkeyword&&"" then
& & sql2=sql2&" and (bianhao = '"&nowkeywor&"' or id_huiyuan in (select id from huiyuan1 where username like '%"&nowkeyword&"%') or id_login in (select id from login where username like '%"&nowkeyword&"%') or bianhao in (select bianhao from buy where type=1 and (title like '%"&nowkeyword&"%' or huohao like '%"&nowkeyword&"%')))"
& end if &
set count_sell = server.createobject("ADODB.RecordSet")
count_sell.open sql,conn,1,3
nowmoney=0
nowprice=0
zongshulian=0
nowfeiyong=0
do while count_sell.eof=false
&sql3="select sum(price*shulian),sum(price2*shulian),sum(shulian),sum(dshui2),sum(dyun),sum(dhui),sum(dyang),sum(dother) from bj where type=0 and bianhao='"&count_sell("bianhao")&"' and zu=false"
&if nowku&&"" then
& &sql3=sql3&" and id_ku="&nowku
&if nowkeyword&&"" then
& & & & sql3=sql3&" and (bianhao = '"&nowkeywor&"' or id_huiyuan in (select id from huiyuan1 where username like '%"&nowkeyword&"%') or id_login in (select id from login where username like '%"&nowkeyword&"%') or title like '%"&nowkeyword&"%' or huohao like '%"&nowkeyword&"%')"
&set rs_sum=conn.execute(sql3)
& nowmoney=nowmoney+rs_sum(0)
& nowprice=nowprice+rs_sum(1)
& zongshulian=zongshulian+rs_sum(2)
& nowfeiyong=nowfeiyong+rs_sum(3)+rs_sum(4)+rs_sum(5)+rs_sum(6)+rs_sum(7)
& count_sell.movenext
set count_back = server.createobject("ADODB.RecordSet")
count_back.open sql2,conn,1,3
nowmoney22=0
nowprice22=0
nowfeiyong2=0
zongshulian2=0
do while count_back.eof=false
&sql3="select sum(price*shulian),sum(price2*shulian),sum(shulian),sum(dshui2),sum(dyun),sum(dhui),sum(dyang),sum(dother) from buy where type=1 and bianhao='"&count_back("bianhao")&"' and zu=false"
&if nowku&&"" then
& &sql3=sql3&" and id_ku="&nowku
&if nowkeyword&&"" then
& & & & sql3=sql3&" and (bianhao = '"&nowkeyword&"' or id_huiyuan in (select id from huiyuan where username like '%"&nowkeyword&"%') or id_login in (select id from login where username like '%"&nowkeyword&"%') or title like '%"&nowkeyword&"%' or huohao like '%"&nowkeyword&"%')"
&set rs_sum=conn.execute(sql3)
& nowmoney2=nowmoney2+rs_sum(0)
& nowprice22=nowprice22+rs_sum(1)
& zongshulian2=zongshulian2+rs_sum(2)
& nowfeiyong22=nowfeiyong2+rs_sum(3)+rs_sum(4)+rs_sum(5)+rs_sum(6)+rs_sum(7)
& count_back.movenext
&table width="100%" border="0" cellpadding="0" cellspacing="2" align="center"&
&form name="form2"&
& & &td width="5%" height="21"&&&img src="../images/print.jpg" align="absmiddle" style="cursor:" onClick="preview();window.close()"&&/td&
&td width="95%" align="right"&
&开始日期：
& & & &input name="startdate" value="&%=nowstartdate%&" readonly style="width:100px"&
&&img src="../images/date.gif" align="absmiddle" style="cursor:" onClick="JavaScript:window.open('day.asp?form=form2&field=startdate&oldDate='+startdate.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=150,left=590');"&
&结束日期：
& & & &input name="enddate" value="&%=nowenddate%&" readonly style="width:100px"&
&&img src="../images/date.gif" align="absmiddle" style="cursor:" onClick="JavaScript:window.open('day.asp?form=form2&field=enddate&oldDate='+enddate.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=170,top=150,left=740');"&
&&select name="ku" onChange="form2.submit()"&
&%if request.Cookies("shiwei_id")="1" or fla88="1" then%&&
& & & & &option value=""&所有仓库&/option&
&%elseif rs_ku.eof then%&
& &&option value="0"&没有你管理的仓库&/option&
&%end if%&
do while rs_ku.eof=false
& & & & &option value="&%=rs_ku("id")%&"&%if trim(cstr(rs_ku("id")))=nowku then%& selected="selected"&%end if%&&&%=rs_ku("ku")%&&/option&
& & & & &%
&rs_ku.movenext
& & & &/select& &
&&input type="text" name="keyword" size="20" value="&%=nowkeyword%&"&
&&input type="hidden" name="hid" value="ok"&
&&input type="submit" value=" 查询 " class="button"&&
&table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="#C4D8ED"&
&td&&img src="../images/r_1.gif" alt="" /&&/td&
&td width="100%" background="../images/r_0.gif"&
& &table cellpadding="0" cellspacing="0" width="100%"&
& & & &td&&报价统计 &a href="excel_bj.asp?page=&%=currentpage%&&keyword=&%=nowkeyword%&&ku=&%=nowku%&&bigclass=&%=nowbigclass%&&smallclass=&%=nowsmallclass%&&order1=&%=request("order1")%&&order2=&%=request("order2")%&&order3=&%=request("order3")%&&order4=&%=request("order4")%&&order5=&%=request("order5")%&&order6=&%=request("order6")%&&order7=&%=request("order7")%&&order8=&%=request("order8")%&&order9=&%=request("order9")%&&order10=&%=request("order10")%&&order11=&%=request("order11")%&&order12=&%=request("order12")%&&order13=&%=request("order13")%&&order14=&%=request("order14")%&&order15=&%=request("order15")%&" target="_blank"&&img src="../images/excel.jpg" border="0" align="absmiddle" alt="导出Excel表格"&&/a&&/td&
&&td align="right"&总报售额：&i&&%=formatnumber(nowmoney,2)%&&/i& 元 (&%=formatnumber(zongshulian,2)%&)，顾客退货：&u&&%=formatnumber(nowmoney2,2)%&&/u& 元 (&%=formatnumber(zongshulian2,2)%&)，实际报价：&b&&%=formatnumber(nowmoney-nowmoney2,2)%&&/b& 元&%if request.Cookies("shiwei_id")="1" or fla87="1" then%&，实际费用支付：&b&正常：&%=formatnumber(nowfeiyong,2)%&&/b&-&b&&%=formatnumber(nowfeiyong2,2)%&&/b&=&b&&%=formatnumber(nowfeiyong-nowfeiyong2,2)%&&/b&元，报价利润：&b&&%=formatnumber(nowmoney-nowprice-nowmoney2+nowprice2-nowfeiyong+nowfeiyong2,2)%&&/b& 元&%end if%&&&/td&
& &/table&
&td&&img src="../images/r_2.gif" alt="" /&&/td&
&!--startprint--&
&table align="center" cellpadding="4" cellspacing="1" class="toptable grid" border="1"&
&form name="form1"&
& &input type="hidden" name="startdate" value="&%=nowstartdate%&"&
& &input type="hidden" name="enddate" value="&%=nowenddate%&"&
& &input type="hidden" name="ku" value="&%=nowku%&"&
& &input type="hidden" name="keyword" value="&%=nowkeyword%&"&
& &input type="hidden" name="order1" value="&%=request("order1")%&"&
& &input type="hidden" name="order2" value="&%=request("order2")%&"&
& &input type="hidden" name="order3" value="&%=request("order3")%&"&
& &input type="hidden" name="order4" value="&%=request("order4")%&"&
& &input type="hidden" name="order5" value="&%=request("order5")%&"&
& &input type="hidden" name="order6" value="&%=request("order6")%&"&
& &input type="hidden" name="order7" value="&%=request("order7")%&"&
& &input type="hidden" name="order8" value="&%=request("order8")%&"&
& &input type="hidden" name="order9" value="&%=request("order9")%&"&
& &input type="hidden" name="order10" value="&%=request("order10")%&"&
& &input type="hidden" name="order11" value="&%=request("order11")%&"&
& &input type="hidden" name="order12" value="&%=request("order12")%&"&
& &input type="hidden" name="order13" value="&%=request("order13")%&"&
& &input type="hidden" name="order14" value="&%=request("order14")%&"&
& &input type="hidden" name="order15" value="&%=request("order15")%&"&&
& &tr align="center"&
& & &td class="category" width="10"&&img src="../images/folder_close.gif" style="cursor:hand" onClick="collapseall(this)" /&&/td&
& & &td class="category" height="30"&
&&a href="?order1=&%if request("order1")="asc" then%&desc&%else%&asc&%end if%&&page=&%=currentpage%&&startdate=&%=nowstartdate%&&enddate=&%=nowenddate%&&ku=&%=nowku%&&keyword=&%=nowkeyword%&" class="title"&报价编号&%if request("order1")="asc" then%&&img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"&&%else%&&img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"&&%end if%&&/a&
&td class="category"&
&&a href="?order4=&%if request("order4")="asc" then%&desc&%else%&asc&%end if%&&page=&%=currentpage%&&startdate=&%=nowstartdate%&&enddate=&%=nowenddate%&&ku=&%=nowku%&&keyword=&%=nowkeyword%&" class="title"&报价时间&%if request("order4")="asc" then%&&img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"&&%else%&&img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"&&%end if%&&/a&
&td class="category"&
&&a href="?order5=&%if request("order5")="asc" then%&desc&%else%&asc&%end if%&&page=&%=currentpage%&&startdate=&%=nowstartdate%&&enddate=&%=nowenddate%&&ku=&%=nowku%&&keyword=&%=nowkeyword%&" class="title"&经办人&%if request("order5")="asc" then%&&img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"&&%else%&&img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"&&%end if%&&/a&
&td class="category"&
&&a href="?order7=&%if request("order7")="asc" then%&desc&%else%&asc&%end if%&&page=&%=currentpage%&&startdate=&%=nowstartdate%&&enddate=&%=nowenddate%&&ku=&%=nowku%&&keyword=&%=nowkeyword%&" class="title"&数量&%if request("order7")="asc" then%&&img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"&&%else%&&img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"&&%end if%&&/a&
&td class="category"&
&&a href="?order9=&%if request("order9")="asc" then%&desc&%else%&asc&%end if%&&page=&%=currentpage%&&startdate=&%=nowstartdate%&&enddate=&%=nowenddate%&&ku=&%=nowku%&&keyword=&%=nowkeyword%&" class="title"&报价金额&%if request("order9")="asc" then%&&img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"&&%else%&&img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"&&%end if%&&/a&
&%if request.Cookies("shiwei_id")="1" or fla87="1" then%&
&td class="category"&
&&a href="?order8=&%if request("order8")="asc" then%&desc&%else%&asc&%end if%&&page=&%=currentpage%&&startdate=&%=nowstartdate%&&enddate=&%=nowenddate%&&ku=&%=nowku%&&keyword=&%=nowkeyword%&" class="title"&成本金额&%if request("order8")="asc" then%&&img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"&&%else%&&img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"&&%end if%&&/a&
& & &td class="category"&税金&/td&
& & &td class="category"&其它(回|样|运|其)&/td&
& & &td class="category"&已执行&/td&
&td class="category"&
&&a href="?order6=&%if request("order6")="asc" then%&desc&%else%&asc&%end if%&&page=&%=currentpage%&&startdate=&%=nowstartdate%&&enddate=&%=nowenddate%&&ku=&%=nowku%&&keyword=&%=nowkeyword%&" class="title"&利润&%if request("order6")="asc" then%&&img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"&&%else%&&img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"&&%end if%&&/a&
&%end if%&
&td class="category"&
&&a href="?order10=&%if request("order10")="asc" then%&desc&%else%&asc&%end if%&&page=&%=currentpage%&&startdate=&%=nowstartdate%&&enddate=&%=nowenddate%&&ku=&%=nowku%&&keyword=&%=nowkeyword%&" class="title"&客户名称&%if request("order10")="asc" then%&&img src="../images/up2.gif" border="0" hspace="2" align="absmiddle"&&%else%&&img src="../images/down2.gif" border="0" hspace="2" align="absmiddle"&&%end if%&&/a&
& set rs_buy =server.createobject("ADODB.RecordSet")
& rs_buy.open sql,conn,1,3
& if not rs_buy.eof then
& rs_buy.pagesize=maxrecord
& rs_buy.absolutepage=currentpage
& for currentrec=1 to rs_buy.pagesize
& & if rs_buy.eof then
& & & exit for
& & end if
& &tr onMouseOver="this.className='highlight'" onMouseOut="this.className=''" onDblClick="javascript:var win=window.open('../produit/print_bj.asp?bianhao=&%=rs_buy("bianhao")%&','详细信息','width=853,height=470,top=176,left=161,toolbar=no,location=no,directories=no,status=no,menubar=no,resizable=no,scrollbars=yes'); win.focus()"&
& & &td align="center"&&img src="../images/folder_close.gif" style="cursor:hand" onClick="collapse(this, 'buy&%=currentrec%&')" /&&/td&
&td align="center" height="25"&&%=rs_buy("bianhao")%&&/td&
&td align="center"&&%=rs_buy("selldate")%&&/td&
&td align="center"&
&sql="select * from login where id="&rs_buy("id_login")
&set rs_login=conn.execute(sql)
&&%if rs_login.eof then%&&%=rs_buy("login")%&&%else%&&%=rs_login("username")%& (&%=rs_login("bianhao")%&)&%end if%&
&td align="center"&
&sql="select sum(shulian) from bj where bianhao='"&rs_buy("bianhao")&"' and zu=false"
&if nowku&&"" then
& &sql=sql&" and id_ku="&nowku
&if nowkeyword&&"" then
& & & & sql=sql&" and (bianhao = '"&nowkeyword&"' or id_huiyuan in (select id from huiyuan where username like '%"&nowkeyword&"%') or id_login in (select id from login where username like '%"&nowkeyword&"%') or title like '%"&nowkeyword&"%' or huohao like '%"&nowkeyword&"%')"
&set rs_sum=conn.execute(sql)
&&%=formatnumber(rs_sum(0),2)%&
&td align="center"&
&sql="select sum(price*shulian) from bj where bianhao='"&rs_buy("bianhao")&"' and zu=false"
&if nowku&&"" then
& &sql=sql&" and id_ku="&nowku
&if nowkeyword&&"" then
& & & & sql=sql&" and (bianhao = '"&nowkeyword&"' or id_huiyuan in (select id from huiyuan where username like '%"&nowkeyword&"%') or id_login in (select id from login where username like '%"&nowkeyword&"%') or title like '%"&nowkeyword&"%' or huohao like '%"&nowkeyword&"%')"
&set rs_sum=conn.execute(sql)
&&%=formatnumber(rs_sum(0),2)%&
&%if request.Cookies("shiwei_id")="1" or fla87="1" then%&
&td align="center"&
&sql="select sum(price2*shulian) from bj where bianhao='"&rs_buy("bianhao")&"' and zu=false"
&if nowku&&"" then
& &sql=sql&" and id_ku="&nowku
&if nowkeyword&&"" then
& & & & sql=sql&" and (bianhao = '"&nowkeyword&"' or id_huiyuan in (select id from huiyuan where username like '%"&nowkeyword&"%') or id_login in (select id from login where username like '%"&nowkeyword&"%') or title like '%"&nowkeyword&"%' or huohao like '%"&nowkeyword&"%')"
&set rs_sum=conn.execute(sql)
&&%=formatnumber(rs_sum(0),2)%&
& & &td align="center"&&%=rs_buy("dshui2")%&&/td&
& & &td align="center"&&%=rs_buy("dhui")%&|&%=rs_buy("dyang")%&|&%=rs_buy("dyun")%&|&%=rs_buy("dother")%&&/td&
& & &td align="center"&&%if rs_buy("dshou") then%&&img src="../images/nomoney.gif" border="0" alt="收款日期：&%=rs_buy("dshoudate")%&"&&%else%&&img src="../images/check.gif" border="0" alt="还没有收款"&&%end if%&&/td&
&td align="center"&
&sql="select sum((price-price2)*shulian),sum(dshui2+dyun+dyang+dhui+dother) from bj where bianhao='"&rs_buy("bianhao")&"' and zu=false"
&if nowku&&"" then
& &sql=sql&" and id_ku="&nowku
&if nowkeyword&&"" then
& & & & sql=sql&" and (bianhao = '"&nowkeyword&"' or id_huiyuan in (select id from huiyuan where username like '%"&nowkeyword&"%') or id_login in (select id from login where username like '%"&nowkeyword&"%') or title like '%"&nowkeyword&"%' or huohao like '%"&nowkeyword&"%')"
&set rs_sum=conn.execute(sql)
&&%=formatnumber(rs_sum(0)-rs_sum(1),2)%&
&%end if%&
&td align="center"&
&sql="select * from huiyuan where id="&rs_buy("id_huiyuan")
&set rs_huiyuan=conn.execute(sql)
&&%if rs_huiyuan.eof=false then%&&%=rs_huiyuan("username")%&&%else%&临时客户&%end if%&
& & sql="select * from bj where type=0 and zu=false and bianhao='"&rs_buy("bianhao")&"'"
if nowku&&"" then
&sql=sql&" and id_ku="&nowku
if nowkeyword&&"" then
& & & sql=sql&" and (bianhao = '"&nowkeyword&"' or id_huiyuan in (select id from huiyuan where username like '%"&nowkeyword&"%') or id_login in (select id from login where username like '%"&nowkeyword&"%') or title like '%"&nowkeyword&"%' or huohao like '%"&nowkeyword&"%')"
set rs_buy2=conn.execute(sql)
& &tr id="buy&%=currentrec%&" style="display:"&
& & &td colspan="16" class="category"&
&&table align="center" cellpadding="4" cellspacing="1" class="grid" border="1" width="100%"&
&tr align="center"&
&&%if showpic="yes" then%&&td width="70"&图片&/td&&%end if%&
&&td height="30"&产品名称/货号&/td&
&&td&规格参数&/td&
&&td&出货仓库&/td&
&&td&数量&/td&
&&td&单价&/td&
&&td&金额&/td&
&&%if request.Cookies("shiwei_id")="1" or fla87="1" then%&
&&td&成本单价&/td&
&&td&成本金额&/td&
&&%end if%&
do while rs_buy2.eof=false
sql="select * from produit where id="&rs_buy2("id_produit")
set rs_produit=conn.execute(sql)
&&%if showpic="yes" then%&&td align="center"&&%if rs_produit.eof then%&&%if rs_buy2("photo")&&"" then%&&a href="../upload/&%=rs_buy2("photo")%&" target="_blank"&&img src="../upload/&%=rs_buy2("photo")%&" border="0" width="60"&&/a&&%else%&无图&%end if%&&%else%&&%if rs_produit("photo")&&"" then%&&a href="../upload/&%=rs_produit("photo")%&" target="_blank"&&img src="../upload/&%=rs_produit("photo")%&" border="0" width="60"&&/a&&%else%&无图&%end if%&&%end if%&&/td&&%end if%&
&&td align="center"&&%if rs_produit.eof then%&&%=rs_buy2("huohao")%&&%else%&&%=rs_produit("huohao")%&&%end if%&&/td&
&&td align="center"&&%if rs_produit.eof then%&&%=rs_buy2("title")%&&%else%&&%=rs_produit("title")%&&%end if%&&/td&
&&td align="center"&&%=rs_buy2("ku")%&&/td&
&&td align="center"&&%=formatnumber(rs_buy2("shulian"),2)%&&/td&
&&td align="center"&&%=formatnumber(rs_buy2("price"),2)%&&/td&
&&td align="center"&&%=formatnumber(rs_buy2("shulian")*rs_buy2("price"),2)%&&/td&
&&%if request.Cookies("shiwei_id")="1" or fla87="1" then%&
&&td align="center"&&%=formatnumber(rs_buy2("price2"),2)%&&/td&
&&td align="center"&&%=formatnumber(rs_buy2("shulian")*rs_buy2("price2"),2)%&&/td&
&&%end if%& &
rs_buy2.movenext
&&%=replace(rs_buy("beizhu")&"",chr(13),"&br&")%&
& & rs_buy.movenext
& &tr align="center" onMouseOver="this.className='highlight'" onMouseOut="this.className=''"&
& & &td colspan="16" height="25" align="center" style="color:red"&&b&没有找到记录&/b&&/td&
& if rs_buy.recordcount&0 then&
& & &td colspan="16" height="30" class="category"&
&table cellpadding=0 cellspacing=0 width="100%"&
&td width="20%" align="left" style="color:#FF0000;"&&双击查看打印单&/td& &
&td width="80%" align="right"&
& & & &%=rs_buy.recordcount%&&条信息& 共&&%=rs_buy.pagecount%&&页&
& nowstart=currentpage-3
& if nowstart&1 then
& & nowstart=1
& nowend=currentpage+3
& if nowend&rs_buy.pagecount then
& & nowend=rs_buy.pagecount
& response.write "&&a href='?startdate="&nowstartdate&"&enddate="&nowenddate&"&ku="&nowku&"&keyword="&nowkeyword&"&page=1&order1="&request("order1")&"&order2="&request("order2")&"&order3="&request("order3")&"&order4="&request("order4")&"&order5="&request("order5")&"&order6="&request("order6")&"&order7="&request("order7")&"&order8="&request("order8")&"&order9="&request("order9")&"&order10="&request("order10")&"&order11="&request("order11")&"&order12="&request("order12")&"&order13="&request("order13")&"&order14="&request("order14")&"&order15="&request("order15")&"' class='page'&最前页&/a&&"
& for ipage=nowstart to nowend
& & if cstr(ipage)=cstr(currentpage) then
& & & response.write "&&span style='font-weight:color:#5858E6'&" & ipage &"&/span&&"
& & & response.write "&[&&a href='?startdate="&nowstartdate&"&enddate="&nowenddate&"&ku="&nowku&"&keyword="&nowkeyword&"&page="&ipage&"&order1="&request("order1")&"&order2="&request("order2")&"&order3="&request("order3")&"&order4="&request("order4")&"&order5="&request("order5")&"&order6="&request("order6")&"&order7="&request("order7")&"&order8="&request("order8")&"&order9="&request("order9")&"&order10="&request("order10")&"&order11="&request("order11")&"&order12="&request("order12")&"&order13="&request("order13")&"&order14="&request("order14")&"&order15="&request("order15")&"' class='page'&" & ipage &"&/a&&]&"
& & end if
& response.write "&&a href='?startdate="&nowstartdate&"&enddate="&nowenddate&"&ku="&nowku&"&keyword="&nowkeyword&"&page="&rs_buy.pagecount&"&order1="&request("order1")&"&order2="&request("order2")&"&order3="&request("order3")&"&order4="&request("order4")&"&order5="&request("order5")&"&order6="&request("order6")&"&order7="&request("order7")&"&order8="&request("order8")&"&order9="&request("order9")&"&order10="&request("order10")&"&order11="&request("order11")&"&order12="&request("order12")&"&order13="&request("order13")&"&order14="&request("order14")&"&order15="&request("order15")&"' class='page'&最后页&/a&&"
& & &select name="page" onChange="form1.action='?';form1.submit();"&
for x=1 to rs_buy.pagecount
&&option value="&%=x%&"&%if currentpage=trim(cstr(x)) then%& selected="selected"&%end if%&&&%=x%&&/option&
& &/tr&&/table&&/td&&/tr&
&%end if%&
&!--endprint--&
&td&&img src="../images/r_4.gif" alt="" /&&/td&
&td&&img src="../images/r_3.gif" alt="" /&&/td&
Sponsored links
源码文件列表
温馨提示： 点击源码文件名可预览文件内容哦 ^_^
25.93 kB05-06-16 11:32
&新建文件夹&0.00 B05-06-16 13:27
（提交有效评论获得积分）
评论内容不能少于15个字，不要超出160个字。
评价成功，多谢！
下载aspprint.rar
CodeForge积分（原CF币）全新升级，功能更强大，使用更便捷，不仅可以用来下载海量源代码马上还可兑换精美小礼品了
您的积分不足，优惠套餐快速获取 30 积分
10积分 / ￥100
30积分 / ￥200原价 ￥300 元
100积分 / ￥500原价 ￥1000 元
订单支付完成后，积分将自动加入到您的账号。以下是优惠期的人民币价格，优惠期过后将恢复美元价格。
支付宝支付宝付款
微信钱包微信付款
更多付款方式：、
您本次下载所消耗的积分将转交上传作者。
同一源码，30天内重复下载，只扣除一次积分。
鲁ICP备号-3 runtime:Elapsed:841.332ms - init:0.1;find:0.9;t:11.2;tags:0.4;related:125.8;comment:0.2; 27.69
登录 CodeForge
还没有CodeForge账号？
Switch to the English version?
^_^"呃 ...
Sorry!这位大神很神秘，未开通博客呢，请浏览一下其他的吧