/// <summary>
/// Paginations the search_ call next page_1.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
private void paginationSearch_CallNextPage_1(object sender, PageArgs args)
{
if (this.TagData != null)
{
this.changePageTags(sender, args);
}
}
/// <summary>
/// Handles the LinkClicked event of the lLPreviousPage control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Windows.Forms.LinkLabelLinkClickedEventArgs"/> instance containing the event data.</param>
private void lLPreviousPage_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Page--;
PageArgs args = new PageArgs(Page);
this.CallPreviousPage(sender, args);
}
/// <summary>
/// Handles the LinkClicked event of the lLNextPage control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Windows.Forms.LinkLabelLinkClickedEventArgs"/> instance containing the event data.</param>
private void lLNextPage_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
Page++;
PageArgs args = new PageArgs(Page);
this.CallNextPage(sender, args);
}
/// <summary>
/// Changes the page tags.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
private void changePageTags(object sender, PageArgs args)
{
TagsArgs newArgs = new TagsArgs("", this.Page, this.TagData);
this.Page = paginationSearch.Page;
this.ChangeTagsPage(sender, newArgs);
}
public JsonResult GetModulesSimpleInfoByPage(int pageNumber, int pageSize)
{
Expression <Func <Module, bool> > where = r => true;//
var moduleName = HttpContext.Request["ModuleName"];
if (!string.IsNullOrEmpty(moduleName))
{
where = where.And(m => m.Name.Contains(moduleName));
}
var pageArgs = new PageArgs {
PageSize = pageSize, PageIndex = pageNumber
};
var result = _moduleSrv.FindByPageWithSimpleInfo(where, query => query.OrderBy(r => r.SortOrder), pageArgs);
if (result.ResultType == OperationResultType.Success)
{
var modules = BuildModulesTree(result.AppendData as List <ModuleSimpleViewModel>);
var formatObj = FormatDataForTreeView(modules);
return(new JsonNetResult
{
Data = new { code = result.ResultType, message = "数据获取成功", total = pageArgs.RecordsCount, rows = formatObj },
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
else
{
return(Json(new { code = result.ResultType, message = result.Message }, JsonRequestBehavior.AllowGet));
}
}
protected virtual void OnPageChange(Object sender, PageArgs e)
{
if (PageChanged != null)
{
PageChanged(this, e);
}
}
public JsonResult GetRoleFullInfoByPage(int pageNumber, int pageSize)
{
Expression <Func <Role, bool> > where = r => true;
var roleName = HttpContext.Request["RoleName"];
if (!string.IsNullOrEmpty(roleName))
{
where = where.And(r => r.RoleName.Contains(roleName));
}
var pageArgs = new PageArgs {
PageSize = pageSize, PageIndex = pageNumber
};
var result = _roleSrv.FindByPageWithFullInfo(where, query => query.OrderBy(r => r.SortOrder), pageArgs);
if (result.ResultType == OperationResultType.Success)
{
return(new JsonNetResult
{
Data = new { code = result.ResultType, message = "数据获取成功", total = pageArgs.RecordsCount, rows = result.AppendData },
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
else
{
return(Json(new { code = result.ResultType, message = result.Message }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult GetUsersSimpleInfoByPage(int pageNumber, int pageSize)
{
Expression <Func <User, bool> > where = u => true;//只能是激活的用户
var usrName = HttpContext.Request["UserName"];
if (!string.IsNullOrEmpty(usrName))
{
where = where.And(u => u.UserName.Contains(usrName));
}
var pageArgs = new PageArgs {
PageSize = pageSize, PageIndex = pageNumber
};
var result = _userSrv.FindBySelectorByPage(where,
u => new
{
Id = u.Id,
UserName = u.UserName
},
query => query.OrderBy(u => u.UserName),
pageArgs);
if (result.ResultType == OperationResultType.Success)
{
return(new JsonNetResult
{
Data = new { code = result.ResultType, message = "数据获取成功", total = pageArgs.RecordsCount, rows = result.AppendData },
JsonRequestBehavior = JsonRequestBehavior.AllowGet,
DateTimeFormat = "yyyy-MM-dd HH:mm:ss"
});
}
else
{
return(Json(new { code = result.ResultType, message = result.Message }, JsonRequestBehavior.AllowGet));
}
}
public void RaisePostBackEvent(string eventArgument)
{
this.CurPage = Int32.Parse(System.Web.HttpContext.Current.Request.Form[this.UniqueID].ToString());
PageArgs e = new PageArgs();
e.CurPage = CurPage;
OnPageChange(this, e);
}
/// <summary>
/// Handles the LinkClicked event of the lLNextFollowers control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Windows.Forms.LinkLabelLinkClickedEventArgs"/> instance containing the event data.</param>
private void lLNextFollowers_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.FollowersPage++;
PageArgs args = new PageArgs(this.FollowersPage);
this.LoadNextFollowerPage(sender, args);
this.setLinksStatus();
}
/// <summary>
/// Handles the LinkClicked event of the lLPreviousFollowing control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Windows.Forms.LinkLabelLinkClickedEventArgs"/> instance containing the event data.</param>
private void lLPreviousFollowing_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.FollowingsPage--;
PageArgs args = new PageArgs(this.FollowingsPage);
this.LoadPreviousFollowingPage(sender, args);
this.setLinksStatus();
}
/// <summary>
/// Handles the LinkClicked event of the lLPreviousRequests control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="System.Windows.Forms.LinkLabelLinkClickedEventArgs"/> instance containing the event data.</param>
private void lLPreviousRequests_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)
{
this.RequestsPage--;
PageArgs args = new PageArgs(this.RequestsPage);
this.LoadPreviousRequestPage(sender, args);
this.setLinksStatus();
}
public PagedResult <LibraryCard> Search(SearchFilters filter, PageArgs pageArgs)
{
ApplyCustomerNameFilter(filter.CustomerName);
var pagedResult = GetPageData(DataSet, pageArgs).ToList();
var mappedData = pagedResult.Select(c => c.Map());
return(CreatePagedResult(mappedData, pageArgs));
}
public PagedResult <T> CreatePagedResult <T>(IEnumerable <T> pageData, PageArgs pageArgs)
{
return(new PagedResult <T>
{
PageSize = pageArgs?.PageSize,
PageNumber = pageArgs?.PageNumber ?? 1,
PageData = pageData
});
}
public static void PageUpdate()
{
PageArgs pageArgs = (PageArgs)PSCDialog.DataShare;
Page page = pageArgs.Page;
page.Update();
page.UpdatePageLayout(pageArgs.Page.LayoutId);
DataStatic["PageList"] = null;
}
public PagedResult <Book> Search(SearchFilters filter, PageArgs pageArgs)
{
ApplyNameFilter(filter.AuthorName)
.ApplyRentedCustomerFilter(filter.RentedByCustomerId);
var pagedResult = GetPageData(DataSet, pageArgs).ToList();
var mappedData = pagedResult.Select(c => c.Map <Book, BookEntity>());
return(CreatePagedResult(mappedData, pageArgs));
}
public PagedResult <Customer> Search(SearchFilters filter, PageArgs pageArgs)
{
ApplyIdentityNumber(filter.CustomerIdentityNumber)
.ApplyIdentityNumber(filter.CustomerName)
.ApplyBookFilters(filter.RentedBookId, filter.OutstandingBookTitle);
var pagedResult = GetPageData(DataSet, pageArgs).ToList();
var mappedData = pagedResult.Select(c => c.Map());
return(CreatePagedResult(mappedData, pageArgs));
}
protected override void OnNavigatedTo(NavigationEventArgs e)
{
if (e.Parameter != null && e.Parameter is PageArgs)
{
_mPageArgs = (PageArgs)e.Parameter;
_mWebView.Language = "en-US";
Windows.UI.Xaml.Media.TranslateTransform transform = new Windows.UI.Xaml.Media.TranslateTransform();
transform.X = -200;
_mWebView.RenderTransform = transform;
_mWebView.Source = new Uri(_mPageArgs.StartUrl);
}
}
/// <summary>
/// Controls the panel_ load following list event.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
private void controlPanel_LoadFollowingListEvent(object sender, PageArgs args)
{
try
{
List <Model.User.UserFollow> userFollowingList;
Guid newToken = Guid.Empty;
userFollowingList = userController.GetUserOwnFollows(out newToken, Session.User.Id, Session.CurrentToken, Session.User.Id, this.ControlPanelNumber, args.Page);
this.Session.CurrentToken = newToken;
this.controlPanel.LoadFollowingList(userFollowingList);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public static void PageAdd()
{
PageArgs pageArgs = (PageArgs)PSCDialog.DataShare;
Page page = pageArgs.Page;
PageList.AddDB(page);
page.UpdatePageLayout(page.LayoutId);
// check subdomain
Guid subId = SessionHelper.GetSession(SessionKey.SubDomain) == string.Empty ? Guid.Empty : new Guid(SessionHelper.GetSession(SessionKey.SubDomain));
if (!(subId == Guid.Empty))
{
SubDomainInPage sip = new SubDomainInPage();
sip.PageId = page.Id;
sip.SubDomainId = subId;
sip.AddDB();
}
}
private async void WebView_DOMContentLoaded(WebView sender, WebViewDOMContentLoadedEventArgs args)
{
if (_mPageArgs != null)
{
string url = _mWebView.Source.ToString();
if (url.StartsWith("https://www.twitch.tv/"))
{
if (url.StartsWith("https://www.twitch.tv/login"))
{
}
else
{
//invoke callback and close window
if (_mPageArgs.OnComplete != null)
{
string html = await _mWebView.InvokeScriptAsync("eval", new string[] { "document.documentElement.outerHTML;" });
await _mPageArgs.OnComplete(html);
}
_mPageArgs = null;
Window.Current.Close();
}
}
else
{
if (url.StartsWith(_mPageArgs.EndUrl))
{
if (_mPageArgs.OnComplete != null)
{
string html = await _mWebView.InvokeScriptAsync("eval", new string[] { "document.documentElement.outerHTML;" });
await _mPageArgs.OnComplete(html);
_mPageArgs = null;
Window.Current.Close();
}
}
}
}
}
public OperationResult FindByPageWithFullInfo(Expression <Func <User, bool> > where, Func <IQueryable <User>, IOrderedQueryable <User> > orderBy, PageArgs pageArgs)
{
OperationResult result = new OperationResult();
try
{
//先分页
var userPaged = _usrRepository.FindByPage(where, orderBy, pageArgs);
//再连接
var usrList = (from usr in userPaged
join creator in _usrRepository.Entities on usr.Creator equals creator.Id into creatorQuery
from c in creatorQuery.DefaultIfEmpty()
join lastmodifier in _usrRepository.Entities on usr.LastModifier equals lastmodifier.Id into lastmodifierQuery
from m in lastmodifierQuery.DefaultIfEmpty()
select new UserDetailViewModel
{
Id = usr.Id,
UserName = usr.UserName,
Email = usr.Email,
Enabled = usr.Enabled,
Creator = usr.Creator,
CreatorName = c.UserName,
CreateTime = usr.CreateTime,
LastModifier = usr.LastModifier,
LastModifierName = m.UserName,
LastModifyTime = usr.LastModifyTime
}).ToList();
var usrIds = usrList.Select(u => u.Id);
if (usrList != null && usrList.Count > 0)
{
//获取用户角色
var roles = (from urRel in _usrRoleRelRepository.Entities
join role in _roleRepository.Entities on urRel.RoleId equals role.Id into roleQuery
from r in roleQuery.DefaultIfEmpty()
where usrIds.Contains(urRel.UserId)
select new { urRel.UserId, r.RoleName })
.ToList();
usrList.ForEach(a => a.Roles =
string.Join("|",
roles.Where(r => r.UserId == a.Id)
.Select(r => r.RoleName)
.ToArray()));
}
result.ResultType = OperationResultType.Success;
result.AppendData = usrList;
}
catch (Exception ex)
{
base.ProcessException(ref result, string.Format("分页获取{0}用户详细信息失败", EntityType), ex);
}
return(result);
}
/// <summary>
/// Pagination_s the call previous page.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
private void pagination_CallPreviousPage(object sender, PageArgs args)
{
this.Page = args.Page;
Args.UsersArgs userArgs = new UsersArgs(this.TextSearched, args.Page, null);
this.CallPreviousPage(sender, userArgs);
}
public IQueryable <TEntity> QueryByPage(IQueryable <TEntity> querable, Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderBy, PageArgs pageArgs)
{
pageArgs.RecordsCount = querable.Count();
pageArgs.PageCount = Convert.ToInt32(Math.Ceiling(pageArgs.RecordsCount * 1.0 / pageArgs.PageSize));
if (pageArgs.PageIndex > pageArgs.PageCount)
{
//页索引不能超过总页数
pageArgs.PageIndex = pageArgs.PageCount - 1;
}
//页索引最小为1
if (pageArgs.PageIndex < 1)
{
pageArgs.PageIndex = 1;
}
//2、处理排序
var query = orderBy(querable);
//3、分页获取
var _list = query
.Skip((pageArgs.PageIndex - 1) * pageArgs.PageSize)
.Take(pageArgs.PageSize);
return(_list);
}
public IQueryable <dynamic> FindBySelectorByPage(Expression <Func <TEntity, bool> > where, Expression <Func <TEntity, dynamic> > selector, Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderBy, PageArgs pageArgs)
{
return(FindByPage(where, orderBy, pageArgs)
.Select(selector));
}
protected void OurPager1_PageChanged(object sender, PageArgs e)
{
LoadData(e.NewPageIndex);
}
/// <summary>
/// Pagination_s the call previous page.
/// </summary>
/// <param name="sender">The sender.</param>
/// <param name="args">The args.</param>
private void pagination_CallPreviousPage(object sender, PageArgs args)
{
TagsArgs newArgs = new TagsArgs(this.TagArgs.Text, args.Page, this.TagArgs.Tag);
this.CallPreviousPage(sender, newArgs);
}
/// <summary>
/// Loads the tags.
/// </summary>
/// <param name="tags">The tags.</param>
/// <param name="args">The args.</param>
public void LoadTags(List <Model.Tag.Tag> tags, PageArgs args)
{
this.TagArgs.Page = args.Page;
this.LoadTags(tags, this.TagArgs);
}
public OperationResult FindBySelectorByPage(Expression <Func <TEntity, bool> > where, Expression <Func <TEntity, dynamic> > selector, Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderBy, PageArgs pageArgs)
{
OperationResult result = new OperationResult();
if (pageArgs == null)
{
result.ResultType = OperationResultType.ParamError;
result.Message = string.Format("分页获取{0}实体集失败，分页参数不能为空", EntityType);
return(result);
}
try
{
var data = CurrentRepository.FindBySelectorByPage(where, selector, orderBy, pageArgs);
result.ResultType = OperationResultType.Success;
result.AppendData = data.ToList();
}
catch (Exception ex)
{
ProcessException(ref result, string.Format("分页获取{0}实体集失败", EntityType), ex);
}
return(result);
}
public IQueryable <TEntity> FindByPage(Expression <Func <TEntity, bool> > where, Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderBy, PageArgs pageArgs)
{
var query = Find(where);
return(QueryByPage(query, orderBy, pageArgs));
}
