当前文件路径：HouseManage/ClientManage/ClientLeaseForm.aspx 
1
<%...--文件名：ClientLeaseForm.aspx--%>
2<%...@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="ClientLeaseForm.aspx.cs" Inherits="ClientManage_ClientLeaseForm" 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="161px">%%</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 </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="77px"></asp:TextBox>
18 客户姓名：<asp:TextBox ID="TextBox3" runat="server" Width="42px"></asp:TextBox>
19 客户性别：<asp:DropDownList ID="DropDownList1" runat="server" Width="40px">
20 <asp:ListItem>男</asp:ListItem>
21 <asp:ListItem>女</asp:ListItem>
22 </asp:DropDownList>
23 客户电话：<asp:TextBox ID="TextBox5" runat="server" Width="84px"></asp:TextBox><br />
24 电子邮箱：<asp:TextBox ID="TextBox6" runat="server" Width="131px"></asp:TextBox>
25 客户地址：<asp:TextBox ID="TextBox7" runat="server" Width="126px"></asp:TextBox>
26 邮政编码：<asp:TextBox ID="TextBox8" runat="server" Width="51px"></asp:TextBox><br />
27 <asp:CheckBox ID="CheckBox1" runat="server" Text="电梯要求" />
28 求租城区：<asp:DropDownList ID="DropDownList2" runat="server" Width="80px">
29 </asp:DropDownList>
30 具体位置：<asp:TextBox ID="TextBox11" runat="server" Width="233px"></asp:TextBox><br />
31 配套设施：<asp:TextBox ID="TextBox12" runat="server" Width="154px"></asp:TextBox>
32 家具家电：<asp:TextBox ID="TextBox13" runat="server" Width="231px"></asp:TextBox><br />
33 装修情况：<asp:DropDownList ID="DropDownList3" runat="server" Width="80px">
34 </asp:DropDownList>
35 房龄要求：<asp:TextBox ID="TextBox15" runat="server" Width="78px"></asp:TextBox>
36 最小房间数：<asp:TextBox ID="TextBox16" runat="server" Width="25px"></asp:TextBox>
37 最大房间数：<asp:TextBox ID="TextBox17" runat="server" Width="32px"></asp:TextBox><br />
38 付租方式：<asp:DropDownList ID="DropDownList4" runat="server" Width="53px">
39 <asp:ListItem>月付</asp:ListItem>
40 <asp:ListItem>季付</asp:ListItem>
41 <asp:ListItem>年付</asp:ListItem>
42 </asp:DropDownList>最低租价(元)：<asp:TextBox ID="TextBox19" runat="server" Width="24px"></asp:TextBox>最高租价(元)：<asp:TextBox ID="TextBox20" runat="server" Width="32px"></asp:TextBox>最低物管费(元/年)：<asp:TextBox ID="TextBox21" runat="server" Width="40px"></asp:TextBox><br />
43 最高物管费(元/年)：<asp:TextBox ID="TextBox22" runat="server" Width="78px"></asp:TextBox>
44 最小面积(m2)：<asp:TextBox ID="TextBox23" runat="server" Width="52px"></asp:TextBox>
45 最大面积(m2)：<asp:TextBox ID="TextBox24" runat="server" Width="55px"></asp:TextBox><br />
46 委托日期：<asp:TextBox ID="TextBox25" runat="server" Width="57px">2007-4-1</asp:TextBox>
47 截止日期：<asp:TextBox ID="TextBox26" runat="server" Width="63px">2007-6-30</asp:TextBox>
48 付佣类别：<asp:DropDownList ID="DropDownList5" runat="server" Width="61px">
49 </asp:DropDownList>
50 信息来源：<asp:DropDownList ID="DropDownList6" runat="server" Width="62px">
51 </asp:DropDownList><br />
52 录入人员：<asp:TextBox ID="TextBox29" runat="server" Width="38px"></asp:TextBox>
53 经纪人员：<asp:DropDownList ID="DropDownList7" runat="server" Width="66px">
54 </asp:DropDownList> <asp:CheckBox ID="CheckBox2" runat="server" Text="客源保密" /> <asp:CheckBox
55 ID="CheckBox3" runat="server" Text="推荐客源" />
56 当前状态：<asp:DropDownList ID="DropDownList8" runat="server" Width="59px">
57 </asp:DropDownList><br />
58 补充说明：<asp:TextBox ID="TextBox34" runat="server" Width="468px"></asp:TextBox> </td>
59 </tr>
60 <tr>
61 <td style="width: 2232px; height: 50px; background-color: gainsboro">
62 <asp:Panel ID="Panel1" runat="server" Height="150px" ScrollBars="Auto" Width="553px">
63 <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyHouseDBConnectionString %>"
64 DeleteCommand="DELETE FROM [求租客户] WHERE [客源编号] = @客源编号" InsertCommand="INSERT INTO [求租客户] ([客源编号], [客户姓名], [客户性别], [客户电话], [电子邮箱], [客户地址], [邮政编码], [电梯要求], [所在城区], [具体位置], [配套设施], [家具家电], [装修级别], [房龄要求], [最小房间数], [最大房间数], [付租方式], [最低租价], [最高租价], [最低物管费], [最高物管费], [最小面积], [最大面积], [委托日期], [截止日期], [付佣类别], [信息来源], [录入人员], [经纪人员], [客源保密], [推荐客源], [当前状态], [补充说明]) VALUES (@客源编号, @客户姓名, @客户性别, @客户电话, @电子邮箱, @客户地址, @邮政编码, @电梯要求, @所在城区, @具体位置, @配套设施, @家具家电, @装修级别, @房龄要求, @最小房间数, @最大房间数, @付租方式, @最低租价, @最高租价, @最低物管费, @最高物管费, @最小面积, @最大面积, @委托日期, @截止日期, @付佣类别, @信息来源, @录入人员, @经纪人员, @客源保密, @推荐客源, @当前状态, @补充说明)"
65 SelectCommand="SELECT * FROM [求租客户] WHERE ([客源编号] LIKE '%' + @客源编号 + '%') AND (客源编号 NOT IN (Select 资料编号 From 租售成交 Where (资料类型='求租客源'))) AND (当前状态 = '有效')"
66 UpdateCommand="UPDATE [求租客户] SET [客户姓名] = @客户姓名, [客户性别] = @客户性别, [客户电话] = @客户电话, [电子邮箱] = @电子邮箱, [客户地址] = @客户地址, [邮政编码] = @邮政编码, [电梯要求] = @电梯要求, [所在城区] = @所在城区, [具体位置] = @具体位置, [配套设施] = @配套设施, [家具家电] = @家具家电, [装修级别] = @装修级别, [房龄要求] = @房龄要求, [最小房间数] = @最小房间数, [最大房间数] = @最大房间数, [付租方式] = @付租方式, [最低租价] = @最低租价, [最高租价] = @最高租价, [最低物管费] = @最低物管费, [最高物管费] = @最高物管费, [最小面积] = @最小面积, [最大面积] = @最大面积, [委托日期] = @委托日期, [截止日期] = @截止日期, [付佣类别] = @付佣类别, [信息来源] = @信息来源, [录入人员] = @录入人员, [经纪人员] = @经纪人员, [客源保密] = @客源保密, [推荐客源] = @推荐客源, [当前状态] = @当前状态, [补充说明] = @补充说明 WHERE [客源编号] = @客源编号">
67 <DeleteParameters>
68 <asp:Parameter Name="客源编号" Type="String" />
69 </DeleteParameters>
70 <UpdateParameters>
71 <asp:ControlParameter ControlID="TextBox3" Name="客户姓名" PropertyName="Text" Type="String" />
72 <asp:ControlParameter ControlID="DropDownList1" Name="客户性别" PropertyName="SelectedValue"
73 Type="String" />
74 <asp:ControlParameter ControlID="TextBox5" Name="客户电话" PropertyName="Text" Type="String" />
75 <asp:ControlParameter ControlID="TextBox6" Name="电子邮箱" PropertyName="Text" Type="String" />
76 <asp:ControlParameter ControlID="TextBox7" Name="客户地址" PropertyName="Text" Type="String" />
77 <asp:ControlParameter ControlID="TextBox8" Name="邮政编码" PropertyName="Text" Type="String" />
78 <asp:ControlParameter ControlID="CheckBox1" Name="电梯要求" PropertyName="Checked" Type="Int32" />
79 <asp:ControlParameter ControlID="DropDownList2" Name="所在城区" PropertyName="SelectedValue"
80 Type="String" />
81 <asp:ControlParameter ControlID="TextBox11" Name="具体位置" PropertyName="Text" Type="String" />
82 <asp:ControlParameter ControlID="TextBox12" Name="配套设施" PropertyName="Text" Type="String" />
83 <asp:ControlParameter ControlID="TextBox13" Name="家具家电" PropertyName="Text" Type="String" />
84 <asp:ControlParameter ControlID="DropDownList3" Name="装修级别" PropertyName="SelectedValue"
85 Type="String" />
86 <asp:ControlParameter ControlID="TextBox15" Name="房龄要求" PropertyName="Text" Type="String" />
87 <asp:ControlParameter ControlID="TextBox16" Name="最小房间数" PropertyName="Text" Type="Int32" />
88 <asp:ControlParameter ControlID="TextBox17" Name="最大房间数" PropertyName="Text" Type="Int32" />
89 <asp:ControlParameter ControlID="DropDownList4" Name="付租方式" PropertyName="SelectedValue"
90 Type="String" />
91 <asp:ControlParameter ControlID="TextBox19" Name="最低租价" PropertyName="Text" Type="Double" />
92 <asp:ControlParameter ControlID="TextBox20" Name="最高租价" PropertyName="Text" Type="Double" />
93 <asp:ControlParameter ControlID="TextBox21" Name="最低物管费" PropertyName="Text" Type="Double" />
94 <asp:ControlParameter ControlID="TextBox22" Name="最高物管费" PropertyName="Text" Type="Double" />
95 <asp:ControlParameter ControlID="TextBox23" Name="最小面积" PropertyName="Text" Type="Double" />
96 <asp:ControlParameter ControlID="TextBox24" Name="最大面积" PropertyName="Text" Type="Double" />
97 <asp:ControlParameter ControlID="TextBox25" Name="委托日期" PropertyName="Text" Type="DateTime" />
98 <asp:ControlParameter ControlID="TextBox26" Name="截止日期" PropertyName="Text" Type="DateTime" />
99 <asp:ControlParameter ControlID="DropDownList5" Name="付佣类别" PropertyName="SelectedValue"
100 Type="String" />
101 <asp:ControlParameter ControlID="DropDownList6" Name="信息来源" PropertyName="SelectedValue"
102 Type="String" />
103 <asp:ControlParameter ControlID="TextBox29" Name="录入人员" PropertyName="Text" Type="String" />
104 <asp:ControlParameter ControlID="DropDownList7" Name="经纪人员" PropertyName="SelectedValue"
105 Type="String" />
106 <asp:ControlParameter ControlID="CheckBox2" Name="客源保密" PropertyName="Checked" Type="Int32" />
107 <asp:ControlParameter ControlID="CheckBox3" Name="推荐客源" PropertyName="Checked" Type="Int32" />
108 <asp:ControlParameter ControlID="DropDownList8" Name="当前状态" PropertyName="SelectedValue"
109 Type="String" />
110 <asp:ControlParameter ControlID="TextBox34" Name="补充说明" PropertyName="Text" Type="String" />
111 <asp:ControlParameter ControlID="TextBox2" Name="客源编号" PropertyName="Text" Type="String" />
112 </UpdateParameters>
113 <SelectParameters>
114 <asp:ControlParameter ControlID="TextBox1" Name="客源编号" PropertyName="Text" Type="String" />
115 </SelectParameters>
116 <InsertParameters>
117 <asp:ControlParameter ControlID="TextBox2" Name="客源编号" PropertyName="Text" Type="String" />
118 <asp:ControlParameter ControlID="TextBox3" Name="客户姓名" PropertyName="Text" Type="String" />
119 <asp:ControlParameter ControlID="DropDownList1" Name="客户性别" PropertyName="SelectedValue"
120 Type="String" />
121 <asp:ControlParameter ControlID="TextBox5" Name="客户电话" PropertyName="Text" Type="String" />
122 <asp:ControlParameter ControlID="TextBox6" Name="电子邮箱" PropertyName="Text" Type="String" />
123 <asp:ControlParameter ControlID="TextBox7" Name="客户地址" PropertyName="Text" Type="String" />
124 <asp:ControlParameter ControlID="TextBox8" Name="邮政编码" PropertyName="Text" Type="String" />
125 <asp:ControlParameter ControlID="CheckBox1" Name="电梯要求" PropertyName="Checked" Type="Int32" />
126 <asp:ControlParameter ControlID="DropDownList2" Name="所在城区" PropertyName="SelectedValue"
127 Type="String" />
128 <asp:ControlParameter ControlID="TextBox11" Name="具体位置" PropertyName="Text" Type="String" />
129 <asp:ControlParameter ControlID="TextBox12" Name="配套设施" PropertyName="Text" Type="String" />
130 <asp:ControlParameter ControlID="TextBox13" Name="家具家电" PropertyName="Text" Type="String" />
131 <asp:ControlParameter ControlID="DropDownList3" Name="装修级别" PropertyName="SelectedValue"
132 Type="String" />
133 <asp:ControlParameter ControlID="TextBox15" Name="房龄要求" PropertyName="Text" Type="String" />
134 <asp:ControlParameter ControlID="TextBox16" Name="最小房间数" PropertyName="Text" Type="Int32" />
135 <asp:ControlParameter ControlID="TextBox17" Name="最大房间数" PropertyName="Text" Type="Int32" />
136 <asp:ControlParameter ControlID="DropDownList4" Name="付租方式" PropertyName="SelectedValue"
137 Type="String" />
138 <asp:ControlParameter ControlID="TextBox19" Name="最低租价" PropertyName="Text" Type="Double" />
139 <asp:ControlParameter ControlID="TextBox20" Name="最高租价" PropertyName="Text" Type="Double" />
140 <asp:ControlParameter ControlID="TextBox21" Name="最低物管费" PropertyName="Text" Type="Double" />
141 <asp:ControlParameter ControlID="TextBox22" Name="最高物管费" PropertyName="Text" Type="Double" />
142 <asp:ControlParameter ControlID="TextBox23" Name="最小面积" PropertyName="Text" Type="Double" />
143 <asp:ControlParameter ControlID="TextBox24" Name="最大面积" PropertyName="Text" Type="Double" />
144 <asp:ControlParameter ControlID="TextBox25" Name="委托日期" PropertyName="Text" Type="DateTime" />
145 <asp:ControlParameter ControlID="TextBox26" Name="截止日期" PropertyName="Text" Type="DateTime" />
146 <asp:ControlParameter ControlID="DropDownList5" Name="付佣类别" PropertyName="SelectedValue"
147 Type="String" />
148 <asp:ControlParameter ControlID="DropDownList6" Name="信息来源" PropertyName="SelectedValue"
149 Type="String" />
150 <asp:ControlParameter ControlID="TextBox29" Name="录入人员" PropertyName="Text" Type="String" />
151 <asp:ControlParameter ControlID="DropDownList7" Name="经纪人员" PropertyName="SelectedValue"
152 Type="String" />
153 <asp:ControlParameter ControlID="CheckBox2" Name="客源保密" PropertyName="Checked" Type="Int32" />
154 <asp:ControlParameter ControlID="CheckBox3" Name="推荐客源" PropertyName="Checked" Type="Int32" />
155 <asp:ControlParameter ControlID="DropDownList8" Name="当前状态" PropertyName="SelectedValue"
156 Type="String" />
157 <asp:ControlParameter ControlID="TextBox34" Name="补充说明" PropertyName="Text" Type="String" />
158 </InsertParameters>
159 </asp:SqlDataSource>
160 <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
161 BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataKeyNames="客源编号"
162 DataSourceID="SqlDataSource1" Font-Names="宋体" Font-Size="Small" GridLines="Vertical"
163 OnRowCreated="GridView1_RowCreated" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
164 Width="4000px">
165 <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
166 <Columns>
167 <asp:CommandField ButtonType="Button" HeaderText="选择" ShowSelectButton="True" />
168 <asp:TemplateField HeaderText="删除" ShowHeader="False">
169 <ItemTemplate>
170 <asp:Button ID="Button1" runat="server" CausesValidation="False" CommandName="Delete"
171 Text="删除" />
172 </ItemTemplate>
173 </asp:TemplateField>
174 <asp:BoundField DataField="客源编号" HeaderText="客源编号" ReadOnly="True" SortExpression="客源编号" />
175 <asp:BoundField DataField="客户姓名" HeaderText="客户姓名" SortExpression="客户姓名" />
176 <asp:BoundField DataField="客户性别" HeaderText="客户性别" SortExpression="客户性别" />
177 <asp:BoundField DataField="客户电话" HeaderText="客户电话" SortExpression="客户电话" />
178 <asp:BoundField DataField="电子邮箱" HeaderText="电子邮箱" SortExpression="电子邮箱" />
179 <asp:BoundField DataField="客户地址" HeaderText="客户地址" SortExpression="客户地址" />
180 <asp:BoundField DataField="邮政编码" HeaderText="邮政编码" SortExpression="邮政编码" />
181 <asp:BoundField DataField="电梯要求" HeaderText="电梯要求" SortExpression="电梯要求" />
182 <asp:BoundField DataField="所在城区" HeaderText="所在城区" SortExpression="所在城区" />
183 <asp:BoundField DataField="具体位置" HeaderText="具体位置" SortExpression="具体位置" />
184 <asp:BoundField DataField="配套设施" HeaderText="配套设施" SortExpression="配套设施" />
185 <asp:BoundField DataField="家具家电" HeaderText="家具家电" SortExpression="家具家电" />
186 <asp:BoundField DataField="
