示例#1
0
        public async Task <PageResponse> Page(JObject form, bool isRecycle = false)
        {
            var req = new SqlServerPageRequest(form);

            var columnNum = req.GetQueryField("columnNum")?.Value.ToStr();

            if (columnNum == null)
            {
                return(PageResponse.Error("无效数据"));
            }

            var column = await _columnService.GetByNum(columnNum);

            if (column == null)
            {
                return(PageResponse.Error("无效数据"));
            }

            var model = await _modelTableService.GetByNum(column.ModelNum);

            if (model == null)
            {
                return(PageResponse.Error("栏目未绑定模型"));
            }

            req.Queries.Add(new DefaultQuery(isRecycle, new DefaultQuerySql("IsDel")));

            return(await Page(model.SqlTableName, req));
        }
示例#2
0
 public async Task <PageResponse> Page(string tableName, IPageRequest req)
 {
     if (!req.ContainsQueryField("columnNum"))
     {
         return(PageResponse <ContentData> .Error("无效数据"));
     }
     return(await _dapper.Page(tableName, req));
 }
示例#3
0
        public async Task <PageResponse> Page([FromBody] JObject form)
        {
            string columnNum = form["columnNum"].ToStr();

            if (columnNum.IsEmpty())
            {
                return(PageResponse.Error("请选择栏目"));
            }

            return(await _service.GetTreeTableData(columnNum));
        }
示例#4
0
        public async Task <PageResponse> FieldPage([FromBody] JObject form)
        {
            var req = new SqlServerPageRequest(form);

            if (!req.ContainsQueryField("ModelNum"))
            {
                return(PageResponse.Error("请选择模型"));
            }

            return(await _modelFieldService.Page(req));
        }
示例#5
0
        public async Task <PageResponse> Page([FromBody] JObject form)
        {
            var req = new SqlServerPageRequest(form, new Dictionary <string, string>
            {
                { "Sort", "DESC" }
            });

            if (!req.ContainsQueryField("columnNum"))
            {
                return(PageResponse.Error("请选择栏目"));
            }
            return(await _service.Page(req));
        }
示例#6
0
        public async Task <PageResponse <ContentData> > PageByColumn(string columnNum, IPageRequest req)
        {
            var cm = await _columnService.GetModelByNum(columnNum);

            if (cm.Column == null || cm.ModelTable == null)
            {
                return(PageResponse <ContentData> .Error("无效数据"));
            }

            var res = await _dapper.Page(cm.ModelTable.SqlTableName, req);

            return(new PageResponse <ContentData>(res.Data.Select(temp => new ContentData(temp)), res.Total));
        }
示例#7
0
        public async Task <PageResponse> GetTreeTableData(string columnNum)
        {
            var columnModel = await _columnService.GetModelByNum(columnNum);

            if (columnModel == null)
            {
                return(PageResponse.Error("栏目未绑定模型"));
            }

            var data = await _dapper.GetByColumnNum(columnNum, columnModel?.ModelTable.SqlCategoryTableName);

            var columns = data as Category[] ?? data.ToArray();

            return(new PageResponse(await GetTreeTableData(columns.ToList(), ""), columns.Length));
        }