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

());

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();

22

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); }

23

图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 +

24

图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);

25

=

lvi.SubItems.Add(reader[\

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

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

26

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