📄 jiaofeishowtable.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 sSelectedDate = Request.QueryString["date"].ToString();//
//
String sCon="server=localhost;database=_hospital;uid=sa;pwd=;Trusted_Connection=yes";
String sSql="select TBA.*,TBB.OfficeDepartment as _KS,TBC.Name as _NM from tb_ExpenditureReg as TBA,tb_Doctor as TBB,tb_Patient as TBC where CONVERT(varchar(12) , TBA.AutoDate, 112 )='"+sSelectedDate+"' and TBB.AutoId=TBA.DoctorId and TBC.AutoId=TBA.PatientId";
SqlConnection OCon=new SqlConnection(sCon);
SqlCommand OCmd=new SqlCommand(sSql,OCon);
OCmd.Connection.Open();
SqlDataReader dr;
dr=OCmd.ExecuteReader();
idStr.Value="";
while(dr.Read())
{
idStr.Value+=(dr["AutoId"].ToString()+"è"+dr["_NM"].ToString().Trim()+"è"+dr["_KS"].ToString()+"è"+dr["Total"].ToString()+"è"+dr["AutoDate"].ToString()+"è"+dr["PayFlag"].ToString()+"é");
}
dr.Close();
OCon.Close();
//
}
</script>
<HTML>
<HEAD>
<SCRIPT LANGUAGE="JavaScript">
<!--
function _initShowJiaoFeiTable()
{
parent._callShowJiaoFeiTable(idStr.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="_initShowJiaoFeiTable()">
<INPUT TYPE="text" id="idStr" style="display:none;" runat="server"/>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -