// GET: User
public ActionResult Index(int page = 1)
{
var data = new PageableData <User>(Repository.Users, page, 30);
//var users = Repository.Users.ToList();
return(View(data));
}
public ActionResult Index(int page = 1, int itemPerPage = 10)
{
var products = presentsDB.Products.ToList();
var data = new PageableData <Product>(products.OrderByDescending(e => e.Popularity).Take(8).ToList(), page, itemPerPage);
return(View(data));
}
public ActionResult Index(int page = 1)
{
var list = Repository.Posts.OrderByDescending(p => p.AddedDate);
var data = new PageableData<Post>(list, page);
data.List.ForEach(p => p.CurrentLang = CurrentLang.ID);
return View(data);
}
public JsonResult Search(int limit, int offset, string organizationName, string Name, string lineIP)
{
var user = CookieHelper.GetInstance(HelperKeys.UserIdCookieKey).GetCookie <UserModel>(Request);
PageableData <AlarmModel> temp = _business.GetPage(Name, organizationName, lineIP, user.OrganId, limit, offset);
PageableData <object> list = new PageableData <object>()
{
total = temp.total,
rows = temp.rows.Select(n => new
{
n.Id,
n.LineName,
n.IP,
n.OrganName,
FirstTime = n.FirstTime.ToString("yyyy-MM-dd HH:mm:ss"),
LastTime = n.LastTime.ToString("yyyy-MM-dd HH:mm:ss"),
n.AlarmCount,
State = n.State.GetDescription(),
Type = n.Type.GetDescription(),
n.Confirm
//LineState = n.LineState ? "连通" : "断开"
})
};
return(Json(list));
}
public async Task InvokeAsync(IMiddlewareContext context)
{
await _next(context).ConfigureAwait(false);
IValueNode sortArgument = context.Argument <IValueNode>(_contextData.ArgumentName);
if (sortArgument is null || sortArgument is NullValueNode)
{
return;
}
IQueryable <T>? source = null;
PageableData <T>?p = null;
if (context.Result is IQueryable <T> q)
{
source = q;
}
else if (context.Result is IEnumerable <T> e)
{
source = e.AsQueryable();
}
if (context.Result is PageableData <T> pb)
{
source = pb.Source;
p = pb;
}
if (source != null &&
context.Field.Arguments[_contextData.ArgumentName].Type is InputObjectType iot &&
iot is ISortInputType fit &&
fit.EntityType is { })
/// <summary>
///
/// </summary>
/// <param name="strWhere"></param>
/// <param name="orderby"></param>
/// <param name="startIndex"></param>
/// <param name="endIndex"></param>
/// <returns></returns>
public PageableData <Model.PURTC> GetPageList(string strWhere, string orderby, int startIndex, int endIndex)
{
PageableData <Model.PURTC> result = null;
string totalsql = string.Format("select count(*) from PURTC where 1=1 and {0}", strWhere);
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM ( ");
strSql.Append(" SELECT ROW_NUMBER() OVER (");
if (!string.IsNullOrEmpty(orderby.Trim()))
{
strSql.Append("order by T." + orderby);
}
else
{
strSql.Append("order by T.TC003 desc");
}
strSql.Append(")AS Row, T.* from PURTC T ");
if (!string.IsNullOrEmpty(strWhere.Trim()))
{
strSql.Append(" WHERE " + strWhere);
}
strSql.Append(" ) TT");
strSql.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
using (SqlConnection conn = new SqlConnection(ConnStrManage.WSGCDB))
{
var reader = conn.Query <Model.PURTC>(strSql.ToString(), null);
result = new PageableData <Model.PURTC>()
{
total = conn.Query <int>(totalsql).FirstOrDefault(),
rows = reader
};
}
return(result);
}
public ActionResult Catalog(int page = 1, int itemPerPage = 10, int sort = 0)
{
List <ProductFrequency> listPr = (List <ProductFrequency>)Session["finalResult"];
ViewBag.sortType = sort;
List <ProductFrequency> helpList = new List <ProductFrequency>();
switch (sort)
{
case 0: helpList = listPr.OrderBy(x => x.productCore.Price).ToList();
break;
case 1: helpList = listPr.OrderByDescending(x => x.productCore.Price).ToList();
break;
case 2: helpList = listPr.OrderByDescending(x => x.Frequency).ToList();
break;
default:
helpList = listPr;
break;
}
Session["finalResult"] = helpList;
var data = new PageableData <ProductFrequency>(helpList, page, itemPerPage);
return(View(data));
}
public ViewResult LogList(int page = 1, int sort = 0, int itemsPerPage = 0)
{
itemsPerPage = itemsPerPage == 0 ? Globals.itemsPerPage : itemsPerPage; //определяем текущее кол-во элементов на странице
ViewBag.sort = sort;
ViewBag.ItemsPage = itemsPerPage;
IQueryable <Models.Action> actions;
switch (sort)
{
case 1:
actions = Repository.Actions.OrderBy(name => name.User.Username);
break;
case 2:
actions = Repository.Actions.OrderBy(name => name.Item.Itemname);
break;
case 3:
actions = Repository.Actions.OrderBy(name => name.Todo);
break;
case 4:
actions = Repository.Actions.OrderBy(name => name.When);
break;
default:
actions = Repository.Actions.OrderByDescending(name => name.When);
break;
}
var data = new PageableData <Models.Action>(actions, page, itemsPerPage);
return(View(data)); //выводим лог список
}
public ActionResult Index(int page = 1)
{
var list = Repository.Posts.OrderByDescending(p => p.AddedDate);
var data = new PageableData <Post>(list, page);
data.List.ForEach(p => p.CurrentLang = CurrentLang.ID);
return(View(data));
}
public ActionResult Index(int page = 1)
{
var list = Repository.Users.OrderBy(p => p.ID);
var data = new PageableData<User>();
data.Init(list, page, "Index");
data.List.ForEach(p => p.CurrentLang = CurrentLang.ID);
return View(data);
}
// GET: Test
//public ActionResult Index()
//{
// var carmodels = Repository.CarModelss.ToList();
// return View(carmodels);
//}
public ActionResult Index(int page = 1)
{
ExistParser pasd = new ExistParser();
pasd.Parse("Tesla");
ViewData.Add("List", Repository.CarModelss);
var data = new PageableData <CarModels>(Repository.CarModelss, page, 30);
return(View(data));
}
/// <summary>
/// Renders a pager based on the PageableData object, which is itself a standardized collection for carrying pages of objects from a collection.
/// </summary>
/// <param name="page">PageableData object which pager will represent</param>
/// <param name="pagesPerGroup">Number of page links to occur on pager. If more pages than this are possible, a "next" link is rendered.</param>
/// <param name="baseurl">Nullable. Use if the existing url already has query string arguments in it. Paging args will be appended to url preserving existing.</param>
/// <param name="pageQueryStringArg">Name of page query string argument</param>
/// <returns>Rendered Html of pager.</returns>
public string Render <T>(PageableData <T> page, int pagesPerGroup, string baseurl, string pageQueryStringArg, string hash = "")
{
this.Calculate(page.VirtualItemCount, page.PageIndex, page.PageSize, pagesPerGroup);
if (this.NotEnoughDataToPage)
{
return(string.Empty);
}
return(this.RenderPageLinks(page.PageIndex, pagesPerGroup, baseurl, pageQueryStringArg, hash));
}
public ActionResult Index(int page = 1)
{
var userEmail = Convert.ToString(HttpContext.Request.Cookies["Email"].Value);
var user = Repository.Users.FirstOrDefault(p => p.Email == userEmail);
var bookmarkView = new BookmarkView();
bookmarkView.UserId = user.ID;
ViewBag.ID = bookmarkView.UserId;
var data = new PageableData<Bookmarks>(Repository.Bookmark.OrderBy(p => p.UserID).Where(x => x.UserID == bookmarkView.UserId), page, 12);
return View(data);
}
public ActionResult Index(int page = 1)
{
var userEmail = Convert.ToString(HttpContext.Request.Cookies["Email"].Value);
var user = Repository.Users.FirstOrDefault(p => p.Email == userEmail);
var calendarView = new CalendarView();
calendarView.UserId = user.ID;
ViewBag.ID = calendarView.UserId;
var data = new PageableData<Calendar>(Repository.Calendar.Where(x => x.UserID == calendarView.UserId).Where(d => d.Date.Day == DateTime.Now.Day).OrderBy(p => p.Date).OrderBy(p => p.Time), page, 10);
return View(data);
}
public ActionResult Index(int page = 1, string searchString = null)
{
ViewBag.Search = searchString;
if (!string.IsNullOrWhiteSpace(searchString))
{
var list = SearchEngine.Search(searchString, Repository.Users).AsQueryable();
var data = new PageableData<User>(list, page, 5);
return View(data);
}
else
{
var data = new PageableData<User>(Repository.Users, page, 5);
return View(data);
}
}
public ActionResult Index(int page = 1, string searchString = null)
{
ViewBag.Search = searchString;
if (!string.IsNullOrWhiteSpace(searchString))
{
var list = SearchEngine.Search(searchString, Repository.Users).AsQueryable();
var data = new PageableData <User>(list, page, 5);
return(View(data));
}
else
{
var data = new PageableData <User>(Repository.Users, page, 5);
return(View(data));
}
}
public IActionResult Packages(int page)
{
// user-facing page values start at 1 instead of 0. reset
if (page != 0)
{
page--;
}
Pager pager = new Pager();
PageableData <Package> packages = _packageList.GetPage(page, _settings.ListPageSize);
ViewData["pager"] = pager.Render(packages, _settings.PagesPerPageGroup, "/packages", "page");
ViewData["packages"] = packages;
return(View());
}
public ActionResult List(int? page, Search search)
{
IEnumerable<users> requestedUsers = DataBase.Users.Get();
if (!page.HasValue)
page = 1;
if (search == null)
ViewBag.Search = new Search();
else
{
ViewBag.Search = search;
requestedUsers= DataBase.Users.Search(search);
}
var requestedUsersView = requestedUsers.Select(u => new UserView(u)).AsQueryable();
var a = new PageableData<UserView>(requestedUsersView, (int)page, 15);
return View("List", a);
}
public object GetPage(string condition, object searchObj, string order, int offset, int limit)
{
string sql = GetPageSqlFromView("tb_organization", "*", order, condition, offset, limit);
PageableData <OrganModel> result = null;
using (MySqlConnection conn = new MySqlConnection(_connStr))
{
var reader = conn.QueryMultiple(sql, searchObj);
result = new PageableData <OrganModel>()
{
total = reader.Read <int>().FirstOrDefault(),
rows = reader.Read <OrganModel>()
};
}
return(result);
}
public PageableData <LogModel> GetPage(string condition, object searchObj, string order, int begin, int end)
{
string sql = GetPageSql(" * ", order, condition, begin, end);
PageableData <LogModel> result = null;
using (MySqlConnection conn = new MySqlConnection(_connStr))
{
var reader = conn.QueryMultiple(sql, searchObj);
result = new PageableData <LogModel>()
{
total = reader.Read <int>().FirstOrDefault(),
rows = reader.Read <LogModel>()
};
}
return(result);
}
/// <summary>
/// 获取一条订单的单身所有信息
/// </summary>
/// <param name="db"></param>
/// <param name="dh"></param>
/// <returns></returns>
public PageableData <Model.COPTD> CoptdList(string db, string dh)
{
PageableData <Model.COPTD> result = null;
string sql = string.Format("select* from COPTD where 1 = 1 and TD001 = '{0}' and TD002 = '{1}'", db, dh);
using (SqlConnection conn = new SqlConnection(ConnStrManage.WSGCDB))
{
var reader = conn.Query <Model.COPTD>(sql.ToString(), null);
result = new PageableData <Model.COPTD>()
{
total = reader.Count(),
rows = reader
};
}
return(result);
}
public void PageDataTest()
{
var data = new List <Item>();
for (var i = 0; i < 6; i++) //создаём тестовый список
{
data.Add(new Item {
ID_Item = Guid.NewGuid(), Itemname = "Item" + i.ToString()
});
}
var pd = new PageableData <Item>(data.AsQueryable(), 1, 5);
Assert.AreEqual(pd.CountPage, 2); //проверяем кол-во страниц
Assert.AreEqual(pd.List.Count(), 5); //проверяем кол-во элементов на странице
Assert.AreEqual(pd.List.ToList()[4].Itemname, "Item4"); //проверяем последний элемент списка
}
public PageableData <DBModel> GetPage(string condition, object searchObj, string order, int begin, int end)
{
string sql = GetPageSqlFromView("tb_dataconfig", " *", order, condition, begin, end);
PageableData <DBModel> result = null;
using (MySqlConnection conn = new MySqlConnection(ConfigManage.GetInstance().GetSysConnStr()))
{
var reader = conn.QueryMultiple(sql, searchObj);
result = new PageableData <DBModel>()
{
total = reader.Read <int>().FirstOrDefault(),
rows = reader.Read <DBModel>()
};
}
return(result);
}
public async Task<PageableData<UserMiniDto>> GetUsersDtoAsync(UserFiltersDto dto)
{
Expression<Func<User, bool>> filter = x => true;
if (dto.RoleGroupId.HasValue)
{
filter = filter.And(x => x.RoleGroupId == dto.RoleGroupId.Value);
}
if (!string.IsNullOrWhiteSpace(dto.UserName))
{
filter = filter.And(x => x.UserName.Contains(dto.UserName));
}
var users = await _userRepository.GetListAsync(dto.Page, filter: filter);
var usersDto = _mapper.Map<IEnumerable<UserMiniDto>>(users);
var allUsersCount = await _userRepository.GetCountAsync(filter);
var result = new PageableData<UserMiniDto>(usersDto, dto.Page, allUsersCount);
return result;
}
public ViewResult ListWithFilter(string filterDiscr = "", int page = 1)
{
var categories = repository.Products;
if (filterDiscr != "")
{
List <string> categor = new List <string>();
foreach (var word in Regex.Split(filterDiscr, "_or_"))
{
categor.Add(word);
}
ViewBag.FilterDiscr = filterDiscr;
categories = categories.Where(e => categor.Contains(e.CategoryUrl));
}
var data = new PageableData <Product>(categories.ToList(), page, PageSize);
return(View(data));
}
public JsonResult Search(int limit, int offset, DateTime?startTime, DateTime?endTime, int?LogType)
{
PageableData <LogModel> temp = _business.GetPage(LogType, startTime, endTime, limit, offset);
PageableData <object> list = new PageableData <object>()
{
total = temp.total,
rows = temp.rows.Select(n => new
{
n.Id,
n.Content,
Time = n.Time.ToString("yyyy-MM-dd HH:mm:ss"),
n.Username,
Type = n.Type.GetDescription()
})
};
return(Json(list));
}
public async Task InvokeAsync(IMiddlewareContext context)
{
await _next(context).ConfigureAwait(false);
IValueNode filter = context.Argument <IValueNode>(_contextData.ArgumentName);
if (filter is null || filter is NullValueNode)
{
return;
}
IQueryable <T>? source = null;
PageableData <T>?p = null;
if (context.Result is PageableData <T> pd)
{
source = pd.Source;
p = pd;
}
if (context.Result is IQueryable <T> q)
{
source = q;
}
else if (context.Result is IEnumerable <T> e)
{
source = e.AsQueryable();
}
if (source != null &&
context.Field.Arguments[_contextData.ArgumentName].Type is InputObjectType iot &&
iot is IFilterInputType fit)
{
var visitorContext = new QueryableFilterVisitorContext(
iot, fit.EntityType, _converter, source is EnumerableQuery);
QueryableFilterVisitor.Default.Visit(filter, visitorContext);
source = source.Where(visitorContext.CreateFilter <T>());
context.Result = p is null
? (object)source
: new PageableData <T>(source, p.Properties);
}
}
public ActionResult Index(int id = -1, bool isCategory = false, int page = 1, int itemPerPage = 10, int sort = 0)
{
ViewBag.sort = sort;
if (!User.IsInRole("Admin"))
{
return(HttpNotFound());
}
var products = new List <Product>();
var notOrderList = presentsDB.Products.Where(e => e.IsValid == true).ToList();
switch (sort)
{
case 0: products = notOrderList.OrderBy(e => e.Name).ToList();
break;
case 1: products = notOrderList.OrderByDescending(e => e.Name).ToList();
break;
case 2: products = notOrderList.OrderBy(e => e.Price).ToList();
break;
case 3: products = notOrderList.OrderByDescending(e => e.Price).ToList();
break;
case 4: products = notOrderList.OrderBy(e => e.Quantity).ToList();
break;
case 5: products = notOrderList.OrderByDescending(e => e.Quantity).ToList();
break;
case 6: products = notOrderList.OrderBy(e => e.Popularity).ToList();
break;
case 7: products = notOrderList.OrderByDescending(e => e.Popularity).ToList();
break;
default: products = notOrderList;
break;
}
var data = new PageableData <Product>(products.ToList(), page, itemPerPage);
return(View(data));
}
public PageableData <T> GetPage <T>(string condition, object searchObj, string order, int begin, int end, string viewName = "")
{
if (string.IsNullOrEmpty(viewName))
{
viewName = _tableName;
}
string sql = GetPageSqlFromView(viewName, "*", order, condition, begin, end);
PageableData <T> result = null;
using (MySqlConnection conn = new MySqlConnection(ConnStrManage.DB))
{
var reader = conn.QueryMultiple(sql, searchObj);
result = new PageableData <T>()
{
total = reader.Read <int>().FirstOrDefault(),
rows = reader.Read <T>()
};
}
return(result);
}
public JsonResult Search(int limit, int offset, string username, int?state, int?typeId)
{
var temp = _business.GetPage(username, state, typeId, limit, offset);
PageableData <object> list = new PageableData <object>()
{
rows = temp.rows.Select(n => new
{
n.Email,
n.Id,
n.RealName,
n.Username,
n.Telphone,
RoleName = n.RoleId.GetDescription(),
n.State,
n.OrganName
}),
total = temp.total
};
return(Json(list));
}
public void Basic()
{
Directory.CreateDirectory(Path.Combine(Settings.PackagePath, "package2003"));
Directory.CreateDirectory(Path.Combine(Settings.PackagePath, "package2002"));
Directory.CreateDirectory(Path.Combine(Settings.PackagePath, "package2001"));
File.WriteAllText(Path.Combine(Settings.PackagePath, "package2003", "manifest.json"), JsonConvert.SerializeObject(new Manifest()));
File.WriteAllText(Path.Combine(Settings.PackagePath, "package2002", "manifest.json"), JsonConvert.SerializeObject(new Manifest()));
File.WriteAllText(Path.Combine(Settings.PackagePath, "package2001", "manifest.json"), JsonConvert.SerializeObject(new Manifest()));
Assert.Equal("package2001", this.PackageList.GetPage(0, 1).Page.First().Id);
Assert.Equal("package2002", this.PackageList.GetPage(1, 1).Page.First().Id);
Assert.Equal("package2003", this.PackageList.GetPage(2, 1).Page.First().Id);
PageableData <Package> page = this.PackageList.GetPage(0, 1);
Assert.Equal(3, page.VirtualItemCount);
Assert.Equal(3, page.TotalPages);
Assert.Equal(1, page.PageSize);
Assert.Equal(0, page.PageIndex);
}
public ActionResult Catalog()
{
Dictionary <Product, int> frequencies = new Dictionary <Product, int>();
foreach (var subcategory in db.Subcategories.Where(e => e.Question.Length > 0).ToList())
{
string ansver = Request[subcategory.SubcategoryId.ToString()];
if (ansver != null && ansver.Equals("yes"))
{
foreach (var product in subcategory.Products)
{
if (frequencies.ContainsKey(product))
{
frequencies[product] += 1;
}
else
{
frequencies.Add(product, 1);
}
}
}
}
if (frequencies.Count == 0)
{
return(RedirectToAction("Browse", "Store", new { id = 1, isCategory = true }));
}
IOrderedEnumerable <KeyValuePair <Product, int> > orderByDescending = frequencies.OrderByDescending(i => i.Value);
List <ProductFrequency> helpList = new List <ProductFrequency>();
foreach (var keyValuePair in orderByDescending)
{
helpList.Add(new ProductFrequency(keyValuePair.Key, keyValuePair.Value));
}
Session["finalResult"] = helpList;
ViewBag.sortType = 2;
var data = new PageableData <ProductFrequency>(helpList, 1, 10);
return(View(data));
}
public ActionResult Browse(int id, bool isCategory, int page = 1, int itemPerPage = 10, int sort = 0)
{
ViewBag.categoryId = id;
ViewBag.sort = sort;
ViewBag.IsCategory = isCategory;
List <Product> products = new List <Product>();
if (isCategory)
{
var categoryName = presentsDB.Categories.FirstOrDefault(e => e.CategoryId == id).Name;
ViewBag.categoryName = categoryName;
Category category = presentsDB.Categories.Find(id);
foreach (var sub in category.Subcategories)
{
products.AddRange(sub.Products);
}
}
else
{
var categoryName = presentsDB.Subcategories.FirstOrDefault(e => e.SubcategoryId == id).Name;
ViewBag.categoryName = categoryName;
products = presentsDB.Subcategories.Find(id).Products.ToList();
}
products = products.Distinct().ToList();
products = products.Where(e => e.IsValid).ToList();
if (sort == 0)
{
products = products.OrderBy(x => x.Price).ToList();
}
else if (sort == 1)
{
products = products.OrderByDescending(x => x.Price).ToList();
}
var data = new PageableData <Product>(products, page, itemPerPage);
return(View(data));
}
public JsonResult Search(int limit, int offset, string organizationName, string name, string lineIp)
{
var user = GetUser();
var temp = _business.GetPage(organizationName, name, lineIp, user.OrganId, limit, offset);
PageableData <object> list = new PageableData <object>()
{
total = temp.total,
rows = temp.rows.Select(n => new
{
n.Id,
n.Name,
n.LineIP,
n.Description,
LineType = n.LineType.GetDescription(),
ServiceProvider = n.ServiceProvider.GetDescription(),
n.OrganizationName,
n.ParentOrganizationName,
ConnectState = n.ConnectState ? "连通" : "断开"
})
};
return(Json(list));
}
[ValidateInput(false)] //Аттрибут отключает проверку (чтоб не возникало HttpRequestValidationException)
public ViewResult UserList(int page = 1, int sorted = 0, int itemsPerPage = 0, string searchString = null)
{
//Сортируем пользователей по полю (сортед = 1 - по должности)
var sortItems = sorted == 0 ? Repository.Users.OrderBy(name => name.Username) : Repository.Users.OrderByDescending(name => name.Post);
itemsPerPage = itemsPerPage == 0 ? Globals.itemsPerPage : itemsPerPage; //определяем текущее кол-во элементов на странице
ViewBag.ItemsPage = itemsPerPage;
ViewBag.Sorted = sorted;
ViewBag.Search = searchString;
if (!string.IsNullOrWhiteSpace(searchString))
{
var list = SearchEngine <User> .Search(searchString, sortItems).AsQueryable();
var data = new PageableData <User>(list, page, itemsPerPage);
return(View(data)); //выводим результаты поиска
}
else
{
var data = new PageableData <User>(sortItems, page, itemsPerPage);
return(View(data)); //выводим список пользователей
}
}
[ValidateInput(false)] //по аналогии с UserController
public ViewResult EquipList(int page = 1, int sorted = 0, int itemsPerPage = 0, string searchString = null)
{
//Выводим итемы по их типу (если sorted = 0 то выводим всё подряд)
var typeItems = sorted != 0 ? Repository.Items.Where(itm => itm.Cast == sorted).OrderBy(name => name.Itemname) : Repository.Items.OrderBy(name => name.Itemname);
itemsPerPage = itemsPerPage == 0 ? Globals.itemsPerPage : itemsPerPage; //определяем текущее кол-во элементов на странице
ViewBag.ItemsPage = itemsPerPage;
ViewBag.Search = searchString;
ViewBag.Sorted = sorted;
if (!string.IsNullOrWhiteSpace(searchString))
{
var list = SearchEngine <Item> .Search(searchString, typeItems).AsQueryable();
var data = new PageableData <Item>(list, page, itemsPerPage);
return(View(data)); //выводим результаты поиска
}
else
{
var data = new PageableData <Item>(typeItems, page, itemsPerPage);
return(View(data)); //отображаем список предметов
}
}
public async Task<PageableData<MaterialMiniDto>> GetDtoAllAsync(MaterialFiltersDto filters)
{
var itemPerPage = GlobalConstants.NewsPerPage;
Expression<Func<Material, bool>> filter = x => x.Type == filters.MaterialType;
if (filters.CategoryId.HasValue)
{
filter = filter.And(x => x.CategoryId == filters.CategoryId.Value);
}
if (!string.IsNullOrWhiteSpace(filters.UserName))
{
Expression<Func<Material, bool>> newFilter = x => x.Author.UserName.Contains(filters.UserName);
filter = filter.And(newFilter);
}
ICollection<Material> topNews = new List<Material>();
if (filters.Page == GlobalConstants.FirstPage)
{
topNews = await _materialRepository.GetTopMaterialsAsync(filter);
itemPerPage = GlobalConstants.NewsPerPage - topNews.Count > 0
? GlobalConstants.NewsPerPage - topNews.Count
: 0;
}
var allNewsCount = await _materialRepository.GetCountAsync(filter);
var news =
await
_materialRepository.GetOrderedByDescAndNotTopAsync(filters.Page, itemPerPage, filter,
x => x.AdditionTime);
var newsForView = topNews.Concat(news);
var newsDtos = _mapper.Map<IEnumerable<MaterialMiniDto>>(newsForView);
var result = new PageableData<MaterialMiniDto>(newsDtos, filters.Page, allNewsCount);
return result;
}
public PageableData <AlarmModel> GetPage(string condition, object searchObj, string order, int begin, int end)
{
string sql = GetPageSqlFromView("tb_alarm", " * ", order, condition, begin, end);
//string sql = GetSelectSqlByName("view_alarm", "*", condition, order);
PageableData <AlarmModel> result = null;
using (MySqlConnection conn = new MySqlConnection(_connStr))
{
var reader = conn.QueryMultiple(sql, searchObj);
result = new PageableData <AlarmModel>()
{
total = reader.Read <int>().FirstOrDefault(),
rows = reader.Read <AlarmModel>()
};
//var result = conn.Query<AlarmModel>(sql, searchObj);
//result.rows.ToList().ForEach(delegate (AlarmModel n)
//{
// n.LastTime = string.IsNullOrEmpty(n.LastTime) ? "" : n.LastTime.Replace('T', ' ');
// n.FirstTime = string.IsNullOrEmpty(n.FirstTime) ? "" : n.FirstTime.Replace('T', ' ');
// n.TypeStr = ((AlarmType)n.Type).GetDescription();
//});
return(result);
}
}
public ActionResult AllNews(int page = 1)
{
List<News> ne = Repository.AllNews.ToList();
var data = new PageableData<News>(Repository.AllNews.OrderByDescending(s => s.DateNew), page, 5);
return View(data);
}
public ActionResult My()
{
return View("developing");
var at = Request.Cookies["access_token"].Value;
var qs = DataBase.Missions.GetByAccess(at).Select(q => new MissionView(q));
var page = 1;
var a = new PageableData<MissionView>(qs.AsQueryable(), (int)page, 5);
return View("My", a);
}
// GET: Admin/PHoto
public ActionResult Index(int page=1, int itemPerPage=16)
{
var listOptions = new SelectItemPerPageList();
var list = db.JewelPHotos.OrderBy(x => x.Caption).AsQueryable();
if (listOptions.Options.Any(x => x == itemPerPage) == false)
{
itemPerPage = 16;
}
var pd = new PageableData<JewelPHoto>(list,page,itemPerPage);
ViewBag.OptionsListViewItems = listOptions.GetSelectListItems(itemPerPage);
return View(pd);
}
