//根据权限,展示用户信息
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();
}