⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 sb_search.aspx

📁 该系统采用asp+sql的实验室管理系统
💻 ASPX
字号:
<%@ Page language="c#" Inherits="Sbgl.Admin.Sb_Search" CodeFile="Sb_Search.aspx.cs" %>
<HTML>
	<HEAD>
		<title>sbzs_001</title>
		<META http-equiv="Content-Type" content="text/html; charset=gb2312">
		<meta content="Microsoft Visual Studio .NET 7.1" name="GENERATOR">
		<meta content="C#" name="CODE_LANGUAGE">
		<meta content="JavaScript" name="vs_defaultClientScript">
		<meta content="http://schemas.microsoft.com/intellisense/ie5" name="vs_targetSchema">
		<LINK href="../css/style.css" type="text/css" rel="stylesheet">
	</HEAD>
	<body topmargin="0">
		<SCRIPT language="JavaScript">
function selclass() {
	window.open('sel_zzjg.aspx','','width=250,height=200,left=360,top=250,scrollbars=yes');
}
function seltime(inputName)
{
	window.open('seltime.aspx?InputName='+inputName+'','','width=250,height=220,left=360,top=250,scrollbars=yes');  
}
		</SCRIPT>
		<form id="frmAnnounce" method="post" runat="server">
			<table width="99%" height="27" border="0" cellpadding="0" cellspacing="0">
				<tr>
					<td align="left" class="f12">你的位置:设备管理--&gt;设备查询</td>
					<td>&nbsp;</td>
				</tr>
			</table>
			<table height="64" cellSpacing="0" cellPadding="0" width="100%" border="0">
				<tr>
					<td>
						<table class="f12" height="85" cellSpacing="1" cellPadding="0" width="99%" bgColor="#2c8ed8"
							border="0">
							<tr valign="middle" bgColor="#e6f2fb">
								<td height="20" bgColor="#cce4f7" >使用部门:</td>
								<td height="20" >&nbsp;
									<asp:textbox id="Class_Name" runat="server" name="Class_Name"></asp:textbox><INPUT id="Classid" type="hidden" name="Classid" runat="server"><INPUT class="submit" onclick="selclass()" type="button" value="选择" name="Button"><INPUT type="radio" value="a.class_name" name="pxzd" <%if (sb=="a.class_name"){%>checked<%}%>></td>
								<td height="20" bgColor="#cce4f7" >设备类别:</td>
								<td height="20" ><asp:dropdownlist id="DDL_Sbzl" runat="server" AutoPostBack="True"></asp:dropdownlist><INPUT type="radio" value="b.bmnr" name="pxzd" <%if (sb=="b.bmnr"){%>checked<%}%>></td>
							</tr>
							<tr valign="middle" bgColor="#e6f2fb">
								<td width="18%" height="20" bgColor="#cce4f7" >设备种类:
								</td>
								<td width="35%" height="20" bgColor="#e6f2fb" ><FONT face="宋体"><asp:dropdownlist id="DDL_Sblb" runat="server" AutoPostBack="True" onselectedindexchanged="DDL_Sblb_SelectedIndexChanged"></asp:dropdownlist><INPUT type="radio" value="c.bmnr" name="pxzd" <%if (sb=="c.bmnr"){%>checked<%}%>><INPUT id="pxzd1" type="hidden" name="Classid" runat="server"></FONT></td>
								<td width="15%" height="20" bgColor="#cce4f7" >设备状态:</td>
								<td width="32%" height="20" ><select id="sbzt" name="sbzt" runat="server">
                                  <option value="正常" selected>正常</option>
                                  <option value="闲置">闲置</option>
                                  <option value="报废">报废</option>
                                </select>
							    <input type="radio" value="a.sbzt" name="pxzd" <%if (sb=="a.sbzt"){%>checked<%}%>></td>
							</tr>
							<tr valign="middle" bgColor="#e6f2fb">
								<td height="20" bgColor="#cce4f7">起用时间起:</td>
								<td height="20"><asp:textbox id="wxsjq" runat="server" name="wxsjq"></asp:textbox><input name="button" type="button" class="submit" onclick="seltime('wxsjq')" value="..."></td>
								<td height="20" bgColor="#cce4f7">起用时间止
								</td>
								<td height="20"><asp:textbox id="wxsjz" runat="server" name="wxsjz"></asp:textbox><input name="button2" type="button" class="submit" onclick="seltime('wxsjz')" value="..."></td>
							</tr>
							<tr bgColor="#e6f2fb">
								<td bgColor="#cce4f7" colSpan="4" height="20">
									<table height="24" cellSpacing="0" cellPadding="0" width="100%" border="0">
										<tr align="center">
											<td><asp:button class="submit" id="my_ok" runat="server" Text="查询" Width="58px" onclick="my_ok_Click"></asp:button></td>
											<td><asp:button id="Button2" runat="server" Text="导出EXCEL" CssClass="submit" onclick="Button2_Click"></asp:button></td>
											<td><asp:button class="submit" id="Button1" runat="server" Text="返回" Width="58px"></asp:button></td>
										</tr>
									</table>
								</td>
							</tr>
						</table>
					</td>
				</tr>
				<tr>
					<td align="center"><asp:label id="lblTotal" runat="server" Width="196px" CssClass="f12" Visible="False"></asp:label><asp:linkbutton id="btnFirst" runat="server" Visible="False" CommandName="Pager" CommandArgument="First"
							OnCommand="PagerButtonClick">首页</asp:linkbutton><asp:linkbutton id="btnPrev" runat="server" Visible="False" CommandName="Pager" CommandArgument="Prev"
							OnCommand="PagerButtonClick">上页</asp:linkbutton><asp:linkbutton id="btnNext" runat="server" Visible="False" CommandName="Pager" CommandArgument="Next"
							OnCommand="PagerButtonClick">下页</asp:linkbutton><asp:linkbutton id="btnLast" runat="server" Visible="False" CommandName="Pager" CommandArgument="Last"
							OnCommand="PagerButtonClick">尾页</asp:linkbutton><asp:textbox id="txtIndex" runat="server" Width="46px" Visible="False"></asp:textbox><asp:button id="btnGoto" runat="server" Text="翻页" Visible="False" Height="20px"></asp:button><asp:hyperlink id="TestA" runat="server"></asp:hyperlink></td>
				</tr>
				<tr>
					<td><asp:datagrid id="DataGrid1" runat="server" Width="98%" CssClass="f12" BorderColor="#2C8ED8" BorderStyle="Inset"
							HorizontalAlign="Justify" AllowPaging="True" AutoGenerateColumns="False" BorderWidth="1px"
							PageSize="20">
							<AlternatingItemStyle Height="25px" BackColor="#E6F2FB"></AlternatingItemStyle>
							<ItemStyle BackColor="#E6F2FB"></ItemStyle>
							<HeaderStyle HorizontalAlign="Center" Height="25px" BackColor="#87BAE0"></HeaderStyle>
							<Columns>
								<asp:HyperLinkColumn DataNavigateUrlField="id" DataNavigateUrlFormatString="sb_detail.aspx?sxh={0}" DataTextField="sn"
									HeaderText="设备型号"></asp:HyperLinkColumn>
								<asp:HyperLinkColumn DataNavigateUrlField="id" DataNavigateUrlFormatString="sb_detail.aspx?sxh={0}" DataTextField="sbzl"
									HeaderText="设备类别"></asp:HyperLinkColumn>
								<asp:HyperLinkColumn DataNavigateUrlField="id" DataNavigateUrlFormatString="sb_detail.aspx?sxh={0}" DataTextField="sblb"
									HeaderText="设备种类"></asp:HyperLinkColumn>
								<asp:BoundColumn DataField="Class_Name" HeaderText="部门名称"></asp:BoundColumn>
								<asp:BoundColumn DataField="syr" HeaderText="使用人"></asp:BoundColumn>
								<asp:BoundColumn DataField="jz" HeaderText="价值"></asp:BoundColumn>
								<asp:BoundColumn DataField="sbzt" HeaderText="设备状态"></asp:BoundColumn>
							</Columns>
							<PagerStyle Visible="False" Position="TopAndBottom"></PagerStyle>
						</asp:datagrid></td>
				</tr>
			</table>
		</form>
	</body>
</HTML>

⌨️ 快捷键说明

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