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