public string vipover([FromBody] JObject obj) { var vipinfo = new { userid = Convert.ToInt32(obj["userid"]) }; using (DiaryDBEntitiesOne ohlifedb = new DiaryDBEntitiesOne()) { User_tb userinfo = ohlifedb.User_tb.Where(info => info.User_tbID == vipinfo.userid).FirstOrDefault(); userinfo.Memberstate = false; return(ohlifedb.SaveChanges() > 0 ? "Yes" : "No"); } }
public string newpwd([FromBody] JObject obj) { var userobj = new { userid = Convert.ToInt32(obj["userid"]), pwd = obj["pwd"].ToString() }; using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne()) { User_tb userinfo = diarydb.User_tb.Where(a => a.User_tbID == userobj.userid).FirstOrDefault(); userinfo.Passwordr = userobj.pwd; return(diarydb.SaveChanges() > 0 ? "Yes" : "No"); } }
public string tovip([FromBody] JObject obj) { var vipinfo = new { begintime = obj["begintime"], overtime = obj["overtimes"], userid = Convert.ToInt32(obj["userid"]) }; using (DiaryDBEntitiesOne ohlifedb = new DiaryDBEntitiesOne()) { User_tb userinfo = ohlifedb.User_tb.Where(info => info.User_tbID == vipinfo.userid).FirstOrDefault(); userinfo.Memberstate = true; // var ss = Convert.ToDateTime(vipinfo.begintime); // var dd= Convert.ToDateTime(vipinfo.overtime); userinfo.Memberopen = Convert.ToDateTime(vipinfo.begintime); userinfo.Memberover = Convert.ToDateTime(vipinfo.overtime); return(ohlifedb.SaveChanges() > 0 ? "Yes" : "No"); } }
public string newuser([FromBody] JObject obj) { var userobj = new { Accountnumber = obj["Accountnumber"], pwd = obj["pwd"].ToString() }; using (DiaryDBEntitiesOne diarydb = new DiaryDBEntitiesOne()) { User_tb userinfo = new User_tb(); userinfo.Accountnumber = userobj.Accountnumber.ToString(); userinfo.Passwordr = userobj.pwd; userinfo.Registertime = DateTime.Now; userinfo.Memberover = DateTime.Now; userinfo.Memberstate = false; userinfo.Accountstate = true; diarydb.User_tb.Add(userinfo); return(diarydb.SaveChanges() > 0 ? "Yes" : "No"); } }
public ActionResult Login(string UserAccount, String UserPWD) { ViewBag.UserAccount = UserAccount; ViewBag.UserPWD = UserPWD; RMuseAccount rmuseAccount = new RMuseAccount(); User_tb user_tb = rmuseAccount.GetUser(UserAccount); if (user_tb == null) { ViewBag.errorMsg = "账号不存在"; } else { if (user_tb.UserPWD != UserPWD) { ViewBag.errorMsg = "密码错误"; } else { //设置Cookies,指定权限,返回至登陆前页面 FormsAuthenticationTicket authTicket = new FormsAuthenticationTicket( 1, user_tb.UserID.ToString(), DateTime.Now, DateTime.Now.AddHours(10000), false, "MuseUser" ); string encTicket = FormsAuthentication.Encrypt(authTicket); this.Response.Cookies.Add(new HttpCookie(FormsAuthentication.FormsCookieName, encTicket)); string url = Request["ReturnUrl"]; if (url == null) { return(RedirectToAction("Index", "Home")); } else { return(Redirect(url)); } } } return(View()); }