课程设计报告完整版(7)

}

DateTime time1 = DateTime.Parse(tbtime1. Text.Trim());

DateTime time2 = DateTime.Parse(tbtime2. Text.Trim());

string connstr = \Source=(local);Initial Catalog=Message;Integrated Security=True\; SqlConnection con = new SqlConnection (connstr); con.Open();

string str = \费用) from 个人理财 where 费用类型='收入'and 时间 between '\ + time1 + \ + time2 + \;

SqlDataAdapter sdat = new SqlDataAdapter (str,con);

SqlCommandBuilder scd = new SqlCommandBuilder (sdat);

DataSet ds = new DataSet(); sdat.Fill(ds,\);

textBox1.Text = ds.Tables[\].Rows[0] [0].ToString().Trim();

SqlConnection con = new SqlConnection (connstr); con.Open();

string str = \费用) from 个人理财 where 费用类型='支出'and 时间 between '\ + time1 + \ + time2 + \;

SqlDataAdapter sdat = new SqlDataAdapter(str, con);

SqlCommandBuilder scd = new SqlCommandBuilder (sdat);

DataSet ds = new DataSet();

sdat.Fill(ds, \);

textBox2.Text = ds.Tables[\].Rows

if (textBox1.Text == \)

{ MessageBox.Show(\没有你要统计的信息\,\提示 return;

}

textBox2.Clear(); textBox3.Clear(); con.Close(); }

（3）支出总计按钮代码的实现：

private void button2_Click(object sender, EventArgs e)

{ if (tbtime1.Text == \ || tbtime2.Text == \) { MessageBox.Show(\你没有输入要查询的日期范围！\, \错误提示\); return; }

DateTime time1 = DateTime.Parse(tbtime1. Text.Trim());

DateTime time2 = DateTime.Parse(tbtime2. Text.Trim());

string connstr = \Initial Catalog=Message;Integrated Security=True\;

[0][0].ToString().Trim(); if (textBox2.Text == \)

{ MessageBox.Show(\没有你要统计的信息\, \提示\); return; }

textBox1.Clear(); textBox3.Clear(); con.Close(); }

（4）总计按钮代码的实现：

private void button3_Click(object sender, EventArgs e)

{ if (tbtime1.Text == \ || tbtime2.Text == \) { MessageBox.Show(\你没有输入要查询的日期范

围！\, \错误提示\); return; }

DateTime time1 = DateTime.Parse(tbtime1. Text.Trim());

DateTime time2 = DateTime.Parse(tbtime2. Text.Trim());

string connstr = \Source=(local);Initial (connstr); con.Open();

string str1 = \费用) from 个人理 财 where 费用类型='收入'and 时间 between '\ + time1 + \ + time2 + \; string str2 = \费用) from 个人 财 where 费用类型='支出'and 时间 between '\ Catalog=Message;Integrated Security=True\; SqlConnection con = new SqlConnection (str1, con);

SqlDataAdapter sdat2 = new SqlDataAdapter (str2, con);

SqlCommandBuilder scd1 = new SqlCommand Builder(sdat1);

SqlCommandBuilder scd2 = new SqlCommand Builder(sdat2);

DataSet ds1 = new DataSet(); DataSet ds2 = new DataSet(); sdat1.Fill(ds1, \); sdat2.Fill(ds2, \); int shouru = 0; int zhichu = 0; if (textBox1.Text != \) shouru = int.Parse(ds1.Tables[\].

+ time1 + \ + time2 + \; SqlDataAdapter sdat1 = new SqlDataAdapter Rows[0][0].ToString().Trim()); if(textBox2.Text!=\)

zhichu = int.Parse(ds2.Tables[\]. Rows[0][0].ToString().Trim()); int zongji = shouru - zhichu; textBox3.Text = zongji.ToString(); if (textBox3.Text == \)

{ MessageBox.Show(\没有你要统计的信息\, \提示\); return;

}

textBox1.Clear(); textBox2.Clear(); con.Close(); }

个人通讯录界面的实现如图4-9所示：

图4-9 个人通讯录界面的实现

(1)显示全部个人通讯录按钮代码的实现： private void button16_Click(object sender, EventArgs e)

{ DataSet dst = new DataSet();

string connstr = \Source=(local);Initial Catalog=Message;Integrated Security=True\; SqlConnection con = new SqlConnection (connstr); con.Open();

string str = \个人通讯录\; SqlDataAdapter sda = new SqlDataAdapter(str, con);

SqlCommandBuilder scd = new SqlCommand Builder(sda);

sda.Fill(dst, \);

dataGridView3.DataSource = dst.Tables [\].DefaultView;

con.Close(); }

