/// <summary>
/// 登录
/// </summary>
/// <param name="username">用户名/手机号/邮箱</param>
/// <param name="password">密码</param>
/// <returns></returns>
public LoginResult Login(string username, string password, LoginUser loginUser)
{
try
{
using (var db = new SQLServerDataContext())
{
var entity = (from x in db.f_user
where (x.username == username || x.phone == username || x.email == username) && x.password == password
select x).SingleOrDefault() ?? null;
db.SubmitChanges();
if (null == entity)
{
LogHelper.Log.Info("用户名或密码错误");
return(LoginResult.USER_NAME_PWD_ERR);
}
//entity.LastLoginTime = DateTime.Now;
LogHelper.Log.Info(entity.user_id + " " + entity.username + " 登录进入 " + DateTime.Now);
return(LoginResult.SUCCESS);
}
}
catch (Exception ex)
{
LogHelper.Log.Error("用户登录异常..." + ex.Message);
return(LoginResult.FAIL_EXCEP);
}
}
/// <summary>
/// 查询用户是否存在
/// username \ phone \ email 返回为true时，验证成功
/// </summary>
/// <param name="username"></param>
/// <returns></returns>
private bool ExistUser(string username)
{
try
{
using (var db = new SQLServerDataContext())
{
f_user user = null;
user = (from x in db.f_user
where x.username == username || x.phone == username || x.email == username
select x).SingleOrDefault() ?? null;
if (user == null)
{
return(false);
}
else
{
return(true);
}
}
}
catch (Exception ex)
{
LogHelper.Log.Error("用户不存在 " + ex.Message);
return(false);
}
}
/// <summary>
/// 获取用户信息
/// </summary>
/// <param name="userName"></param>
/// <returns></returns>
public f_user GetUserInfo(string userName)
{
try
{
using (var db = new SQLServerDataContext())
{
var entity = (from x in db.f_user
where x.username == userName
select x).SingleOrDefault() ?? null;
return(entity);
}
}
catch
{
LogHelper.Log.Error("获取用户信息异常...");
return(null);
}
}
/// <summary>
/// 用户注册
/// </summary>
/// <param name="username"></param>
/// <param name="pwd"></param>
/// <param name="phone"></param>
/// <param name="email"></param>
/// <returns></returns>
private bool Register(string username, string pwd, string phone, string email)
{
try
{
using (var db = new SQLServerDataContext())
{
f_user option = null;
option = (from x in db.f_user
where x.username == username || x.phone == phone || x.email == email
select x).SingleOrDefault() ?? null;
if (null != option)
{
option.username = username;
option.password = pwd;
option.email = email;
option.phone = phone;
option.create_date = DateTime.Now;
option.last_update_date = DateTime.Now;
}
else
{
option = new f_user()
{
username = username,
password = pwd,
phone = phone,
email = email,
create_date = DateTime.Now,
last_update_date = DateTime.Now
};
db.f_user.InsertOnSubmit(option);
}
db.SubmitChanges();
return(true);
}
}
catch (Exception ex)
{
LogHelper.Log.Error("注册失败..." + ex.Message);
return(false);
}
}
/// <summary>
/// 连接SQL Server
/// </summary>
/// <returns></returns>
public bool SQLConnection()
{
SQLServerDataContext db = new SQLServerDataContext();
try
{
db.Connection.Open();
LogHelper.Log.Info("SQLServer connection successful!");
return(true);
}
catch (Exception ex)
{
LogHelper.Log.Error("无法连接SQL Server数据库\r" + ex.Message);
return(false);
}
finally
{
db.Dispose();
}
}
public ClienteRepository(SQLServerDataContext sqlServerDataContext)
: base(sqlServerDataContext)
{
this.sqlServerDataContext = sqlServerDataContext;
}
public BaseRepository(SQLServerDataContext sqlServerDataContext)
{
this.sqlServerDataContext = sqlServerDataContext;
}
public FilmeCategoriaRepository(SQLServerDataContext sqlServerDataContext)
: base(sqlServerDataContext)
{
this.sqlServerDataContext = sqlServerDataContext;
}
public RoleRepository(SQLServerDataContext oracleContext)
{
_db = oracleContext;
}
public UserLoginsRepository(SQLServerDataContext oracleContext)
{
_db = oracleContext;
}
public UserRolesRepository(SQLServerDataContext database)
{
_db = database;
}
public FilmeElencoRepository(SQLServerDataContext sqlServerDataContext)
: base(sqlServerDataContext)
{
this.sqlServerDataContext = sqlServerDataContext;
}
public UserRepository(SQLServerDataContext sqlServerContext)
{
_db = sqlServerContext;
}
public UserClaimsRepository(SQLServerDataContext oracleContext)
{
_db = oracleContext;
}
