public string All() { ApiResult result = new ApiResult(); try { var CreateUserNumber = ZNRequest.GetString("CreateUserNumber"); if (string.IsNullOrWhiteSpace(CreateUserNumber)) { result.message = "参数异常"; return(JsonConvert.SerializeObject(result)); } var pager = new Pager(); var query = new SubSonic.Query.Select(provider).From <Black>().Where <Black>(x => x.CreateUserNumber == CreateUserNumber); var recordCount = query.GetRecordCount(); if (recordCount == 0) { result.message = new { records = recordCount, totalpage = 1 }; return(JsonConvert.SerializeObject(result)); } var list = query.OrderDesc("ID").ExecuteTypedList <Black>(); var array = list.Select(x => x.ToUserNumber).ToArray(); var users = new SubSonic.Query.Select(provider, "ID", "NickName", "Avatar", "Signature", "Number", "Cover").From <User>().Where("Number").In(array).ExecuteTypedList <User>(); var newlist = (from b in list join u in users on b.ToUserNumber equals u.Number select new BlackJson { ID = b.ID, CreateDate = b.CreateDate.ToString("yyyy-MM-dd"), UserID = u.ID, Number = u.Number, NickName = u.NickName, Avatar = u.Avatar, Signature = u.Signature, Cover = u.Cover }).ToList(); result.result = true; result.message = new { currpage = 1, records = newlist.Count, totalpage = 1, list = newlist }; } catch (Exception ex) { LogHelper.ErrorLoger.Error("Api_Black_All:" + ex.Message); result.message = ex.Message; } return(JsonConvert.SerializeObject(result)); }