public virtual Summary GetSummary(PaginateResult <Setor> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
});
}
public virtual Summary GetSummary(PaginateResult <OrdemServico> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
});
}
protected virtual IPaginateResult ExecuteResultInternal(IDbExecuteContext ctx, DbCommand command, Type elementType)
{
PaginateResult result;
if (elementType == null)
{
result = new PaginateResult();
}
else
{
var type = typeof(PaginateResult <>);
var instanceType = type.MakeGenericType(elementType);
result = (PaginateResult)TypeHelper.CreateObject(instanceType, null, true);
}
using (var reader = command.ExecuteReader(CommandBehavior.Default)) {
if (reader.Read())
{
result.Count = Convert.ToInt32(reader[0]);
}
var list = new ArrayList();
if (reader.NextResult())
{
while (reader.Read())
{
list.Add(this.ObjectMapper.Mapping(ctx.Statement, reader.ToDictionary(), elementType, null));
}
}
result.Items = elementType != null ? (object[])list.ToArray(elementType) : list.ToArray();
}
return(result);
}
public virtual Summary GetSummary(PaginateResult <TipoPlanoConta> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
});
}
public ActionResult UserRoleList(string userName, string roleNo, int?startIndex)
{
const int pageSize = 20;
var index = startIndex != null ? startIndex.Value : 0;
this.ViewBag.StartIndex = index;
this.ViewBag.PageSize = pageSize;
this.ViewBag.UserName = userName;
this.ViewBag.RoleNo = roleNo;
var items = this.PermissionServer.GetUserGroupRoles();
var list = items.Where(x => x.TargetCategory == 2);
if (!string.IsNullOrEmpty(userName))
{
list = list.Where(x => string.Compare(x.UserName, userName, StringComparison.InvariantCultureIgnoreCase) == 0);
}
if (!string.IsNullOrEmpty(roleNo))
{
list = list.Where(x => string.Compare(x.TargetValue, roleNo, StringComparison.InvariantCultureIgnoreCase) == 0);
}
var count = list.Count();
list = list.OrderByDescending(x => x.ID).Skip(index).Take(pageSize);
var result = new PaginateResult <UserGroupRole> {
Count = count, Items = list.ToArray()
};
return(this.View(result));
}
public ActionResult RoleList(string roleNo, string roleTitle, int?startIndex)
{
const int pageSize = 20;
var index = startIndex != null ? startIndex.Value : 0;
this.ViewBag.StartIndex = index;
this.ViewBag.PageSize = pageSize;
this.ViewBag.RoleNo = roleNo;
this.ViewBag.RoleTitle = roleTitle;
var roles = this.PermissionServer.GetPermissionRoles();
IEnumerable <PermissionRole> list = roles;
if (!string.IsNullOrEmpty(roleNo))
{
list = list.Where(x => x.RoleNo.Contains(roleNo));
}
if (!string.IsNullOrEmpty(roleTitle))
{
list = list.Where(x => x.Title.Contains(roleTitle));
}
var count = list.Count();
list = list.Skip(index).Take(pageSize);
var result = new PaginateResult <PermissionRole> {
Count = count, Items = list.ToArray()
};
return(this.View(result));
}
public virtual Summary GetSummary(PaginateResult <EstoqueMovimentacao> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
});
}
public virtual Summary GetSummary(PaginateResult <UnidadeMedida> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
});
}
private PaginateResult <T> PagingAndSorting <T>(PessoaFilter filter, IQueryable <T> queryBase, Func <PessoaFilter, IQueryable <T>, PaginateResult <T>, PaginateResult <T> > PaginationDefault) where T : class
{
var querySorting = queryBase;
if (filter.IsOrderByDynamic)
{
querySorting = queryBase.OrderByDynamic(filter);
}
var dataList = new PaginateResult <T>
{
ResultPaginatedData = querySorting,
TotalCount = 0
};
if (filter.IsPagination)
{
if (filter.IsOrderByDynamic || filter.IsOrderByDomain)
{
return(dataList = querySorting.PaginateNew(filter));
}
dataList = PaginationDefault(filter, querySorting, dataList);
}
return(dataList);
}
public virtual Summary GetSummary(PaginateResult <CategoriaEstoque> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
});
}
public virtual Summary GetSummary(PaginateResult <NivelAcesso> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
});
}
public virtual Summary GetSummary(PaginateResult <Financeiro> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <ProjetoFluxoTrabalhoStatus> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <TipoDeUsuario> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <Acompanhadores> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <StatusSolicitacaoEstoqueMovimentacao> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <ProjetoDocumento> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <SampleStandart> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <ManySampleType> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <GroupParticipant> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <OrdemServicoInteracao> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <Prioridade> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <Colaborador> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <PendenciaEventos> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <InfraestruturaPop> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <StatusUser> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
public virtual Summary GetSummary(PaginateResult <CodigoVerificacao> paginateResult)
{
return(new Summary
{
Total = paginateResult.TotalCount,
PageSize = paginateResult.PageSize,
});
}
private Common.Models.Summary Summary(IQueryable <Pessoa> queryBase, PaginateResult <Pessoa> dataList)
{
var domainSummary = this.Pessoa.GetSummary(queryBase);
var summary = new Common.Models.Summary
{
Total = dataList.TotalCount,
AdditionalSummary = domainSummary.AdditionalSummary.IsNotNull() ? domainSummary.AdditionalSummary : null
};
return(summary);
}
public static SearchResult <T> ToSearchResult <T>(this PaginateResult <T> paginatedResult)
{
return(new SearchResult <T>()
{
DataList = paginatedResult.ResultPaginatedData,
Summary = new Summary
{
PageSize = paginatedResult.PageSize,
Total = paginatedResult.TotalCount
}
});
}
public override Summary GetSummary(PaginateResult <PendenciaTempos> paginateResult)
{
var result = new TimeSpan(paginateResult.ResultPaginatedData.Sum(_ => _.CalcularDiferencaTimeSheet().Ticks));
return(new Summary
{
Total = paginateResult.TotalCount,
AdditionalSummary = new {
TotalHoras = result.ToString(@"hh\:mm")
}
});
}
