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);
}
}
}
}
