/// <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()); } } }