public ContentResult listedu(PlayerEduExperQueryRequest request) { var data = _playerEduService.List(new PlayerEduExperQueryRequest { MemberId = UserContext.WebUserContext.Id }); return(Result(true, string.Empty, data)); }
//教育经历列表 public List <PlayerEduResponse> List(PlayerEduExperQueryRequest request) { List <PlayerEduResponse> list = new List <PlayerEduResponse>(); try { var sql = @" select a.*,b.chinessname SchoolName,c.name CityName,d.name ProvinceName from t_player_edu a inner join t_sys_school b on a.schoolId=b.id inner join t_sys_city c on b.cityId=c.id inner join t_sys_province d on b.provinceId=d.id where a.isdelete=0 and a.memberId=@MemberId order by a.startdate desc "; list = _dbContext.Query <PlayerEduResponse>(sql, request).ToList(); } catch (Exception ex) { LogUtils.LogError("PlayerEduService.List", ex); } return(list); }