📄 yaopinghuajiagetdrubmsg.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 sValue;
sValue=Request.QueryString["value"].ToString();
String []sValueSplit;
sValueSplit=sValue.Split('è');
String sConditionStr="";
int i=0;
for(i=0;i<sValueSplit.Length;i++)
{
if(sValueSplit[i]!="")
break;
}
switch(i)
{
case 0:sConditionStr=("AutoId="+sValueSplit[i]);break;
case 1:sConditionStr=("PYName='"+sValueSplit[i]+"'");break;
case 2:sConditionStr=("Name='"+sValueSplit[i]+"'");break;
}
idFocusInputIndex.Value=i.ToString();
String sNeedCount=sValueSplit[3];
//
String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
String sSql="";
sSql="select * from tb_DrugStore where "+sConditionStr;
SqlConnection OCon=new SqlConnection(sCon);
SqlCommand OCmd=new SqlCommand(sSql,OCon);
OCmd.Connection.Open();
SqlDataReader dr;
dr=OCmd.ExecuteReader();
int nRow=0;
String sDrugMsgStr="";
while(dr.Read())
{
sDrugMsgStr+=(dr["AutoId"].ToString()+"è");
sDrugMsgStr+=(dr["Name"].ToString()+"è");
sDrugMsgStr+=(dr["Unit"].ToString()+"è");
sDrugMsgStr+=(dr["Type"].ToString()+"è");
sDrugMsgStr+=(dr["BatchCode"].ToString()+"è");
sDrugMsgStr+=(dr["Price"].ToString()+"è");
sDrugMsgStr+=(sNeedCount+"é");
nRow++;
}
dr.Close();
OCon.Close();
//
idDrugMsgStr.Value=sDrugMsgStr+sValueSplit[3];
//
idAskedItemCount.Value=nRow.ToString();
//
idStoreNeedCount.Value=sValueSplit[3];
//
}
</script>
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _init()
{
var drugMsgStr=idDrugMsgStr.value;
if(idAskedItemCount.value=="0")
{
alert("没有该药品!");
_focus(idFocusInputIndex.value);
return;
}
parent.idStoreNeedCount.value=idStoreNeedCount.vlaue;
if(idAskedItemCount.value=="1")
{
//
var drugMsgStrSplit=drugMsgStr.split('é');
parent._addDrugMsgToTable(drugMsgStrSplit[0]);
}
else
{
parent._callSameDrugMsgTable(drugMsgStr);
}
/*
if(Number(idStoreCount.value)<Number(idStoreNeedCount.value))
{
alert("该药品库存量仅有"+idStoreCount.value+",请通知药房处理,输入无效!");
_focus(idFocusInputIndex.value);
return;
}
parent._addDrugMsgToTable(drugMsgStr);
*/
parent._clearDrugInput(idFocusInputIndex.value);
}
function _focus(theObjIndex)
{
switch(theObjIndex)
{
case "0":parent.idDrugId.focus();break;
case "1":parent.idDrugPyCode.focus();break;
case "2":parent.idDrugName.focus();break;
}
}
//-->
</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="_init()">
<INPUT TYPE="text" id="idStoreCount" style="display:none;" runat="server"/>
<INPUT TYPE="text" id="idStoreNeedCount" style="display:none;" runat="server"/>
<INPUT TYPE="text" id="idFocusInputIndex" style="display:none;" runat="server"/>
<INPUT TYPE="text" id="idDrugMsgStr" style="display:none;" runat="server"/>
<INPUT TYPE="text" id="idAskedItemCount" style="display:none;" runat="server"/>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -