materialfind.aspx

来自「用Visual C#.net开发企业材料采购管理系统数据库使用的是SqlServ」· ASPX 代码 · 共 206 行 · 第 1/2 页

<%@ Page Language="c#" codebehind="MaterialFind.aspx.cs" autoeventwireup="false" Inherits="WebApplication5.MaterialFind" %>
<%@ import Namespace="System.Data.SqlClient" %>
<%@ import Namespace="System.Data" %>
<html>
<head>
    <link href="style/blue.css" type="text/css" rel="stylesheet" />
</head>
<body>
    <form runat="server">
        <center>
            <table style="WIDTH: 725px; HEIGHT: 40px" height="40" cellspacing="0" cellpadding="0" width="725" background="image/image24.bmp">
                <tbody>
                    <tr>
                        <td height="30">
                            &nbsp;&nbsp;<asp:imagebutton id="Img_save" runat="server" ImageAlign="Middle" ImageUrl="image/add.bmp"></asp:imagebutton>
                            &nbsp;&nbsp;<asp:imagebutton id="Img_search" runat="server" ImageAlign="Middle" ImageUrl="image/search.bmp"></asp:imagebutton>
                            &nbsp;&nbsp;&nbsp;
                            <asp:imagebutton id="Img_clear" runat="server" ImageAlign="Middle" ImageUrl="image/clear.bmp" CommandName="clear"></asp:imagebutton>
                            &nbsp;&nbsp;&nbsp;&nbsp;
                            <asp:imagebutton id="Img_delete" runat="server" ImageAlign="Middle" ImageUrl="image/deletex.bmp" CommandName="delete"></asp:imagebutton>
                            <asp:Label id="Label1" runat="server" visible="False">Label</asp:Label><asp:Label id="Label2" runat="server" visible="False">Label</asp:Label><asp:Label id="Label3" runat="server" visible="False">Label</asp:Label></td>
                    </tr>
                </tbody>
            </table>
            <table style="WIDTH: 725px; HEIGHT: 324px" bordercolor="#ffc080" height="344" cellspacing="0" cellpadding="0" width="664" border="1">
                <tbody>
                    <tr>
                        <td height="80">
                            <table style="WIDTH: 643px; HEIGHT: 26px">
                                <tbody>
                                    <tr>
                                        <td width="30">
                                        </td>
                                        <td width="170">
                                            查询字段:<asp:dropdownlist id="DDList1" runat="server" AutoPostBack="True" Width="103px"></asp:dropdownlist>
                                        </td>
                                        <td width="110">
                                            操作符:<asp:dropdownlist id="DDList2" runat="server" AutoPostBack="True" Width="58px"></asp:dropdownlist>
                                        </td>
                                        <td width="200">
                                            查询值:<asp:textbox id="Txt_value" runat="server" Width="143px"></asp:textbox>
                                        </td>
                                        <td>
                                            运算符:<asp:dropdownlist id="DDList3" runat="server" AutoPostBack="True" Width="58px"></asp:dropdownlist>
                                        </td>
                                    </tr>
                                </tbody>
                            </table>
                            <table style="WIDTH: 643px; HEIGHT: 26px">
                                <tbody>
                                    <tr>
                                        <td width="30">
                                        </td>
                                        <td>
                                            <font face="宋体">
                                            <asp:listbox id="ListBox1" runat="server" Width="579px"></asp:listbox>
                                            </font></td>
                                    </tr>
                                </tbody>
                            </table>
                        </td>
                    </tr>
                    <tr>
                        <td>
                            <div id="div1" style="OVERFLOW: auto; HEIGHT: 210px" align="center">
                                <asp:Panel id="Panel1" runat="server" Width="625px" Height="179px">
                                    <asp:DataGrid id="DataGrid1" runat="server" Width="610px" AutoGenerateColumns="False" CellPadding="3" BackColor="White" BorderColor="#CCCCCC" BorderWidth="1px" BorderStyle="None" ShowFooter="True">
                                        <SelectedItemStyle font-bold="True" forecolor="White" backcolor="#669999"></SelectedItemStyle>
                                        <ItemStyle forecolor="#000066" height="20"></ItemStyle>
                                        <HeaderStyle font-bold="True" height="30" forecolor="White" backcolor="#006699"></HeaderStyle>
                                        <FooterStyle forecolor="#000066" height="30" backcolor="SeaShell"></FooterStyle>
                                        <Columns>
                                            <asp:EditCommandColumn ButtonType="PushButton" UpdateText="更新" CancelText="放弃" EditText="编辑"></asp:EditCommandColumn>
                                            <asp:BoundColumn DataField="c_id" HeaderText="序号" Readonly="true"></asp:BoundColumn>
                                            <asp:TemplateColumn>
                                                <HeaderTemplate>
                                                    <b>年 </b>
                                                </HeaderTemplate>
                                                <ItemTemplate>
                                                    <asp:Label text='<%# DataBinder.Eval(Container.DataItem,"m_year") %>' width="35" runat="server" />
                                                </ItemTemplate>
                                                <EditItemTemplate>
                                                    <asp:TextBox Text='<%# DataBinder.Eval(Container.DataItem,"m_year") %>' width="35" runat="server" />
                                                </EditItemTemplate>
                                            </asp:TemplateColumn>
                                            <asp:TemplateColumn>
                                                <HeaderTemplate>
                                                    <b>月</b>
                                                </HeaderTemplate>
                                                <ItemTemplate>
                                                    <asp:Label text='<%# DataBinder.Eval(Container.DataItem,"m_month") %>' width="23" runat="server" />
                                                </ItemTemplate>
                                                <EditItemTemplate>
                                                    <asp:TextBox Text='<%# DataBinder.Eval(Container.DataItem,"m_month") %>' width="23" runat="server" />
                                                </EditItemTemplate>
                                            </asp:TemplateColumn>
                                            <asp:TemplateColumn>
                                                <HeaderTemplate>
                                                    <b>供应商</b>
                                                </HeaderTemplate>
                                                <ItemTemplate>
                                                    <asp:Label text='<%# DataBinder.Eval(Container.DataItem,"m_provider") %>' width="120" runat="server" />
                                                </ItemTemplate>