/// <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));
}
