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());
}
