📄 yaopingruku.aspx

📁 医院进行药品进货,划价,派单等功能的系统
💻 ASPX
字号:
<%@ Page Language="C#" debug="true"%> 
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.SqlClient"%>
<script Language="c#" runat="server">
void Page_Load(Object Source, EventArgs E)
{
///
	String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
	String sSql;

	sSql="select * from tb_DrugStore";
	SqlConnection OCon=new SqlConnection(sCon);
	SqlCommand OCmd=new SqlCommand(sSql,OCon);
	OCmd.Connection.Open();
	SqlDataReader dr;
	dr=OCmd.ExecuteReader();
	if(dr.Read())
	{
		dr.Close();
		//
		sSql="select Max(AutoId) as MAXID from tb_DrugStore";
		OCmd=new SqlCommand(sSql,OCon);
		dr=OCmd.ExecuteReader();
		if(dr.Read())
		{
			idMaxAutoId.Value=dr["MAXID"].ToString();
		}
	}
	else
	{
		dr.Close();

		sSql="insert into  tb_DrugStore (StoreCount) values (0)";
		OCmd=new SqlCommand(sSql,OCon);
		OCmd.ExecuteNonQuery();

		//
		sSql="SELECT  @@IDENTITY  AS  'Identity'";
		OCmd=new SqlCommand(sSql,OCon);
		dr=OCmd.ExecuteReader();
		if(dr.Read())
		{
			idMaxAutoId.Value=dr["Identity"].ToString();
			
		}

	}
	
	dr.Close();
	OCon.Close();
}
</script>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
.style2 {
	font-size: 12pt;
	font-weight: bold;
	color: #FFFFFF;
}
body {
	background-image: url(_images/waterBack.gif);
	font-size:12px;
}
input{
	border:1px;
	background-color:#ffffff;
	color:#aa0000;
}
table{
font-size:12px;}
-->
</style>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _glTrim(para_)     //  删除字串中的所有空格符
{

//方法一

	if(para_=="")
		return "";
	
	var str="";
	for(ii=0;ii<para_.length;ii++)
	{
		if(para_.substring(ii,ii+1)==' ')
		continue;
		str+=para_.substring(ii,ii+1);
	}
	return str;


//方法二(仅删除左边的空格)
//	return para_.replace(/(^ *)/g, ""); 

}

