当前文件路径：HouseManage/HouseManage/HouseLeaseForm.aspx

		            
  1<%...--文件名：HouseLeaseForm.aspx--%>
  2<%...@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="HouseLeaseForm.aspx.cs" Inherits="HouseManage_HouseLeaseForm" Title="当前位置：房源管理->出租房源管理"%>
  3<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
  4    <table style="width: 556px; height: 161px">
  5        <tr>
  6            <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 16px;
  7                background-color: darkturquoise">
  8                &nbsp;请输入出租房源的编号：<asp:TextBox ID="TextBox1" runat="server" Width="84px">%%</asp:TextBox>
  9                <asp:Button ID="Button1" runat="server" Text="查询" Width="70px" />
 10                <asp:Button ID="Button2" runat="server" OnClick="Button2_Click" Text="新增" Width="70px" />
 11                <asp:Button ID="Button3" runat="server" OnClick="Button3_Click" Text="修改" Width="70px" />
 12                <asp:Button ID="Button4" runat="server" OnClick="Button4_Click" Text="打印" Width="70px" /></td>
 13        </tr>
 14        <tr>
 15            <td align="left" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 141px;
 16                background-color: palegoldenrod" valign="top">
 17                &nbsp;房源编号：<asp:TextBox ID="TextBox2" runat="server" Width="89px"></asp:TextBox>
 18                所在城区：&nbsp;<asp:DropDownList ID="DropDownList1" runat="server" Width="80px">
 19                </asp:DropDownList>
 20                具体位置：<asp:TextBox ID="TextBox4" runat="server" Width="145px"></asp:TextBox><br />
 21                &nbsp;楼盘名称：<asp:TextBox ID="TextBox5" runat="server" Width="63px"></asp:TextBox>
 22                配套环境：<asp:TextBox ID="TextBox6" runat="server" Width="275px"></asp:TextBox>&nbsp;<asp:CheckBox
 23                    ID="CheckBox1" runat="server" Text="电梯" /><br />
 24                &nbsp;<asp:TextBox ID="TextBox8" runat="server" Width="16px"></asp:TextBox>
 25                房<asp:TextBox ID="TextBox9" runat="server" Width="17px"></asp:TextBox>
 26                厅<asp:TextBox ID="TextBox10" runat="server" Width="14px"></asp:TextBox>
 27                厨<asp:TextBox ID="TextBox11" runat="server" Width="12px"></asp:TextBox>
 28                卫<asp:TextBox ID="TextBox12" runat="server" Width="13px"></asp:TextBox>
 29                阳台 朝向：<asp:DropDownList ID="DropDownList2" runat="server" Width="91px">
 30                </asp:DropDownList>
 31                物业管理费(元/年)：<asp:TextBox ID="TextBox14" runat="server" Width="52px"></asp:TextBox><br />
 32                &nbsp;楼层类型：<asp:DropDownList ID="DropDownList3" runat="server" Width="74px">
 33                </asp:DropDownList>
 34                房屋结构：<asp:DropDownList ID="DropDownList4" runat="server" Width="71px">
 35                </asp:DropDownList>
 36                建筑面积(m2)：<asp:TextBox ID="TextBox17" runat="server" Width="25px"></asp:TextBox>
 37                套内面积(m2)：<asp:TextBox ID="TextBox18" runat="server" Width="23px"></asp:TextBox><br />
 38                &nbsp;装修情况：<asp:DropDownList ID="DropDownList5" runat="server" Width="74px">
 39                </asp:DropDownList>
 40                装修说明：<asp:TextBox ID="TextBox20" runat="server" Width="186px"></asp:TextBox>
 41                付租方式：<asp:DropDownList ID="DropDownList6" runat="server" Width="67px">
 42                    <asp:ListItem></asp:ListItem>
 43                    <asp:ListItem>月付</asp:ListItem>
 44                    <asp:ListItem>季付</asp:ListItem>
 45                    <asp:ListItem>年付</asp:ListItem>
 46                </asp:DropDownList><br />
 47                &nbsp;出租价格(元)：<asp:TextBox ID="TextBox22" runat="server" Width="40px"></asp:TextBox>
 48                押金(元)：<asp:TextBox ID="TextBox23" runat="server" Width="36px"></asp:TextBox>
 49                家私：<asp:TextBox ID="TextBox24" runat="server" Width="236px"></asp:TextBox><br />
 50                &nbsp;家电：<asp:TextBox ID="TextBox25" runat="server" Width="208px"></asp:TextBox>
 51                配套设施：<asp:TextBox ID="TextBox26" runat="server" Width="210px"></asp:TextBox><br />
 52                &nbsp;车位：<asp:TextBox ID="TextBox27" runat="server" Width="34px"></asp:TextBox>
 53                公钥数量：<asp:TextBox ID="TextBox28" runat="server" Width="19px"></asp:TextBox>
 54                私钥数量：<asp:TextBox ID="TextBox29" runat="server" Width="17px"></asp:TextBox>
 55                出租底价(元)：<asp:TextBox ID="TextBox30" runat="server" Width="33px"></asp:TextBox>
 56                付佣类别：<asp:DropDownList ID="DropDownList7" runat="server" Width="60px">
 57                </asp:DropDownList><br />
 58                &nbsp;业主姓名：<asp:TextBox ID="TextBox32" runat="server" Width="38px"></asp:TextBox>
 59                业主电话：<asp:TextBox ID="TextBox33" runat="server" Width="77px"></asp:TextBox>
 60                联系人：<asp:TextBox ID="TextBox34" runat="server" Width="57px"></asp:TextBox>
 61                联系电话：<asp:TextBox ID="TextBox35" runat="server" Width="77px"></asp:TextBox><br />
 62                &nbsp;委托方式：<asp:DropDownList ID="DropDownList8" runat="server" Width="60px">
 63                </asp:DropDownList>
 64                委托日期：<asp:TextBox ID="TextBox37" runat="server" Width="61px">2007-4-1</asp:TextBox>
 65                截止日期：<asp:TextBox ID="TextBox38" runat="server" Width="60px">2007-7-30</asp:TextBox>
 66                信息来源：<asp:DropDownList ID="DropDownList9" runat="server" Width="67px">
 67                </asp:DropDownList><br />
 68                &nbsp;<asp:CheckBox ID="CheckBox2" runat="server" Text="推荐房源" />&nbsp;<asp:CheckBox
 69                    ID="CheckBox3" runat="server" Text="业主保密" />&nbsp;
 70                <asp:CheckBox ID="CheckBox4" runat="server" Text="房源保密" />&nbsp;
 71                录入人员：<asp:TextBox ID="TextBox43" runat="server" Width="73px"></asp:TextBox>
 72                经纪人员：<asp:DropDownList ID="DropDownList10" runat="server" Width="73px">
 73                </asp:DropDownList><br />
 74                &nbsp;当前状态：<asp:DropDownList ID="DropDownList11" runat="server" Width="60px">
 75                </asp:DropDownList>
 76                补充说明：<asp:TextBox ID="TextBox46" runat="server" Width="338px"></asp:TextBox>
 77            </td>
 78        </tr>
 79        <tr>
 80            <td style="width: 2232px; height: 50px; background-color: gainsboro">
 81                <asp:Panel ID="Panel1" runat="server" Height="150px" ScrollBars="Auto" Width="553px">
 82                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHouseDBConnectionString %>"
 83                        DeleteCommand="DELETE FROM [出租房源] WHERE [房源编号] = @房源编号" InsertCommand="INSERT INTO [出租房源] ([房源编号], [所在城区], [具体位置], [楼盘名称], [配套环境], [电梯], [房], [厅], [厨], [卫], [阳], [朝向], [物管费], [楼层类型], [房屋结构], [建筑面积], [套内面积], [装修级别], [装修说明], [付租方式], [出租价格], [押金], [家私], [家电], [配套设施], [车位], [公钥数量], [私钥数量], [出租底价], [付佣类别], [业主姓名], [业主电话], [联系人], [联系电话], [委托方式], [委托日期], [截止日期], [信息来源], [推荐房源], [业主保密], [房源保密], [录入入员], [经纪人员], [当前状态], [补充说明]) VALUES (@房源编号, @所在城区, @具体位置, @楼盘名称, @配套环境, @电梯, @房, @厅, @厨, @卫, @阳, @朝向, @物管费, @楼层类型, @房屋结构, @建筑面积, @套内面积, @装修级别, @装修说明, @付租方式, @出租价格, @押金, @家私, @家电, @配套设施, @车位, @公钥数量, @私钥数量, @出租底价, @付佣类别, @业主姓名, @业主电话, @联系人, @联系电话, @委托方式, @委托日期, @截止日期, @信息来源, @推荐房源, @业主保密, @房源保密, @录入入员, @经纪人员, @当前状态, @补充说明)"
 84                        SelectCommand="SELECT * FROM [出租房源] WHERE ([房源编号] LIKE '%' + @房源编号 + '%') AND (房源编号 NOT IN (Select 资料编号 From 租售成交 Where (资料类型='出租房源'))) AND (当前状态 = '有效')"
 85                        UpdateCommand="UPDATE [出租房源] SET [所在城区] = @所在城区, [具体位置] = @具体位置, [楼盘名称] = @楼盘名称, [配套环境] = @配套环境, [电梯] = @电梯, [房] = @房, [厅] = @厅, [厨] = @厨, [卫] = @卫, [阳] = @阳, [朝向] = @朝向, [物管费] = @物管费, [楼层类型] = @楼层类型, [房屋结构] = @房屋结构, [建筑面积] = @建筑面积, [套内面积] = @套内面积, [装修级别] = @装修级别, [装修说明] = @装修说明, [付租方式] = @付租方式, [出租价格] = @出租价格, [押金] = @押金, [家私] = @家私, [家电] = @家电, [配套设施] = @配套设施, [车位] = @车位, [公钥数量] = @公钥数量, [私钥数量] = @私钥数量, [出租底价] = @出租底价, [付佣类别] = @付佣类别, [业主姓名] = @业主姓名, [业主电话] = @业主电话, [联系人] = @联系人, [联系电话] = @联系电话, [委托方式] = @委托方式, [委托日期] = @委托日期, [截止日期] = @截止日期, [信息来源] = @信息来源, [推荐房源] = @推荐房源, [业主保密] = @业主保密, [房源保密] = @房源保密, [录入入员] = @录入入员, [经纪人员] = @经纪人员, [当前状态] = @当前状态, [补充说明] = @补充说明 WHERE [房源编号] = @房源编号">
 86                        <DeleteParameters>
 87                            <asp:Parameter Name="房源编号" Type="String" />
 88                        </DeleteParameters>
 89                        <UpdateParameters>
 90                            <asp:ControlParameter ControlID="DropDownList1" Name="所在城区" PropertyName="SelectedValue"
 91                                Type="String" />
 92                            <asp:ControlParameter ControlID="TextBox4" Name="具体位置" PropertyName="Text" Type="String" />
 93                            <asp:ControlParameter ControlID="TextBox5" Name="楼盘名称" PropertyName="Text" Type="String" />
 94                            <asp:ControlParameter ControlID="TextBox6" Name="配套环境" PropertyName="Text" Type="String" />
 95                            <asp:ControlParameter ControlID="CheckBox1" Name="电梯" PropertyName="Checked" Type="Int32" />
 96                            <asp:ControlParameter ControlID="TextBox8" Name="房" PropertyName="Text" Type="Int32" />
 97                            <asp:ControlParameter ControlID="TextBox9" Name="厅" PropertyName="Text" Type="Int32" />
 98                            <asp:ControlParameter ControlID="TextBox10" Name="厨" PropertyName="Text" Type="Int32" />
 99                            <asp:ControlParameter ControlID="TextBox11" Name="卫" PropertyName="Text" Type="Int32" />
100                            <asp:ControlParameter ControlID="TextBox12" Name="阳" PropertyName="Text" Type="Int32" />
101                            <asp:ControlParameter ControlID="DropDownList2" Name="朝向" PropertyName="SelectedValue"
102                                Type="String" />
103                            <asp:ControlParameter ControlID="TextBox14" Name="物管费" PropertyName="Text" Type="Double" />
104                            <asp:ControlParameter ControlID="DropDownList3" Name="楼层类型" PropertyName="SelectedValue"
105                                Type="String" />
106                            <asp:ControlParameter ControlID="DropDownList4" Name="房屋结构" PropertyName="SelectedValue"
107                                Type="String" />
108                            <asp:ControlParameter ControlID="TextBox17" Name="建筑面积" PropertyName="Text" Type="Double" />
109                            <asp:ControlParameter ControlID="TextBox18" Name="套内面积" PropertyName="Text" Type="Double" />
110                            <asp:ControlParameter ControlID="DropDownList5" Name="装修级别" PropertyName="SelectedValue"
111                                Type="String" />
112                            <asp:ControlParameter ControlID="TextBox20" Name="装修说明" PropertyName="Text" Type="String" />
113                            <asp:ControlParameter ControlID="DropDownList6" Name="付租方式" PropertyName="SelectedValue"
114                                Type="String" />
115                            <asp:ControlParameter ControlID="TextBox22" Name="出租价格" PropertyName="Text" Type="Double" />
116                            <asp:ControlParameter ControlID="TextBox23" Name="押金" PropertyName="Text" Type="Double" />
117                            <asp:ControlParameter ControlID="TextBox24" Name="家私" PropertyName="Text" Type="String" />
118                            <asp:ControlParameter ControlID="TextBox25" Name="家电" PropertyName="Text" Type="String" />
119                            <asp:ControlParameter ControlID="TextBox26" Name="配套设施" PropertyName="Text" Type="String" />
120                            <asp:ControlParameter ControlID="TextBox27" Name="车位" PropertyName="Text" Type="String" />
121                            <asp:ControlParameter ControlID="TextBox28" Name="公钥数量" PropertyName="Text" Type="Int32" />
122                            <asp:ControlParameter ControlID="TextBox29" Name="私钥数量" PropertyName="Text" Type="Int32" />
123                            <asp:ControlParameter ControlID="TextBox30" Name="出租底价" PropertyName="Text" Type="Double" />
124                            <asp:ControlParameter ControlID="DropDownList7" Name="付佣类别" PropertyName="SelectedValue"
125                                Type="String" />
126                            <asp:ControlParameter ControlID="TextBox32" Name="业主姓名" PropertyName="Text" Type="String" />
127                            <asp:ControlParameter ControlID="TextBox33" Name="业主电话" PropertyName="Text" Type="String" />
128                            <asp:ControlParameter ControlID="TextBox34" Name="联系人" PropertyName="Text" Type="String" />
129                            <asp:ControlParameter ControlID="TextBox35" Name="联系电话" PropertyName="Text" Type="String" />
130                            <asp:ControlParameter ControlID="DropDownList8" Name="委托方式" PropertyName="SelectedValue"
131                                Type="String" />
132                            <asp:ControlParameter ControlID="TextBox37" Name="委托日期" PropertyName="Text" Type="DateTime" />
133                            <asp:ControlParameter ControlID="TextBox38" Name="截止日期" PropertyName="Text" Type="DateTime" />
134                            <asp:ControlParameter ControlID="DropDownList9" Name="信息来源" PropertyName="SelectedValue"
135                                Type="String" />
136                            <asp:ControlParameter ControlID="CheckBox2" Name="推荐房源" PropertyName="Checked" Type="Int32" />
137                            <asp:ControlParameter ControlID="CheckBox3" Name="业主保密" PropertyName="Checked" Type="Int32" />
138                            <asp:ControlParameter ControlID="CheckBox4" Name="房源保密" PropertyName="Checked" Type="Int32" />
139                            <asp:ControlParameter ControlID="TextBox43" Name="录入入员" PropertyName="Text" Type="String" />
140                            <asp:ControlParameter ControlID="DropDownList10" Name="经纪人员" PropertyName="SelectedValue"
141                                Type="String" />
142                            <asp:ControlParameter ControlID="DropDownList11" Name="当前状态" PropertyName="SelectedValue"
143                                Type="String" />
144                            <asp:ControlParameter ControlID="TextBox46" Name="补充说明" PropertyName="Text" Type="String" />
145                            <asp:ControlParameter ControlID="TextBox2" Name="房源编号" PropertyName="Text" Type="String" />
146                        </UpdateParameters>
147                        <SelectParameters>
148                            <asp:ControlParameter ControlID="TextBox1" Name="房源编号" PropertyName="Text" Type="String" />
149                        </SelectParameters>
150                        <InsertParameters>
151                            <asp:ControlParameter ControlID="TextBox2" Name="房源编号" PropertyName="Text" Type="String" />
152                            <asp:ControlParameter ControlID="DropDownList1" Name="所在城区" PropertyName="SelectedValue"
153                                Type="String" />
154                            <asp:ControlParameter ControlID="TextBox4" Name="具体位置" PropertyName="Text" Type="String" />
155                            <asp:ControlParameter ControlID="TextBox5" Name="楼盘名称" PropertyName="Text" Type="String" />
156                            <asp:ControlParameter ControlID="TextBox6" Name="配套环境" PropertyName="Text" Type="String" />
157                            <asp:ControlParameter ControlID="CheckBox1" Name="电梯" PropertyName="Checked" Type="Int32" />
158                            <asp:ControlParameter ControlID="TextBox8" Name="房" PropertyName="Text" Type="Int32" />
159                            <asp:ControlParameter ControlID="TextBox9" Name="厅" PropertyName="Text" Type="Int32" />
160                            <asp:ControlParameter ControlID="TextBox10" Name="厨" PropertyName="Text" Type="Int32" />
161                            <asp:ControlParameter ControlID="TextBox11" Name="卫" PropertyName="Text" Type="Int32" />
162                            <asp:ControlParameter ControlID="TextBox12" Name="阳" PropertyName="Text" Type="Int32" />
163                            <asp:ControlParameter ControlID="DropDownList2" Name="朝向" PropertyName="SelectedValue"
164                                Type="String" />
165                            <asp:ControlParameter ControlID="TextBox14" Name="物管费" PropertyName="Text" Type="Double" />
166                            <asp:ControlParameter ControlID="DropDownList3" Name="楼层类型" PropertyName="SelectedValue"
167                                Type="String" />
168                            <asp:ControlParameter ControlID="DropDownList4" Name="房屋结构" PropertyName="SelectedValue"
169                                Type="String" />
170                            <asp:ControlParameter ControlID="TextBox17" Name="建筑面积" PropertyName="Text" Type="Double" />
171                            <asp:ControlParameter ControlID="TextBox18" Name="套内面积" PropertyName="Text" Type="Double" />
172                            <asp:ControlParameter ControlID="DropDownList5" Name="装修级别" PropertyName="SelectedValue"
173                                Type="String" />
174                            <asp:ControlParameter ControlID="TextBox20" Name="装修说明" PropertyName="Text" Type="String" />
175                            <asp:ControlParameter ControlID="DropDownList6" Name="付租方式" PropertyName="SelectedValue"
176                                Type="String" />
177                            <asp:ControlParameter ControlID="TextBox22" Name="出租价格" PropertyName="Text" Type="Double" />
178                            <asp:ControlParameter ControlID="TextBox23" Name="押金" PropertyName="Text" Type="Double" />
179                            <asp:ControlParameter ControlID="TextBox24" Name="家私" PropertyName="Text" Type="String" />
180                            <asp:ControlParameter ControlID="TextBox25" Name="家电" PropertyName="Text" Type="String" />
181                            <asp:ControlParameter ControlID="TextBox26" Name="配套设施" PropertyName="Text" Type="String" />
182                            <asp:ControlParameter ControlID="TextBox27" Name="车位" PropertyName="Text" Type="String" />
183                            <asp:ControlParameter ControlID="TextBox28" Name="公钥数量" PropertyName="Text" Type="Int32" />
184                            <asp:ControlParameter ControlID="TextBox29" Name="私钥数量" PropertyName="Text" Type="Int32" />
185                            <asp:ControlParameter ControlID="TextBox30" Name="出租底价" PropertyName="Text"