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