/// <summary>
/// 添加职务
/// </summary>
/// <param name="position"></param>
/// <returns></returns>
public int AddPosition(Position position)
{
var addposition = db.Position.Add(position);
var i = db.SaveChanges();
return(i);;
}
/// <summary>
/// 添加能级
/// </summary>
/// <param name="hierarchy"></param>
/// <returns></returns>
public int AddHierarchy(Hierarchy hierarchy)
{
var addhierarchy = db.Hierarchy.Add(hierarchy);
var i = db.SaveChanges();
return(i);;
}
/// <summary>
/// 添加手术室用户
/// </summary>
/// <param name="operuser"></param>
/// <returns></returns>
public int AddOoperationUser(Ooperationuser operuser)
{
db.Ooperationuser.Add(operuser);
var addOoperationUser = db.SaveChanges();
return(addOoperationUser);
}
/// <inheritdoc />
/// <summary>
/// 添加院区信息
/// </summary>
/// <param name="area"></param>
/// <returns></returns>
public int AddArea(Area area)
{
//附一个初始值
area.Isnable = 0;
_context.Add(area);
var result = _context.SaveChanges();
return(result);
}
/// <summary>
/// 是否开启手术间
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public int EnableOperationRoom(int id)
{
var area = _context.Operationroom.FirstOrDefault(p => p.Id == id);
if (area != null)
{
area.EnableOperation = 3;
}
var result = _context.SaveChanges();
return(result);
}
/// <summary>
/// 添加配置表信息
/// </summary>
/// <param name="approvalConfiguration"></param>
/// <returns></returns>
public int AddApprovalConfiguration(List <ApprovalConfiguration> approvalConfiguration)
{
var result = 0;
var oneId = 0;
var twoId = 0;
using (var tr = _context.Database.BeginTransaction())
{
try
{ //进行循环这个集合
foreach (var configuration in approvalConfiguration)
{
//进行一个添加操作
_context.ApprovalConfiguration.Add(configuration);
//进入保存一个操作
_context.SaveChanges();
//先进行把TwoId赋值给OneId
oneId = twoId;
//再把twoId赋值为当前的Id
twoId = configuration.Id;
//去配置表中查询是否有这个活动而且下一步Id为0的数据
var queryable = _context.ApprovalConfiguration.FirstOrDefault(p => p.Id == oneId);
if (queryable == null)
{
continue;
}
queryable.DownId = twoId;
//如果为空那么返回自增长Id
result = _context.SaveChanges();
//不为空则修改为当前自增长Id
}
tr.Commit();
return(1);
}
catch (Exception e)
{
tr.Rollback();
Console.WriteLine(e);
return(result);
}
finally
{
_context.Dispose();
}
}
//var result = _context.SaveChanges();
//return result;
}
/// <summary>
/// 修改状态
/// </summary>
/// <param name="role"></param>
/// <returns></returns>
public int UpdateEnable(Role role)
{
var model = db.Role.FirstOrDefault(p => p.Id == role.Id);
model.Isnable = role.Isnable;
return(db.SaveChanges());
}
/// <summary>
/// 更改排序id 向前
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool UpdateSortId(int id)
{
using (hospitaldbContext db = new hospitaldbContext())
{
int sortId = db.SolitaireSet.Find(id).SortId;
if (sortId <= 1)
{
return(false);
}
else
{
int ids = db.SolitaireSet.OrderByDescending(u => u.SortId).First(u => u.SortId < sortId).SortId;
SolitaireSet solitaireSet = db.SolitaireSet.Find(id);
solitaireSet.SortId = ids;
SolitaireSet solitaireSete = db.SolitaireSet.FirstOrDefault(u => u.SortId == ids);
solitaireSete.SortId = sortId;
bool b1 = db.SaveChanges() > 0;
if (b1)
{
return(true);
}
else
{
return(false);
}
}
}
}
/// <summary>
/// 更改排序id 向前
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool UpdateSortid(int id)
{
using (Model.hospitaldbContext eF = new hospitaldbContext())
{
int?sortid = eF.Shiftssetting.Find(id).Sortid;
if (sortid <= 1)
{
return(false);
}
else
{
int?ii = eF.Shiftssetting.OrderByDescending(u => u.Sortid).First(u => u.Sortid < sortid).Sortid;
Model.Shiftssetting shiftssetting = eF.Shiftssetting.Find(id);
shiftssetting.Sortid = ii;
//bool b1 = eF.SaveChanges() > 0;
Model.Shiftssetting shiftssetting2 = eF.Shiftssetting.FirstOrDefault(u => u.Sortid == ii);
shiftssetting2.Sortid = sortid;
bool b2 = eF.SaveChanges() > 0;
if (b2)
{
return(true);
}
else
{
return(false);
}
}
}
}
/// <summary>
/// 更改排序id 向后
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DownSortId(int id)
{
using (hospitaldbContext db = new hospitaldbContext())
{
int maxId = GetMaxId();
int sortId = db.SolitaireSet.Find(id).SortId;
if (sortId >= maxId)
{
return(false);
}
else
{
int ids = db.SolitaireSet.OrderBy(u => u.SortId).First(u => u.SortId > sortId).SortId;
SolitaireSet solitaireSet = db.SolitaireSet.Find(id);
solitaireSet.SortId = ids;
SolitaireSet solitaireSete = db.SolitaireSet.FirstOrDefault(u => u.SortId == ids);
solitaireSete.SortId = sortId;
bool b2 = db.SaveChanges() > 0;
if (b2)
{
return(true);
}
else
{
return(false);
}
}
}
}
/// <summary>
/// 更改排序id 向后
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DownSortid(int id)
{
using (Model.hospitaldbContext eF = new hospitaldbContext())
{
int orldid = GetId();
int?sortid = eF.Shiftssetting.Find(id).Sortid;
if (sortid >= orldid)
{
return(false);
}
else
{
int?ii = eF.Shiftssetting.OrderBy(u => u.Sortid).First(u => u.Sortid > sortid).Sortid;
Model.Shiftssetting shiftssetting = eF.Shiftssetting.Find(id);
shiftssetting.Sortid = ii;
//bool b1 = eF.SaveChanges() > 0;
Model.Shiftssetting shiftssetting2 = eF.Shiftssetting.FirstOrDefault(u => u.Sortid == ii);
shiftssetting2.Sortid = sortid;
bool b2 = eF.SaveChanges() > 0;
if (b2)
{
return(true);
}
else
{
return(false);
}
}
}
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="shiftssetting"></param>
/// <returns></returns>
public bool UpdateShiftssetting(Shiftssetting shiftssetting)
{
using (Model.hospitaldbContext ef = new hospitaldbContext())
{
ef.Entry(shiftssetting).State = Microsoft.EntityFrameworkCore.EntityState.Modified;
return(ef.SaveChanges() > 0);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="shiftssetting"></param>
/// <returns></returns>
public bool AddShiftssetting(Shiftssetting shiftssetting)
{
using (Model.hospitaldbContext ef = new hospitaldbContext())
{
ef.Add(shiftssetting);
return(ef.SaveChanges() > 0);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
public int Add(Clinicuser model)
{
using (hospitaldbContext db = new hospitaldbContext())
{
db.Clinicuser.Add(model);
return(db.SaveChanges());
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
public int Add(Administrative model)
{
using (hospitaldbContext db = new hospitaldbContext())
{
db.Administrative.Add(model);
return(db.SaveChanges());
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
public int Add(Professionalgroup model)
{
using (hospitaldbContext db = new hospitaldbContext())
{
db.Professionalgroup.Add(model);
return(db.SaveChanges());
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
public int Add(SolitaireSet model)
{
using (hospitaldbContext db = new hospitaldbContext())
{
db.SolitaireSet.Add(model);
return(db.SaveChanges());
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
public int Delete(int id)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var model = db.SolitaireSet.FirstOrDefault(p => p.Id == id);
db.SolitaireSet.Remove(model);
return(db.SaveChanges());
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public bool DeleteShiftssetting(int id)
{
using (Model.hospitaldbContext ef = new hospitaldbContext())
{
Model.Shiftssetting shiftssetting = ef.Shiftssetting.Find(id);
ef.Remove(shiftssetting);
return(ef.SaveChanges() > 0);
}
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
public int Delete(int id)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var model = db.Professionalgroup.FirstOrDefault(p => p.Id == id);
db.Professionalgroup.Remove(model);
return(db.SaveChanges());
}
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="model"></param>
public int Update(Administrative model)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var info = db.Administrative.FirstOrDefault(p => p.Id == model.Id);
info.AdministrativeName = model.AdministrativeName; //名称
info.Isoperation = model.Isoperation; //是否为手术间
info.AdministrativeRemark = model.AdministrativeRemark; //备注
return(db.SaveChanges());
}
}
/// <summary>
/// 启用
/// </summary>
/// <param name="id"></param>
public int Enable(int id)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var user = db.Administrative.FirstOrDefault(p => p.Id == id);
if (user != null)
{
user.IsEnable = 0; //启用
}
return(db.SaveChanges());
}
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="model"></param>
public int Update(SolitaireSet model)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var info = db.SolitaireSet.FirstOrDefault(p => p.Id == model.Id);
info.Shift = model.Shift; //班次
info.SolitaireCycle = model.SolitaireCycle; //周期
info.GroupMember = model.GroupMember; //成员
info.GroupLeader = model.GroupLeader; //组长
return(db.SaveChanges());
}
}
/// <summary>
/// 禁用
/// </summary>
/// <param name="id"></param>
public int Delete(int id)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var user = db.Clinicuser.FirstOrDefault(p => p.Id == id);
if (user != null)
{
user.IsEnable = 1; //禁用
}
return(db.SaveChanges());
}
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="model"></param>
public int Update(Clinicuser model)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var info = db.Clinicuser.FirstOrDefault(p => p.Id == model.Id);
info.ClinicUserName = model.ClinicUserName; //名称
info.Aadministrativeid = model.Aadministrativeid; //所属科室
info.Jobnumber = model.Jobnumber; //工号
info.Sex = model.Sex; //性别
info.ClinicUserRemark = model.ClinicUserRemark; //备注
return(db.SaveChanges());
}
}
/// <summary>
/// 编辑
/// </summary>
/// <param name="model"></param>
public int Update(Professionalgroup model)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var info = db.Professionalgroup.FirstOrDefault(p => p.Id == model.Id);
info.ProfessionalGroupName = model.ProfessionalGroupName; //专业组名称
info.ProfessionalGroupColore = model.ProfessionalGroupColore; //颜色
info.DepartmentId = model.DepartmentId; //关联科室
info.TeachingId = model.TeachingId; //带教
info.GroupLeader = model.GroupLeader; //组长
info.TeamMember = model.TeamMember; //组员
return(db.SaveChanges());
}
}
/// <summary>
/// 添加权限
/// </summary>
/// <param name="permission"></param>
/// <returns></returns>
public int AddPermission(Permission permission)
{
db.Permission.Add(permission);
return(db.SaveChanges());
}
