public UserViewModel GetUserInfoById(string innerid)
{
const string sql = @"select a.*,b.provname,c.cityname,d.countyname from user_info as a
left join base_province as b on a.provid=b.innerid
left join base_city as c on a.cityid=c.innerid
left join base_county as d on a.countyid=d.innerid where a.innerid=@innerid;";
try
{
var model = Helper.Query<UserViewModel>(sql, new { innerid }).FirstOrDefault();
return model;
}
catch (Exception ex)
{
LoggerFactories.CreateLogger().Write("C用户获取会员详情:", TraceEventType.Error, ex);
return null;
}
}