//菜单点击事件 private void menu_click(object sender, RoutedEventArgs e) { if (sender == add)//新增 { New_Click(sender, e); } else if (sender == delete)//删除 { Delete_Click(sender, e); } else if (sender == search)//查询 { Search_Click(sender, e); } else if (sender == changeUser)//切换用户 { MessageBoxResult msg = MessageBox.Show("你确定要切换用户?", "提示", MessageBoxButton.YesNo); if (msg == MessageBoxResult.Yes) { Login mLogin = new Login(); mLogin.Show(); Close(); } } else if (sender == exit)//退出系统 { MessageBoxResult msg = MessageBox.Show("你确定要退出系统?", "提示", MessageBoxButton.YesNo); if (msg == MessageBoxResult.Yes) { Close(); } } else if (sender == dataImport)//数据库导入 { Microsoft.Win32.OpenFileDialog ofd = new Microsoft.Win32.OpenFileDialog(); ofd.DefaultExt = ".accdb"; ofd.Filter = "Access|*.accdb"; ofd.Title = "导入Access数据库"; if (ofd.ShowDialog() == true) { string path_import = ofd.FileName; string path_data = "APP_Data/FFMS.accdb"; if (DataImport(path_import, path_data)) { MessageBox.Show("数据库导入成功"); } else { MessageBox.Show("数据库导入失败"); } } } else if (sender == dataBackup)//数据库备份 { string path_data = "APP_Data/FFMS.accdb"; string path_back = "APP_Data/FFMS_bat.accdb"; if (Backup(path_data, path_back)) { MessageBox.Show("数据库备份成功"); } else { MessageBox.Show("数据库备份失败"); } } else if (sender == dataRecover)//数据库还原 { string path_back = "APP_Data/FFMS_bat.accdb"; string path_data = "APP_Data/FFMS.accdb"; if (RecoverAccess(path_back, path_data)) { MessageBox.Show("数据库还原成功"); } else { MessageBox.Show("数据库还原失败"); } } else if (sender == payExport)//导出支出明细Excel { ExportExcel.ExportToExcel(pay_data); } else if (sender == incomeExport)//导出收入明细Excel { ExportExcel.ExportToExcel(income_data); } else if (sender == accessExport)//导出月度统计Excel { //ExportExcel.ExportToExcel(count_data); } else if (sender == pay)//支出明细 { tab.SelectedIndex = 0; } else if (sender == income)//收入明细 { tab.SelectedIndex = 1; } else if (sender == count)//月度统计 { tab.SelectedIndex = 2; } else if (sender == assets)//家庭财产 { Information info = new Information(getAssets()); info.Title = "家庭财产"; info.Show(); } else if (sender == budget)//每月预算 { new MonNote().Show(); } else if (sender == alterInfo)//修改资料 { AlterInfo alter = new AlterInfo(name); alter.Title = "修改资料"; alter.Show(); } else if (sender == deleteUser)//删除成员 { new DeleteMember().ShowDialog(); //重新刷新datagrid init_dataGrid(); } else if (sender == message)//提醒信息 { Information info = new Information(getMessage()); info.Title = "提醒信息"; info.Show(); } else if (sender == function)//功能介绍 { String infomation = "1.收支明细,记录了所有的收支信息\n" +"2.月度统计,统计了当前月的收支统计\n" +"3.数据部分,可以导入数据库,导出数据库及数据库备份,并且还可以导出支出明细,收入明细,月度统计的Excel\n" +"4.家庭财产统计了所有月的净收入,上个月的总支出及当前月的目前支出\n" +"5.每月记事,功能强大,可以查询某年某月的记事,可以增加当前月的记事,还有当记事内容被删掉"; Information info = new Information(infomation); info.Title = "功能介绍"; info.Show(); } else if (sender == calculator)//计算器 { Calculator mCalculator = new Calculator(); mCalculator.Show(); } else if (sender == about)//关于 { String infomation = " 该软件由学生小组完成,并且是免费的。感谢你的使用!如果有好的建议,可以把建议发到邮箱[email protected]。"; Information info = new Information(infomation); info.Title = "关于"; info.Show(); } }
//菜单点击事件 private void menu_click(object sender, RoutedEventArgs e) { if (sender == add)//新增 { New_Click(sender, e); } else if (sender == delete)//删除 { Delete_Click(sender, e); } else if (sender == search)//查询 { Search_Click(sender, e); } else if (sender == changeUser)//切换用户 { MessageBoxResult msg = MessageBox.Show("你确定要切换用户?", "提示", MessageBoxButton.YesNo); if (msg == MessageBoxResult.Yes) { Login mLogin = new Login(); mLogin.Show(); Close(); } } else if (sender == exit)//退出系统 { MessageBoxResult msg = MessageBox.Show("你确定要退出系统?", "提示", MessageBoxButton.YesNo); if (msg == MessageBoxResult.Yes) { Close(); } } else if (sender == dataImport)//数据库导入 { Microsoft.Win32.OpenFileDialog ofd = new Microsoft.Win32.OpenFileDialog(); ofd.DefaultExt = ".accdb"; ofd.Filter = "Access|*.accdb"; ofd.Title = "导入Access数据库"; if (ofd.ShowDialog() == true) { string path_import = ofd.FileName; string path_data = "APP_Data/FFMS.accdb"; if (DataImport(path_import, path_data)) { MessageBox.Show("数据库导入成功"); } else { MessageBox.Show("数据库导入失败"); } } } else if (sender == dataBackup)//数据库备份 { string path_data = "APP_Data/FFMS.accdb"; string path_back = "APP_Data/FFMS_bat.accdb"; if (Backup(path_data, path_back)) { MessageBox.Show("数据库备份成功"); } else { MessageBox.Show("数据库备份失败"); } } else if (sender == dataRecover)//数据库还原 { string path_back = "APP_Data/FFMS_bat.accdb"; string path_data = "APP_Data/FFMS.accdb"; if (RecoverAccess(path_back, path_data)) { MessageBox.Show("数据库还原成功"); } else { MessageBox.Show("数据库还原失败"); } } else if (sender == payExport)//导出支出明细Excel { ExportExcel.ExportToExcel(pay_data); } else if (sender == incomeExport)//导出收入明细Excel { ExportExcel.ExportToExcel(income_data); } else if (sender == accessExport)//导出月度统计Excel { //ExportExcel.ExportToExcel(count_data); } else if (sender == pay)//支出明细 { tab.SelectedIndex = 0; } else if (sender == income)//收入明细 { tab.SelectedIndex = 1; } else if (sender == count)//月度统计 { tab.SelectedIndex = 2; } else if (sender == assets)//家庭财产 { Information info = new Information(getAssets()); info.Title = "家庭财产"; info.Show(); } else if (sender == budget)//每月预算 { new MonNote().Show(); } else if (sender == alterInfo)//修改资料 { AlterInfo alter = new AlterInfo(name); alter.Title = "修改资料"; alter.Show(); } else if (sender == deleteUser)//删除成员 { new DeleteMember().ShowDialog(); //重新刷新datagrid init_dataGrid(); } else if (sender == message)//提醒信息 { Information info = new Information(getMessage()); info.Title = "提醒信息"; info.Show(); } else if (sender == function)//功能介绍 { String infomation = "1.收支明细,记录了所有的收支信息\n" + "2.月度统计,统计了当前月的收支统计\n" + "3.数据部分,可以导入数据库,导出数据库及数据库备份,并且还可以导出支出明细,收入明细,月度统计的Excel\n" + "4.家庭财产统计了所有月的净收入,上个月的总支出及当前月的目前支出\n" + "5.每月记事,功能强大,可以查询某年某月的记事,可以增加当前月的记事,还有当记事内容被删掉"; Information info = new Information(infomation); info.Title = "功能介绍"; info.Show(); } else if (sender == calculator)//计算器 { Calculator mCalculator = new Calculator(); mCalculator.Show(); } else if (sender == about)//关于 { String infomation = " 该软件由学生小组完成,并且是免费的。感谢你的使用!如果有好的建议,可以把建议发到邮箱[email protected]。"; Information info = new Information(infomation); info.Title = "关于"; info.Show(); } }