?? gaspaymentform.aspx
字號:
?<%--文件名:GasPaymentForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="GasPaymentForm.aspx.cs" Inherits="ChargeManage_GasPaymentForm" Title="當前位置:費用管理->水電氣費交納" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
<table style="width: 556px; height: 161px">
<tr>
<td align="left" style="font-size: 0.8em; width: 2180px; font-family: 宋體; height: 16px;
background-color: darkseagreen">
收據編號:<asp:TextBox ID="TextBox1" runat="server" Width="202px"></asp:TextBox>
收款日期:<asp:TextBox ID="TextBox2" runat="server" Width="62px">2006-6-1</asp:TextBox>
交款人員:<asp:TextBox ID="TextBox3" runat="server" Width="53px"></asp:TextBox><br />
收款金額:<asp:TextBox ID="TextBox4" runat="server" Width="50px" BackColor="#E0E0E0" ReadOnly="True">0</asp:TextBox>
收款形式:<asp:TextBox ID="TextBox5" runat="server" Width="65px">現金</asp:TextBox>
收款人員:<asp:TextBox ID="TextBox6" runat="server" BackColor="#E0E0E0" ReadOnly="True"
Width="56px"></asp:TextBox>
收款事由:<asp:TextBox ID="TextBox7" runat="server" Width="68px">交水電氣費</asp:TextBox><br />
補充說明:<asp:TextBox ID="TextBox8" runat="server" Width="234px">暫無</asp:TextBox> <asp:Button
ID="Button1" runat="server" Text="新增" Width="73px" OnClick="Button1_Click" />
<asp:Button ID="Button2" runat="server" Text="打印" Width="73px" OnClick="Button2_Click" />
<asp:Button ID="Button3" runat="server" Text="保存" Width="73px" OnClick="Button3_Click" /></td>
</tr>
<tr>
<td align="left" style="font-size: 0.8em; width: 2180px; font-family: 宋體; height: 16px;
background-color: lightskyblue">
請選擇需要查詢水電氣費的樓棟名稱:<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True"
DataSourceID="SqlDataSource1" DataTextField="樓棟名稱" DataValueField="樓棟名稱" Width="82px">
</asp:DropDownList>
業主姓名:<asp:DropDownList ID="DropDownList2" runat="server" DataSourceID="SqlDataSource2"
DataTextField="業主姓名" DataValueField="業主編號" Width="96px">
</asp:DropDownList> <asp:Button ID="Button4" runat="server" Text="查詢" Width="73px" /></td>
</tr>
<tr>
<td style="width: 2180px; height: 101px; background-color: cadetblue">
<asp:Panel ID="Panel1" runat="server" Height="150px" ScrollBars="Auto" Width="555px">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyCommunityDBConnectionString %>"
SelectCommand="SELECT DISTINCT * FROM [樓棟信息]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MyCommunityDBConnectionString %>"
SelectCommand="SELECT * FROM [業主信息] WHERE ([樓棟名稱] = @樓棟名稱)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="樓棟名稱" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
BorderColor="White" BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1"
DataKeyNames="自動編號" DataSourceID="SqlDataSource3" Font-Names="宋體" Font-Size="Small"
GridLines="None" Width="700px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
<FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
<Columns>
<asp:CommandField ButtonType="Button" HeaderText="選擇" ShowSelectButton="True" />
<asp:BoundField DataField="自動編號" HeaderText="自動編號" InsertVisible="False" ReadOnly="True"
SortExpression="自動編號" />
<asp:BoundField DataField="計費年份" HeaderText="計費年份" SortExpression="計費年份" />
<asp:BoundField DataField="計費月份" HeaderText="計費月份" SortExpression="計費月份" />
<asp:BoundField DataField="費用類型" HeaderText="費用類型" SortExpression="費用類型" />
<asp:BoundField DataField="表編號" HeaderText="表編號" SortExpression="表編號" />
<asp:BoundField DataField="表底數" HeaderText="表底數" SortExpression="表底數" />
<asp:BoundField DataField="表止數" HeaderText="表止數" SortExpression="表止數" />
<asp:BoundField DataField="表用量" HeaderText="表用量" ReadOnly="True" SortExpression="表用量" />
<asp:BoundField DataField="計費單價" HeaderText="計費單價" SortExpression="計費單價" />
<asp:BoundField DataField="應交金額" HeaderText="應交金額" ReadOnly="True" SortExpression="應交金額" />
</Columns>
<RowStyle BackColor="#DEDFDE" ForeColor="Black" />
<SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" HorizontalAlign="Center" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MyCommunityDBConnectionString %>"
SelectCommand="SELECT [自動編號], [計費年份], [計費月份], [費用類型], [表編號], [表底數], [表止數], [表用量], [計費單價], [應交金額] FROM [水電氣費] WHERE ([業主編號] = @業主編號) AND (費用狀態='未交費')">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList2" Name="業主編號" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</asp:Panel>
</td>
</tr>
<tr>
<td style="font-size: 10pt; width: 2180px; height: 20px; background-color: gainsboro">
費用明細構成:</td>
</tr>
<tr>
<td style="width: 2180px; height: 50px; background-color: lightsteelblue">
<asp:Panel ID="Panel2" runat="server" Height="150px" ScrollBars="Auto" Width="555px">
<asp:GridView ID="GridView2" runat="server" BackColor="White" BorderColor="White"
BorderStyle="Ridge" BorderWidth="2px" CellPadding="3" CellSpacing="1" Font-Names="宋體"
Font-Size="Small" GridLines="None">
<FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
<RowStyle BackColor="#DEDFDE" ForeColor="Black" />
<SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#E7E7FF" HorizontalAlign="Center" />
</asp:GridView>
</asp:Panel>
</td>
</tr>
</table>
</asp:Content>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -