62,041
社区成员
发帖
与我相关
我的任务
分享
entry.State = System.Data.EntityState.Unchanged;
entry.Property("key").IsModified = true;
entry.Property("groupid").IsModified = true;
model.key = "0"; //清空key
model.groupid = 1;
int ret = db.SaveChanges();
public void SetUserState(User model)
{
usertable tab = new usertable();
tab.id = model.id;
tab.username = model.username;
tab.password = model.password;
tab.email = model.email;
tab.phone = model.phone;
tab.logintime = DateTime.Now;
tab.loginip = model.loginip;
tab.groupid = 1;
tab.key = "";
DbEntityEntry<usertable> entry = db.Entry<usertable>(tab);
entry.State = System.Data.EntityState.Unchanged;
entry.Property("key").IsModified = true;
entry.Property("groupid").IsModified = true;
model.key = "0"; //清空key
model.groupid = 1;
int ret = db.SaveChanges();
return;
}
//这是更新操作
public JsonResult login(User model)
{
jsonres = new JsonRes();
jsonresult = new JsonResult();
int uRet = UserDal.CheckUser(model);
if (uRet == 1)
{
//设置当前登录ID
AppBase.UserId = UserDal.QueryUserIdByName(model);
//return RedirectToAction("left", "back");
UserDal.UpdateLoginIp(model);
jsonres.tip = "ok";
jsonres.res = "登录成功";
jsonresult.Data = jsonres;
return jsonresult;
}
else if (uRet == 2)
{
//Response.Write("<script type=\"text/javascript\">alert('您的账号还未激活,请登录到注册邮箱进行激活!');</script>");
jsonres.tip = "failed";
jsonres.res = "您的账号还未激活,请登录到注册邮箱进行激活!";
jsonresult.Data = jsonres;
return jsonresult;
}
jsonres.tip = "failed";
jsonres.res = "验证失败,请检查用户名和密码";
jsonresult.Data = jsonres;
return jsonresult;
}
这是读取数据的哪里。
public int QueryUserIdByName(string username,string password)
{
usertable model = db.usertable.Where(x => x.username == username || x.password == password).First();
if (model != null && model.id != 0)
{
return model.id;
}
return 0;
}