📄 sales_in_compiles.asp
字号:
<!--#include file="conn.asp"-->
<!--#include file="top.asp"-->
<!--#include file="checkuser.asp"-->
<head>
<style type="text/css">
<!--
.select {
color: #FFFFFF;
background-color: #08246b;
}
.offline {
filter: Gray;
}
-->
</style>
<title>∷企业生产管理信息系统∷</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="css/main.css" rel="stylesheet" type="text/css">
<SCRIPT language=JavaScript src="css/User_Info_Modify.js"></SCRIPT>
</head>
<body >
<TABLE width=800 align=center border="1" cellspacing="0" cellpadding="0" bordercolor="#0055E6">
<tr><td align="center">
<%if request("action")<>"search" then%>
<table width="800" border="0" cellpadding="0" cellspacing="0" >
<tr >
<td height=26 background="images/background.gif">
<b><font color="#ffffff">详 细 运 输 信 息 查 询</font></b>
</td>
</tr>
</table>
<table width="800" border="0" cellpadding="0" cellspacing="0" bordercolor="#D4D0C8">
<form name="powersearch" method="post" action="sales_In_Compiles.asp?action=search" >
<tr>
<td width="20%"><input type="checkbox" name="SeachModel" value=1>按车号</td><td width="30%">
<input name="chehao" type="text" size="20">
</td>
<td width="20%"><input type="checkbox" name="SeachModel" value=2>按产品</td>
<td width="30%">
<select name="chanpin" size="1" style='width:100'>
<% if isedit then%><option ><%=rs("chanpin")%></option><%end if%>
<%
set rs3=server.createobject("adodb.recordset")
rs3.open "select * from dengji",conn,1,1
if not rs3.eof then
do while not rs3.eof
%>
<option <% if isedit then
if trim(rs3("dengjiname"))=trim(rs("chanpin")) then
%> selected="selected"<%end if%><%end if%>><%=rs3("dengjiname")%></option>
<%
rs3.movenext
loop
end if
rs3.close
set rs3=nothing
%>
</select>
</td>
</tr>
<tr><td height="30" >
<input type="checkbox" name="SeachModel" value=3>按包装</td>
<td><select name="baozhuang" size="1" style='width:100'>
<% if isedit then%><option ><%=rs("baozhuang")%></option><%end if%>
<%
set rs3=server.createobject("adodb.recordset")
rs3.open "select * from packing",conn,1,1
if not rs3.eof then
do while not rs3.eof
%>
<option <% if isedit then
if trim(rs3("packing"))=trim(rs("baozhuang")) then
%> selected="selected"<%end if%><%end if%>><%=rs3("packing")%></option>
<%
rs3.movenext
loop
end if
rs3.close
set rs3=nothing
%>
</select>
</td>
<td><input type="checkbox" name=SeachModel value=4>按购货单位</td>
<td><select name="yonghu" >
<%
set rs=server.createobject("adodb.recordset")
sql="select * from owner"
rs.open sql,conn,1,1
if not rs.eof then
do while not rs.eof
%>
<option value="<%=rs("owner_name")%>"><%=rs("owner_name")%></option>
<%
rs.movenext
loop
rs.close
set rs=nothing
end if
%>
</select>
</td>
</tr>
<tr><td height="30" ><input type="checkbox" name=SeachModel value=5>按销售日期</td><td ><INPUT name="uptime" onFocus="show_cele_date(uptime,'','',uptime)" value="<%=year(now())%>-<%=month(now())%>-<%=day(now())%>" size="8"> 到 <INPUT name="uptime1" onFocus="show_cele_date(uptime1,'','',uptime1)" value="<%=year(now())%>-<%=month(now())%>-<%=day(now())%>" size="8"></td><td height="30" ><input type="checkbox" name=SeachModel value=6>按卸货日期</td><td ><INPUT name="daka" onFocus="show_cele_date(daka,'','',daka)" value="<%=year(now())%>-<%=month(now())%>-<%=day(now())%>" size="8"> 到 <INPUT name="daka1" onFocus="show_cele_date(daka1,'','',daka1)" value="<%=year(now())%>-<%=month(now())%>-<%=day(now())%>" size="8"></td></tr><tr><td align="center" height="30" colspan="8"><input type="submit" name="Submit" value="查询" style="font-size: 9pt; color: #000000; background-color: #EAEAF4; solid #EAEAF4" onMouseOver ="this.style.backgroundColor='#ffffff'" onMouseOut ="this.style.backgroundColor='#EAEAF4'" title="查询"></td></tr>
</form>
</table>
</td>
</tr>
</table>
<br><br>
<TABLE width=800 align=center border="1" cellspacing="0" cellpadding="0" bordercolor="#0055E6">
<tr>
<td>
<table width="800" border="0" cellpadding="0" cellspacing="0" >
<tr >
<td height=26 background="images/background.gif">
<b><font color="#ffffff">单 月 运 输 信 息 汇 总 查 询</font></b>
</td>
</tr>
</table>
<table width="800" border="0" cellpadding="0" cellspacing="0" bordercolor="#D4D0C8">
<form name="powersearch" method="post" action="sales_In_Compiles.asp?action=search" >
<tr><td height="30" width="30%" align="center"><input type="checkbox" name=SeachModel value=7>选择查询日期（1个自然月） </td><td width="30%"> <INPUT name="uptime" onFocus="show_cele_date(uptime,'','',uptime)" value="<%=year(now())%>-<%=month(now())%>-<%=day(now())%>" size="8"> 到 <INPUT name="uptime1" onFocus="show_cele_date(uptime1,'','',uptime1)" value="<%=year(now())%>-<%=month(now())%>-<%=day(now())%>" size="8"></td><td height="30" width="40%"><input type="submit" name="Submit" value="查询" style="font-size: 9pt; color: #000000; background-color: #EAEAF4; solid #EAEAF4" onMouseOver ="this.style.backgroundColor='#ffffff'" onMouseOut ="this.style.backgroundColor='#EAEAF4'" title="查询"> * 如：2006年8月则选择2006-8-1到2006-8-31</td></tr>
</form>
</table>
</td>
</tr>
</table>
<br><br>
<TABLE width=800 align=center border="1" cellspacing="0" cellpadding="0" bordercolor="#0055E6">
<tr>
<td>
<table width="800" border="0" cellpadding="0" cellspacing="0" >
<tr >
<td height=26 background="images/background.gif">
<b><font color="#ffffff">年 度 运 输 信 息 汇 总 查 询</font></b>
</td>
</tr>
</table>
<table width="800" border="0" cellpadding="0" cellspacing="0" bordercolor="#D4D0C8">
<form name="powersearch" method="post" action="sales_In_Compiles.asp?action=search" >
<tr><td height="30" width="30%" align="center"><input type="checkbox" name=SeachModel value=8>请输入查询年份 </td><td width="30%"> <INPUT name="nian" value="<%=year(now())%>" onKeyUp="value=value.replace(/[^\d\.]/g,'')" maxlength="4" size="6"> </td><td height="30" width="40%"><input type="submit" name="Submit" value="查询" style="font-size: 9pt; color: #000000; background-color: #EAEAF4; solid #EAEAF4" onMouseOver ="this.style.backgroundColor='#ffffff'" onMouseOut ="this.style.backgroundColor='#EAEAF4'" title="查询"></td></tr>
</form>
</table>
<%else%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -