houseleaseform.aspx

一个房屋中介系统的源码

<%--文件名：HouseLeaseForm.aspx--%>
<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="HouseLeaseForm.aspx.cs" Inherits="HouseManage_HouseLeaseForm" 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="89px"></asp:TextBox>
                所在城区：&nbsp;<asp:DropDownList ID="DropDownList1" runat="server" Width="80px">
                </asp:DropDownList>
                具体位置：<asp:TextBox ID="TextBox4" runat="server" Width="145px"></asp:TextBox><br />
                &nbsp;楼盘名称：<asp:TextBox ID="TextBox5" runat="server" Width="63px"></asp:TextBox>
                配套环境：<asp:TextBox ID="TextBox6" runat="server" Width="275px"></asp:TextBox>&nbsp;<asp:CheckBox
                    ID="CheckBox1" runat="server" Text="电梯" /><br />
                &nbsp;<asp:TextBox ID="TextBox8" runat="server" Width="16px"></asp:TextBox>
                房<asp:TextBox ID="TextBox9" runat="server" Width="17px"></asp:TextBox>
                厅<asp:TextBox ID="TextBox10" runat="server" Width="14px"></asp:TextBox>
                厨<asp:TextBox ID="TextBox11" runat="server" Width="12px"></asp:TextBox>
                卫<asp:TextBox ID="TextBox12" runat="server" Width="13px"></asp:TextBox>
                阳台 朝向：<asp:DropDownList ID="DropDownList2" runat="server" Width="91px">
                </asp:DropDownList>
                物业管理费(元/年)：<asp:TextBox ID="TextBox14" runat="server" Width="52px"></asp:TextBox><br />
                &nbsp;楼层类型：<asp:DropDownList ID="DropDownList3" runat="server" Width="74px">
                </asp:DropDownList>
                房屋结构：<asp:DropDownList ID="DropDownList4" runat="server" Width="71px">
                </asp:DropDownList>
                建筑面积(m2)：<asp:TextBox ID="TextBox17" runat="server" Width="25px"></asp:TextBox>
                套内面积(m2)：<asp:TextBox ID="TextBox18" runat="server" Width="23px"></asp:TextBox><br />
                &nbsp;装修情况：<asp:DropDownList ID="DropDownList5" runat="server" Width="74px">
                </asp:DropDownList>
                装修说明：<asp:TextBox ID="TextBox20" runat="server" Width="186px"></asp:TextBox>
                付租方式：<asp:DropDownList ID="DropDownList6" runat="server" Width="67px">
                    <asp:ListItem></asp:ListItem>
                    <asp:ListItem>月付</asp:ListItem>
                    <asp:ListItem>季付</asp:ListItem>
                    <asp:ListItem>年付</asp:ListItem>
                </asp:DropDownList><br />
                &nbsp;出租价格(元)：<asp:TextBox ID="TextBox22" runat="server" Width="40px"></asp:TextBox>
                押金(元)：<asp:TextBox ID="TextBox23" runat="server" Width="36px"></asp:TextBox>
                家私：<asp:TextBox ID="TextBox24" runat="server" Width="236px"></asp:TextBox><br />
                &nbsp;家电：<asp:TextBox ID="TextBox25" runat="server" Width="208px"></asp:TextBox>
                配套设施：<asp:TextBox ID="TextBox26" runat="server" Width="210px"></asp:TextBox><br />
                &nbsp;车位：<asp:TextBox ID="TextBox27" runat="server" Width="34px"></asp:TextBox>
                公钥数量：<asp:TextBox ID="TextBox28" runat="server" Width="19px"></asp:TextBox>
                私钥数量：<asp:TextBox ID="TextBox29" runat="server" Width="17px"></asp:TextBox>
                出租底价(元)：<asp:TextBox ID="TextBox30" runat="server" Width="33px"></asp:TextBox>
                付佣类别：<asp:DropDownList ID="DropDownList7" runat="server" Width="60px">
                </asp:DropDownList><br />
                &nbsp;业主姓名：<asp:TextBox ID="TextBox32" runat="server" Width="38px"></asp:TextBox>
                业主电话：<asp:TextBox ID="TextBox33" runat="server" Width="77px"></asp:TextBox>
                联系人：<asp:TextBox ID="TextBox34" runat="server" Width="57px"></asp:TextBox>
                联系电话：<asp:TextBox ID="TextBox35" runat="server" Width="77px"></asp:TextBox><br />
                &nbsp;委托方式：<asp:DropDownList ID="DropDownList8" runat="server" Width="60px">
                </asp:DropDownList>
                委托日期：<asp:TextBox ID="TextBox37" runat="server" Width="61px">2007-4-1</asp:TextBox>
                截止日期：<asp:TextBox ID="TextBox38" runat="server" Width="60px">2007-7-30</asp:TextBox>
                信息来源：<asp:DropDownList ID="DropDownList9" runat="server" Width="67px">
                </asp:DropDownList><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="房源保密" />&nbsp;
                录入人员：<asp:TextBox ID="TextBox43" runat="server" Width="73px"></asp:TextBox>
                经纪人员：<asp:DropDownList ID="DropDownList10" runat="server" Width="73px">
                </asp:DropDownList><br />
                &nbsp;当前状态：<asp:DropDownList ID="DropDownList11" runat="server" Width="60px">
                </asp:DropDownList>
                补充说明：<asp:TextBox ID="TextBox46" runat="server" Width="338px"></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="CheckBox1" Name="电梯" PropertyName="Checked" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox8" Name="房" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox9" Name="厅" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox10" Name="厨" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox11" Name="卫" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox12" Name="阳" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="DropDownList2" Name="朝向" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox14" Name="物管费" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="DropDownList3" Name="楼层类型" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="DropDownList4" Name="房屋结构" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox17" Name="建筑面积" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="TextBox18" Name="套内面积" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="DropDownList5" Name="装修级别" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox20" Name="装修说明" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList6" Name="付租方式" PropertyName="SelectedValue"
                                Type="String" />
                            <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="String" />
                            <asp:ControlParameter ControlID="TextBox25" Name="家电" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox26" Name="配套设施" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox27" Name="车位" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox28" Name="公钥数量" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox29" Name="私钥数量" PropertyName="Text" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox30" Name="出租底价" PropertyName="Text" Type="Double" />
                            <asp:ControlParameter ControlID="DropDownList7" Name="付佣类别" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox32" Name="业主姓名" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox33" Name="业主电话" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox34" Name="联系人" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="TextBox35" Name="联系电话" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList8" Name="委托方式" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="TextBox37" Name="委托日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="TextBox38" Name="截止日期" PropertyName="Text" Type="DateTime" />
                            <asp:ControlParameter ControlID="DropDownList9" Name="信息来源" PropertyName="SelectedValue"
                                Type="String" />
                            <asp:ControlParameter ControlID="CheckBox2" Name="推荐房源" PropertyName="Checked" Type="Int32" />
                            <asp:ControlParameter ControlID="CheckBox3" Name="业主保密" PropertyName="Checked" Type="Int32" />
                            <asp:ControlParameter ControlID="CheckBox4" Name="房源保密" PropertyName="Checked" Type="Int32" />
                            <asp:ControlParameter ControlID="TextBox43" Name="录入入员" PropertyName="Text" Type="String" />
                            <asp:ControlParameter ControlID="DropDownList10" Name="经纪人员" PropertyName="SelectedValue"
                                Type="String" />