public SingleApiResponse MemberGetList(MemberGetListRequest req)
{
var result = RoleRepo.MemberGetList <SS_USER>(req);
return(new SingleApiResponse()
{
Data = result
});
}
public IEnumerable <T> MemberGetList <T>(MemberGetListRequest req) where T : class
{
var client = DBProxy.CreateClient();
var sql = new StringBuilder(@"SELECT
*
FROM SS_USER su
LEFT JOIN SS_ROLE_USER sru
ON su.U_ID = sru.U_ID
WHERE 1 = 1
");
var param = new DynamicParameters();
if (req.R_ID.HasValue)
{
sql.Append(" AND sru.R_ID = @R_ID");
param.Add("@R_ID", req.R_ID);
}
return(client.Query <T>(sql.ToString(), param));
}
public SingleApiResponse MemberGetList([FromBody] MemberGetListRequest req)
{
return(IRoleBiz.MemberGetList(req));
}