// GET:Workout
public IActionResult Index(string sortOrder, string filter, string currentFilter, int?page)
{
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParam"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
if (filter != null)
{
page = 1;
}
else
{
filter = currentFilter;
}
ViewData["CurrentFilter"] = filter;
var collWorkouts = _workoutRepository.WorkoutsByFilter(filter);
switch (sortOrder)
{
case "name_desc":
collWorkouts = collWorkouts.OrderByDescending(s => s.Name);
break;
default:
collWorkouts = collWorkouts.OrderBy(s => s.Name);
break;
}
var pageSize = 6;
return(View(PagerList <Workout> .Create(collWorkouts, page ?? 1, pageSize)));
}
/// <summary>
/// 创建分页列表
/// </summary>
private static PagerList <T> CreatePageList <T>(IEnumerable <T> source, IPager pager)
{
var result = new PagerList <T>(pager);
result.AddRange(source.ToList());
return(result);
}
/// <summary>
/// 初始化图标集合视图实体
/// </summary>
/// <param name="width">宽度</param>
/// <param name="height">高度</param>
/// <param name="categoryId">分类编号</param>
/// <param name="icons">图标分页集合</param>
public IconListViewModel(int?width, int?height, Guid?categoryId, PagerList <IconDto> icons)
{
Width = width;
Height = height;
CategoryId = categoryId;
Icons = icons;
}
public JsonResult ProjectManageList(QueryBase query)
{
string payway = CommonMethod.GetString(Request["PayWay"]);
string status = CommonMethod.GetString(Request["Status"]);
query.CusMemberId = CookieOperate.AccountCookie.AccountId;
var totalcount = 0;
var list = ProjectManageDBOperate.GetPagerList(query, payway, status, out totalcount);
var payways = CommonMethod.GetEnumItems <ProjectPayWayEnum>();
var statuss = CommonMethod.GetEnumItems <ProjectStatusEnum>();
var operate = CommonMethod.GetIntEnumItems <OpereateTypeEnum>();
var dev = CommonMethod.GetIntEnumItems <DevTypeEnum>();
list.ForEach(a =>
{
a.StatusTxt = statuss.FirstOrDefault(b => b.Key == a.Status).Value;
a.PayWayTxt = payways.FirstOrDefault(b => b.Key == a.PayWay).Value;
var o = operate.FirstOrDefault(b => b.Key == a.OpereateType);
if (!string.IsNullOrEmpty(o.Value))
{
a.OpereateTypeTxt = o.Value;
}
var d = operate.FirstOrDefault(b => b.Key == a.DevType);
if (!string.IsNullOrEmpty(d.Value))
{
a.DevTypeTxt = d.Value;
}
});
PagerList <ProjectManage> pagerList = new PagerList <ProjectManage>();
pagerList.rows = list;
pagerList.total = totalcount;
return(Json(pagerList));
}
//主页请求的数据
public JsonResult WorkListList(WorkListQuery query)
{
var totalcount = 0;
query.CusMemberId = CookieOperate.AccountCookie.AccountId;
var list = WorkListDBOperate.GetPagerList(query, out totalcount);
PagerList <WorkList> pagerList = new PagerList <WorkList>();
var status = CommonMethod.GetEnumItems <WorkListStatusEnum>();
//var userList = CompanyUserDBOperate.GetUserByUserNames(string.Join(",", list.Select(a => a.Users)).Split(',').ToArray());
var detailList = WorkListDetailDBOperate.GetList(list.Select(a => a.Guid).ToArray());
list.ForEach(a =>
{
a.StatusTxt = status.FirstOrDefault(b => b.Key == a.Status).Value;
a.StatusClass = CommonMethod.GetWorkListStatusClass(a.Status);
a.DetailList = detailList.Where(b => b.WorkId == a.Guid).ToList();
//if (string.IsNullOrEmpty(a.Users)) { return; }
//var thisUserList = new List<CompanyUser>();
//var thisUserArray = a.Users.Split(',').ToArray();
//foreach (var item in thisUserArray)
//{
// if (!string.IsNullOrEmpty(item))
// thisUserList.Add(userList.FirstOrDefault(b => b.UserName == item));
//}
//a.UserList = thisUserList;
});
pagerList.rows = list;
pagerList.total = totalcount;
return(Json(pagerList));
}
public void TestToJson()
{
var list = new PagerList <Sample>();
list.Add(new Sample());
Assert.Contains("PageCount", Json.ToJson(list));
}
/// <summary>
/// 转换为分页列表
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="source">数据源</param>
/// <param name="pager">分页对象</param>
public static PagerList <T> ToPageList <T>(this IEnumerable <T> source, IPager pager)
{
var result = new PagerList <T>(pager);
result.AddRange(source.ToList());
return(result);
}
public async Task <IActionResult> GetEmptyPageList(QueryParameter parameter)
{
await Task.Delay(1000);
var result = new PagerList <UserModel>(parameter.Page, parameter.PageSize, CreateList().Count);
return(Success(result));
}
public async Task <IActionResult> Index(int?pageNumber)
{
var contacts = from c in _context.Contacts
select c;
int pageSize = 5;
return(View(await PagerList <Contact> .CreateAsync(contacts.AsNoTracking(), pageNumber ?? 1, pageSize)));
}
public ActionResult List(string sortOrder, string filterTag, string curentTag, string filter, string pageSize,
string currentFilter, int?page)
{
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParam"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
if (!string.IsNullOrEmpty(pageSize))
{
ViewData["SizePage"] = pageSize;
}
else if (string.IsNullOrEmpty(pageSize) & string.IsNullOrEmpty((string)ViewData["SizePage"]))
{
pageSize = (string)ViewData["SizePage"];
}
ViewData["AllTags"] = _tagRepository.Tags.ToList();
int sizeOfPage;
if (int.TryParse(pageSize, out sizeOfPage) == false)
{
sizeOfPage = 12;
}
if (filter != null)
{
page = 1;
}
else
{
filter = currentFilter;
}
ViewData["CurrentFilter"] = filter;
IEnumerable <Workout> collworkout;
if (filterTag == null)
{
filterTag = curentTag;
collworkout = _workoutRepository.WorkoutsByFilter(filter).Where(t => t.PersonWorkout == false);
}
else
{
collworkout = _workoutRepository.WorkoutsByFilter(filter).Where(t => t.Tag.Name == filterTag);
}
ViewData["FilterTagParam"] = filterTag;
switch (sortOrder)
{
case "name_desc":
collworkout = collworkout.OrderByDescending(s => s.Name);
break;
default:
collworkout = collworkout.OrderBy(s => s.Name);
break;
}
return(View(PagerList <Workout> .Create(collworkout, page ?? 1, sizeOfPage)));
}
public void TestInit()
{
_list = new PagerList <Employee>(1, 2, 3);
_list.Add(new Employee());
_list.Add(new Employee()
{
Name = "B"
});
}
public async Task <IActionResult> GetPageList(QueryParameter parameter)
{
await Task.Delay(1000);
parameter.TotalCount = CreateList().Count;
var list = CreateList().Skip(parameter.GetSkipCount()).Take(parameter.PageSize);
var result = new PagerList <UserModel>(parameter, list);
return(Success(result));
}
public JsonResult NewsInfoListPager(QueryBase query)
{
var totalcount = 0;
var list = NewsInfoDBOperate.GetPagerList(query, true, out totalcount);
PagerList <NewsInfo> pagerList = new PagerList <NewsInfo>();
pagerList.rows = list;
pagerList.total = totalcount;
return(Json(pagerList));
}
// GET: /<controller>/
public ActionResult List(string sortOrder, string filter, string pageSize, string currentFilter, int?page)
{
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParam"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
if (!string.IsNullOrEmpty(pageSize))
{
ViewData["SizePage"] = pageSize;
}
else if (string.IsNullOrEmpty(pageSize) & string.IsNullOrEmpty((string)ViewData["SizePage"]))
{
pageSize = (string)ViewData["SizePage"];
}
int sizeOfPage;
if (int.TryParse(pageSize, out sizeOfPage) == false)
{
sizeOfPage = 6;
}
if (filter != null)
{
page = 1;
}
else
{
filter = currentFilter;
}
ViewData["CurrentFilter"] = filter;
var collnews = _newsRepository.NewsByFilter(filter);
var coll = new List <NewsViewModel>();
foreach (var collnew in collnews)
{
var view = new NewsViewModel();
view.Name = collnew.Name;
view.ImagePath = collnew.ImagePath;
view.Annatation = System.IO.File.ReadAllLines(@"../BeFit/wwwroot" + collnew.Path).First();
view.Tag = collnew.Tag;
coll.Add(view);
}
switch (sortOrder)
{
case "name_desc":
collnews = collnews.OrderByDescending(s => s.Name);
break;
default:
collnews = collnews.OrderBy(s => s.Name);
break;
}
return(View(PagerList <NewsViewModel> .Create(coll, page ?? 1, sizeOfPage)));
}
// GET: /Cardio/
public IActionResult Index(string sortOrder, string pageSize, string filter, string currentFilter, int?page)
{
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParam"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["CalSortParam"] = string.IsNullOrEmpty(sortOrder) ? "cal_desc" : "cal";
if (!string.IsNullOrEmpty(pageSize))
{
ViewData["SizePage"] = pageSize;
}
else if (string.IsNullOrEmpty(pageSize) & string.IsNullOrEmpty((string)ViewData["SizePage"]))
{
pageSize = (string)ViewData["SizePage"];
}
int sizeOfPage;
if (int.TryParse(pageSize, out sizeOfPage) == false)
{
sizeOfPage = 12;
}
if (filter != null)
{
page = 1;
}
else
{
filter = currentFilter;
}
ViewData["CurrentFilter"] = filter;
var collTag = _cardioRepository.CardiosByFilter(filter);
switch (sortOrder)
{
case "name_desc":
collTag = collTag.OrderByDescending(s => s.Name);
break;
case "cal_desc":
collTag = collTag.OrderByDescending(s => s.CalPerHour);
break;
case "cal":
collTag = collTag.OrderBy(s => s.CalPerHour);
break;
default:
collTag = collTag.OrderBy(s => s.Name);
break;
}
return(View(PagerList <Cardio> .Create(collTag, page ?? 1, sizeOfPage)));
}
public JsonResult FinanceReportList(QueryBase model)
{
var totalcount = 0;
model.CompanyId = CookieOperate.UserAdminCookie.CompanyId;
var list = FinanceReportDBOperate.GetPagerList(model, out totalcount);
PagerList <FinanceReport> pagerList = new PagerList <FinanceReport>();
pagerList.rows = list;
pagerList.total = totalcount;
return(Json(pagerList));
}
public JsonResult ConfigList()
{
int pagesize = CommonMethod.GetInt(Request["limit"]);
int offset = CommonMethod.GetInt(Request["offset"]);
string name = CommonMethod.GetString(Request["name"]);
var totalcount = 0;
var list = ConfigDBOperate.GetPagerList(pagesize, offset, name, out totalcount);
PagerList <Config> pagerList = new PagerList <Config>();
pagerList.rows = list;
pagerList.total = totalcount;
return(Json(pagerList));
}
public PagerList<Role> Query(RoleQuery query)
{
if (string.IsNullOrWhiteSpace(query.Order)) //分页必须先进行排序
query.Order = "Id desc";
query.TotalCount = RoleRepository.GetAll().Count();
IQueryable<Role> roles = GetQueryConditions(RoleRepository.GetAll(), query) //where查询条件必须放在排序和分页前，不然生成SQL有BUG
.OrderByIfOrderNullOrEmpty(query.Order)
.Skip(query.GetSkipCount())
.Take(query.PageSize);
var result = new PagerList<Role>(query);
result.AddRange(roles.ToList());
return result;
}
public PagerList<User> Query(UserQuery query)
{
if (string.IsNullOrWhiteSpace(query.Order)) //分页必须先进行排序
query.Order = "Id desc";
query.TotalCount = UserRepository.GetAllFilterDataPermissions().Count();
IQueryable<User> users = GetQueryConditions(UserRepository.GetAllFilterDataPermissions(), query) //where查询条件必须放在排序和分页前，不然生成SQL有BUG
.OrderByIfOrderNullOrEmpty(query.Order)
.Skip(query.GetSkipCount())
.Take(query.PageSize);
var result = new PagerList<User>(query);
result.AddRange(users.ToList());
return result;
}
public JsonResult AdminInfoList()
{
int pagesize = CommonMethod.GetInt(Request["limit"]);
int offset = CommonMethod.GetInt(Request["offset"]);
string name = CommonMethod.GetString(Request["name"]);
int companyId = CookieOperate.UserAdminCookie.CompanyId;
var totalcount = 0;
var list = AdminInfoDBOperate.GetPagerList(pagesize, offset, name, out totalcount, companyId);
PagerList <AdminInfo> pagerList = new PagerList <AdminInfo>();
pagerList.rows = list;
pagerList.total = totalcount;
return(Json(pagerList));
}
public virtual PagerList <TDto> FetchPages(TQuery query)
{
string fetchQuery = GetQuerySqlId();
int total = 0;
int wiilShowedPage = query.Page;
int pageSize = query.PageSize;
IList <TDto> list = DataMapper.QueryForListWithPage <TDto>(fetchQuery, query, query.Order, wiilShowedPage, pageSize, ref total);
query.TotalCount = total;
PagerList <TDto> pagers = new PagerList <TDto>(query);
pagers.AddRange(list);
return(pagers);
}
public object Index()
{
List <NewsListDto> listNews = new List <NewsListDto>();
for (int i = 0; i < 10; i++)
{
listNews.Add(new NewsListDto()
{
FID = i, FTitle = "test1" + i.ToString(), FImg = "https://pic4.zhimg.com/v2-24b83b0b4f1b7d2c90a2a28b6bbf116b.jpg"
});
}
PagerList <NewsListDto> pagelist = new PagerList <NewsListDto>(1, 10, 100, listNews);
return(new AjaxResponse(pagelist));
}
/// <summary>
/// 转换为分页列表
/// </summary>
/// <typeparam name="TEntity">实体类型</typeparam>
/// <param name="source">数据源</param>
/// <param name="pager">分页对象</param>
/// <returns></returns>
public static PagerList <TEntity> ToPagerList <TEntity>(this IQueryable <TEntity> source, IPager pager)
{
if (source == null)
{
throw new ArgumentNullException(nameof(source));
}
if (pager == null)
{
throw new ArgumentNullException(nameof(pager));
}
var result = new PagerList <TEntity>(pager);
result.AddRange(source.ToList());
return(result);
}
public PagerList <Role> Query(RoleQuery query)
{
if (string.IsNullOrWhiteSpace(query.Order)) //分页必须先进行排序
{
query.Order = "Id desc";
}
query.TotalCount = RoleRepository.GetAll().Count();
IQueryable <Role> roles = GetQueryConditions(RoleRepository.GetAll(), query) //where查询条件必须放在排序和分页前，不然生成SQL有BUG
.OrderByIfOrderNullOrEmpty(query.Order)
.Skip(query.GetSkipCount())
.Take(query.PageSize);
var result = new PagerList <Role>(query);
result.AddRange(roles.ToList());
return(result);
}
public PagerList <User> Query(UserQuery query)
{
if (string.IsNullOrWhiteSpace(query.Order)) //分页必须先进行排序
{
query.Order = "Id desc";
}
query.TotalCount = UserRepository.GetAllFilterDataPermissions().Count();
IQueryable <User> users = GetQueryConditions(UserRepository.GetAllFilterDataPermissions(), query) //where查询条件必须放在排序和分页前，不然生成SQL有BUG
.OrderByIfOrderNullOrEmpty(query.Order)
.Skip(query.GetSkipCount())
.Take(query.PageSize);
var result = new PagerList <User>(query);
result.AddRange(users.ToList());
return(result);
}
public virtual ActionResult Query(TQuery query)
{
LogOuts.Info("Query");
SetPage(query);
PagerList <TDto> list = null;
try
{
list = Service.FetchPages(query);
}
catch (Exception e)
{
LogOuts.Info("FetchPages Error:" + e.Message);
}
return(ToDataGridResult(list, list.TotalCount));
}
/// <summary>
/// 读取列表
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="isOrderBy"></param>
/// <returns></returns>
public static PagerList <T> ToPage <T>(this ISugarQueryable <T> query,
int pageIndex,
int pageSize,
bool isOrderBy = false)
{
var page = new PagerList <T>();
var totalCount = 0;
page.Data = query.ToPageList(pageIndex, pageSize, ref totalCount);
var pageCount = totalCount != 0 ? (totalCount % pageSize) == 0 ? (totalCount / pageSize) : (totalCount / pageSize) + 1 : 0;
page.Page = pageIndex;
page.PageSize = pageSize;
page.TotalCount = totalCount;
page.PageCount = pageCount;
return(page);
}
//[DisableFiltersAttribute(FiltersEnum.SoftDelete)] //示范：关闭数据过滤器(参数为过滤器名称列表)
public PagerList <UserDto> Query(UserQuery query)
{
//todo：easyui组件的ajax请求异常，暂时无法拦截
//throw new Exception("用户查询异常，easyui ajax操作全局异常测试");
if (string.IsNullOrWhiteSpace(query.Order)) //分页必须先进行排序
{
query.Order = "Id desc";
}
query.TotalCount = _userRepository.GetAllFilterDataPermissions().Count();
IQueryable <User> users = GetQueryConditions(_userRepository.GetAllFilterDataPermissions(), query) //where查询条件必须放在排序和分页前，不然生成SQL有BUG
.OrderByIfOrderNullOrEmpty(query.Order)
.Skip(query.GetSkipCount())
.Take(query.PageSize);
var result = new PagerList <User>(query);
result.AddRange(users.ToList());
return(result.Convert(p => p.ToDto()));
}
/// <summary>
/// 读取列表
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="query"></param>
/// <param name="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="isOrderBy"></param>
/// <returns></returns>
public static async Task <PagerList <T> > ToPageAsync <T>(this ISugarQueryable <T> query,
int pageIndex,
int pageSize,
bool isOrderBy = false)
{
RefAsync <int> totalCount = 0;
var page = new PagerList <T>();
page.Data = await query.ToPageListAsync(pageIndex, pageSize, totalCount);
var pageCount = totalCount != 0 ? (totalCount % pageSize) == 0 ? (totalCount / pageSize) : (totalCount / pageSize) + 1 : 0;
page.Page = pageIndex;
page.PageSize = pageSize;
page.TotalCount = totalCount;
page.PageCount = pageCount;
return(page);
}
public ActionResult List(string sortOrder, string filter, string pageSize, string currentFilter, int?page)
{
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParam"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
if (!string.IsNullOrEmpty(pageSize))
{
ViewData["SizePage"] = pageSize;
}
else if (string.IsNullOrEmpty(pageSize) & string.IsNullOrEmpty((string)ViewData["SizePage"]))
{
pageSize = (string)ViewData["SizePage"];
}
int sizeOfPage;
if (int.TryParse(pageSize, out sizeOfPage) == false)
{
sizeOfPage = 12;
}
if (filter != null)
{
page = 1;
}
else
{
filter = currentFilter;
}
ViewData["CurrentFilter"] = filter;
var collExercises = _repository.ExercisesByFilter(filter);
switch (sortOrder)
{
case "name_desc":
collExercises = collExercises.OrderByDescending(s => s.Name);
break;
default:
collExercises = collExercises.OrderBy(s => s.Name);
break;
}
return(View(PagerList <Exercise> .Create(collExercises, page ?? 1, sizeOfPage)));
}
public virtual PagerList <TDto> FetchPages(TQuery query)
{
PagerList <TDto> pagers = new PagerList <TDto>(0);
try
{
string fetchQuery = GetQuerySqlId();
int total = 0;
int wiilShowedPage = query.Page;
int pageSize = query.PageSize;
IList <TDto> list = DataMapper.QueryForListWithPage <TDto>(fetchQuery, query, query.Order, wiilShowedPage, pageSize, ref total);
query.TotalCount = total;
pagers = new PagerList <TDto>(query);
pagers.AddRange(list);
}
catch (Exception e)
{
LogOuts.Info("FetchPages error:" + e.ToString());
}
return(pagers);
}
// GET: User
public IActionResult Index(string sortOrder, string filter, string currentFilter, int?page)
{
ViewData["CurrentSort"] = sortOrder;
ViewData["NameSortParam"] = string.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
ViewData["SecondNameSortParam"] = string.IsNullOrEmpty(sortOrder) ? "Second_name_desc" : "Second_name";
if (filter != null)
{
page = 1;
}
else
{
filter = currentFilter;
}
ViewData["CurrentFilter"] = filter;
var collTag = _appUserRepository.UserProfileByFilter(filter);
switch (sortOrder)
{
case "name_desc":
collTag = collTag.OrderByDescending(s => s.FirstName);
break;
case "Second_name_desc":
collTag = collTag.OrderByDescending(s => s.FirstName);
break;
case "Second_name":
collTag = collTag.OrderBy(s => s.FirstName);
break;
default:
collTag = collTag.OrderBy(s => s.FirstName);
break;
}
var pageSize = 10;
return(View(PagerList <AppUser> .Create(collTag, page ?? 1, pageSize)));
}
public PagerList<UserDto> Query(UserQuery query)
{
//todo：easyui组件的ajax请求异常，暂时无法拦截
//throw new Exception("用户查询异常，easyui ajax操作全局异常测试");
if (string.IsNullOrWhiteSpace(query.Order)) //分页必须先进行排序
query.Order = "Id desc";
query.TotalCount = _userRepository.GetAllFilterDataPermissions().Count();
IQueryable<User> users = GetQueryConditions(_userRepository.GetAllFilterDataPermissions(), query) //where查询条件必须放在排序和分页前，不然生成SQL有BUG
.OrderByIfOrderNullOrEmpty(query.Order)
.Skip(query.GetSkipCount())
.Take(query.PageSize);
var result = new PagerList<User>(query);
result.AddRange(users.ToList());
return result.Convert(p => p.ToDto());
}
public void TestInit() {
_list = new PagerList<Customer>( 1,2,3,"Name" );
_list.Add( Customer.GetCustomerA() );
_list.Add( Customer.GetCustomerB() );
}
