public static List <patientcase> GetPatientCases()
{
using (var db = new RescueEntities())
{
return(db.patientcase.Include("owner").Include("patientcase_image.cmn_image").Include("patientcase_conclusion.user_account").OrderByDescending(t => t.admission_dt).ThenByDescending(t => t.created_dt).ToList());
}
}
//获取新闻详细信息
public static news GetNewsDetail(int id)
{
using (var db = new RescueEntities())
{
return(db.news.FirstOrDefault(t => t.id == id));
}
}
//获取cds详细信息
public static decision_support GetCdsDetail(int id)
{
using (var db = new RescueEntities())
{
return(db.decision_support.FirstOrDefault(t => t.id == id));
}
}
//获取直播课程列表
public static DataTable QueryLiveList(string Title, string Speaker, string Section, string Publisher, string Channel, string Date_t, int page, out string Count)
{
using (var db = new RescueEntities())
{
//主外键的表报错
var Querysql = from t in db.teaching_liv select new { t.id, t.title, t.teacher_name, t.teacher_title, t.teacher_org, t.teacher_dept, t.start_dt, t.end_dt, t.channel_id, t.creator_id, t.created_dt };
if (!string.IsNullOrEmpty(Title))
{
Querysql = Querysql.Where(t => t.title.Contains(Title));
}
if (!string.IsNullOrEmpty(Speaker))
{
Querysql = Querysql.Where(t => t.teacher_name.Contains(Speaker));
}
if (!string.IsNullOrEmpty(Section))
{
Querysql = Querysql.Where(t => t.teacher_dept.Contains(Section));
}
if (!string.IsNullOrEmpty(Publisher))
{
int int_Publisher = Convert.ToInt32(Publisher);
Querysql = Querysql.Where(t => t.creator_id == int_Publisher);
}
if (!string.IsNullOrEmpty(Channel) && Channel != "全部")
{
int int_Channel = Convert.ToInt32(Channel);
Querysql = Querysql.Where(t => t.channel_id == int_Channel);
}
Count = Querysql.Count().ToString(); //获取行数
return(CommonFunctions.ToDataTable(Querysql.OrderByDescending(t => t.created_dt).Take(page * 15).Skip((page - 1) * 15).ToList()));
}
}
//获取用户详细信息
public static user_account GetUserDetail(int id)
{
using (var db = new RescueEntities())
{
return(db.user_account.FirstOrDefault(t => t.id == id));
}
}
//获取会诊列表
public static List <patientcase> QueryCaseList(string Title, string Proposer, GenderType Sex1, PatientCaseStatusType?status, string DateT, int page, out string Count)
{
using (var db = new RescueEntities())
{
var Querysql = from t in db.patientcase select t;
if (!string.IsNullOrEmpty(Title))
{
Querysql = Querysql.Where(t => t.title == Title);
}
if (!string.IsNullOrEmpty(Proposer))
{
Querysql = Querysql.Where(t => t.owner_name == Proposer);
}
if (Sex1 != GenderType.全部)
{
Querysql = Querysql.Where(t => t.gender == Sex1);
}
if (!string.IsNullOrEmpty(status.ToString()))
{
Querysql = Querysql.Where(t => t.status == status);
}
Count = Convert.ToString(Querysql.Count());
return(Querysql.OrderBy(t => t.status).Take(page * 15).Skip((page - 1) * 15).ToList().ToList());
}
}
//获取会诊图片
public static List <patientcase_imageview> QueryCaseImageView(int id)
{
using (var db = new RescueEntities())
{
return(db.patientcase_imageview.Where(t => t.case_id == id).OrderBy(t => t.sorting_no).ToList());
}
}
public static decision_support InsertCds(decision_support obj)
{
using (var db = new RescueEntities())
{
return(null);
}
}
public static List <news> GetNewsList()
{
using (var db = new RescueEntities())
{
return(db.news.Include("news_image.cmn_image").OrderByDescending(t => t.post_dt).ToList());
}
}
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 List <decision_support> GetCdsList()
{
using (var db = new RescueEntities())
{
return(db.decision_support.OrderBy(t => t.disease_name).ToList());
}
}
public static patientcase GetDraft(int user_id)
{
using (var db = new RescueEntities())
{
return(db.patientcase.Include("owner").Include("patientcase_image.cmn_image").Include("patientcase_conclusion.user_account").FirstOrDefault(t => t.owner_id == user_id && t.status == PatientCaseStatusType.草稿));
}
}
public static patientcase_image GetImage(int id)
{
using (var db = new RescueEntities())
{
return(db.patientcase_image.Include("cmn_image").FirstOrDefault(t => t.id == id));
}
}
public static patientcase GetPatientCase(int id)
{
using (var db = new RescueEntities())
{
return(db.patientcase.Include("owner").Include("patientcase_image.cmn_image").Include("patientcase_conclusion.user_account").FirstOrDefault(t => t.id == id));
}
}
//获取文章详细信息
public static article_listview GetArticleDetail(int id)
{
using (var db = new RescueEntities())
{
return(db.article_listview.FirstOrDefault(t => t.apply_id == id));
}
}
public static news GetNews(int id)
{
using (var db = new RescueEntities())
{
return(db.news.Include("news_comments.user_account").Include("news_image.cmn_image").FirstOrDefault(t => t.id == id));
}
}
//获取用户列表
public static List <user_account> QueryUsers(string name, string mobile, string hosp, string dept, UserStatusType?status, QueryDateRangeType range, int page, out string Count)
{
using (var db = new RescueEntities())
{
var Querysql = from t in db.user_account select t;
if (!string.IsNullOrEmpty(name))
{
Querysql = Querysql.Where(t => t.name.Contains(name));
}
if (!string.IsNullOrEmpty(mobile))
{
Querysql = Querysql.Where(t => t.mobile_number.Contains(mobile));
}
if (!string.IsNullOrEmpty(hosp))
{
Querysql = Querysql.Where(t => t.hospital_name.Contains(hosp));
}
if (!string.IsNullOrEmpty(dept))
{
Querysql = Querysql.Where(t => t.department_name.Contains(dept));
}
if (status != null && status.Value.ToString() != "全部")
{
Querysql = Querysql.Where(t => t.status != UserStatusType.已删除 && t.status == status);
}
Count = Querysql.Count().ToString();
return(Querysql.OrderBy(t => t.status).Take(page * 15).Skip((page - 1) * 15).ToList());
}
}
public static news InsertNews(news obj)
{
using (var db = new RescueEntities())
{
return(null);
}
}
//获取会诊详细信息
public static patientcase GetCaseDetail(int id)
{
using (var db = new RescueEntities())
{
return(db.patientcase.FirstOrDefault(t => t.id == id));
}
}
public static List <teaching_vod> GetTeachingVods()
{
using (var db = new RescueEntities())
{
return(db.teaching_vod.Include("teaching_category").Include("cmn_image").OrderByDescending(t => t.created_dt).ToList());
}
}
//获取教学回放列表
public static DataTable QueryVodList(string title, string Proposer, string Grade, string Unit, string Section, string Date_t, int page, out string Count)
{
using (var db = new RescueEntities())
{
var Querysql = from t in db.teaching_vod select new { t.id, t.title, t.category_id, t.teacher_name, t.teacher_title, t.teacher_org, t.teacher_dept, t.creator_id, t.created_dt };
if (!string.IsNullOrEmpty(title))
{
Querysql = Querysql.Where(t => t.title.Contains(title));
}
if (!string.IsNullOrEmpty(Proposer))
{
Querysql = Querysql.Where(t => t.teacher_name.Contains(Proposer));
}
if (!string.IsNullOrEmpty(Grade))
{
Querysql = Querysql.Where(t => t.teacher_title.Contains(Grade));
}
if (!string.IsNullOrEmpty(Unit))
{
Querysql = Querysql.Where(t => t.teacher_org.Contains(Unit));
}
if (!string.IsNullOrEmpty(Section))
{
Querysql = Querysql.Where(t => t.teacher_dept.Contains(Section));
}
Count = Querysql.Count().ToString();
return(CommonFunctions.ToDataTable(Querysql.OrderByDescending(t => t.created_dt).Take(page * 15).Skip((page - 1) * 15).ToList()));
}
}
public static teaching_vod GetTeachingVod(int id)
{
using (var db = new RescueEntities())
{
return(db.teaching_vod.Include("specialist_user").Include("cmn_image").Include("teaching_category").FirstOrDefault(t => t.id == id));
}
}
//获取直播详细信息
public static teaching_liv GetLiveDetail(int id)
{
using (var db = new RescueEntities())
{
return(db.teaching_liv.FirstOrDefault(t => t.id == id));
}
}
public static teaching_vod InsertTeachingVod(teaching_vod obj)
{
using (var db = new RescueEntities())
{
return(null);
}
}
//获取新闻列表
public static DataTable QueryNewsList(string Title, string AuthorName, string AuthorOrg, string Post_Name, string Post_Dt, int Page, out string Count)
{
using (var db = new RescueEntities())
{
var Querysql = from t in db.news select new { t.id, t.title, t.author_name, t.author_org, t.post_user_name, t.post_dt };
if (!string.IsNullOrEmpty(Title))
{
Querysql = Querysql.Where(t => t.title.Contains(Title));
}
if (!string.IsNullOrEmpty(AuthorName))
{
Querysql = Querysql.Where(t => t.author_name.Contains(AuthorName));
}
if (!string.IsNullOrEmpty(AuthorOrg))
{
Querysql = Querysql.Where(t => t.author_org.Contains(AuthorOrg));
}
if (!string.IsNullOrEmpty(Post_Name))
{
Querysql = Querysql.Where(t => t.post_user_name.Contains(Post_Name));
}
Count = Querysql.Count().ToString();
return
(CommonFunctions.ToDataTable(
Querysql.OrderByDescending(t => t.post_dt).Take(Page * 15).Skip((Page - 1) * 15)));
}
}
//用户登录
public static user_account GetLoin(string Name, string password)
{
using (var db = new RescueEntities())
{
return(db.user_account.FirstOrDefault(t => t.mobile_number == Name && t.password == password && t.role == UserRoleType.管理员));
}
}
//获取新闻图片
public static List <news_imageview> QueryNewsImageView(int id)
{
using (var db = new RescueEntities())
{
return(db.news_imageview.Where(t => t.news_id == id).OrderBy(t => t.sorting_no).ToList());
}
}
//获取文章列表
public static List <article_listview> QueryArticleListView()
{
using (var db = new RescueEntities())
{
return(db.article_listview.OrderByDescending(t => t.publish_dt).ToList());
}
}
public static List <dic_hospital> GetHospitals()
{
using (var db = new RescueEntities())
{
return(null);
}
}
public static List <article> QueryArticles(string keyword, ArticleType?type, DateTime from, DateTime to, string author, string dept)
{
using (var db = new RescueEntities())
{
to = to.AddDays(1).AddSeconds(-1);
var list = db.article.AsQueryable();
if (string.IsNullOrEmpty(keyword) == false)
{
list = list.Where(t => t.title.Contains(keyword));
}
if (type != null)
{
list = list.Where(t => t.type == type);
}
list = list.Where(t => t.publish_dt >= from && t.publish_dt <= to);
if (string.IsNullOrEmpty(author) == false)
{
list = list.Where(t => t.author_name.Contains(author));
}
if (string.IsNullOrEmpty(dept) == false)
{
list = list.Where(t => t.author_dept.Contains(dept));
}
return(list.ToList());
}
}
