public async Task <Result <QueryAllModel <BlobModel> > > GetAll(QueryInputModel query, CancellationToken token)
{
bool ok = false;
string message = "";
IEnumerable <BlobModel> models = null;
QueryAllModel <BlobModel> model = new QueryAllModel <BlobModel>();
string newContinuationToken = null;
try
{
var queryOptions = new QueryRequestOptions
{
PartitionKey = new PartitionKey(_partitionId + "_" + _userInfo.UserId),
MaxItemCount = _contextCosmosDB.MaxItemCount
};
//await foreach (var page in RepositoryContainer.GetItemQueryIterator<BlobModel>(query.Query, query.ContinuationToken, queryOptions, token).AsPages())
//{
// models = page.Values;
// newContinuationToken = page.ContinuationToken;
// break;
//}
model.ContinuationToken = newContinuationToken;
model.models = models;
ok = true;
}
catch (Exception ex)
{
message = ex.Message;
}
return(_result.Create(ok, message, model));
}
public async Task <ActionResult <ApiResultViewModel <IEnumerable <AccountInvitationViewModel> > > > GetAll(
[FromQuery] QueryInputModel <AccountInvitationFilterInputModel> query, CancellationToken cancellationToken)
{
var data = await _accountInvitationManager.GetAllAsync(query, cancellationToken);
return(OkData(AccountInvitationViewModel.MapAll(data.Data), new DataMetaViewModel(data.TotalCount)));
}
public async Task <IActionResult> GetAll(
[HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = "users/GetAll")] HttpRequestMessage req,
HttpRequest request, ILogger log, CancellationToken cancellationToken)
{
var resultAuth = validAdmin(req, request, new List <string>()
{
"users.list"
});
if (!resultAuth.Success)
{
return(new BadRequestObjectResult(resultAuth.Message));
}
QueryInputModel data = await req.Content.ReadAsAsync <QueryInputModel>();
var dataResult = await _controller.GetAll(data, cancellationToken);
if (!dataResult.Success)
{
return(new BadRequestObjectResult(dataResult.Message));
}
return(new OkObjectResult(dataResult.Value));
}
public async Task <IActionResult> GetAll(
[HttpTrigger(AuthorizationLevel.Anonymous, "post", Route = "Blobs/GetAll")] HttpRequestMessage req,
HttpRequest request, ILogger log, CancellationToken cancellationToken)
{
var resultAuth = validAuthorized(req, request);
if (!resultAuth.Success)
{
if (resultAuth.Message == _errors.NotAuthorized)
{
return(new UnauthorizedResult());
}
else
{
var objectResult = new ObjectResult(resultAuth.Message)
{
StatusCode = StatusCodes.Status401Unauthorized
};
return(objectResult);
}
}
QueryInputModel data = await req.Content.ReadAsAsync <QueryInputModel>();
var dataResult = await _controller.GetAll(data, cancellationToken);
if (!dataResult.Success)
{
return(new BadRequestObjectResult(dataResult.Message));
}
return(new OkObjectResult(dataResult.Value));
}
GetAchievementTypesAsync(QueryInputModel <AchievementTypeFilterInputModel> filter,
CancellationToken cancellationToken)
{
var result = await _achievementTypeManager.GetAllAsync(filter, cancellationToken);
return(OkData(AchievementTypeViewModel.MapAll(result.Data), result.TotalCount));
}
public async Task <ActionResult <ApiResultViewModel <IEnumerable <AccountViewModel> > > > GetAccounts(
QueryInputModel <AccountFilterInputModel> inputModel,
CancellationToken cancellationToken)
{
var queryResult = await _accountManager.GetAllAsync(inputModel, cancellationToken);
return(OkData(AccountViewModel.MapAll(queryResult.Data), new DataMetaViewModel(queryResult.TotalCount)));
}
public async Task <QueryResult <TEntity> > GetAllAsync(QueryInputModel queryModel,
CancellationToken cancellationToken = default)
{
using (var db = CreateDbContext())
{
return(await QueryProcessor.ApplyAsync(db.Set <TEntity>().AsNoTracking(), queryModel, cancellationToken));
}
}
public async Task ShouldGetPagedListFromServer()
{
var studentgenerator = new AutoFaker <StudentEntity>()
.RuleFor(p => p.StudentId, 0);
var students = studentgenerator.Generate(2);
students.ForEach(p => InsertAsync(p));
var query = new QueryInputModel();
var viewmodel = await SendAsync(query);
viewmodel.StudentList.Count().Should().BeGreaterOrEqualTo(2);
}
public async Task <Result <UserQueryModel> > GetAll(QueryInputModel query, CancellationToken token)
{
bool ok = false;
string message = "";
List <UserModel> models = new List <UserModel>();
UserQueryModel model = new UserQueryModel();
string newContinuationToken = null;
try
{
var queryOptions = new QueryRequestOptions
{
PartitionKey = new PartitionKey(_partitionId),
MaxItemCount = _contextCosmosDB.MaxItemCount
};
using (FeedIterator <UserModel> feedIterator = RepositoryContainer.GetItemQueryIterator <UserModel>(
query.Query,
query.ContinuationToken,
queryOptions))
{
while (feedIterator.HasMoreResults)
{
FeedResponse <UserModel> response = await feedIterator.ReadNextAsync();
newContinuationToken = response.ContinuationToken;
foreach (var item in response.Resource)
{
models.Add(item);
}
}
}
model.ContinuationToken = newContinuationToken;
model.models = models;
ok = true;
}
catch (Exception ex)
{
message = ex.Message;
}
return(_result.Create(ok, message, model));
}
public async Task <ActionResult <ApiResultViewModel <FriendRequest> > > GetFriendRequests(
[FromQuery] QueryInputModel <FriendRequestFilterInputModel> filterInputModel,
CancellationToken cancellationToken)
{
var fromAccountId = filterInputModel.FilterParameters.FirstOrDefault(q =>
q.FieldName == nameof(FriendRequestFilterInputModel.FromAccountId));
var toAccountId = filterInputModel.FilterParameters.FirstOrDefault(q =>
q.FieldName == nameof(FriendRequestFilterInputModel.ToAccountId));
if ((fromAccountId == null || !string.Equals(fromAccountId.Values[0], AccountId.ToString(),
StringComparison.OrdinalIgnoreCase)) &&
(toAccountId == null || !string.Equals(toAccountId.Values[0], AccountId.ToString(),
StringComparison.OrdinalIgnoreCase)))
{
return(Forbidden());
}
var friendRequests = await _friendRequestManager.GetAllAsync(filterInputModel, cancellationToken);
return(OkData(friendRequests.Data, friendRequests.TotalCount));
}
public QueryPermissionChecker(string key, QueryInputModel value, string queryFieldName)
{
Key = key;
Value = value;
_queryFieldName = queryFieldName;
}
public QueryPermissionChecker(string key, QueryInputModel value) : this(key, value, null)
{
Value = value;
}
public async Task <ActionResult <ApiResultViewModel <ShopItemViewModel> > > GetAll([FromQuery] QueryInputModel <ShopItemFilterInputModel> query,
CancellationToken cancellationToken)
{
var result = await _shopItemManager.GetAllAsync(query, cancellationToken);
return(OkData(ShopItemViewModel.MapAll(result.Data), result.TotalCount));
}
public async Task <Result <UserQueryModel> > GetAll(QueryInputModel query, CancellationToken token)
{
return(await _services.GetAll(query, token));
}
public AccountIdQueryPermissionParameterChecker(QueryInputModel value) : base("CreatorAccountId", value)
{
}
public AccountIdQueryPermissionParameterChecker(QueryInputModel value, string queryFieldName) : base(
"CreatorAccountId", value, queryFieldName)
{
}
public async Task <ActionResult <ApiResultViewModel <IEnumerable <StatsViewModel> > > > GetAccountStatsAsync([FromQuery] QueryInputModel <StatsFilterInputModel> query, CancellationToken cancellationToken)
{
var stats = await _statsManager.GetAllAsync(query, cancellationToken);
return(OkData(StatsViewModel.MapAll(stats.Data), new DataMetaViewModel(stats.TotalCount)));
}
public async Task <ActionResult <ApiResultViewModel <CategoryViewModel> > > GetAllAsync([FromQuery] QueryInputModel <CategoryFilterInputModel> queryInputModel, CancellationToken cancellationToken)
{
var data = await _categoryManager.GetAllAsync(queryInputModel, cancellationToken);
return(OkData(CategoryViewModel.MapAll(data.Data), new DataMetaViewModel(data.TotalCount)));
}
public async Task <Result <QueryAllModel <BlobModel> > > GetAll(QueryInputModel query, CancellationToken token)
{
return(await _repository.GetAll(query, token));
}
public string QueryData(QueryInputModel qim)
{
//输入参数
string KeyWords = string.Empty;
if (!string.IsNullOrEmpty(Request["keywords"]))
{
KeyWords = Request["keywords"].ToString().OfSql();
}
//构查询实体
QueryDataSetModel dsm = new QueryDataSetModel();
dsm.pageIndex = Convert.ToInt32(Request["pageIndex"]);
dsm.pageSize = Convert.ToInt32(Request["pageSize"]);
//点击标题排序
string OrderBy = string.Empty;
if (Request.Form["sortField"].ToString().Length > 1)
{
string[] sortField = Request.Form["sortField"].ToString().Split(',');
string[] sortOrder = Request.Form["sortOrder"].ToString().Split(',');
for (int i = 0; i < sortField.Length; i++)
{
OrderBy += "," + sortField[i] + " " + sortOrder[i];
}
OrderBy = OrderBy.Substring(1);
}
switch (qim.uri.ToLower())
{
#region 公共查询
//表格配置
case "pptableconfig":
dsm.tableName = "view_table_config";
dsm.orderBy = "l_order";
dsm.whereStr = "vname='" + Request["vname"].ToString().OfSql() + "'";
dsm.total = false;
break;
//菜单
case "ppmenu":
dsm.tableName = "sys_menu";
dsm.orderBy = OrderBy == "" ? "m_order" : OrderBy;
dsm.whereStr = "m_pid=0";
dsm.total = true;
break;
#endregion
#region Setting 控制器
//角色查询
case "pprole":
dsm.tableName = "sys_role";
dsm.orderBy = OrderBy == "" ? "id" : OrderBy;
dsm.total = true;
break;
//操作日志
case "pplog":
dsm.tableName = "sys_log";
dsm.orderBy = OrderBy == "" ? "l_datetime desc" : OrderBy;
dsm.whereStr = KeyWords != "" ? string.Format("l_user like '{0}%' or l_action ='%{0}%' or l_content ='%{0}%' or l_ip ='%{0}%'", KeyWords) : "";
dsm.total = true;
break;
//列表配置
case "ppcolumn":
dsm.tableName = "sys_column";
dsm.orderBy = OrderBy == "" ? "id" : OrderBy;
dsm.whereStr = KeyWords != "" ? string.Format("vname like '{0}%' or field ='{0}'", KeyWords) : "";
dsm.total = true;
break;
//按钮列表
case "ppbutton":
dsm.tableName = "sys_button";
dsm.orderBy = OrderBy == "" ? "b_pid,b_order" : OrderBy;
break;
//用户查询
case "ppuser":
dsm.tableName = "view_sys_user";
dsm.orderBy = OrderBy == "" ? "u_state" : OrderBy;
dsm.whereStr = KeyWords != "" ? string.Format("u_name like '%{0}%'", KeyWords) : "";
dsm.total = true;
break;
#endregion
}
if (dsm.tableName.Length == 0 || dsm.orderBy.Length == 0)
{
throw new Exception("查询传参错误，缺失表名或排序列");
}
//得到数据集
DataSet ds = QueryDS(dsm, DBT.sqllite);
//输出数据
QueryOutputModel qom = new QueryOutputModel();
if (dsm.total)
{
qom.total = Convert.ToInt32(ds.Tables[1].Rows[0][0]);
}
qom.data = ds.Tables[0];
//第一次查询列配置
if (Convert.ToInt32(Request["columnsExists"]) == 0)
{
qom.columns = QueryColumns(dsm.tableName);
}
//列配置表名
qom.vname = dsm.tableName;
return(qom.ToJson());
}
public async Task <ActionResult <ApiResultViewModel <AccountItemViewModel> > > GetItems(QueryInputModel <AccountItemFilterInputModel> queryModel, CancellationToken cancellationToken)
{
var data = await _accountItemManager.GetAllAsync(queryModel, cancellationToken);
return(OkData(data.Data, data.TotalCount));
}