housesaleform.aspx

一个房屋中介系统的源码

<%--文件名：HouseSaleForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="HouseSaleForm.aspx.cs" Inherits="HouseManage_HouseSaleForm" 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="84px">%%</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" />
                <asp:Button ID="Button4" runat="server" OnClick="Button4_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="112px"></asp:TextBox>
                所在城区：<asp:DropDownList ID="DropDownList1" runat="server" Width="66px">
                </asp:DropDownList>
                具体位置：<asp:TextBox ID="TextBox4" runat="server" Width="141px"></asp:TextBox><br />
                &nbsp;公交线路：<asp:TextBox ID="TextBox5" runat="server" Width="108px"></asp:TextBox>
                楼盘名称：<asp:TextBox ID="TextBox6" runat="server" Width="65px"></asp:TextBox>
                配套环境：<asp:TextBox ID="TextBox7" runat="server" Width="140px"></asp:TextBox><br />
                &nbsp;所处座栋：<asp:TextBox ID="TextBox8" runat="server" Width="47px"></asp:TextBox>
                房屋编号：<asp:TextBox ID="TextBox9" runat="server" Width="156px"></asp:TextBox>
                所处楼层：<asp:TextBox ID="TextBox10" runat="server" Width="22px"></asp:TextBox>
                总层数：<asp:TextBox ID="TextBox11" runat="server" Width="23px"></asp:TextBox><br />
                &nbsp;<asp:CheckBox ID="CheckBox1" runat="server" Text="电梯" />
                <asp:TextBox ID="TextBox13" runat="server" Width="21px"></asp:TextBox>房<asp:TextBox
                    ID="TextBox14" runat="server" Width="20px"></asp:TextBox>厅<asp:TextBox ID="TextBox15"
                        runat="server" Width="20px"></asp:TextBox>厨<asp:TextBox ID="TextBox16" runat="server"
                            Width="18px"></asp:TextBox>卫<asp:TextBox ID="TextBox17" runat="server" Width="18px"></asp:TextBox>阳台
                朝向：<asp:DropDownList ID="DropDownList2" runat="server" Width="66px">
                </asp:DropDownList>
                物管费：<asp:TextBox ID="TextBox19" runat="server" Width="105px"></asp:TextBox><br />
                &nbsp;楼层类型：<asp:DropDownList ID="DropDownList3" runat="server" Width="54px">
                </asp:DropDownList>
                建成年份：<asp:TextBox ID="TextBox21" runat="server" Width="59px">2002-1-1</asp:TextBox>
                土地性质：<asp:DropDownList ID="DropDownList4" runat="server" Width="71px">
                </asp:DropDownList>
                产权性质：<asp:DropDownList ID="DropDownList5" runat="server" Width="69px">
                </asp:DropDownList><br />
                &nbsp;房屋用途：<asp:DropDownList ID="DropDownList6" runat="server" Width="69px">
                </asp:DropDownList>房屋结构：<asp:DropDownList ID="DropDownList7" runat="server" Width="71px">
                </asp:DropDownList>
                建筑面积(m2)：<asp:TextBox ID="TextBox26" runat="server" Width="33px"></asp:TextBox>
                套内面积(m2)：<asp:TextBox ID="TextBox27" runat="server" Width="25px"></asp:TextBox><br />
                &nbsp;装修程度：<asp:DropDownList ID="DropDownList8" runat="server">
                </asp:DropDownList>
                装修说明：<asp:TextBox ID="TextBox29" runat="server" Width="48px"></asp:TextBox>
                房屋说明：<asp:TextBox ID="TextBox30" runat="server" Width="204px"></asp:TextBox><br />
                &nbsp;出售价格(元)：<asp:TextBox ID="TextBox31" runat="server" Width="55px"></asp:TextBox>
                家私情况：<asp:TextBox ID="TextBox32" runat="server" Width="108px"></asp:TextBox>
                家电情况：<asp:TextBox ID="TextBox33" runat="server" Width="122px"></asp:TextBox><br />
                &nbsp;配套设施：<asp:TextBox ID="TextBox34" runat="server" Width="180px"></asp:TextBox>
                车位说明：<asp:TextBox ID="TextBox35" runat="server" Width="39px"></asp:TextBox>
                权证名称：<asp:DropDownList ID="DropDownList9" runat="server" Width="100px">
                </asp:DropDownList><br />
                &nbsp;权证编号：<asp:TextBox ID="TextBox37" runat="server" Width="123px"></asp:TextBox>
                公钥数量：<asp:TextBox ID="TextBox38" runat="server" Width="22px"></asp:TextBox>
                私钥数量：<asp:TextBox ID="TextBox39" runat="server" Width="14px"></asp:TextBox>
                出售底价(元)：<asp:TextBox ID="TextBox40" runat="server" Width="49px"></asp:TextBox><br />
                &nbsp;付款方式：<asp:DropDownList ID="DropDownList10" runat="server" Width="69px">
                </asp:DropDownList>
                货币名称：<asp:DropDownList ID="DropDownList11" runat="server" Width="71px">
                </asp:DropDownList>
                付佣类别：<asp:DropDownList ID="DropDownList12" runat="server" Width="58px">
                </asp:DropDownList>
                业主姓名：<asp:TextBox ID="TextBox44" runat="server" Width="54px"></asp:TextBox><br />
                &nbsp;业主电话：<asp:TextBox ID="TextBox45" runat="server" Width="114px"></asp:TextBox>
                联系人姓名：<asp:TextBox ID="TextBox46" runat="server" Width="64px"></asp:TextBox>
                联系人电话：<asp:TextBox ID="TextBox47" runat="server" Width="109px"></asp:TextBox><br />
                &nbsp;委托方式：<asp:DropDownList ID="DropDownList13" runat="server" Width="63px">
                </asp:DropDownList>
                委托日期：<asp:TextBox ID="TextBox49" runat="server" Width="58px">2007-1-1</asp:TextBox>
                截止日期：<asp:TextBox ID="TextBox50" runat="server" Width="63px">2007-1-31</asp:TextBox>
                信息来源：<asp:DropDownList ID="DropDownList14" runat="server" Width="62px">
                </asp:DropDownList>&nbsp;<br />
                &nbsp;<asp:CheckBox ID="CheckBox2" runat="server" Text="推荐房源" />&nbsp;<asp:CheckBox
                    ID="CheckBox3" runat="server" Text="业主保密" />&nbsp;<asp:CheckBox ID="CheckBox4" runat="server"
                        Text="房源保密" />
                录入人员：<asp:TextBox ID="TextBox55" runat="server" Width="74px"></asp:TextBox>
                经纪人员：<asp:DropDownList ID="DropDownList15" runat="server" Width="86px">
                </asp:DropDownList><br />
                &nbsp;当前状态：<asp:DropDownList ID="DropDownList16" runat="server" Width="85px">
                </asp:DropDownList>
                补充说明：<asp:TextBox ID="TextBox58" runat="server" Width="311px"></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="DropDownList1" Name="所在城区" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox4" Name="具体位置" PropertyName="Text" 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="TextBox9" Name="房号" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox10" Name="楼层" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox11" Name="总层" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="CheckBox1" Name="电梯" PropertyName="Checked" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox13" Name="房" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox14" Name="厅" PropertyName="Text" Type="Int32" />