/// <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="id"></param>
/// <returns></returns>
public SolitaireSet GetModel(int id)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var model = db.SolitaireSet.FirstOrDefault(p => p.Id == id);
return(model);
}
}
/// <summary>
/// 获取单条数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Administrative GetModel(int id)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var model = db.Administrative.FirstOrDefault(p => p.Id == id);
return(model);
}
}
/// <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="id"></param>
/// <returns></returns>
public Professionalgroup GetModel(int id)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var model = db.Professionalgroup.FirstOrDefault(p => p.Id == id);
return(model);
}
}
/// <summary>
/// 获取人员
/// </summary>
/// <returns></returns>
public List <Clinicuser> GetClinical()
{
using (hospitaldbContext db = new hospitaldbContext())
{
List <Clinicuser> list = db.Clinicuser.ToList();
return(list);
}
}
/// <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>
/// <returns></returns>
public List <Shiftssetting> GetShift()
{
using (hospitaldbContext db = new hospitaldbContext())
{
List <Shiftssetting> list = db.Shiftssetting.ToList();
return(list);
}
}
/// <summary>
/// 获取科室
/// </summary>
/// <returns></returns>
public List <Administrative> GetDepartment()
{
using (hospitaldbContext db = new hospitaldbContext())
{
List <Administrative> list = db.Administrative.ToList();
return(list);
}
}
/// <summary>
/// 获取最大编号
/// </summary>
/// <returns></returns>
public int GetMaxId()
{
using (hospitaldbContext db = new hospitaldbContext())
{
int id = db.SolitaireSet.OrderBy(u => u.Id).FirstOrDefault().Id;
return(id);
}
}
/// <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="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(Clinicuser model)
{
using (hospitaldbContext db = new hospitaldbContext())
{
db.Clinicuser.Add(model);
return(db.SaveChanges());
}
}
/// <summary>
/// 获取单条数据
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Clinicuser GetModel(int id)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var model = db.Clinicuser.FirstOrDefault(p => p.Id == id);
return(model);
}
}
/// <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>
/// <returns></returns>
public List <Shiftssetting> GetShiftssettings(string name)
{
using (Model.hospitaldbContext ef = new hospitaldbContext())
{
List <Model.Shiftssetting> list = ef.Shiftssetting.Where(u => string.IsNullOrEmpty(name) || u.ShiftssettingName == name).OrderBy(u => u.Sortid).ToList();
return(list);
}
}
/// <summary>
/// 获取最大编号
/// </summary>
/// <returns></returns>
public int GetId()
{
using (Model.hospitaldbContext eF = new hospitaldbContext())
{
int id = eF.Shiftssetting.OrderBy(u => u.Id).LastOrDefault().Id;
return(id);
}
}
/// <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="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="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="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(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="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>
/// <returns></returns>
public PageHelper <Professionalgroup> GetPagedList(int pageIndex, int pageSize, string name)
{
using (hospitaldbContext db = new hospitaldbContext())
{
var pageList = new PageHelper <Professionalgroup>();
var list = db.Professionalgroup.OrderBy(p => p.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
var total = db.Professionalgroup.Count();
if (name != null)
{
list = db.Professionalgroup.OrderBy(p => p.Id).Where(p => p.ProfessionalGroupName.Contains(name)).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
total = db.Professionalgroup.Count(p => p.ProfessionalGroupName.Contains(name));
}
pageList.PageSizes = total; //总条数
pageList.PageList = list; //查询数据集合
pageList.PageNum = (pageList.PageSizes / pageSize); //总页数
return(pageList);
}
}
/// <summary>
/// 获取人员
/// </summary>
/// <returns></returns>
public PageHelper <Clinicuser> GetPerson(int pageIndex, int pageSize, string name)
{
hospitaldbContext db = new hospitaldbContext();
var pageList = new PageHelper <Clinicuser>();
var list = db.Clinicuser.OrderBy(p => p.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
var total = db.Clinicuser.Count();
//根据人员名称查询
if (name != null)
{
list = db.Clinicuser.OrderBy(p => p.Id).Where(p => p.ClinicUserName.Contains(name)).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
total = db.Clinicuser.Count(p => p.ClinicUserName.Contains(name));
}
pageList.PageSizes = total; //总条数
pageList.PageList = list; //查询数据集合
pageList.PageNum = (pageList.PageSizes / pageSize); //总页数
return(pageList);
}
/// <summary>
/// 分页查询
/// </summary>
/// <returns></returns>
public PageHelper <AttendanceSummary> GetPagedList(int pageIndex, int pageSize, string name)
{
hospitaldbContext db = new hospitaldbContext();
var pageList = new PageHelper <AttendanceSummary>();
var list = db.AttendanceSummary.OrderBy(p => p.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
var total = db.AttendanceSummary.Count();
//根据人员名称查询
if (name != null)
{
list = db.AttendanceSummary.OrderBy(p => p.Id).Where(p => p.Person.Contains(name)).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
total = db.AttendanceSummary.Count(p => p.Person.Contains(name));
}
pageList.PageSizes = total; //总条数
pageList.PageList = list; //查询数据集合
pageList.PageNum = (pageList.PageSizes / pageSize); //总页数
return(pageList);
}
/// <summary>
/// 分页查询
/// </summary>
/// <returns></returns>
public PageHelper <SolitaireSet> GetPagedList(int pageIndex, int pageSize, string shift)
{
hospitaldbContext db = new hospitaldbContext();
var pageList = new PageHelper <SolitaireSet>();
var list = db.SolitaireSet.OrderBy(p => p.Id).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
var total = db.SolitaireSet.Count();
//根据班次查询
if (shift != null)
{
list = db.SolitaireSet.OrderBy(p => p.Id).Where(p => p.Shift.Contains(shift)).Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
total = db.SolitaireSet.Count(p => p.Shift.Contains(shift));
}
pageList.PageSizes = total; //总条数
pageList.PageList = list; //查询数据集合
pageList.PageNum = (pageList.PageSizes / pageSize); //总页数
return(pageList);
}
