📄 po.asp
字号:
}
if (form1.strfield.value=="Status"){
form1.strvalue.value=form1.strvalue2.value;
}
if (form1.strfield.value=="username"){
form1.strvalue.value=form1.strvalue3.value;
}
if (form1.strfield.value=='poDate'){
if(form1.strvalue.value==""){
alert("请输入搜索日期!");
return false;
}
if(CheckDate(document.form1.strvalue.value)){
alert("请输入正确格式的日期!");
return false;
}
}
form1.submit();
}
</SCRIPT>
<body leftmargin="10" rightmargin="0" topmargin="10">
<form name="form1" method="post" action="po.asp" onsubmit="return GetStrValue();">
<table width="100%" height="20" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10%"><select name="strfield" onchange="relativeinput_onchange();">
<option value=pono <%if request("strfield")="pono" then Response.Write "selected"%>>采购单号</option>
<option value=Account <%if request("strfield")="Account" then Response.Write "selected"%>>客户</option>
<option value=totalamount <%if request("strfield")="totalamount" then Response.Write "selected"%>>金额</option>
<option value=Status <%if request("strfield")="Status" then Response.Write "selected"%>>状态</option>
<option value=poDate <%if request("strfield")="poDate" then Response.Write "selected"%>>采购日期</option>
<option value=username <%if request("strfield")="username" then Response.Write "selected"%>>采购员</option>
</select></td>
<td width="18%">
<div id=strvalue1 <%if request("strfield")<>"Status" and request("strfield")<>"username" or request("strfield")="" then response.write "style=display:block" else response.write "style=display:none" end if%>>
<input type="text" name="strvalue1" value="<%=request("strvalue1")%>">
</div>
<div id=strvalue2 <%if request("strfield")="Status" then response.write "style=display:block" else response.write "style=display:none" end if%>>
<select name="strvalue2" class="stedit">
<option value="">--请选择采购状态--</option>
<%getgrouptype selecttablename,"Status",request("strvalue2")%>
</select></div>
<div id=strvalue3 <%if request("strfield")="username" then response.write "style=display:block" else response.write "style=display:none" end if%>>
<select name="strvalue3" class="stedit">
<option value="">--请选择采购员--</option>
<%getgrouptype selecttablename,"username",request("strvalue3")%>
</select></div>
</td>
<td>
<input type=hidden name="strvalue" value="<%=request("strvalue")%>" >
<select name="status">
<option value="nc">未完成</option>
<option value="all" <%if request("status")="all" then response.Write("selected")%>>所有</option>
</select>
<input type=image src="../images/button_submit.gif" style="cursor:hand" border=0 >
<%
if CurPage<=1 then
Response.Write "<a href='po.asp?status="&request("status")&"&turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage=1'><img src='../images/button_start.gif' border=0></a> "
else
Response.Write "<a href='po.asp?status="&request("status")&"&turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage=1'><img src='../images/button_start.gif' border=0></a> "
Response.Write "<a href='po.asp?status="&request("status")&"&turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage="&CurPage-1&"'><img src='../images/button_backward.gif' border=0></a> "
end if
if CurPage>=RS.PageCount then
Response.Write "<a href='po.asp?status="&request("status")&"&turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage="&RS.PageCount&"'><img src='../images/button_end.gif' border=0></a>"
else
Response.Write "<a href='po.asp?status="&request("status")&"&turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage="&CurPage+1&"'><img src='../images/button_forward.gif' border=0></a> "
Response.Write "<a href='po.asp?status="&request("status")&"&turnpage=yes&orderby="&session("orderby")&"&orderbyfield="&request("orderbyfield")&"&strvalue="&request("strvalue")&"&strfield="&request("strfield")&"&CurPage="&RS.PageCount&"'><img src='../images/button_end.gif' border=0></a>"
end if
%>
</td>
<td width=120>
<div id=dateformat <%if request("strfield")="poDate" then response.write "style=display:block" else response.write "style=display:none" end if%>>日期格式：YYYY-MM-DD</div></td>
</tr>
<tr>
<td height="25" colspan="4"><strong><font class=title>采购列表</font></strong>
<a href="javascript:opensubwin('resizable=yes, scrollbars=yes, left= 40, top=40, menubar=no, location=no, toolbar=no ,width=750, height=500','newpo.asp');"><img src="../images/button_new.gif" border=0></a> <a href="javascript:opensubwin('resizable=yes, scrollbars=yes, left= 300, top=220, menubar=no, location=no, toolbar=no ,width=300, height=200','relpoprint.asp?type=po');"><img src="../images/button_print.gif" border=0></a> <a href="uploadfile.asp"><!--从EXCEL导入--></a></td>
</tr>
<tr >
<td height="16" colspan="4" background="../images/title.gif"> </td>
</tr>
<tr>
<td height=4 colspan="4"></td>
</tr>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#DECFAD">
<tr bgcolor="#efefef">
<td width="7%" align=center height="22">操作</td>
<td width="15%" align=center bgcolor="efefef"><a href="po.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=pono&orderby=<%=session("orderby")%>">采购单号</a></td>
<td align=center bgcolor="efefef"><a href="po.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=account&orderby=<%=session("orderby")%>">供应商</a></td>
<td width="10%" align=center bgcolor="efefef"><a href="po.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=totalamount&orderby=<%=session("orderby")%>">金额</a></td>
<td width="8%" align=center bgcolor="efefef"><a href="po.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=status&orderby=<%=session("orderby")%>">状态</a></td>
<td width="8%" align=center bgcolor="efefef"><a href="po.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=podate&orderby=<%=session("orderby")%>">采购日期</a></td>
<td width="8%" align=center bgcolor="efefef"><a href="po.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=owner&orderby=<%=session("orderby")%>">采购员</a></td>
<td width="8%" align=center bgcolor="efefef"><a href="po.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=approvedate&orderby=<%=session("orderby")%>">审核日期</a></td>
<td width="8%" align=center bgcolor="efefef"><a href="po.asp?CurPage=<%=CurPage%>&strfield=<%=request("strfield")%>&strvalue=<%=request("strvalue")%>&orderbyfield=approver&orderby=<%=session("orderby")%>">审核人</a></td>
</tr>
<%
set pono=rs("pono")
set poid=rs("poid")
set accountid=rs("accountid")
set account=rs("account")
set totalamount=rs("totalamount")
set status=rs("status")
set podate=rs("podate")
set username=rs("username")
set approvedate=rs("approvedate")
set approver=rs("approver")
i=1:do while not rs.EOF and i<=session("pagesize")%>
<tr bgcolor="#FFFFFF">
<td align=center height="22" nowrap>
<%
'//////////////// Add Menu List Start /////////////////////////
if status="初始" then
AddPopupMenu1 true,true,false,false,true,false,false,false,_
"newpo.asp?id=", _
"../delete.asp?poid=",_
"", _
"",_
"approve.asp?poid=",_
"",_
"",_
"menuPo"&poid
elseif status="已审核" then
AddPopupMenu1 true,true,false,true,false,false,false,false,_
"newpo.asp?id=", _
"../delete.asp?poid=",_
"", _
"relpoprint3.asp?poid=",_
"approve.asp?poid=",_
"",_
"",_
"menuPo"&poid
else
AddPopupMenu1 false,false,false,true,false,false,false,false,_
"", _
"",_
"", _
"relpoprint3.asp?poid=",_
"",_
"",_
"",_
"menuPo"&poid
end if
'/////////////// Menu List End
%>
<img src="../images/edit.gif" border="0" id="Po<%=poid%>" align=absMiddle height=16 width=16 onMouseOver="ShowMenu('Po<%=poid%>','menuPo<%=poid%>','<%=poid%>')" onMouseOut="HideMenu('menuPo<%=poid%>')"></td>
<td align=center height=18><a href="javascript:opensubwin3('podetail.asp?poid=<%=poid%>','采购<%=poid%>','toolbar=no,scrollbars=yes,location=no,status=no,menubar=no,width=600,height=400,top=150,left=160');"><%=pono%></a></td>
<td align=center><a href="javascript:opensubwin3('../account/accountdetail.asp?accountid=<%=accountid%>','客户<%=accountid%>','toolbar=no,scrollbars=yes,location=no,status=no,menubar=no,width=600,height=400,top=150,left=160');"><%=account%></a></td>
<td align=center><%if totalamount<>"" then
Response.write formatnumber(totalamount,2)
else
Response.Write 0
end if
%></td>
<td align=center><%=status%></td>
<td align=center><%=PoDate%></td>
<td align=center><%=username%></td>
<td align=center><%=approveDate%></td>
<td align=center><%=approver%></td>
</tr>
<%
i=i+1
rs.MoveNext
loop
%>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr height="50"><td>第<%=CurPage%>页 / 共<%=RS.PageCount%>页 / 记录数:<%=Rs.RecordCount%>条
</td></tr></table>
<%
rs.Close
set rs=nothing
conn.Close
set conn=nothing
set objcheck=nothing
%>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -