/// <summary> /// 列表获取 /// </summary> /// <param name="request"></param> /// <returns></returns> public BsTableDataSource <ColumnManageViewModel> GetColumnList(GetColumnList request) { if (RowID != 1) { throw new Exception("权限异常"); } using (var db = DbFactory.Open()) { var builder = db.From <Column>(); if (null != request.id && request.id.Value > 0) { builder.Where(w => w.ColumnID == request.id); } var count = db.Select(builder).Count; if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "asc") { builder.OrderBy(o => request.Sort); } else if (!string.IsNullOrEmpty(request.Sort) && !string.IsNullOrEmpty(request.Order) && request.Order == "desc") { builder.OrderByDescending(o => request.Sort); } else { builder.OrderBy(o => o.ColumnID); } var PageSize = request.PageSize == 0 ? 15 : request.PageSize; var PageIndex = request.PageIndex == 0 ? 0 : (request.PageIndex) * PageSize; builder.Limit(PageIndex, PageSize); var RList = db.Select <ColumnManageViewModel>(builder); return(new BsTableDataSource <ColumnManageViewModel>() { rows = RList, total = count }); } }
public BsTableDataSource <ColumnManageViewModel> Get(GetColumnList request) { return(ColumnManager.GetColumnList(request)); }