public string DelMember(int user_id) { if (!Request.IsAuthenticated || StaticMethod.GetType(UserID) != 0) { return(JsonConvert.SerializeObject(new ReturnResponse(24000, "身份验证未通过"))); } using (var db = new DoCoverEntities()) { Users user = db.Users.FirstOrDefault(m => m.user_id == user_id); if (user == null) { return(JsonConvert.SerializeObject(new ReturnResponse() { code = 31002, message = "该用户不存在" })); } if ((user.Orders_Create != null && user.Orders_Create.Count > 0) || (user.Orders_Finish != null && user.Orders_Finish.Count > 0)) { return(JsonConvert.SerializeObject(new ReturnResponse() { code = 21001, message = "该用户有关联订单,推荐使用禁用功能" })); } db.Users.Remove(user); db.SaveChanges(); } return(JsonConvert.SerializeObject(new ReturnResponse(200))); }
public string EditMemberStatus(int user_id, bool user_status, string user_remark = "") { if (!Request.IsAuthenticated || StaticMethod.GetType(UserID) != 0) { return(JsonConvert.SerializeObject(new ReturnResponse(24000, "身份验证未通过"))); } using (var db = new DoCoverEntities()) { Users user = db.Users.FirstOrDefault(m => m.user_id == user_id); if (user == null) { return(JsonConvert.SerializeObject(new ReturnResponse() { code = 31002, message = "该用户不存在" })); } user.user_status = user_status; user.user_remark = user_remark; user.user_last_update_ip = StaticMethod.GetClientIP(); user.user_last_update_time = DateTime.Now;; db.SaveChanges(); } return(JsonConvert.SerializeObject(new ReturnResponse(200))); }
public string AddMember(string data) { if (!Request.IsAuthenticated || StaticMethod.GetType(UserID) != 0) { return(JsonConvert.SerializeObject(new ReturnResponse(24000, "身份验证未通过"))); } Users user = JsonConvert.DeserializeObject <Users>(data); user.user_pwd = Security.EncryptQueryString("123456"); user.user_reg_ip = StaticMethod.GetClientIP(); user.user_reg_time = DateTime.Now; using (var db = new DoCoverEntities()) { if (db.Users.Count(m => m.user_name == user.user_name) > 0) { return(JsonConvert.SerializeObject(new ReturnResponse() { code = 31001, message = "用户名重复" })); } db.Users.Add(user); db.SaveChanges(); } return(JsonConvert.SerializeObject(new ReturnResponse(200))); }
public ActionResult AddMember() { if (StaticMethod.GetType(UserID) != 0) { noAuth = true; } return(View()); }
public string EditMember(string data) { if (!Request.IsAuthenticated || StaticMethod.GetType(UserID) != 0) { return(JsonConvert.SerializeObject(new ReturnResponse(24000, "身份验证未通过"))); } Users info = JsonConvert.DeserializeObject <Users>(data); info.user_last_update_ip = StaticMethod.GetClientIP(); info.user_last_update_time = DateTime.Now; using (var db = new DoCoverEntities()) { Users user = db.Users.FirstOrDefault(m => m.user_id == info.user_id); if (user == null) { return(JsonConvert.SerializeObject(new ReturnResponse() { code = 31002, message = "该用户不存在" })); } if (user.user_name != info.user_name) { if (db.Users.Count(m => m.user_name != user.user_name && m.user_name == info.user_name) > 0) { return(JsonConvert.SerializeObject(new ReturnResponse() { code = 31001, message = "用户名重复" })); } } if (info.user_pwd != null && info.user_pwd != "") { user.user_pwd = Security.EncryptQueryString(info.user_pwd); } user.user_name = info.user_name; user.user_nick_name = info.user_nick_name; user.user_qq = info.user_qq; user.user_phone = info.user_phone; user.user_email = info.user_email; user.user_last_update_ip = info.user_last_update_ip; user.user_last_update_time = info.user_last_update_time; db.SaveChanges(); } return(JsonConvert.SerializeObject(new ReturnResponse(200))); }
/// <summary> /// 获取成员接口 /// </summary> /// <param name="page">页码</param> /// <param name="limit">一页数据</param> /// <returns></returns> public string GetMember(int page, int limit, int user_id = 0, string user_name = "", int user_type = 0, int user_status = 0) { if (!Request.IsAuthenticated || StaticMethod.GetType(UserID) != 0) { return(JsonConvert.SerializeObject(new ReturnResponse(24000, "身份验证未通过"))); } int count = 0; List <Users> users; IEnumerable <Users> temp; using (var db = new DoCoverEntities()) { temp = db.Users.Where(m => m.user_type != 0); if (user_id > 0) { temp = temp.Where(m => m.user_id == user_id); } if (user_name != "") { temp = temp.Where(m => m.user_name == user_name); } if (user_type > 0) { temp = temp.Where(m => m.user_type == user_type); } if (user_status == 1) { temp = temp.Where(m => m.user_status != false); } if (user_status == 2) { temp = temp.Where(m => m.user_status == false); } users = temp.ToList(); } count = users.Count(); users = users.Skip((page - 1) * limit).Take(limit).ToList(); if (users.Count == 0) { return(JsonConvert.SerializeObject(new { code = 201, msg = "暂时没有数据", count = count, data = users })); } users.ForEach(m => m.user_pwd = "别看了,没密码"); return(JsonConvert.SerializeObject(new { code = 0, msg = "", count = count, data = users })); }
public ActionResult EditMember(int user_id) { if (StaticMethod.GetType(UserID) != 0) { noAuth = true; } using (var db = new DoCoverEntities()) { Users user = db.Users.FirstOrDefault(m => m.user_id == user_id && m.user_type != 0); if (user == null) { return(Content(JsonConvert.SerializeObject(new ReturnResponse() { code = 31002, message = "该用户不存在" }))); } ViewBag.User = user; } return(View()); }