public LocalUser GetModelByPhone(string phoneNumber)
{
SystemDBContext.DBAutoConnect();
var result = Applicate.SystemDbContext.user.FirstOrDefault(u => u.Telephone == phoneNumber);
return(result);
}
public LocalUser GetModel()
{
SystemDBContext.DBAutoConnect();
var result = (
from user in Applicate.SystemDbContext.user
where user.UserId == this.UserId
select user
).FirstOrDefault();
return(result);
}
/// <summary>
/// 更新到数据库
/// </summary>
public void Update()
{
SystemDBContext.DBAutoConnect();
var result = (
from user in Applicate.SystemDbContext.user
where user.UserId == this.UserId
select user
).FirstOrDefault();
result = this;
Applicate.SystemDbContext.SaveChanges();
}
/// <summary>
/// 更新到数据库
/// </summary>
public void UpdatePwd(string phoneNumber, string password, int pwdLength)
{
lock (Applicate.SystemDbContext)
{
SystemDBContext.DBAutoConnect();
var localuser = Applicate.SystemDbContext.user.FirstOrDefault(l => l.Telephone == phoneNumber);
localuser.LastLoginTime = LastLoginTime; //设置登录时间
localuser.Password = password; //设置密码
localuser.PasswordLength = pwdLength; //设置密码长度
Applicate.SystemDbContext.SaveChanges(); //保存更改
}
}
/// <summary>
/// 删除
/// </summary>
public void Delete(string userId)
{
SystemDBContext.DBAutoConnect();
lock (Applicate.SystemDbContext.user)
{
var item = Applicate.SystemDbContext.user.FirstOrDefault(i => i.UserId == userId);
if (item != null)
{
Applicate.SystemDbContext.user.Remove(item);
}
}
Applicate.SystemDbContext.SaveChanges();
}
/// <summary>
/// 更新到数据库
/// </summary>
public List <LocalUser> GetAllList()
{
var result = new List <LocalUser>();
lock (Applicate.SystemDbContext.user)
{
SystemDBContext.DBAutoConnect();
result = (
from user in Applicate.SystemDbContext.user
select user
).ToList();
}
return(result);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Areas GetModel()
{
SystemDBContext.DBAutoConnect();
var result = (from area in Applicate.SystemDbContext.tbareas
where area.id == this.id
select area
).FirstOrDefault();
if (result == null)
{
result = new Areas();
}
return(result);
}
/// <summary>
/// 插入到数据库
/// </summary>
public void InsertOrUpdatePassword()
{
lock (Applicate.SystemDbContext)
{
SystemDBContext.DBAutoConnect();
if (this.id == null || this.id == Guid.Empty.ToString("N"))
{
this.id = Guid.NewGuid().ToString("N");
}
if (Applicate.SystemDbContext.user.Count(l => l.Telephone == this.Telephone) > 0) //如果数据库存在项
{
UpdatePwd(this.Telephone, this.Password, this.PasswordLength); //更新密码
}
else
{
Applicate.SystemDbContext.user.Add(this); //插入
}
int res = Applicate.SystemDbContext.SaveChanges(); //保存更改
}
}
/// <summary>
/// 更新上次离线时间
/// </summary>
/// <param name="userId">对应的用户</param>
/// <param name="lastexittime">上次离线时间</param>
internal void UpdateLastExitTime(string userId, long lastexittime)
{
lock (Applicate.SystemDbContext)
{
if (Applicate.SystemDbContext.user.Count(u => u.UserId == userId) > 0)//如果存在此人
{
SystemDBContext.DBAutoConnect();
var user = Applicate.SystemDbContext.user.FirstOrDefault(u => u.UserId == userId);
if (user != null)
{
ConsoleLog.Output("用户" + userId + "退出时间为:" + Helpers.StampToDatetime(LastExitTime).ToShortDateString());
user.LastExitTime = lastexittime; //更新离线时间
var tmp = Applicate.SystemDbContext.SaveChanges(); //保存更改
ConsoleLog.Output("保存退出时间为:" + tmp);
}
}
else
{
}
}
}
/// <summary>
/// 获取子项位置列表
/// </summary>
/// <returns></returns>
public List <Areas> GetChildrenList()
{
try
{
SystemDBContext.DBAutoConnect();
var result = (from area in Applicate.SystemDbContext.tbareas
where area.parent_id == this.parent_id &&
area.type == this.type
select area
).ToList();
if (result == null)
{
return(new List <Areas>());
}
return(result);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return(null);
}
}
/// <summary>
/// 根据时间获取本地用户
/// </summary>
/// <returns>最后登录的用户</returns>
internal LocalUser GetLastUserByTime()
{
SystemDBContext.DBAutoConnect();
lock (Applicate.SystemDbContext)
{
if (Applicate.SystemDbContext.user.Count() > 0)
{
var u1 = (from users in Applicate.SystemDbContext.user
orderby users.LastLoginTime descending
select users).FirstOrDefault();
var user = (from users in Applicate.SystemDbContext.user
orderby users.LastLoginTime ascending
select users
).FirstOrDefault();
return(u1);
}
else
{
return(null);
}
}
}