function _bfSubmit()
{
	if(_glTrim(idFm.idName.value)=="")
	{
		alert("药品名称不能为空!");
		idFm.idName.focus();
		return false;
	}
	if(_glTrim(idFm.idPYName.value)=="")
	{
		alert("药品拼单码不能为空!");
		idFm.idPYName.focus();
		return false;
	}
	if(_glTrim(idFm.idBatch.value)=="")
	{
		alert("药品批号不能为空!");
		idFm.idBatch.focus();
		return false;
	}

	if(_glTrim(idFm.idToDate.value)=="")
	{
		alert("药品有效期不能为空!");
		idFm.idToDate.focus();
		return false;
	}
	var toDate=_glTrim(idFm.idToDate.value);
	var toDateSplit=toDate.split('-');
	if(toDateSplit.length!=3)
	{
		alert("药品有效期俄有误，请确认输入格式！药品有效期格式为:年-月-日 (如:2008-08-08)");
		idFm.idToDate.focus();
		return false;
	}	if(!(Number(toDateSplit[0])<2080&&Number(toDateSplit[0])>2000)||!(Number(toDateSplit[1])<13&&Number(toDateSplit[1])>1)||!(Number(toDateSplit[2])<32&&Number(toDateSplit[2])>1))
	{
		alert("hahahah药品有效期俄有误，请确认输入格式！药品有效期格式为:年-月-日 (如:2008-08-08)");
		idFm.idToDate.focus();
		return false;
	}
	toDateSplit[1]=toDateSplit[1].length==2?toDateSplit[1]:"0"+toDateSplit[1];
	toDateSplit[2]=toDateSplit[2].length==2?toDateSplit[2]:"0"+toDateSplit[2];
	idFm.idToDate.value=toDateSplit[0]+"-"+toDateSplit[1]+"-"+toDateSplit[2];

	if(_glTrim(idFm.idUnit.value)=="")
	{
		alert("药品单位不能为空!");
		idFm.idUnit.focus();
		return false;
	}
	if(_glTrim(idFm.idPrice.value)=="")
	{
		alert("药品单价不能为空!");
		idFm.idPrice.focus();
		return false;
	}
	if(isNaN(idFm.idPrice.value))
	{
		alert("药品单价必须是数字!");
		idFm.idPrice.focus();
		return false;
	}

	if(_glTrim(idFm.idStoreCount.value)=="")
	{
		alert("药品库存量不能为空!");
		idFm.idStoreCount.focus();
		return false;
	}
	if(isNaN(idFm.idStoreCount.value))
	{
		alert("药品库存量必须是数字!");
		idFm.idStoreCount.focus();
		return false;
	}

	return true;
}
function _clearTable()
{
//
	idFm.idModifyFlag.value="0";
	idFm.idBtnDel.disabled=true;
//
	idFm.idName.value="";
	idFm.idPYName.value="";
	idFm.idBatch.value="";
	idFm.idToDate.value="";
	idFm.idUnit.value="";
	idFm.idPrice.value="";
	idFm.idBatchPrice.value="";
	idFm.idProductAddress.value="";
	idFm.idStoreCount.value="";
//
	idFm.idDrugId.value="";
	idFm.idDrugPyCode.value="";
	idFm.idDrugName.value="";

}
function _initYaoPing()
{
	if(	parent.idOfficePosition.value=="")
	{
		document.write("<body onContextMenu='return false'  leftmargin=0 topmargin=0   ondragstart='return false' onselectstart ='return false' onselect='document.selection.empty()' oncopy='document.selection.empty()' onbeforecopy='return false'  style='background-image: url(_images/waterBack.gif);'><font size=15 color=#ff0000>还未登陆!请先登陆系统</font></body>");
		return;
	}
	if(	parent.idOfficePosition.value!="药房管理员")
	{
		document.write("<body onContextMenu='return false'  leftmargin=0 topmargin=0   ondragstart='return false' onselectstart ='return false' onselect='document.selection.empty()' oncopy='document.selection.empty()' onbeforecopy='return false'  style='background-image: url(_images/waterBack.gif);'><font size=5 color=#ff0000>对不起!你不是<font size=10 style='text-decoration:underline;'>药房管理员</font>，没有权限！</font></body>");
		return;
	}

	idFm.idModifyFlag.value="0";
	idFm.idBtnDel.disabled=true;
	idDrugCode.innerText=Number(idMaxAutoId.value)+1;
	idNewDrugCode.value=Number(idMaxAutoId.value)+1;
	//
	idFm.idName.focus();
}

function _getDrugMsg()
{
	var drugId;
	var drugPYCode;
	var drugName;
	drugId=idFm.idDrugId.value;
	drugPYCode=idFm.idDrugPyCode.value;
	drugName=idFm.idDrugName.value;

	if(drugId==""&&drugPYCode==""&&drugName=="")
	{
		alert("请输入至少一个查询条件!");
		return;
	}
	if(drugId!="")
	{
		if(isNaN(drugId))
		{
			alert("药品ID号必须是数字!");
			idFm.idDrugId.focus();
			return;
		}
	}


	var sStr=drugId+"è"+drugPYCode+"è"+drugName;
	idIfmHid.location="yaopingrukuGetDrugMsg.aspx?value="+sStr;
}

