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