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

2019-08-26 18:55

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

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

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

if (lvSellhouse.Items.Count <= 0)

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

if (radB2.Checked) {

string connectionStr1

\Source='(local)'; Initial Catalog= 'House';

Integrated Security=true\

SqlConnection connection1 = new SqlConnection(connectionStr1); connection1.Open();

SqlCommand command1 = new SqlCommand();

command1.Connection = connection1;

command1.CommandText =

String.Format(\* from Sellhouse where

sellhouse_type = '{0}'\

this.texB1.Text); SqlDataReader reader1

command1.ExecuteReader();

this.lvSellhouse.Items.Clear();

while (reader1.Read()) {

ListViewItem lvi = new ListViewItem();

lvi.Text =

reader1[\

lvi.SubItems.Add(reader1[\

ring());

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

lvi.SubItems.Add(reader1[\tring());

lvi.SubItems.Add(reader1[\].ToString());

lvi.SubItems.Add(reader1[\tring());

lvi.SubItems.Add(reader1[\oString());

this.lvSellhouse.Items.Add(lvi); } if (lvSellhouse.Items.Count <= 0)

MessageBox.Show(\没有您查询的相关信息，请重新输入！\\提示\MessageBoxButtons.OK, MessageBoxIcon.Information); reader1.Close(); connection1.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 =

String.Format(\* from Sellhouse where

sellhouse_decoration ='{0}'\

this.texB1.Text); SqlDataReader

reader =

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[\ring());

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

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

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

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

if (lvSellhouse.Items.Count <= 0)

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

if (radB4.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 Sellhouse where

sellhouse_address like '%{0}%'\

this.texB1.Text); SqlDataReader reader =

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[\ring());

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

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

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

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

if (lvSellhouse.Items.Count <= 0)

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

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

} else

MessageBox.Show(\请输入您要查询的信息！\\提示\MessageBoxButtons.OK, MessageBoxIcon.Information);

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

command.CommandText = \ SqlDataReader reader = command.ExecuteReader(); this.lvSellhouse.Items.Clear(); while (reader.Read()) {

ListViewItem lvi = new ListViewItem(); lvi.Text = reader[\

lvi.SubItems.Add(reader[\ lvi.SubItems.Add(reader[\ lvi.SubItems.Add(reader[\ lvi.SubItems.Add(reader[\ lvi.SubItems.Add(reader[\ lvi.SubItems.Add(reader[\ this.lvSellhouse.Items.Add(lvi); }

4.4 管理员模块实现

管理员主要能对用户和交易信息进行增删查改，如图如图4－6、4－7、4－8、4

－9、4-10所示。

图4-6 买房者信息添加界面

（1）确认按钮的代码为：

if(texB1.Text.Trim()!= \& texB2.Text.Trim() != \

texB3.Text.Trim()

texB4.Text.Trim() != \& texB5.Text.Trim() != \& texB6.Text.Trim() != \\

{

SqlCommand command = new SqlCommand();

command.Connection =

connection;

command.CommandText =

String.Format(\buy_id from Buy where

buy_id = '{0}'\

this.texB1.Text); Int count

= command.ExecuteNonQuery(); if (count > 0) {

MessageBox.Show(\用户编号已存在，请重新输入！\错误\

MessageBoxButtons.OK, MessageBoxIcon.Error); } else { try {

String sql

String.Format(\ \buy_num,

buy_password, buy_name, buy_account, buy_phone,

buy_card)\

（2）取消按钮的代码为： this.Close();

\('{0}', '{1}', '{2}', '{3}', '{4}', '{5}', '{6}')\

this.texB1.Text, this.texB2.Text,

this.texB3.Text, this.texB4.Text,

this.texB5.Text, this.texB6.Text,

this.texB7.Text); command.CommandText = sql;

command.ExecuteNonQuery();

MessageBox.Show(\添加成功！\

} catch {

MessageBox.Show(\添加失败！\

} }

connection.Close(); this.Close(); }

else

MessageBox.Show(\请您填写完整信息后，再添加！\\提示\MessageBoxButtons.OK, MessageBoxIcon.Information);

图4-7 买房者信息管理界面（1）删除按钮的代码为：

try{

SqlCommand command = new SqlCommand(); command.Connection = connection;

command.CommandText = \from Buy where

buy_id='\

lvbuy.SelectedItems[0].SubItems[0].Text + \ command.ExecuteNonQuery(); connection.Close();

lvbuy.Items.Remove(lvbuy.SelectedItems[0]); MessageBox.Show(\删除成功！\\提示\MessageBoxButtons.OK, MessageBoxIcon.Information); } catch{

MessageBox.Show(\请选择您要删除的记录！\\

提

示

MessageBoxButtons.OK,

MessageBoxIcon.Information); }

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[\g());

lvi.SubItems.Add(reader[\;

lvi.SubItems.Add(reader[\

= =

String.Format(\

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

共8页:

房地产信息管理系统课设报告(5).doc 将本文的Word文档下载到电脑下载失败或者文档不完整，请联系客服人员解决！

下载这篇word文档