public bool EditPW(string where_user_nameOrEmail, string edit_PassWord)
{
edit_PassWord = NMd5.GetMd5Hash(edit_PassWord);
string execSql = string.Format("Exec {0}_EditPW @Name=N'{1}',@PassWord='******' ", base.ETblName, where_user_nameOrEmail, edit_PassWord);
return(base.DUI(execSql) > 0 ? true : false);
}
//
// GET: /NLCQ/
public ActionResult Reg()
{
NModel.NewsPager model_pager = LoadConfig("/nlcq/reg");
string _Captcha = this.Request.Form["Captcha"];
string password = this.Request.Form["password"];
string isCueLoginStatus = this.Request["isCueLoginStatus"];
//验证码
if (!string.IsNullOrEmpty(_Captcha) && !string.IsNullOrEmpty(NModel.EnObject.GetCodeValue + ""))
{
if (_Captcha.Equals(NModel.EnObject.GetCodeValue + ""))
{
String JsonStr = "";
NModel.DB_User model = new NModel.DB_User();
BLL.DB_User bll_User = new BLL.DB_User();
bool isGet = Tool.NStr.PostForSetVal <NModel.DB_User>(ref model, ref JsonStr, "");
bool isUserNameExists = !String.IsNullOrEmpty(model.User_Name) && bll_User.ExistsName(model.User_Name);
if (isGet && !isUserNameExists)
{
bool isUserEmailExists = !String.IsNullOrEmpty(model.User_Email) && bll_User.ExistsEmail(model.User_Email);
if (!isUserEmailExists)
{
if (!string.IsNullOrEmpty(model.User_PW) && !string.IsNullOrEmpty(password))
{
//密码是否相同
if (model.User_PW.Trim().Equals(password.Trim()))
{
model.User_PW = NMd5.GetMd5Hash(model.User_PW);
//增加数据
if (bll_User.AddFree(model) > 0)
{
bll_User.CheckLogin(model.User_Name, model.User_PW, _Captcha, true);
Tool.NMsg.AlertAndRedirect("注册成功", "/nlcq/index");
}
//登录
//刷新验证码
NCaptcha.Generate(NModel.EnObject.UserCodeSessionName);
}
}
}
}
bll_User.Close();
}
}
// if(isGet&&model.)
return(View(model_pager));
}
public bool CheckLogin(string nameOrEmail, string pw, string code, bool isCueStatus = false)
{
// if (NTool.IsSessionEquals(NModel.EnObject.UserCodeSessionName, code))
{
NModel.DB_User cModel_User = this.ExistsNamePw((nameOrEmail + "").ToLower(), NMd5.GetMd5Hash(pw).ToLower());
if (cModel_User != null && cModel_User.User_ID > 0)
{
HttpContext.Current.Session[NModel.EnObject.LoginUserSessionName] = cModel_User.User_Name;
HttpContext.Current.Session[NModel.EnObject.CurrentLoginUserSessionName] = cModel_User;
if (isCueStatus)
{
BLL.DB_Session cModel = new DB_Session();
NModel.DB_Session cModel_Session = new NModel.DB_Session();
cModel_Session.Session_DB_Name = base.TableName;
cModel_Session.Session_UserID = cModel_User.User_ID;
cModel_Session.Session_CID = (HttpContext.Current.Session.SessionID + "");
cModel_Session.Session_Status = 1;
cModel_Session.Session_EndTime = DateTime.Parse(DateTime.Now.AddHours(60).ToString("s"));
///DateTime.Parse(DateTime.Now.AddHours(60).ToString("yyyy-MM-dd hh:mm:ss"));
cModel_Session.Session_AddTime = DateTime.Parse(DateTime.Now.ToString("s"));
if (cModel.Add(cModel_Session) > 0)
{
Tool.NTool.AddCookie(base.TableName, cModel_Session.Session_CID + "_" + cModel_User.User_ID, 60);
cModel.Close();
return(true);
}
;
cModel.Close();
}
else
{
return(true);
}
}
}
return(false);
}
