📄 g_mainlost.asp
字号:
<!--#include file="../include/Pubconn.asp"-->
<!--#include file="../include/PubFun.asp"-->
<% username=Getuser()%>
<%
set RSlost=server.createobject("adodb.recordset")
str="select * from G_TblLostReport where StuffNum='"&Session("UserID")&"' AND ( cdate(ReportDate) between (date()-10) and date() ) and DepartID='"&Session("DepartID")&"' order by id desc"
RSlost.open str,pubconn,1
'response.write str
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>单据查询</title><link href="cread.css" rel="stylesheet" type="text/css">
</head>
<script language="vbscript">
sub GoPage()
a="G_mainlost.asp?page="+document.myform.page1.value
window.location=a
end sub
</script>
<body bgcolor="#FFFFFF" >
<table border="0" cellpadding="0" cellspacing="0" width="100%">
<tr>
<td width="100%"><b><font size="3"><img border="0" src="../pic/it_22.gif">
</font><font size="2">丢单报告</font></b><hr width="40%" size="1" align="left">
</td>
</tr>
</table>
<p align="left">
<%
if RSlost.eof then %>
<font size="2">您最近十天内没有丢单记录。</font>
<br>
<input type="button" value="新增" name="B1" onclick="location.href='G_lost.asp'" class="hand" style="background-color: #D1D1D1; border-style: solid; border-width: 1">
<input type="button" value="明细查询" name="B1" onclick="location.href='G_lostdetail.asp'" class="hand" style="background-color: #D1D1D1; border-style: solid; border-width: 1">
<input type="button" value="统计查询" name="B1" onclick="location.href='G_losttj.asp'" class="hand" style="background-color: #D1D1D1; border-style: solid; border-width: 1">
<input type="button" value="审核" name="B1" onclick="location.href='G_lostsh.asp'" class="hand" style="background-color: #D1D1D1; border-style: solid; border-width: 1">
<% response.end
%>
<%else
if request.querystring("page")<>"" then
page=cint(request.querystring("page"))
else
page=1
end if
RSlost.pagesize=10
if page>=RSlost.pagecount then
page=RSlost.pagecount
else
if page<1 then
page=1
end if
end if
RSlost.absolutepage=page
%>
<div align="center">
<p align="left"><font size="2">您最近十天的丢单情况如下：</font>
<p> </p>
<form method="post" action="G_lostdel.asp" name="myform">
<table border="1" cellspacing="0" width="100%" height="15" width="100%" width="100%">
<tr>
<td width="26" height="24" align="center" width="122" bgcolor="#DDD2C4">
</td>
<td width="118" height="24" align="center" width="122" bgcolor="#DDD2C4">
<font size="2">丢失客户
</font>
</td>
<td width="56" height="24" align="center" width="131" bgcolor="#DDD2C4">
<font size="2">业务员
</font>
</td>
<td width="108" height="24" align="center" width="84" bgcolor="#DDD2C4">
<font size="2">报告日期
</font>
</td>
<td width="86" height="24" align="center" width="98" bgcolor="#DDD2C4">
<font size="2">产品
</font>
</td>
<td width="63" height="24" align="center" width="120" bgcolor="#DDD2C4">
<font size="2">竞争者
</font>
</td>
<td width="54" height="24" align="center" width="146" bgcolor="#DDD2C4">
<font size="2">竞争者签约时间
</font>
</td>
<td width="54" height="24" align="center" width="146" bgcolor="#DDD2C4">
<font size="2">状态
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -