repairdrawform.aspx

ASP.NET 2.0 C# +MYSQL 家电维修管理系统 功能还算齐全

                &nbsp;签收日期：<asp:TextBox ID="TextBox14" runat="server" BackColor="White" Width="74px">2007-7-10</asp:TextBox>
                签收人员：<asp:TextBox ID="TextBox15" runat="server" BackColor="White" Width="87px"></asp:TextBox>&nbsp;<asp:Button
                    ID="Button1" runat="server" OnClick="Button1_Click" Text="新增" Width="70px" />
                <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="修改" Width="70px" />
                <asp:Button ID="Button4" runat="server" OnClick="Button4_Click" Text="打印" Width="70px" /><br />
                &nbsp;补充说明：<asp:TextBox ID="TextBox16" runat="server" BackColor="White" Width="471px">暂无</asp:TextBox></td>
        </tr>
        <tr>
            <td style="overflow: auto; width: 550px; height: 103px; background-color: gainsboro">
                <asp:Panel ID="Panel1" runat="server" Height="200px" ScrollBars="Auto" Width="555px">
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyServiceDBConnectionString %>"
                        SelectCommand="SELECT * FROM [客户信息]"></asp:SqlDataSource><asp:GridView ID="GridView2" 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="950px" OnRowCreated="GridView2_RowCreated" OnRowDataBound="GridView2_RowDataBound" OnRowDeleted="GridView2_RowDeleted" OnSelectedIndexChanged="GridView2_SelectedIndexChanged">
                            <FooterStyle BackColor="#C6C3C6" ForeColor="Black" />
                            <Columns>
                                <asp:CommandField ButtonType="Button" HeaderText="选择" ShowSelectButton="True" />
                                <asp:TemplateField HeaderText="删除" ShowHeader="False">
                                    <ItemTemplate>
                                        <asp:Button ID="Button1" runat="server" CausesValidation="False" CommandName="Delete"
                                            Text="删除" />
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <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="签收人员" SortExpression="签收人员" />
                                <asp:BoundField DataField="补充说明" HeaderText="补充说明" SortExpression="补充说明" />
                            </Columns>
                            <RowStyle BackColor="#DEDFDE" ForeColor="Black" />
                            <SelectedRowStyle BackColor="#9471DE" Font-Bold="True" ForeColor="White" />
                            <PagerStyle BackColor="#C6C3C6" ForeColor="Black" HorizontalAlign="Right" />
                            <HeaderStyle BackColor="Navy" Font-Bold="True" ForeColor="#E7E7FF" HorizontalAlign="Center" />
                        </asp:GridView>
                    <asp:SqlDataSource ID="SqlDataSource3" runat="server" ConnectionString="<%$ ConnectionStrings:MyServiceDBConnectionString %>"
                        DeleteCommand="DELETE FROM [签收登记] WHERE [签收编号] = @签收编号" InsertCommand="INSERT INTO [签收登记] ([维修编号], [维修费用], [零件费用], [预收费用], [补收费用], [签收日期], [签收人员], [补充说明]) VALUES (@维修编号, @维修费用, @零件费用, @预收费用, @补收费用, @签收日期, @签收人员, @补充说明)"
                        SelectCommand="SELECT * FROM [签收登记] WHERE ([维修编号] LIKE '%' + @维修编号 + '%')" UpdateCommand="UPDATE [签收登记] SET [维修编号] = @维修编号, [维修费用] = @维修费用, [零件费用] = @零件费用, [预收费用] = @预收费用, [补收费用] = @补收费用, [签收日期] = @签收日期, [签收人员] = @签收人员, [补充说明] = @补充说明 WHERE [签收编号] = @签收编号">
                        <DeleteParameters>
                            <asp:Parameter Name="签收编号" Type="Int32" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:ControlParameter ControlID="TextBox2" Name="维修编号" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox8" Name="维修费用" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox9" Name="零件费用" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox12" Name="预收费用" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox13" Name="补收费用" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox14" Name="签收日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="TextBox15" Name="签收人员" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox16" Name="补充说明" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox1" Name="签收编号" PropertyName="Text" Type="Int32" />
                        </UpdateParameters>
                        <SelectParameters>
                            <asp:ControlParameter ControlID="TextBox11" Name="维修编号" PropertyName="Text" Type="String" />
                        </SelectParameters>
                        <InsertParameters>
                            <asp:ControlParameter ControlID="TextBox2" Name="维修编号" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox8" Name="维修费用" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox9" Name="零件费用" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox12" Name="预收费用" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox13" Name="补收费用" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox14" Name="签收日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="TextBox15" Name="签收人员" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox16" Name="补充说明" PropertyName="Text" Type="String" />
                        </InsertParameters>
                    </asp:SqlDataSource>
                </asp:Panel>
            </td>
        </tr>
    </table>
</asp:Content>