（2）实现个人通讯录的上一条按钮代码的实现： private void button17_Click(object sender, EventArgs e)

{ row = dataGridView3.RowCount; for (int i = 0; i < row - 1; i++)

{if (dataGridView3.Rows[i].Selected == true) { dataGridView3.Rows[i].Selected = false; if (i == 0)

dataGridView3.Rows[row - 2].Selected = true; else

dataGridView3.Rows[i - 1].Selected = true; break; }

（3）实现个人通讯录下一条按钮代码的实现： private void button18_Click(object sender,

EventArgs e)

{ row = dataGridView3.RowCount; for (int i = 0; i < row - 1; i++)

{if (dataGridView3.Rows[i].Selected == true) {dataGridView3.Rows[i].Selected = false; if (i == row - 2)

{ dataGridView3.Rows[0].Selected = true;} else

dataGridView3.Rows[i + 1].Selected = true; break; }

（4）添加个人通讯录按钮代码的实现： private void button22_Click(object sender, EventArgs e)

{ if (textBox15.Text == \)

{ MessageBox.Show(\你没有输入要添加的通讯录的名字\,\错误提示\); return; }

if (textBox16.Text == \)

{ MessageBox.Show(\你没有输入要添加的通讯录 的电话\, \错误提示\); return; }

if (textBox17.Text == \)

{ MessageBox.Show(\你没有输入要添加的通讯录的住址\, \错误提示\); return; }

if (rbjia.Checked == false && rbpeng.Checked == false && rbtong.Checked == false) { MessageBox.Show(\你没有选择要添加的通讯录的类型\, \错误提示\); return; }

string leixing=null;

if (rbjia.Checked == true) leixing = \家人\; else

if (rbpeng.Checked == true)leixing = \朋友\; else

if (rbtong.Checked == true)leixing = \同事\; string connstr = \Source=(local);Initial Catalog=Message;Integrated Security=True\; SqlConnection con = new SqlConnection (connstr); con.Open();

if(MessageBox.Show(\你确定要添加此信息吗？\,\提示\,MessageBoxButtons.YesNo)==、DialogResult.Yes) { try

{ string sql = \个人通讯录values('\+textBox15.Text+\+textBox16.Text+\+textBox17.Text+\+leixing+\”; SqlCommand comm = new SqlCommand(sql,con); comm.ExecuteNonQuery(); } catch(Exception ea)

{ MessageBox.Show(\添加用户失败\,\错误提示\); return;

}

MessageBox.Show(\添加通讯录成功！\,\提示\); textBox15.Clear(); textBox16.Clear(); textBox17.Clear(); rbjia.Checked = false; rbpeng.Checked = false; rbtong.Checked = false; button16_Click(sender, e); con.Close(); }

（5）查询个人通讯录按钮代码的实现： private void button20_Click(object sender, EventArgs e)

{询个人通讯录 chaxun = new 查询个人通讯录(); chaxun.Visible = true;}

查询个人通讯录界面的实现，如下图4-10所示：

图4-10 查询个人通讯录界面的实现

（1）查询个人通讯录按钮代码的实现： private void button2_Click(object sender, EventArgs e)

{string str = null; string lei = null; if (rbjia.Checked == true) lei = \家人\; if (rbpeng.Checked == true) lei = \朋友\; if (rbtong.Checked == true) lei = \同事\; if (textBox1.Text != \ && textBox2.Text == \ && lei == null)

{ str = \个人通讯录 where 姓名='\+textBox1.Text.Trim()+\; } else

if (textBox1.Text == \ && textBox2.Text != \ && lei == null)

{ str = \个人通讯录 where 住址='\ + textBox2.Text.Trim() + \; textBox2.Clear();

} else

if (textBox1.Text== \ && textBox2.Text == \ && lei != null)

{str = \个人通讯录 where 类型 ='\ + lei+ \;

rbjia.Checked = false;rbpeng.Checked = false; rbtong.Checked = false; }

DataSet dst = new DataSet();

SqlDataAdapter sda = new SqlDataAdapter(str, con);

SqlCommandBuilder scd = new SqlCommand Builder(sda);

sda.Fill(dst, \);

dataGridView1.DataSource = dst.Tables [\].DefaultView; con.Close();