房地产信息管理系统课设报告(4)

if (radB4.Checked) {

String

sql

=

String.Format(\='{0}' and rent_password = '{1}'\ this.texB1.Text, this.texB2.Text);

SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader

=

command.ExecuteReader();

Form26 f26 = new Form26(); if (reader.Read()) {

f26.Show(); } else {

MessageBox.Show(\用户名或密码错误！\提示\MessageBoxIcon.Information);

texB1.Text = \ texB2.Text = \ radB1.Text = \ }

reader.Close(); connection.Close(); }

if (radB5.Checked) {

String sql

=

图4-2 不完整的用户名和密码

String.Format(\* from Lease where lease_num ='{0}' and lease_password = '{1}'\ this.texB1.Text, this.texB2.Text);

SqlCommand command = new SqlCommand(sql, connection); SqlDataReader reader

=

command.ExecuteReader();

Form27 f27 = new Form27(); if (reader.Read()) {

f27.Show(); } else {

MessageBox.Show(\用户名或密码错误！\提示\MessageBoxIcon.Information);

texB1.Text = \ texB2.Text = \ radB1.Text = \ }

reader.Close(); connection.Close(); } } else

MessageBox.Show(\请将登录信息填写完整！\\提示\MessageBoxButtons.OK, MessageBoxIcon.Information);

this.Hide();

图4-3 错误的用户名和密码

12

4.3 买房者模块实现

买房者主要能查询卖房者信息和出售房屋信息。如图4－4、4－5所示。

图4-4 卖房者信息查询

图4-4 卖房者信息查询界面 （1）查询按钮的代码为： if (radB1.Checked)

{

string connectionStr = \Source='(local)'; Initial Catalog= 'House'; Integrated Security=true\

SqlConnection

connection = new SqlConnection(connectionStr); connection.Open();

SqlCommand command = new SqlCommand();

command.Connection connection;

command.CommandText '{0}'\

this.texB1.Text); SqlDataReader reader = command.ExecuteReader();

this.lvbuy.Items.Clear();

if (reader.Read()) {

ListViewItem lvi = new ListViewItem();

lvi.Text reader[\

lvi.SubItems.Add(reader[\;

= =

lvi.SubItems.Add(reader[\ng());

lvi.SubItems.Add(reader[\);

lvi.SubItems.Add(reader[\g());

13

=

String.Format(\* from Sell where sell_id =

lvi.SubItems.Add(reader[\));

lvi.SubItems.Add(reader[\);

lvi.SubItems.Add(reader[\g());

this.lvbuy.Items.Add(lvi); } else

MessageBox.Show(\没有您查询的相关信息，请重新输入！\\提示\MessageBoxButtons.OK, MessageBoxIcon.Information);

reader.Close(); connection.Close(); }

if (radB2.Checked) {

string connectionStr = \Source='(local)'; Initial Catalog= 'House'; Integrated Security=true\

SqlConnection

connection = new SqlConnection(connectionStr); connection.Open();

SqlCommand command = new SqlCommand();

command.Connection = connection;

command.CommandText =

String.Format(\* from Sell where

sell_name= '{0}'\

this.texB1.Text); SqlDataReader reader = command.ExecuteReader(); this.lvbuy.Items.Clear();

if (reader.Read()) {

ListViewItem lvi = new ListViewItem();

lvi.Text =

reader[\

lvi.SubItems.Add(reader[\;

lvi.SubItems.Add(reader[\ng());

lvi.SubItems.Add(reader[\);

lvi.SubItems.Add(reader[\g());

lvi.SubItems.Add(reader[\));

lvi.SubItems.Add(reader[\);

lvi.SubItems.Add(reader[\g());

this.lvbuy.Items.Add(lvi); } else

MessageBox.Show(\没有您查询的相关信息，请重新输入！\\提示\MessageBoxButtons.OK, MessageBoxIcon.Information);

reader.Close(); connection.Close(); }

if (radB3.Checked) {

string connectionStr = \Source='(local)'; Initial Catalog= 'House'; Integrated Security=true\

SqlConnection

connection = new SqlConnection(connectionStr); connection.Open();

SqlCommand command = new SqlCommand();

command.Connection = connection;

command.CommandText

=

14

String.Format(\*

from

Sell

where

sell_phone = '{0}'\

this.texB1.Text); SqlDataReader reader = command.ExecuteReader(); this.lvbuy.Items.Clear();

if (reader.Read()) {

ListViewItem lvi = new ListViewItem();

lvi.Text =

reader[\

lvi.SubItems.Add(reader[\;

lvi.SubItems.Add(reader[\ng());

lvi.SubItems.Add(reader[\);

（2）全部显示按钮的代码为：

string connectionStr = \Initial

Catalog=

'House';

Integrated

Security=true\

SqlConnection connection = new SqlConnection(connectionStr); connection.Open();

SqlCommand command = new SqlCommand();

command.Connection = connection; command.CommandText = \from Sell\

SqlDataReader reader =

command.ExecuteReader();

this.lvbuy.Items.Clear(); while (reader.Read()) {

ListViewItem lvi = new ListViewItem();

lvi.Text =

reader[\

lvi.SubItems.Add(reader[\g());

lvi.SubItems.Add(reader[\));

lvi.SubItems.Add(reader[\);

lvi.SubItems.Add(reader[\g());

this.lvbuy.Items.Add(lvi); } else

MessageBox.Show(\没有您查询的相关信息，请重新输入！\\提示\MessageBoxButtons.OK, MessageBoxIcon.Information);

reader.Close(); connection.Close(); }

lvi.SubItems.Add(reader[\;

lvi.SubItems.Add(reader[\ng());

lvi.SubItems.Add(reader[\);

lvi.SubItems.Add(reader[\g());

lvi.SubItems.Add(reader[\));

lvi.SubItems.Add(reader[\);

lvi.SubItems.Add(reader[\g());

15

this.lvbuy.Items.Add(lvi); }

reader.Close(); connection.Close();

图4-5 出售房屋信息查询

（1）查询按钮的代码为：

if (texB1.Text.Trim() != \ {

if (radB1.Checked) {

string connectionStr = \Source='(local)'; Initial Catalog= 'House'; Integrated Security=true\

SqlConnection connection = new SqlConnection(connectionStr); connection.Open();

SqlCommand command = new SqlCommand();

command.Connection connection;

command.CommandText sellhouse_area = '{0}'\

this.texB1.Text); SqlDataReader command.ExecuteReader();

this.lvSellhouse.Items.Clear();

while (reader.Read()) {

ListViewItem lvi = new ListViewItem();

lvi.Text reader[\

lvi.SubItems.Add(reader[\ing());

lvi.SubItems.Add(reader[\= =

ing());

lvi.SubItems.Add(reader[\ring());

lvi.SubItems.Add(reader[\=

.ToString());

reader

=

String.Format(\* from Sellhouse where

16

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说教育文库房地产信息管理系统课设报告(4)在线全文阅读。