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

2019-08-26 18:55

());

lvi.SubItems.Add(reader[\);

lvi.SubItems.Add(reader[\;

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(\

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

lvi.SubItems.Add(reader[\);

lvi.SubItems.Add(reader[\;

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 =

String.Format(\

= '{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[\

（3）刷新按钮的代码为：

command.CommandText = \ SqlDataReader reader

command.ExecuteReader();

this.lvbuy.Items.Clear(); while (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[\;

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

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

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

lvi.SubItems.Add(reader[\;

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

lvi.SubItems.Add(reader[\);

lvi.SubItems.Add(reader[\;

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

图4-8 买房者信息修改界面

修改按钮的代码为：

if(texB1.Text.Trim()

\+ texB6.Text +

\texB7.Text

WHERE

buy_id='\

WindowsFormsApplication1.Form6.sellhouse.sh \=

command.ExecuteNonQuery();

MessageBox.Show(\修改成功！\\提示\MessageBoxButtons.OK, MessageBoxIcon.Information); } catch +

{

MessageBox.Show(\修改失败！\+

}

+ + +

texB2.Text.Trim() != \& texB3.Text.Trim() != \& texB4.Text.Trim() != \\

texB6.Text.Trim()

texB7.Text.Trim() != \

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

try {

command.CommandText= String.Format(\Buy set buy_id ='\+ texB1.Text +

texB4.Text

texB2.Text + \+ texB3.Text +

图4-9 出售房屋交易信息管理界面

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

radB3.Visible = true; radB4.Visible = true;

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

if (radB1.Checked) {

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

SqlConnection

connection = new SqlConnection(connectionStr); connection.Open(); lvsb.Columns.Clear(); lvsb.Columns.Add(\交易编号\

lvsb.Columns.Add(\房屋编号\

lvsb.Columns.Add(\买房者编号\

lvsb.Columns.Add(\卖房者编号\

SqlCommand command = new SqlCommand();

command.Connection connection;

command.CommandText

bsbargin_id = '{0}'\

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

if (reader.Read()) {

ListViewItem lvi = new ListViewItem();

lvi.Text reader[\

lvi.SubItems.Add(reader[\g()); this.lvsb.Items.Add(lvi); } else = =

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

lvi.SubItems.Add(reader[\

String.Format(\* from Bsbargin where

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

if (radB2.Checked) {

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

SqlConnection

connection = new SqlConnection(connectionStr1); connection.Open(); lvsb.Columns.Clear(); lvsb.Columns.Add(\交易编号\

lvsb.Columns.Add(\房屋编号\

lvsb.Columns.Add(\买房者编号\

lvsb.Columns.Add(\卖房者编号\

SqlCommand command1 = new SqlCommand();

command1.Connection =

connection;

command1.CommandText = String.Format(\* from Bsbargin where sellhouse_id = '{0}'\

this.texB1.Text); SqlDataReader reader = command1.ExecuteReader(); this.lvsb.Items.Clear();

if (reader.Read()) {

ListViewItem lvi = new ListViewItem();

lvi.Text =

reader[\

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

lvi.SubItems.Add(reader[\

this.lvsb.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(); lvsb.Columns.Clear(); lvsb.Columns.Add(\交易编号\

lvsb.Columns.Add(\房屋编号\

lvsb.Columns.Add(\买房者编号\

lvsb.Columns.Add(\卖房者编号\

SqlCommand command = new SqlCommand();

command.Connection = connection;

command.CommandText =

String.Format(\* from Bsbargin where

sell_id = '{0}'\

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

while (reader.Read()) {

ListViewItem lvi = new ListViewItem();

lvi.Text =

reader[\

共8页:

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

下载这篇word文档