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