📄 jiaofeimoneyitemshow.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 sSheetId = Request.QueryString["sheetid"].ToString();//
//
	String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
	String sSql="select *  from tb_ExpenditureReg where AutoId="+sSheetId;
	SqlConnection OCon=new SqlConnection(sCon);
	SqlCommand OCmd=new SqlCommand(sSql,OCon);
	OCmd.Connection.Open();
	SqlDataReader dr;
	dr=OCmd.ExecuteReader();

	idMoneyItemStr.Value="";
	if(dr.Read())
	{
		idMoneyItemStr.Value+=(dr["WMedicine"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["CWMedicine"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["CMedicine"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Material"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Diagnosis"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Examine"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Inspection"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["BWaveExamine"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Cardiogram"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["XRay"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Treatment"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Nurse"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Bed"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Surgery"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Register"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Others"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Deposit"].ToString()+"è");
		idMoneyItemStr.Value+=(dr["Total"].ToString()+"è");

	}
	idMoneyItemStr.Value+=sSheetId;

	dr.Close();
	OCon.Close();

	//

}
</script>
<HTML>
<HEAD>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _initJiaofeiMoneyItemShow()
{
	parent._onMoneyItemTableWndOpen(idMoneyItemStr.value);
}

//-->
</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="_initJiaofeiMoneyItemShow()">
<INPUT TYPE="text" id="idMoneyItemStr" style="display:none;" runat="server"/>
</BODY>
</HTML>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -