Example #1
0
        public SingleApiResponse MemberGetList(MemberGetListRequest req)
        {
            var result = RoleRepo.MemberGetList <SS_USER>(req);

            return(new SingleApiResponse()
            {
                Data = result
            });
        }
Example #2
0
        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));
        }
Example #3
0
 public SingleApiResponse MemberGetList([FromBody] MemberGetListRequest req)
 {
     return(IRoleBiz.MemberGetList(req));
 }