authorizeone.aspx

来自「医院进行药品进货,划价,派单等功能的系统」· ASPX 代码 · 共 35 行

ASPX
35
字号
<%@ 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 sDoctorId;
	sDoctorId=Request.QueryString["id"].ToString();
	String sValue;
	sValue=Request.QueryString["value"].ToString();
	//
	String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
	String sSql="";
	sSql="Update tb_Doctor set Authorized='"+sValue+"' where AutoId="+sDoctorId;
	SqlConnection OCon=new SqlConnection(sCon);
	SqlCommand OCmd=new SqlCommand(sSql,OCon);
	OCmd.Connection.Open();
	OCmd.ExecuteNonQuery();

	OCon.Close();
	//
}
</script>
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
<!--
//-->
</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'  >
</body>
</html>

⌨️ 快捷键说明

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