public static string DataMarcacao(int idProcesso) { string[] andamentosAgenda = { "LICITAÇÃO MARCADA", "DISPUTA", "SESSÃO FINAL", "SESSÃO DE RESULTADO - HABILITAÇÃO", "SESSÃO DE RESULTADO - PROPOSTA COMERCIAL", "SESSÃO DE ABERTURA - PROPOSTA COMERCIAL", "SESSÃO DE ABERTURA - PROPOSTA TÉCNICA", "SESSÃO DE RESULTADO - PROPOSTA TÉCNICA" }; DetachedCriteria dc = DetachedCriteria.For(typeof(ProcessoAndamento)); dc.Add(Expression.Eq("Processo.Id", idProcesso)); dc.Add(Expression.IsNull("AndamentoCorrigido")); dc.Add(Expression.IsNull("AndamentoAdiado")); dc.CreateAlias("FluxoAndamento", "fan"); dc.CreateAlias("fan.Atividade", "ati"); dc.Add(Expression.In("ati.Descricao", andamentosAgenda)); dc.Add(Expression.Sql(" this_.dat_andamento_pan >= '" + DateTime.Now + "' order by this_.dat_andamento_pan desc ")); ProcessoAndamento andamento = ProcessoAndamento.FindFirst(dc); string retorno = string.Empty; if (andamento != null && Utilidade.UtdValidador.ValidarData(Convert.ToString(andamento.DataAndamento))) { retorno = andamento.DataAndamento.ToString("dd/MM/yyyy"); } return(retorno); }
public IList <InProcessLocationDetail> GetInProcessLocationDetailOut(IList <string> itemList, IList <string> locList) { DetachedCriteria criteria = DetachedCriteria.For(typeof(InProcessLocationDetail)); criteria.CreateAlias("InProcessLocation", "ip"); criteria.Add(Expression.Eq("ip.Status", BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE)); criteria.Add(Expression.Eq("ip.Type", BusinessConstants.CODE_MASTER_INPROCESS_LOCATION_TYPE_VALUE_NORMAL)); criteria.CreateAlias("OrderLocationTransaction", "olt"); if (itemList.Count == 1) { criteria.Add(Expression.Eq("olt.Item.Code", itemList[0])); } else { criteria.Add(Expression.InG <string>("olt.Item.Code", itemList)); } if (locList.Count == 1) { criteria.Add(Expression.Eq("olt.Location.Code", locList[0])); } else { criteria.Add(Expression.InG <string>("olt.Location.Code", locList)); } criteria.SetProjection(Projections.ProjectionList() .Add(Projections.GroupProperty("olt.Location.Code").As("LocationCode")) .Add(Projections.GroupProperty("olt.Item.Code").As("ItemCode")) .Add(Projections.Sum("Qty").As("Qty"))); criteria.SetResultTransformer(Transformers.AliasToBean(typeof(InProcessLocationDetail))); return(this.criteriaMgr.FindAll <InProcessLocationDetail>(criteria)); }
public void ProdsWDate() { ISession session = GetConfiguration().BuildSessionFactory().OpenSession(); Category category = new Category() { Id = 1 }; DetachedCriteria criteria = DetachedCriteria.For <Income>(); criteria.CreateAlias("Product", "p"); criteria.CreateAlias("p.Category", "c"); criteria.SetProjection( Projections.ProjectionList() .Add(Projections.GroupProperty("Product")) .Add(Projections.GroupProperty("c.Name")) .Add(Projections.Max("Date"))); //criteria.Add(Restrictions.Eq("p.Category", category)); criteria.AddOrder(NHibernate.Criterion.Order.Asc("c.Name")); var list = criteria.GetExecutableCriteria(session).List(); foreach (var VARIABLE in list) { } }
public bool CheckGoodsIssueFIFO(string locationCode, string itemCode, DateTime baseManufatureDate, IList <string> huIdList) { DetachedCriteria criteria = DetachedCriteria.For <LocationLotDetail>(); criteria.SetProjection(Projections.Count("Id")); criteria.CreateAlias("Hu", "hu"); criteria.CreateAlias("Location", "loc"); criteria.CreateAlias("Item", "item"); criteria.Add(Expression.IsNotNull("Hu")); criteria.Add(Expression.Gt("Qty", new Decimal(0))); criteria.Add(Expression.Eq("item.Code", itemCode)); criteria.Add(Expression.Eq("loc.Code", locationCode)); criteria.Add(Expression.Lt("hu.ManufactureDate", baseManufatureDate)); criteria.Add(Expression.Not(Expression.In("hu.HuId", huIdList.ToArray <string>()))); IList <int> list = this.criteriaMgr.FindAll <int>(criteria); if (list[0] > 0) { return(false); } else { return(true); } }
private IList <OrderLocationTransaction> GetOpenOrderLocTransInByFlow(string flowCode, string itemCode, DateTime?startWinTime, DateTime?endWinTime) { DetachedCriteria criteria = DetachedCriteria.For(typeof(OrderLocationTransaction), "orderLocTrans"); criteria.CreateAlias("OrderDetail", "od"); criteria.CreateAlias("od.OrderHead", "oh"); criteria.Add(Expression.Eq("orderLocTrans.Item.Code", itemCode)); criteria.Add(Expression.Eq("orderLocTrans.IOType", BusinessConstants.IO_TYPE_IN)); criteria.Add(Expression.Eq("oh.Flow", flowCode)); //WindowTime in [startWinTime,endWinTime) if (startWinTime.HasValue) { criteria.Add(Expression.Ge("oh.WindowTime", (DateTime)startWinTime)); } if (endWinTime.HasValue) { criteria.Add(Expression.Lt("oh.WindowTime", (DateTime)endWinTime)); } criteria.Add(Expression.Or(Expression.Eq("oh.Status", BusinessConstants.CODE_MASTER_STATUS_VALUE_SUBMIT), Expression.Eq("oh.Status", BusinessConstants.CODE_MASTER_STATUS_VALUE_INPROCESS))); criteria.AddOrder(Order.Asc("oh.WindowTime")); IList <OrderLocationTransaction> orderLocTransList = CriteriaMgr.FindAll <OrderLocationTransaction>(criteria); return(orderLocTransList); }
public bool CheckGoodsReceiveFIFO(string locationCode, string itemCode, DateTime manufactureDate, string manufactureParty, DateTime?baseManufatureDate) { DetachedCriteria criteria = DetachedCriteria.For <LocationLotDetail>(); criteria.SetProjection(Projections.Count("Id")); criteria.CreateAlias("Hu", "hu"); criteria.CreateAlias("Location", "loc"); criteria.CreateAlias("Item", "item"); criteria.CreateAlias("hu.ManufactureParty", "party"); criteria.Add(Expression.IsNotNull("Hu")); criteria.Add(Expression.Gt("Qty", new Decimal(0))); criteria.Add(Expression.Eq("item.Code", itemCode)); criteria.Add(Expression.Eq("loc.Code", locationCode)); criteria.Add(Expression.Gt("hu.ManufactureDate", manufactureDate)); criteria.Add(Expression.Eq("party.Code", manufactureParty)); if (baseManufatureDate.HasValue) { criteria.Add(Expression.Lt("hu.ManufactureDate", baseManufatureDate.Value)); } IList <int> list = this.criteriaMgr.FindAll <int>(criteria); if (list[0] > 0) { return(false); } else { return(true); } }
public override void CreateByMaterial(ByMaterial byMaterial) { #region ¼ì²éOrderºÍItem DetachedCriteria criteria = DetachedCriteria.For(typeof(OrderLocationTransaction)); criteria.CreateAlias("OrderDetail", "od"); criteria.CreateAlias("od.OrderHead", "oh"); criteria.Add(Expression.Eq("Item.Code", byMaterial.Item.Code)); criteria.Add(Expression.Eq("oh.OrderNo", byMaterial.OrderNo)); criteria.Add(Expression.Eq("oh.Type", BusinessConstants.CODE_MASTER_ORDER_TYPE_VALUE_PRODUCTION)); criteria.Add(Expression.Eq("oh.Status", BusinessConstants.CODE_MASTER_STATUS_VALUE_INPROCESS)); criteria.Add(Expression.Eq("TransactionType", BusinessConstants.CODE_MASTER_LOCATION_TRANSACTION_TYPE_VALUE_ISS_WO)); criteria.Add(Expression.Eq("TagNo", byMaterial.TagNo)); IList <OrderLocationTransaction> orderLocTransList = criteriaMgr.FindAll <OrderLocationTransaction>(criteria); if (orderLocTransList.Count == 0) { throw new BusinessErrorException("Mes.ByMaterial.OrderItem.NotExist"); } #endregion else { OrderLocationTransaction ol = orderLocTransList[0]; ol.Cartons = ol.Cartons + 1; base.CreateByMaterial(byMaterial); } }
public IList <PickListDetail> GetPickedPickListDetail(int orderLocationTransactionId) { DetachedCriteria criteria = DetachedCriteria.For <PickListDetail>(); criteria.CreateAlias("OrderLocationTransaction", "olt"); criteria.CreateAlias("PickList", "pk"); IList <string> statusList = new List <string>(); statusList.Add(BusinessConstants.CODE_MASTER_STATUS_VALUE_SUBMIT); statusList.Add(BusinessConstants.CODE_MASTER_STATUS_VALUE_INPROCESS); criteria.Add(Expression.Eq("olt.Id", orderLocationTransactionId)); if (statusList != null && statusList.Count > 0) { if (statusList.Count == 1) { criteria.Add(Expression.Eq("pk.Status", statusList[0])); } else { criteria.Add(Expression.InG <string>("pk.Status", statusList)); } } return(this.criteriaMgr.FindAll <PickListDetail>(criteria)); }
public static bool VerificarUltimaRealizacaoDataMaiorQueDataRemarcacao(int idProcesso) { DetachedCriteria dc = DetachedCriteria.For(typeof(ProcessoAndamento)); dc.Add(Expression.Eq("Processo.Id", idProcesso)); dc.Add(Expression.IsNull("AndamentoCorrigido")); dc.Add(Expression.IsNull("AndamentoAdiado")); dc.CreateAlias("FluxoAndamento", "fan"); dc.CreateAlias("fan.Atividade", "ati"); dc.Add(Expression.Sql(@" this_.pk_cod_processo_andamento_pan in (select pan.pk_cod_processo_andamento_pan from adm_licitar.tb_processo_andamento_pan pan inner join adm_licitar.tb_fluxo_andamento_fan fan on fan.pk_cod_fluxo_andamento_fan = pan.fk_cod_fluxo_andamento_fan inner join adm_licitar.tb_atividade_ati ati on ati.pk_cod_atividade_ati = fan.fk_cod_atividade_ati and fk_cod_processo_andamento_remarcado_pan is null and fk_cod_processo_andamento_pan is null where fk_cod_processo_pro = " + idProcesso + @" and txt_descricao_ati in ( 'LICITAÇÃO MARCADA', 'LICITAÇÃO MARCADA EM CONTINUIDADE', 'DISPUTA', 'SESSÃO FINAL', 'SESSÃO DE RESULTADO - HABILITAÇÃO', 'SESSÃO DE RESULTADO - PROPOSTA COMERCIAL', 'SESSÃO DE ABERTURA - PROPOSTA COMERCIAL', 'SESSÃO DE ABERTURA - PROPOSTA TÉCNICA', 'SESSÃO DE RESULTADO - PROPOSTA TÉCNICA' ) and dat_andamento_pan >= '" + DateTime.Now + @"' order by dat_andamento_pan desc limit 1)")); ; ProcessoAndamento andamento = ProcessoAndamento.FindOne(dc); if (andamento != null) { return(true); } return(false); }
public IList <Flow> GetAllFlow(string userCode) { DetachedCriteria criteria = DetachedCriteria.For <Flow>(); criteria.CreateAlias("PartyTo", "pt"); criteria.CreateAlias("PartyFrom", "pf"); DetachedCriteria[] pfCrieteria = SecurityHelper.GetPartyPermissionCriteria(userCode, BusinessConstants.CODE_MASTER_PARTY_TYPE_VALUE_REGION, BusinessConstants.CODE_MASTER_PARTY_TYPE_VALUE_SUPPLIER); DetachedCriteria[] ptCrieteria = SecurityHelper.GetPartyPermissionCriteria(userCode, BusinessConstants.CODE_MASTER_PARTY_TYPE_VALUE_REGION, BusinessConstants.CODE_MASTER_PARTY_TYPE_VALUE_CUSTOMER); criteria.Add( Expression.Or( Subqueries.PropertyIn("pf.Code", pfCrieteria[0]), Subqueries.PropertyIn("pf.Code", pfCrieteria[1]) )); criteria.Add( Expression.Or( Subqueries.PropertyIn("pt.Code", ptCrieteria[0]), Subqueries.PropertyIn("pt.Code", ptCrieteria[1]) )); return(criteriaMgr.FindAll <Flow>(criteria)); }
private void SetCriteria() { DetachedCriteria criteria = DetachedCriteria.For(typeof(OrderLocationTransaction)); criteria.CreateAlias("OrderDetail", "od"); criteria.CreateAlias("od.OrderHead", "oh"); OrderHelper.SetOpenOrderStatusCriteria(criteria, "oh.Status");//订单状态 if (this.EndDate.HasValue) { if (IOType == BusinessConstants.IO_TYPE_IN) { criteria.Add(Expression.Le("oh.WindowTime", this.EndDate.Value)); } else { criteria.Add(Expression.Lt("oh.StartTime", this.EndDate.Value)); } } criteria.Add(Expression.Eq("Item.Code", this.Item)); criteria.Add(Expression.Eq("Location.Code", this.Location)); criteria.Add(Expression.Eq("IOType", this.IOType)); DetachedCriteria selectCountCriteria = CloneHelper.DeepClone <DetachedCriteria>(criteria); selectCountCriteria.SetProjection(Projections.Count("Id")); SetSearchCriteria(criteria, selectCountCriteria); }
private void ClearOldItemFlowPlan(string item, string loc, string status) { DetachedCriteria criteria = DetachedCriteria.For(typeof(ItemFlowPlan)); criteria.CreateAlias("FlowDetail", "fd"); criteria.CreateAlias("fd.Item", "item"); criteria.Add(Expression.Eq("item.Code", item)); criteria.Add(Expression.Eq("Location.Code", loc)); criteria.Add(Expression.Eq("Status", status)); IList <ItemFlowPlan> itemFlowPlanList = CriteriaMgr.FindAll <ItemFlowPlan>(criteria); if (itemFlowPlanList != null && itemFlowPlanList.Count > 0) { foreach (ItemFlowPlan itemFlowPlan in itemFlowPlanList) { if (itemFlowPlan.ItemFlowPlanDetails != null && itemFlowPlan.ItemFlowPlanDetails.Count > 0) { foreach (ItemFlowPlanDetail itemFlowPlanDetail in itemFlowPlan.ItemFlowPlanDetails) { if (itemFlowPlanDetail.ItemFlowPlanTracks != null && itemFlowPlanDetail.ItemFlowPlanTracks.Count > 0) { foreach (ItemFlowPlanTrack itemFlowPlanTrack in itemFlowPlanDetail.ItemFlowPlanTracks) { ItemFlowPlanTrackMgr.DeleteItemFlowPlanTrack(itemFlowPlanTrack); } } ItemFlowPlanDetailMgr.DeleteItemFlowPlanDetail(itemFlowPlanDetail); } } this.DeleteItemFlowPlan(itemFlowPlan); } } }
private void SetCriteria() { DetachedCriteria criteria = DetachedCriteria.For(typeof(InProcessLocationDetail)); criteria.CreateAlias("OrderLocationTransaction", "olt"); criteria.CreateAlias("InProcessLocation", "ip"); criteria.Add(Expression.Eq("ip.Status", BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE)); criteria.Add(Expression.Eq("ip.Type", BusinessConstants.CODE_MASTER_INPROCESS_LOCATION_TYPE_VALUE_NORMAL)); if (this.IOType == BusinessConstants.IO_TYPE_IN) { DetachedCriteria subCriteria = DetachedCriteria.For(typeof(OrderLocationTransaction)); subCriteria.CreateAlias("OrderDetail", "od"); subCriteria.CreateAlias("od.OrderHead", "oh"); OrderHelper.SetOpenOrderStatusCriteria(subCriteria, "oh.Status"); subCriteria.Add(Expression.Eq("IOType", BusinessConstants.IO_TYPE_IN)); subCriteria.Add(Expression.Eq("Item.Code", this.Item)); subCriteria.Add(Expression.Eq("Location.Code", this.Location)); subCriteria.SetProjection(Projections.ProjectionList().Add(Projections.GroupProperty("OrderDetail.Id"))); criteria.Add(Subqueries.PropertyIn("olt.OrderDetail.Id", subCriteria)); } else { criteria.Add(Expression.Eq("olt.Item.Code", this.Item)); criteria.Add(Expression.Eq("olt.Location.Code", this.Location)); } DetachedCriteria selectCountCriteria = CloneHelper.DeepClone <DetachedCriteria>(criteria); selectCountCriteria.SetProjection(Projections.Count("Id")); this.SetSearchCriteria(criteria, selectCountCriteria); }
public static bool VerificarSeJaFoiDadoAndamentoAgendaComDataIgual(int idProcesso, DateTime data) { string[] andamentosAgenda = { "LICITAÇÃO MARCADA", // MF Inicio "LICITAÇÃO MARCADA EM CONTINUIDADE", // MF Fim "DISPUTA", "SESSÃO FINAL", "SESSÃO DE RESULTADO - HABILITAÇÃO", "SESSÃO DE RESULTADO - PROPOSTA COMERCIAL", "SESSÃO DE ABERTURA - PROPOSTA COMERCIAL", "SESSÃO DE ABERTURA - PROPOSTA TÉCNICA", "SESSÃO DE RESULTADO - PROPOSTA TÉCNICA" }; DetachedCriteria dc = DetachedCriteria.For(typeof(ProcessoAndamento)); dc.Add(Expression.Eq("Processo.Id", idProcesso)); dc.Add(Expression.IsNull("AndamentoCorrigido")); dc.Add(Expression.IsNull("AndamentoAdiado")); dc.CreateAlias("FluxoAndamento", "fan"); dc.CreateAlias("fan.Atividade", "ati"); dc.Add(Expression.In("ati.Descricao", andamentosAgenda)); dc.Add(Expression.Sql(" this_.dat_andamento_pan = '" + data + "' ")); ProcessoAndamento[] andamentos = ProcessoAndamento.FindAll(dc); if (andamentos.Length > 0) { return(true); } return(false); }
private void RegistrarAndamentoIncluindoPessoa(Atividade tipoAndamento, Pessoa responsavel, Pessoa destinatario, string observacao, bool incluirData, bool UnidExercicio, string fase) { ProcessoAndamento andamento = new ProcessoAndamento(); DetachedCriteria dcFluxo = DetachedCriteria.For(typeof(FluxoAndamento)); dcFluxo.CreateAlias("Fase", "fas"); dcFluxo.CreateAlias("Atividade", "ati"); dcFluxo.Add(Expression.Eq("fas.Descricao", fase)); dcFluxo.Add(Expression.Eq("ati.Descricao", tipoAndamento.Descricao)); dcFluxo.Add(Expression.Sql("this_.fk_cod_workflow_wor in (select wor.pk_cod_workflow_wor from adm_licitar.tb_workflow_modalidade_unidade_exercicio_wmu wmu inner join adm_licitar.tb_workflow_wor wor on wmu.fk_cod_workflow_wor = wor.pk_cod_workflow_wor where wmu.fk_cod_modalidade_mod=" + this.Classificacao.Modalidade.Id + ")")); FluxoAndamento objFluxo = FluxoAndamento.FindFirst(dcFluxo); //INSERIR ANDAMENTO andamento.Cadastrante = responsavel; andamento.Processo = this; andamento.FluxoAndamento = objFluxo; andamento.Pessoa = destinatario; if (incluirData) { andamento.DataCadastro = DateTime.Now; } andamento.Andamento = observacao ?? null; andamento.SaveAndFlush(); }
public int RetornarUltimoIdDataMarcacao(int idProcesso, int processoAndamentoAdiado) { string[] andamentosAgenda = { "LICITAÇÃO MARCADA", "LICITAÇÃO MARCADA EM CONTINUIDADE", "DISPUTA", "SESSÃO FINAL", "SESSÃO DE RESULTADO - HABILITAÇÃO", "SESSÃO DE RESULTADO - PROPOSTA COMERCIAL", "SESSÃO DE ABERTURA - PROPOSTA COMERCIAL", "SESSÃO DE ABERTURA - PROPOSTA TÉCNICA", "SESSÃO DE RESULTADO - PROPOSTA TÉCNICA" }; DetachedCriteria dc = DetachedCriteria.For(typeof(ProcessoAndamento)); dc.Add(Expression.Eq("Processo.Id", idProcesso)); dc.Add(Expression.IsNull("AndamentoCorrigido")); dc.CreateAlias("AndamentoAdiado", "adi"); dc.Add(Expression.Eq("adi.Id", processoAndamentoAdiado)); dc.CreateAlias("FluxoAndamento", "fan"); dc.CreateAlias("fan.Atividade", "ati"); dc.Add(Expression.In("ati.Descricao", andamentosAgenda)); dc.Add(Expression.Sql(" this_.dat_andamento_pan >= '" + DateTime.Now + "' order by this_.dat_andamento_pan desc ")); ProcessoAndamento andamento = ProcessoAndamento.FindFirst(dc); return(andamento.Id); }
public void MarcarUltimaDataRealizacao(int idProcesso, ProcessoAndamento fkCodProcAndRemarcado) { string[] andamentosAgenda = { "LICITAÇÃO MARCADA", // MF Inicio "LICITAÇÃO MARCADA EM CONTINUIDADE", // MF Fim "DISPUTA", "SESSÃO FINAL", "SESSÃO DE RESULTADO - HABILITAÇÃO", "SESSÃO DE RESULTADO - PROPOSTA COMERCIAL", "SESSÃO DE ABERTURA - PROPOSTA COMERCIAL", "SESSÃO DE ABERTURA - PROPOSTA TÉCNICA", "SESSÃO DE RESULTADO - PROPOSTA TÉCNICA" }; DetachedCriteria dc = DetachedCriteria.For(typeof(ProcessoAndamento)); dc.Add(Expression.Eq("Processo.Id", idProcesso)); dc.Add(Expression.IsNull("AndamentoCorrigido")); dc.Add(Expression.IsNull("AndamentoAdiado")); dc.CreateAlias("FluxoAndamento", "fan"); dc.CreateAlias("fan.Atividade", "ati"); dc.Add(Expression.In("ati.Descricao", andamentosAgenda)); dc.Add(Expression.Sql(" this_.dat_andamento_pan >= '" + DateTime.Now + "' order by this_.dat_andamento_pan desc ")); ProcessoAndamento andamento = ProcessoAndamento.FindFirst(dc); if (andamento != null) { andamento.AndamentoAdiado = fkCodProcAndRemarcado; andamento.SaveAndFlush(); } }
private List <LeanEngine.Entity.InvBalance> GetInspectInvBalance() { //报验库存 DetachedCriteria criteria = DetachedCriteria.For(typeof(InspectOrderDetail)); criteria.CreateAlias("InspectOrder", "io"); criteria.CreateAlias("LocationLotDetail", "lld"); criteria.Add(Expression.Eq("io.Status", BusinessConstants.CODE_MASTER_STATUS_VALUE_CREATE)); criteria.Add(Expression.Eq("io.IsSeperated", false)); criteria.SetProjection(Projections.ProjectionList() .Add(Projections.Sum("InspectQty").As("InspectQty")) .Add(Projections.Sum("QualifiedQty").As("QualifiedQty")) .Add(Projections.Sum("RejectedQty").As("RejectedQty")) .Add(Projections.GroupProperty("LocationFrom.Code").As("LocationFromCode")) .Add(Projections.GroupProperty("lld.Item.Code").As("ItemCode"))); criteria.SetResultTransformer(Transformers.AliasToBean(typeof(InspectOrderDetail))); IList <InspectOrderDetail> inspectOrderDetailList = CriteriaMgr.FindAll <InspectOrderDetail>(criteria); var query = from i in inspectOrderDetailList select new LeanEngine.Entity.InvBalance { Loc = i.LocationFromCode, Item = i.ItemCode, Qty = i.InspectedQty, InvType = Enumerators.InvType.Inspect }; return(query.Where(q => q.Qty != 0).ToList()); }
public IDictionary <string, int> getStudentCompanyData() { Utility.logFile(Constant.METHOD_ENTER + Utility.getCurrentMethodName(1) + "(StatisticsManagerImpl)", null, Constant.LOGTYPE_INFO); DetachedCriteria criteria = DetachedCriteria.For <Entity_PlacementDetails>(); criteria.CreateAlias("compDetailsObj", "compDetail"); criteria.CreateAlias("compDetail.companyObj", "company"); ProjectionList projectionList = Projections.ProjectionList(); projectionList.Add(Projections.GroupProperty(Projections.Property("company.companyName"))); projectionList.Add(Projections.Count(Projections.Property("compDetail.compDetailsId"))); criteria.Add(Restrictions.Eq("compDetail.myConfigObj.currentBatch", Common.loggedUser.myConfigObj.currentBatch)); criteria.Add(Restrictions.Eq("compDetail.myConfigObj.currentDegree", Common.loggedUser.myConfigObj.currentDegree)); criteria.SetProjection(projectionList); criteria.AddOrder(Order.Asc("company.companyName")); IList list = persistence.findByCriteria(criteria); if (list != null && list.Count > 0) { IDictionary <string, int> resultMap = new Dictionary <string, int>(); foreach (Object[] item in list) { resultMap.Add(item[0].ToString(), Convert.ToInt32(item[1])); } return(resultMap); } else { return(null); } }
public static DetachedCriteria[] GetPermissionCriteriaByCategory(User user, string category) { DetachedCriteria[] criteria = new DetachedCriteria[2]; DetachedCriteria upSubCriteria = DetachedCriteria.For <UserPermission>(); upSubCriteria.CreateAlias("User", "u"); upSubCriteria.CreateAlias("Permission", "pm"); upSubCriteria.CreateAlias("pm.Category", "pmc"); upSubCriteria.Add(Expression.Eq("pmc.Type", category)); upSubCriteria.Add(Expression.Eq("u.Code", user.Code)); upSubCriteria.SetProjection(Projections.ProjectionList().Add(Projections.GroupProperty("pm.Code"))); DetachedCriteria rpSubCriteria = DetachedCriteria.For <RolePermission>(); rpSubCriteria.CreateAlias("Role", "r"); rpSubCriteria.CreateAlias("Permission", "pm"); rpSubCriteria.CreateAlias("pm.Category", "pmc"); rpSubCriteria.Add(Expression.Eq("pmc.Type", category)); rpSubCriteria.SetProjection(Projections.ProjectionList().Add(Projections.GroupProperty("pm.Code"))); DetachedCriteria urSubCriteria = DetachedCriteria.For <UserRole>(); urSubCriteria.CreateAlias("User", "u"); urSubCriteria.CreateAlias("Role", "r"); urSubCriteria.Add(Expression.Eq("u.Code", user.Code)); urSubCriteria.SetProjection(Projections.ProjectionList().Add(Projections.GroupProperty("r.Code"))); rpSubCriteria.Add(Subqueries.PropertyIn("r.Code", urSubCriteria)); criteria[0] = upSubCriteria; criteria[1] = rpSubCriteria; return(criteria); }
protected override void SetCriteria() { DetachedCriteria criteria = DetachedCriteria.For(typeof(CycleCountResult)); criteria.CreateAlias("CycleCount", "cc"); criteria.CreateAlias("cc.Location", "l"); #region Customize SecurityHelper.SetRegionSearchCriteria(criteria, "l.Region.Code", this.CurrentUser.Code); //区域权限 OrderHelper.SetActiveOrderStatusCriteria(criteria, "cc.Status"); //状态 #endregion #region Select Parameters CriteriaHelper.SetPartyCriteria(criteria, "l.Region.Code", this._criteriaParam); CriteriaHelper.SetLocationCriteria(criteria, "cc.Location.Code", this._criteriaParam); CriteriaHelper.SetStartDateCriteria(criteria, "cc.EffectiveDate", this._criteriaParam); CriteriaHelper.SetEndDateCriteria(criteria, "cc.EffectiveDate", this._criteriaParam); CriteriaHelper.SetStorageBinCriteria(criteria, "StorageBin.Code", this._criteriaParam); CriteriaHelper.SetItemCriteria(criteria, "Item.Code", this._criteriaParam); CriteriaHelper.SetOrderNoCriteria(criteria, "CycleCount.Code", this._criteriaParam, MatchMode.Start); #endregion #region Projections ProjectionList projectionList = Projections.ProjectionList() .Add(Projections.Max("Id").As("Id")) .Add(Projections.Sum("Qty").As("Qty")) .Add(Projections.Sum("InvQty").As("InvQty")) .Add(Projections.Sum("DiffQty").As("DiffQty")) .Add(Projections.Count("HuId").As("Cartons")) .Add(Projections.GroupProperty("Item").As("Item")); if (!this._criteriaParam.ClassifiedOrderNo) { projectionList.Add(Projections.GroupProperty("CycleCount").As("CycleCount")); } if (!this._criteriaParam.ClassifiedLocation) { projectionList.Add(Projections.GroupProperty("cc.Location").As("Location")); } if (!this._criteriaParam.ClassifiedBin) { projectionList.Add(Projections.GroupProperty("StorageBin").As("StorageBin"));//库格 } if (!this._criteriaParam.ClassifiedHuId) { projectionList.Add(Projections.GroupProperty("HuId").As("HuId")); //条码 projectionList.Add(Projections.GroupProperty("LotNo").As("LotNo")); //批号 projectionList.Add(Projections.GroupProperty("ReferenceLocation").As("ReferenceLocation")); //参考库位 projectionList.Add(Projections.GroupProperty("DiffReason").As("DiffReason")); //差异原因 } criteria.SetProjection(projectionList); criteria.SetResultTransformer(Transformers.AliasToBean(typeof(CycleCountResult))); #endregion DetachedCriteria selectCountCriteria = CloneHelper.DeepClone <DetachedCriteria>(criteria); selectCountCriteria.SetProjection(Projections.Count("Id")); SetSearchCriteria(criteria, selectCountCriteria); }
protected override void DoSearch() { string code = this.tbFlow.Text != string.Empty ? this.tbFlow.Text.Trim() : string.Empty; string partyFrom = this.tbPartyFrom.Text != string.Empty ? this.tbPartyFrom.Text.Trim() : string.Empty; string partyTo = this.tbPartyTo.Text != string.Empty ? this.tbPartyTo.Text.Trim() : string.Empty; string locFrom = this.tbLocFrom.Text != string.Empty ? this.tbLocFrom.Text.Trim() : string.Empty; string strategy = this.ddlStrategy.SelectedIndex != -1 ? this.ddlStrategy.SelectedValue : string.Empty; if (SearchEvent != null) { DetachedCriteria selectCriteria = DetachedCriteria.For(typeof(Flow)); DetachedCriteria selectCountCriteria = DetachedCriteria.For(typeof(Flow)) .SetProjection(Projections.ProjectionList() .Add(Projections.Count("Code"))); selectCriteria.CreateAlias("PartyFrom", "pf"); selectCountCriteria.CreateAlias("PartyFrom", "pf"); selectCriteria.CreateAlias("PartyTo", "pt"); selectCountCriteria.CreateAlias("PartyTo", "pt"); #region partyFrom SecurityHelper.SetPartyFromSearchCriteria( selectCriteria, selectCountCriteria, (this.tbPartyFrom != null ? this.tbPartyFrom.Text : null), BusinessConstants.CODE_MASTER_FLOW_TYPE_VALUE_DISTRIBUTION, this.CurrentUser.Code); #endregion #region partyTo SecurityHelper.SetPartyToSearchCriteria( selectCriteria, selectCountCriteria, (this.tbPartyTo != null ? this.tbPartyTo.Text : null), BusinessConstants.CODE_MASTER_FLOW_TYPE_VALUE_DISTRIBUTION, this.CurrentUser.Code); #endregion #region flowType selectCriteria.Add(Expression.Eq("Type", BusinessConstants.CODE_MASTER_FLOW_TYPE_VALUE_DISTRIBUTION)); selectCountCriteria.Add(Expression.Eq("Type", BusinessConstants.CODE_MASTER_FLOW_TYPE_VALUE_DISTRIBUTION)); #endregion if (code != string.Empty) { selectCriteria.Add(Expression.Eq("Code", code)); selectCountCriteria.Add(Expression.Eq("Code", code)); } if (locFrom != string.Empty) { selectCriteria.Add(Expression.Eq("LocationFrom.Code", locFrom)); selectCountCriteria.Add(Expression.Eq("LocationFrom.Code", locFrom)); } if (strategy != string.Empty) { selectCriteria.Add(Expression.Eq("FlowStrategy", strategy)); selectCountCriteria.Add(Expression.Eq("FlowStrategy", strategy)); } SearchEvent((new object[] { selectCriteria, selectCountCriteria }), null); } }
public IList <PickListResult> GetPickListResult(string pickListNo) { DetachedCriteria criteria = DetachedCriteria.For <PickListResult>(); criteria.CreateAlias("PickListDetail", "pld"); criteria.CreateAlias("pld.PickList", "pl"); criteria.Add(Expression.Eq("pl.PickListNo", pickListNo)); return(this.criteriaMgr.FindAll <PickListResult>(criteria)); }
private object[] CollectParam() { DetachedCriteria selectCriteria = DetachedCriteria.For(typeof(BillAgingView)); DetachedCriteria selectCountCriteria = DetachedCriteria.For(typeof(BillAgingView)) .SetProjection(Projections.Count("Id")); IDictionary <string, string> alias = new Dictionary <string, string>(); selectCriteria.CreateAlias("BillAddress", "ba"); selectCountCriteria.CreateAlias("BillAddress", "ba"); alias.Add("BillAddress", "ba"); if (this.ModuleType == BusinessConstants.CODE_MASTER_ORDER_TYPE_VALUE_PROCUREMENT) { selectCriteria.CreateAlias("ba.Party", "pf"); selectCountCriteria.CreateAlias("ba.Party", "pf"); alias.Add("BillAddress.Party", "pf"); if (this.tbParty.Text.Trim() != string.Empty) { selectCriteria.Add(Expression.Eq("pf.Code", this.tbParty.Text.Trim())); selectCountCriteria.Add(Expression.Eq("pf.Code", this.tbParty.Text.Trim())); } else { SecurityHelper.SetPartyFromSearchCriteria( selectCriteria, selectCountCriteria, (this.tbParty != null ? this.tbParty.Text : null), this.ModuleType, this.CurrentUser.Code); } selectCriteria.Add(Expression.Eq("TransactionType", BusinessConstants.BILL_TRANS_TYPE_PO)); selectCountCriteria.Add(Expression.Eq("TransactionType", BusinessConstants.BILL_TRANS_TYPE_PO)); } else if (this.ModuleType == BusinessConstants.CODE_MASTER_ORDER_TYPE_VALUE_DISTRIBUTION) { selectCriteria.CreateAlias("ba.Party", "pt"); selectCountCriteria.CreateAlias("ba.Party", "pt"); alias.Add("BillAddress.Party", "pt"); if (this.tbParty.Text.Trim() != string.Empty) { selectCriteria.Add(Expression.Eq("pt.Code", this.tbParty.Text.Trim())); selectCountCriteria.Add(Expression.Eq("pt.Code", this.tbParty.Text.Trim())); } else { SecurityHelper.SetPartyToSearchCriteria( selectCriteria, selectCountCriteria, (this.tbParty != null ? this.tbParty.Text : null), this.ModuleType, this.CurrentUser.Code); } selectCriteria.Add(Expression.Eq("TransactionType", BusinessConstants.BILL_TRANS_TYPE_SO)); selectCountCriteria.Add(Expression.Eq("TransactionType", BusinessConstants.BILL_TRANS_TYPE_SO)); } return(new object[] { selectCriteria, selectCountCriteria, alias }); }
public static Classificacao[] getClassificacoes(string modalidade, string natureza) { DetachedCriteria dc2 = DetachedCriteria.For(typeof(Classificacao)); dc2.CreateAlias("Modalidade", "mod"); dc2.CreateAlias("Natureza", "nat"); dc2.Add(Expression.Eq("mod.Id", Convert.ToInt32(modalidade))); dc2.Add(Expression.Eq("nat.Id", Convert.ToInt32(natureza))); return(Classificacao.FindAll(dc2)); }
public bool VerificarExistenciaValorEstimadoGlobal(int idProcesso) { DetachedCriteria pesqValorEstGlobal = DetachedCriteria.For(typeof(ValorProcesso)); pesqValorEstGlobal.CreateAlias("TipoValor", "tpvalor"); pesqValorEstGlobal.CreateAlias("Processo", "proc"); pesqValorEstGlobal.Add(Expression.Eq("tpvalor.Descricao", "Estimado Global")); pesqValorEstGlobal.Add(Expression.Eq("proc.Id", idProcesso)); return(ValorProcesso.Exists(pesqValorEstGlobal)); }
protected override void DoSearch() { string pickListNo = this.tbPickListNo.Text != string.Empty ? this.tbPickListNo.Text.Trim() : string.Empty; string startDate = this.tbStartDate.Text != string.Empty ? this.tbStartDate.Text.Trim() : string.Empty; string endDate = this.tbEndDate.Text != string.Empty ? this.tbEndDate.Text.Trim() : string.Empty; DetachedCriteria selectCriteria = DetachedCriteria.For(typeof(PickList)); selectCriteria.Add(Expression.Or(Expression.Eq("Status", BusinessConstants.CODE_MASTER_STATUS_VALUE_INPROCESS), Expression.Eq("Status", BusinessConstants.CODE_MASTER_STATUS_VALUE_COMPLETE))); selectCriteria.CreateAlias("PartyFrom", "pf"); selectCriteria.CreateAlias("PartyTo", "pt"); //partyFrom DetachedCriteria[] pfCrieteria = SecurityHelper.GetPartyPermissionCriteria(this.CurrentUser.Code, BusinessConstants.CODE_MASTER_PARTY_TYPE_VALUE_REGION); selectCriteria.Add( Expression.Or( Subqueries.PropertyIn("pf.Code", pfCrieteria[0]), Subqueries.PropertyIn("pf.Code", pfCrieteria[1]) )); ////partyTo //DetachedCriteria[] ptCrieteria = SecurityHelper.GetPartyPermissionCriteria(this.CurrentUser.Code, // BusinessConstants.CODE_MASTER_PARTY_TYPE_VALUE_REGION, BusinessConstants.CODE_MASTER_PARTY_TYPE_VALUE_CUSTOMER); //selectCriteria.Add( // Expression.Or( // Subqueries.PropertyIn("pt.Code", ptCrieteria[0]), // Subqueries.PropertyIn("pt.Code", ptCrieteria[1]) //)); if (pickListNo != string.Empty) { selectCriteria.Add(Expression.Eq("PickListNo", pickListNo)); } if (startDate != string.Empty) { selectCriteria.Add(Expression.Ge("CreateDate", DateTime.Parse(startDate))); } if (endDate != string.Empty) { selectCriteria.Add(Expression.Lt("CreateDate", DateTime.Parse(endDate).AddDays(1))); } IList <PickList> pickList = TheCriteriaMgr.FindAll <PickList>(selectCriteria); this.ucList.BindDataSource(pickList); this.ucList.Visible = true; }
public IList <InProcessLocationDetail> GetInProcessLocationDetail(OrderHead orderHead) { DetachedCriteria criteria = DetachedCriteria.For <InProcessLocationDetail>(); criteria.CreateAlias("OrderLocationTransaction", "olt"); criteria.CreateAlias("olt.OrderDetail", "od"); criteria.CreateAlias("od.OrderHead", "oh"); criteria.Add(Expression.Eq("oh.OrderNo", orderHead.OrderNo)); return(this.criteriaMgr.FindAll <InProcessLocationDetail>(criteria)); }
private void DoSearch(bool isExport) { DetachedCriteria selectCriteria = DetachedCriteria.For(typeof(InspectDetailView)); selectCriteria.CreateAlias("InspectOrder", "o"); selectCriteria.CreateAlias("LocationFrom", "lf"); selectCriteria.CreateAlias("LocationTo", "lt"); DetachedCriteria selectCountCriteria = DetachedCriteria.For(typeof(InspectDetailView)).SetProjection(Projections.Count("Id")); selectCountCriteria.CreateAlias("InspectOrder", "o"); selectCountCriteria.CreateAlias("LocationFrom", "lf"); if (this.tbLocation.Text.Trim() != string.Empty) { selectCriteria.Add(Expression.Eq("lf.Code", this.tbLocation.Text.Trim())); selectCountCriteria.Add(Expression.Eq("lf.Code", this.tbLocation.Text.Trim())); } else { SecurityHelper.SetRegionSearchCriteria(selectCriteria, "lf.Region", this.CurrentUser.Code); SecurityHelper.SetRegionSearchCriteria(selectCountCriteria, "lf.Region", this.CurrentUser.Code); } if (this.tbStartDate.Text.Trim() != string.Empty) { DateTime startDate = DateTime.Parse(this.tbStartDate.Text.Trim()); selectCriteria.Add(Expression.Ge("o.CreateDate", startDate)); selectCountCriteria.Add(Expression.Ge("o.CreateDate", startDate)); } if (this.tbEndDate.Text.Trim() != string.Empty) { DateTime endDate = DateTime.Parse(this.tbEndDate.Text.Trim()); selectCriteria.Add(Expression.Lt("o.CreateDate", endDate.AddDays(1))); selectCountCriteria.Add(Expression.Lt("o.CreateDate", endDate.AddDays(1))); } if (this.tbItemCode.Text.Trim() != string.Empty) { selectCriteria.Add(Expression.Eq("Item.Code", tbItemCode.Text.Trim())); selectCountCriteria.Add(Expression.Eq("Item.Code", tbItemCode.Text.Trim())); } if (isExport) { ExportEvent((new object[] { selectCriteria, selectCountCriteria }), null); } else { SearchEvent((new object[] { selectCriteria, selectCountCriteria }), null); } }
public static FluxoAndamento getFluxoAndamentoCadastroCadastradoPGE(string modalidade) { DetachedCriteria dcFluxo = DetachedCriteria.For(typeof(FluxoAndamento)); dcFluxo.CreateAlias("Fase", "fas"); dcFluxo.CreateAlias("Atividade", "ati"); dcFluxo.Add(Expression.Eq("fas.Descricao", "CADASTRO")); dcFluxo.Add(Expression.Eq("ati.Descricao", "CADASTRADO")); dcFluxo.Add(Expression.Sql("this_.fk_cod_workflow_wor in (select wor.pk_cod_workflow_wor from adm_licitar.tb_workflow_modalidade_unidade_exercicio_wmu wmu inner join adm_licitar.tb_workflow_wor wor on wmu.fk_cod_workflow_wor = wor.pk_cod_workflow_wor where wmu.fk_cod_modalidade_mod='" + modalidade + "')")); return(FluxoAndamento.FindFirst(dcFluxo)); }