public PagedList <EntityMap> QueryPaged(Func <QueryDescriptor <EntityMap>, QueryDescriptor <EntityMap> > container, Guid solutionId, bool existInSolution)
{
QueryDescriptor <EntityMap> q = container(QueryDescriptorBuilder.Build <EntityMap>());
var datas = _entityMapRepository.QueryPaged(q, Module.Core.ModuleCollection.GetIdentity(DataMappingDefaults.ModuleName), solutionId, existInSolution);
return(datas);
}
public List <Domain.Dependency> Query(Func <QueryDescriptor <Domain.Dependency>, QueryDescriptor <Domain.Dependency> > container)
{
QueryDescriptor <Domain.Dependency> q = container(QueryDescriptorBuilder.Build <Domain.Dependency>());
var datas = _dependencyRepository.Query(q)?.ToList();
return(datas);
}
public virtual List <T> Query(Expression <Func <T, bool> > predicate)
{
QueryDescriptor <T> q = QueryDescriptorBuilder.Build <T>();
q.Where(predicate);
return(_repository.Query(q));
}
/// <summary>
/// 查询一行记录
/// </summary>
/// <param name="id">主键</param>
/// <returns></returns>
public T FindById(object id)
{
//return _repository.FindById(id);
var key = MetaData.TableInfo.TableName + ".FindById";
ExecuteContext <TImpl> ctx;
//缓存执行语句
if (PocoExecuteContainer.TryGetValue(key, out object value))
{
ctx = new ExecuteContext <TImpl>();
Sql s = value as Sql;
s.Arguments[0] = id;
ctx.ExecuteContainer = s;
}
else
{
QueryDescriptor <T> q = QueryDescriptorBuilder.Build <T>();
q.QueryText = PocoHelper.FormatColumn(this.MetaData, this.MetaData.TableInfo.PrimaryKey) + "=@0";
q.Parameters.Add(new QueryParameter("@0", id));
ctx = PocoHelper.ParseContext <T, TImpl>(MetaData, q);
PocoExecuteContainer[key] = ctx.ExecuteContainer;
}
var result = _repository.Single(ctx);
return(result);
}
/// <summary>
/// 是否存在记录
/// </summary>
/// <param name="predicate">过滤条件</param>
/// <returns></returns>
public bool Exists(Expression <Func <T, bool> > predicate)
{
QueryDescriptor <T> q = QueryDescriptorBuilder.Build <T>();
q.Where(predicate);
return(Exists(q));
}
public PagedList <AttributeMap> QueryPaged(Func <QueryDescriptor <AttributeMap>, QueryDescriptor <AttributeMap> > container)
{
QueryDescriptor <AttributeMap> q = container(QueryDescriptorBuilder.Build <AttributeMap>());
var datas = _attributeMapRepository.QueryPaged(q);
return(datas);
}
/// <summary>
/// 查询一行记录
/// </summary>
/// <param name="id">主键</param>
/// <returns></returns>
public T FindById(object id)
{
//return _repository.FindById(id);
var key = MetaData.TableInfo.TableName + ".FindById";
ExecuteContext <T> ctx;
//缓存执行语句
//if (PocoExecuteContainer.TryGetValue(key, out object value))
//{
// ctx = new ExecuteContext<T>();
// Sql s = value as Sql;
// s.Arguments[0] = id;
// ctx.ExecuteContainer = s;
//}
//else
//{
QueryDescriptor <T> q = QueryDescriptorBuilder.Build <T>();
q.QueryText = "[" + this.MetaData.TableInfo.TableName + "]." + this.MetaData.TableInfo.PrimaryKey + "=@0";
q.Parameters.Add(new QueryParameter("@0", id));
ctx = PocoHelper.ParseContext <T>(MetaData, q);
// PocoExecuteContainer[key] = ctx.ExecuteContainer;
//}
var result = _repository.Single(ctx);
return(result);
}
public List <SystemFormStateRule> Query(Func <QueryDescriptor <SystemFormStateRule>, QueryDescriptor <SystemFormStateRule> > container)
{
QueryDescriptor <SystemFormStateRule> q = container(QueryDescriptorBuilder.Build <SystemFormStateRule>());
var datas = _systemFormStateRuleRepository.Query(q)?.ToList();
return(datas);
}
public PagedList <FilterRule> QueryPaged(Func <QueryDescriptor <FilterRule>, QueryDescriptor <FilterRule> > container, Guid solutionId, bool existInSolution)
{
QueryDescriptor <FilterRule> q = container(QueryDescriptorBuilder.Build <FilterRule>());
var datas = _filterRuleRepository.QueryPaged(q, Module.Core.ModuleCollection.GetIdentity(FilterRuleDefaults.ModuleName), solutionId, existInSolution);
return(datas);
}
public List <EntityMap> Query(Func <QueryDescriptor <EntityMap>, QueryDescriptor <EntityMap> > container)
{
QueryDescriptor <EntityMap> q = container(QueryDescriptorBuilder.Build <EntityMap>());
var datas = _entityMapRepository.Query(q)?.ToList();
return(datas);
}
public List <WorkFlow> Query(Func <QueryDescriptor <WorkFlow>, QueryDescriptor <WorkFlow> > container)
{
QueryDescriptor <WorkFlow> q = container(QueryDescriptorBuilder.Build <WorkFlow>());
var datas = _workFlowRepository.Query(q)?.ToList();
WrapLocalizedLabel(datas);
return(datas);
}
public List <Domain.RibbonButton> Query(Func <QueryDescriptor <Domain.RibbonButton>, QueryDescriptor <Domain.RibbonButton> > container)
{
QueryDescriptor <Domain.RibbonButton> q = container(QueryDescriptorBuilder.Build <Domain.RibbonButton>());
var datas = _ribbonButtonRepository.Query(q)?.ToList();
WrapLocalizedLabel(datas);
return(datas);
}
public List <Privilege> Query(Func <QueryDescriptor <Privilege>, QueryDescriptor <Privilege> > container)
{
QueryDescriptor <Privilege> q = container(QueryDescriptorBuilder.Build <Privilege>());
var datas = _privilegeRepository.Query(q)?.ToList();
WrapLocalizedLabel(datas);
return(datas);
}
public List <Domain.StringMap> Query(Func <QueryDescriptor <Domain.StringMap>, QueryDescriptor <Domain.StringMap> > container)
{
QueryDescriptor <Domain.StringMap> q = container(QueryDescriptorBuilder.Build <Domain.StringMap>());
var datas = _stringMapRepository.Query(q)?.ToList();
WrapLocalizedLabel(datas);
return(datas);
}
public List <Domain.SerialNumberRule> Query(Func <QueryDescriptor <Domain.SerialNumberRule>, QueryDescriptor <Domain.SerialNumberRule> > container)
{
QueryDescriptor <Domain.SerialNumberRule> q = container(QueryDescriptorBuilder.Build <Domain.SerialNumberRule>());
var datas = _serialNumberRuleRepository.Query(q)?.ToList();
WrapLocalizedLabel(datas);
return(datas);
}
public PagedList <Domain.SerialNumberRule> QueryPaged(Func <QueryDescriptor <Domain.SerialNumberRule>, QueryDescriptor <Domain.SerialNumberRule> > container, Guid solutionId, bool existInSolution)
{
QueryDescriptor <Domain.SerialNumberRule> q = container(QueryDescriptorBuilder.Build <Domain.SerialNumberRule>());
var datas = _serialNumberRuleRepository.QueryPaged(q, Module.Core.ModuleCollection.GetIdentity(SerialNumberRuleDefaults.ModuleName), solutionId, existInSolution);
WrapLocalizedLabel(datas.Items);
return(datas);
}
public PagedList <Chart> QueryPaged(Func <QueryDescriptor <Chart>, QueryDescriptor <Chart> > container, Guid solutionId, bool existInSolution)
{
QueryDescriptor <Chart> q = container(QueryDescriptorBuilder.Build <Chart>());
var datas = _chartRepository.QueryPaged(q, Module.Core.ModuleCollection.GetIdentity(ChartDefaults.ModuleName), solutionId, existInSolution);
WrapLocalizedLabel(datas.Items);
return(datas);
}
public List <Chart> Query(Func <QueryDescriptor <Chart>, QueryDescriptor <Chart> > container)
{
QueryDescriptor <Chart> q = container(QueryDescriptorBuilder.Build <Chart>());
var datas = _chartRepository.Query(q)?.ToList();
WrapLocalizedLabel(datas);
return(datas);
}
public PagedList <Domain.QueryView> QueryPaged(Func <QueryDescriptor <Domain.QueryView>, QueryDescriptor <Domain.QueryView> > container, Guid solutionId, bool existInSolution)
{
QueryDescriptor <Domain.QueryView> q = container(QueryDescriptorBuilder.Build <Domain.QueryView>());
var datas = _queryViewRepository.QueryPaged(q, ModuleCollection.GetIdentity(QueryViewDefaults.ModuleName), solutionId, existInSolution);
WrapLocalizedLabel(datas.Items);
return(datas);
}
public List <Domain.Entity> Query(Func <QueryDescriptor <Domain.Entity>, QueryDescriptor <Domain.Entity> > container)
{
QueryDescriptor <Domain.Entity> q = container(QueryDescriptorBuilder.Build <Domain.Entity>());
var datas = _entityRepository.Query(q).ToList();
WrapLocalizedLabel(datas);
return(datas);
}
public List <Domain.OptionSetDetail> Query(Func <QueryDescriptor <Domain.OptionSetDetail>, QueryDescriptor <Domain.OptionSetDetail> > container)
{
QueryDescriptor <Domain.OptionSetDetail> q = container(QueryDescriptorBuilder.Build <Domain.OptionSetDetail>());
var datas = _optionSetDetailRepository.Query(q).ToList();
WrapLocalizedLabel(datas);
return(datas);
}
public PagedList <Domain.QueryView> QueryPaged(Func <QueryDescriptor <Domain.QueryView>, QueryDescriptor <Domain.QueryView> > container)
{
QueryDescriptor <Domain.QueryView> q = container(QueryDescriptorBuilder.Build <Domain.QueryView>());
var datas = _queryViewRepository.QueryPaged(q);
WrapLocalizedLabel(datas.Items);
return(datas);
}
public PagedList <Domain.OptionSet> QueryPaged(Func <QueryDescriptor <Domain.OptionSet>, QueryDescriptor <Domain.OptionSet> > container)
{
QueryDescriptor <Domain.OptionSet> q = container(QueryDescriptorBuilder.Build <Domain.OptionSet>());
var datas = _optionSetRepository.QueryPaged(q);
WrapLocalizedLabel(datas.Items);
return(datas);
}
public List <Domain.RelationShip> Query(Func <QueryDescriptor <Domain.RelationShip>, QueryDescriptor <Domain.RelationShip> > container)
{
QueryDescriptor <Domain.RelationShip> q = container(QueryDescriptorBuilder.Build <Domain.RelationShip>());
var datas = _relationShipRepository.Query(q)?.ToList();
//WrapLocalizedLabel(datas);
return(datas);
}
public PagedList <Domain.SystemForm> QueryPaged(Func <QueryDescriptor <Domain.SystemForm>, QueryDescriptor <Domain.SystemForm> > container, Guid solutionId, bool existInSolution, FormType formType)
{
QueryDescriptor <Domain.SystemForm> q = container(QueryDescriptorBuilder.Build <Domain.SystemForm>());
var datas = _systemFormRepository.QueryPaged(q, ModuleCollection.GetIdentity(formType == FormType.Dashboard ? DashBoardDefaults.ModuleName : FormDefaults.ModuleName), solutionId, existInSolution);
WrapLocalizedLabel(datas.Items);
return(datas);
}
public PagedList <Domain.SystemForm> QueryPaged(Func <QueryDescriptor <Domain.SystemForm>, QueryDescriptor <Domain.SystemForm> > container)
{
QueryDescriptor <Domain.SystemForm> q = container(QueryDescriptorBuilder.Build <Domain.SystemForm>());
var datas = _systemFormRepository.QueryPaged(q);
WrapLocalizedLabel(datas.Items);
return(datas);
}
public List <Domain.WebResource> Query(Func <QueryDescriptor <Domain.WebResource>, QueryDescriptor <Domain.WebResource> > container)
{
QueryDescriptor <Domain.WebResource> q = container(QueryDescriptorBuilder.Build <Domain.WebResource>());
var datas = _webResourceRepository.Query(q)?.ToList();
WrapLocalizedLabel(datas);
return(datas);
}
public PagedList <SolutionComponent> QueryPaged(int page, int pageSize, Guid solutionId, string componentTypeName)
{
var identity = ModuleCollection.GetIdentity(componentTypeName);
var q = QueryDescriptorBuilder.Build <SolutionComponent>();
q.Where(x => x.SolutionId == solutionId && x.ComponentType == identity);
q.Page(page, pageSize);
return(_solutionComponentRepository.QueryPaged(q));
}
public PagedList <DuplicateRule> QueryPaged(Func <QueryDescriptor <DuplicateRule>, QueryDescriptor <DuplicateRule> > container)
{
QueryDescriptor <DuplicateRule> q = container(QueryDescriptorBuilder.Build <DuplicateRule>());
var datas = _duplicateRuleRepository.QueryPaged(q);
WrapLocalizedLabel(datas.Items);
return(datas);
}
public PagedList <Domain.VisitedLog> Query(Func <QueryDescriptor <Domain.VisitedLog>, QueryDescriptor <Domain.VisitedLog> > container)
{
if (_AppLogRepository == null)
{
return(null);
}
QueryDescriptor <Domain.VisitedLog> q = container(QueryDescriptorBuilder.Build <Domain.VisitedLog>());
return(_AppLogRepository.QueryPaged(q));
}