public List <MenuAndRoleRelationEntity> QueryRoleAndMenuList(MenuAndRoleRelationRequest request) { DynamicParameters dp = new DynamicParameters(); StringBuilder strSQL = new StringBuilder(); strSQL.Append(" select * from tblMenuAndRoleRelation with(nolock) where 1=1 "); if (!string.IsNullOrEmpty(request.Id)) { strSQL.Append(" and Id=@Id "); dp.Add("Id", request.Id, DbType.String, ParameterDirection.Input, 50); } if (!string.IsNullOrEmpty(request.RoleId)) { strSQL.Append(" and RoleId=@RoleId "); dp.Add("RoleId", request.RoleId, DbType.String, ParameterDirection.Input, 50); } if (!string.IsNullOrEmpty(request.MenuId)) { strSQL.Append(" and MenuId=@MenuId "); dp.Add("MenuId", request.MenuId, DbType.String, ParameterDirection.Input, 50); } using (DbConnection conn = new SqlConnection(DbConnectionStringConfig.Default.MyShopConnectionString)) { return(conn.Query <MenuAndRoleRelationEntity>(strSQL.ToString(), request).ToList()); } }
public List <MenuAndRoleRelationEntity> GetRoleAndMenuList(MenuAndRoleRelationRequest request) { return(menuAndRoleRelation.QueryRoleAndMenuList(request)); }