/// <summary>
/// 保存用户
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public static int SaveUser(User u)
{
try
{
WebDBEntities2 Entity = new WebDBEntities2();
if (u.Id > 0)
{
User entity = Entity.Users.FirstOrDefault(p => p.Id == u.Id);
entity.UserName = u.UserName;
entity.PhoneNum = u.PhoneNum;
entity.Email = u.Email;
entity.Sex = u.Sex;
entity.BirthDate = u.BirthDate;
entity.UserInfo = u.UserInfo;
entity.Status = u.Status;
entity.BingDoctorId = u.BingDoctorId;
entity.HeartMin = u.HeartMin;
entity.HeartMax = u.HeartMax;
entity.BloodMax = u.BloodMax;
entity.BloodMin = u.BloodMin;
entity.BloodMax2 = u.BloodMax2;
entity.BloodMin2 = u.BloodMin2;
}
else
{
Entity.Users.Add(u);
}
return(Entity.SaveChanges());
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex.Message);
return(0);
}
}
/// <summary>
/// 获取系统配置
/// </summary>
/// <returns></returns>
public static SysConfig GetSysConfig()
{
WebDBEntities2 Entity = new WebDBEntities2();
SysConfig sc = Entity.SysConfigs.FirstOrDefault();
return(sc);
}
/// <summary>
/// 获取所有菜单
/// </summary>
/// <returns></returns>
public static List <SortMenu> GetAllMenus()
{
WebDBEntities2 Entity = new WebDBEntities2();
var list = Entity.SortMenus.Where(p => p.UserTypeId == 1).OrderBy(p => p.Path).ToList();
return(list);
}
/// <summary>
/// 保存设备
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public static int SaveDevice(Device d)
{
try
{
WebDBEntities2 Entity = new WebDBEntities2();
Device device = Entity.Devices.FirstOrDefault(p => p.Imei == d.Imei);
if (device != null)//如果设备已存在
{
device.Status = d.Status;
device.IconId = d.IconId;
device.UserId = d.UserId;
device.APIDeviceId = d.APIDeviceId > 0 ? d.APIDeviceId : device.APIDeviceId;
device.APIDeviceModel = d.APIDeviceModel > 0 ? d.APIDeviceModel : device.APIDeviceModel;
}
else
{
Entity.Devices.Add(d);
}
Entity.SaveChanges();
return(0);
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex);
return(1);
}
}
/// <summary>
/// 保存系统公告 修改和新增
/// </summary>
/// <param name="n"></param>
/// <returns></returns>
public static int SaveNotice(Notice n)
{
try
{
WebDBEntities2 Entity = new WebDBEntities2();
Notice notice = Entity.Notices.FirstOrDefault(p => p.Id == n.Id);
if (notice != null)//修改
{
notice.Content = n.Content;
notice.CreateUser = n.CreateUser;
notice.CreateUserName = n.CreateUserName;
notice.Status = n.Status;
notice.Title = n.Title;
}
else
{//新增
Entity.Notices.Add(n);
}
return(Entity.SaveChanges());
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex);
return(0);
}
}
/// <summary>
/// 获取医生列表
/// </summary>
/// <returns></returns>
public static List <UserAndDoctor> GetUserAndDoctors(int pi, int pc)
{
pi--;
List <UserAndDoctor> users = new List <UserAndDoctor>();
WebDBEntities2 Entity = new WebDBEntities2();
var list = from u in Entity.Users
join d in Entity.Doctors
on u.Id equals d.UserId
where u.UserTypeId == 3
select new UserAndDoctor
{
Id = u.Id,
LoginName = u.LoginName,
UserName = u.UserName,
HeadImgId = u.HeadImgId.Value,
Position = d.Position,
Hospital = d.Hospital,
Subject = d.Subject,
PhoneNum = u.PhoneNum,
UserTypeId = u.UserTypeId.Value,
Sex = u.Sex.Value
};
users = list.OrderBy(p => p.Id).Skip(pi * pc).Take(pc).ToList();
return(users);
}
/// <summary>
/// 根据医生id获取所以绑定的用户,分页
/// </summary>
/// <param name="dId"></param>
/// <returns></returns>
public static List <User> GetUsersByDoctorId(int dId, int pi, int pc)
{
WebDBEntities2 Entity = new WebDBEntities2();
pi--;
return(Entity.Users.Where(p => p.BingDoctorId == dId && p.Status == (int)Status.Normal).OrderBy(p => p.Id).Skip(pi * pc).Take(pc).ToList());
}
/// <summary>
/// 保存指令下发记录
/// </summary>
/// <param name="cl"></param>
public static void SaveCmdLog(CmdLog cl)
{
WebDBEntities2 entity = new WebDBEntities2();
entity.CmdLogs.Add(cl);
entity.SaveChanges();
}
/// <summary>
/// 根据设备imei获取指令下发记录
/// </summary>
/// <param name="imei"></param>
/// <returns></returns>
public static List <CmdLog> GetCmdLogs(string imei)
{
WebDBEntities2 entity = new WebDBEntities2();
//取前100
return(entity.CmdLogs.Where(p => p.Imei == imei).OrderByDescending(p => p.SendDate).Take(100).ToList());
}
/// <summary>
/// 获取设备列表
/// </summary>
/// <param name="userTypeId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public static List <DeviceAndUser> GetDeviceList(int userTypeId, int userId, int pi, int pc)
{
List <DeviceAndUser> list = new List <DeviceAndUser>();
try
{
WebDBEntities2 Entity = new WebDBEntities2();
pi--;
IQueryable <DeviceAndUser> _l = null;
//医生只能获取到绑定了自己居民的设备列表
if (userTypeId == 3)
{
_l = Entity.DeviceAndUsers.Where(p => p.BingDoctorId == userId && p.Status == (int)Status.Normal);
}
//用户只取自己的
else if (userTypeId == 4)
{
_l = Entity.DeviceAndUsers.Where(p => p.UserId == userId && p.Status == (int)Status.Normal);
}
else if (userTypeId == 1 || userTypeId == 2)
{
_l = _l = Entity.DeviceAndUsers.Where(p => p.Status == (int)Status.Normal);
}
list = _l.OrderBy(p => p.DeviceId).Skip(pi * pc).Take(pc).ToList();
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex);
}
return(list);
}
/// <summary>
/// 保存医生信息
/// </summary>
/// <param name="d"></param>
/// <returns></returns>
public static int SaveDoctor(Doctor d)
{
try
{
WebDBEntities2 Entity = new WebDBEntities2();
Doctor doctor = Entity.Doctors.FirstOrDefault(p => p.UserId == d.UserId);
if (doctor != null)
{
doctor.Hospital = d.Hospital;
doctor.DoctorInfo = d.DoctorInfo;
doctor.Subject = d.Subject;
doctor.Position = d.Position;
}
else
{
Entity.Doctors.Add(d);
}
return(Entity.SaveChanges());
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex);
return(0);
}
}
/// <summary>
///更新用户头像
/// </summary>
/// <param name="userId">用户id</param>
/// <param name="imgId">图片id</param>
/// <returns></returns>
public static int UpdateUserHeadImg(int userId, int imgId)
{
WebDBEntities2 Entity = new WebDBEntities2();
User _u = Entity.Users.FirstOrDefault(p => p.Id == userId);
_u.HeadImgId = imgId;
return(Entity.SaveChanges());
}
/// <summary>
/// 更新队列时间
/// </summary>
/// <param name="queue"></param>
public static void UpdateQueueTime(CmdQueue queue)
{
WebDBEntities2 entity = new WebDBEntities2();
CmdQueue q = entity.CmdQueues.FirstOrDefault(p => p.APIDeviceId == queue.APIDeviceId && p.CmdCode == queue.CmdCode);
q.LastExecTime = DateTime.Now.AddMinutes(q.ExceTime ?? 0);
entity.SaveChanges();
}
/// <summary>
/// 根据用户id删除医生
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static int DeleteDoctorByUserId(int userId)
{
WebDBEntities2 Entity = new WebDBEntities2();
Doctor d = Entity.Doctors.FirstOrDefault(p => p.UserId == userId);
Entity.Doctors.Remove(d);
return(Entity.SaveChanges());
}
/// <summary>
/// 修改用户密码
/// </summary>
/// <param name="userId"></param>
/// <param name="pwd"></param>
/// <returns></returns>
public static User EditPwd(int userId, string pwd)
{
WebDBEntities2 Entity = new WebDBEntities2();
User user = Entity.Users.FirstOrDefault(p => p.Id == userId);
user.Pwd = pwd;
Entity.SaveChanges();
return(user);
}
/// <summary>
/// 逻辑删除用户
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static int DeleteUser(int userId)
{
WebDBEntities2 Entity = new WebDBEntities2();
User user = Entity.Users.FirstOrDefault(p => p.Id == userId);
user.Status = (int)Status.Deleted;
return(Entity.SaveChanges());
}
/// <summary>
/// 根据用户类型,和父级获取用户菜单
/// </summary>
/// <param name="userType"></param>
/// <returns></returns>
public static List <UserMenu> GetMenusByUType(int userType, int parentId)
{
WebDBEntities2 Entity = new WebDBEntities2();
var list = from u in Entity.UserMenus
join t in Entity.UserTypeToMenus on u.Id equals t.MenuId
where t.UserTypeId == userType && u.ParentId == parentId
select u;
return(list.ToList());
}
/// <summary>
/// 移除队列
/// </summary>
/// <param name="cmdCode"></param>
/// <param name="deviceId"></param>
public static void DelCmdQueue(string cmdCode, int deviceId)
{
WebDBEntities2 entity = new WebDBEntities2();
CmdQueue q = entity.CmdQueues.FirstOrDefault(p => p.APIDeviceId == deviceId && p.CmdCode == cmdCode);
if (q != null)
{
entity.CmdQueues.Remove(q);
entity.SaveChanges();
}
}
/// <summary>
/// 根据设备id获取用户，如果未绑定则返回空
/// </summary>
/// <param name="deviceId"></param>
/// <returns></returns>
public static User GetUserByDeviceId(int deviceId)
{
WebDBEntities2 entity = new WebDBEntities2();
Device _d = entity.Devices.FirstOrDefault(p => p.Id == deviceId);
if (_d == null || _d.UserId < 1)
{
return(null);
}
return(entity.Users.FirstOrDefault(p => p.Id == _d.UserId));
}
/// <summary>
/// 获取所有队列
/// </summary>
/// <returns></returns>
public static List <CmdQueue> GetCmdQueues()
{
WebDBEntities2 entity = new WebDBEntities2();
var list = from n in entity.CmdQueues
where System.Data.Entity.Core.Objects.EntityFunctions.DiffMinutes(DateTime.Now, n.LastExecTime) < 3
select n;
//select n;
// int i = list.ToList()[0].Value;
//entity.CmdQueues.Where(p => p.LastExecTime.Value.AddMinutes(p.ExceTime ?? 0) > DateTime.Now).ToList()
return(list.ToList());
}
/// <summary>
/// 更新用户信息
/// </summary>
/// <param name="u"></param>
/// <returns></returns>
public static int UpdateUser(User u)
{
WebDBEntities2 Entity = new WebDBEntities2();
User user = Entity.Users.First(p => p.Id == u.Id);
user.APIToken = u.APIToken;
user.APIUserId = u.APIUserId;
user.Email = u.Email;
user.LastLoginIp = u.LastLoginIp;
user.LastLoginTime = u.LastLoginTime;
return(Entity.SaveChanges());
}
/// <summary>
/// 将用户从医生中解绑
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static string UnBindUser(int userId)
{
WebDBEntities2 Entity = new WebDBEntities2();
User user = Entity.Users.FirstOrDefault(p => p.Id == userId);
if (user != null)
{
user.BingDoctorId = null;
}
Entity.SaveChanges();
return(user.LoginName);
}
/// <summary>
/// 根据id获取公告
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static Notice GetNoticeById(int id)
{
try
{
WebDBEntities2 Entity = new WebDBEntities2();
return(Entity.Notices.FirstOrDefault(p => p.Id == id));
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
return(null);
}
}
/// <summary>
/// 根据用户id获取用户
/// </summary>
/// <param name="userId"></param>
/// <returns></returns>
public static User GetUserById(int userId)
{
try
{
WebDBEntities2 Entity = new WebDBEntities2();
return(Entity.Users.FirstOrDefault(p => p.Status == (int)Status.Normal && p.Id == userId));
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex);
return(null);
}
}
/// <summary>
/// 获取最新的系统公告
/// </summary>
/// <returns></returns>
public static Notice GetLastNotice()
{
try
{
WebDBEntities2 Entity = new WebDBEntities2();
return(Entity.Notices.Where(p => p.Status == 0).OrderByDescending(p => p.Created).FirstOrDefault());
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
return(null);
}
}
/// <summary>
/// 根据状态获取所有系统公告
/// </summary>
/// <returns></returns>
public static List <Notice> GetNotices(int status)
{
WebDBEntities2 Entity = new WebDBEntities2();
try
{
return(Entity.Notices.Where(p => p.Status == status).OrderByDescending(p => p.Created).ToList());
}
catch (Exception ex)
{
LogHelper.WriteLog(ex);
return(null);
}
}
/// <summary>
/// 保存操作记录
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public static int SaveWebLog(WebLog log)
{
try
{
WebDBEntities2 Entity = new WebDBEntities2();
Entity.WebLogs.Add(log);
int res = Entity.SaveChanges();
return(res);
}
catch (Exception ex) {
LogHelper.ErrorLog(ex);
return(0);
}
}
/// <summary>
/// 根据用户类型返回用户列表,分页
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public static List <User> GetUserByType(int type, int pi, int pc)
{
try
{
WebDBEntities2 Entity = new WebDBEntities2();
pi--;
return(Entity.Users.Where(p => p.Status == (int)Status.Normal && p.UserTypeId == type).OrderBy(p => p.Id).Skip(pi * pc).Take(pc).ToList());
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex);
return(null);
}
}
/// <summary>
/// 根据id删除用户菜单
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static int DeleteUserMenu(UserMenu um)
{
try
{
WebDBEntities2 Entity = new WebDBEntities2();
Entity.UserMenus.Remove(Entity.UserMenus.First(p => p.Id == um.Id));
Entity.SaveChanges();
return(1);
}
catch (Exception ex)
{
LogHelper.ErrorLog(ex);
return(0);
}
}
/// <summary>
/// 获取所有日志的数量
/// </summary>
/// <returns></returns>
public static int GetWebLogCount(string date = "")
{
WebDBEntities2 Entity = new WebDBEntities2();
if (string.IsNullOrWhiteSpace(date))
{
return(Entity.WebLogs.Count());
}
else
{
DateTime todayMin = Convert.ToDateTime(date);
DateTime todayMax = Convert.ToDateTime(date + " 23:59:59");
return(Entity.WebLogs.Count(p => p.Created.Value > todayMin && p.Created.Value < todayMax));
}
}