/// <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);
}
//点击编辑的历史的记录
public BaseResponse <DayLife> QueryShowDayLifeList(string id)
{
//加载子项目
var response = new BaseResponse <DayLife>();
//这边获取list的集合
DayLife CheckReclist = new DayLife();
DC_DayLifeCarerec DayLifeCarereclist = new DC_DayLifeCarerec();
DC_DAYLIFECAREREC regQuestion = new DC_DAYLIFECAREREC();
var ID = Convert.ToInt32(id);
// 这边只有一条的信息
regQuestion = unitOfWork.GetRepository <DC_DAYLIFECAREREC>().dbSet.Where(m => m.ID == ID).OrderByDescending(m => m.CREATEDATE).ToList()[0];
Mapper.CreateMap <DC_DAYLIFECAREREC, DC_DayLifeCarerec>();
Mapper.Map(regQuestion, DayLifeCarereclist);
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);
}