📄 authorize.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_Doctor";
	SqlConnection OCon=new SqlConnection(sCon);
	SqlCommand OCmd=new SqlCommand(sSql,OCon);
	OCmd.Connection.Open();
	SqlDataReader dr;
	dr=OCmd.ExecuteReader();

	int nRow=0;
	String sDoctorId="";
	String sHtmlStr="";
	while(dr.Read())
	{
		sDoctorId=dr["AutoId"].ToString();
		nRow++;
		if(nRow%2==0)
			sHtmlStr+="<tr align='center' bgcolor='#ffffff'>";
		else
			sHtmlStr+="<tr align='center' bgcolor='#dddddd'>";

		sHtmlStr+="<td>"+nRow.ToString()+"</td>";
		sHtmlStr+="<td>"+dr["Name"].ToString()+"</td>";
		String sSex=dr["Sex"].ToString();
		sSex=sSex.Trim();
		if(sSex=="1")
			sHtmlStr+=("<td>男</td>");
		else
			sHtmlStr+=("<td>女</td>");
		sHtmlStr+="<td>"+dr["OfficePosition"].ToString()+"</td>";
		sHtmlStr+="<td>"+dr["OfficeDepartment"].ToString()+"</td>";
		sHtmlStr+="<td>"+dr["AutoDate"].ToString()+"</td>";
		sHtmlStr+="<td>"+dr["LoginName"].ToString()+"</td>";
		sHtmlStr+="<td>"+dr["LoginPwd"].ToString()+"</td>";
		if(dr["Authorized"].ToString()=="n")
			sHtmlStr+="<td><input type='button' style='border:1px;cursor:hand;background-color:#ff0000;color:#000000;' value='开通权限' onClick='_changeQx(this,"+sDoctorId+")'></td>";
		else
			sHtmlStr+="<td><input type='button' style='border:1px;cursor:hand;background-color:#00ff00;color:#000000;' value='禁止权限' onClick='_changeQx(this,"+sDoctorId+")'></td>";

	}
	dr.Close();
	OCon.Close();
	idContent.Value=sHtmlStr;

}
</script>

<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
body {
	background-image: url(_images/waterBack.gif);
}
input{
	border:0px;
	background-color:#ffffff;
	color:#aa0000;
}
table{
font-size:12px;}
.style3 {color: #FFFFFF}
-->
</style>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _initAuthorize()
{
	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!="1")
	{
		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;
	}

	var htmlStr="<table width='930' border='0' cellpadding='0' cellspacing='0'>";
	htmlStr+="<tr align='center' bgcolor='#333399'>     <td width='60'><span class='style3'>序号</span></td>     <td width='79' height='21'><span class='style3'>姓名</span></td>     <td width='71'><span class='style3'>性别</span></td>     <td width='128'><span class='style3'>职务</span></td>     <td width='176'><span class='style3'>所属科室</span></td>     <td width='154'><span class='style3'>注册日期</span></td>     <td width='109'><span class='style3'>登陆帐号</span></td>     <td width='82'><span class='style3'>登陆密码</span></td>     <td width='71'><span class='style3'>操作</span></td>   </tr>";
	htmlStr+=idContent.value;
	htmlStr+="</table>";
	idAuthorizeTable.innerHTML=htmlStr;
}
function _changeQx(the,doctorId)
{
	if(the.value=="开通权限")
	{
		the.style.backgroundColor="#00ff00";
		the.value="禁止权限";
		parent.idIfmHid.location="AuthorizeOne.aspx?id="+doctorId+"&value="+'y';
	}
	else
	{
		the.style.backgroundColor="#ff0000";
		the.value="开通权限";

		parent.idIfmHid.location="AuthorizeOne.aspx?id="+doctorId+"&value="+'n';
	}
}
//-->
</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="_initAuthorize()">
<INPUT TYPE="button" disabled value="清除所有被禁止医务员" onClick="parent.idIfmHid.location='DelDoctor.aspx'">
<center>
<br><span id="idAuthorizeTable"></span>
</center>
<INPUT TYPE="text" id="idContent" style="display:none;" runat="server"/>
</body>
</html>
⌨️ 快捷键说明

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