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