function _callShowDrugMsg(drugMsgStr)       //"AutoId""Name""PYName""Type""BatchCode""ToDate""Unit""Price""BatchPrice""ProductAddress""StoreCount""ABType"
{ 	
	idFm.idDrugId.value="";
	idFm.idDrugPyCode.value="";
	idFm.idDrugName.value="";

	var strSplit=drugMsgStr.split('è');

	idDrugCode.innerText=strSplit[0];

	idFm.idDrugIdHide.value=_glTrim(strSplit[0]);
	idFm.idName.value=_glTrim(strSplit[1]);
	idFm.idPYName.value=_glTrim(strSplit[2]);

	var typeText=_glTrim(strSplit[3]);
	var getTypeText;
	for(i=0;i<idFm.idType.options.length;i++)
	{
		getTypeText=idFm.idType.options[i].text;
		if(getTypeText==typeText)
		{
			idFm.idType.selectedIndex=i;
			break;
		}
	}

	typeText=_glTrim(strSplit[11]);
	for(i=0;i<idFm.idABType.options.length;i++)
	{
		getTypeText=idFm.idABType.options[i].text;
		if(getTypeText==typeText)
		{
			idFm.idABType.selectedIndex=i;
			break;
		}
	}

	idFm.idBatch.value=_glTrim(strSplit[4]);
	idFm.idToDate.value=_glTrim(strSplit[5]);
	idFm.idUnit.value=_glTrim(strSplit[6]);
	idFm.idPrice.value=_glTrim(strSplit[7]);
	idFm.idBatchPrice.value=_glTrim(strSplit[8]);
	idFm.idProductAddress.value=_glTrim(strSplit[9]);
	idFm.idStoreCount.value=_glTrim(strSplit[10]);


//
	idFm.idBtnDel.disabled=false;
//
	idFm.idModifyFlag.value="1";

//
	idFm.idName.focus();
}
function _onDbDeDrugItemMsg()
{
	var drugId=idFm.idDrugIdHide.value;
	idIfmHid.location="yaopingrukuDelDrugMsg.aspx?drugid="+drugId;

}
var glDrugMsgStr;
function _callSameDrugMsgTable(drugMsgStr)
{
	glDrugMsgStr=drugMsgStr;
	var sHtmlStr=" <table width='387' height='64' border='0' cellpadding='0' cellspacing='0' bgcolor='#ffffff'>";
	sHtmlStr+="<tr align='center' bgcolor='#99CCFF'><td width='138' height='26'>药品名称</td><td width='153'>类别</td><td width='133'>批号</td></tr>";
	var strSplit=drugMsgStr.split('é');
	for(i=0;i<strSplit.length-1;i++)
	{
		var subStrSplit=strSplit[i].split('è');

		sHtmlStr+=("<tr value="+i+" style='cursor:hand;' onMouseOver="+"this.style.backgroundColor='#99FF00'"+" onMouseOut="+"this.style.backgroundColor='#ffffff'"+" onClick='_showOneDetail(this)'><td>"+subStrSplit[1]+"</td>");
		sHtmlStr+=("<td>"+subStrSplit[3]+"</td>");
		sHtmlStr+=("<td>"+subStrSplit[4]+"</td>");
		sHtmlStr+=("</tr>");

	}
	sHtmlStr+="</table>";
	idSameDrugItemTable.innerHTML=sHtmlStr;
	//
	Layer1Back.style.display="block";
	Layer1.style.display="block";
}
function _showOneDetail(the)
{
	var strSplit=glDrugMsgStr.split('é');

	for(i=0;i<strSplit.length-1;i++)
	{
		if(i==the.value)
		{
			break;
		}
	}
	Layer1Back.style.display="none";
	Layer1.style.display="none";

	//
	_callShowDrugMsg(strSplit[i]);
}
function _onClearTable()
{
	idFm.idBtnDel.disabled=true;
	idDrugCode.innerText=idNewDrugCode.value;
	_clearTable();
}
function keyDown() 
{  
	if(event.keyCode==13) 
	{ 
		event.keyCode=9; 
	} 

}

