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