public T GetModelByUserName <T>(UserInfoGetRequest req) where T : class
{
var client = DBProxy.CreateClient();
var sql = new StringBuilder(@"SELECT * FROM SS_USER su WHERE 1=1 ");
var param = new DynamicParameters();
if (req.U_ID.HasValue)
{
sql.Append(" AND U_ID=@U_ID");
param.Add("@U_ID", req.U_ID);
}
return(client.Query <T>(sql.ToString(), param).FirstOrDefault());
}
public SingleApiResponse Get(UserInfoGetRequest req)
{
var result = RepoBase.Instance.GetWhere <SS_USER, UserDto>(x => x.U_ID == req.U_ID.Value).FirstOrDefault();
//用户权限
var roles = RoleRepo.GetListByUid <SS_ROLE>(req);
result.U_RoleIds = roles.Select(x => x.R_ID).ToArray();
result.U_Roles = string.Join(',', roles.Select(x => x.R_NAME));
return(new SingleApiResponse()
{
Data = result
});
}
public HttpResponseMessage GetUserInfos([FromUri] UserInfoGetRequest request)
{
var result = _userInfoService.GetUserInfos(request);
var list = new PageList <UserCenterInfoResponse>()
{
PageIndex = request.pageIndex == null ? ConstKeys.DEFAULT_PAGEINDEX : request.pageIndex.Value,
PageSize = result.PageSize,
TotalCount = result.TotalCount,
TotalPages = result.TotalPages,
Data = result.ToList()
};
return(toListJson(list, OperatingState.Success, "获取成功"));
}
public IEnumerable <T> GetListByUid <T>(UserInfoGetRequest req) where T : class
{
var client = DBProxy.CreateClient();
var sql = new StringBuilder(@"SELECT
sr.R_ID,
sr.R_NAME,
sr.R_DESC,
sr.Branch_ID,
sr.R_ORDERID
FROM SS_ROLE sr
LEFT JOIN SS_ROLE_USER sru
ON sr.R_ID = sru.R_ID
WHERE 1 = 1
");
var param = new DynamicParameters();
if (req.U_ID.HasValue)
{
sql.Append(" AND sru.U_ID = @U_ID");
param.Add("@U_ID", req.U_ID);
}
return(client.Query <T>(sql.ToString(), param));
}
public SingleApiResponse Get([FromBody] UserInfoGetRequest req)
{
return(UserBiz.Get(req));
}
