📄 daysale.asp
字号:
</TR>
</TBODY>
</TABLE></TD>
<TD class=DashedFrame_Right><IMG height=1
width=1></TD>
</TR>
<TR>
<TD height="858" class=DashedFrame_Angle_3><IMG height=1
width=1></TD>
<TD class=DashedFrame_Bottom><IMG height=1
width=1></TD>
<TD class=DashedFrame_Angle_4><IMG height=1
width=1></TD>
</TR>
</TBODY>
</TABLE>
<%rsa.close
set rsa=nothing
%>
<br>
<TABLE cellSpacing=0 cellPadding=0 width="100%"
border=0>
<TBODY>
<TR>
<TD align=middle width="3%" height=32><IMG
height=20
src="../images/Ico_CircleBlue1.gif"
width=20></TD>
<TD class=AreaName width="12%"><% if s_keyword="" then Response.Write"当日销售清单" else Response.Write"查询帐目清单" end if%></TD>
<TD class=AreaName align=right width="20%"><div align="center">当前日期：<%=year(now()) & "年" & month(now()) & "月" & day(now()) & "日"%>
</div>
<TD class=AreaName align=middle width="40%"> </TD>
</TR></TBODY></TABLE>
<%
if s_keyword="" then
if s_keyword="" then
sql="select * from SalesData where saleyear='"&msaleyear&"' and salemonth='"&msalemonth&"' and saleday='"&msaleday&"' order by saletime desc"
end if
else
if s_keyword<>"" then
sql ="select * from SalesData where ["&s_saletypes&"] like '%"&s_keyword&"%' order by saletime desc"
end if
end if
rs.open sql,conn,1,3
rcount=rs.recordcount
if pmcount="" or isempty(pmcount) or pmcount<1 then
pmcount=10
end if
rs.pagesize=pmcount '设置每页数
mpage=rs.pagecount '得到总页数
'pageno=RtnReplaceInt(Request("pageno"),1)
if cint(pageno)<1 or cint(pageno)>mpage then
pageno=1
end if
if rs.bof and rs.eof then
response.write "<TABLE cellSpacing=0 cellPadding=0 width='96%' align=center border=0>"
response.write "<TBODY>"
response.write " <TR> <TD class=DashedFrame_Angle_1><IMG height=1 width=1></TD>"
response.write " <TD class=DashedFrame_Top><IMG height=1 width=1></TD>"
response.write " <TD class=DashedFrame_Angle_2><IMG height=1 width=1></TD>"
response.write " </TR>"
response.write " <TR>"
response.write " <TD class=DashedFrame_Left><IMG height=1 width=1></TD>"
response.write " <TD class=DashedFrame_Bg>"
response.write " <TABLE cellSpacing=0 cellPadding=0 width='96%' align=center border=0>"
response.write " <TBODY>"
response.write " <TR>"
response.write " <TD class=DashedFrame_Bg><div align='center'><font color=ff0000>今日还未录入销售信息,未检索到相关信息</font></div></TD>"
response.write " </TR> </TBODY> </TABLE>"
response.write " </TD> <TD class=DashedFrame_Right><IMG height=1 width=1></TD>"
response.write " </TR>"
response.write " <TR>"
response.write " <TD height='858' class=DashedFrame_Angle_3><IMG height=1 width=1></TD>"
response.write " <TD class=DashedFrame_Bottom><IMG height=1 width=1></TD>"
response.write " <TD class=DashedFrame_Angle_4><IMG height=1 width=1></TD>"
response.write " </TR> </TBODY> </TABLE>"
else
rs.absolutepage=pageno '将指针移至指定页的第一条记录
loopno=pmcount
do while not rs.eof and loopno>0
%>
<TABLE cellSpacing=0 cellPadding=0 width="96%"
align=center border=0>
<TBODY>
<TR>
<TD class=DashedFrame_Angle_1><IMG height=1
width=1></TD>
<TD class=DashedFrame_Top><IMG height=1
width=1></TD>
<TD class=DashedFrame_Angle_2><IMG height=1
width=1></TD></TR>
<TR>
<TD class=DashedFrame_Left><IMG height=1
width=1></TD>
<TD class=DashedFrame_Bg>
<TABLE cellSpacing=3 cellPadding=0 width="96%"
align=center border=0>
<TBODY>
<TR>
<TD width="2%" height=20><IMG height=5
src="../images/Ico_Dot.gif" width=5></TD>
<TD width="5%" class=grayTxt>类型:</TD>
<TD width="19%" class=blueTxt><%=rs("Salestypes")%></TD>
<TD width="2%"><IMG height=5
src="../images/Ico_Dot.gif" width=5></TD>
<TD width="6%" class=grayTxt>单价:</TD>
<TD width="13%" class=blueTxt><%=rs("Price")%></TD>
<TD width="2%"><IMG height=5
src="../images/Ico_Dot.gif" width=5></TD>
<TD width="5%" class=grayTxt>数量:</TD>
<TD width="8%" class=blueTxt><%=rs("Volume")%></TD>
<TD width="1%"><IMG height=5
src="../images/Ico_Dot.gif" width=5></TD>
<TD width="7%" class=grayTxt>销售员:</TD>
<TD width="10%" class=blueTxt><%=rs("Salesman")%></TD>
<TD width="2%" class=blueTxt><IMG height=5
src="../images/Ico_Dot.gif" width=5></TD>
<TD width="9%" class=grayTxt>付款类型:</TD>
<TD width="9%" class=grayTxt><%=rs("Payment")%></TD>
</TR>
</TBODY></TABLE>
<TABLE cellSpacing=3 cellPadding=0 width="96%"
align=center border=0>
<TBODY>
<TR>
<TD width="2%" height=20><IMG height=5
src="../images/Ico_Dot.gif" width=5></TD>
<TD width="5%" class=grayTxt>客户:</TD>
<TD width="16%" class=blueTxt><%=rs("Customers")%></TD>
<TD width="2%"><IMG height=5
src="../images/Ico_Dot.gif" width=5></TD>
<TD width="5%" class=grayTxt>合计:</TD>
<TD width="15%" class=blueTxt><span class="redTxt"><%=rs("saleTotal")%></span></TD>
<TD width="2%"><IMG height=5
src="../images/Ico_Dot.gif" width=5></TD>
<TD width="5%" class=grayTxt>实收:</TD>
<TD width="15%" class=redTxt><%=rs("Revenue")%></TD>
<TD width="2%"><IMG height=5
src="../images/Ico_Dot.gif" width=5></TD>
<TD width="9%" class=grayTxt>操作时间:</TD>
<TD width="22%" class=blueTxt><%=rs("saletime")%></TD></TR>
</TBODY></TABLE>
<table width="96%" border="0" align="center">
<tr>
<td width="2%"><IMG height=5
src="../images/Ico_Dot.gif" width=5></td>
<td width="68%" class="grayTxt">品名: <font color=ff0000><%=rs("Designation")%></font></td>
<td width="6%" class="grayTxt"><strong>操作</strong></td>
<td width="24%" class="grayTxt"><a href="#">删除</a> <a href="addsale.asp?saleid=<%=rs("id")%>&leixing=<%=rs("Salestypes")%>&huilv=<%=rs("Currency")%>&ticheng=<%=server.urlencode(rs("Generateratio"))%>&xsman=<%=rs("salesman")%>&khlx=<%=rs("Customertypes")%>&fflx=<%=rs("Payment")%>">修改</a> <a href="#">查看</a> </td>
</tr>
</table></TD>
<TD class=DashedFrame_Right><IMG height=1
width=1></TD></TR>
<TR>
<TD height="858" class=DashedFrame_Angle_3><IMG height=1
width=1></TD>
<TD class=DashedFrame_Bottom><IMG height=1
width=1></TD>
<TD class=DashedFrame_Angle_4><IMG height=1
width=1></TD></TR></TBODY></TABLE><br>
<%
rs.movenext
loopno=loopno-1
loop
end if
rs.close
set rs=Nothing
endconnection
%>
<TABLE cellSpacing=0 cellPadding=0 width="96%"
align=center border=0>
<TBODY>
<TR>
<TD><div align="center">共 <%=cstr(rcount)%> 条记录 当前第 <%=cstr(pageno)&"/"&cstr(mpage)%> 页 每页 <%=pmcount%> 条
<%
if cint(pageno)>1 then%>
[ <a href='daysale.asp?cataid=<%=s_cataid%>&pageno=<%=pageno-1%>&keyword=<%=s_keyword%>' class="tt1">上一页</a> ]
<%
end if
if cint(pageno)<cint(mpage) then
%>
[ <a href='daysale.asp?cataid=<%=s_cataid%>&pageno=<%=pageno+1%>&keyword=<%=s_keyword%>' class="tt1">下一页</a> ]
<%end if%>
<input type=button onclick="vbscript:buildDoc" value="打印"> </div></TD>
</TR>
</TBODY>
</TABLE>
<TABLE cellSpacing=0 cellPadding=0 width=100 border=0>
<TBODY>
<TR>
<TD><IMG height=10
width=1></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD>
<TD class=Bg_RightShadow vAlign=top>
<TABLE cellSpacing=0 cellPadding=0 width=10 border=0>
<TBODY>
<TR>
<TD class=Bg_Angle_2><IMG height=1
width=1></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<TABLE height=10 cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD class=Bg_Angle_3><IMG height=1 width=1></TD>
<TD class=Bg_BottomShadow><IMG height=1 width=1></TD>
<TD class=Bg_Angle_4><IMG height=1
width=1></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE>
<SCRIPT language=jscript.encode>pmLoading.style.visibility="hidden";</SCRIPT>
</BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -