当前文件路径：HouseManage/HouseManage/HouseSaleForm.aspx 
1
<%...--文件名：HouseSaleForm.aspx--%>
2<%...@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="HouseSaleForm.aspx.cs" Inherits="HouseManage_HouseSaleForm" 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 请输入出售房源的编号：<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 房源编号：<asp:TextBox ID="TextBox2" runat="server" Width="112px"></asp:TextBox>
18 所在城区：<asp:DropDownList ID="DropDownList1" runat="server" Width="66px">
19 </asp:DropDownList>
20 具体位置：<asp:TextBox ID="TextBox4" runat="server" Width="141px"></asp:TextBox><br />
21 公交线路：<asp:TextBox ID="TextBox5" runat="server" Width="108px"></asp:TextBox>
22 楼盘名称：<asp:TextBox ID="TextBox6" runat="server" Width="65px"></asp:TextBox>
23 配套环境：<asp:TextBox ID="TextBox7" runat="server" Width="140px"></asp:TextBox><br />
24 所处座栋：<asp:TextBox ID="TextBox8" runat="server" Width="47px"></asp:TextBox>
25 房屋编号：<asp:TextBox ID="TextBox9" runat="server" Width="156px"></asp:TextBox>
26 所处楼层：<asp:TextBox ID="TextBox10" runat="server" Width="22px"></asp:TextBox>
27 总层数：<asp:TextBox ID="TextBox11" runat="server" Width="23px"></asp:TextBox><br />
28 <asp:CheckBox ID="CheckBox1" runat="server" Text="电梯" />
29 <asp:TextBox ID="TextBox13" runat="server" Width="21px"></asp:TextBox>房<asp:TextBox
30 ID="TextBox14" runat="server" Width="20px"></asp:TextBox>厅<asp:TextBox ID="TextBox15"
31 runat="server" Width="20px"></asp:TextBox>厨<asp:TextBox ID="TextBox16" runat="server"
32 Width="18px"></asp:TextBox>卫<asp:TextBox ID="TextBox17" runat="server" Width="18px"></asp:TextBox>阳台
33 朝向：<asp:DropDownList ID="DropDownList2" runat="server" Width="66px">
34 </asp:DropDownList>
35 物管费：<asp:TextBox ID="TextBox19" runat="server" Width="105px"></asp:TextBox><br />
36 楼层类型：<asp:DropDownList ID="DropDownList3" runat="server" Width="54px">
37 </asp:DropDownList>
38 建成年份：<asp:TextBox ID="TextBox21" runat="server" Width="59px">2002-1-1</asp:TextBox>
39 土地性质：<asp:DropDownList ID="DropDownList4" runat="server" Width="71px">
40 </asp:DropDownList>
41 产权性质：<asp:DropDownList ID="DropDownList5" runat="server" Width="69px">
42 </asp:DropDownList><br />
43 房屋用途：<asp:DropDownList ID="DropDownList6" runat="server" Width="69px">
44 </asp:DropDownList>房屋结构：<asp:DropDownList ID="DropDownList7" runat="server" Width="71px">
45 </asp:DropDownList>
46 建筑面积(m2)：<asp:TextBox ID="TextBox26" runat="server" Width="33px"></asp:TextBox>
47 套内面积(m2)：<asp:TextBox ID="TextBox27" runat="server" Width="25px"></asp:TextBox><br />
48 装修程度：<asp:DropDownList ID="DropDownList8" runat="server">
49 </asp:DropDownList>
50 装修说明：<asp:TextBox ID="TextBox29" runat="server" Width="48px"></asp:TextBox>
51 房屋说明：<asp:TextBox ID="TextBox30" runat="server" Width="204px"></asp:TextBox><br />
52 出售价格(元)：<asp:TextBox ID="TextBox31" runat="server" Width="55px"></asp:TextBox>
53 家私情况：<asp:TextBox ID="TextBox32" runat="server" Width="108px"></asp:TextBox>
54 家电情况：<asp:TextBox ID="TextBox33" runat="server" Width="122px"></asp:TextBox><br />
55 配套设施：<asp:TextBox ID="TextBox34" runat="server" Width="180px"></asp:TextBox>
56 车位说明：<asp:TextBox ID="TextBox35" runat="server" Width="39px"></asp:TextBox>
57 权证名称：<asp:DropDownList ID="DropDownList9" runat="server" Width="100px">
58 </asp:DropDownList><br />
59 权证编号：<asp:TextBox ID="TextBox37" runat="server" Width="123px"></asp:TextBox>
60 公钥数量：<asp:TextBox ID="TextBox38" runat="server" Width="22px"></asp:TextBox>
61 私钥数量：<asp:TextBox ID="TextBox39" runat="server" Width="14px"></asp:TextBox>
62 出售底价(元)：<asp:TextBox ID="TextBox40" runat="server" Width="49px"></asp:TextBox><br />
63 付款方式：<asp:DropDownList ID="DropDownList10" runat="server" Width="69px">
64 </asp:DropDownList>
65 货币名称：<asp:DropDownList ID="DropDownList11" runat="server" Width="71px">
66 </asp:DropDownList>
67 付佣类别：<asp:DropDownList ID="DropDownList12" runat="server" Width="58px">
68 </asp:DropDownList>
69 业主姓名：<asp:TextBox ID="TextBox44" runat="server" Width="54px"></asp:TextBox><br />
70 业主电话：<asp:TextBox ID="TextBox45" runat="server" Width="114px"></asp:TextBox>
71 联系人姓名：<asp:TextBox ID="TextBox46" runat="server" Width="64px"></asp:TextBox>
72 联系人电话：<asp:TextBox ID="TextBox47" runat="server" Width="109px"></asp:TextBox><br />
73 委托方式：<asp:DropDownList ID="DropDownList13" runat="server" Width="63px">
74 </asp:DropDownList>
75 委托日期：<asp:TextBox ID="TextBox49" runat="server" Width="58px">2007-1-1</asp:TextBox>
76 截止日期：<asp:TextBox ID="TextBox50" runat="server" Width="63px">2007-1-31</asp:TextBox>
77 信息来源：<asp:DropDownList ID="DropDownList14" runat="server" Width="62px">
78 </asp:DropDownList> <br />
79 <asp:CheckBox ID="CheckBox2" runat="server" Text="推荐房源" /> <asp:CheckBox
80 ID="CheckBox3" runat="server" Text="业主保密" /> <asp:CheckBox ID="CheckBox4" runat="server"
81 Text="房源保密" />
82 录入人员：<asp:TextBox ID="TextBox55" runat="server" Width="74px"></asp:TextBox>
83 经纪人员：<asp:DropDownList ID="DropDownList15" runat="server" Width="86px">
84 </asp:DropDownList><br />
85 当前状态：<asp:DropDownList ID="DropDownList16" runat="server" Width="85px">
86 </asp:DropDownList>
87 补充说明：<asp:TextBox ID="TextBox58" runat="server" Width="311px"></asp:TextBox></td>
88 </tr>
89 <tr>
90 <td style="width: 2232px; height: 50px; background-color: gainsboro">
91 <asp:Panel ID="Panel1" runat="server" Height="150px" ScrollBars="Auto" Width="553px">
92 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHouseDBConnectionString %>"
93 DeleteCommand="DELETE FROM [出售房源] WHERE [房源编号] = @房源编号"
94 InsertCommand="INSERT INTO [出售房源] ([房源编号], [所在城区], [具体位置], [公交线路], [楼盘名称], [配套环境], [座栋], [房号], [楼层], [总层], [电梯], [房], [厅], [厨], [卫], [阳], [朝向], [物管费], [楼层类型], [建成年份], [土地性质], [产权性质], [房屋用途], [房屋结构], [建筑面积], [套内面积], [装修级别], [装修说明], [房屋说明], [价格], [家私], [家电], [配套设施], [车位], [权证名称], [权证编号], [公钥数量], [私钥数量], [出售底价], [付款方式], [货币名称], [付佣类别], [业主姓名], [业主电话], [联系人], [联系电话], [委托方式], [委托日期], [截止日期], [信息来源], [推荐房源], [业主保密], [房源保密], [录入人员], [经纪人], [当前状态], [说明]) VALUES (@房源编号, @所在城区, @具体位置, @公交线路, @楼盘名称, @配套环境, @座栋, @房号, @楼层, @总层, @电梯, @房, @厅, @厨, @卫, @阳, @朝向, @物管费, @楼层类型, @建成年份, @土地性质, @产权性质, @房屋用途, @房屋结构, @建筑面积, @套内面积, @装修级别, @装修说明, @房屋说明, @价格, @家私, @家电, @配套设施, @车位, @权证名称, @权证编号, @公钥数量, @私钥数量, @出售底价, @付款方式, @货币名称, @付佣类别, @业主姓名, @业主电话, @联系人, @联系电话, @委托方式, @委托日期, @截止日期, @信息来源, @推荐房源, @业主保密, @房源保密, @录入人员, @经纪人, @当前状态, @说明)"
95 SelectCommand="SELECT * FROM [出售房源] WHERE ([房源编号] LIKE '%' + @房源编号 + '%') AND (房源编号 NOT IN (Select 资料编号 From 租售成交 Where (资料类型='出售房源'))) AND (当前状态 = '有效')"
96 UpdateCommand="UPDATE [出售房源] SET [所在城区] = @所在城区, [具体位置] = @具体位置, [公交线路] = @公交线路, [楼盘名称] = @楼盘名称, [配套环境] = @配套环境, [座栋] = @座栋, [房号] = @房号, [楼层] = @楼层, [总层] = @总层, [电梯] = @电梯, [房] = @房, [厅] = @厅, [厨] = @厨, [卫] = @卫, [阳] = @阳, [朝向] = @朝向, [物管费] = @物管费, [楼层类型] = @楼层类型, [建成年份] = @建成年份, [土地性质] = @土地性质, [产权性质] = @产权性质, [房屋用途] = @房屋用途, [房屋结构] = @房屋结构, [建筑面积] = @建筑面积, [套内面积] = @套内面积, [装修级别] = @装修级别, [装修说明] = @装修说明, [房屋说明] = @房屋说明, [价格] = @价格, [家私] = @家私, [家电] = @家电, [配套设施] = @配套设施, [车位] = @车位, [权证名称] = @权证名称, [权证编号] = @权证编号, [公钥数量] = @公钥数量, [私钥数量] = @私钥数量, [出售底价] = @出售底价, [付款方式] = @付款方式, [货币名称] = @货币名称, [付佣类别] = @付佣类别, [业主姓名] = @业主姓名, [业主电话] = @业主电话, [联系人] = @联系人, [联系电话] = @联系电话, [委托方式] = @委托方式, [委托日期] = @委托日期, [截止日期] = @截止日期, [信息来源] = @信息来源, [推荐房源] = @推荐房源, [业主保密] = @业主保密, [房源保密] = @房源保密, [录入人员] = @录入人员, [经纪人] = @经纪人, [当前状态] = @当前状态, [说明] = @说明 WHERE [房源编号] = @房源编号">
97 <DeleteParameters>
98 <asp:Parameter Name="房源编号" Type="String" />
99 </DeleteParameters>
100 <UpdateParameters>
101 <asp:ControlParameter ControlID="DropDownList1" Name="所在城区" PropertyName="SelectedValue"
102 Type="String" />
103 <asp:ControlParameter ControlID="TextBox4" Name="具体位置" PropertyName="Text" Type="String" />
104 <asp:ControlParameter ControlID="TextBox5" Name="公交线路" PropertyName="Text" Type="String" />
105 <asp:ControlParameter ControlID="TextBox6" Name="楼盘名称" PropertyName="Text" Type="String" />
106 <asp:ControlParameter ControlID="TextBox7" Name="配套环境" PropertyName="Text" Type="String" />
107 <asp:ControlParameter ControlID="TextBox8" Name="座栋" PropertyName="Text" Type="String" />
108 <asp:ControlParameter ControlID="TextBox9" Name="房号" PropertyName="Text" Type="String" />
109 <asp:ControlParameter ControlID="TextBox10" Name="楼层" PropertyName="Text" Type="Int32" />
110 <asp:ControlParameter ControlID="TextBox11" Name="总层" PropertyName="Text" Type="Int32" />
111 <asp:ControlParameter ControlID="CheckBox1" Name="电梯" PropertyName="Checked" Type="Int32" />
112 <asp:ControlParameter ControlID="TextBox13" Name="房" PropertyName="Text" Type="Int32" />
113 <asp:ControlParameter ControlID="TextBox14" Name="厅" PropertyName="Text" Type="Int32" />
114 <asp:ControlParameter ControlID="TextBox15" Name="厨" PropertyName="Text" Type="Int32" />
115 <asp:ControlParameter ControlID="TextBox16" Name="卫" PropertyName="Text" Type="Int32" />
116 <asp:ControlParameter ControlID="TextBox17" Name="阳" PropertyName="Text" Type="Int32" />
117 <asp:ControlParameter ControlID="DropDownList2" Name="朝向" PropertyName="SelectedValue"
118 Type="String" />
119 <asp:ControlParameter ControlID="TextBox19" Name="物管费" PropertyName="Text" Type="String" />
120 <asp:ControlParameter ControlID="DropDownList3" Name="楼层类型" PropertyName="SelectedValue"
121 Type="String" />
122 <asp:ControlParameter ControlID="TextBox21" Name="建成年份" PropertyName="Text" Type="DateTime" />
123 <asp:ControlParameter ControlID="DropDownList4" Name="土地性质" PropertyName="SelectedValue"
124 Type="String" />
125 <asp:ControlParameter ControlID="DropDownList5" Name="产权性质" PropertyName="SelectedValue"
126 Type="String" />
127 <asp:ControlParameter ControlID="DropDownList6" Name="房屋用途" PropertyName="SelectedValue"
128 Type="String" />
129 <asp:ControlParameter ControlID="DropDownList7" Name="房屋结构" PropertyName="SelectedValue"
130 Type="String" />
131 <asp:ControlParameter ControlID="TextBox26" Name="建筑面积" PropertyName="Text" Type="Double" />
132 <asp:ControlParameter ControlID="TextBox27" Name="套内面积" PropertyName="Text" Type="Double" />
133 <asp:ControlParameter ControlID="DropDownList8" Name="装修级别" PropertyName="SelectedValue"
134 Type="String" />
135 <asp:ControlParameter ControlID="TextBox29" Name="装修说明" PropertyName="Text" Type="String" />
136 <asp:ControlParameter ControlID="TextBox30" Name="房屋说明" PropertyName="Text" Type="String" />
137 <asp:ControlParameter ControlID="TextBox31" Name="价格" PropertyName="Text" Type="Double" />
138 <asp:ControlParameter ControlID="TextBox32" Name="家私" PropertyName="Text" Type="String" />
139 <asp:ControlParameter ControlID="TextBox33" Name="家电" PropertyName="Text" Type="String" />
140 <asp:ControlParameter ControlID="TextBox34" Name="配套设施" PropertyName="Text" Type="String" />
141 <asp:ControlParameter ControlID="TextBox35" Name="车位" PropertyName="Text" Type="String" />
142 <asp:ControlParameter ControlID="DropDownList9" Name="权证名称" PropertyName="SelectedValue"
143 Type="String" />
144 <asp:ControlParameter ControlID="TextBox37" Name="权证编号" PropertyName="Text" Type="String" />
145 <asp:ControlParameter ControlID="TextBox38" Name="公钥数量" PropertyName="Text" Type="Int32" />
146 <asp:ControlParameter ControlID="TextBox39" Name="私钥数量" PropertyName="Text" Type="Int32" />
147 <asp:ControlParameter ControlID="TextBox40" Name="出售底价" PropertyName="Text" Type="Double" />
148 <asp:ControlParameter ControlID="DropDownList10" Name="付款方式" PropertyName="SelectedValue"
149 Type="String" />
150 <asp:ControlParameter ControlID="DropDownList11" Name="货币名称" PropertyName="SelectedValue"
151 Type="String" />
152 <asp:ControlParameter ControlID="DropDownList12" Name="付佣类别" PropertyName="SelectedValue"
153 Type="String" />
154 <asp:ControlParameter ControlID="TextBox44" Name="业主姓名" PropertyName="Text" Type="String" />
155 <asp:ControlParameter ControlID="TextBox45" Name="业主电话" PropertyName="Text" Type="String" />
156 <asp:ControlParameter ControlID="TextBox46" Name="联系人" PropertyName="Text" Type="String" />
157 <asp:ControlParameter ControlID="TextBox47" Name="联系电话" PropertyName="Text" Type="String" />
158 <asp:ControlParameter ControlID="DropDownList13" Name="委托方式" PropertyName="SelectedValue"
159 Type="String" />
160 <asp:ControlParameter ControlID="TextBox49" Name="委托日期" PropertyName="Text" Type="DateTime" />
161 <asp:ControlParameter ControlID="TextBox50" Name="截止日期" PropertyName="Text" Type="DateTime" />
162 <asp:ControlParameter ControlID="DropDownList14" Name="信息来源" PropertyName="SelectedValue"
163 Type="String" />
164 <asp:ControlParameter ControlID="CheckBox2" Name="推荐房源" PropertyName="Checked" Type="Int32" />
165 <asp:ControlParameter ControlID="CheckBox3" Name="业主保密" PropertyName="Checked" Type="Int32" />
166 <asp:ControlParameter ControlID="CheckBox4" Name="房源保密" PropertyName="Checked" Type="Int32" />
167 <asp:ControlParameter ControlID="TextBox55" Name="录入人员" PropertyName="Text" Type="String" />
168 <asp:ControlParameter ControlID="DropDownList15" Name="经纪人" PropertyName="SelectedValue"
169 Type="String" />
170 <asp:ControlParameter ControlID="DropDownList16" Name="当前状态" PropertyName="SelectedValue"
171 Type="String" />
172 <asp:ControlParameter ControlID="TextBox58" Name="说明" PropertyName="Text" Type="String" />
173 <asp:ControlParameter ControlID="TextBox2" Name="房源编号" PropertyName="Text" Type="String" />
174 </UpdateParameters>
175 <SelectParameters>
176 <asp:ControlParameter ControlID="TextBox1" Name="房源编号" PropertyName="Text" Type="String" />
177 </SelectParameters>
178 <InsertParameters>
179 <asp:ControlParameter ControlID="TextBox2" Name="房源编号" PropertyName="Text" Type="String" />
180 <asp:ControlParameter ControlID="DropDownList1" Name="所在城区" PropertyName="SelectedValue"
181 Type="String" />
182 <asp:ControlParameter ControlID="TextBox4" Name="具体位置" PropertyName="Text" Type="String" />
183 <asp:ControlParameter ControlID="TextBox5" Name="公交线路" PropertyName="Text" Type="String" />
184 <asp:ControlParameter ControlID="TextBox6" Name="楼盘名称" PropertyName="Text" Type="String" />
185 <asp:ControlParameter ControlID="TextBox7" Name="配套环境" PropertyName="Text" Type="String"
