public ActionResult GetPlistTables(GetPlistTables requestModel)
{
if (!ModelState.IsValid)
{
return(ModelState.ToJsonResult());
}
var data = AcDomain.GetPlistTables(requestModel);
Debug.Assert(requestModel.Total != null, "requestModel.total != null");
return(this.JsonResult(new MiniGrid <DbTable> {
total = requestModel.Total.Value, data = data
}));
}
public static IQueryable <DbTable> GetPlistTables(this IAcDomain acDomain, GetPlistTables requestModel)
{
if (!requestModel.DatabaseId.HasValue)
{
throw new ValidationException("databaseId为空");
}
RdbDescriptor db;
if (!acDomain.RdbSet.TryDb(requestModel.DatabaseId.Value, out db))
{
throw new ValidationException("意外的数据库Id");
}
var properties = new HashSet <string>()
{
"Id",
"DatabaseId",
"CatalogName",
"SchemaName",
"Name",
"Description"
};
foreach (var filter in requestModel.Filters)
{
if (!properties.Contains(filter.field))
{
throw new ValidationException("意外的DbTable实体类型属性" + filter.field);
}
}
int pageIndex = requestModel.PageIndex;
int pageSize = requestModel.PageSize;
var queryable = db.DbTables.Values.Select(a => a).AsQueryable();
foreach (var filter in requestModel.Filters)
{
queryable = queryable.Where(filter.ToPredicate(), filter.value);
}
requestModel.Total = queryable.Count();
return(queryable.OrderBy(requestModel.SortField + " " + requestModel.SortOrder).Skip(pageIndex * pageSize).Take(pageSize));
}
public static IQueryable<DbTable> GetPlistTables(this IAcDomain acDomain, GetPlistTables requestModel)
{
if (!requestModel.DatabaseId.HasValue)
{
throw new ValidationException("databaseId为空");
}
RdbDescriptor db;
if (!acDomain.Rdbs.TryDb(requestModel.DatabaseId.Value, out db))
{
throw new ValidationException("意外的数据库Id");
}
var properties = new HashSet<string>()
{
"Id",
"DatabaseId",
"CatalogName",
"SchemaName",
"Name",
"Description"
};
foreach (var filter in requestModel.Filters)
{
if (!properties.Contains(filter.field))
{
throw new ValidationException("意外的DbTable实体类型属性" + filter.field);
}
}
int pageIndex = requestModel.PageIndex;
int pageSize = requestModel.PageSize;
var queryable = db.DbTables.Values.Select(a => a).AsQueryable();
foreach (var filter in requestModel.Filters)
{
queryable = queryable.Where(filter.ToPredicate(), filter.value);
}
requestModel.Total = queryable.Count();
return queryable.OrderBy(requestModel.SortField + " " + requestModel.SortOrder).Skip(pageIndex * pageSize).Take(pageSize);
}
public ActionResult GetPlistTables(GetPlistTables requestModel)
{
if (!ModelState.IsValid)
{
return ModelState.ToJsonResult();
}
var data = AcDomain.GetPlistTables(requestModel);
Debug.Assert(requestModel.Total != null, "requestModel.total != null");
return this.JsonResult(new MiniGrid<DbTable> { total = requestModel.Total.Value, data = data });
}
