📄 yaopinghuajia.aspx

📁 医院进行药品进货,划价,派单等功能的系统
💻 ASPX
📖 第 1 页 / 共 2 页
字号:
12 下一页
<%@ 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_Doctor where Authorized='y'";
	SqlConnection OCon=new SqlConnection(sCon);
	SqlCommand OCmd=new SqlCommand(sSql,OCon);
	OCmd.Connection.Open();
	SqlDataReader dr;
	dr=OCmd.ExecuteReader();

	int nRow=0;
	String sHtmlStr="";
	bool b=true;
	while(dr.Read())
	{
		if(b)
		{
			sHtmlStr+=(dr["AutoId"].ToString());
			b=false;
		}
		else
		{
			sHtmlStr+=("è"+dr["AutoId"].ToString());
		}
		sHtmlStr+=("è"+dr["Name"].ToString());

	}
	dr.Close();
	idHtmlStr.Value=sHtmlStr;

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

		sSql="insert into  tb_ExpenditureReg (PayFlag) values ('n')";
		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">
<!--

.style2 {
	font-size: 12pt;
	font-weight: bold;
	color: #FFFFFF;
}
body {

	background-image: url(_images/waterBack.gif);margin-top:0px;
}
table{
font-size:12px;
}
input{
	border:0px;
	background-color:#ffffff;
	color:#aa0000;
}
.style4 {color: #000066}
.style5 {font-size: 9pt}
.style6 {color: #FFFFFF; font-size: 12pt;}
.style7 {color: #FFFFFF}
.style8 {
	font-size: 16px;
	font-weight: bold;
	color: #FFFF00;
}
.style9 {
	color: #CC0000;
	font-weight: bold;
	font-size: 24px;
}
.style10 {
	color: #000000;
	font-size: 16px;
}
.style11 {font-size: 14px}

阴影{filter:progid:DXImageTransform.Microsoft.Shadow 
(Color=#333333,Direction=120,strength=5)} 
-->
</style>
<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);
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
//
var doctorId;
var makingTable=0;   // 显示表格时间,不允许删除操作:(

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 keyDown() 
{  
	if(event.keyCode==13) 
	{ 
		event.keyCode=9; 
	} 

}

function _showTotalMoney()
{
var totalMoney=Number(idWMedicine.value)+Number(idCWMedicine.value)+Number(idCMedicine.value)+Number(idMaterial.value)+Number(idDiagnosis.value)+Number(idExamine.value)+Number(idInspection.value)+Number(BWaveExamine.value)+Number(idCardiogram.value)+Number(idXRay.value)+Number(idTreatment.value)+Number(idNurse.value)+Number(idBed.value)+Number(idSurgery.value)+Number(idRegister.value)+Number(idOthers.value);
totalMoney=Math.round(totalMoney*100)/100;
idTotalMoney.innerText=totalMoney;
}

function JHshNumberText()
{
	if ( !(((window.event.keyCode >= 48) && (window.event.keyCode <= 57)) || (window.event.keyCode == 46)||(window.event.keyCode== 45)))
	{
		window.event.keyCode = 0 ;
	}

} 

function _initYaopinghuajia()
{
	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;
	}

	idHuajiaTableCode.innerText=Number(idMaxAutoId.value)+1;
	//
	var sVal=idHtmlStr.value;
	var sValSplit=sVal.split('è');

	doctorId=sValSplit[0];

//
	idDoctorId.add(new Option("--选择门诊医生--","--选择门诊医生--"));

	for(var i=0;i<sValSplit.length;i+=2)
	{
		idDoctorId.add(new Option(sValSplit[i+1],sValSplit[i])); 
	}

}
function _getDoctorId()
{
	doctorId=idDoctorId.options[idDoctorId.options.selectedIndex].value;
}

function _addDrugToTable()
{
	var drugId;
	var drugPYCode;
	var drugName;
	var drugCount;
	drugId=idDrugId.value;
	drugPYCode=idDrugPyCode.value;
	drugName=idDrugName.value;
	drugCount=idDrugCount.value;
	if(drugCount=="")
	{
		alert("药品数量不能为空!");
		idDrugCount.focus();
		return;
	}
	if(drugId==""&&drugPYCode==""&&drugName=="")
	{
		alert("请输入至少一个查询条件!");
		return;
	}
	if(drugId!="")
	{
		if(isNaN(drugId))
		{
			alert("药品ID号必须是数字!");
			idDrugId.focus();
			return;
		}
	}

	if(drugCount!="")
	{
		if(isNaN(drugCount))
		{
			alert("药品数量有误!");
			idDrugCount.focus();
			return;
		}
	}

	var sStr=drugId+"è"+drugPYCode+"è"+drugName+"è"+drugCount;
	idIfmHid.location="yaopinghuajiaGetDrubMsg.aspx?value="+sStr;
}
function _clearDrugInput(theObjIndex)
{
	idDrugId.value="";
	idDrugPyCode.value="";
	idDrugName.value="";
	idDrugCount.value="";

	switch(theObjIndex)
	{
		case "0":idDrugId.focus();break;
		case "1":idDrugPyCode.focus();break;
		case "2":idDrugName.focus();break;
	}
}

function _addDrugMsgToTable(val)     // yaopinghuajiaGetDrubMsg.aspx 处理后得到 val = AutoId+"è"+Name+"è"+Unit+"è"+Type+"è"+BatchCode+"è"+Price+"è"+数量;
{ 
	idDrugTableMsgStr.value+=(val+"é");

	var valSplit=val.split('è');
	if(Number(idStoreNeedCount.value)<Number(valSplit[6]))
	{
		alert("该药品库存量仅有"+idStoreCount.value+",请通知药房处理,输入无效!");
		_focus(idFocusInputIndex.value);
		return;
	}

	makingTable=1;
	_makeTable();

}
function _makeTable()
{
	var cDrugMoney=0;
	var wDrugMoney=0;
	var cwDrugMoney=0;

	var sTableHtmlStr="<table  border='1' cellpadding='0' cellspacing='0' bordercolor='#999999' style='border-collapse:collapse;'>";
	                                                                                               
	var str=idDrugTableMsgStr.value;

	var strSplit=str.split('é');
	for(i=0;i<strSplit.length-1;i++)
	{
		var subTotal=0;
		//
		var subStr=strSplit[i];
		var subStrSplit=subStr.split('è');
		//
		subTotal=Number(subStrSplit[5])*Number(subStrSplit[6]);
		subTotal=Math.round(subTotal*100)/100;


		var drugType=subStrSplit[3];

		drugType=_glTrim(drugType);

		if(drugType=="中草药")
		{
			cDrugMoney+=subTotal;
		}
		if(drugType=="西药")
		{
			wDrugMoney+=subTotal;
		}

		if(drugType=="中成药")
		{
			cwDrugMoney+=subTotal;
		}
		//
		sTableHtmlStr+="<tr> ";
		sTableHtmlStr+="<td width='82' align='center'>"+subStrSplit[0]+"</td>";
		sTableHtmlStr+="<td width='175'>"+subStrSplit[1]+"</td>";
		sTableHtmlStr+="<td width='90'>"+subStrSplit[2]+"</td>";
		sTableHtmlStr+="<td width='95'>"+subStrSplit[3]+"</td>";
		sTableHtmlStr+="<td width='70'>"+subStrSplit[5]+"</td>";
		sTableHtmlStr+="<td width='61'>"+subStrSplit[6]+"</td>";
		sTableHtmlStr+="<td width='75'>"+subTotal+"</td>";
		sTableHtmlStr+="<td width='70'><input type='button' value='删除' style='cursor:hand;' onClick=_delDrugItem('"+i+"')></input></td>";
		sTableHtmlStr+="</tr>";

	}
	sTableHtmlStr+="</table>";

	cDrugMoney=Math.round(cDrugMoney*100)/100;
	wDrugMoney=Math.round(wDrugMoney*100)/100;
	cwDrugMoney=Math.round(cwDrugMoney*100)/100;

	idCMedicine.value=cDrugMoney;
	idWMedicine.value=wDrugMoney;
	idCWMedicine.value=cwDrugMoney;

	idDrugTable.innerHTML=sTableHtmlStr;


	idDrugRcdCount.innerText=strSplit.length-1;

	//
	makingTable=0;
	//
	_showTotalMoney();
}

function _delDrugItem(index)
12 下一页
⌨️ 快捷键说明

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