// GET: /Attendance/
public ActionResult Index(Int32? page)
{
_lastAwanaDate = LastAwanaDate();
_lastDateToShow = Constants.AwanaStartDate;//_lastAwanaDate.AddDays(-(DAYS_IN_WEEK * (NUMBER_OF_WEEKS_TO_SHOW - 1)));
var students = db.StudentsUserHasAccessTo(User);
var attendances = students.SelectMany(x => x.Attendances).ToList();
GenerateAttendancesIfNeeded(_lastDateToShow, _lastAwanaDate, students, attendances);
var allAttendances = students.SelectMany(x => x.Attendances).OrderByDescending(x => x.AttendanceDate).ThenBy(x => x.Student.LastName).ThenBy(x => x.Student.FirstName).ToList();
var pageList = new PagedList.PagedList<Attendance>(allAttendances, page ?? 1, NUMBER_OF_WEEKS_TO_SHOW * students.Count);
var statisticsList = new List<AttendanceStatistics>();
var totalWeeks = ((_lastAwanaDate - Constants.AwanaStartDate).Days / DAYS_IN_WEEK) + 1;
foreach (var student in students)
{
var attendanceRate = (float)student.Attendances.Count(x => x.Student.Equals(student) && x.Attended) / totalWeeks;
var lastAttendance = student.Attendances.OrderByDescending(x => x.AttendanceDate).FirstOrDefault(x => x.Attended);
var weeksSinceLastAttendance = (_lastAwanaDate - (lastAttendance != null ? lastAttendance.AttendanceDate : Constants.AwanaStartDate)).Days / DAYS_IN_WEEK;
statisticsList.Add(new AttendanceStatistics
{
AttendanceStatisticsStudent = student,
AttendanceRate = attendanceRate,
WeeksSinceLastAttendance = weeksSinceLastAttendance
});
}
_lastPage = page;
return View(new AttendanceViewModel { Attendances = pageList, Statistics = statisticsList });
}
// GET: Home
public ActionResult Index(int page = 1, int pageSize = 10)
{
List <STUDENTINFO> students = db.STUDENTINFOes.ToList();
PagedList.PagedList <STUDENTINFO> model = new PagedList.PagedList <STUDENTINFO>(students, page, pageSize);
return(View(model));
}
private ArticuloPaginadoViewModel ConstruirViewModel(FiltroArticulo filtro, List <Articulo> articulos)
{
List <ArticuloViewModel> listado = AutoMapper.Mapper.Map <List <ArticuloViewModel> >(articulos);
PagedList.IPagedList <ArticuloViewModel> paginado = new PagedList.PagedList <ArticuloViewModel>(listado, filtro.Pagina, 30);
var vm = new ArticuloPaginadoViewModel();
vm.Articulos = paginado;
vm.Filtro = filtro;
vm.Filtro.TodosTags = _tagService.ObtenerTodos().Select(s => s.Descripcion);
vm.Filtro.TodosTipos = _tipoService.ObtenerTodos().ToList();
return(vm);
}
/// <summary>
/// 获取产品信息
/// </summary>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="ITEM_CD">产品编码</param>
/// <returns></returns>
public PagedList.PagedList <ProductDto> GetProductInfo(int pageNumber, int pageSize, string ITEM_CD)
{
string sql = "SELECT * from product";
if (!string.IsNullOrWhiteSpace(ITEM_CD))
{
sql += " WHERE item_cd =" + ITEM_CD;
}
var dt = _db.ExecuteDataSet(CommandType.Text, sql).Tables[0];
var list = ListConvert.DtToList <ProductDto>(dt);
for (int i = 0; i < list.Count; i++)
{
list[i].RowID = i + 1;
}
var pagelist = new PagedList.PagedList <ProductDto>(list, pageNumber, pageSize);
return(pagelist);
}
public ActionResult ProductList(int page = 1)
{
var pageSize = 5;
// var data = list.Skip((page-1)*pageSize).Take(pageSize).ToList();
var pagelist = new PagedList.PagedList <ProductViewModel>(list, page, pageSize);
PagedListModel vm = new PagedListModel
{
Products = pagelist,
};
if (Request.IsAjaxRequest())
{
return(PartialView("ProductList", vm));
}
else
{
return(PartialView(vm));
}
}
//以下为产品槽位明细信息-------------------------------
/// <summary>
/// 获取产品槽位明细
/// </summary>
/// <param name="pageNumber"></param>
/// <param name="pageSize"></param>
/// <param name="ITEM_CD">产品编码</param>
/// <returns></returns>
public PagedList.PagedList <ProductDetailDto> GetProductdetailInfo(int pageNumber, int pageSize, string ITEM_CD)
{
string sql = @"SELECT prodetail.* , pro.ITEM_CD , pro.ITEM_NM ,pro.MODEL_CD , pro.ITEM_COLOR
FROM productdetail prodetail
LEFT JOIN product pro ON pro.id = prodetail.productid";
if (!string.IsNullOrWhiteSpace(ITEM_CD))
{
sql += " WHERE pro.ITEM_CD = " + ITEM_CD;
}
var dt = _db.ExecuteDataSet(CommandType.Text, sql).Tables[0];
var list = ListConvert.DtToList <ProductDetailDto>(dt);
for (int i = 0; i < list.Count; i++)
{
list[i].RowID = i + 1;
}
var pagelist = new PagedList.PagedList <ProductDetailDto>(list, pageNumber, pageSize);
return(pagelist);
}
// GET: Administracion/Roles
public ActionResult Index(string busqueda = null, int paginaActual = 1, int totalPaginas = 10)
{
List <ApplicationRole> roles = null;
if (String.IsNullOrEmpty(busqueda))
{
roles = _roleService.Roles.ToList();
}
else
{
roles = _roleService.Roles.Where(x => x.Name.Contains(busqueda)).ToList();
}
ViewBag.busqueda = busqueda;
PagedList.PagedList <ApplicationRole> rolesPaginado = new PagedList.PagedList <ApplicationRole>(roles, paginaActual, totalPaginas);
return(View(rolesPaginado));
}
// GET: Product
//[ValidateAntiForgeryToken]
//public ActionResult Index(string sortOrder, string currentFilter, string searchString, int? page, string source)
//{
// ViewBag.Locations = this.GetOptionSource;
// return View();
//}
//[ValidateAntiForgeryToken]
public ActionResult Index(string sortOrder, string currentFilter, string searchString, int?page, string source)
{
PagedList.PagedList <SANNA.Services.Masters.DataContracts.ProductResponse> model = null;
if (searchString != null)
{
page = 1;
}
else
{
searchString = currentFilter;
}
int pageSize = 2;
int pageNumber = (page ?? 1);
ViewBag.source = this.GetOptionSource;
Enumerates.TypeSource TypeSourceValue;
ViewBag.currentFilter = currentFilter;
source = string.IsNullOrEmpty(source) ? "" : source;
if (Enum.TryParse(source.ToString(), out TypeSourceValue))
{
ViewBag.SourceCode = source;
model = _productService.ProductFilterPagination(new ProductRequest {
Page = pageNumber, Size = pageSize, Name = searchString, Source = TypeSourceValue
});
}
else
{
model = this.DefaultProductsResponse;
}
return(View(model));
}
