public JsonResult GetList(Pagination pagination, string search)
{
int totalRows = db.Images.Count();
pagination.records = totalRows;
ViewPagerModel <PageImage> list = new ViewPagerModel <PageImage>()
{
rows = db.Images.OrderBy(t => t.Position).Skip(pagination.rows * (pagination.page - 1))
.Take(pagination.rows).ToList(),
records = totalRows,
total = pagination.total,
page = pagination.page
};
return(Json(list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetList(Pagination pagination, DateTime?startDate, DateTime?endDate)
{
int totalRows = 0;
List <Customer> _rows = null;
if (startDate.HasValue)
{
if (!endDate.HasValue)//假如结束日期没有值自动设置为当前日期
{
endDate = DateTime.Now;
}
totalRows = db.Customers.Count(t => t.CreateTime >= startDate && t.CreateTime <= endDate);
pagination.records = totalRows;
_rows = db.Customers.Where(t => t.CreateTime >= startDate && t.CreateTime <= endDate)
.OrderByDescending(t => t.CreateTime).Skip(pagination.rows * (pagination.page - 1))
.Take(pagination.rows).ToList();
}
else
{
totalRows = db.Customers.Count();
pagination.records = totalRows;
_rows = db.Customers.OrderByDescending(t => t.CreateTime).Skip(pagination.rows * (pagination.page - 1))
.Take(pagination.rows).ToList();
}
ViewPagerModel <Customer> list = new ViewPagerModel <Customer>()
{
rows = _rows,
records = totalRows,
total = pagination.total,
page = pagination.page
};
//int totalRows = db.Customers.Count();
//pagination.records = totalRows;
//ViewPagerModel<Customer> list = new ViewPagerModel<Customer>()
//{
// rows = db.Customers.OrderByDescending(t => t.CreateTime).Skip(pagination.rows * (pagination.page - 1))
// .Take(pagination.rows).ToList(),
// records = totalRows,
// total = pagination.total,
// page = pagination.page
//};
return(Json(list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetList(Pagination pagination, string search)
{
//string[] _order = pagination.sidx.Split(',');
int totalRows = db.WeChatAccounts.Count();
pagination.records = totalRows;
ViewPagerModel <WeChatAccount> list = new ViewPagerModel <WeChatAccount>()
{
rows = db.WeChatAccounts.OrderBy(t => t.NickName).Skip(pagination.rows * (pagination.page - 1))
.Take(pagination.rows).ToList(),
records = totalRows,
total = pagination.total,
page = pagination.page
};
return(Json(list, JsonRequestBehavior.AllowGet));
}
public ActionResult GetList(Pagination pagination, string search)
{
int totalRows = RoleManager.Roles.Count();
pagination.records = totalRows;
ViewPagerModel <ApplicationRole> list = new ViewPagerModel <ApplicationRole>()
{
//rows = UserManager.Users.Where(m=>m.Roles.Contains()).OrderBy(t => t.UserName).Skip(pagination.rows * (pagination.page - 1))
// .Take(pagination.rows).ToList(),
rows = RoleManager.Roles.OrderBy(t => t.Name)
.Skip(pagination.rows * (pagination.page - 1))
.Take(pagination.rows).ToList(),
records = totalRows,
total = pagination.total,
page = pagination.page
};
return(Json(list, JsonRequestBehavior.AllowGet));
}
public JsonResult GetList(Pagination pagination, string search)
{
int totalRows = UserManager.Users.Count();
pagination.records = totalRows;
//IdentityUserRole role = new IdentityUserRole();
//IdentityRole role = IdentityRole();
//role.Name = "admin";
// var roleManager=new RoleManager<IdentityRole>(new RoleStore<IdentityRole>)
var role = Context.Roles.SingleOrDefault(m => m.Name == "user");
ViewPagerModel <ApplicationUser> list = new ViewPagerModel <ApplicationUser>()
{
//rows = UserManager.Users.Where(m=>m.Roles.Contains()).OrderBy(t => t.UserName).Skip(pagination.rows * (pagination.page - 1))
// .Take(pagination.rows).ToList(),
rows = Context.Users.Where(m => m.Roles.Any(r => r.RoleId == role.Id)).OrderBy(t => t.UserName)
.Skip(pagination.rows * (pagination.page - 1))
.Take(pagination.rows).ToList(),
records = totalRows,
total = pagination.total,
page = pagination.page
};
return(Json(list, JsonRequestBehavior.AllowGet));
}
