public string count_substract_info(DateTime? start_time, DateTime? end_time) { try { db_context = new query_entities(); var list = (from t in this.db_context.CASEOPER where (((t.AUDITSTATUS == 10) && (t.ADState == 3)) && (start_time <= t.REVIEWDATE)) && (t.REVIEWDATE <= end_time) select new { substract_amount = t.SUBTRACTAMOUNT, substract_reason = t.SUBTRACTREASON }).ToList(); decimal? nullable = 0M; string str2 = ""; for (int i = 0; i < list.Count; i++) { decimal? nullable2; if (list[i].substract_amount.HasValue && (((nullable2 = list[i].substract_amount).GetValueOrDefault() > 0M) && nullable2.HasValue)) { nullable += list[i].substract_amount; } if ((list[i].substract_reason != null) && (list[i].substract_reason.Trim().Length > 0)) { str2 = str2 + list[i].substract_reason + "/n"; } } if (str2.Length > 0) { str2 = str2.Substring(0, str2.Length - 2); } return string.Concat(new object[] { "{\"substract_amount\":", nullable, ",\"substract_reason\":\"", str2, "\"}" }); } catch (Exception exception) { return exception.Message; } }
public string edit_monthly_data(DateTime? start_time, DateTime? end_time) { try { db_context = new query_entities(); return JsonConvert.SerializeObject((from t in this.db_context.TB0014 where (start_time <= t.AAE031) && (t.AAE031 <= end_time) select t).ToList<TB0014>(), new JsonConverter[] { new ChinaDateTimeConverter() }); } catch (Exception exception) { return exception.Message; } }
public void export_to_excel(string hospital_id, string area_code, string state, DateTime start_time, DateTime end_time, string hospital_name, int source_type) { db_context = new query_entities(); IQueryable<TB0004> source_t04 = null; if (string.IsNullOrEmpty(state)) { source_t04 = db_context.TB0004.Where( t => t.aae040 >= start_time && t.aae040 <= end_time && t.akb020 == hospital_id && t.AKC197 == source_type); } else { source_t04 = db_context.TB0004.Where( t => t.aae040 >= start_time && t.aae040 <= end_time && t.akb020 == hospital_id && t.aae117 == state && t.AKC197 == source_type); } if (!string.IsNullOrEmpty(area_code)) { source_t04 = source_t04.Where(t => t.aab324 == area_code); } var list = (from t04 in source_t04 join t12 in db_context.TB0012 on new {AKB020 = t04.akb020, AKC190 = t04.akc190, AAC001 = t04.aac001} equals new {AKB020 = t12.AKB020, AKC190 = t12.AKC190, AAC001 = t12.AAC001} into _group from g in _group.DefaultIfEmpty() join t01 in db_context.TB0001 on t04.aac001 equals t01.AAC001 select new excel_model { AAC003 = t01.AAC003, AAC041 = t01.AAC041, _AKC192 = g == null ? null : g.AKC192, _AKC194 = g == null ? null : g.AKC194, AKC195 = g == null ? "" : g.AKC195, AKC198 = g == null ? "" : g.AKC198, _hospital_days = t04.akc336, _akc264 = t04.akc264, _akc305 = t04.AKC305, akc190 = t04.akc190, _akc253 = t04.akc253, _akc280 = t04.akc280, disease_cost_limits = "", //病种费用限额 //disease_cost_limits = (t04.akc261 == null ? 0 : t04.akc261) + (t04.akc260 == null ? 0 : t04.akc260) //+ (t04.akc283 == null ? 0 : t04.akc283), //病种费用限额 _personal_payment = (t04.akc264 == null ? 0 : t04.akc264) - (t04.akc260 == null ? 0 : t04.akc260), //个人支付 _akc260 = t04.akc260, swap_amount = "", //调剂金额 _bkc287 = t04.bkc287 }).OrderByDescending(t => t._AKC194).ToList(); if (source_type == 1) { var sum = new excel_model { record_count = source_t04.Count().ToString(), _hospital_days = source_t04.Sum(t => t.akc336), _akc253 = source_t04.Sum(t => t.akc253), _akc264 = list.Sum(t => t._akc264), _akc305 = list.Sum(t => t._akc305), _personal_payment = list.Sum(t => t._personal_payment), _akc260 = list.Sum(t => t._akc260), swap_amount = "", //调剂金额 _bkc287 = list.Sum(t => t._bkc287) }; new ExcelOper().export_all(sum, list, start_time.ToString("yyyy年M月"), hospital_name, source_type.ToString()); }else if (source_type == 0) { new ExcelOper().export_list(list, start_time.ToString("yyyy年M月"), hospital_name, source_type.ToString()); } }
public string search_personnel_info(int page_index, int page_size, string name, string id_card) { string message = ""; try { db_context = new query_entities(); List<TB0001> list = new List<TB0001>(); int source_count = 0; int page_count = 0; if (!string.IsNullOrEmpty(name)) { var source = db_context.TB0001.Where(t => t.AAC003.Contains(name)); source_count = source.Count(); page_count = ((source_count + page_size) - 1) / page_size; list = source.OrderByDescending(t => t.AAC006).Skip((page_index*page_size)).Take(page_size).ToList(); } else if (!string.IsNullOrEmpty(id_card)) { var source = db_context.TB0001.Where(t => t.AAC002.StartsWith(id_card)); source_count = source.Count(); page_count = ((source_count + page_size) - 1) / page_size; list = source.OrderByDescending(t => t.AAC006).Skip((page_index*page_size)).Take(page_size).ToList(); } else { source_count = db_context.TB0001.Count(); page_count = ((source_count + page_size) - 1) / page_size; list = db_context.TB0001.OrderByDescending(t => t.AAC006).Skip((page_index * page_size)).Take(page_size).ToList(); } message = "{\"page_count\":" + page_count + ",\"record_count\":" + source_count + ",\"source\":" + JsonConvert.SerializeObject(list, new JsonConverter[] { new ChinaDateTimeConverter() }) + "}"; } catch (Exception ex) { message = ex.Message; } return message; }
public string save_case(string case_str, bool is_submit) { try { db_context = new query_entities(); CASEOPER _case = JsonConvert.DeserializeObject<CASEOPER>(case_str); if (_case.ID == 0) { this.db_context.CASEOPER.AddObject(_case); this.db_context.SaveChanges(); return _case.ID.ToString(); } CASEOPER caseoper = (from t in this.db_context.CASEOPER where t.ID == _case.ID select t).SingleOrDefault<CASEOPER>(); if (caseoper != null) { caseoper.PNAME = _case.PNAME; caseoper.IDCARD = _case.IDCARD; caseoper.LEAVEDATE = _case.LEAVEDATE; caseoper.PAYAMOUNT = _case.PAYAMOUNT; caseoper.SUBTRACTAMOUNT = _case.SUBTRACTAMOUNT; caseoper.SUBTRACTREASON = _case.SUBTRACTREASON; if (is_submit) { int num = int.Parse(base.Request.Cookies["authority_level"].Value); string str2 = HttpUtility.UrlDecode(base.Request.Cookies["username"].Value); switch (num) { case 1: caseoper.TRIALER = str2; caseoper.TRIALDATE = new DateTime?(DateTime.Now); caseoper.AUDITSTATUS = 9; caseoper.ADState = 1; break; case 2: caseoper.ADState = 7; break; case 9: caseoper.AUDITSTATUS = 10; caseoper.ADState = 3; break; case 10: caseoper.AUDITSTATUS = 2; caseoper.ADState = 5; break; } if (num > 1) { caseoper.REVIEWER = str2; caseoper.REVIEWDATE = new DateTime?(DateTime.Now); } } } this.db_context.SaveChanges(); return "1"; } catch (Exception exception) { return exception.Message; } }
public string illness_payment_search(int page_index, int page_size, string name, string id_card) { string message = ""; try { db_context = new query_entities(); int source_count = 0; int page_count = 0; if (!string.IsNullOrEmpty(name)) { var source = from t01 in db_context.TB0001 join t11 in db_context.TB0011 on t01.AAC002 equals t11.AAC002 where t01.AAC003.Contains(name) && t11.AKC197 == 1 select new { AAC003 = t01.AAC003, AAC002 = t01.AAC002, aae040 = t11.aae040, akc268 = t11.akc268, akc269 = t11.akc269, akc264 = t11.akc264, akc261 = t11.akc261, akc260 = t11.akc260, akc283 = t11.akc283, akc259 = t11.akc259, ckc281 = t11.ckc281, ckc282 = t11.ckc282, ckc283 = t11.ckc283, bkc284 = t11.bkc284, ckc285 = t11.ckc285, bkc286 = t11.bkc286 }; source_count = source.Count(); page_count = ((source_count + page_size) - 1) / page_size; var list = source.OrderByDescending(t => t.aae040).Skip((page_index * page_size)).Take(page_size).ToList(); message = "{\"page_count\":" + page_count + ",\"record_count\":" + source_count + ",\"source\":" + JsonConvert.SerializeObject(list, new JsonConverter[] { new ChinaDateTimeConverter() }) + "}"; } else if (!string.IsNullOrEmpty(id_card)) { var source = from t01 in db_context.TB0001 join t11 in db_context.TB0011 on t01.AAC002 equals t11.AAC002 where t01.AAC002.StartsWith(id_card) && t11.AKC197 == 1 select new { AAC003 = t01.AAC003, AAC002 = t01.AAC002, aae040 = t11.aae040, akc268 = t11.akc268, akc269 = t11.akc269, akc264 = t11.akc264, akc261 = t11.akc261, akc260 = t11.akc260, akc283 = t11.akc283, akc259 = t11.akc259, ckc281 = t11.ckc281, ckc282 = t11.ckc282, ckc283 = t11.ckc283, bkc284 = t11.bkc284, ckc285 = t11.ckc285, bkc286 = t11.bkc286 }; source_count = source.Count(); page_count = ((source_count + page_size) - 1)/page_size; var list = source.OrderByDescending(t => t.aae040).Skip((page_index*page_size)).Take(page_size).ToList(); message = "{\"page_count\":" + page_count + ",\"record_count\":" + source_count + ",\"source\":" + JsonConvert.SerializeObject(list, new JsonConverter[] { new ChinaDateTimeConverter() }) + "}"; } else { var source = from t11 in db_context.TB0011 join t01 in db_context.TB0001 on t11.AAC002 equals t01.AAC002 into _group from tb01 in _group.DefaultIfEmpty() where t11.AKC197 == 1 select new { AAC003 = tb01 == null ? "" : tb01.AAC003, AAC002 = tb01 == null ? "" : tb01.AAC002, aae040 = t11.aae040, akc268 = t11.akc268, akc269 = t11.akc269, akc264 = t11.akc264, akc261 = t11.akc261, akc260 = t11.akc260, akc283 = t11.akc283, akc259 = t11.akc259, ckc281 = t11.ckc281, ckc282 = t11.ckc282, ckc283 = t11.ckc283, bkc284 = t11.bkc284, ckc285 = t11.ckc285, bkc286 = t11.bkc286 }; source_count = source.Count(); page_count = ((source_count + page_size) - 1) / page_size; var list = source.OrderByDescending(t => t.aae040).Skip((page_index * page_size)).Take(page_size).ToList(); message = "{\"page_count\":" + page_count + ",\"record_count\":" + source_count + ",\"source\":" + JsonConvert.SerializeObject(list, new JsonConverter[] { new ChinaDateTimeConverter() }) + "}"; } } catch (Exception ex) { message = ex.Message; } return message; }
public string search_hospital(string name, string area_code) { string message = ""; try { db_context = new query_entities(); var query = db_context.TB0005.Where(t => t.akb021.Contains(name)); if (!string.IsNullOrEmpty(area_code)) { query = query.Where(t => t.AAB324 == area_code); } var list = (from t05 in query select new { name = t05.akb021, id = t05.akb020 }).ToList(); message = JsonConvert.SerializeObject(list); } catch (Exception ex) { message = ex.Message; } return message; }
public string get_summary_list(int page_index, int page_size, string hospital_id, string area_code, string state, int source_type, DateTime start_time, DateTime end_time) { string message = ""; try { db_context = new query_entities(); IQueryable<TB0004> source_t04 = null; if (string.IsNullOrEmpty(state)) { source_t04 = db_context.TB0004.Where( t => t.aae040 >= start_time && t.aae040 <= end_time && t.akb020 == hospital_id && t.AKC197 == source_type); } else { source_t04 = db_context.TB0004.Where( t => t.aae040 >= start_time && t.aae040 <= end_time && t.akb020 == hospital_id && t.aae117 == state && t.AKC197 == source_type); } if (!string.IsNullOrEmpty(area_code)) { source_t04 = source_t04.Where(t => t.aab324 == area_code); } var list = from t04 in source_t04 join t12 in db_context.TB0012 on new { AKB020 = t04.akb020, AKC190 = t04.akc190, AAC001 = t04.aac001 } equals new { AKB020 = t12.AKB020, AKC190 = t12.AKC190, AAC001 = t12.AAC001 } into _group from g in _group.DefaultIfEmpty() join t01 in db_context.TB0001 on t04.aac001 equals t01.AAC001 select new { AAC003 = t01.AAC003, AAC041 = t01.AAC041, AKC192 = g == null ? null : g.AKC192, AKC194 = g == null ? null : g.AKC194, AKC195 = g == null ? "" : g.AKC195, AKC198 = g == null ? "" : g.AKC198, akc336 = t04.akc336, akc264 = t04.akc264, akc305 = t04.AKC305, akc190 = t04.akc190, akc253 = t04.akc253, akc280 = t04.akc280, disease_cost_limits = "", //病种费用限额 //disease_cost_limits = (t04.akc261 == null ? 0 : t04.akc261) + (t04.akc260 == null ? 0 : t04.akc260) //+ (t04.akc283 == null ? 0 : t04.akc283), //病种费用限额 personal_payment = (t04.akc264 == null ? 0 : t04.akc264) - (t04.akc260 == null ? 0 : t04.akc260), //个人支付 akc260 = t04.akc260, swap_amount = "", //调剂金额 bkc287 = t04.bkc287 }; int source_count = list.Count(); int page_count = ((source_count + page_size) - 1) / page_size; list = list.OrderByDescending(t => t.AKC194).Skip((page_index * page_size)).Take(page_size); if (source_type == 1) { var summary = new { record_count = source_t04.Count(), hospital_days = source_t04.Sum(t => t.akc336), akc253 = source_t04.Sum(t => t.akc253), akc264 = list.Sum(t => t.akc264), akc305 = list.Sum(t => t.akc305), personal_payment = list.Sum(t => t.personal_payment), akc260 = list.Sum(t => t.akc260), swap_amount = "", //调剂金额 bkc287 = list.Sum(t => t.bkc287) }; message = "{\"page_count\":" + page_count + ",\"record_count\":" + source_count + ",\"source\":{\"summary\":" + JsonConvert.SerializeObject(summary) + ",\"list\":" + JsonConvert.SerializeObject(list.ToList(), new JsonConverter[] { new ChinaDateTimeConverter() }) + "}}"; } else if (source_type == 0) { message = "{\"page_count\":" + page_count + ",\"record_count\":" + source_count + ",\"source\":{\"summary\":[],\"list\":" + JsonConvert.SerializeObject(list.ToList(), new JsonConverter[] {new ChinaDateTimeConverter()}) + "}}"; } } catch (Exception ex) { message = ex.Message; } return message; }
public string validate_user(string username, string password) { string message = "0"; try { db_context = new query_entities(); LGN lgn = (from t in this.db_context.LGN where (t.user_name == username) && (t.password == password) select t).SingleOrDefault<LGN>(); if (lgn != null) { lgn.last_login_time = new DateTime?(DateTime.Now); this.db_context.SaveChanges(); message = "{\"authority_level\":" + lgn.authority_level + "}"; } } catch (Exception exception) { message = exception.Message; } return message; }
public string untread_monthly_data(int id) { string str = ""; try { db_context = new query_entities(); TB0016 tb = (from t in this.db_context.TB0016 where t.ID == id select t).SingleOrDefault<TB0016>(); if (tb == null) { return str; } switch (int.Parse(base.Request.Cookies["authority_level"].Value)) { case 9: tb.AAE117 = 1; tb.ADState = 2; break; case 10: tb.AAE117 = 9; tb.ADState = 4; break; case 2: tb.AAE117 = 10; tb.ADState = 6; break; } this.db_context.SaveChanges(); return "1"; } catch (Exception exception) { return exception.Message; } }
public string untread_case(int id) { string str = ""; try { db_context = new query_entities(); CASEOPER caseoper = (from t in this.db_context.CASEOPER where t.ID == id select t).SingleOrDefault<CASEOPER>(); if (caseoper == null) { return str; } switch (int.Parse(base.Request.Cookies["authority_level"].Value)) { case 9: caseoper.AUDITSTATUS = 1; caseoper.ADState = 2; break; case 10: caseoper.AUDITSTATUS = 9; caseoper.ADState = 4; break; case 2: caseoper.AUDITSTATUS = 10; caseoper.ADState = 6; break; } this.db_context.SaveChanges(); return "1"; } catch (Exception exception) { return exception.Message; } }
public string search_patient(string id_card, DateTime? leave_date) { string message = ""; try { db_context = new query_entities(); List<patient_info> list = null; if (!string.IsNullOrEmpty(id_card)) { list = (from t11 in this.db_context.TB0011 join t12 in this.db_context.TB0012 on new { ID1 = t11.akc190, ID2 = t11.akb020 } equals new { ID1 = t12.AKC190, ID2 = t12.AKB020 } join t01 in this.db_context.TB0001 on t11.AAC002 equals t01.AAC002 where t11.AAC002 == id_card select new patient_info { PNAME = t01.AAC003, IDCARD = t11.AAC002, LEAVEDATE = t12.AKC194, PAYAMOUNT = ((t11.ckc281 + t11.ckc282) + t11.ckc283) + t11.ckc285 }).ToList<patient_info>(); } else if (leave_date.HasValue) { list = (from t11 in this.db_context.TB0011 join t12 in this.db_context.TB0012 on new { ID1 = t11.akc190, ID2 = t11.akb020 } equals new { ID1 = t12.AKC190, ID2 = t12.AKB020 } join t01 in this.db_context.TB0001 on t11.AAC002 equals t01.AAC002 where t12.AKC194 == leave_date select new patient_info { PNAME = t01.AAC003, IDCARD = t11.AAC002, LEAVEDATE = t12.AKC194, PAYAMOUNT = ((t11.ckc281 + t11.ckc282) + t11.ckc283) + t11.ckc285 }).ToList<patient_info>(); } return JsonConvert.SerializeObject(list, new JsonConverter[] { new ChinaDateTimeConverter() }); } catch (Exception exception) { message = exception.Message; } return message; }
public string search_monthly_data(int page_index, int page_size, string yjlsh, bool is_all) { string message = ""; try { db_context = new query_entities(); List<TB0016> source = null; if (!string.IsNullOrEmpty(yjlsh)) { source = (from t in this.db_context.TB0016 where t.AAE430.StartsWith(yjlsh) select t).ToList<TB0016>(); } else { source = this.db_context.TB0016.ToList<TB0016>(); } if (!is_all) { switch (int.Parse(base.Request.Cookies["authority_level"].Value)) { case 1: source = source.Where<TB0016>(delegate(TB0016 t) { int? nullable; return ((t.ADState == 0) || (((nullable = t.ADState).GetValueOrDefault() == 2) && nullable.HasValue)); }).ToList<TB0016>(); break; case 2: source = (from t in source where t.ADState == 5 select t).ToList<TB0016>(); break; case 9: source = source.Where<TB0016>(delegate(TB0016 t) { int? nullable; return ((t.ADState == 1) || (((nullable = t.ADState).GetValueOrDefault() == 4) && nullable.HasValue)); }).ToList<TB0016>(); break; case 10: source = source.Where<TB0016>(delegate(TB0016 t) { int? nullable; return ((t.ADState == 3) || (((nullable = t.ADState).GetValueOrDefault() == 6) && nullable.HasValue)); }).ToList<TB0016>(); break; } } int num2 = source.Count<TB0016>(); int num3 = ((num2 + page_size) - 1) / page_size; message = string.Concat(new object[] { "\"page_count\":", num3, ", \"record_count\":", num2, ", \"cases\":" }); source = (from t in source orderby t.AAE430 descending select t).Skip<TB0016>((page_index * page_size)).Take<TB0016>(page_size).ToList<TB0016>(); message = message + JsonConvert.SerializeObject(source, new JsonConverter[] { new ChinaDateTimeConverter() }); } catch (Exception exception) { message = exception.Message; } return ("{" + message + "}"); }
public string save_monthly_data(string tb0016, bool is_submit) { string message = ""; try { db_context = new query_entities(); TB0016 t16 = JsonConvert.DeserializeObject<TB0016>(tb0016); if (t16.ID == 0) { this.db_context.TB0016.AddObject(t16); this.db_context.SaveChanges(); message = t16.ID.ToString(); } else { TB0016 tb = (from t in this.db_context.TB0016 where t.ID == t16.ID select t).SingleOrDefault<TB0016>(); if (tb != null) { tb.AKB144 = t16.AKB144; tb.AKB147 = t16.AKB147; if (is_submit) { int num = int.Parse(base.Request.Cookies["authority_level"].Value); string str2 = HttpUtility.UrlDecode(base.Request.Cookies["username"].Value); switch (num) { case 1: tb.AAE026 = str2; tb.AAE025 = new DateTime?(DateTime.Now); tb.AAE117 = 9; tb.ADState = 1; break; case 2: tb.AAE032 = str2; tb.ADState = 7; break; case 9: tb.AAE093 = str2; tb.AAE092 = new DateTime?(DateTime.Now); tb.AAE117 = 10; tb.ADState = 3; break; case 10: tb.AAE095 = str2; tb.AAE094 = new DateTime?(DateTime.Now); tb.AAE117 = 2; tb.ADState = 5; break; } } } this.db_context.SaveChanges(); message = "1"; } if (is_submit && (int.Parse(base.Request.Cookies["authority_level"].Value) == 2)) { } } catch (Exception exception) { message = exception.Message; } return message; }