/// <summary>
/// 根据用户名和密码获取用户
/// </summary>
public static MUsers GetUsers(string inUserName, string inPassword)
{
string sql = @" SELECT * FROM nw_Users WHERE UserName = @inUserName AND Password = @inPassword ";
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@inUserName", SqlDbType.NVarChar, 50),
new SqlParameter("@inPassword", SqlDbType.VarChar, 50)
};
paras[0].Value = inUserName;
paras[1].Value = inPassword;
DataTable dt = SqlHelper.ExecuteDataTable(CommandType.Text, sql, "", paras);
MUsers model = null;
if (dt.Rows.Count > 0)
{
model = new MUsers
{
UID = Convert.ToInt32(dt.Rows[0]["UID"]),
UserName = dt.Rows[0]["UserName"].ToString(),
Password = dt.Rows[0]["Password"].ToString(),
Email = dt.Rows[0]["Email"].ToString()
};
}
return(model);
}
public void Update(int id, MUsers item)
{
var entity = _context.User.Find(id);
if (entity == null)
{
return;
}
_context.Entry(entity).CurrentValues.SetValues(item);
_context.SaveChanges();
}
/// <summary>
/// 创建用户
/// </summary>
public static int CreateUser(MUsers inModel)
{
StringBuilder sql = new StringBuilder();
sql.Append(" INSERT INTO nw_Users ( ");
sql.Append(" UserName, Password, Email ) VALUES ( ");
sql.Append(" @inUserName, @inPassword, @inEmail ) ");
SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@inUserName", SqlDbType.NVarChar, 50),
new SqlParameter("@inPassword", SqlDbType.VarChar, 50),
new SqlParameter("@inEmail", SqlDbType.VarChar, 50)
};
paras[0].Value = inModel.UserName;
paras[1].Value = inModel.Password;
paras[2].Value = inModel.Email;
int result = SqlHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), paras);
return(result);
}
public ActionResult OAuthLogin(string code)
{
try
{
if (string.IsNullOrEmpty(code))
{
throw new Exception("Your authorization code is already expired");
}
MUsers _user = new MUsers();
#region User Information
var _mailInfo = lIAuthenticate.UserInformation(code, SystemConfig.RedirectURI, SystemConfig.MicrosoftId, SystemConfig.MicrosoftSecret, "Microsoft", "rafi.ph");
_user.UMID = _mailInfo.id;
_user.FNAM = _mailInfo.firstname;
_user.LNAM = _mailInfo.lastname;
_user.MAIL = _mailInfo.mail;
_user.PICT = _mailInfo.picture;
_user.FULL = _mailInfo.firstname + " " + _mailInfo.lastname;
#endregion
var _emp = lIEmployees.Get(_user.MAIL);
_user.EMID = _emp.EmployeeId;
Session["Users"] = (_user as MUsers);
if (!_emp.Equals(0))
{
return(RedirectToAction("Index", "Page"));
}
else
{
return(RedirectToAction("Index", "Account"));
}
}
catch (Exception ex)
{
Session.RemoveAll();
TempData["msg"] = ex.Message;
return(RedirectToAction("Index", "Account"));
}
}
public void Put(int id, [FromBody] MUsers modal)
{
_User.Update(id, modal);
}
public void Post([FromBody] MUsers modal)
{
_User.Create(modal);
}
/// <summary>
/// 创建用户
/// </summary>
public static int CreateUser(MUsers inModel)
{
return(DUsers.CreateUser(inModel));
}
public void Create(MUsers item)
{
_context.User.Add(item);
_context.SaveChanges();
}
