public bool Register(RegisterRowData data) { bool result = false; try { var record = dbcontext.S_USER.FirstOrDefault(x => x.EMAIL == data.Email || x.PHONE == data.Phone); if (record == null) { record = new S_USER(); record.USER_ID = commonModel.GetAutoId("USER_ID", "S_USER"); record.FULL_NAME = data.Fullname; record.EMAIL = data.Email; record.PASSWORD = commomFunction.MD5Hash(data.Password); record.PHONE = data.Phone; record.ADDRESS = data.Address; record.PACKED_ID = ConstantClass.PACKED_DEFAULT; record.USER_TYPE = data.Usertype; dbcontext.S_USER.Add(record); dbcontext.SaveChanges(); result = true; } } catch (Exception ex) { logger.Error("Register - " + ex); result = false; } return(result); }
public ActionResult CheckLogin(string username, string password, string code) { try { if (Session["nfine_session_verifycode"].IsEmpty() || Md5.md5(code.ToLower(), 16) != Session["nfine_session_verifycode"].ToString()) { throw new Exception("验证码错误,请重新输入"); } S_USER user = ZGEDrySaltery.BLL.SUserBLL.GetInstance().CheckLogin(username, password); if (user != null && user.USER_ID != 0) { OperatorProvider.Provider.AddCurrent(user); return(Content(new AjaxResult { state = ResultType.success.ToString(), message = "登录成功。" }.ToJson())); } else { return(Content(new AjaxResult { state = ResultType.error.ToString(), message = "该用户不存在。" }.ToJson())); } } catch (Exception ex) { return(Content(new AjaxResult { state = ResultType.error.ToString(), message = "登录失败," + ex.Message }.ToJson())); } }
/// <summary> /// 检测登录用户信息 /// </summary> public S_USER CheckLogin(string account, string password) { string sqlValue = @"SELECT * FROM S_USER WHERE TEL=@ACCOUNT AND USER_PSD =@PASSWORD UNION ALL SELECT * FROM S_USER WHERE REAL_NAME=@ACCOUNT AND USER_PSD =@PASSWORD UNION ALL SELECT * FROM S_USER WHERE USER_NAME=@ACCOUNT AND USER_PSD =@PASSWORD "; List <MySqlParameter> parameters = new List <MySqlParameter>(); parameters.Add(new MySqlParameter("@ACCOUNT", account)); parameters.Add(new MySqlParameter("@PASSWORD", password)); S_USER model = new S_USER(); try { using (IDataReader reader = DbHelperMySQL.ExecuteReader(sqlValue, parameters.ToArray())) { while (reader.Read()) { model = DataReaderToModel(reader); } } } catch (Exception e) { throw; } return(model); }
public void AddCurrent(S_USER operatorModel) { if (LoginProvider == "Cookie") { WebHelper.WriteCookie(LoginUserKey, DESEncrypt.Encrypt(operatorModel.ToJson()), 60); } else { WebHelper.WriteSession(LoginUserKey, DESEncrypt.Encrypt(operatorModel.ToJson())); } WebHelper.WriteCookie("nfine_mac", Md5.md5(Net.GetMacByNetworkInterface().ToJson(), 32)); WebHelper.WriteCookie("nfine_licence", Licence.GetLicence()); }
public S_USER GetCurrent() { S_USER operatorModel = new S_USER(); if (LoginProvider == "Cookie") { operatorModel = DESEncrypt.Decrypt(WebHelper.GetCookie(LoginUserKey).ToString()).ToObject <S_USER>(); } else { operatorModel = DESEncrypt.Decrypt(WebHelper.GetSession(LoginUserKey).ToString()).ToObject <S_USER>(); } return(operatorModel); }
/// <summary> /// 检测登录用户信息 /// </summary> public S_USER CheckLogin(string account, string password) { try { string pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "MD5"); S_USER suser = DAL.SUserDAL.GetInstance().CheckLogin(account, pwd); return(suser); } catch (Exception ex) { log.Error(ex.Message); } return(null); }
/// <summary> /// 得到一个对象实体 /// </summary> public S_USER DataReaderToModel(IDataReader row) { S_USER model = new S_USER(); if (row != null) { if (row["USER_ID"] != null && row["USER_ID"].ToString() != "") { model.USER_ID = int.Parse(row["USER_ID"].ToString()); } if (row["ORG_ID"] != null && row["ORG_ID"].ToString() != "") { model.ORG_ID = int.Parse(row["ORG_ID"].ToString()); } if (row["USER_NAME"] != null) { model.USER_NAME = row["USER_NAME"].ToString(); } if (row["REAL_NAME"] != null) { model.REAL_NAME = row["REAL_NAME"].ToString(); } if (row["SEX"] != null) { model.SEX = row["SEX"].ToString(); } if (row["ID_CARD"] != null) { model.ID_CARD = row["ID_CARD"].ToString(); } if (row["USER_PSD"] != null) { model.USER_PSD = row["USER_PSD"].ToString(); } if (row["OPEN_ID"] != null) { model.OPEN_ID = row["OPEN_ID"].ToString(); } if (row["TEL"] != null) { model.TEL = row["TEL"].ToString(); } if (row["EMAIL"] != null) { model.EMAIL = row["EMAIL"].ToString(); } if (row["IMAGE_PATH"] != null) { model.IMAGE_PATH = row["IMAGE_PATH"].ToString(); } if (row["LAST_ONLINE_TIME"] != null && row["LAST_ONLINE_TIME"].ToString() != "") { model.LAST_ONLINE_TIME = DateTime.Parse(row["LAST_ONLINE_TIME"].ToString()); } if (row["LOGIN_TIMES"] != null && row["LOGIN_TIMES"].ToString() != "") { model.LOGIN_TIMES = int.Parse(row["LOGIN_TIMES"].ToString()); } if (row["ENABLE_FLAG"] != null) { model.ENABLE_FLAG = row["ENABLE_FLAG"].ToString(); } if (row["CREATE_USER_ID"] != null) { model.CREATE_USER_ID = row["CREATE_USER_ID"].ToString(); } if (row["CREATE_TIME"] != null && row["CREATE_TIME"].ToString() != "") { model.CREATE_TIME = DateTime.Parse(row["CREATE_TIME"].ToString()); } if (row["UPDATE_USER_ID"] != null) { model.UPDATE_USER_ID = row["UPDATE_USER_ID"].ToString(); } if (row["UPDATE_TIME"] != null && row["UPDATE_TIME"].ToString() != "") { model.UPDATE_TIME = DateTime.Parse(row["UPDATE_TIME"].ToString()); } if (row["REMARK"] != null) { model.REMARK = row["REMARK"].ToString(); } if (row["TENANT_ID"] != null && row["TENANT_ID"].ToString() != "") { model.TENANT_ID = int.Parse(row["TENANT_ID"].ToString()); } } return(model); }