📄 spcg.asp
字号:
<%
set conn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
set myrs=server.CreateObject("adodb.recordset")
set rec=server.CreateObject("adodb.recordset")
conn.open application("dsn")
sql="select id from tab_cgdan"
rs.open sql,conn,1,3
if not rs.eof then
sql="select max(id) as id from tab_cgdan"
myrs.open sql,conn,1,3
str=myrs("id")
cgid=cint(mid(str,7,5))+1
cgid="cg"&year(date())&cstr(cgid)
else
cgid="cg"&year(date())&"10001"
end if
session("auto")=cgid
%>
<html>
<head>
<script language="JavaScript">
function k1()
{
form1.spname.focus()
if (event.keyCode==13)
{form1.cs.focus()}
}
function k2()
{
if (form1.spname.value=="")
{alert("请输入商品名称")
spname.focus()
form1.cs.value=""
return false
}
if (event.keyCode==13)
{form1.gg.focus()}
}
function k3()
{
if (form1.cs.value=="")
{alert("请输入厂商名称")
form1.cs.focus()
form1.gg.value=""
return false
}
if (event.keyCode==13)
{form1.bz.focus()}
}
function k4()
{
if (form1.gg.value=="")
{alert("请输入商品规格")
form1.gg.focus()
form1.bz.value=""
return false
}
if (event.keyCode==13)
{form1.dw.focus()}
}
function k5()
{
if (form1.bz.value=="")
{alert("请输入商品包装")
form1.bz.focus()
form1.dw.value=""
return false
}
if (event.keyCode==13)
{form1.dj.focus()
form1.dj.select()
}
}
function k6()
{
if (event.keyCode==13)
{form1.sl.focus()
form1.sl.select()}
if (form1.dj.value==0 && form1.dj.value=="")
{ alert("请输入单价！");form1.dj.focus();form1.dj.select();return;}
str=form1.dj.value;
if(isNaN(str))
{alert("您输入的不是有效值（请输入0-9之间的数）！");form1.dj.focus();form1.dj.select();return;}
}
function k7()
{
if (event.keyCode==13)
{form1.je.focus()}
if (form1.sl.value==0 && form1.sl.value=="")
{ alert("请输入数量！");form1.sl.focus();form1.sl.select();return;}
str=form1.sl.value;
if(isNaN(str))
{alert("您输入的不是有效值（请输入0-9之间的数）！");form1.sl.focus();form1.sl.select();return;}
}
function k8()
{
form1.je.value=form1.sl.value*form1.dj.value
form1.memo.focus()
}
function k9()
{
if (event.keyCode==13)
{send()}
}
function send()
{
form1.submit()
}
</script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>商品采购录入界面</title>
<link href="../style.css" rel="stylesheet" type="text/css">
</head>
<body onLoad="k1()">
<table width="97%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolorlight="#9CA6C6" bordercolordark="#CCE3FF">
<tr valign="baseline" bgcolor="#FF9933">
<td height="18" colspan="2" nowrap class="word_white"> 当前位置：采购管理> 采购信息登记 >>></td>
</tr>
<form action="checkspcg.asp" method="post" name="form1" >
<tr bgcolor="#CCE3FF">
<td width="20%" height="27" align="center" nowrap>采购单号：</td>
<td width="355"> <font color="#0099FF"> <%=session("auto")%></font>
<input type="hidden" name="id" value="<%=session("auto")%>">
</td>
</tr>
<tr valign="baseline" bgcolor="#CCE3FF">
<td height="27" align="center" nowarp>商品名称：</td>
<td> <input type="text" name="spname" value="" size="70" onkeyup="k1()">
<font color="#FF0000">*</font> </td>
</tr>
<tr valign="baseline" bgcolor="#CCE3FF">
<td height="27" align="center" nowrap>厂 商：</td>
<td> <input type="text" name="cs" value="" size="70" onkeyup="k2()" >
<font color="#FF0000">*</font> </td>
</tr>
<tr valign="baseline" bgcolor="#CCE3FF">
<td height="27" align="center" nowrap>规 格：</td>
<td> <input type="text" name="gg" value="" size="50" onkeyup="k3()">
<font color="#FF0000"> *</font> </td>
</tr>
<tr valign="baseline" bgcolor="#CCE3FF">
<td height="27" align="center" nowrap>包 装：</td>
<td> <input type="text" name="bz" value="" size="70" onkeyup="k4()">
<font color="#FF0000">*</font></td>
</tr>
<tr valign="baseline" bgcolor="#CCE3FF">
<td height="27" align="center" nowrap>单 位：</td>
<td> <input type="text" name="dw" value="" onkeyup="k5()"> </td>
</tr>
<tr valign="baseline" bgcolor="#CCE3FF">
<td height="27" align="center" nowrap>单 价：</td>
<td> <font color="#00CCFF">
<input type="text" name="dj" value="0" onkeyup="k6()">
</font><font color="#FF0000"><font color="#0066FF">( 元 )</font> *</font></td>
</tr>
<tr valign="baseline" bgcolor="#CCE3FF">
<td height="27" align="center" nowrap>数 量：</td>
<td> <font color="#00CCFF">
<input type="text" name="sl" value="0" onkeyup="k7()">
</font><font color="#FF0000">*</font></td>
</tr>
<tr valign="baseline" bgcolor="#CCE3FF">
<td height="27" align="center" nowrap>金 额：</td>
<td> <input type="text" name="je" value="0" onfocus="k8()">
<font color="#00CCFF"> </font><font color="#FF0000"><font color="#0066FF">( 元 )</font> *</font></td>
</tr>
<tr valign="baseline" bgcolor="#CCE3FF">
<td height="27" align="center" nowrap>采购日期：</td>
<td> <input type="text" name="cgdate" value="<%=date()%>" size="13">
<font color="#FF0000">*</font><font color="#0066FF">日期格式为：yyyy-mm-dd (2005-07-17)<font color="#FF0000">*</font></font></td>
</tr>
<tr valign="baseline" bgcolor="#CCE3FF">
<td height="27" align="center" nowrap>备 注：</td>
<td> <input type="text" name="memo" size="70" onkeyup="k9()"> </td>
</tr>
<tr valign="middle" bgcolor="#CCE3FF">
<td height="40" colspan="2" align="right" nowrap> <div align="center">
<input name="button" type="button" class="btn_grey" onclick="send()" value="提交">
<input name="Submit" type="reset" class="btn_grey" value="重填">
</div></td>
</tr>
</form>
</table>
<p> </p>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -