repairregisterform.aspx

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

                                        Text="删除" />
                                </ItemTemplate>
                            </asp:TemplateField>
                            <asp:BoundField DataField="维修编号" HeaderText="维修编号" 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="商家名称" />
                            <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="补充说明" />
                            <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="SqlDataSource4" runat="server" ConnectionString="<%$ ConnectionStrings:MyServiceDBConnectionString %>"
                        DeleteCommand="DELETE FROM [维修登记] WHERE [维修编号] = @维修编号" InsertCommand="INSERT INTO [维修登记] ([维修编号], [维修类别], [维修项目], [维修费用], [产品品牌], [产品型号], [机身号码], [购买日期], [商家名称], [商家电话], [客户名称], [客户电话], [保修情况], [故障情况], [附件信息], [预交订金], [维修方式], [补充说明], [登记日期], [登记人员]) VALUES (@维修编号, @维修类别, @维修项目, @维修费用, @产品品牌, @产品型号, @机身号码, @购买日期, @商家名称, @商家电话, @客户名称, @客户电话, @保修情况, @故障情况, @附件信息, @预交订金, @维修方式, @补充说明, @登记日期, @登记人员)"
                        SelectCommand="SELECT * FROM [维修登记] WHERE ([维修编号] LIKE '%' + @维修编号 + '%') AND (维修编号 NOT IN(SELECT 维修编号 FROM 派修登记)) AND (维修编号 NOT IN(SELECT 维修编号 FROM 完修登记))  AND (维修编号 NOT IN(SELECT 维修编号 FROM 签收登记))" UpdateCommand="UPDATE [维修登记] SET [维修类别] = @维修类别, [维修项目] = @维修项目, [维修费用] = @维修费用, [产品品牌] = @产品品牌, [产品型号] = @产品型号, [机身号码] = @机身号码, [购买日期] = @购买日期, [商家名称] = @商家名称, [商家电话] = @商家电话, [客户名称] = @客户名称, [客户电话] = @客户电话, [保修情况] = @保修情况, [故障情况] = @故障情况, [附件信息] = @附件信息, [预交订金] = @预交订金, [维修方式] = @维修方式, [补充说明] = @补充说明, [登记日期] = @登记日期, [登记人员] = @登记人员 WHERE [维修编号] = @维修编号">
                        <DeleteParameters>
                            <asp:Parameter Name="维修编号" Type="String" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:ControlParameter ControlID="TextBox2" Name="维修类别" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox3" Name="维修项目" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox4" Name="维修费用" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox5" Name="产品品牌" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox6" Name="产品型号" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox7" Name="机身号码" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox8" Name="购买日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="DropDownList1" Name="商家名称" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox10" Name="商家电话" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList2" Name="客户名称" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox12" Name="客户电话" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList3" Name="保修情况" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox14" Name="故障情况" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox15" Name="附件信息" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox16" Name="预交订金" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="DropDownList4" Name="维修方式" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox18" Name="补充说明" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox19" Name="登记日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="TextBox20" Name="登记人员" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox1" Name="维修编号" PropertyName="Text" Type="String" />
                        </UpdateParameters>
                        <SelectParameters>
                            <asp:ControlParameter ControlID="TextBox21" Name="维修编号" PropertyName="Text" Type="String" />
                        </SelectParameters>
                        <InsertParameters>
                            <asp:ControlParameter ControlID="TextBox1" Name="维修编号" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox2" Name="维修类别" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox3" Name="维修项目" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox4" Name="维修费用" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox5" Name="产品品牌" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox6" Name="产品型号" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox7" Name="机身号码" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox8" Name="购买日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="DropDownList1" Name="商家名称" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox10" Name="商家电话" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList2" Name="客户名称" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox12" Name="客户电话" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList3" Name="保修情况" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox14" Name="故障情况" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox15" Name="附件信息" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox16" Name="预交订金" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="DropDownList4" Name="维修方式" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox18" Name="补充说明" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox19" Name="登记日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="TextBox20" Name="登记人员" PropertyName="Text" Type="String" />
                        </InsertParameters>
                    </asp:SqlDataSource>
                </asp:Panel>
            </td>
        </tr>
    </table>
</asp:Content>