private void Button4_Click(object sender, EventArgs e)
{
if (TextBox7.Text.ToLower() == "admin" && PublicVar.UserLoginName.ToLower() != "admin")
{
MessageBox.Show(this, "您不能更改内置管理员admin密码。",
"操作禁止", MessageBoxButtons.OK);
return;
}
myEFContext db = new myEFContext();
User user = db.Users.Find(TextBox7.Tag);
if (user != null)
{
user.UserPassword = sys.SysSec.StringSec(user.UserLoginName);
db.SaveChanges();
MessageBox.Show(this, "操作成功。", "操作提示", MessageBoxButtons.OK);
}
else
{
MessageBox.Show(this, "未能找到指定用户名的用户。",
"用户错误", MessageBoxButtons.OK);
return;
}
}
private void Button3_Click(object sender, EventArgs e)
{
if (TextBox7.Text.ToLower() == "admin")
{
MessageBox.Show(this, "不能删除内置管理员admin。",
"操作禁止", MessageBoxButtons.OK);
return;
}
//删除
myEFContext db = new myEFContext();
User user = db.Users.Find(TextBox7.Tag);
if (user != null)
{
if (MessageBox.Show(this, "确认删除用户吗？如果仅仅是禁止用户登录，可以考虑不勾选【允许登录】",
"用户删除确认", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
db.Users.Remove(user);
db.SaveChanges();
}
}
else
{
MessageBox.Show(this, "未能找到指定用户名的用户。",
"用户错误", MessageBoxButtons.OK);
return;
}
}
private void Button5_Click(object sender, EventArgs e)
{
//保存信息
if (sys.SysSec.CheckdbCon(sys.SysSec.dbSvrName, sys.SysSec.dbName, sys.SysSec.dbUserName, sys.SysSec.dbUserPwd) == false)
{
MessageBox.Show("数据库连接失败，请先设置数据库配置");
return;
}
myEFContext db = new myEFContext();
int n = db.sysInfo.Count();
if (n == 0)
{
//新增
sysInfo sysInfo = new sysInfo
{
companyName = TextBox8.Text,
sysName = TextBox10.Text,
sysVersion = Application.ProductVersion,
sysCreateTime = DateTime.Now,
MaxUser = 100,
sysDeadTime = DateTime.Now.AddYears(10),
sysKey = "",
sharePath = ""
};
db.sysInfo.Add(sysInfo);
db.SaveChanges();
SysSec.companyName = TextBox8.Text;
SysSec.sysName = TextBox10.Text;
}
else if (n == 1)
{
sysInfo sysInfo = db.sysInfo.First();
sysInfo.companyName = TextBox8.Text;
sysInfo.sysName = TextBox10.Text;
sysInfo.sysVersion = Application.ProductVersion;
db.SaveChanges();
SysSec.companyName = TextBox8.Text;
SysSec.sysName = TextBox10.Text;
}
}
private void Button1_Click(object sender, EventArgs e)
{
if (TextBox7.Tag == null)
{
MessageBox.Show(this, "请先选择到一个指定用户", "操作终止", MessageBoxButtons.OK);
return;
}
if (TextBox7.Text.Trim() == "")
{
MessageBox.Show(this, "请输入用户名", "操作终止", MessageBoxButtons.OK);
return;
}
if (TextBox3.Text.Trim() == "")
{
MessageBox.Show(this, "请输入用户姓名", "操作终止", MessageBoxButtons.OK);
return;
}
if (ComboBox5.Text.Trim() == "")
{
MessageBox.Show(this, "请选择用户权限级别", "操作终止", MessageBoxButtons.OK);
return;
}
myEFContext db = new myEFContext();
//检查用户名是否重复
int count = db.Users.Where(t => t.ID != int.Parse(TextBox7.Tag.ToString()) &&
t.UserLoginName.ToUpper() == TextBox7.Text.ToUpper()).Count();
if (count != 0)
{
MessageBox.Show(this, "用户名重复。", "操作终止", MessageBoxButtons.OK);
return;
}
User user = db.Users.Find(TextBox7.Tag);
if (user != null)
{
user.UserLoginName = TextBox7.Text.Trim();
user.UserName = TextBox3.Text.Trim();
user.UserCreateTime = DateTime.Now;
user.Level = int.Parse(ComboBox5.Text);
user.remark = TextBox1.Text.Trim();
user.Enable = checkBox1.Checked;
//db.Entry(user).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
else
{
MessageBox.Show(this, "未能找到指定用户名的用户。",
"用户错误", MessageBoxButtons.OK);
return;
}
}
public void LoadSysData()
{
//如果没有admin用户，添加该用户
myEFContext db = new myEFContext();
//检查系统设置
int n = db.sysInfo.Count();
if (n == 1)
{
sysInfo sysInfo = db.sysInfo.First();
SysSec.companyName = sysInfo.companyName;
SysSec.sysName = sysInfo.sysName;
}
n = db.Users.Where(t => t.UserLoginName.ToLower() == "admin").Count();
if (n == 0)
{
User adminUser = new User
{
UserLoginName = "admin",
UserPassword = SysSec.StringSec("admin"),
UserName = "******",
Level = 0,
Enable = true,
remark = "系统内置管理员，不能删除",
UserCreateTime = DateTime.Now,
LastLoginTime = null
};
db.Users.Add(adminUser);
db.SaveChanges();
//自动打开系统配置界面
MessageBox.Show("第一次登录使用系统，请设置系统数据");
Form dbset = new sys.SysSet();
dbset.ShowDialog();
}
}
private void Button2_Click(object sender, EventArgs e)
{
if (TextBox7.Text.Trim() == "")
{
MessageBox.Show(this, "请输入用户名", "操作终止", MessageBoxButtons.OK);
return;
}
if (TextBox3.Text.Trim() == "")
{
MessageBox.Show(this, "请输入用户姓名", "操作终止", MessageBoxButtons.OK);
return;
}
if (ComboBox5.Text.Trim() == "")
{
MessageBox.Show(this, "请选择用户权限级别", "操作终止", MessageBoxButtons.OK);
return;
}
myEFContext db = new myEFContext();
//检查用户名是否重复
int count = db.Users.Where(t => t.UserLoginName.ToUpper() == TextBox7.Text.ToUpper()).Count();
if (count != 0)
{
MessageBox.Show(this, "用户名重复。", "操作终止", MessageBoxButtons.OK);
return;
}
User user = new User
{
UserLoginName = TextBox7.Text.Trim(),
UserName = TextBox3.Text.Trim(),
UserCreateTime = DateTime.Now,
UserPassword = sys.SysSec.StringSec(TextBox7.Text.Trim()),
Level = int.Parse(ComboBox5.Text),
remark = TextBox1.Text.Trim(),
Enable = checkBox1.Checked
};
db.Users.Add(user);
db.SaveChanges();
}
private void Button1_Click(object sender, EventArgs e)
{
//检查登录
string yhm = TextBox1.Text;
string mima = TextBox4.Text;
if (string.IsNullOrEmpty(yhm) | string.IsNullOrEmpty(mima))
{
MessageBox.Show(this, "用户名或者密码为空，请检查。系统不允许用户使用空密码。",
"用户名或密码不能为空", MessageBoxButtons.OK);
return;
}
//检查用户名
myEFContext db = new myEFContext();
User user = db.Users.FirstOrDefault(t => t.UserLoginName.ToUpper() == yhm.ToUpper());
if (user == null)
{
MessageBox.Show(this, "未找到用户名，请检查。用户名一般为姓名全拼，请联系管理员添加。",
"用户名不存在", MessageBoxButtons.OK);
return;
}
//检查用户密码
if (user.UserPassword != sys.SysSec.StringSec(mima))
{
MessageBox.Show(this, "用户密码不配对。",
"密码错误", MessageBoxButtons.OK);
return;
}
if (user.Enable == false)
{
MessageBox.Show(this, "用户已经被禁止登录，请联系管理员", "警告", MessageBoxButtons.OK);
return;
}
//更新登录信息
user.LastLoginTime = DateTime.Now;
db.SaveChanges();
PublicVar.UserLoginName = user.UserLoginName;
PublicVar.UserName = user.UserName;
//记住用户
if (CheckBox1.Checked == true)
{
PublicVar.SetUserName(yhm);
}
else
{
PublicVar.SetUserName("");
}
this.Visible = false;
if (user.Level == 0)
{
Form SysSet = new sys.SysSet();
SysSet.ShowDialog();
this.Close();
}
else
{
Thread th = new Thread(new ThreadStart(StartMainForm));
th.Start();
this.Close();
}
}
