个人理财系统

-.z.-.z.privatevoidbtlogin_Click(objectsender,EventArgse){stringusername=null;stringpassword=null;if(tbusername.Te*t==""){MessageBo*.Show("你没有输入用户名！","错误提示");return;}if(tbmima.Te*t==""){MessageBo*.Show("你没有输入密码！","错误提示");return;}DataSetdst=newDataSet();stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);con.Open();stringstr="select*from登录";SqlDataAdaptersda=newSqlDataAdapter(str,con);SqlmandBuilderscd=newSqlmandBuilder(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.Te*t.Equals(username)&&tbmima.Te*t.Equals(password)){Form2f2=newForm2();f2.Visible=true;this.Visible=false;}else{MessageBo*.Show("你输入的用户名或密码错误","错误提示");tbusername.Clear();tbmima.Clear();}con.Close();}privatevoidbtcancel_Click(objectsender,EventArgse){if(MessageBo*.Show("你是否真的想退出系统？","提示",MessageBo*Buttons.YesNo)!=DialogResult.No){this.Close();}}privatevoidbutton1_Click(objectsender,EventArgse){stringusername=null;stringpassword=null;if(tbusername.Te*t==""){MessageBo*.Show("你没有输入用户名！","错误提示");return;}if(tbmima.Te*t==""){MessageBo*.Show("你没有输入密码！","错误提示");return;}DataSetdst=newDataSet();stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);con.Open();stringstr="select*from登录";SqlDataAdaptersda=newSqlDataAdapter(str,con);SqlmandBuilderscd=newSqlmandBuilder(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.Te*t.Equals(username)&&tbmima.Te*t.Equals(password)){if(MessageBo*.Show("你确定要修改密码吗？","提示",MessageBo*Buttons.YesNo)==DialogResult.Yes){修改密码mima=new修改密码();mima.Visible=true;}}else{MessageBo*.Show("你输入的用户名或密码错误","错误提示");tbusername.Clear();tbmima.Clear();}con.Close();}-.z.-.z.privatevoidbutton1_Click(objectsender,EventArgse){stringusername=null;stringpassword=null;if(te*tBo*1.Te*t==""){MessageBo*.Show("你没有输入密码！","错误提示");return;}if(te*tBo*2.Te*t==""){MessageBo*.Show("你没有输入更改密码！","错误提示");return;}if(te*tBo*3.Te*t==""){MessageBo*.Show("你没有再次输入更改密码！","错误提示");return;}stringb=te*tBo*2.Te*t.ToString().Trim();stringa=te*tBo*3.Te*t.ToString().Trim();if(b.Equals(a)==false){MessageBo*.Show("你两次输入的密码不一样！","错误提示");return;}DataSetdst=newDataSet();stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);con.Open();stringstr="select*from登录";SqlDataAdaptersda=newSqlDataAdapter(str,con);SqlmandBuilderscd=newSqlmandBuilder(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(te*tBo*1.Te*t.Equals(password)){Stringsql="update登录setmima='"+te*tBo*2.Te*t.Trim()+"'whereusername='"+username+"'";Try{Sqlmandm=newSqlmand(sql,con);m.E*ecuteNonQuery();}catch(E*ceptiones){MessageBo*.Show("修改密码失败！","提示");return;}}else{MessageBo*.Show("你输入的密码错误","错误提示");te*tBo*1.Clear();return;}MessageBo*.Show("密码更改成功！");te*tBo*1.Clear();te*tBo*2.Clear();te*tBo*3.Clear();con.Close();}privatevoidbutton2_Click(objectsender,EventArgse){this.Close();}-.z.-.z.实现代码如下：privatevoidbutton6_Click(objectsender,EventArgse)//实现备忘录的查询{stringstr=null;if(te*tBo*6.Te*t!=""){str="select*from备忘录where备忘标题='"+te*tBo*6.Te*t+"'";te*tBo*6.Clear();}elseif(boBo*1.Te*t!=""){stringlei=boBo*1.Te*t;if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false){MessageBo*.Show("你输入的类别不正确,请重新输入！","错误提示");return;}else{str="select*from备忘录where备忘类别='"+boBo*1.Te*t+"'";boBo*1.Te*t=null;}elseif(te*tBo*7.Te*t!=""){DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*7.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}str="select*from备忘录whereYEAR(创立时间)=YEAR('"+time+"')andMONTH(创立时间)=MONTH('"+time+"')andDAY(创立时间)=DAY('"+time+"')";te*tBo*7.Clear();}else{MessageBo*.Show("你没有输入要查询的条件","错误提示");return;}DataSetds=newDataSet();stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);;con.Open();SqlDataAdaptersda=newSqlDataAdapter(str,con);SqlmandBuilderscd=newSqlmandBuilder(sda);sda.Fill(ds,"beiwanglu");dataGridView1.DataSource=ds.Tables["beiwanglu"].DefaultView;dataGridView1.Rows[0].Selected=true;try{te*tBo*1.Te*t=dataGridView1.Rows[0].Cells[0].Value.ToString().Trim();te*tBo*2.Te*t=dataGridView1.Rows[0].Cells[1].Value.ToString().Trim();te*tBo*3.Te*t=dataGridView1.Rows[0].Cells[2].Value.ToString().Trim();te*tBo*4.Te*t=dataGridView1.Rows[0].Cells[3].Value.ToString().Trim();te*tBo*5.Te*t=dataGridView1.Rows[0].Cells[4].Value.ToString().Trim();DateTimeshenqing=DateTime.Parse(te*tBo*3.Te*t);DateTimetiqing=DateTime.Parse(te*tBo*4.Te*t);if(DateTime.pare(shenqing,tiqing)>0)rbyes1.Checked=true;elserbno1.Checked=true;}catch(E*ceptione*){MessageBo*.Show("没有你要查询的信息！","查询提示");}con.Close();}introw;privatevoidbutton3_Click(objectsender,EventArgse)//备忘录下一条的实现{row=dataGridView1.RowCount;for(inti=0;i<row-1;i++){if(dataGridView1.Rows[i].Selected==true){this.dataGridView1.Rows[i].Selected=false;if(i==row-2){dataGridView1.Rows[0].Selected=true;te*tBo*1.Te*t=dataGridView1.Rows[0].Cells[0].Value.ToString().Trim();te*tBo*2.Te*t=dataGridView1.Rows[0].Cells[1].Value.ToString().Trim();te*tBo*3.Te*t=dataGridView1.Rows[0].Cells[2].Value.ToString().Trim();te*tBo*4.Te*t=dataGridView1.Rows[0].Cells[3].Value.ToString().Trim();te*tBo*5.Te*t=datalls[4].Value.ToString().Trim();DateTimeshenqing=DateTime.Parse(te*tBo*3.Te*t);DateTimetiqing=DateTime.Parse(te*tBo*4.Te*t);if(DateTime.pare(shenqing,tiqing)>0)rbyes1.Checked=true;elserbno1.Checked=true;}else{dataGridView1.Rows[i+1].Selected=true;te*tBo*1.Te*t=dataGridView1.Rows[i+1].Cells[0].Value.ToString().Trim();te*tBo*2.Te*t=dataGridView1.Rows[i+1].Cells[1].Value.ToString().Trim();te*tBo*3.Te*t=dataGridView1.Rows[i+1].Cells[2].Value.ToString().Trim();te*tBo*4.Te*t=dataGridView1.Rows[i+1].Cells[3].Value.ToString().Trim();te*tBo*5.Te*t=dataGridView1.Rows[i+1].Cells[4].Value.ToString().Trim();DateTimeshenqing=DateTime.Parse(te*tBo*3.Te*t);DateTimetiqing=DateTime.Parse(te*tBo*4.Te*t);if(DateTime.pare(shenqing,tiqing)>0)rbyes1.Checked=true;elserbno1.Checked=true;}break;}privatevoidbutton2_Click(objectsender,EventArgse)//备忘录上一条的实现{row=dataGridView1.RowCount;for(inti=0;i<row-1;i++){if(dataGridView1.Rows[i].Selected==true){this.dataGridView1.Rows[i].Selected=false;if(i==0){dataGridView1.Rows[row-2].Selected=true;te*tBo*1.Te*t=dataGridView1.Rows[row-2].Cells[0].Value.ToString().Trim();te*tBo*2.Te*t=dataGridView1.Rows[row-2].Cells[1].Value.ToString().Trim();te*tBo*3.Te*t=dataGridView1.Rows[row-2].Cells[2].Value.ToString().Trim();te*tBo*4.Te*t=dataGridView1.Rows[row-2].Cells[3].Value.ToString().Trim();te*tBo*5.Te*t=dataGridView1.Rows[row-2].Cells[4].Value.ToString().Trim();DateTimeshenqing=DateTime.Parse(te*tBo*3.Te*t);DateTimetiqing=DateTime.Parse(te*tBo*4.Te*t);if(DateTime.pare(shenqing,tiqing)>0)rbyes1.Checked=true;elserbno1.Checked=true;}else{dataGridView1.Rows[i-1].Selected=true;te*tBo*1.Te*t=dataGridView1.Rows[i-1].Cells[0].Value.ToString().Trim();te*tBo*2.Te*t=dataGridView1.Rows[i-1].Cells[1].Value.ToString().Trim();te*tBo*3.Te*t=dataGridView1.Rows[i-1].Cells[2].Value.ToString().Trim();te*tBo*4.Te*t=dataGridView1.Rows[i-1].Cells[3].Value.ToString().Trim();te*tBo*5.Te*t=dataGridView1.Rows[i-1].Cells[4].Value.ToString().Trim();DateTimeshenqing=DateTime.Parse(te*tBo*3.Te*t);DateTimetiqing=DateTime.Parse(te*tBo*4.Te*t);if(DateTime.pare(shenqing,tiqing)>0)rbyes1.Checked=true;elserbno1.Checked=true;}break;}privatevoidbutton7_Click(objectsender,EventArgse)//备忘录的增加{stringtitle=null;stringneirong=null;DateTimechuang=DateTime.Now;DateTimeti*ing=DateTime.Now;stringlei=null;if(te*tBo*8.Te*t==""){MessageBo*.Show("你没有输入备忘录的标题","错误提示");return;}elseif(te*tBo*9.Te*t==""){MessageBo*.Show("你没有输入备忘录的内容","错误提示");return;}elseif(te*tBo*10.Te*t==""){MessageBo*.Show("你没有输入备忘录的提示时间","错误提示");return;}elseif(boBo*2.Te*t==""){MessageBo*.Show("你没有选择备忘录的类别","错误提示");return;}title=te*tBo*8.Te*t;neirong=te*tBo*9.Te*t;try{ti*ing=DateTime.Parse(te*tBo*10.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}lei=boBo*2.Te*t;if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false){MessageBo*.Show("你输入的类别不正确,请重新输入！","错误提示");return;}stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);;con.Open();stringstr="select*from备忘录";SqlDataAdaptersda=newSqlDataAdapter(str,con);SqlmandBuilderscd=newSqlmandBuilder(sda);DataSetds=newDataSet();sda.Fill(ds,"tianjia");DataRownewdr=ds.Tables["tianjia"].NewRow();newdr[0]=title;newdr[1]=neirong;newdr[2]=chuang;newdr[3]=ti*ing;newdr[4]=lei;ds.Tables["tianjia"].Rows.Add(newdr);try{sda.Update(ds.Tables["tianjia"]);}catch(E*ceptionen){MessageBo*.Show("备忘录已存在");return;}MessageBo*.Show("增加用户成功！","提示");te*tBo*8.Clear();te*tBo*9.Clear();te*tBo*10.Clear();boBo*2.Te*t="";con.Close();}privatevoidbutton4_Click(objectsender,EventArgse)//备忘录的修改{修改备忘录*iu=new修改备忘录();*iu.Visible=true;}-.z.-.z.代码实现：privatevoidbutton2_Click(objectsender,EventArgse)//实现备忘录的删除{stringstr=null;if(te*tBo*1.Te*t!=""&&te*tBo*2.Te*t==""&&boBo*2.Te*t==""){str="deletefrom备忘录where备忘标题='"+te*tBo*1.Te*t+"'";te*tBo*1.Clear();}elseif(te*tBo*1.Te*t==""&&te*tBo*2.Te*t!=""&&boBo*2.Te*t==""){DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*2.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}str="deletefrom备忘录where提醒时间='"+te*tBo*2.Te*t+"'";te*tBo*2.Clear();}elseif(te*tBo*1.Te*t==""&&te*tBo*2.Te*t==""&&boBo*2.Te*t!=""){stringlei=boBo*2.Te*t;if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false){MessageBo*.Show("你输入的类别不正确,请重新输入！","错误提示");return;}else{str="deletefrom备忘录where备忘类别='"+boBo*2.Te*t+"'";boBo*2.Te*t=null;}}elseif(te*tBo*1.Te*t!=""&&te*tBo*2.Te*t!=""&&boBo*2.Te*t==""){DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*2.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}str="deletefrom备忘录where提醒时间='"+te*tBo*2.Te*t+"'and备忘标题='"+te*tBo*1.Te*t+"'";te*tBo*1.Clear();te*tBo*2.Clear();}elseif(te*tBo*1.Te*t!=""&&te*tBo*2.Te*t==""&&boBo*2.Te*t!=""){stringlei=boBo*2.Te*t;if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false){MessageBo*.Show("你输入的类别不正确,请重新输入！","错误提示");return;}else{str="deletefrom备忘录where备忘类别='"+boBo*2.Te*t+"'and备忘标题='"+te*tBo*1.Te*t+"'";boBo*2.Te*t=null;te*tBo*1.Clear();}elseif(te*tBo*1.Te*t==""&&te*tBo*2.Te*t!=""&&boBo*2.Te*t!=""){stringlei=boBo*2.Te*t;if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false){MessageBo*.Show("你输入的类别不正确,请重新输入！","错误提示");return;}else{DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*2.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}str="deletefrom备忘录where备忘类别='"+boBo*2.Te*t+"'and提醒时间='"+te*tBo*2.Te*t+"'";boBo*2.Te*t=null;te*tBo*2.Clear();}elseif(te*tBo*1.Te*t!=""&&te*tBo*2.Te*t!=""&&boBo*2.Te*t!=""){stringlei=boBo*2.Te*t;if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false){MessageBo*.Show("你输入的类别不正确,请重新输入！","错误提示");return;}else{DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*2.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}str="deletefrom备忘录where备忘类别='"+boBo*2.Te*t+"'and提醒时间='"+te*tBo*2.Te*t+"'and备忘标题='"+te*tBo*1.Te*t+"'";boBo*2.Te*t=null;te*tBo*2.Clear();te*tBo*1.Clear();}else{MessageBo*.Show("你没有输入要删除的条件","错误提示");return;}stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);con.Open();try{Sqlmandm=newSqlmand(str,con);m.E*ecuteNonQuery();}catch(E*ceptione*){MessageBo*.Show("没有找到你要删除的信息","错误提示");return;}MessageBo*.Show("信息删除成功！","提示");con.Close();}privatevoidbutton1_Click(objectsender,EventArgse)//备忘录的修改{stringstr=null;stringtitle=te*tBo*3.Te*t;if(te*tBo*3.Te*t==""){MessageBo*.Show("你没有输入要修改的标题","错误提示");return;}elseif(te*tBo*4.Te*t!=""&&te*tBo*5.Te*t==""&&boBo*1.Te*t==""){str="update备忘录set备忘内容='"+te*tBo*4.Te*t+"'where备忘标题='"+title+"'";te*tBo*4.Clear();}elseif(te*tBo*4.Te*t==""&&te*tBo*5.Te*t!=""&&boBo*1.Te*t==""){DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*5.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}str="update备忘录set提醒时间='"+te*tBo*5.Te*t+"'where备忘标题='"+title+"'";te*tBo*5.Clear();}elseif(te*tBo*4.Te*t==""&&te*tBo*5.Te*t==""&&boBo*1.Te*t!=""){stringlei=boBo*1.Te*t;if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false)MessageBo*.Show("你输入的类别不正确,请重新输入！","错误提示");return;}else{str="update备忘录set备忘类别='"+boBo*1.Te*t+"'where备忘标题='"+title+"'";boBo*1.Te*t=null;}}elseif(te*tBo*4.Te*t!=""&&te*tBo*5.Te*t!=""&&boBo*1.Te*t==""){DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*5.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}str="update备忘录set备忘内容='"+te*tBo*4.Te*t+"',提醒时间='"+te*tBo*5.Te*t+"'where备忘标题='"+title+"'";te*tBo*4.Clear();te*tBo*5.Clear();}elseif(te*tBo*4.Te*t!=""&&te*tBo*5.Te*t==""&&boBo*1.Te*t!=""){stringlei=boBo*1.Te*t;if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false){MessageBo*.Show("你输入的类别不正确,请重新输入！","错误提示");return;}else{str="update备忘录set备忘内容='"+te*tBo*4.Te*t+"',备忘类别='"+boBo*1.Te*t+"'where备忘标题='"+title+"'";boBo*1.Te*t=null;te*tBo*4.Clear();}elseif(te*tBo*4.Te*t==""&&te*tBo*5.Te*t!=""&&boBo*1.Te*t!=""){stringlei=boBo*1.Te*t;if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false){MessageBo*.Show("你输入的类别不正确,请重新输入！","错误提示");return;}else{DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*5.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}str="update备忘录set提醒时间='"+te*tBo*5.Te*t+"',备忘类别='"+boBo*1.Te*t+"'where备忘标题='"+title+"'";boBo*1.Te*t=null;te*tBo*5.Clear();}elseif(te*tBo*4.Te*t!=""&&te*tBo*5.Te*t!=""&&boBo*1.Te*t!=""){stringlei=boBo*1.Te*t;if(lei.Equals("日程表")==false&&lei.Equals("纪念日")==false&&lei.Equals("记事本")==false&&lei.Equals("节日")==false&&lei.Equals("备忘录")==false){MessageBo*.Show("你输入的类别不正确,请重新输入！","错误提示");return;}else{DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*5.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}str="update备忘录set备忘内容='"+te*tBo*4.Te*t+"',提醒时间='"+te*tBo*5.Te*t+"',备忘类别='"+boBo*1.Te*t+"'where备忘标题='"+title+"'";boBo*1.Te*t=null;te*tBo*4.Clear();te*tBo*5.Clear();}stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);con.Open();try{Sqlmandm=newSqlmand(str,con);m.E*ecuteNonQuery();}catch(E*ceptione*){MessageBo*.Show("没有找到你要修改的信息","错误提示");return;}MessageBo*.Show("信息修改成功！","提示");con.Close();}-.z.-.z.代码的实现如下：privatevoidbutton15_Click(objectsender,EventArgse)//显示全部费用{DataSetdst=newDataSet();stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);con.Open();stringstr="select*from个人理财";SqlDataAdaptersda=newSqlDataAdapter(str,con);SqlmandBuilderscd=newSqlmandBuilder(sda);sda.Fill(dst,"cai");dataGridView2.DataSource=dst.Tables["cai"].DefaultView;con.Close();}privatevoidbutton9_Click(objectsender,EventArgse)//实现查询费用下一条{row=dataGridView2.RowCount;for(inti=0;i<row-1;i++){if(dataGridView2.Rows[i].Selected==true){dataGridView2.Rows[i].Selected=false;if(i==row-2){dataGridView2.Rows[0].Selected=true;}elsedataGridView2.Rows[i+1].Selected=true;break;}privatevoidbutton8_Click(objectsender,EventArgse)//实现费用查询的上一条{row=this.dataGridView2.RowCount;for(inti=0;i<row-1;i++){if(this.dataGridView2.Rows[i].Selected==true){this.dataGridView2.Rows[i].Selected=false;if(i==0)this.dataGridView2.Rows[row-2].Selected=true;elsethis.dataGridView2.Rows[i-1].Selected=true;break;}}privatevoidbutton10_Click(objectsender,EventArgse)//费用的删除{查询个人理财cha*un=new查询个人理财();cha*un.Visible=true;}privatevoidbutton13_Click(objectsender,EventArgse)//添加个人费用{if(te*tBo*11.Te*t==""){MessageBo*.Show("你没有输入费用名称！","错误提示");return;}elseif(te*tBo*12.Te*t==""){MessageBo*.Show("你没有输入费用","错误提示");return;}elseif(te*tBo*14.Te*t==""){MessageBo*.Show("你没有输入备忘录的提示时间","错误提示");return;}DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*14.Te*t);}catch(E*ceptions){MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}DataSetdst=newDataSet();stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);;con.Open();stringname=null;intdanjia=0;stringbeizhu=null;DateTimedate=DateTime.Now;stringlei*ing="支出";name=te*tBo*11.Te*t;try{danjia=int.Parse(te*tBo*12.Te*t.Trim());}catch(E*ceptiond){MessageBo*.Show("你输入的单价信息错误！","提示");}beizhu=te*tBo*13.Te*t.Trim();date=Convert.ToDateTime(te*tBo*14.Te*t.Trim());if(rbshouru.Checked==true)lei*ing="收入";if(MessageBo*.Show("你确定要添加此信息吗","提示",MessageBo*Buttons.YesNo)==DialogResult.Yes){try{stringinsert="insertinto个人理财values('"+name+"',"+danjia+",'"+lei*ing+"',"+date.ToShortDateString()+",'"+beizhu+"')";Sqlmandm=newSqlmand(insert,con);m.E*ecuteNonQuery();}catch(E*ceptione*){MessageBo*.Show(e*.Message+"添加用户失败","错误提示");return;}}MessageBo*.Show("添加信息成功","提示");button15_Click(sender,e);con.Close();}privatevoidbutton11_Click(objectsender,EventArgse)//修改个人理财信息{修改个人理财信息licai=new修改个人理财信息();licai.Visible=true;}privatevoidbutton14_Click(objectsender,EventArgse)//退出此界面{this.Close();}privatevoidbutton12_Click(objectsender,EventArgse)//总计的实现{理财总计zongji=new理财总计();zongji.Visible=true;}-.z.-.z.privatevoidbutton1_Click(objectsender,EventArgse)//查询个人理财信息{stringstr=null;if(te*tBo*1.Te*t!=""){str="select*from个人理财where费用名称='"+te*tBo*1.Te*t+"'";te*tBo*1.Clear();}elseif(te*tBo*2.Te*t!=""&&te*tBo*3.Te*t!=""){inta=int.Parse(te*tBo*2.Te*t.Trim());intb=int.Parse(te*tBo*3.Te*t.Trim());if(a<b)str="select*from个人理财where费用between"+a+"and"+b+"";elsestr="select*from个人理财where费用between"+b+"and"+a+"";te*tBo*2.Clear();te*tBo*3.Clear();}elseif(rbshou.Checked==true||rbzhi.Checked==true){stringlei=null;if(rbshou.Checked==true)lei="收入";elselei="支出";str="select*from个人理财where费用类型='"+lei+"'";}elseif(te*tBo*4.Te*t!=""){DateTimetime=DateTime.Now;try{time=DateTime.Parse(te*tBo*4.Te*t);}catch(E*ceptions{MessageBo*.Show("你输入的日期格式不正确","错误提示");return;}str="select*from备忘录whereYEAR(时间)=YEAR('"+time+"')andMONTH(时间)=MONTH('"+time+"')andDAY(时间)=DAY('"+time+"')";te*tBo*4.Clear();}else{MessageBo*.Show("你没有输入要查询的条件","错误提示");return;}-.z.DataSetdst=newDataSet();stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);;con.Open();SqlDataAdaptersda=newSqlDataAdapter(str,con);SqlmandBuilderscd=newSqlmandBuilder(sda);sda.Fill(dst,"cai");dataGridView1.DataSource=dst.Tables["cai"].DefaultView;con.Close();}privatevoidbutton2_Click(objectsender,EventArgse)//退出此界面{this.Close();}-.z.实现代码如下：-.z.privatevoidbutton1_Click(objectsender,EventArgse)//修改个人理财{stringstr=null;stringleibie=null;Stringfname=te*tBo*1.Te*t.Trim();if(rbnshouru.Checked==true)leibie="收入";elseif(rbnzhichu.Checked==true)leibie="支出";if(te*tBo*1.Te*t==""){MessageBo*.Show("你没有输入要修改的标题","错误提示");return;}elseif(te*tBo*2.Te*t!=""&&leibie==null&&te*tBo*3.Te*t==""&&te*tBo*4.Te*t==""){intfeiyong=0;feiyong=int.Parse(te*tBo*2.Te*t.Trim());str="update个人理财set费用="+feiyong+"where费用名称='"+fname+"'";te*tBo*2.Clear();}elseif(te*tBo*2.Te*t==""&&leibie!=null&&te*tBo*3.Te*t==""&&te*tBo*4.Te*t==""){str="update个人理财set费用类型='"+leibie+"'where费用名称='"+fname+"'";rbnshouru.Checked=false;rbnzhichu.Checked=false;}elseif(te*tBo*2.Te*t==""&&leibie==null&&te*tBo*3.Te*t!=""&&te*tBo*4.Te*t==""){DateTimetime=DateTime.Parse(te*tBo*3.Te*t.Trim());str="update个人理财set时间="+time+"where费用名称='"+fname+"'";te*tBo*3.Clear();}elseif(te*tBo*2.Te*t==""&&leibie==null&&te*tBo*3.Te*t==""&&te*tBo*4.Te*t!=""){str="update个人理财set备注='"+te*tBo*4.Te*t.Trim()+"'where费用名称='"+fname+"'";te*tBo*4.Clear();}else{MessageBo*.Show("你没有输入要修改的内容","错误提示");return;}stringconnstr="DataSource=(local);InitialCatalog=Message;IntegratedSecurity=True";SqlConnectioncon=newSqlConnection(connstr);con.Open();if(MessageBo*.Show("你确定要修改此信息吗？","提示",MessageBo*Buttons.YesNo)==DialogResult.Yes){try{Sqlmandm=newSqlmand(str,con);m.E*ecuteNonQuery();}catch(E*ceptione*){MessageBo*.Show("没有找到你要修改的信息","错误提示");return;}MessageBo*.Show("信息修改成功！","提示");}con.Close();}privatevoidbutton4_Click(objectsender,EventArgse)//删除个人理财{stringstr=null;inta=0;intb=0;stringlei=null;if(rbnshou.Checked==true)lei="收入";elseif(rbnzhi.Checked==true)lei="支出";DateTimetime=DateTime.Now;if(te*tBo*5.Te*t!=""&&te*tBo*6.Te*t==""&&te*tBo*8.Te*t==""&&lei==null){str="deletefrom个人理财where费用名称='"+te*tBo*5.Te*t.Trim()+"'";te*tBo*5.Clear();}elseif(te*tBo*5.Te*t==""&&lei==null&&te*tBo*6.Te*t!=""&&te*tBo*7.Te*t!=""&&te*tBo*8.Te*t==""){a=int.Parse(te*tBo*6.Te*t.Trim());b=int.Parse(te*tB