public ActionResult ResetToken(int id) { var result = ActionJsonResult.Create(); using (var db = DbHelper.Create()) { var user = db.Tb_Users.FirstOrDefault(u => u.UserID == id); if (user == null) { result.Failed("无法查询到指定的用户."); } else { try { user.Token = GetUserToken(); db.Entry(user).State = EntityState.Modified; db.SaveChanges(); } catch (Exception e) { result.Failed(e.Message); } } } return(result.ToJson()); }
public ActionResult Login(LoginParam param, string isBer) { var result = ActionJsonResult.Create(); using (var db = DbHelper.Create()) { var user = db.Tb_Users.FirstOrDefault(u => u.UserName == param.UserName); if (user?.Password != param.Psw) { result.Failed("用户或密码错误"); } else if (user.Enabled == 0) { result.Failed("用户已被禁用"); } else { //保存Cookie HttpCookie cookie = new HttpCookie("Tb_Users"); cookie.Values.Add("UserName", HttpUtility.UrlEncode(param.UserName)); cookie.Values.Add("PassWord", param.Psw); cookie.Values.Add("IsBer", isBer); Response.AppendCookie(cookie); //保存当前登录用户 this.Save(user); //?获取用户菜单 var menuReader = new MenuReader(user); menuReader.LoadMenus(GetMenuJson()); this.Save(SessionKeys.UserPermissionDic, menuReader.PermissionItems); this.Save(SessionKeys.Menus, menuReader.Menus); result.Success("/home/main"); } } return(result.ToJson()); }
public ActionResult DeleteUser(int?id) { var result = ActionJsonResult.Create(); if (id.HasValue) //编辑 { using (var db = DbHelper.Create()) { var user = db.Tb_Users.FirstOrDefault(u => u.UserID == id); if (user == null) { result.Failed("无法查询到指定的用户."); } else { try { db.Tb_Users.Remove(user); db.SaveChanges(); } catch (Exception e) { result.Failed(e.Message); } } } } else { result.Failed("无效的用户Id."); } return(result.ToJson()); }
public ActionResult GetAllMenu() { var result = ActionJsonResult.Create(); var menus = this.Load <List <MenuItem> >(SessionKeys.Menus); result.Success(menus); return(result.ToJson()); }
public ActionResult GetSession() { var result = ActionJsonResult.Create(); if (Session["Web.EF.Tb_Users"] == null) { //Tb_Users user = Session["Web.EF.Tb_Users"] as Tb_Users; ////保存当前登录用户 //this.Save(user); ////?获取用户菜单 //var menuReader = new MenuReader(user); //menuReader.LoadMenus(GetMenuJson()); //this.Save(SessionKeys.UserPermissionDic, menuReader.PermissionItems); //this.Save(SessionKeys.Menus, menuReader.Menus); result.Failed("过期"); } return(result.ToJson()); }
public ActionResult SaveDeveloper(Tb_Users user) { var result = ActionJsonResult.Create(); if (user == null) { result.Failed("用户数据错误."); } else { using (var db = DbHelper.Create()) { try { //查询是否有相同的记录存在,存在,则更新;否则插入新的 var tmp = db.Tb_Users.FirstOrDefault((a => a.UserID == user.UserID)); if (tmp != null) { tmp.Enabled = user.Enabled; tmp.UserName = user.UserName; db.Entry(tmp).State = EntityState.Modified; } else { user.Level = 2; user.Password = "******"; user.CreateDate = DateTime.Now; user.Token = GetUserToken(); db.Tb_Users.Add(user); } db.SaveChanges(); } catch (Exception e) { result.Failed(e.Message); } } } return(result.ToJson()); }
public ActionResult SaveUserProfile(PasswordChange info) { var result = ActionJsonResult.Create(); if (info == null) { result.Failed("参数错误"); } else { var user = this.Load <Tb_Users>(); if (user.Password != info.OldPsw) { result.Failed("用户密码不匹配."); } else { using (var db = DbHelper.Create()) { user.Password = info.NewPsw; db.Entry(user).State = EntityState.Modified; try { db.SaveChanges(); this.Save(user); } catch (Exception e) { result.Failed(e.Message); } } } } return(result.ToJson()); }
public ActionResult GetFaceAPIReport(int type) { //var sw = new Stopwatch(); //sw.Start(); var sum = new List <int>(); var min = new List <int>(); var max = new List <int>(); var count = new List <int>(); var saveDate = new List <string>(); var avg = new List <int>(); var result = ActionJsonResult.Create(); using (var db = DbHelper.Create()) { var users = this.Load <Tb_Users>(); var level = users.Level; var userid = users.UserID; string StrSql = ""; string sqlWhere = ""; string UserId = ""; if (type == 1) { if (level > 1) { sqlWhere = " and UserID=" + userid + " "; UserId = " UserID, "; } StrSql = " select sum(UseTime) as sumElapsedTime ,max(UseTime) as maxElapsedTime,count(UseTime) as countElapsedTime,avg(UseTime) as avgElapsedTime, min(UseTime) as minElapsedTime," + UserId + " day(Tb_Logs_FaceAPI.CallTime) as SaveDate from Tb_Logs_FaceAPI " + " where year(Tb_Logs_FaceAPI.CallTime) = year(getdate()) and month(Tb_Logs_FaceAPI.CallTime) = month(getdate()) " + sqlWhere + " " + " group by " + UserId + " day(Tb_Logs_FaceAPI.CallTime)"; } else { if (level > 1) { sqlWhere = " and UserID=" + userid + " "; UserId = " UserID, "; } StrSql = "select sum(UseTime) as sumElapsedTime ,max(UseTime) as maxElapsedTime,count(UseTime) as countElapsedTime,avg(UseTime) as avgElapsedTime, min(UseTime) as minElapsedTime," + UserId + " DATEPART(hh,Tb_Logs_FaceAPI.CallTime) as SaveDate from Tb_Logs_FaceAPI " + " where year(Tb_Logs_FaceAPI.CallTime) = year(getdate()) and month(Tb_Logs_FaceAPI.CallTime) = month(getdate()) " + " and day(Tb_Logs_FaceAPI.CallTime) = day(getdate()) " + sqlWhere + " group by " + UserId + " DATEPART(hh, Tb_Logs_FaceAPI.CallTime)"; } var sql = new StringBuilder(StrSql); var list = db.Database.SqlQuery <FaceApiData>(sql.ToString()).ToList(); //var psr = new PageSearchResult<List<FaceApiData>>(list.Count, list); //result.Data = list; var month = DateTime.Now.Month; //月 var day = DateTime.Now.Day; //日 var hour = DateTime.Now.Hour; //小时 var param = type == 1 ? day : hour; var m = 0; for (int i = 1; i <= param; i++) { m++; if (type == 1) { saveDate.Add(month + "月" + m + "日"); } else { saveDate.Add(m + "小时"); } count.Add(0); foreach (var item in list) { if (i == item.SaveDate) { if (type == 1) { if (item.SaveDate != null) { saveDate[i - 1] = month + "月" + item.SaveDate + "日"; } if (item.countElapsedTime != null) { count[i - 1] = (int)item.countElapsedTime; } } else { if (item.SaveDate != null) { saveDate[i - 1] = item.SaveDate + "小时"; } if (item.countElapsedTime != null) { count[i - 1] = (int)item.countElapsedTime; } } } } } foreach (var item in list) { if (item.avgElapsedTime != null) { avg.Add((int)item.avgElapsedTime); } if (item.sumElapsedTime != null) { sum.Add((int)item.sumElapsedTime); } if (item.maxElapsedTime != null) { max.Add((int)item.maxElapsedTime); } if (item.minElapsedTime != null) { min.Add((int)item.minElapsedTime); } } } var o = new { sum = sum, min = min, max = max, count = count, saveDate = saveDate, avg = avg, }; return(Json(o, JsonRequestBehavior.AllowGet)); }