//根据权限,展示用户信息 private void showUsers() { switch (power) { case 0: //超级用户 AddPowerList.Clear(); AddPowerList.Add("普通用户"); AddPowerList.Add("管理员"); //显示除临时用户以外的所有用户 DataTable dt = sql.ExecuteQuery("select username,userpower from userTB where userpower<>2"); UserList.Clear(); for (int i = 0; i < dt.Rows.Count; i++) { User u = new User(); u.Username = dt.Rows[i]["username"].ToString(); u.Passwd = "XXX"; u.Userpower = Convert.ToInt32(dt.Rows[i]["userpower"].ToString()); UserList.Add(u); } break; case 2: //临时用户 AddPowerList.Clear(); AddPowerList.Add("普通用户"); DataTable dt2 = sql.ExecuteQuery("select (username) from userTB where userpower=3"); UserList.Clear(); for (int i = 0; i < dt2.Rows.Count; i++) { User u = new User(); u.Username = dt2.Rows[i]["username"].ToString(); u.Passwd = "XXX"; u.Userpower = 3; UserList.Add(u); } break; } AddPowerSelect = 0; }
//添加用户按钮事件 public void runAddUser() { if (AddUsername == null | AddPasswd == null) { return; } DataTable dt3 = sql.ExecuteQuery("select count(1) from userTB where username='******'"); //result.Read(); Console.WriteLine(dt3.Rows.Count); int i = Convert.ToInt32(dt3.Rows[0][0].ToString()); //sql.CloseConnection(); if (i != 0) { Application.Current.Dispatcher.Invoke((Action) delegate { ModernDialog.ShowMessage("用户名已经存在", "提示", MessageBoxButton.OK); }); return; } if (AddUsername.Equals("admin") | AddUsername.Equals("master")) { //与临时用户或超级用户重名 Application.Current.Dispatcher.Invoke((Action) delegate { ModernDialog.ShowMessage("用户名非法,请更换", "提示", MessageBoxButton.OK); }); return; } int power = -1; string itemlist = null; switch (addPowerList[AddPowerSelect]) { case "超级用户": power = 0; itemlist = "1,1,1,1"; break; case "管理员": power = 1; itemlist = "1,1,1,1"; break; case "临时用户": power = 2; itemlist = "0,0,0,0"; break; case "普通用户": power = 3; itemlist = "0,0,1,0"; break; } int insertCount = sql.ExecuteNonQuery("insert into userTB values(null,@username,@passwd,@userpower,@itemlist,0)", new Dictionary <string, string>() { { "@username", AddUsername }, { "@passwd", AddPasswd }, { "@userpower", power.ToString() }, { "@itemlist", itemlist } }); List <string> aa = AddPowerList.ToList(); if (insertCount != 1) { Application.Current.Dispatcher.Invoke((Action) delegate { ModernDialog.ShowMessage("添加失败", "提示", MessageBoxButton.OK); }); } showUsers(); }