//用户管理页面删除
public ActionResult UserManagementDelete(int id)
{
//查询出要删除用户的真实姓名是否和登陆进来的姓名相同 AsNoTracking
var list = iud.SelectWhere(e => e.UserID == id);
foreach (var item in list)
{
if (item.UserRealName == Session["UserRealName"].ToString())
{
return(Content("<script>alert('用户正在使用中不能被删除');window.location.href='/Systems/UserManagementSelect'</script>"));
}
}
info_User user = new info_User
{
UserID = id
};
//不相同，则删除
if (iud.Delete(user) > 0)
{
return(Content("<script>alert('删除成功');window.location.href='/Systems/UserManagementSelect'</script>"));
}
else
{
return(Content("<script>alert('删除失败');window.location.href='/Systems/UserManagementSelect'</script>"));
}
}
public ActionResult UserManagementEdits(info_User u)
{
if (iud.Update(u) > 0)
{
return(Content("<script>alert('修改成功');window.location.href='/Systems/UserManagementSelect'</script>"));
}
else
{
return(Content("<script>alert('修改失败');window.location.href='/Systems/UserManagementEdit/" + u.UserID + "'</script>"));
}
// return View(dt);
}
//修改密码[进行修改密码操作]
public ActionResult UserManagementPassEdits(int id, string pass)
{
info_User u = iud.SelectWhere(e => e.UserID == id).FirstOrDefault();
u.UserPass = pass;
if (iud.Update(u) > 0)
{
return(Content("ok"));
}
else
{
return(Content("no"));
}
}
public async Task <ActionResult> UserManagementCreates(info_User u)
{
if (iud.Add(u) > 0)
{
AddUser(u);
return(Content("<script>alert('添加成功');window.location.href='/Systems/UserManagementSelect'</script>"));
}
else
{
return(Content("<script>alert('添加失败');window.location.href='/Systems/UserManagementEdit/" + u.UserID + "'</script>"));
}
// return View(dt);
}
public async void AddUser(info_User u)
{
ThreadPool.SetMinThreads(800, 800);
using (var redis = await ConnectionMultiplexer.ConnectAsync("127.0.0.1:6379"))
{
IDatabase db = redis.GetDatabase();
Dictionary <object, object> di = new Dictionary <object, object>();
di.Add("UserID", u.UserID);
di.Add("UserRealName", u.UserRealName);
di.Add("Email", u.Email);
await db.ListLeftPushAsync("f", JsonConvert.SerializeObject(di));
string zhi = await db.ListRightPopAsync("f");
//把json字符串转换为对象
info_User p = JsonConvert.DeserializeObject <info_User>(zhi);
//使用MailMessage发送电子邮件
MailMessage mail = new MailMessage();
//主题
mail.Subject = "欢迎您成为信息系统的一员";
//发件人
mail.From = new MailAddress("*****@*****.**");
//收件人
mail.To.Add(new MailAddress(u.Email));
//主体
//HtmlHelper h=new HtmlHelper(Login, Login);
// string login = "******";
mail.Body = "欢迎" + u.UserRealName + "，恭喜您成为信息系统的一员(*^_^*)，您的密码是：" + u.UserPass + "!快去登陆一下吧";
//允许程序发邮件
SmtpClient sc = new SmtpClient("smtp.qq.com");
//发信的凭证
sc.Credentials = new NetworkCredential("*****@*****.**", "onfwcyynkhtjeadg");
sc.Send(mail);
}
}
//点击机房维护维修查看
public ActionResult SelectTongJiWeiHuWeiXiuChaKan(int id)
{
info_Maintenance im = img.SelectWhere(e => e.MIDs == id).FirstOrDefault();
info_Software iss = isb.SelectWhere(e => e.SID == im.MDeviceName).FirstOrDefault();
ViewData["a"] = iss.Sdynacomm;
//查询陪同人员
int mm = Convert.ToInt32(im.MAccompanyingOfficials);
info_User iu = iud.SelectWhere(e => e.UserID == mm).FirstOrDefault();
ViewData["p"] = iu.UserRealName;
//查询检测人员
int rr = Convert.ToInt32(im.MTestingPersonnel);
info_ComputerRoomVisit ir = lcr.SelectWheres(e => e.CID == rr).FirstOrDefault();
ViewData["s"] = ir.CName;
return(View(im));
}
public int Update(info_User t)
{
return(iud.Update(t));
}
public int Delete(info_User t)
{
return(iud.Delete(t));
}
public int Add(info_User t)
{
return(iud.Add(t));
}
