public ActionResult GetPartnerCollectionForPaging(string sidx, string sord, string filters, int page = 1)
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter())
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
long firmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
bucket.PredicateExpression.Add(PartnerFields.FirmaId == firmaId);
if (filters != null)
{
bucket.PredicateExpression.Add(PredicateHelper.CreatePredicateFromJqGridFilterString(filters, typeof(PartnerFields), DbGenericHelper.GetDbGenericTypeByName));
}
if (!string.IsNullOrWhiteSpace(filters))
{
JqGridFilter jqGridFilter = JsonConvert.DeserializeObject <JqGridFilter>(filters);
bool foo;
JqGridFilterItem filterItem = jqGridFilter.rules.Where(r => r.field == PartnerFields.IsActive.Name && bool.TryParse(r.data, out foo)).SingleOrDefault();
if (filterItem != null)
{
bool isActive = bool.Parse(filterItem.data);
bucket.PredicateExpression.Add(PartnerFields.IsActive == isActive);
}
}
bool?isSortAscending = PagerBase.IsJqgridSortAscending(sord);
PartnerPager partnerPager = new PartnerPager();
partnerPager.LoadData(adapter, bucket, page, Common.Config.JqGridPageSize, sidx, isSortAscending);
return(CreateJsonResponse(partnerPager.CreateJqGridRespose()));
}
}
public ActionResult GetArtiklCollectionForPaging(string sidx, string sord, string filters, int page = 1)
{
using (DataAccessAdapterBase adapter = Helper.GetDataAccessAdapter())
{
RelationPredicateBucket bucket = new RelationPredicateBucket();
long firmaId = UserEntity.GetFirmaId(adapter, User.Identity.Name);
bucket.PredicateExpression.Add(ArtiklFields.FirmaId == firmaId);
if (filters != null)
{
bucket.Relations.Add(ArtiklEntity.Relations.PdvEntityUsingPdvId);
bucket.PredicateExpression.Add(PredicateHelper.CreatePredicateFromJqGridFilterString(filters, typeof(ArtiklFields), DbGenericHelper.GetDbGenericTypeByName));
}
bool?isSortAscending = PagerBase.IsJqgridSortAscending(sord);
PrefetchPath2 prefetchPath = new PrefetchPath2(EntityType.ArtiklEntity);
prefetchPath.Add(ArtiklEntity.PrefetchPathPdv);
ArtiklPager artiklPager = new ArtiklPager();
artiklPager.LoadData(adapter, bucket, page, Common.Config.JqGridPageSize, sidx, isSortAscending);
return(CreateJsonResponse(artiklPager.CreateJqGridRespose()));
}
}
private void LoadItemsBySubmissions(long idCall, ManageEvaluationsAction action, String submitterName, long idSubmitterType, int pageIndex, int pageSize)
{
View.DisplayByEvaluator = false;
PagerBase pager = new PagerBase();
List <dtoBasicSubmissionItem> items = Service.GetItemsBySubmissionsForEvaluationsManagement(idCall, submitterName, idSubmitterType, action, View.AnonymousTranslation);
InitializeSelectedItems(items);
pager.PageSize = pageSize; //Me.View.CurrentPageSize
pager.Count = items.Count - 1;
pager.PageIndex = pageIndex; // Me.View.CurrentPageIndex
View.Pager = pager;
if (items != null && items.Any() && items.Count > 0)
{
View.LoadItems(items.Skip(pager.PageIndex * pageSize).Take(pageSize).ToList());
}
else
{
List <ManageEvaluationsAction> availableActions = Service.GetAvailableActionsForManageEvaluations(idCall);
View.DisplayNoEvaluations(true, false, (availableActions.Count > 0));
View.LoadAvailableActions(availableActions);
}
}
private void LoadCommunities(Int32 idCommunity, lm.Comol.Core.BaseModules.CommunityManagement.dtoCommunitiesFilters filters, Int32 pageIndex, Int32 pageSize, ModuleTags.ActionType action, Boolean firstLoad = false)
{
List <lm.Comol.Core.BaseModules.Dashboard.Domain.dtoCommunityForTags> items = ServiceCommunities.GetCommunitiesForBulkTagsManage(UserContext.CurrentUserID, filters);
Int32 itemsCount = (items == null ? 0 : items.Count);
PagerBase pager = new PagerBase();
pager.PageSize = pageSize;
pager.Count = (itemsCount > 0) ? itemsCount - 1 : 0;
pager.PageIndex = pageIndex;
View.Pager = pager;
if (items != null)
{
if (firstLoad && itemsCount == 0)
{
View.HideFilters();
}
else if (itemsCount == 0 && ServiceTags.GetCommunitiesWithNoTags() == 0)
{
View.HideFilters();
}
View.LoadCommunities(GenerateItems(filters, items.Skip(pager.PageIndex * pageSize).Take(pageSize).ToList(), itemsCount > pageSize));
View.SendUserAction(idCommunity, CurrentIdModule, action);
}
else
{
View.DisplayErrorFromDB();
}
}
public void LoadCalls(CallForPaperType type, Boolean fromPortal, List <Int32> fromCommunities, List <Int32> removeUsers, Int32 pageIndex, Int32 pageSize)
{
List <dtoCallInfo> calls = Service.GetCallsForPersonAssignments(type, fromPortal, fromCommunities, removeUsers, View.UnknownCommunityName, View.PortalName);
PagerBase pager = new PagerBase();
pager.PageSize = pageSize; //Me.View.CurrentPageSize
pager.Count = calls.Count - 1;
pager.PageIndex = pageIndex; // Me.View.CurrentPageIndex
View.CallsPager = pager;
if (calls != null && calls.Any())
{
calls = calls.Skip(pager.PageIndex * pageSize).Take(pageSize).OrderBy(c => c.CommunityName).OrderBy(c => c.Name).OrderByDescending(c => c.EndDate).ToList();
if (calls.Any())
{
View.LoadCalls(calls);
}
else
{
View.DisplayNoCallsAvailable();
}
}
else
{
View.DisplayNoCallsAvailable();
}
}
private void LoadItems(long idCall, EvaluationType type, Int32 idCommunity, dtoEvaluationsFilters filters, int pageIndex, int pageSize)
{
if (type == EvaluationType.Dss)
{
InitializeDssInfo(idCall);
}
else
{
View.HideDssWarning();
}
bool isAdvance = ServiceCall.CallIsAdvanced(idCall);
List <dtoEvaluationSummaryItem> items =
isAdvance ?
ServiceCall.GetEvaluationsList(idCall, View.IdCallAdvCommission, type, filters, View.AnonymousDisplayname, View.UnknownDisplayname) :
Service.GetEvaluationsList(idCall, type, filters, View.AnonymousDisplayname, View.UnknownDisplayname, true);
PagerBase pager = new PagerBase();
pager.PageSize = pageSize;
if (pageSize == 0)
{
pageSize = 50;
}
pager.Count = (int)items.Count - 1;
pager.PageIndex = pageIndex;// Me.View.CurrentPageIndex
View.Pager = pager;
View.CurrentOrderBy = filters.OrderBy;
View.CurrentFilterBy = filters.Status;
View.CurrentAscending = filters.Ascending;
View.PageSize = pageSize;
View.AllowExportCurrent = (items != null && items.Any() && items.Skip(pageIndex * pageSize).Take(pageSize).Any());
if (pager.Count < 0)
{
View.DisplayNoEvaluationsFound();
}
else
{
List <long> committees = Service.GetIdCommittees(idCall);
if (committees.Count == 1)
{
View.DisplayLinkToSingleCommittee(committees.FirstOrDefault());
}
View.LoadEvaluations(items.Skip(pageIndex * pageSize).Take(pageSize).ToList(), committees.Count);
}
View.SendUserAction(View.IdCallCommunity, View.IdCallModule, ModuleCallForPaper.ActionType.ViewEvaluationsSummary);
if (isAdvance)
{
bool cancloseAdvance = ServiceCall.CommissionCanClose(View.IdCallAdvCommission);
View.ShowCloseCommission(cancloseAdvance);
}
}
public void LoadUserMessages(dtoModuleMessagesContext context, int pageIndex, int pageSize)
{
if (UserContext.isAnonymous)
{
View.DisplaySessionTimeout();
}
else
{
Int32 count = Service.GetUserMessagesCount(context);
PagerBase pager = new PagerBase();
pager.PageSize = pageSize;
if (pageSize == 0)
{
pageSize = 50;
}
pager.Count = count - 1;
pager.PageIndex = pageIndex;// Me.View.CurrentPageIndex
View.Pager = pager;
View.CurrentPageSize = pageSize;
List <dtoDisplayUserMessage> items = Service.GetUserMessages(context, View.RemovedUserName, View.UnknownUserName, pageIndex, pageSize);
if (items == null || !items.Any() || items.Count <= 0)
{
View.DisplayNoMessagesFound();
}
else
{
View.LoadItems(items);
}
}
}
public List <Mes_Sys_Stock> FindByPage(Mes_Sys_Stock obj, ref PagerBase pager)
{
string sql = @"select * from Mes_Sys_Stock WHERE 1=1 ";
if (!string.IsNullOrEmpty(obj.StockCode))
{
sql += string.Format(" AND StockCode Like '%{0}%'", obj.StockCode);
}
if (!string.IsNullOrEmpty(obj.StockName))
{
sql += string.Format(" AND StockName Like '%{0}%'", obj.StockName);
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Sys_Stock>());
}
/// <summary>
/// 分页查询
/// </summary>
/// <param name="obj"></param>
/// <param name="pager"></param>
/// <returns></returns>
public List <Mes_Tec_Process> FindByPage(Mes_Tec_Process obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.Name AS ParentName FROM Mes_Tec_Process T1 WITH(NOLOCK)
LEFT JOIN Mes_Tec_Process T2 WITH(NOLOCK) ON T1.ParentCode=T2.ProcessCode
WHERE T1.RecordStatus = 1 ";
if (!string.IsNullOrEmpty(obj.Name))
{
sql += string.Format(" AND T1.Name Like '%{0}%'", obj.Name);
}
if (!string.IsNullOrEmpty(obj.ProcessCode))
{
if (obj.ProcessCode != "01")
{
sql += string.Format(" AND (T1.ProcessCode = '{0}' OR T1.ParentCode = '{0}')", obj.ProcessCode);
}
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "State,ProcessCode";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Tec_Process>());
}
private List <dtoSubmissionMultipleAssignment> GetItems(CallForPaper call, dtoSubmissionFilters filters, int pageIndex, int pageSize)
{
PagerBase pager = new PagerBase();
pager.PageSize = pageSize;
if (pageSize == 0)
{
pageSize = 50;
}
pager.Count = (int)CallService.SubmissionsCount(call.Id, filters) - 1;
pager.PageIndex = pageIndex;// Me.View.CurrentPageIndex
View.Pager = pager;
View.CurrentOrderBy = filters.OrderBy;
View.CurrentFilterBy = filters.Status;
View.CurrentAscending = filters.Ascending;
View.PageSize = pageSize;
if (pager.Count < 0)
{
return(new List <dtoSubmissionMultipleAssignment>());
}
else
{
return(Service.GetCommitteesAssignments(call, CallService.GetSubmissionsForEvaluation(call.Id, filters, pager.PageIndex, pageSize)));
}
}
public List <Mes_Sys_User> FindByPage(Mes_Sys_User obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T3.OrgName,T4.RoleName FROM Mes_Sys_User T1 WITH(NOLOCK)
LEFT JOIN Mes_Sys_Map T2 WITH(NOLOCK) ON T1.UserID = T2.UserID
LEFT JOIN Mes_Sys_Role T4 WITH(NOLOCK) ON T2.RoleID = T4.ID
LEFT JOIN dbo.Mes_Sys_Organization T3 WITH(NOLOCK) ON T1.OrgID = T3.ID
WHERE 1=1 ";
if (!string.IsNullOrEmpty(obj.UserID))
{
sql += string.Format(" AND T1.UserID Like '%{0}%'", obj.UserID);
}
if (!string.IsNullOrEmpty(obj.UserName))
{
sql += string.Format(" AND T1.UserName Like '%{0}%'", obj.UserName);
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Sys_User>());
}
public List <Mes_Tra_SourceBarcode> FindByPage(Mes_Tra_SourceBarcode obj, ref PagerBase pager)
{
string sql = @"SELECT T1.* FROM Mes_Tra_SourceBarcode T1 WITH(NOLOCK) WHERE 1=1 ";
if (!string.IsNullOrEmpty(obj.Barcode))
{
sql += string.Format(" AND T1.Barcode Like '{0}%'", obj.Barcode);
}
if (!string.IsNullOrEmpty(obj.PackSN))
{
sql += string.Format(" AND T1.PackSN Like '{0}%'", obj.PackSN);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeStart))
{
sql += string.Format(" AND T1.CreatedTime >='{0}'", obj.CreatedTimeStart);
}
if (!string.IsNullOrEmpty(obj.CreatedTimeEnd))
{
sql += string.Format(" AND T1.CreatedTime <'{0}'", TConvertHelper.FormatDBDate(obj.CreatedTimeEnd).AddDays(1));
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Tra_SourceBarcode>());
}
private void LoadRevisions(ModuleRequestForMembership module, CallStandardAction action, int idCommunity, dtoRevisionFilters filters, int pageIndex, int pageSize)
{
liteCommunity community = CurrentManager.GetLiteCommunity(idCommunity);
litePerson person = CurrentManager.GetLitePerson(UserContext.CurrentUserID);
Boolean fromAllcommunities = false;
PagerBase pager = new PagerBase();
pager.PageSize = pageSize;
if (action == CallStandardAction.Manage)
{
pager.Count = (int)Service.RevisionCount(fromAllcommunities, (idCommunity == 0), community, person, CallForPaperType.RequestForMembership, filters, RevisionType.Manager) - 1;
}
else
{
fromAllcommunities = (idCommunity == 0);
pager.Count = (int)Service.RevisionCount(fromAllcommunities, (idCommunity == 0), community, person, CallForPaperType.RequestForMembership, filters, RevisionType.UserRequired) - 1;
}
pager.PageIndex = pageIndex;// Me.View.CurrentPageIndex
View.Pager = pager;
if (pager.Count < 0)
{
View.LoadNoRevisionsFound();
}
else
{
View.LoadRevisions(Service.GetRevisionList(module, action, fromAllcommunities, (idCommunity == 0), community, person, filters, pager.PageIndex, pageSize));
}
View.SendUserAction(View.IdCallCommunity, ServiceRequest.ServiceModuleID(), ModuleRequestForMembership.ActionType.LoadRevisionsList);
}
public void LoadItems(dtoUsersByMessageFilter filter, Int32 pageIndex, Int32 pageSize, Boolean initialize)
{
View.WasGridInitialized = true;
List <dtoCallMessageRecipient> recipients = Service.GetAllUsers(View.UnknownUserTranslation, View.AnonymousUserTranslation, View.CurrentObject, View.RemoveUsers, filter, View.HasUserValues, MessageService, ProfileService);
filter.StartWith = View.CurrentStartWith;
if (initialize)
{
View.InitializeWordSelector(recipients.Select(r => r.FirstLetter).Distinct().ToList());
}
else
{
View.InitializeWordSelector(recipients.Select(r => r.FirstLetter).Distinct().ToList(), filter.StartWith);
}
recipients = Service.GetUsers(ProfileService, recipients, filter);
PagerBase pager = new PagerBase();
pager.PageSize = pageSize; //Me.View.CurrentPageSize
pager.Count = (recipients.Count > 0) ? recipients.Count - 1 : 0;
pager.PageIndex = pageIndex; // Me.View.CurrentPageIndex
View.Pager = pager;
View.SelectedItems = UpdateItemsSelection();
recipients = recipients.Skip(pageIndex * pageSize).Take(pageSize).ToList();
View.LoadedNoUsers = !recipients.Any();
if (recipients.Any())
{
View.LoadUsers(recipients);
}
else
{
View.DisplayNoUsersFound();
}
}
public void LoadPreviewItems(String value, String currentLetter, int currentPageIndex, int currentPageSize, Boolean updateSelection)
{
List <Int32> idSelectedUsers = UpdateTemporaryItemsSelection();
Boolean allowAll = View.AllowSelectAllFromPreview;
if (updateSelection)
{
View.TemporaryIdUsers = idSelectedUsers;
View.TemporaryItemsCount = idSelectedUsers.Count();
}
View.IsFirstPreviewLoad = false;
if (allowAll)
{
currentPageSize = View.SystemMaxGridItems;
}
PagerBase pager = new PagerBase();
pager.PageSize = currentPageSize; //Me.View.CurrentPageSize
pager.Count = Service.GetBaseProfilesCount(idSelectedUsers, value, currentLetter) - 1;
pager.PageIndex = currentPageIndex; // Me.View.CurrentPageIndex
View.PreviewPager = pager;
if (updateSelection)
{
View.SelectedIdUsers = UpdateItemsSelection();
}
List <dtoBaseProfile> items = Service.GetBaseProfiles(idSelectedUsers, value, currentLetter, (allowAll) ? 0 : View.DefaultMaxPreviewItems);
View.DisplayUsersPreview(items.Skip(currentPageIndex * currentPageSize).Take(currentPageSize).ToList(), pager.Count - 1);
}
public List <Mes_Sys_Employee> FindByPage(Mes_Sys_Employee obj, ref PagerBase pager)
{
string sql = @"SELECT T1.*,T2.OrgName FROM Mes_Sys_Employee T1 WITH(NOLOCK)
LEFT JOIN dbo.Mes_Sys_Organization T2 WITH(NOLOCK) ON T1.OrgID = T2.ID
WHERE T1.RecordStatus=1";
if (!string.IsNullOrEmpty(obj.EmpNo))
{
sql = sql + string.Format(" AND T1.EmpNo='{0}'", obj.EmpNo);
}
if (!string.IsNullOrEmpty(obj.EmpName))
{
sql = sql + string.Format(" AND T1.EmpName LIKE '%{0}%'", obj.EmpName);
}
if (obj.OrgID > 0)
{
sql = sql + string.Format(" AND T1.OrgID = {0}", obj.OrgID);
}
string orderBy = pager.OrderBy;
if (string.IsNullOrEmpty(orderBy))
{
orderBy = "CreatedTime DESC";
}
string cmdPageSql = string.Format(BaseDao.PageSql, orderBy, sql, pager.StartNo, pager.EndNo);
string cmdCountSql = string.Format(BaseDao.CountSql, sql.Substring(sql.ToLower().IndexOf("from", StringComparison.Ordinal)));
//查询总记录数
pager.TotalItemCount = this.CurDbSession.FromSql(cmdCountSql).ToScalar <int>();
//返回当前页的记录数
return(this.CurDbSession.FromSql(cmdPageSql).ToList <Mes_Sys_Employee>());
}
public void LoadCalls(ModuleRequestForMembership module, CallStandardAction action, int idCommunity, CallStatusForSubmitters view, int pageIndex, int pageSize)
{
Boolean fromAllcommunities = false;
PagerBase pager = new PagerBase();
pager.PageSize = pageSize;
if (action == CallStandardAction.Manage)
{
pager.Count = (int)Service.CallCount((idCommunity == 0), idCommunity, UserContext.CurrentUserID, CallForPaperType.RequestForMembership, view, View.CurrentFilter) - 1;
}
else
{
fromAllcommunities = (idCommunity == 0) && (view == CallStatusForSubmitters.SubmissionOpened || view == CallStatusForSubmitters.Submitted || view == CallStatusForSubmitters.ToEvaluate || view == CallStatusForSubmitters.Evaluated);
pager.Count = (int)Service.CallCountBySubmission(false, fromAllcommunities, (idCommunity == 0), idCommunity, UserContext.CurrentUserID, view) - 1;
}
pager.PageIndex = pageIndex;// Me.View.CurrentPageIndex
View.Pager = pager;
if (pager.Count < 0)
{
View.LoadCalls(new List <dtoRequestItemPermission>());
}
else
{
View.LoadCalls(Service.GetRequests(module, action, fromAllcommunities, (idCommunity == 0), idCommunity, UserContext.CurrentUserID, view, View.CurrentFilter, pager.PageIndex, pageSize));
}
}
private void InternalTemplates(dtoModuleContext context, dtoBaseFilters filters, int pageIndex, int pageSize)
{
List <dtoDisplayTemplateDefinition> items = Service.GetTemplates(context, filters, View.UnknownUserName, UserContext.CurrentUserID, UserContext.Language.Id);
PagerBase pager = new PagerBase();
pager.PageSize = pageSize;
if (pageSize == 0)
{
pageSize = 50;
}
pager.Count = (items == null)? -1 : (int)items.Count - 1;
pager.PageIndex = pageIndex;// Me.View.CurrentPageIndex
View.Pager = pager;
View.CurrentOrderBy = filters.OrderBy;
//View.CurrentFilterBy = filters.Status;
View.CurrentAscending = filters.Ascending;
View.CurrentPageSize = pageSize;
if (pager.Count < 0)
{
View.LoadNoTemplatesFound();
}
else
{
View.LoadTemplates(items.Skip(pageIndex * pageSize).Take(pageSize).ToList());
}
if (View.SendTemplateActions)
{
View.SendUserAction(context.IdCommunity, context.IdModule, ModuleTemplateMessages.ActionType.ListTemplates);
}
}
public void LoadCalls(int idCommunity, int pageIndex, int pageSize)
{
Int32 idUser = UserContext.CurrentUserID;
litePerson person = GetCurrentUser(ref idUser);
Boolean fromAllcommunities = false;
PagerBase pager = new PagerBase();
pager.PageSize = pageSize;
fromAllcommunities = (idCommunity == 0);
pager.Count = (int)Service.PublicCallCount(false, fromAllcommunities, (idCommunity == 0), idCommunity, CallStatusForSubmitters.SubmissionOpened) - 1;
pager.PageIndex = pageIndex;// Me.View.CurrentPageIndex
View.Pager = pager;
if (pager.Count < 0)
{
View.LoadCalls(new List <dtoRequestItemPermission>());
}
else
{
ModuleRequestForMembership module = Service.RequestForMembershipServicePermission(idUser, idCommunity);
View.LoadCalls(Service.GetRequests(module, CallStandardAction.List, fromAllcommunities, (idCommunity == 0), idCommunity, idUser, CallStatusForSubmitters.SubmissionOpened, FilterCallVisibility.OnlyVisible, pager.PageIndex, pageSize));
}
}
public void LoadCommunities(DashboardViewType view, UserCurrentSettings userSettings, Int32 pageIndex, Int32 pageSize, OrderItemsBy orderBy, Boolean ascending, Int32 idCommunityType = -1, Int32 idRemoveCommunityType = -1, long idTile = -1, long idTag = -1, dtoTileDisplay tile = null)
{
if (UserContext.isAnonymous)
{
View.DisplaySessionTimeout();
}
else
{
if (View.DisplayLessCommand)
{
Int32 itemsCount = Service.GetSubscribedCommunitiesCount(UserContext.CurrentUserID, view, idCommunityType, idRemoveCommunityType, idTile, idTag, tile);
PagerBase pager = new PagerBase();
pager.PageSize = pageSize; //Me.View.CurrentPageSize
pager.Count = (itemsCount > 0) ? itemsCount - 1 : 0;
pager.PageIndex = pageIndex; // Me.View.CurrentPageIndex
View.Pager = pager;
}
List <dtoSubscriptionItem> items = Service.GetSubscribedCommunities(UserContext.CurrentUserID, view, pageIndex, pageSize, orderBy, ascending, idCommunityType, idRemoveCommunityType, idTile, idTag, tile);
if (items != null)
{
List <Int32> withNews = View.GetIdcommunitiesWithNews(items.Where(i => i.Status != SubscriptionStatus.communityblocked && i.Status != SubscriptionStatus.blocked && i.Status != SubscriptionStatus.waiting).Select(i => i.Community.Id).ToList(), UserContext.CurrentUserID);
if (withNews.Any())
{
items.Where(i => withNews.Contains(i.Community.Id)).ToList().ForEach(i => i.HasNews = true);
}
switch (view)
{
case DashboardViewType.List:
case DashboardViewType.Combined:
Language l = CurrentManager.GetDefaultLanguage();
Dictionary <Int32, List <String> > tags = ServiceTags.GetCommunityAssociationToString(items.Select(i => i.Community.Id).ToList(), UserContext.Language.Id, l.Id, true);
if (tags.Any())
{
foreach (dtoSubscriptionItem item in items.Where(i => tags.ContainsKey(i.Community.Id)))
{
item.Community.Tags = tags[item.Community.Id];
}
}
break;
}
View.LoadItems(items, orderBy, ascending);
if (userSettings != null)
{
userSettings.Ascending = ascending;
userSettings.OrderBy = orderBy;
userSettings.View = view;
View.UpdateUserSettings(userSettings);
}
//View.SendUserAction(0, CurrentIdModule, ModuleDashboard.ActionType.ListDashboardLoadSubscribedCommunities);
}
else
{
View.DisplayErrorFromDB();
}
}
}
/// <summary>
/// Inizializza View (PageLoad)
/// </summary>
public void InitView(int currentPageIndex, int currentPageSize)
{
//View.ShowUpdateRoomRecording = false;
if (UserContext.isAnonymous)
{
this.SendUserAction(Domain.ModuleWebConferencing.ActionType.NoUser);
View.DisplaySessionTimeout();
}
else if (!ServerStatus())
{
this.SendUserAction(Domain.ModuleWebConferencing.ActionType.NoServer);
View.ShowErrorOnPage(Domain.ErrorListMessage.NoServer, true);
}
else
{
if (true) //Permessi: OK così. S'arrangia a recuperarsi le stanze corrette e mostrare o meno l'edit, etc...
{
int PageCount = 0;
IList <Domain.WbRoom> Rooms = Service.RoomsGet(Module.ManageRoom, CurrentCommunityId, UserContext.CurrentUserID, View.Filters, currentPageIndex, currentPageSize, ref PageCount);
PagerBase pager = new PagerBase();
pager.PageSize = currentPageSize; //Me.View.CurrentPageSize
pager.Count = PageCount;
pager.PageIndex = currentPageIndex; // Me.View.CurrentPageIndex
View.Pager = pager;
Boolean CanAdd = (Module.AddChatRoom || Module.ManageRoom);
Boolean CanModify = (Module.ManageRoom);
Int32 CurrentUserId = UserContext.CurrentUserID;
this.SendUserAction(Domain.ModuleWebConferencing.ActionType.RoomList);
View.BindList(Rooms, CanAdd, CanModify, CurrentUserId);
//if (Rooms != null && Rooms.Count > 0)
//{
// View.BindList(Rooms, CanAdd, CanModify, CurrentUserId);
//}
//else
//{
// View.BindList(null, CanAdd, CanModify, CurrentUserId);
// this.SendUserAction(Domain.ModuleWebConferencing.ActionType.RoomList);
// View.ShowErrorOnPage(Domain.ErrorListMessage.NoItem, false);
//}
}
else
{
this.SendUserAction(Domain.ModuleWebConferencing.ActionType.NoPermission);
View.ShowErrorOnPage(Domain.ErrorListMessage.NoPermission, true);
}
if (UserContext.CurrentUser.TypeID == 0)
{
}
}
}
private void LoadItems(long idCall, EvaluationType type, Int32 idCommunity, List <dtoCommittee> committees, dtoEvaluationsFilters filters, int pageIndex, int pageSize)
{
if (type == EvaluationType.Dss)
{
InitializeDssInfo(idCall);
}
else
{
View.HideDssWarning();
}
List <dtoCommitteesSummaryItem> items = Service.GetCommitteesSummary(idCall, type, filters, View.AnonymousDisplayname, View.UnknownDisplayname, committees);
PagerBase pager = new PagerBase();
pager.PageSize = pageSize;
if (pageSize == 0)
{
pageSize = 50;
}
pager.Count = (int)items.Count - 1;
pager.PageIndex = pageIndex;// Me.View.CurrentPageIndex
View.Pager = pager;
View.CurrentOrderBy = filters.OrderBy;
View.CurrentFilterBy = filters.Status;
View.CurrentAscending = filters.Ascending;
View.PageSize = pageSize;
//if (pageSize == 0)
// pageSize = 50;
//int itemsCount = (int)items.Count-1;
//if (itemsCount > 0)
//{
// while (!items.Skip(pageIndex * pageSize).Take(pageSize).Any())
// {
// pageIndex -= 1;
// }
// View.CurrentPageIndex = pageIndex;
//}
//View.CurrentOrderBy = filters.OrderBy;
//View.CurrentFilterBy = filters.Status;
//View.CurrentAscending = filters.Ascending;
//View.PageSize = pageSize;
View.AllowExportCurrent = (items != null && items.Any() && items.Skip(pageIndex * pageSize).Take(pageSize).Any());
//!(itemsCount < 0);
if (pager.Count < 0)
{
View.DisplayNoEvaluationsFound();
}
else
{
View.LoadEvaluations(committees, items.Skip(pageIndex * pageSize).Take(pageSize).ToList());
}
View.SendUserAction(View.IdCallCommunity, View.IdCallModule, ModuleCallForPaper.ActionType.ViewEvaluationsSummary);
}
public ActionResult WorkShop_FindByPage(Mes_Sys_WorkShop obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesSysWorkShopDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }));
}
public ActionResult TraInStock_FindByPage(Mes_Tra_InStock obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesTraInStockDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }));
}
public ActionResult DeviceOutRecord_FindByPage(Mes_Tec_DeviceOutRecord obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesTecDeviceOutRecordDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }));
}
public ActionResult BarcodeInfo_FindByPage(Mes_Tra_SourceBarcode obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = SourceBarcodeDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }));
}
public ActionResult PlanMgt_FindByPage(Mes_Plan_PlanInfor obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesPlanPlanInforDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }, JsonRequestBehavior.AllowGet));
}
public ActionResult ProductInfo_FindByPage(Mes_Tec_ProductInfo obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesTecProductInfoDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }));
}
public ActionResult DeviceInfo_ExpiredDetail(int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = MesTecDeviceInfoDao.Instance.ExpiredDetail(ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }));
}
public ActionResult ProductInStockMgt_FindByPage(Mes_Stock_ProductInStock obj, int page, int rows)
{
var pager = new PagerBase()
{
CurrentPageIndex = page, PageSize = rows
};
var list = StockProductInStockDao.Instance.FindByPage(obj, ref pager);
return(Json(new { total = pager.TotalItemCount, rows = list }, JsonRequestBehavior.AllowGet));
}