📄 query_record.aspx
字号:
<%@ Page language="c#" Codebehind="Query_Record.aspx.cs" AutoEventWireup="false" Inherits="AMSystem.browser.QuaryPart.Query_Record" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
<HEAD>
<title>Query_Record</title>
<meta name="GENERATOR" Content="Microsoft Visual Studio .NET 7.1">
<meta name="CODE_LANGUAGE" Content="C#">
<meta name="vs_defaultClientScript" content="JavaScript">
<meta name="vs_targetSchema" content="http://schemas.microsoft.com/intellisense/ie5">
<LINK href="../../css/css.css" type="text/css" rel="stylesheet">
</HEAD>
<body>
<form id="Form1" method="post" runat="server">
<TABLE id="Table1" cellSpacing="1" cellPadding="1" width="100%" border="1" borderColor="#ffffff">
<TR>
<TD class="P1" background="../../Images/bgcolor.gif" height="30">
<P align="center">记录查看</P>
</TD>
</TR>
<TR>
<TD class="P" bgColor="#e7f7ef" height="25">
<table class="P" borderColor="#ffffff" cellSpacing="0" cellPadding="0" width="100%" border="0">
<tr>
<td>
记录类型：
<asp:dropdownlist id="ddl_RecordType" runat="server">
<asp:ListItem Value="0" Selected="True">全部记录</asp:ListItem>
<asp:ListItem Value="1">使用记录</asp:ListItem>
<asp:ListItem Value="2">维修记录</asp:ListItem>
</asp:dropdownlist> 资产编码：
<asp:textbox id="txt_AssetsCode" runat="server" Width="150px"></asp:textbox>
<asp:button id="btn_choose" runat="server" Text="编辑显示项"></asp:button>
<asp:checkbox id="chbCheck" runat="server" Text="全选" AutoPostBack="True"></asp:checkbox>
<asp:button id="btn_submit" runat="server" Text="查看"></asp:button></td>
</tr>
<tr>
<td>
<asp:panel id="Panel_choose" runat="server" Runat="server" Visible="False" Width="100%">
<asp:CheckBoxList id="cblEdit" runat="server" Width="100%" RepeatDirection="Horizontal" RepeatColumns="9"
CssClass="P">
<asp:ListItem Value="db_record.record_type as 记录类型">记录类型</asp:ListItem>
<asp:ListItem Value="db_record.record_content as 记录内容">记录内容</asp:ListItem>
<asp:ListItem Value="convert(varchar(10),db_record.record_usetime,126) as 使用维修时间">使用维修时间</asp:ListItem>
<asp:ListItem Value="convert(varchar(10),db_record.record_addtime,126) as 添加时间">添加时间</asp:ListItem>
<asp:ListItem Value="db_equ.equ_Units as 所在单位">所在单位</asp:ListItem>
<asp:ListItem Value="db_equ.equ_UseDep as 大类">大类</asp:ListItem>
<asp:ListItem Value="db_equ.equ_Class as 小类">小类</asp:ListItem>
<asp:ListItem Value="db_equ.equ_UseDep as 使用部门">使用部门</asp:ListItem>
<asp:ListItem Value="db_equ.equ_AssetsCoding as 资产编号">资产编号</asp:ListItem>
<asp:ListItem Value="db_equ.equ_FinanceNum as 财务号">财务号</asp:ListItem>
<asp:ListItem Value="db_equ.equ_Name as 设备名称">设备名称</asp:ListItem>
<asp:ListItem Value="db_equ.equ_OriValue as 设备原值">设备原值</asp:ListItem>
<asp:ListItem Value="db_equ.equ_Brand as 设备品牌">设备品牌</asp:ListItem>
<asp:ListItem Value="convert(varchar(10),db_equ.equ_PurchaseTime,126) as 购置时间">购置时间</asp:ListItem>
<asp:ListItem Value="db_equ.equ_UseYears as 使用年限">使用年限</asp:ListItem>
<asp:ListItem Value="db_equ.equ_Spec as 规格型号">规格型号</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompCPU as 电脑CPU">电脑CPU</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompMemory as 电脑内存">电脑内存</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompHarddisk as 电脑硬盘">电脑硬盘</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompDisplayCard as 电脑显卡">电脑显卡</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompSoundCard as 电脑声卡">电脑声卡</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompODD as 电脑光驱">电脑光驱</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompFloppy as 电脑软驱">电脑软驱</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompDisplay as 电脑显示器">电脑显示器</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompMouse as 鼠标">鼠标</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompKeyBoard as 键盘">键盘</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompIP as 电脑IP地址">电脑IP地址</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CompMAC as 电脑MAC地址">电脑MAC地址</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarNum as 车牌号">车牌号</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarOutType as 厂牌型号及排气量">厂牌型号及排气量</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarEngineerNum as 发动机号码">发动机号码</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarDownTube as 车架号码">车架号码</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarSort as 车辆种类">车辆种类</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarPersonNum as 核定人数">核定人数</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarWeight as 核定载重">核定载重</asp:ListItem>
<asp:ListItem Value="convert(varchar(10),db_equ.equ_CarRegistDate,126) as 初次登记日期">初次登记日期</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarPrice as 新车购置价格">新车购置价格</asp:ListItem>
<asp:ListItem Value="convert(varchar(10),db_equ.equ_CarStartInsureDate,126) as 起保日期">起保日期</asp:ListItem>
<asp:ListItem Value="convert(varchar(10),db_equ.equ_CarFinalInsureDate,126) as 终保日期">终保日期</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarPurpose as 车辆用途">车辆用途</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarInsureMoney as 保费金额">保费金额</asp:ListItem>
<asp:ListItem Value="db_equ.equ_BuildingAddr as 建筑地点">建筑地点</asp:ListItem>
<asp:ListItem Value="db_equ.equ_BuildingSquare as 建筑面积">建筑面积</asp:ListItem>
<asp:ListItem Value="convert(varchar(10),db_equ.equ_BuildingDate,126) as 建筑时间">建筑时间</asp:ListItem>
<asp:ListItem Value="db_equ.equ_DetailsSet as 详细配置">详细配置</asp:ListItem>
<asp:ListItem Value="db_equ.equ_AddKind as 增加方式">增加方式</asp:ListItem>
<asp:ListItem Value="db_equ.equ_UsingState as 使用情况">使用情况</asp:ListItem>
<asp:ListItem Value="db_equ.equ_CarePerson as 保管人员">保管人员</asp:ListItem>
<asp:ListItem Value="db_equ.equ_Num as 设备数量">设备数量</asp:ListItem>
<asp:ListItem Value="db_equ.equ_MesureUnit as 计数单位">计数单位</asp:ListItem>
<asp:ListItem Value="db_equ.equ_Remark as 备注">备注</asp:ListItem>
</asp:CheckBoxList>
</asp:panel></td>
</tr>
</table>
</TD>
</TR>
<TR>
<TD class="P" bgColor="#e7f7ef" height="25"><asp:button id="btn_daochu" runat="server" Text="导出数据"></asp:button></TD>
</TR>
<TR>
<TD bgColor="#e7f7ef"><asp:datagrid id="dg_Record" runat="server" Width="100%" CellPadding="3" BackColor="White" BorderWidth="1px"
BorderStyle="None" BorderColor="Navy" PageSize="15">
<FooterStyle ForeColor="#4A3C8C" BackColor="#B5C7DE"></FooterStyle>
<SelectedItemStyle Font-Bold="True" ForeColor="#F7F7F7" BackColor="#738A9C"></SelectedItemStyle>
<AlternatingItemStyle Font-Size="12px" BackColor="#F7F7F7"></AlternatingItemStyle>
<ItemStyle Font-Size="12px" ForeColor="#4A3C8C" BackColor="#E7E7FF"></ItemStyle>
<HeaderStyle Font-Size="13px" Font-Bold="True" ForeColor="#F7F7F7" BackColor="#4A3C8C"></HeaderStyle>
<PagerStyle Visible="False" HorizontalAlign="Right" ForeColor="#4A3C8C" BackColor="#E7E7FF"
Mode="NumericPages"></PagerStyle>
</asp:datagrid></TD>
</TR>
</TABLE>
<asp:Panel id="Panel1" runat="server" Visible="False">
<asp:datagrid id="DataGrid1" Runat="server"></asp:datagrid>
</asp:Panel>
</form>
</body>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -