private static void EnsureLTC_CPDataRefresh()
{
using (TWSLTCContext context = new TWSLTCContext())
{
cp_data = context.CARE_PLANDATA.ToList();
}
}
/// <summary>
/// 这边是查询的
/// </summary>
/// <param name="request"></param>
/// <returns></returns>
public BaseResponse <DayLife> QueryDayLife(int FeeNo, int year, int num)
{
//加载子项目
var response = new BaseResponse <DayLife>();
//这边获取list的集合
DayLife CheckReclist = new DayLife();
DC_DayLifeCarerec DayLifeCarereclist = new DC_DayLifeCarerec();
DC_DAYLIFECAREREC regQuestion = new DC_DAYLIFECAREREC();
List <DC_DAYLIFECAREREC> regQuestionlist = new List <DC_DAYLIFECAREREC>();
//这边默认本周为0
StringBuilder sb = new StringBuilder();
string sql = string.Format("select * from DC_DAYLIFECAREREC where DC_DAYLIFECAREREC.FEENO='" + FeeNo + "' and DC_DAYLIFECAREREC.WEEKNUMBER='" + num + "' and DATE_FORMAT( current_timestamp(),'%Y' )='" + year + "' and DC_DAYLIFECAREREC.DELFLAG<>1");
sb.Append(sql);
//这边默认的是时间
using (TWSLTCContext context = new TWSLTCContext())
{
var daylife = context.Database.SqlQuery <DC_DAYLIFECAREREC>(sb.ToString()).ToList().FirstOrDefault();
if (daylife != null)
{
DayLifeCarereclist.REGNO = daylife.REGNO;
DayLifeCarereclist.REGNAME = daylife.REGNAME;
DayLifeCarereclist.SEX = daylife.SEX;
DayLifeCarereclist.FAMILYMESSAGE = daylife.FAMILYMESSAGE;
DayLifeCarereclist.CONTACTMATTERS = daylife.CONTACTMATTERS;
DayLifeCarereclist.ID = daylife.ID;
DayLifeCarereclist.NURSEAIDES = daylife.NURSEAIDES;
DayLifeCarereclist.RESIDENTNO = daylife.RESIDENTNO;
DayLifeCarereclist.WEEKNUMBER = Convert.ToString(daylife.WEEKNUMBER);
DayLifeCarereclist.WEEKSTARTDATE = daylife.WEEKSTARTDATE;
}
}
List <DC_DayLifeCaredtl> DayLifeCaredtlist = new List <DC_DayLifeCaredtl>();
if (DayLifeCarereclist.ID > 0)
{
List <DC_DAYLIFECAREDTL> DayLifeCaredtl = unitOfWork.GetRepository <DC_DAYLIFECAREDTL>().dbSet.Where(m => m.ID == DayLifeCarereclist.ID).ToList();
Mapper.CreateMap <DC_DAYLIFECAREDTL, DC_DayLifeCaredtl>();
Mapper.Map(DayLifeCaredtl, DayLifeCaredtlist);
}
CheckReclist.DayLifeRec = DayLifeCarereclist;
CheckReclist.DayLifeCaredtl = DayLifeCaredtlist;
response.Data = CheckReclist;
// response.PagesCount = regQuestionlist.Count;
return(response);
}
private static void EnsureLTC_CPRefresh()
{
using (TWSLTCContext context = new TWSLTCContext())
{
cp = context.CARE_PLANPROBLEM.ToList();
}
}
private static void EnsureLTC_CPReasonRefresh()
{
using (TWSLTCContext context = new TWSLTCContext())
{
cp_reason = context.CARE_PLANREASON.ToList();
}
}
public string GetNurseCareBycode(string CodeId)
{
if (CodeId != null && CodeId != "")
{
string[] result = new string[3];
result = CodeId.Split(',');
var id = result[1];
var code = result[2];
// 这边获取list的集合
List <ABFilter> ABFilterList = new List <ABFilter>();
//这边默认本周为0
StringBuilder sb = new StringBuilder();
string sql = "select DC_TEAMACTIVITY.ACTIVITYNAME,DC_TEAMACTIVITYDTL.TITLENAME,DC_TEAMACTIVITYDTL.ITEMNAME from DC_TEAMACTIVITY inner join DC_TEAMACTIVITYDTL on DC_TEAMACTIVITY.SEQNO=DC_TEAMACTIVITYDTL.SEQNO where 1=1 ";
if (code != "" && code != null && code != "undefined")
{
sql = sql + "and DC_TEAMACTIVITY.ACTIVITYCODE='" + code + "'";
}
if (id != "" && id != null && id != "undefined")
{
sql = sql + "and DC_TEAMACTIVITYDTL.ID='" + id + "'";
}
else
{
sql = sql + "and 1<>1";
}
sb.Append(sql);
//这边默认的是时间
using (TWSLTCContext context = new TWSLTCContext())
{
ABFilterList = context.Database.SqlQuery <ABFilter>(sb.ToString()).ToList();
}
if (ABFilterList.Count > 0)
{
return(ABFilterList[0].ITEMNAME + "(" + ABFilterList[0].TITLENAME + ")");
}
else
{
return("");
}
}
else
{
return(null);
}
}
/// <summary>
/// 获取个案生活史
/// </summary>
/// <param name="regNo"></param>
/// <returns></returns>
public BaseResponse <NurseingLife3> GetNurseCareById(int id)
{
//加载子项目
var response = new BaseResponse <NurseingLife3>();
//这边获取list的集合
NurseingLife3 CheckReclist = new NurseingLife3();
NurseingLifeWeeks DayLifeCarereclist = new NurseingLifeWeeks();
var ID = Convert.ToInt32(id);
// 这边只有一条的信息
//regQuestion = unitOfWork.GetRepository<DC_NURSEINGLIFECAREREC>().dbSet.Where(m => m.ID == ID).OrderByDescending(m => m.CREATEDATE).ToList()[0];
StringBuilder sb = new StringBuilder();
string sql = string.Format("select LTC_ORG.ORGNAME as OrgName, nurse.ID,nurse.RESIDENTNO as Res,nurse.SEX,nurse.REGNAME,nurse.NURSEAIDES as Nur,nurse.WEEKSTARTDATE,nurse.SECURITYMEASURES,nurse.ARTICLESCARRIED,nurse.MEDICATIONINSTRUCTIONS,nurse.ACTIVITYSUMMARY,nurse.QUESTIONBEHAVIOR,nurse.REMARKS,date_add(WEEKSTARTDATE, interval 0 day)as WEEK1,date_add(WEEKSTARTDATE, interval 1 day)as WEEK2,date_add(WEEKSTARTDATE, interval 2 day)as WEEK3,date_add(WEEKSTARTDATE, interval 3 day)as WEEK4,date_add(WEEKSTARTDATE, interval 4 day)as WEEK5 from DC_NURSEINGLIFECAREREC as nurse inner join LTC_ORG on nurse.ORGID=LTC_ORG.ORGID where nurse.DELFLAG=0 and nurse.ID='" + ID + "'");
sb.Append(sql);
//这边默认的是时间
using (TWSLTCContext context = new TWSLTCContext())
{
DayLifeCarereclist = context.Database.SqlQuery <NurseingLifeWeeks>(sb.ToString()).ToList()[0];
}
List <DC_NurseingLifeCareEDTL> DayLifeCaredtlist = new List <DC_NurseingLifeCareEDTL>();
if (DayLifeCarereclist.ID > 0)
{
List <DC_NURSEINGLIFECAREDTL> DayLifeCaredtl = unitOfWork.GetRepository <DC_NURSEINGLIFECAREDTL>().dbSet.Where(m => m.ID == DayLifeCarereclist.ID).ToList();
Mapper.CreateMap <DC_NURSEINGLIFECAREDTL, DC_NurseingLifeCareEDTL>();
Mapper.Map(DayLifeCaredtl, DayLifeCaredtlist);
}
CheckReclist.NurseingLifeCareREC = DayLifeCarereclist;
CheckReclist.NurseingLifeCareEDTL = DayLifeCaredtlist;
response.Data = CheckReclist;
return(response);
}
public BaseResponse <AbNormaleMotionRec> GetAb(long feeNo, int year, int month)
{
//加载子项目
var response = new BaseResponse <AbNormaleMotionRec>();
//这边获取list的集合
AbNormaleMotionRec AbNormaleMotionRec = new AbNormaleMotionRec();
ABFilter ABFilter = new ABFilter();
List <DC_AbNormaleMotionRec> DC_AbNormaleMotionRec = new List <DC_AbNormaleMotionRec>();
List <DC_ABNORMALEMOTIONREC> regQuestion = unitOfWork.GetRepository <DC_ABNORMALEMOTIONREC>().dbSet.Where(m => m.YEAR == year && m.MONTH == month && m.FEENO == feeNo).ToList();
Mapper.CreateMap <DC_ABNORMALEMOTIONREC, DC_AbNormaleMotionRec>();
Mapper.Map(regQuestion, DC_AbNormaleMotionRec);
NurseingLifeWeeks DayLifeCarereclist = new NurseingLifeWeeks();
if (DC_AbNormaleMotionRec.Count > 0)
{
StringBuilder sb = new StringBuilder();
string sql = string.Format("select LTC_ORG.ORGNAME as OrgName from DC_ABNORMALEMOTIONREC as nurse inner join LTC_ORG on nurse.ORGID=LTC_ORG.ORGID ");
sb.Append(sql);
//这边默认的是时间
using (TWSLTCContext context = new TWSLTCContext())
{
DayLifeCarereclist = context.Database.SqlQuery <NurseingLifeWeeks>(sb.ToString()).ToList()[0];
}
ABFilter.REGNAME = DC_AbNormaleMotionRec[0].REGNAME;
ABFilter.SEX = DC_AbNormaleMotionRec[0].SEX;
ABFilter.RESIDENTNO = DC_AbNormaleMotionRec[0].RESIDENTNO;
ABFilter.Res = DC_AbNormaleMotionRec[0].RESIDENTNO;
ABFilter.Day = year + "." + month;
ABFilter.NURSEAIDES = DC_AbNormaleMotionRec[0].NURSEAIDES;
ABFilter.Nur = DC_AbNormaleMotionRec[0].NURSEAIDES;
ABFilter.OrgName = DayLifeCarereclist.OrgName;
}
AbNormaleMotionRec.AbNormaleMotionlist = DC_AbNormaleMotionRec;
AbNormaleMotionRec.ab = ABFilter;
response.Data = AbNormaleMotionRec;
return(response);
}
public BaseResponse <DayLife2> GetDayLifeById(int id)
{
//加载子项目
var response = new BaseResponse <DayLife2>();
//这边获取list的集合
DayLife2 CheckReclist = new DayLife2();
DayLifeWeeks DayLifeCarereclist = new DayLifeWeeks();
var ID = Convert.ToInt32(id);
// 这边只有一条的信息
//regQuestion = unitOfWork.GetRepository<DC_NURSEINGLIFECAREREC>().dbSet.Where(m => m.ID == ID).OrderByDescending(m => m.CREATEDATE).ToList()[0];
StringBuilder sb = new StringBuilder();
string sql = string.Format("select nurse.ID,nurse.RESIDENTNO as Res,nurse.CONTACTMATTERS,nurse.FAMILYMESSAGE,nurse.SEX,nurse.REGNAME,nurse.NURSEAIDES as Nur,nurse.WEEKSTARTDATE,date_add(WEEKSTARTDATE, interval 0 day)as WEEK1,date_add(WEEKSTARTDATE, interval 1 day)as WEEK2,date_add(WEEKSTARTDATE, interval 2 day)as WEEK3,date_add(WEEKSTARTDATE, interval 3 day)as WEEK4,date_add(WEEKSTARTDATE, interval 4 day)as WEEK5 from DC_DAYLIFECAREREC as nurse where nurse.DELFLAG=0 and nurse.ID='" + ID + "'");
sb.Append(sql);
//这边默认的是时间
using (TWSLTCContext context = new TWSLTCContext())
{
DayLifeCarereclist = context.Database.SqlQuery <DayLifeWeeks>(sb.ToString()).ToList()[0];
}
List <DC_DayLifeCaredtl> DayLifeCaredtlist = new List <DC_DayLifeCaredtl>();
if (DayLifeCarereclist.ID > 0)
{
List <DC_DAYLIFECAREDTL> DayLifeCaredtl = unitOfWork.GetRepository <DC_DAYLIFECAREDTL>().dbSet.Where(m => m.ID == DayLifeCarereclist.ID).ToList();
Mapper.CreateMap <DC_DAYLIFECAREDTL, DC_DayLifeCaredtl>();
Mapper.Map(DayLifeCaredtl, DayLifeCaredtlist);
}
CheckReclist.DayLifeRec = DayLifeCarereclist;
CheckReclist.DayLifeCaredtl = DayLifeCaredtlist;
response.Data = CheckReclist;
return(response);
}
//获得输入值输出值
public BaseResponse <IList <RecordFilter> > GetOutInt(int feeno, string recdate, string classtype)
{
var response = new BaseResponse <IList <RecordFilter> >();
RecordFilter CrecordFilter = new RecordFilter();
List <RecordFilter> FrecordFilter = new List <RecordFilter>();
var times = Convert.ToDateTime(recdate).ToString("yyyy-MM-dd");
StringBuilder sb = new StringBuilder();
string sql = string.Format("select * from LTC_OUTVALUE as vs where vs.FEENO='" + feeno + "' and DATE_FORMAT(vs.RECDATE,'%Y-%m-%d')='" + times + "' and vs.CLASSTYPE='" + classtype + "' ORDER BY vs.RECDATE asc ");
sb.Append(sql);
StringBuilder sb1 = new StringBuilder();
string sql1 = string.Format("select * from LTC_INVALUE as vs where vs.FEENO='" + feeno + "' and DATE_FORMAT(vs.RECDATE,'%Y-%m-%d')='" + times + "' and vs.CLASSTYPE='" + classtype + "' ORDER BY vs.RECDATE asc ");
sb1.Append(sql1);
using (TWSLTCContext context = new TWSLTCContext())
{
var OutPut = context.Database.SqlQuery <OutValueModel>(sb.ToString()).ToList().FirstOrDefault();
var IntPut = context.Database.SqlQuery <InValueModel>(sb1.ToString()).ToList().FirstOrDefault();
if (OutPut != null)
{
CrecordFilter.outvalue = Convert.ToInt32(OutPut.OutValue);
}
if (IntPut != null)
{
CrecordFilter.intvalue = Convert.ToInt32(IntPut.InValue);
}
}
FrecordFilter.Add(CrecordFilter);
response.Data = FrecordFilter;
return(response);
}
public BaseResponse <IList <ABFilter> > QueryHISAB(int FeeNo)
{
//加载子项目
var response = new BaseResponse <IList <ABFilter> >();
//这边获取list的集合
List <ABFilter> ABFilterList = new List <ABFilter>();
//这边默认本周为0
StringBuilder sb = new StringBuilder();
string sql = string.Format("select DC_ABNORMALEMOTIONREC.MONTH,DC_ABNORMALEMOTIONREC.YEAR,REGNAME,RESIDENTNO,SEX,FEENO,DELFLAG,NURSEAIDES from DC_ABNORMALEMOTIONREC group by DC_ABNORMALEMOTIONREC.MONTH,DC_ABNORMALEMOTIONREC.YEAR,REGNAME,RESIDENTNO,SEX,FEENO,DELFLAG,NURSEAIDES having DC_ABNORMALEMOTIONREC.FEENO='" + FeeNo + "'");
sb.Append(sql);
//这边默认的是时间
using (TWSLTCContext context = new TWSLTCContext())
{
ABFilterList = context.Database.SqlQuery <ABFilter>(sb.ToString()).ToList();
}
response.Data = ABFilterList;
return(response);
}
public GenericRepository(TWSLTCContext context)
{
this.context = context;
this.dbSet = context.Set <TEntity>();
}
public BaseResponse <NurseingLife> QueryNurseingLife(int FeeNo, int year, int num)
{
//加载子项目
var response = new BaseResponse <NurseingLife>();
//这边获取list的集合
NurseingLife CheckReclist = new NurseingLife();
DC_NurseingLifeCareREC DayLifeCarereclist = new DC_NurseingLifeCareREC();
DC_NURSEINGLIFECAREREC regQuestion = new DC_NURSEINGLIFECAREREC();
List <DC_NURSEINGLIFECAREREC> regQuestionlist = new List <DC_NURSEINGLIFECAREREC>();
//这边默认本周为0
StringBuilder sb = new StringBuilder();
string sql = string.Format("select * from DC_NURSEINGLIFECAREREC where DC_NURSEINGLIFECAREREC.FEENO='" + FeeNo + "' and DC_NURSEINGLIFECAREREC.WEEKNUMBER='" + num + "' and DATE_FORMAT( current_timestamp(),'%Y' )='" + year + "' and DC_NURSEINGLIFECAREREC.DELFLAG<>1");
sb.Append(sql);
//这边默认的是时间
using (TWSLTCContext context = new TWSLTCContext())
{
var daylife = context.Database.SqlQuery <DC_NURSEINGLIFECAREREC>(sb.ToString()).ToList().FirstOrDefault();
if (daylife != null)
{
DayLifeCarereclist.REGNO = daylife.REGNO;
DayLifeCarereclist.REGNAME = daylife.REGNAME;
DayLifeCarereclist.SEX = daylife.SEX;
DayLifeCarereclist.ID = daylife.ID;
DayLifeCarereclist.NURSEAIDES = daylife.NURSEAIDES;
DayLifeCarereclist.SECURITYMEASURES = daylife.SECURITYMEASURES;
DayLifeCarereclist.ARTICLESCARRIED = daylife.ARTICLESCARRIED;
DayLifeCarereclist.MEDICATIONINSTRUCTIONS = daylife.MEDICATIONINSTRUCTIONS;
DayLifeCarereclist.ACTIVITYSUMMARY = daylife.ACTIVITYSUMMARY;
DayLifeCarereclist.QUESTIONBEHAVIOR = daylife.QUESTIONBEHAVIOR;
DayLifeCarereclist.REMARKS = daylife.REMARKS;
}
}
List <DC_NurseingLifeCareEDTL> DayLifeCaredtlist = new List <DC_NurseingLifeCareEDTL>();
if (DayLifeCarereclist.ID > 0)
{
List <DC_NURSEINGLIFECAREDTL> DayLifeCaredtl = unitOfWork.GetRepository <DC_NURSEINGLIFECAREDTL>().dbSet.Where(m => m.ID == DayLifeCarereclist.ID).ToList();
Mapper.CreateMap <DC_NURSEINGLIFECAREDTL, DC_NurseingLifeCareEDTL>();
Mapper.Map(DayLifeCaredtl, DayLifeCaredtlist);
}
CheckReclist.NurseingLifeCareREC = DayLifeCarereclist;
CheckReclist.NurseingLifeCareEDTL = DayLifeCaredtlist;
response.Data = CheckReclist;
// response.PagesCount = regQuestionlist.Count;
return(response);
}
