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