public Theme_model GetThemeIdModel(string themeName) { string sqlStr = "select [Theme_Id],[Theme_Name] from [tb_Theme] where Theme_Name= @themeName"; SqlParameter[] parameters = new SqlParameter[] { new SqlParameter("@themeName", themeName) }; DataTable dt = SqlHelper.ExecuteDataTable(sqlStr, parameters); if (dt.Rows.Count > 1) { //数据库出错处理,数据库里存在大于两条标题名一样的数据 ErrorMessage_bll errorMessage_bll = new ErrorMessage_bll(); errorMessage_bll.InsertErrorMessage("数据库出错", "数据库存在2条标题名一样的数据,用户名为:" + themeName); throw new Exception("more than 1 row was found"); } if (dt.Rows.Count <= 0) { return(null); } DataRow row = dt.Rows[0]; //把取回来的dt_Theme表的一行数据转化为model Theme_model model = new Theme_model(); model.themeName = (string)row["Theme_Name"]; model.themeId = (int)row["Theme_Id"]; return(model); }
/// <summary> /// 退出登录状态,退出成功返回1,失败返回0 /// login /// </summary> /// <returns></returns> public ActionResult AjaxMakeUnLogin() { Session["userName"] = null; Session["rank"] = null; return(Content("1")); People_bll people = new People_bll(); string username = Request["username"]; string password = Request["password"]; bool login = false; //true代表账号密码都正确 try { login = people.LoginYes(username, password); } catch (Exception e) { //数据库异常处理,数据库里存在大于两条用户名一样的数据 ErrorMessage_bll errorMessage_bll = new ErrorMessage_bll(); errorMessage_bll.InsertErrorMessage("数据库出错", "数据库里tb_User表存在大于2条用户名一样的数据,用户名为:" + username); return(Content("2")); } if (login) { //登录成功之后,保存用户的用户名,权限等资料到session Session["userName"] = username; Session["rank"] = "rank"; return(Content("1")); } else { return(Content("0")); } }
/// <summary> /// 根据用户名判断账号名是否存在,存在返回1,不存在返回0,数据库出错返回2 /// 用于Login页面、Register页面 /// </summary> /// <returns></returns> public ActionResult ajaxUserName() { string userName = Request["userName"].ToString(); People_bll people = new People_bll(); //数据库出错处理,数据库里存在大于两条用户名一样的数据 if (people.HavingUserName(userName) >= 2) { ErrorMessage_bll errorMessage_bll = new ErrorMessage_bll(); errorMessage_bll.InsertErrorMessage("数据库出错", "数据库存在2条用户名一样的数据,用户名为:" + userName); //return View("PeopleHomePage"); //throw new Exception("数据库出错,存在两条用户名一样的数据。"); } return(Content(people.HavingUserName(userName).ToString())); }
/// <summary> /// 判断登录是否成功,登录成功返回1,登录失败返回0,数据库异常返回2,用户类型不一致返回3 /// login /// </summary> /// <returns></returns> public ActionResult ajaxMakeLogin() { People_bll people = new People_bll(); string username = Request["username"].ToString(); string password = Request["password"].ToString(); string rankName = Request["rankName"].ToString(); bool login = false; //true代表账号密码都正确 try { login = people.LoginYes(username, password); } catch (Exception e) { //数据库异常处理,数据库里存在大于两条用户名一样的数据 ErrorMessage_bll errorMessage_bll = new ErrorMessage_bll(); errorMessage_bll.InsertErrorMessage("数据库出错", "数据库里tb_User表存在大于2条用户名一样的数据,用户名为:" + username); return(Content("2")); } if (login) { ////登录成功后,判断用户类型是否与用户填写的一致 Rank_bll rank_bll = new Rank_bll(); string rankNameDB = rank_bll.GetRankName(username); //该用户数据库里的等级名 rankNameDB = rankNameDB.Trim(); //去除空格 if (rankName != rankNameDB) { return(Content("3")); } //,保存用户的用户名,权限等资料到session Session["userName"] = username; Session["rank"] = rankName; User_bll user_bll = new User_bll(); Session["signature"] = user_bll.GetSignature(username); return(Content("1")); } else { return(Content("0")); } }