private void ok_Click(object sender, EventArgs e) { bool flag = false, flag_login = false; //AccountAdd aa = new AccountAdd(); BusinessLogicLayer.Login.Login login = new BusinessLogicLayer.Login.Login(); flag_login = login.isLogin(text_name.Text, text_oldpsd.Text);//判断旧密码是否正确 if (flag_login) { if (text_newpsd1.Text == text_newpsd2.Text) { flag = login.updatePasswordByUsername(text_name.Text, text_newpsd1.Text); if (flag) { MessageBox.Show("数据保存成功!"); this.DialogResult = DialogResult.OK; this.Close(); } else { MessageBox.Show("数据保存失败,请检查网络连接!"); } } else { MessageBox.Show("新密码两次输入不一致!", "禁止操作", MessageBoxButtons.OK, MessageBoxIcon.Warning); text_newpsd1.SelectAll(); return; } } else { MessageBox.Show("原密码不正确!", "禁止操作", MessageBoxButtons.OK, MessageBoxIcon.Warning); text_oldpsd.SelectAll(); return; } }
private void shujukuhuifu_Click(object sender, EventArgs e) { BusinessLogicLayer.Login.Login login = new BusinessLogicLayer.Login.Login(); DialogResult dr; Boolean flag = false; string filename = ""; OpenFileDialog open = new OpenFileDialog(); open.Title = "请选择数据库备份文件"; open.InitialDirectory = "d://"; // 默认打开的路径,可更改 open.Filter = "MDF数据库文件 (*.mdf)|*.mdf"; open.FilterIndex = 1; open.RestoreDirectory = true; open.Multiselect = false; dr = MessageBox.Show("您确认恢复数据库吗?", "请确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { if (open.ShowDialog() == DialogResult.OK) { filename = open.FileName; Cursor cr = Cursor.Current; Cursor.Current = Cursors.WaitCursor;//将光标置为等待状态 flag = login.ReplaceDataBase(filename); Cursor.Current = cr;//将光标置回原来状态 if (flag) { MessageBox.Show("数据库已成功还原", "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("数据库还原失败!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }
/// <summary> /// 数据库备份 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void shujukubeifen_Click(object sender, EventArgs e) { BusinessLogicLayer.Login.Login login = new BusinessLogicLayer.Login.Login(); //login.BackupDataBase(); //"d:\\cemsdb\\cems.mdf" string path = "", filename = ""; DialogResult dr; Boolean flag = false; FolderBrowserDialog fb = new FolderBrowserDialog(); fb.Description = "请选择备份文件存放路径"; string date = DateTime.Now.ToString("yyyyMMdd"); dr = MessageBox.Show("您确认备份数据库吗?", "请确认", MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (dr == DialogResult.Yes) { if (fb.ShowDialog() == DialogResult.OK) { Cursor cr = Cursor.Current; Cursor.Current = Cursors.WaitCursor;//将光标置为等待状态 path = fb.SelectedPath; filename = "\\cems-" + date+"-" + Util.Tools.Number(6)+".mdf"; flag = login.BackupDataBase(path, filename); Cursor.Current = cr;//将光标置回原来状态 if (flag) { MessageBox.Show("数据库已成功备份至" + path + filename, "操作成功", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("数据库备份失败!", "操作失败", MessageBoxButtons.OK, MessageBoxIcon.Error); } } } }