clientbuyform.aspx

一个房屋中介系统的源码

<%--文件名：ClientBuyForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="ClientBuyForm.aspx.cs" Inherits="ClientManage_ClientBuyForm" 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: 2232px; font-family: 宋体; height: 16px;
                background-color: darkturquoise">
                &nbsp;请输入求购客源的编号：<asp:TextBox ID="TextBox1" runat="server" Width="161px">%%</asp:TextBox>
                <asp:Button ID="Button1" runat="server" Text="查询" Width="70px" />
                <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="新增" Width="70px" />
                <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="修改" Width="70px" />
            </td>
        </tr>
        <tr>
            <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 141px;
                background-color: palegoldenrod" valign="top">
                &nbsp;客源编号：<asp:TextBox ID="TextBox2" runat="server" Width="83px"></asp:TextBox>
                客户姓名：<asp:TextBox ID="TextBox3" runat="server" Width="43px"></asp:TextBox>
                客户性别：<asp:DropDownList ID="DropDownList1" runat="server" Width="40px">
                    <asp:ListItem>男</asp:ListItem>
                    <asp:ListItem>女</asp:ListItem>
                </asp:DropDownList>
                客户电话：<asp:TextBox ID="TextBox5" runat="server" Width="75px"></asp:TextBox><br />
                &nbsp;电子邮箱：<asp:TextBox ID="TextBox6" runat="server" Width="148px"></asp:TextBox>
                客户地址：<asp:TextBox ID="TextBox7" runat="server" Width="242px"></asp:TextBox>&nbsp;<br />
                &nbsp;邮政编码：<asp:TextBox ID="TextBox8" runat="server" Width="44px"></asp:TextBox>
                楼层类型：<asp:DropDownList ID="DropDownList2" runat="server" Width="75px">
                </asp:DropDownList>
                楼层结构：<asp:DropDownList ID="DropDownList3" runat="server" Width="72px">
                </asp:DropDownList>
                求购城区：<asp:DropDownList ID="DropDownList4" runat="server" Width="63px">
                </asp:DropDownList><br />
                &nbsp;具体位置：<asp:TextBox ID="TextBox12" runat="server" Width="108px"></asp:TextBox>
                朝向要求：<asp:DropDownList ID="DropDownList5" runat="server" Width="80px">
                </asp:DropDownList>
                配套设施：<asp:TextBox ID="TextBox14" runat="server" Width="131px">六通</asp:TextBox><br />
                &nbsp;家具家电：<asp:TextBox ID="TextBox15" runat="server" Width="165px">配套齐全</asp:TextBox>
                装修要求：<asp:DropDownList ID="DropDownList6" runat="server" Width="80px">
                </asp:DropDownList>
                产权性质：<asp:DropDownList ID="DropDownList7" runat="server" Width="80px">
                </asp:DropDownList><br />
                &nbsp;最小房间数：<asp:TextBox ID="TextBox18" runat="server" Width="17px">0</asp:TextBox>
                最大房间数：<asp:TextBox ID="TextBox19" runat="server" Width="18px">0</asp:TextBox>
                最低购价(元)：<asp:TextBox ID="TextBox20" runat="server" Width="58px">0</asp:TextBox>
                最高购价(元)：<asp:TextBox ID="TextBox21" runat="server" Width="62px">0</asp:TextBox><br />
                &nbsp;最小面积(m2)：<asp:TextBox ID="TextBox22" runat="server" Width="30px">0</asp:TextBox>
                最大面积(m2)：<asp:TextBox ID="TextBox23" runat="server" Width="30px">0</asp:TextBox>
                委托日期：<asp:TextBox ID="TextBox24" runat="server" Width="56px">2007-4-1</asp:TextBox>
                截止日期：<asp:TextBox ID="TextBox25" runat="server" Width="62px">2007-8-1</asp:TextBox><br />
                &nbsp;付佣类别：<asp:DropDownList ID="DropDownList8" runat="server" Width="80px">
                </asp:DropDownList>
                录入人员：<asp:TextBox ID="TextBox4" runat="server" Width="55px"></asp:TextBox>
                经纪人员：<asp:DropDownList ID="DropDownList9" runat="server" Width="80px">
                </asp:DropDownList>
                &nbsp;&nbsp;
                <asp:CheckBox ID="CheckBox1" runat="server" Text="客源保密" />
                <br />
                &nbsp;<asp:CheckBox ID="CheckBox2" runat="server" Text="推荐客源" />
                当前状态：<asp:DropDownList ID="DropDownList10" runat="server" Width="80px">
                </asp:DropDownList>
                补充说明：<asp:TextBox ID="TextBox9" runat="server" Width="238px"></asp:TextBox></td>
        </tr>
        <tr>
            <td style="width: 2232px; height: 50px; background-color: gainsboro">
                <asp:Panel ID="Panel1" runat="server" Height="150px" ScrollBars="Auto" Width="553px">
                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHouseDBConnectionString %>"
                        DeleteCommand="DELETE FROM [求购客户] WHERE [客源编号] = @客源编号" InsertCommand="INSERT INTO [求购客户] ([客源编号], [客户姓名], [客户性别], [客户电话], [电子邮箱], [客户地址], [邮政编码], [楼层类型], [楼层结构], [所在城区], [具体位置], [朝向要求], [配套设施], [家具家电], [装修要求], [产权性质], [最小房间数], [最大房间数], [最低购价], [最高购价], [最小面积], [最大面积], [委托日期], [截止日期], [付佣类别], [录入人员], [经纪人员], [客源保密], [推荐客源], [当前状态], [补充说明]) VALUES (@客源编号, @客户姓名, @客户性别, @客户电话, @电子邮箱, @客户地址, @邮政编码, @楼层类型, @楼层结构, @所在城区, @具体位置, @朝向要求, @配套设施, @家具家电, @装修要求, @产权性质, @最小房间数, @最大房间数, @最低购价, @最高购价, @最小面积, @最大面积, @委托日期, @截止日期, @付佣类别, @录入人员, @经纪人员, @客源保密, @推荐客源, @当前状态, @补充说明)"
                        SelectCommand="SELECT * FROM [求购客户] WHERE ([客源编号] LIKE '%' + @客源编号 + '%') AND (客源编号 NOT IN (Select 资料编号 From 租售成交 Where (资料类型='求购客源'))) AND (当前状态 = '有效')" 
                        UpdateCommand="UPDATE [求购客户] SET [客户姓名] = @客户姓名, [客户性别] = @客户性别, [客户电话] = @客户电话, [电子邮箱] = @电子邮箱, [客户地址] = @客户地址, [邮政编码] = @邮政编码, [楼层类型] = @楼层类型, [楼层结构] = @楼层结构, [所在城区] = @所在城区, [具体位置] = @具体位置, [朝向要求] = @朝向要求, [配套设施] = @配套设施, [家具家电] = @家具家电, [装修要求] = @装修要求, [产权性质] = @产权性质, [最小房间数] = @最小房间数, [最大房间数] = @最大房间数, [最低购价] = @最低购价, [最高购价] = @最高购价, [最小面积] = @最小面积, [最大面积] = @最大面积, [委托日期] = @委托日期, [截止日期] = @截止日期, [付佣类别] = @付佣类别, [录入人员] = @录入人员, [经纪人员] = @经纪人员, [客源保密] = @客源保密, [推荐客源] = @推荐客源, [当前状态] = @当前状态, [补充说明] = @补充说明 WHERE [客源编号] = @客源编号">
                        <DeleteParameters>
                            <asp:Parameter Name="客源编号" Type="String" />
                        </DeleteParameters>
                        <UpdateParameters>
                            <asp:ControlParameter ControlID="TextBox3" Name="客户姓名" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList1" Name="客户性别" PropertyName="SelectedValue"
                                Type="String" />
                            <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="String" />
                            <asp:ControlParameter ControlID="DropDownList2" Name="楼层类型" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="DropDownList3" Name="楼层结构" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="DropDownList4" Name="所在城区" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox12" Name="具体位置" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList5" 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="DropDownList6" Name="装修要求" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="DropDownList7" Name="产权性质" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox18" Name="最小房间数" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox19" Name="最大房间数" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox20" Name="最低购价" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox21" Name="最高购价" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox22" Name="最小面积" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox23" Name="最大面积" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox24" Name="委托日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="TextBox25" Name="截止日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="DropDownList8" Name="付佣类别" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox4" Name="录入人员" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList9" Name="经纪人员" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="CheckBox1" Name="客源保密" PropertyName="Checked" Type="Int32" />
                            <asp:ControlParameter ControlID="CheckBox2" Name="推荐客源" PropertyName="Checked" Type="Int32" />
                            <asp:ControlParameter ControlID="DropDownList10" Name="当前状态" PropertyName="SelectedValue"