?? buyreduceform.aspx
字號:
?<%--文件名:BuyReduceForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="BuyReduceForm.aspx.cs" Inherits="BuyManage_BuyReduceForm" 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:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
DataTextField="客戶名稱" DataValueField="客戶名稱" Width="149px" AutoPostBack="True">
</asp:DropDownList>
采購入庫單號：<asp:DropDownList ID="DropDownList3" runat="server" DataSourceID="SqlDataSource2"
DataTextField="采購單號" DataValueField="采購單號" Width="122px">
</asp:DropDownList>
<asp:Button ID="Button6" runat="server" OnClick="Button1_Click" Text="查詢入庫單"
Width="101px" /><br />
采購退貨單號：<asp:TextBox ID="TextBox1" runat="server" Width="125px"></asp:TextBox>
應收金額：<asp:TextBox ID="TextBox2" runat="server" BackColor="#E0E0E0" ReadOnly="True"
Width="73px">0</asp:TextBox>
實收金額：<asp:TextBox ID="TextBox3" runat="server" Width="82px">0</asp:TextBox><br />
收款方式：<asp:DropDownList ID="DropDownList2" runat="server" Width="81px">
<asp:ListItem>現金</asp:ListItem>
<asp:ListItem>銀行卡</asp:ListItem>
<asp:ListItem>支票</asp:ListItem>
<asp:ListItem>匯票</asp:ListItem>
<asp:ListItem>轉賬</asp:ListItem>
<asp:ListItem>其他</asp:ListItem>
</asp:DropDownList>
經辦人員：<asp:TextBox ID="TextBox4" runat="server" Width="115px">王彬</asp:TextBox>
出庫日期：<asp:TextBox ID="TextBox5" runat="server" Width="117px">2007-1-1</asp:TextBox><br />
補充說明：<asp:TextBox ID="TextBox6" runat="server" Width="470px">這是一張退貨單</asp:TextBox></td>
</tr>
<tr>
<td align="center" style="font-size: 0.8em; width: 2180px; font-family: 宋體; height: 16px;
background-color: darkturquoise">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MySaleDBConnectionString %>"
SelectCommand="SELECT DISTINCT * FROM [供應客戶]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:MySaleDBConnectionString %>"
SelectCommand="SELECT * FROM [采購信息] WHERE ([客戶名稱] = @客戶名稱)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="客戶名稱" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="新增退貨單"
Width="120px" /> <asp:Button ID="Button2" runat="server" OnClick="Button2_Click"
Text="打印退貨單" Width="120px" /> <asp:Button ID="Button3" runat="server" OnClick="Button3_Click"
Text="保存退貨單" Width="120px" />
</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="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MySaleDBConnectionString %>"
SelectCommand="SELECT [商品編號], [商品名稱], [規格型號], [計量單位], [商品單價], [采購數量], [采購金額], [生產日期], [補充說明] FROM [采購明細] WHERE ([采購單號] = @采購單號)">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList3" Name="采購單號" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
</asp:SqlDataSource>
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource3"
Font-Names="宋體" Font-Size="Small" GridLines="Vertical" Width="1200px" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<Columns>
<asp:CommandField ButtonType="Button" HeaderText="選擇" ShowSelectButton="True" />
<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="采購金額" SortExpression="采購金額" />
<asp:BoundField DataField="生產日期" HeaderText="生產日期" SortExpression="生產日期" />
<asp:BoundField DataField="補充說明" HeaderText="補充說明" SortExpression="補充說明" />
</Columns>
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
</asp:Panel>
</td>
</tr>
<tr>
商品編號：<asp:TextBox ID="TextBox7" runat="server" BackColor="#E0E0E0" ReadOnly="True"
Width="73px">0</asp:TextBox> 商品名稱：<asp:TextBox ID="TextBox8" runat="server"
BackColor="#E0E0E0" ReadOnly="True" Width="172px">0</asp:TextBox>
規格型號：
<asp:TextBox ID="TextBox9" runat="server" BackColor="#E0E0E0" ReadOnly="True" Width="65px">0</asp:TextBox><br />
計量單位：
<asp:TextBox ID="TextBox10" runat="server" BackColor="#E0E0E0" ReadOnly="True" Width="35px">0</asp:TextBox>
退貨單價：<asp:TextBox ID="TextBox11" runat="server" BackColor="White" Width="55px">0</asp:TextBox>
退貨數量：<asp:TextBox ID="TextBox12" runat="server" BackColor="White" OnTextChanged="TextBox12_TextChanged"
Width="57px">0</asp:TextBox>
退貨金額：<asp:TextBox ID="TextBox13" runat="server" BackColor="#E0E0E0" ReadOnly="True"
Width="83px"></asp:TextBox> <br />
補充說明：
<asp:TextBox ID="TextBox15" runat="server" BackColor="White" Width="252px">這是退貨商品</asp:TextBox>
<asp:Button ID="Button4" runat="server" Text="計算金額" Width="100px" />
<asp:Button ID="Button5" runat="server" OnClick="Button5_Click" Text="新增商品" Width="100px" /></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="#999999"
BorderStyle="None" BorderWidth="1px" CellPadding="3" Font-Names="宋體" Font-Size="Small"
GridLines="Vertical" Width="1500px">
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
<HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
</asp:Panel>
</td>
</tr>
</table>
</asp:Content>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -