/// <summary> /// Adds the orders. /// </summary> /// <param name="criteria">The criteria.</param> /// <param name="orders">The orders.</param> /// <returns>A <see cref="DetachedCriteria"/></returns> public static DetachedCriteria AddOrders(this DetachedCriteria criteria, IEnumerable <Order> orders) { foreach (var order in orders) { criteria.AddOrder(order); } return(criteria); }
public static DetachedCriteria ConverToCriteria(EntityOrderby[] orderbyField, Dictionary <string, string> orderbyFiledsMapping, DetachedCriteria criteria) { foreach (EntityOrderby orderby in orderbyField) { if (orderbyFiledsMapping.ContainsKey(orderby.orderbyField)) { if (orderby.asc) { criteria.AddOrder(Order.Asc(orderbyFiledsMapping[orderby.orderbyField])); } else { criteria.AddOrder(Order.Desc(orderbyFiledsMapping[orderby.orderbyField])); } } } return(criteria); }
/// <summary> /// Lista todas as areas da instituicao. /// </summary> /// <returns> /// A <see cref="Area"/> /// </returns> public virtual Area[] ListarAreas() { DetachedCriteria dc = DetachedCriteria.For(typeof(Area)); dc.Add(Expression.Eq("Instituicao.Id", this.Id)); dc.AddOrder(Order.Asc("Descricao")); return(Area.FindAll(dc)); }
public static Atividade[] ListarTiposDeAndamento() { DetachedCriteria dc = DetachedCriteria.For(typeof(Atividade)); dc.Add(Expression.Eq("TipoAndamento", true)); dc.AddOrder(Order.Asc("Descricao")); return(Atividade.FindAll(dc)); }
public UnidadeExercicioFuncaoPessoa[] getUEFPporPessoa(int idPessoa) { DetachedCriteria dc = DetachedCriteria.For(typeof(UnidadeExercicioFuncaoPessoa)); dc.Add(Expression.Eq("Pessoa.Id", idPessoa)); dc.Add(Expression.Eq("DataFim", Convert.ToDateTime("01/01/0001 00:00:00"))); dc.AddOrder(Order.Asc("DataInicio")); return(UnidadeExercicioFuncaoPessoa.FindAll(dc)); }
public MrpRunLog GetLastestMrpRunLog(DateTime effectiveDate) { DetachedCriteria criteria = DetachedCriteria.For <MrpRunLog>(); criteria.Add(Expression.Lt("RunDate", effectiveDate)); criteria.AddOrder(Order.Desc("RunDate")); criteria.AddOrder(Order.Desc("Id")); IList <MrpRunLog> list = this.criteriaMgr.FindAll <MrpRunLog>(criteria, 0, 1); if (list != null && list.Count > 0) { return(list[0]); } else { return(null); } }
public static Pessoa[] Pesquisar(bool pessoaFisica, string nome, string cpfCnpj) { DetachedCriteria dc = DetachedCriteria.For(typeof(Pessoa)); dc.AddOrder(Order.Asc("Nome")); dc.Add(Expression.Eq("PessoaFisica", pessoaFisica)); dc.Add(Expression.InsensitiveLike("Nome", "%" + nome + "%")); dc.Add(Expression.InsensitiveLike("CpfCnpj", "%" + cpfCnpj + "%")); return(Pessoa.FindAll(dc)); }
public ProcessoAndamento[] listarAndamentosProcesso(int idPai) { DetachedCriteria dc = DetachedCriteria.For(typeof(ProcessoAndamento)); dc.AddOrder(Order.Asc("DataCadastro")); dc.Add(Expression.Eq("Processo.Id", idPai)); dc.Add(Expression.IsNull("AndamentoCorrigido")); return(ProcessoAndamento.FindAll(dc)); }
public IList <ItemFlowPlanDetail> GetActiveItemFlowPlanDetailListSort(int itemFlowPlanId) { DetachedCriteria criteria = DetachedCriteria.For(typeof(ItemFlowPlanDetail)); criteria.Add(Expression.Eq("ItemFlowPlan.Id", itemFlowPlanId)); criteria.Add(Expression.Ge("ReqDate", DateTime.Now.Date)); criteria.AddOrder(Order.Asc("ReqDate")); return(CriteriaMgr.FindAll <ItemFlowPlanDetail>(criteria)); }
/// <summary> /// Adds sorting to the DetachedCriteria based on the given parameters. /// </summary> /// <param name="criteria"></param> /// <param name="contentItemSortBy"></param> /// <param name="contentItemSortDirection"></param> /// <returns></returns> public static DetachedCriteria ApplyOrdering(this DetachedCriteria criteria, ContentItemSortBy contentItemSortBy, ContentItemSortDirection contentItemSortDirection) { DetachedCriteria orderedCriteria = criteria; if (contentItemSortDirection != ContentItemSortDirection.None) { switch (contentItemSortDirection) { case ContentItemSortDirection.ASC: orderedCriteria = criteria.AddOrder(Order.Asc(contentItemSortBy.ToString())); break; case ContentItemSortDirection.DESC: orderedCriteria = criteria.AddOrder(Order.Desc(contentItemSortBy.ToString())); break; } } return(orderedCriteria); }
public static Atividade[] listarAtividadesAndamentos() { DetachedCriteria pesquisa = DetachedCriteria.For(typeof(Atividade)); pesquisa.Add(Expression.Eq("TipoAndamento", true)); pesquisa.Add(Expression.Eq("TipoAndamentoVisivel", true)); pesquisa.AddOrder(Order.Asc("Descricao")); return(Atividade.FindAll(pesquisa)); }
public UnidadeExercicio[] listarUnidades() { DetachedCriteria pesqExercicio = DetachedCriteria.For(typeof(UnidadeExercicio)); pesqExercicio.Add(Expression.Eq("Area.Id", 12)); pesqExercicio.Add(Expression.IsNull("UnidadeExercicioPai")); pesqExercicio.AddOrder(Order.Asc("Descricao")); return(UnidadeExercicio.FindAll(pesqExercicio)); }
public static List <Pessoa> ListarPessoasDaSubUnidade(int idSubUnidade) { DetachedCriteria dc = DetachedCriteria.For(typeof(UnidadeExercicioFuncaoPessoa)); dc.CreateAlias("UnidadeExercicioFuncao", "sue"); dc.Add(Expression.Eq("sue.UnidadeExercicio.Id", idSubUnidade)); dc.Add(Expression.Sql(" dat_fim_efp = '-infinity' or dat_fim_efp is null ")); dc.AddOrder(Order.Asc("sue.UnidadeExercicio")); dc.CreateAlias("Pessoa", "pes"); dc.AddOrder(Order.Asc("pes.Nome")); UnidadeExercicioFuncaoPessoa[] uefp = UnidadeExercicioFuncaoPessoa.FindAll(dc); List <Pessoa> pessoasDaSubUnidade = new List <Pessoa>(); for (int i = 0; i < uefp.Length; i++) { pessoasDaSubUnidade.Add(uefp[i].Pessoa); } return(pessoasDaSubUnidade); }
public AtividadePessoaPermissao[] listarPessoasAtividade(int atividade) { DetachedCriteria dcPermissaoPessoa = DetachedCriteria.For(typeof(AtividadePessoaPermissao)); dcPermissaoPessoa.CreateAlias("Atividade", "at"); dcPermissaoPessoa.Add(Expression.Eq("Atividade.Id", atividade)); dcPermissaoPessoa.AddOrder(Order.Asc("at.Descricao")); return(AtividadePessoaPermissao.FindAll(dcPermissaoPessoa)); }
// // GET: /Outcome/ public ActionResult List() { DetachedCriteria criteria = DetachedCriteria.For(typeof(Outcome)); criteria.AddOrder(Order.Asc("Date")); var outcomes = daoTemplate.FindByCriteria <Outcome>(criteria); IEnumerable <OutcomeListItemViewModel> viewModels = outcomes.Select(income => new OutcomeListItemViewModel(income)); return(View(viewModels)); }
public static UnidadeExercicio[] ListarSubUnidadesExercicio(int idUnidadePai) { DetachedCriteria pesquisa = DetachedCriteria.For(typeof(UnidadeExercicio)); pesquisa.Add(Expression.Sql(" dat_fim_uex = '-infinity' or dat_fim_uex is null ")); pesquisa.CreateAlias("UnidadeExercicioPai", "UnExPai"); pesquisa.Add(Expression.Eq("UnExPai.Id", idUnidadePai)); pesquisa.AddOrder(Order.Asc("Descricao")); return(UnidadeExercicio.FindAll(pesquisa)); }
public IList <OrderHead> GetOrderHead(string status) { DetachedCriteria criteria = DetachedCriteria.For(typeof(OrderHead)); criteria.AddOrder(Order.Desc("CreateDate")); if (status != null && status != string.Empty) { criteria.Add(Expression.Eq("Status", status)); } return(criteriaMgr.FindAll <OrderHead>(criteria)); }
public IList <ShiftDetail> GetShiftDetail(string shiftCode, DateTime date) { DetachedCriteria criteria = DetachedCriteria.For(typeof(ShiftDetail)); criteria.Add(Expression.Eq("Shift.Code", shiftCode)); criteria.Add(Expression.Or(Expression.Le("StartDate", date), Expression.IsNull("StartDate"))); criteria.Add(Expression.Or(Expression.Ge("EndDate", date), Expression.IsNull("EndDate"))); criteria.AddOrder(Order.Desc("StartDate")); return(criteriaMgr.FindAll <ShiftDetail>(criteria)); }
public IList <DssImportHistory> GetActiveDssImportHistory(int dssInboundCtrlId) { DetachedCriteria criteria = DetachedCriteria.For(typeof(DssImportHistory)); criteria.Add(Expression.Eq("IsActive", true)); criteria.Add(Expression.Eq("DssInboundCtrl.Id", dssInboundCtrlId)); criteria.Add(Expression.Lt("ErrorCount", 10));//2012-6-12 djin 3变1//2012-10-25 1->2 criteria.AddOrder(Order.Asc("Id")); return(criteriaMgr.FindAll <DssImportHistory>(criteria)); }
public IList <ProductLineInProcessLocationDetail> GetProductLineInProcessLocationDetail(string prodLineCode, string status) { DetachedCriteria criteria = DetachedCriteria.For <ProductLineInProcessLocationDetail>(); criteria.Add(Expression.Eq("ProductLine.Code", prodLineCode)); criteria.Add(Expression.Eq("Status", status)); criteria.AddOrder(Order.Asc("Id")); return(this.criteriaMgr.FindAll <ProductLineInProcessLocationDetail>(criteria)); }
protected void SetOrder(DetachedCriteria criteria, SortParam param) { if (string.IsNullOrWhiteSpace(param.Field)) { return; } criteria .AddOrder(param.Direction == ListSortDirection.Ascending ? Order.Asc(param.Field) : Order.Desc(param.Field)); }
public Frase[] listarFrases(string descricao) { DetachedCriteria dc = DetachedCriteria.For(typeof(Frase)); dc.AddOrder(Order.Asc("Descricao")); if (!string.IsNullOrEmpty(descricao)) { dc.Add(Expression.InsensitiveLike("Descricao", "%" + descricao + "%")); } return(Frase.FindAll(dc)); }
/// <summary> /// 지정된 Criteria에 Ordering 을 추가합니다. /// </summary> /// <param name="dc"></param> /// <param name="orders"></param> /// <returns></returns> public static DetachedCriteria AddOrders(this DetachedCriteria dc, params Order[] orders) { if (orders != null) { foreach (var order in orders) { dc = dc.AddOrder(order); } } return(dc); }
/// <summary> /// 取得訊息清單 /// </summary> /// <param name="createName">留言者姓名</param> /// <param name="startDate">起始時間</param> /// <param name="endDate">結束時間</param> /// <param name="pageIndex">分頁索引</param> /// <param name="pageSize">分頁大小</param> /// <param name="sortField">排序欄位</param> /// <param name="sortDesc">升降冪排序</param> /// <returns>訊息清單</returns> public IList <MessageVO> GetMessageList(string createName, DateTime?startDate, DateTime?endDate , int pageIndex, int pageSize, string sortField, bool sortDesc) { DetachedCriteria dCriteria = DetachedCriteria.For <MessageVO>(); if (!string.IsNullOrEmpty(createName)) { dCriteria.Add(Expression.Like("CreateName", createName, MatchMode.Anywhere)); } if (startDate != null) { dCriteria.Add(Expression.Ge("CreatedDate", startDate)); } if (endDate != null) { dCriteria.Add(Expression.Le("CreatedDate", endDate)); } if (!string.IsNullOrEmpty(sortField)) { if (sortDesc) { dCriteria.AddOrder(Order.Desc(sortField)); } else { dCriteria.AddOrder(Order.Asc(sortField)); } } int count = NHibernateDao.CountByDetachedCriteria(dCriteria); if (count == 0) { return(null); } return(NHibernateDao.SearchByDetachedCriteria <MessageVO>(dCriteria, pageIndex, pageSize)); }
/// <summary> /// 取得系統紀錄清單 /// </summary> /// <param name="fucntion">功能</param> /// <param name="startDate">起始時間</param> /// <param name="endDate">結束時間</param> /// <param name="pageIndex">分頁索引</param> /// <param name="pageSize">分頁大小</param> /// <param name="sortField">排序欄位</param> /// <param name="sortDesc">升降冪排序</param> /// <returns>系統紀錄清單</returns> public IList <LogSystemVO> GetLogSystemList(string fucntion, DateTime?startDate, DateTime?endDate , int pageIndex, int pageSize, string sortField, bool sortDesc) { DetachedCriteria dCriteria = DetachedCriteria.For <LogSystemVO>(); if (!string.IsNullOrEmpty(fucntion)) { dCriteria.Add(Expression.Eq("Fucntion", fucntion)); } if (startDate != null) { dCriteria.Add(Expression.Ge("UpdateDate", startDate)); } if (endDate != null) { dCriteria.Add(Expression.Le("UpdateDate", endDate)); } if (!string.IsNullOrEmpty(sortField)) { if (sortDesc) { dCriteria.AddOrder(Order.Desc(sortField)); } else { dCriteria.AddOrder(Order.Asc(sortField)); } } int count = NHibernateDao.CountByDetachedCriteria(dCriteria); if (count == 0) { return(null); } return(NHibernateDao.SearchByDetachedCriteria <LogSystemVO>(dCriteria, pageIndex, pageSize)); }
public ProcessoAndamento[] listarAndamentosProcesso(int idPai, bool corrigido, bool desc) { DetachedCriteria dc = DetachedCriteria.For(typeof(ProcessoAndamento)); if (desc) { dc.AddOrder(Order.Desc("DataCadastro")); } else { dc.AddOrder(Order.Asc("DataCadastro")); } dc.AddOrder(Order.Desc("Id")); dc.Add(Expression.Eq("Processo.Id", idPai)); if (corrigido) { dc.Add(Expression.IsNull("AndamentoCorrigido")); } return(ProcessoAndamento.FindAll(dc)); }
/// <summary> /// 取得Post By 父層ParentPostId /// </summary> /// <param name="parentPostId">父層PostId</param> /// <param name="onlyShow">僅抓取上架</param> /// <param name="showDate">目前顯示的日期</param> /// <param name="sortField">排序欄位</param> /// <param name="sortDesc">升降冪排序</param> /// <returns>Post清單</returns> public IList <PostVO> GetPostListByParentPostId(int parentPostId, bool onlyShow, DateTime?showDate, string sortField, bool sortDesc) { DetachedCriteria dCriteria = DetachedCriteria.For <PostVO>(); dCriteria.CreateCriteria("ParentPost").Add(Expression.Eq("PostId", parentPostId)); dCriteria.Add(Expression.Eq("IsTemp", false)); if (onlyShow) { dCriteria.Add(Expression.Eq("Flag", 1)); } if (showDate != null) { dCriteria.Add(Expression.Le("ShowDate", showDate.Value.Date)); dCriteria.Add(Expression.Ge("CloseDate", showDate)); } if (!string.IsNullOrEmpty(sortField)) { if (sortDesc) { dCriteria.AddOrder(Order.Desc(sortField)); } else { dCriteria.AddOrder(Order.Asc(sortField)); } } int count = NHibernateDao.CountByDetachedCriteria(dCriteria); if (count == 0) { return(null); } return(NHibernateDao.SearchByDetachedCriteria <PostVO>(dCriteria)); }
private static void AddOrdersForPropertyName(DetachedCriteria criteria, string name, bool ascending) { switch (name) { case "PatientIdentifier": criteria.AddOrder(new Order(Projections.Property("p.UniqueIdentifier"), ascending)); break; case "PatientName": criteria.AddOrder(new Order(Projections.Property("p.LastName"), ascending)) .AddOrder(new Order(Projections.Property("p.FirstName"), ascending)); break; case "PatientPrefixName": criteria.AddOrder(new Order(Projections.Property("p.PrefixName"), ascending)); break; case "PatientContactPreference": criteria.AddOrder(new Order(Projections.Property("p.ContactPreference"), ascending)); break; } }
public UnidadeAdministrativa[] getUnidadesAdministrativas(string tipo, string idInstituicao) { DetachedCriteria dc = DetachedCriteria.For(typeof(UnidadeAdministrativa)); dc.CreateAlias("TipoUnidadeAdministrativa", "tua"); dc.CreateAlias("Instituicao", "ins"); if (!string.IsNullOrEmpty(idInstituicao)) { dc.Add(Expression.Eq("Instituicao.Id", Convert.ToInt32(idInstituicao))); } if (!string.IsNullOrEmpty(tipo)) { dc.Add(Expression.Eq("TipoUnidadeAdministrativa.Id", Convert.ToInt32(tipo))); } dc.AddOrder(Order.Asc("ins.Sigla")); dc.AddOrder(Order.Asc("tua.Descricao")); return(UnidadeAdministrativa.FindAll(dc)); }
public IList <TransportationOrder> GetTransportationOrder(string status, bool isValuated) { DetachedCriteria criteria = DetachedCriteria.For(typeof(TransportationOrder)); criteria.AddOrder(Order.Desc("CreateDate")); if (status != null && status != string.Empty) { criteria.Add(Expression.Eq("Status", status)); } criteria.Add(Expression.Eq("IsValuated", isValuated)); return(criteriaMgr.FindAll <TransportationOrder>(criteria)); }