public ActionResult Index([Bind(Include = "user_id,user_ip, user_name, user_password, user_email, user_profile_photo, user_level, user_rights, user_registration_time, user_birthday, user_age, user_telephone_number, user_nickname")] tb_users tb_Users) { if (ModelState.IsValid) { tb_Users.user_name = HttpContext.Request.Form["username"]; tb_Users.user_password = HttpContext.Request.Form["userpwd"]; tb_users new_user = db.tb_users.SqlQuery("select * from tb_users where user_name = '" + tb_Users.user_name + "'").FirstOrDefault(); if (new_user != null) { if (tb_Users.user_password == new_user.user_password) { if (new_user.user_rights == "管理员") { Handler.loginis = true; //证明用户登录过后台 Handler.loginid = new_user.user_id; tb_users user = new tb_users(); user.user_name = new_user.user_name; return(RedirectToAction("../Main/Index", user)); } Response.Write("<script>您不是管理员不能登录后台!</script>"); } tb_Users.user_password = "******"; } else { tb_Users.user_name = "没有这个用户"; tb_Users.user_password = ""; } } return(View(tb_Users)); }
// GET: YjLihouT public ActionResult Index(string n, tb_users user) { tb_users new_user; tb_users n_user; if (n != null) { n_user = db.tb_users.SqlQuery("select * from tb_users where user_name = '" + n + "'").FirstOrDefault(); Handler.loginid = n_user.user_id; if (n_user != null) { return(View(n_user)); } } if (user.user_name != null) { new_user = db.tb_users.SqlQuery("select * from tb_users where user_name = '" + user.user_name + "'").FirstOrDefault(); new_user.user_login_count++; db.Entry(new_user).State = EntityState.Modified; db.SaveChanges(); new_user.user_ip = GetIPAndMac.ipTrue(); return(View(new_user)); } n_user = db.tb_users.SqlQuery("select * from tb_users where user_name = '游客'").FirstOrDefault(); return(View(n_user)); }
//初始化登录信息 private void InitLogin(HttpContext context) { if (loginis) { if (loginid >= 1) { SqlParameter[] ID = { new SqlParameter("@ID", loginid) }; DataTable dt = DB.SqlQueryForDataTatable(db.Database, "select * from tb_users where user_id = @ID", ID); string json = f.DtToJson(dt); json = json.Replace("\"", "\\\""); tb_users new_user = db.tb_users.SqlQuery("select * from tb_users where user_id = " + loginid).FirstOrDefault(); new_user.user_login_time = DateTime.Now; new_user.user_ip = GetIPAndMac.ipTrue(); db.Entry(new_user).State = EntityState.Modified; db.SaveChanges(); context.Response.Write("{\"status\":\"" + json + "\"}"); } else { context.Response.Write("{\"status\":\"-1\"}"); } } else { tb_users users = new tb_users(); users.user_name = "游客"; users.user_nickname = "游客"; context.Response.Write(f.StToJSON(users)); } }
// GET: Login public ActionResult Index() { Handler.loginis = false; //用户登录重新证明 tb_users tb_Users = new tb_users(); tb_Users.user_name = "请输入用户名"; tb_Users.user_password = "******"; return(View(tb_Users)); }