📄 finddrug.asp

📁 这是个完整的SQL SEVER与asp.net结合的医院管理系统的源代码
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<style type="text/css">
<!--
#Layer1 {
	position:absolute;
	width:631px;
	height:36px;
	z-index:1;
	left: 48px;
	top: 318px;
}
-->
</style>
<body bgcolor="#CCCCCC">
<%
on error resume next
'dim drugs_pin,drugs_no,drugs_name
drugs_pin=Request("pinyinma")
drugs_no=Request("drug-no")

drugs_name=Request("name")


set conn=server.createobject("ADODB.connection") 
conn.open="driver={sql server};server=FF-CK1W5O4NH1L9;uid=s;pwd=123;database=hospital3;"
sql="select * from drug_info where drug_no='"&drugs_no&"'"
 set rs=conn.execute(sql)
 
dan01=rs("drug_no")
dan02=rs("drug_name")
dan03=rs("drug_spec")
dan04=rs("whole_unit")
dan05=rs("sale_unit")
dan06=rs("in_price")
dan07=rs("out_price")
dan08=rs("trade_price")
dan09=rs("drug_sort")
dan010=rs("fee_sort")
dan011=rs("drug_spell")
dan012=rs("drug_pro_area")
dan013=rs("deadline")


%>

<form id="form1" action="finddrug.asp" method="post">
<p><img src="picture/Glasz3-1.jpg" alt="1" width="137" height="53" />
  <img src="picture/Glasz3-2.jpg" alt="2" width="137" height="53" /> <img src="picture/Glasz3-3.jpg" alt="3" width="137" height="53" />
  <img src="picture/Glasz3-4.jpg" alt="4" width="137" height="53" /></p>
<hr  color="#666666" size="3" />
<p> 增加条目菜单</p>

<hr  color="#666666" size="3" />
<input type="submit" name="find" value="搜索"/>
    &nbsp;&nbsp;拼音码： <input type="text" size="8" height="18" name="pinyinma" />
	 &nbsp;&nbsp;编号：  <input type="text" size="15" height="18" name="drug-no" />
 
&nbsp;&nbsp;名称：
<label>
<input type="text" name="name" height="18" size="15" />
</label>
<p><br />
  <br />
  <br />
药品目录：



</p>
<iframe src="untitled.asp" id="i" width="80%" height="200"></iframe>
<hr  color="#666666" size="3" />

<p>搜索结果：</p>

  编号：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;名称：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;规格：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;整量单位：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;散量单位：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;入库单价：&nbsp;&nbsp;&nbsp;&nbsp;<br />
<br />  <input type="text" id="dan1"size="10" height="18"  name="drug_no" value=<%=rs("drug_no")%> />&nbsp;&nbsp;&nbsp;<input type="text" id="dan2" size="10" height="18" name="name" value="<%=rs("drug_name")%>" /> &nbsp;<input type="text" id="dan3" size="8" height="18" name="spec" value="<%=dan03%>" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" id="dan4" size="8" height="18" name="whole_unit" value="<%=dan04%>" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" id="dan5" size="8" height="18" name="sale_unit" value="<%=dan05%>" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <input type="text" id="dan6" size="8" height="18" name="in_price" value="<%=dan016%>" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
<p> <br />
  <br />
   出库单价：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;批发价:&nbsp;&nbsp;&nbsp;&nbsp;分类： &nbsp; &nbsp; &nbsp; 费用归类： &nbsp; &nbsp; &nbsp; 拼音码： &nbsp; &nbsp; &nbsp; 有效期: &nbsp; &nbsp; &nbsp; <br /><br /><input type="text" id="dan7" size="8" height="18" name="out_price" value="<%=dan07%>" /> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" id="dan8" size="8" height="18" name="trade_price" value="<%=dan08%>" /> &nbsp;         
 <input type="text" id="dan9" size="10" height="18"  name="type" value="<%=dan09%>" />&nbsp;&nbsp;&nbsp;<input type="text" id="dan10" size="10" height="18"  name="fee_type" value="<%=dan010%>" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" id="dan11" size="10" height="18"  name="pinyinma" value="<%=dan011%>" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<input type="text" id="dan12" size="10" height="18"  name="deadline" value="<%=dan012%>" />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br/><br/>出产地：<br/><br/><input type="text" id="dan13" size="10" height="18"  name="address" value="<%=dan013%>" />
</p>

</form>

</body>
</html>



















































































































































.
.
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -