《C#程序设计》课程设计报告-备忘录软件设计

**学院《C#程序设计》课程设计报告课程名称：软件程序设计题目：备忘录软件专业班级： 学生姓名：学号： 指导教师： 设计周数：设计成绩：设计题目：备忘录一、课程设计目的（1）通过本次设计掌握VisualStudio中Windows窗体的建立及窗体中各个控件的使用，以及界面的设计（2）进一步熟悉了所学的C#语言的编程，对编程有了进一步巩固，并提高分析和解决实际问题的能力（3）初步掌握使用VisualStudio建立备忘录软件的这一功能。熟悉了软件的设计，调试的全过程备忘录课程设计是通信工程专业的一门软件实践专业基础课，旨在提高学生的软件编程能力。本设计将进一步加强学生对面向对象程序设计思想的理解，增强对C#程序语言的灵活运用。要求学生能结合数据库知识，网络通信技术，实现基本的应用软件，为以后从事相关行业打下软件编程基础。二、课程设计的要求及内容1设计要求（1）支持多用户，根据用户名和密码进入备忘录；（2）登录用户可完成备忘信息的录入、修改和删除功能；（3）支持登录提醒功能或其它提醒方式。2设计内容（1）根据技术要求和现有开发环境，分析题目（2）软件设计方案。包括：软件功能结构、各功能模块的详细描述、关键程序流程图等。（3）使用C#语言，实现软件；（4）调试、修改并完善程序；（5）生成安装程序，编写软件使用说明书（图文结合进行描述）；（6）撰写课程设计报告。软件的分析与设计1.逻辑层次的设计备忘录的基本结构框图如图1所示打开软件打开软件登陆进入软件界面登陆进入软件界面今日提醒添加备忘删除修改今日提醒添加备忘删除修改备忘存储到数据库退出定时提醒备忘事件备忘存储到数据库退出定时提醒备忘事件图1备忘录基本结果框架窗体设计2.1登录窗体源代码:usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;namespace备忘录{publicpartialclassForm1:Form{publicForm1(){InitializeComponent();}privatevoidbutton1_Click(objectsender,EventArgse){//stringsql="select*fromUserwhereUserName='"+textBox1.Text.Trim().ToLower()+"'andPassWord='"+textBox2.Text.Trim()+"'";stringsql="select*fromTable1whereUserName='"+textBox1.Text.Trim().ToLower()+"'andPassWord='"+textBox2.Text.Trim()+"'";if(OperatorDb.ExecuteReader(sql)){Form3frm=newForm3();frm.Show();this.Hide();}else{MessageBox.Show("用户名或密码错误","出错了",MessageBoxButtons.OK,MessageBoxIcon.Error);}}privatevoidbutton2_Click(objectsender,EventArgse){textBox1.Text="";textBox2.Text="";}privatevoidForm1_Load(objectsender,EventArgse){}privatevoidlabel3_Click(objectsender,EventArgse){}privatevoidlabel4_Click(objectsender,EventArgse){}privatevoidbutton4_Click(objectsender,EventArgse){}privatevoidlabel10_Click(objectsender,EventArgse){}privatevoidtabPage3_Click(objectsender,EventArgse){}privatevoidlabel7_Click(objectsender,EventArgse){}privatevoidtextBox4_TextChanged(objectsender,EventArgse){}privatevoidtextBox5_TextChanged(objectsender,EventArgse){}privatevoidtextBox3_TextChanged(objectsender,EventArgse){}privatevoidlabel9_Click(objectsender,EventArgse){}privatevoidlabel8_Click(objectsender,EventArgse){}privatevoidtextBox1_TextChanged(objectsender,EventArgse){}privatevoidtabPage1_Click(objectsender,EventArgse){}privatevoidlinkLabel1_LinkClicked(objectsender,LinkLabelLinkClickedEventArgse){System.Diagnostics.Process.Start("/jiaozikai");}}}2.2主窗体源代码:usingSystem;usingSystem.Collections.Generic;usingSystem.ComponentModel;usingSystem.Data;usingSystem.Drawing;usingSystem.Text;usingSystem.Windows.Forms;usingSystem.Data.SqlClient;usingSystem.Collections;usingSystem.Diagnostics;usingSystem.IO;usingSystem.Threading;usingMicrosoft.Win32;usingSystem.Runtime.InteropServices;namespace备忘录{publicpartialclassForm3:Form{publicForm3(){InitializeComponent();}[DllImport("winmm")]publicstaticexternboolPlaySound(stringszSound,IntPtrhMod,inti);//声明API:PlaySound///<summary>///数据绑定///</summary>voidBindData(){stringsql="selecttimeas时间,eventas备忘fromTable2";SqlConnectionconn=newSqlConnection(OperatorDb.ConnString);conn.Open();SqlCommandcmd=newSqlCommand(sql,conn);da.SelectCommand=cmd;da.Fill(ds);dataGridView1.DataSource=ds.Tables[0];conn.Close();}privatevoidForm3_Load(objectsender,EventArgse){for(inti=0;i<60;i++){comboBox2.Items.Add(i.ToString());comboBox3.Items.Add(i.ToString());}for(inti=0;i<=24;i++)comboBox1.Items.Add(i.ToString());comboBox1.SelectedIndex=0;comboBox2.SelectedIndex=0;comboBox3.SelectedIndex=0;{BindData();}}privatevoiddataGridView1_CellContentClick(objectsender,DataGridViewCellEventArgse){}SqlDataAdapterda=newSqlDataAdapter();DataSetds=newDataSet();privatevoidbutton1_Click(objectsender,EventArgse){}privatevoidbutton6_Click(objectsender,EventArgse){SqlCommandBuildercb=newSqlCommandBuilder(da);da.Update(ds);MessageBox.Show("修改成功！");}privatevoidbutton4_Click_1(objectsender,EventArgse){DialogResultdlResult=MessageBox.Show(this,"要删除这些信息吗？","请确认",MessageBoxButtons.YesNo,MessageBoxIcon.Question);if(dlResult==DialogResult.Yes){intj=dataGridView1.SelectedRows.Count;int[]l=newint[j];inti;for(i=0;i<j;i++){l[i]=dataGridView1.SelectedRows[i].Index;}intk=0;while(k<j){ds.Tables[0].Rows[l[k]].Delete();k++;}SqlCommandBuildercb=newSqlCommandBuilder(da);da.Update(ds);}}privatevoidbutton1_Click_1(objectsender,EventArgse){stringsql="insertintoTable2(time,event)values('"+dateTimePicker1.Value+"','"+richTextBox1.Text+"')";try{if(OperatorDb.ExecuteNonQuery(sql)==1){MessageBox.Show("添加成功！");stringconnString=@"DataSource=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\beiwanglu.mdf;IntegratedSecurity=True;ConnectTimeout=30;UserInstance=True";SqlConnectionconn=newSqlConnection(connString);SqlDataAdapterda=newSqlDataAdapter();DataSetds=newDataSet();SqlCommandcmd=newSqlCommand("select*fromTable2",conn);da.SelectCommand=cmd;da.Fill(ds);dataGridView1.DataSource=ds.Tables[0];conn.Close();}else{MessageBox.Show("添加失败！");}}catch{MessageBox.Show("数据不能重复！");}}stringtemp;privatevoidtimer1_Tick(objectsender,EventArgse){temp=(System.DateTime.Now.Hour.ToString()+System.DateTime.Now.Minute.ToString()+System.DateTime.Now.Second.ToString());label1.Text=System.DateTime.Now.ToString();if(colock==temp){PlaySound(@"/.wav",IntPtr.Zero,0);MessageBox.Show("时间到了亲，该执行备忘事件了");Form3frm=newForm3();frm.Show();this.Hide();}}privatevoidbutton5_Click(objectsender,EventArgse){Application.Exit();}privatevoidbutton2_Click(objectsender,EventArgse){this.WindowState=FormWindowState.Minimized;}privatevoidgroupBox1_Enter(objectsender,EventArgse){}privateboolm_isMouseDown=false;privatePointm_mousePos=newPoint();protectedoverridevoidOnMouseDown(MouseEventArgse){base.OnMouseDown(e);m_mousePos=Cursor.Position;m_isMouseDown=true;}protectedoverridevoidOnMouseUp(MouseEventArgse){base.OnMouseUp(e);m_isMouseDown=false;}protectedoverridevoidOnMouseMove(MouseEventArgse){base.OnMouseMove(e);if(m_isMouseDown){PointtempPos=Cursor.Position;this.Location=newPoint(Location.X+(tempPos.X-m_mousePos.X),Location.Y+(tempPos.Y-m_mousePos.Y));m_mousePos=Cursor.Position;}}stringcolock;privatevoidbutton3_Click(objectsender,EventArgse){colock=(comboBox1.Text+comboBox2.Text+comboBox3.Text);}privatevoidbeiwangluDataSetBindingSource_CurrentChanged(objectsender,EventArgse){}privatevoidlinkLabel1_LinkClicked(objectsender,LinkLabelLinkClickedEventArgse){System.Diagnostics.Process.Start("/jiaozikai");}privatevoidrichTextBox1_TextChanged(objectsender,EventArgse){}}}运行