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