//-->
</SCRIPT>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) {  //reloads the window if Nav4 resized
  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
</head>

<body onContextMenu='return false'  leftmargin=0 topmargin=0   ondragstart='return false' onselectstart ='return false' onselect='document.selection.empty()' oncopy='document.selection.empty()' onbeforecopy='return false'  onLoad="_initYaoPing();">
<div id="Layer1Back" style="display:none;position:absolute; left:375px; top:145px; width:411px; height:257px; z-index:1; background-color: #000000; layer-background-color: #009999; border: 1px none #000000;filter:alpha(opacity=50);">
</div>
<div id="Layer1" style="display:none;position:absolute; left:371px; top:140px; width:411px; height:257px; z-index:2; background-color: #009999; layer-background-color: #009999; border: 1px none #000000;">
  <div align="center"><br>
    <span class="style1">查询结果出现多个,请你点击目标药品
    </span><br>
      <br>    
<span id="idSameDrugItemTable"></span>
  </div>
</div>
<center><br>
<iframe name="idIfmHid" style="height:0px;width:0px;"></iframe>
<form id="idFm" action="yaopingrukuInsert2Db.aspx" target="idIfmHid" method="post" onSubmit="return _bfSubmit();">
<table rules="none" width="609" height="259"  border="1" cellpadding="0" cellspacing="0" bordercolor="#638AA7" bgcolor="#CAD1DF">
  <tr align="center" bgcolor="#253F96">
      <td height="32" colspan="2"><span class="style1">药品ID号：<strong><font color="#FFFF00" size="4" id="idDrugCode"></font></strong></span></td>
      <td height="32" colspan="4" align="left"><span class="style2">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;药品入库</span></td>
    </tr>
  <tr>
    <td width="102" height="33" align="right">药品名称：</td>
    <td colspan="3"><input type="text" onKeyDown="keyDown()" name="idName" style="width:250px;"></td>
    <td align="right">拼音码：</td>
    <td><input type="text" onKeyDown="keyDown()" name="idPYName" style="width:90px;"></td>
  </tr>
  <tr>
    <td height="28" align="right">药品类别：</td>
      <td width="92"><select name="idType" style="background-color:#ffffff;" onKeyDown="keyDown()">
          <option value="中成药">中成药</option>
          <option value="中草药">中草药</option>
          <option value="西药">西药</option>
        </select></td>
    <td width="63" align="right">批号：</td>
    <td width="101"><input type="text" onKeyDown="keyDown()" name="idBatch" style="width:90px;"></td>
      <td width="96" align="right">药品有效期至：</td>  <td width="141"> 
        <input type="text" onKeyDown="keyDown()" name="idToDate" style="width:90px;"></td></tr>
  <tr>
    <td height="28" align="right">药品单位：</td>
    <td><input type="text" onKeyDown="keyDown()" name="idUnit" style="width:90px;"></td>
    <td align="right">单价：</td>
    <td><input type="text" onKeyDown="keyDown()" name="idPrice" style="width:90px;"></td>
    <td align="right">批发价：</td>
    <td align="left"><input type="text" onKeyDown="keyDown()" name="idBatchPrice" style="width:90px;"></td>
  </tr>
  <tr>
    <td height="23" align="right">产地：</td>
    <td colspan="3"><input type="text" onKeyDown="keyDown()" name="idProductAddress" style="width:250px;"></td>
    <td align="right">库存量：</td>
    <td align="left"><input type="text" onKeyDown="keyDown()" name="idStoreCount" style="width:90px;"></td>
  </tr>
  <tr>
    <td height="22" align="right">药品类型：</td>
    <td><select name="idABType" style="background-color:#ffffff;" onKeyDown="keyDown()">
      <option value="A类药">A类药</option>
      <option value="B类药">B类药</option>
    </select></td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
    <td>&nbsp;</td>
  </tr>
  <tr bgcolor="#9DB7D2">
    <td height="30" colspan="6" align="right"><input type="hidden" name="idDrugIdHide"></input><input type="hidden" name="idModifyFlag"></input>
      <input type="submit" name="submit" style="cursor:hand;background-color:#990000;color:#ffff00;" value="入  库"> 
      <input type="button"  name="idBtnClear" style="cursor:hand;background-color:#990000;color:#ffff00;" value="清空/新建" onClick="_onClearTable()">&nbsp;&nbsp;<input type="button" disabled name="idBtnDel" style="cursor:hand;background-color:#990000;color:#ffff00;" value="删   除" onClick="_onDbDeDrugItemMsg()">
        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</td>
  </tr>
  <tr>
    <td height="33" align="right">药品ID号：</td>
    <td><input type="text" onKeyDown="keyDown()" name="idDrugId" style="width:90px;"></td>
    <td align="right">拼音码：</td>
    <td><input type="text" onKeyDown="keyDown()" name="idDrugPyCode" style="width:90px;"></td>
    <td align="right">药品名称：</td>
    <td><input type="text" onKeyDown="keyDown()" name="idDrugName" style="width:90px;"></td>
  </tr>
  <tr bgcolor="#9DB7D2">
    <td height="30" colspan="6" align="right"><input type="button" name="Submit2" style="cursor:hand;background-color:#990000;color:#ffff00;" value="查   询" onClick="_getDrugMsg()">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;        </td>
  </tr>
</table>  

</form>

  <table width="600" border="0">
    <tr>
      <td height="21"><font color="#FF0000">注</font>:药品有效期格式为:年-月-日 (如:2008-08-08)</td>
    </tr>
  </table>
 
</center>
<INPUT TYPE="text" id="idMaxAutoId" style="display:none;" runat="server"/>
<INPUT TYPE="text" id="idNewDrugCode" style="display:none">

</body>
</html>
⌨️ 快捷键说明

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