tj.aspx

一个简单的信息系统 系统用户管理 编辑系统用户 新增系统用户

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="tj.aspx.cs" Inherits="tj" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <br />
    <asp:Label ID="Label1" runat="server" Text="选择企业："></asp:Label>
    <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
        DataTextField="client_name" DataValueField="client_id">
    </asp:DropDownList>
    <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="统计" BorderStyle="Groove" />
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:clientmanageConnectionString %>"
        SelectCommand="SELECT [client_id], [client_name] FROM [client]"></asp:SqlDataSource>
    <br />
    <br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
        BorderColor="#336666" BorderStyle="Double" BorderWidth="3px" CellPadding="4" DataSourceID="SqlDataSource2" GridLines="Horizontal" Width="533px" AllowPaging="True" AllowSorting="True" DataKeyNames="compact_id">
        <FooterStyle BackColor="White" ForeColor="#333333" />
        <Columns>
            <asp:BoundField DataField="client_name" HeaderText="企业名称" SortExpression="client_name" />
            <asp:BoundField DataField="compact_id" HeaderText="合同编号" ReadOnly="True" SortExpression="compact_id" />
            <asp:BoundField DataField="product_name" HeaderText="产品名称" SortExpression="product_name" />
            <asp:BoundField DataField="price" HeaderText="总金额" SortExpression="price" />
            <asp:BoundField DataField="price1" HeaderText="已收金额" SortExpression="price1" />
            <asp:BoundField DataField="state" HeaderText="执行状况" SortExpression="state" />
        </Columns>
        <RowStyle BackColor="White" ForeColor="#333333" />
        <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
        <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:clientmanageConnectionString %>"
        SelectCommand="SELECT a.client_name,d.compact_id,b.product_name,d.price,c.price,d.state FROM client a,product b,sell c,compact d WHERE a.client_id=@client_id and d.client_id=a.client_id and c.compact_id=d.compact_id and b.product_id=c.product_id">
        <SelectParameters>
            <asp:ControlParameter ControlID="DropDownList1" Name="client_id" PropertyName="SelectedValue" />
        </SelectParameters>
    </asp:SqlDataSource>
    &nbsp;&nbsp;
</asp:Content>