public IEnumerable <ProjectFile> GetProjectFileList()
{
using (var dbContext = new DKLManagerDbContext())
{
return(dbContext.FindAll <ProjectFile>());
}
}
public void AddVlaueProjectInfo(ValueProjectInfo role)
{
using (var dbContext = new DKLManagerDbContext())
{
dbContext.Insert <ValueProjectInfo>(role);
}
}
public void UpdateVlaueProjectInfo(ValueProjectInfo role)
{
using (var dbContext = new DKLManagerDbContext())
{
dbContext.Update <ValueProjectInfo>(role);
}
}
public IList <DeviceStateModel> GetStateList()
{
using (var dbContext = new DKLManagerDbContext())
{
return(dbContext.FindAll <DeviceStateModel>());
}
}
public IEnumerable <ValueProjectInfo> GetVlaueProjectInfoList()
{
using (var dbContext = new DKLManagerDbContext())
{
return(dbContext.FindAll <ValueProjectInfo>());
}
}
public ValueProjectInfo GetVlaueProjectInfo(int id)
{
using (var dbContext = new DKLManagerDbContext())
{
return(dbContext.ValueProjectInfo.Where(c => c.ID == id).SingleOrDefault());
}
}
public void UpdateProjectFile(ProjectFile role)
{
using (var dbContext = new DKLManagerDbContext())
{
dbContext.Update <ProjectFile>(role);
}
}
public void AddProjectFile(ProjectFile role)
{
using (var dbContext = new DKLManagerDbContext())
{
dbContext.Insert <ProjectFile>(role);
}
}
public void InsertState(DeviceStateModel state)
{
using (var dbContext = new DKLManagerDbContext())
{
dbContext.Insert <DeviceStateModel>(state);
}
}
public DeviceStateModel Select(int id)
{
using (var dbContext = new DKLManagerDbContext())
{
return(dbContext.DeviceState.Where(u => u.ID == id).SingleOrDefault());
}
}
public ProjectFile GetProjectFile(int id)
{
using (var dbContext = new DKLManagerDbContext())
{
return(dbContext.ProjectFile.Where(c => c.ID == id).SingleOrDefault());
}
}
public void UpdateConsultBasicInfo(ConsultBasicInfo role)
{
using (var dbContext = new DKLManagerDbContext())
{
dbContext.Update <ConsultBasicInfo>(role);
}
}
public void AddConsultBasicInfo(ConsultBasicInfo role)
{
using (var dbContext = new DKLManagerDbContext())
{
dbContext.Insert <ConsultBasicInfo>(role);
}
}
public IEnumerable <ConsultBasicInfo> GetConsultBasicInfoList()
{
using (var dbContext = new DKLManagerDbContext())
{
return(dbContext.FindAll <ConsultBasicInfo>());
}
}
public ConsultBasicInfo GetConsultBasicInfo(int id)
{
using (var dbContext = new DKLManagerDbContext())
{
return(dbContext.ConsultBasicInfo.Where(c => c.ID == id).SingleOrDefault());
}
}
public void UpDateState(DeviceStateModel state)
{
using (var dbContext = new DKLManagerDbContext())
{
dbContext.Update <DeviceStateModel>(state);
}
}
public void DeleteConsultBasicInfo(List <int> ids)
{
using (var dbContext = new DKLManagerDbContext())
{
dbContext.ConsultBasicInfo.Where(u => ids.Contains(u.ID)).ToList().ForEach(a => { dbContext.ConsultBasicInfo.Remove(a); });
dbContext.SaveChanges();
}
}
public void DeleteState(List <int> ids)
{
using (var dbContext = new DKLManagerDbContext())
{
dbContext.DeviceState.Where(u => ids.Contains(u.ID)).ToList().ForEach(a => { dbContext.DeviceState.Remove(a); });
dbContext.SaveChanges();
}
}
