public static patientcase UpdatePatientCase(patientcase obj) { using (var db = new RescueEntities()) { var temp = db.patientcase.Find(obj.id); temp.title = obj.title; temp.description = obj.description; temp.gender = obj.gender; temp.birthday = obj.birthday; temp.weight = obj.weight; temp.height = obj.height; temp.occupation = obj.occupation; temp.chief_complaint = obj.chief_complaint; temp.present_illness_history = obj.present_illness_history; temp.primary_diagnosis = obj.primary_diagnosis; temp.treatment_plan = obj.treatment_plan; temp.past_history = obj.past_history; temp.personal_history = obj.personal_history; temp.family_history = obj.family_history; temp.allergy_history = obj.allergy_history; temp.status = obj.status; temp.admission_dt = obj.admission_dt; temp.rejected_reason = obj.rejected_reason; temp.modified_dt = obj.modified_dt; temp.owner_id = obj.owner_id; temp.owner_name = obj.owner_name; db.SaveChanges(); return(temp); } }
public static teaching_comments InsertTeachingComments(teaching_comments obj) { using (var db = new RescueEntities()) { db.teaching_comments.Add(obj); db.SaveChanges(); return(obj); } }
public static teaching_apply InsertTeachingApply(teaching_apply obj) { using (var db = new RescueEntities()) { db.teaching_apply.Add(obj); db.SaveChanges(); return(obj); } }
public static void DeleteConclusion(int id) { using (var db = new RescueEntities()) { var temp = db.patientcase_conclusion.Find(id); db.patientcase_conclusion.Remove(temp); db.SaveChanges(); } }
public static patientcase InsertPatientCase(patientcase obj) { using (var db = new RescueEntities()) { db.patientcase.Add(obj); db.SaveChanges(); return(obj); } }
public static patientcase_conclusion InsertConclusion(patientcase_conclusion obj) { using (var db = new RescueEntities()) { db.patientcase_conclusion.Add(obj); db.SaveChanges(); return(obj); } }
public static article_apply InsertArticleApply(article_apply obj) { using (var db = new RescueEntities()) { db.article_apply.Add(obj); db.SaveChanges(); return(obj); } }
public static article_comments InsertArticleComments(article_comments obj) { using (var db = new RescueEntities()) { db.article_comments.Add(obj); db.SaveChanges(); return(obj); } }
public static article InsertArticle(article obj) { using (var db = new RescueEntities()) { db.article.Add(obj); db.SaveChanges(); return(obj); } }
public static void UpdateAvatar(int id, string img) { using (var db = new RescueEntities()) { var temp = db.user_account.Find(id); temp.avatar = img; db.SaveChanges(); } }
public static void ChangePassword(int id, string newpassword) { using (var db = new RescueEntities()) { var temp = db.user_account.Find(id); temp.password = Cryptography.GetMD5Hash(temp.mobile_number + newpassword); db.SaveChanges(); } }
public static void UpdateImageDescrip(int id, string descrip) { using (var db = new RescueEntities()) { var temp = db.patientcase_image.Find(id); temp.description = descrip; db.SaveChanges(); } }
public static void DeleteTeachingApply(int apply_id) { using (var db = new RescueEntities()) { var temp = db.teaching_apply.Find(apply_id); db.teaching_apply.Remove(temp); db.SaveChanges(); } }
public static cmn_image InsertCmnImage(cmn_image obj) { using (var db = new RescueEntities()) { db.cmn_image.Add(obj); db.SaveChanges(); return(obj); } }
//添加直播课程 public static teaching_liv InsertLive(teaching_liv live) { using (var db = new RescueEntities()) { db.teaching_liv.Add(live); db.SaveChanges(); return(live); } }
//添加决策指导 public static decision_support InsertCds(decision_support cds) { using (var db = new RescueEntities()) { db.decision_support.Add(cds); db.SaveChanges(); return(cds); } }
//添加新闻 public static news InsertNews(news news) { using (var db = new RescueEntities()) { db.news.Add(news); db.SaveChanges(); return(news); } }
public static void DeleteNewsComments(int comments_id) { using (var db = new RescueEntities()) { var temp = db.news_comments.Find(comments_id); db.news_comments.Remove(temp); db.SaveChanges(); } }
//添加教学回放 public static teaching_vod InsertVod(teaching_vod vod) { using (var db = new RescueEntities()) { db.teaching_vod.Add(vod); db.SaveChanges(); return(vod); } }
public static news_comments InsertNewsComments(news_comments obj) { using (var db = new RescueEntities()) { db.news_comments.Add(obj); db.SaveChanges(); return(obj); } }
public static user_account InsertUser(user_account user) { using (var db = new RescueEntities()) { user.password = Cryptography.GetMD5Hash(user.mobile_number + user.password); user.created_dt = DateTime.Now; db.user_account.Add(user); db.SaveChanges(); return(user); } }
//删除cds public static void DeleteCds(int cd_id) { //删除用户收藏 DeleteUserCollect(ContentType.指导, cd_id); using (var db = new RescueEntities()) { var temp = db.decision_support.FirstOrDefault(t => t.id == cd_id); db.decision_support.Remove(temp); db.SaveChanges(); } }
//删除新闻评论 public static void DeleteNewsComment(int nid) { using (var db = new RescueEntities()) { var temp = db.news_comments.Where(t => t.news_id == nid); foreach (var item in temp) { db.news_comments.Remove(item); } db.SaveChanges(); } }
//删除会诊结论 public static void DeleteCaseConclusion(int pcid) { using (var db = new RescueEntities()) { var temp = db.patientcase_conclusion.Where(t => t.case_id == pcid); foreach (var item in temp) { db.patientcase_conclusion.Remove(item); } db.SaveChanges(); } }
// 删除文章评论 public static void DeleteArticleComment(int aid) { using (var db = new RescueEntities()) { var temp = db.article_comments.Where(t => t.article_id == aid); foreach (var item in temp) { db.article_comments.Remove(item); } db.SaveChanges(); } }
//删除文章 public static void DeleteArticle(int app_id) { using (var db = new RescueEntities()) { var temp = db.article.FirstOrDefault(t => t.apply_id == app_id); //DeleteArticleFile(); //删除文章附件 DeleteArticleComment(temp.id); // 删除文章评论 DeleteUserCollect(ContentType.文章, temp.id); //删除用户收藏 db.article.Remove(temp); db.SaveChanges(); } }
//删除用户收藏 public static void DeleteUserCollect(ContentType ctype, int cid) { using (var db = new RescueEntities()) { var temp = db.user_collect_record.Where(t => t.content_type == ctype && t.content_id == cid); foreach (var item in temp) { db.user_collect_record.Remove(item); } db.SaveChanges(); } }
public static void DeleteImage(int id) { using (var db = new RescueEntities()) { // 同时删除patientcase_image和cmn_image记录 var temp = db.patientcase_image.Find(id); var cmn = db.cmn_image.Find(temp.image_id); db.cmn_image.Remove(cmn); db.patientcase_image.Remove(temp); db.SaveChanges(); } }
//删除用户信息 (状态设置为已删除状�? public static void DeleteUser(int user_id) { using (var db = new RescueEntities()) { var temp = db.user_account.FirstOrDefault(t => t.id == user_id); if (temp.status != UserStatusType.已删除) { temp.status = UserStatusType.已删除; db.SaveChanges(); } } }
public static void RemoveUserCollection(int userid, ContentType type, int contentid) { using (var db = new RescueEntities()) { var temp = db.user_collect_record.FirstOrDefault(t => t.user_id == userid && t.content_type == type && t.content_id == contentid); if (temp != null) { db.user_collect_record.Remove(temp); db.SaveChanges(); } } }