/// <summary>
/// 取得LocalDB
/// </summary>
/// <param name="doctor">醫生資訊</param>
/// <returns></returns>
public static Doctor GetSystemDoctor(Doctor doctor)
{
using (var db = new LocalDBContext())
{
return(db.Doctors.Where(x => x.Name == doctor.Name).FirstOrDefault());
}
}
public static List <Doctor> GetAllDoctorToList()
{
using (var db = new LocalDBContext())
{
return(db.Doctors.ToList());
}
}
/// <summary>
/// 取得所有的Clinic
/// </summary>
/// <returns></returns>
public static List <ClinicRoom> GetAllClinicToList()
{
using (var db = new LocalDBContext())
{
return(db.ClinicRooms.ToList());
}
}
/// <summary>
/// 取得LocalDB
/// </summary>
/// <param name="clinic">科別資訊</param>
/// <returns></returns>
public static ClinicRoom GetClinic(ClinicRoom clinic)
{
using (var db = new LocalDBContext())
{
return(db.ClinicRooms.Where(x => x.Code == clinic.Code).FirstOrDefault());
}
}
/// <summary>
/// 取得LocalDB
/// </summary>
/// <param name="systemConfigType">傳入所定義的列舉參數</param>
/// <returns></returns>
public static SystemConfig GetSystemConfig(SystemConfigType systemConfigType)
{
using (var db = new LocalDBContext())
{
return(db.SystemConfigs.Where(x => x.Code == (int)systemConfigType).FirstOrDefault());
}
}
public static bool ClearDoctor()
{
using (var db = new LocalDBContext())
{
db.Database.ExecuteSqlCommand("DELETE FROM Doctors; update sqlite_sequence set seq = '0' where name = 'Doctors'");
return(db.SaveChanges() > 0);
}
}
/// <summary>
/// 儲存LocalDB
/// </summary>
/// <param name="doctor">醫生資訊</param>
public static void SaveDoctor(Doctor doctor)
{
using (var db = new LocalDBContext())
{
var obj = db.Doctors.Where(x => x.Name == doctor.Name).FirstOrDefault();
obj.Name = doctor.Name;
db.SaveChanges();
}
}
/// <summary>
/// 儲存LocalDB
/// </summary>
/// <param name="clinic">科別資訊</param>
public static void SaveClinic(ClinicRoom clinic)
{
using (var db = new LocalDBContext())
{
var obj = db.ClinicRooms.Where(x => x.Code == clinic.Code).FirstOrDefault();
obj.Name = clinic.Name;
db.SaveChanges();
}
}
/// <summary>
/// 儲存LocalDB
/// </summary>
/// <param name="systemConfig">每次必定會儲存所有參數</param>
public static void SaveSystemConfig(SystemConfig systemConfig)
{
using (var db = new LocalDBContext())
{
var obj = db.SystemConfigs.Where(x => x.Code == systemConfig.Code).FirstOrDefault();
obj.Value = systemConfig.Value;
db.SaveChanges();
}
}
/// <summary>
/// 新增初始化科別資訊
/// </summary>
public static void Init(List <ClinicRoom> dataList)
{
using (var db = new LocalDBContext())
{
try
{
db.ClinicRooms.AddRange(dataList);
db.SaveChanges();
}
catch (DbEntityValidationException ex)
{
new Log().Error(ex.ToString());
}
}
}
/// <summary>
/// 新增初始化醫生資訊
/// </summary>
public static void Init(List <Doctor> listData)
{
using (var db = new LocalDBContext())
{
try
{
if (db.Doctors.Count() == 0)
{
db.Doctors.AddRange(listData);
db.SaveChanges();
}
else
{
//foreach (var obj in InitData())
//{
// //不存在的列舉新增
// if (!db.Doctor.Where(x => x.DoctorName.Equals(obj.DoctorName)).Any())
// {
// db.Doctor.Add(obj);
// db.SaveChanges();
// }
// else
// {
// ////已存在更新
// //var dbData = db.Doctor.Where(x => x.ID.Equals(obj.ID)).FirstOrDefault();
// //if (dbData != null)
// //{
// // dbData.DoctorName = obj.DoctorName;
// // dbData.LastModifiedTime = DateTime.Now;
// // dbData.LastModifiedBy = "admin";
// // db.SaveChanges();
// //}
// }
//}
}
}
catch (DbEntityValidationException ex)
{
new Log().Error(ex.ToString());
}
}
}
/// <summary>
/// 新增初始化資料
/// </summary>
public static void Init()
{
using (var db = new LocalDBContext())
{
try
{
if (db.SystemConfigs.Count() == 0)
{
db.SystemConfigs.AddRange(InitData());
db.SaveChanges();
}
else
{
foreach (var obj in InitData())
{
//不存在的列舉新增
if (!db.SystemConfigs.Where(x => x.Code.Equals(obj.Code)).Any())
{
db.SystemConfigs.Add(obj);
db.SaveChanges();
}
else
{
//已存在更新
var dbData = db.SystemConfigs.Where(x => x.Code.Equals(obj.Code)).FirstOrDefault();
if (dbData != null)
{
dbData.Name = obj.Name;
dbData.LastModifiedTime = DateTime.Now;
dbData.LastModifiedBy = "admin";
db.SaveChanges();
}
}
}
}
}
catch (Exception ex)
{
new Log().Error(ex.ToString());
}
}
}
