个人理财系统.docx
- 文档编号:2361694
- 上传时间:2023-05-03
- 格式:DOCX
- 页数:53
- 大小:605.64KB
个人理财系统.docx
《个人理财系统.docx》由会员分享,可在线阅读,更多相关《个人理财系统.docx(53页珍藏版)》请在冰点文库上搜索。
个人理财系统
privatevoidbtlogin_Click(objectsender,EventArgse)
{stringusername=null;
stringpassword=null;
if(tbusername.Text=="")
{MessageBox.Show("你没有输入用户名!
","错误提示");return;
}
if(tbmima.Text=="")
{MessageBox.Show("你没有输入密码!
","错误提示");
return;
}
DataSetdst=newDataSet();
stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";
SqlConnectioncon=newSqlConnection(connstr);
con.Open();
stringstr="select*from登录";
SqlDataAdaptersda=newSqlDataAdapter(str,con);
SqlCommandBuilderscd=newSqlCommand
Builder(sda);
sda.Fill(dst,"tong");
dataGridView1.DataSource=dst.Tables
["tong"].DefaultView;
username=dataGridView1.Rows[0].Cells[0].
Value.ToString().Trim();
password=dataGridView1.Rows[0].Cells[1].
Value.ToString().Trim();
if(tbusername.Text.Equals(username)&&tbmima.Text.Equals(password))
{Form2f2=newForm2();
f2.Visible=true;
this.Visible=false;
}
else
{MessageBox.Show("你输入的用户名或密码错误","错误提示");
tbusername.Clear();
tbmima.Clear();
}
con.Close();
}
privatevoidbtcancel_Click(objectsender,EventArgse)
{if(MessageBox.Show("你是否真的想退出系统?
","提示",MessageBoxButtons.YesNo)!
=DialogResult.No)
{this.Close();}
}
privatevoidbutton1_Click(objectsender,EventArgse)
{stringusername=null;
stringpassword=null;
if(tbusername.Text=="")
{MessageBox.Show("你没有输入用户名!
","错误提示");return;
}
if(tbmima.Text=="")
{MessageBox.Show("你没有输入密码!
","错误提示");return;
}
DataSetdst=newDataSet();
stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";
SqlConnectioncon=newSqlConnection
(connstr);
con.Open();
stringstr="select*from登录";
SqlDataAdaptersda=newSqlDataAdapter(str,con);
SqlCommandBuilderscd=newSqlCommand
Builder(sda);
sda.Fill(dst,"tong");
dataGridView1.DataSource=dst.Tables
["tong"].DefaultView;
username=dataGridView1.Rows[0].Cells[0].
Value.ToString().Trim();
password=dataGridView1.Rows[0].Cells[1].
Value.ToString().Trim();
if(tbusername.Text.Equals(username)&&tbmima.Text.Equals(password))
{if(MessageBox.Show("你确定要修改密码吗?
","提示",MessageBoxButtons.YesNo)==DialogResult.Yes)
{修改密码mima=new修改密码();
mima.Visible=true;
}
}
else
{MessageBox.Show("你输入的用户名或密码错误","错误提示");
tbusername.Clear();
tbmima.Clear();
}
con.Close();
}
privatevoidbutton1_Click(objectsender,EventArgse)
{stringusername=null;
stringpassword=null;
if(textBox1.Text=="")
{MessageBox.Show("你没有输入密码!
","错误提示");
return;
}
if(textBox2.Text=="")
{MessageBox.Show("你没有输入更改密码!
","错误提示");return;
}
if(textBox3.Text=="")
{MessageBox.Show("你没有再次输入更改密码!
","错误提示");
return;
}
stringb=textBox2.Text.ToString().Trim();
stringa=textBox3.Text.ToString().Trim();
if(b.Equals(a)==false)
{MessageBox.Show("你两次输入的密码不一样!
","错误提示");return;
}
DataSetdst=newDataSet();
stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";
SqlConnectioncon=newSqlConnection
(connstr);
con.Open();
stringstr="select*from登录";
SqlDataAdaptersda=newSqlDataAdapter(str,con);
SqlCommandBuilderscd=newSqlCommand
Builder(sda);
sda.Fill(dst,"tong");
dataGridView1.DataSource=dst.Tables
["tong"].DefaultView;
username=dataGridView1.Rows[0].Cells[0].
Value.ToString().Trim();
password=dataGridView1.Rows[0].Cells[1].
Value.ToString().Trim();
if(textBox1.Text.Equals(password))
{Stringsql="update登录setmima='"+textBox2.Text.Trim()+"'whereusername='"+username+"'";
Try
{SqlCommandcomm=newSqlCommand(sql,con);
comm.ExecuteNonQuery();
}
catch(Exceptiones)
{MessageBox.Show("修改密码失败!
","提示");
return;
}
}
else
{MessageBox.Show("你输入的密码错误","错误提示");
textBox1.Clear();
return;
}
MessageBox.Show("密码更改成功!
");
textBox1.Clear();
textBox2.Clear();
textBox3.Clear();
con.Close();
}
privatevoidbutton2_Click(objectsender,EventArgse)
{this.Close();}
实现代码如下:
privatevoidbutton6_Click(objectsender,EventArgse)//实现备忘录的查询
{stringstr=null;
if(textBox6.Text!
="")
{str="select*from备忘录where备忘标题='"+textBox6.Text+"'";
textBox6.Clear();
}
else
if(comboBox1.Text!
="")
{stringlei=comboBox1.Text;
if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false)
{MessageBox.Show("你输入的类别不正确,请重新输入!
","错误提示");
return;
}
else
{str="select*from备忘录where备忘类别='"+comboBox1.Text+"'";
comboBox1.Text=null;
}
else
if(textBox7.Text!
="")
{DateTimetime=DateTime.Now;
try
{time=DateTime.Parse(textBox7.Text);}
catch(Exceptions)
{MessageBox.Show("你输入的日期格式不正确","错误提示");
return;
}
str="select*from备忘录whereYEAR(创建时间)=YEAR('"+time+"')andMONTH(创建时间)=MONTH('"+time+"')andDAY(创建时间)=DAY('"+time+"')";
textBox7.Clear();
}
else
{MessageBox.Show("你没有输入要查询的条件","错误提示");
return;
}
DataSetds=newDataSet();
stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";
SqlConnectioncon=newSqlConnection(connstr);;
con.Open();
SqlDataAdaptersda=newSqlDataAdapter(str,con);
SqlCommandBuilderscd=newSqlCommandBuilder(sda);
sda.Fill(ds,"beiwanglu");
dataGridView1.DataSource=ds.Tables["beiwanglu"].DefaultView;dataGridView1.Rows[0].Selected=true;
try
{textBox1.Text=dataGridView1.Rows[0].
Cells[0].Value.ToString().Trim();
textBox2.Text=dataGridView1.Rows[0].
Cells[1].Value.ToString().Trim();
textBox3.Text=dataGridView1.Rows[0].
Cells[2].Value.ToString().Trim();
textBox4.Text=dataGridView1.Rows[0].
Cells[3].Value.ToString().Trim();
textBox5.Text=dataGridView1.Rows[0].
Cells[4].Value.ToString().Trim();
DateTimeshenqing=DateTime.Parse(textBox3.Text);
DateTimetiqing=DateTime.Parse(textBox4.Text);
if(DateTime.Compare(shenqing,tiqing)>0)
rbyes1.Checked=true;
else
rbno1.Checked=true;
}
catch(Exceptionex){MessageBox.Show("没有你要查询的信息!
","查询提示");}
con.Close();
}
introw;
privatevoidbutton3_Click(objectsender,EventArgse)//备忘录下一条的实现
{row=dataGridView1.RowCount;
for(inti=0;i {if(dataGridView1.Rows[i].Selected==true) {this.dataGridView1.Rows[i].Selected=false; if(i==row-2) {dataGridView1.Rows[0].Selected=true; textBox1.Text=dataGridView1.Rows[0]. Cells[0].Value.ToString().Trim(); textBox2.Text=dataGridView1.Rows[0]. Cells[1].Value.ToString().Trim(); textBox3.Text=dataGridView1.Rows[0]. Cells[2].Value.ToString().Trim(); textBox4.Text=dataGridView1.Rows[0]. Cells[3].Value.ToString().Trim(); textBox5.Text=datalls[4].Value. ToString().Trim(); DateTimeshenqing=DateTime.Parse (textBox3.Text); DateTimetiqing=DateTime.Parse (textBox4.Text); if(DateTime.Compare(shenqing,tiqing)>0) rbyes1.Checked=true; else rbno1.Checked=true; } else {dataGridView1.Rows[i+1].Selected=true; textBox1.Text=dataGridView1.Rows[i+1].Cells[0].Value.ToString().Trim(); textBox2.Text=dataGridView1.Rows[i+1].Cells[1].Value.ToString().Trim(); textBox3.Text=dataGridView1.Rows[i+1].Cells[2].Value.ToString().Trim(); textBox4.Text=dataGridView1.Rows[i+1].Cells[3].Value.ToString().Trim(); textBox5.Text=dataGridView1.Rows[i+1].Cells[4].Value.ToString().Trim(); DateTimeshenqing=DateTime.Parse (textBox3.Text); DateTimetiqing=DateTime.Parse (textBox4.Text); if(DateTime.Compare(shenqing,tiqing)>0) rbyes1.Checked=true; else rbno1.Checked=true; } break; } privatevoidbutton2_Click(objectsender,EventArgse)//备忘录上一条的实现 {row=dataGridView1.RowCount; for(inti=0;i {if(dataGridView1.Rows[i].Selected==true) {this.dataGridView1.Rows[i].Selected=false; if(i==0) {dataGridView1.Rows[row-2].Selected=true; textBox1.Text=dataGridView1.Rows[row-2].Cells[0].Value.ToString().Trim(); textBox2.Text=dataGridView1.Rows[row-2].Cells[1].Value.ToString().Trim(); textBox3.Text=dataGridView1.Rows[row-2].Cells[2].Value.ToString().Trim(); textBox4.Text=dataGridView1.Rows[row-2].Cells[3].Value.ToString().Trim(); textBox5.Text=dataGridView1.Rows[row-2].Cells[4].Value.ToString().Trim(); DateTimeshenqing=DateTime.Parse (textBox3.Text); DateTimetiqing=DateTime.Parse (textBox4.Text); if(DateTime.Compare(shenqing,tiqing)>0) rbyes1.Checked=true; else rbno1.Checked=true; } else {dataGridView1.Rows[i-1].Selected=true; textBox1.Text=dataGridView1.Rows[i-1].Cells[0].Value.ToString().Trim(); textBox2.Text=dataGridView1.Rows[i-1].Cells[1].Value.ToString().Trim(); textBox3.Text=dataGridView1.Rows[i-1].Cells[2].Value.ToString().Trim(); textBox4.Text=dataGridView1.Rows[i-1].Cells[3].Value.ToString().Trim(); textBox5.Text=dataGridView1.Rows[i-1].Cells[4].Value.ToString().Trim(); DateTimeshenqing=DateTime.Parse (textBox3.Text); DateTimetiqing=DateTime.Parse (textBox4.Text); if(DateTime.Compare(shenqing,tiqing)>0) rbyes1.Checked=true; else rbno1.Checked=true; } break; } privatevoidbutton7_Click(objectsender,EventArgse)//备忘录的增加 {stringtitle=null; stringneirong=null; DateTimechuang=DateTime.Now; DateTimetixing=DateTime.Now; stringlei=null; if(textBox8.Text=="") {MessageBox.Show("你没有输入备忘录的标题","错误提示"); return; } else if(textBox9.Text=="") {MessageBox.Show("你没有输入备忘录的内容","错误提示"); return; } else if(textBox10.Text=="") {MessageBox.Show("你没有输入备忘录的提示时间","错误提示"); return; } else if(comboBox2.Text=="") {MessageBox.Show("你没有选择备忘录的类别","错误提示"); return; } title=textBox8.Text; neirong=textBox9.Text; try {tixing=DateTime.Parse(textBox10.Text);} catch(Exceptions) {MessageBox.Show("你输入的日期格式不正确","错误提示"); return; } lei
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- 个人 理财 系统