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