public void CreatesWherePartFromEqualsExpression() { var criteriaHelper = new CriteriaHelper(); var criteria = SimpleExpression.Equal(new Column("Name", new Table("Spaceship", new Container("db"))), "Heart of Gold"); var wherePart = criteriaHelper.ToWherePart(criteria); Assert.Equal("Spaceship.Name", $"{wherePart.Column.Table.Name}.{wherePart.Column.Name}"); }
/// <summary> /// Executes the query. /// </summary> /// <param name="session">The <c>NHibernate</c>'s <see cref="ISession"/></param> /// <returns><c>System.Int32</c> as object</returns> protected override object InternalExecute(ISession session) { if (detachedCriteria != null) { ICriteria criteria = detachedCriteria.GetExecutableCriteria(session); criteria.SetProjection(Projections.RowCount()); Int32 count = Convert.ToInt32(criteria.UniqueResult()); // clear the projection, so our caller can re-use the DetachedCriteria criteria.SetProjection(new IProjection[] { null }); return(count); } else if (criterias != null) { ICriteria criteria = session.CreateCriteria(RootType); CriteriaHelper.AddCriterionToCriteria(criteria, criterias); criteria.SetProjection(Projections.RowCount()); return(Convert.ToInt32(criteria.UniqueResult())); } else { return(Convert.ToInt32(base.CreateQuery(session).UniqueResult())); } }
protected void btnSearch_Click(object sender, EventArgs e) { Button btn = (Button)sender; if (btn == this.btnExport) { FillParameter(); if (ExportEvent != null) { if (this.rblListFormat.SelectedValue == "Detail") { object[] criteriaParam = CriteriaHelper.CollectDetailParam(this.parameter, statusList, typeList, NewItem); ExportEvent(criteriaParam, null); } else { object[] criteriaParam = CriteriaHelper.CollectMasterParam(this.parameter, statusList, typeList, NewItem); ExportEvent(criteriaParam, null); } } } else { DoSearch(); } }
private decimal GetTotalOutQty(LocationDetail locationDetail) { DetachedCriteria criteria = DetachedCriteria.For(typeof(LocationTransactionView)); //criteria.CreateAlias("Location", "l"); #region Customize //SecurityHelper.SetRegionSearchCriteria(criteria, "l.Region.Code", this.CurrentUser.Code); //区域权限 CriteriaHelper.SetStartDateCriteria(criteria, "EffDate", _criteriaParam); CriteriaHelper.SetEndDateCriteria(criteria, "EffDate", _criteriaParam); #endregion #region Select Parameters string[] regionCode = locationDetail.Region != null ? new string[] { locationDetail.Region.Code } : null; string[] locationCode = locationDetail.Location != null ? new string[] { locationDetail.Location.Code } : null; string itemCode = locationDetail.Item != null ? locationDetail.Item.Code : null; //CriteriaHelper.SetPartyCriteria(criteria, "l.Region.Code", regionCode); CriteriaHelper.SetLocationCriteria(criteria, "Loc", locationCode); CriteriaHelper.SetItemCriteria(criteria, "Item", itemCode, MatchMode.Exact); criteria.Add(Expression.In("TransType", GetTransType())); #endregion criteria.SetProjection(Projections.Sum("Qty")); IList result = CriteriaMgr.FindAll(criteria); if (result[0] != null) { return((decimal)result[0]); } else { return(0); } }
public ActionResult List( string createdDate, string date, string isArchived, string modifiedDate, int?projectId, string projectName, int?sprintId, string sprintName, int?storyId, int?userId, string userName) { var model = new HourListModel(); var criteria = new HourDataCriteria { CreatedDate = CriteriaHelper.ToDateRangeCriteria(createdDate), Date = CriteriaHelper.ToDateRangeCriteria(date), IsArchived = CriteriaHelper.ToBoolean(isArchived), ModifiedDate = CriteriaHelper.ToDateRangeCriteria(modifiedDate), ProjectId = CriteriaHelper.ToArray(projectId), ProjectName = projectName, SprintId = sprintId, StoryId = storyId, UserId = userId, UserName = userName }; var hours = HourRepository.HourFetchInfoList(criteria); model.Hours = hours; return(this.View(model)); }
protected override void SetCriteria() { DetachedCriteria criteria = DetachedCriteria.For(typeof(LocationDetail)); criteria.CreateAlias("Location", "l"); #region Customize SecurityHelper.SetRegionSearchCriteria(criteria, "l.Region.Code", this.CurrentUser.Code); //区域权限 #endregion #region Select Parameters CriteriaHelper.SetLocationCriteria(criteria, "l.Code", this._criteriaParam); if (this._criteriaParam.Item != null) { criteria.Add(Expression.Eq("Item.Code", this._criteriaParam.Item)); } #endregion if (this._criteriaParam.LocationType != null) { criteria.Add(Expression.Eq("l.Type", this._criteriaParam.LocationType)); } DetachedCriteria selectCountCriteria = CloneHelper.DeepClone <DetachedCriteria>(criteria); selectCountCriteria.SetProjection(Projections.Count("Id")); SetSearchCriteria(criteria, selectCountCriteria); }
protected override void SetCriteria() { DetachedCriteria criteria = DetachedCriteria.For(typeof(LocationLotDetail)); criteria.CreateAlias("Location", "l"); #region Customize SecurityHelper.SetRegionSearchCriteria(criteria, "l.Region.Code", this.CurrentUser.Code); //区域权限 #endregion #region Select Parameters if (this._criteriaParam.Location == null) { criteria.Add(Expression.Eq("l.Type", BusinessConstants.LOCATION_TYPE_WORKSHOP)); } else { CriteriaHelper.SetLocationCriteria(criteria, "Location.Code", this._criteriaParam); } CriteriaHelper.SetItemCriteria(criteria, "Item.Code", this._criteriaParam); criteria.Add(Expression.IsNotNull("Hu.HuId")); criteria.Add(Expression.Not(Expression.Eq("Qty", decimal.Zero))); #endregion DetachedCriteria selectCountCriteria = CloneHelper.DeepClone <DetachedCriteria>(criteria); selectCountCriteria.SetProjection(Projections.Count("Id")); SetSearchCriteria(criteria, selectCountCriteria); }
private void BtnAddCriteria_Click(object sender, EventArgs e) { if (CriteriaTxtBox.Text == "") { MessageHelper.PromptErrorMsg(MessageTypeEnum.NullCriteria); } else { CriteriaModel criteria = new CriteriaModel() { ArtistId = Store.ArtistId, Name = CriteriaTxtBox.Text.ToLower() }; bool createSuccessful = criteriaService.Create(criteria); if (createSuccessful) { CriteriasListBox.DataSource = CriteriaHelper.GetCriteriasDataSource(); UpdateSongListBox(); } else { CriteriaTxtBox.SelectAll(); CriteriaTxtBox.Focus(); } } }
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); }
private IList <DssExportHistoryDetail> GetHisDetList(List <int> IdList) { DetachedCriteria criteria = DetachedCriteria.For(typeof(DssExportHistoryDetail)); CriteriaHelper.SetInCriteria <int>(criteria, "MstrId", IdList); return(criteriaMgr.FindAll <DssExportHistoryDetail>(criteria)); }
private IList <OrderLocationTransaction> GetOrderLocationTransaction(List <string> orderNoList) { DetachedCriteria criteria = DetachedCriteria.For(typeof(OrderLocationTransaction)); criteria.CreateAlias("OrderDetail", "od"); CriteriaHelper.SetInCriteria <string>(criteria, "od.OrderHead.OrderNo", orderNoList); return(criteriaMgr.FindAll <OrderLocationTransaction>(criteria)); }
public void CreatesWherePartFromEqualsExpression() { var criteriaHelper = new CriteriaHelper(); var criteria = SimpleExpression.Equal(new Column("Name", new Table("Spaceship", null)), "Heart of Gold"); var wherePart = criteriaHelper.ToWherePart(criteria); var actual = Postgres.SqlFormatter.FormatWherePart(wherePart); Assert.Equal("Spaceship.Name = @Name", actual); }
protected override void SetCriteria() { DetachedCriteria criteria = DetachedCriteria.For(typeof(OrderDetailView)); #region Customize criteria.Add(Expression.Eq("Type", BusinessConstants.CODE_MASTER_ORDER_TYPE_VALUE_PRODUCTION)); SecurityHelper.SetRegionSearchCriteria(criteria, "PartyTo.Code", this.CurrentUser.Code); //区域权限 OrderHelper.SetActiveOrderStatusCriteria(criteria, "Status"); //订单状态 #endregion #region Select Parameters CriteriaHelper.SetFlowCriteria(criteria, "Flow", this._criteriaParam); CriteriaHelper.SetPartyCriteria(criteria, "PartyTo.Code", this._criteriaParam); CriteriaHelper.SetStartDateCriteria(criteria, "EffDate", this._criteriaParam); CriteriaHelper.SetEndDateCriteria(criteria, "EffDate", this._criteriaParam); CriteriaHelper.SetShiftCriteria(criteria, "Shift.Code", this._criteriaParam); CriteriaHelper.SetItemCriteria(criteria, "Item.Code", this._criteriaParam); #endregion #region Projections ProjectionList projectionList = Projections.ProjectionList() .Add(Projections.Max("Id").As("Id")) .Add(Projections.Sum("OrderedQty").As("OrderedQty")) .Add(Projections.Sum("ReceivedQty").As("ReceivedQty")) .Add(Projections.Sum("RejectedQty").As("RejectedQty")) .Add(Projections.Sum("ScrapQty").As("ScrapQty")) .Add(Projections.GroupProperty("Item").As("Item")) .Add(Projections.GroupProperty("Uom").As("Uom")); if (!this._criteriaParam.ClassifiedFlow) { projectionList.Add(Projections.GroupProperty("Flow").As("Flow")); projectionList.Add(Projections.GroupProperty("Description").As("Description")); } if (!this._criteriaParam.ClassifiedParty) { projectionList.Add(Projections.GroupProperty("PartyTo").As("PartyTo")); } if (!this._criteriaParam.ClassifiedShift) { projectionList.Add(Projections.GroupProperty("Shift").As("Shift")); } if (!this._criteriaParam.ClassifiedDate) { projectionList.Add(Projections.GroupProperty("EffDate").As("EffDate")); } criteria.SetProjection(projectionList); criteria.SetResultTransformer(Transformers.AliasToBean(typeof(OrderDetailView))); #endregion DetachedCriteria selectCountCriteria = CloneHelper.DeepClone <DetachedCriteria>(criteria); selectCountCriteria.SetProjection(Projections.Count("Id")); SetSearchCriteria(criteria, selectCountCriteria); }
protected void ASPxGridView1_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { ASPxGridView grid = sender as ASPxGridView; if (e.Parameters != "patchFilterExpression" || string.IsNullOrEmpty(grid.FilterExpression)) { return; } var fieldsToReplace = GetFieldsToReplace(grid); var criteria = CriteriaHelper.ReplaceCriteriaByFieldName(fieldsToReplace, CriteriaOperator.Parse(grid.FilterExpression)); grid.FilterExpression = criteria.ToString(); }
private DetachedCriteria GetCriteria() { DetachedCriteria criteria = DetachedCriteria.For(typeof(InventoryAgingView)); SecurityHelper.SetRegionSearchCriteria(criteria, "Region.Code", this.CurrentUser.Code); //区域权限 #region Select Parameters CriteriaHelper.SetPartyCriteria(criteria, "Region.Code", this._criteriaParam); CriteriaHelper.SetLocationCriteria(criteria, "Location.Code", this._criteriaParam); CriteriaHelper.SetItemCriteria(criteria, "Item.Code", this._criteriaParam, MatchMode.Exact); CriteriaHelper.SetStartDateCriteria(criteria, "CreateDate", this._criteriaParam); CriteriaHelper.SetEndDateCriteria(criteria, "CreateDate", this._criteriaParam); #endregion return(criteria); }
private ICriteria CreateCriteria(ISession session) { AssertAllArgumentsValid(); ICriteria criteria = detachedCriteria.GetExecutableCriteria(session); criteria.SetProjection(projections); // we are not returning a tuple, so we need the result transformer if (!typeof(TResultItem).IsPrimitive && typeof(TResultItem) != typeof(object[])) { criteria.SetResultTransformer(new TypedResultTransformer <TResultItem>()); } CriteriaHelper.AddOrdersToCriteria(criteria, orders); return(criteria); }
protected override void DoSearch() { if (SearchEvent != null) { FillParameter(); if (this.rblListFormat.SelectedValue == "Detail") { object[] criteriaParam = CriteriaHelper.CollectDetailParam(this.parameter, statusList, typeList, NewItem); SearchEvent(criteriaParam, null); } else { object[] criteriaParam = CriteriaHelper.CollectMasterParam(this.parameter, statusList, typeList, NewItem); SearchEvent(criteriaParam, null); } } }
private IList <LocationTransaction> GetIssTr(List <int> orderDetIdList) { DetachedCriteria criteria = DetachedCriteria.For(typeof(OrderLocationTransaction)); criteria.CreateAlias("OrderDetail", "od"); criteria.CreateAlias("od.OrderHead", "oh"); CriteriaHelper.SetInCriteria <int>(criteria, "od.Id", orderDetIdList); criteria.Add(Expression.Eq("IOType", BusinessConstants.IO_TYPE_OUT)); criteria.SetProjection(Projections.Distinct(Projections.ProjectionList() .Add(Projections.Property("od.Id").As("OrderDetailId")) .Add(Projections.Property("Location.Code").As("Location")) .Add(Projections.Property("oh.PartyFrom.Code").As("PartyFrom")))); criteria.SetResultTransformer(Transformers.AliasToBean(typeof(LocationTransaction))); return(criteriaMgr.FindAll <LocationTransaction>(criteria)); }
/// <summary> /// Executes the specified query and return the results /// </summary> /// <param name="session">The session to execute the query in.</param> /// <returns>the result of the query</returns> public TResult Execute(ISession session) { if (detachedCriteria != null) { return(detachedCriteria.GetExecutableCriteria(session) .SetProjection(projection) .UniqueResult <TResult>()); } else { ICriteria criteria = session.CreateCriteria(RootType); CriteriaHelper.AddCriterionToCriteria(criteria, criterions); criteria.SetProjection(projection); return(criteria.UniqueResult <TResult>()); } }
protected override void DoSearch() { FillParameter(); if (this.rblListFormat.SelectedValue == "Detail") { object[] criteriaParam = CriteriaHelper.CollectDetailParam(this.parameter, statusList, typeList, NewItem); Array.Resize <object>(ref criteriaParam, 5); criteriaParam[4] = false; SearchEvent(criteriaParam, null); } else { object[] criteriaParam = CriteriaHelper.CollectMasterParam(this.parameter, statusList, typeList, NewItem); Array.Resize <object>(ref criteriaParam, 5); criteriaParam[4] = false; SearchEvent(criteriaParam, null); } }
protected override void SetCriteria() { DetachedCriteria criteria = DetachedCriteria.For(typeof(FlowView)); criteria.CreateAlias("LocationTo", "l"); criteria.CreateAlias("FlowDetail", "fd"); SecurityHelper.SetRegionSearchCriteria(criteria, "l.Region.Code", this.CurrentUser.Code); //区域权限 #region Select Parameters CriteriaHelper.SetLocationCriteria(criteria, "LocationTo.Code", this._criteriaParam); CriteriaHelper.SetItemCriteria(criteria, "fd.Item.Code", this._criteriaParam, MatchMode.Exact); CriteriaHelper.SetFlowCriteria(criteria, "Flow.Code", this._criteriaParam); #endregion DetachedCriteria selectCountCriteria = CloneHelper.DeepClone <DetachedCriteria>(criteria); selectCountCriteria.SetProjection(Projections.Count("Id")); SetSearchCriteria(criteria, selectCountCriteria); }
public override void OnSaveData() { try { this.Validate(); if (CriteriaHelper.ValidateStringAsFilterCriteria(ctrl_frEdSourceEntityRule.FilterString) && CriteriaHelper.ValidateStringAsFilterCriteria(ctrl_frEdTargetEntityRule.FilterString, true) && dxValidator.Validate()) { JarsRule saveRule = defaultBindingSource.Current as JarsRule; saveRule.SourceCriteriaString = ctrl_frEdSourceEntityRule.FilterString; saveRule.TargetCriteriaString = ctrl_frEdTargetEntityRule.FilterString; StoreJarsRule store = new StoreJarsRule() { Rule = saveRule }; JarsRuleResponse response = ServiceClient.Post(store); if (response.ResponseStatus == null) { saveRule = response.Rule; ServiceClient.Post(new JarsRulesNotification { Selector = SelectorTypes.store, FromUserName = LoggedInUser.UserName, Ids = new List <int> { response.Rule.Id } }); } base.OnSaveData(); } } catch (Exception exS) { OnExceptionEvent(exS); } }
/// <summary> /// Executes the query. /// </summary> /// <param name="session">The <c>NHibernate</c>'s <see cref="ISession"/></param> /// <returns><c>ArrayList</c> as an <c>object</c></returns> protected override object InternalExecute(ISession session) { if (detachedCriteria != null) { ICriteria criteria = detachedCriteria.GetExecutableCriteria(session); return(criteria.List()); } else if (criterias != null) { ICriteria criteria = session.CreateCriteria(RootType); CriteriaHelper.AddCriterionToCriteria(criteria, criterias); return(criteria.List()); } else { return(base.CreateQuery(session).List()); } }
protected override void SetCriteria() { DetachedCriteria criteria = DetachedCriteria.For(typeof(LocationLotDetailView)); criteria.CreateAlias("Location", "l"); #region Customize SecurityHelper.SetRegionSearchCriteria(criteria, "l.Region.Code", this.CurrentUser.Code); //区域权限 #endregion #region Select Parameters CriteriaHelper.SetLocationCriteria(criteria, "l.Code", this._criteriaParam); CriteriaHelper.SetItemCriteria(criteria, "Item.Code", this._criteriaParam); CriteriaHelper.SetLotNoCriteria(criteria, "LotNo", this._criteriaParam); #endregion DetachedCriteria selectCountCriteria = CloneHelper.DeepClone <DetachedCriteria>(criteria); selectCountCriteria.SetProjection(Projections.Count("Id")); SetSearchCriteria(criteria, selectCountCriteria); }
protected override void SetCriteria() { DetachedCriteria criteria = DetachedCriteria.For(typeof(LocationDetail)); criteria.CreateAlias("Location", "l"); #region Customize criteria.Add(Expression.Not(Expression.Eq("Qty", new decimal(0)))); SecurityHelper.SetRegionSearchCriteria(criteria, "l.Region.Code", this.CurrentUser.Code); //区域权限 #endregion #region Select Parameters CriteriaHelper.SetPartyCriteria(criteria, "l.Region.Code", this._criteriaParam); CriteriaHelper.SetLocationCriteria(criteria, "Location.Code", this._criteriaParam); CriteriaHelper.SetItemCriteria(criteria, "Item.Code", this._criteriaParam); #endregion #region Projections ProjectionList projectionList = Projections.ProjectionList() .Add(Projections.Max("Id").As("Id")) .Add(Projections.Sum("Qty").As("Qty")) .Add(Projections.GroupProperty("Item").As("Item")); if (this._criteriaParam.ClassifiedParty) { projectionList.Add(Projections.GroupProperty("l.Region").As("Region")); } if (this._criteriaParam.ClassifiedLocation) { projectionList.Add(Projections.GroupProperty("Location").As("Location")); } criteria.SetProjection(projectionList); criteria.SetResultTransformer(Transformers.AliasToBean(typeof(LocationDetail))); #endregion DetachedCriteria selectCountCriteria = CloneHelper.DeepClone <DetachedCriteria>(criteria); selectCountCriteria.SetProjection(Projections.Count("Id")); SetSearchCriteria(criteria, selectCountCriteria); }
public ActionResult Index(int?year, int?userId) { var model = new HourIndexModel(); var projects = ProjectRepository.ProjectFetchInfoList(); model.UserId = userId ?? ((IBusinessIdentity)Csla.ApplicationContext.User.Identity).UserId; var weeks = WeekCollection.GetWeeks(year ?? DateTime.Now.Year); model.Weeks = weeks; var criteria = new HourDataCriteria { Date = CriteriaHelper.ToDateRangeCriteria(weeks.StartDate, weeks.EndDate), UserId = model.UserId }; var hours = HourRepository.HourFetchInfoList(criteria); model.Hours = hours; model.Year = year ?? DateTime.Now.Year; var years = new List <int>(); for (var currentYear = year ?? DateTime.Now.Year; currentYear <= DateTime.Now.Year; currentYear++) { years.Add(currentYear); } model.Years = years; var users = UserRepository.UserFetchInfoList(projects); model.Users = users; return(this.View(model)); }
public ActionResult Index( string createdDate, string isActive, string isArchived, string modifiedDate, string projectName) { var model = new ProjectListModel(); var criteria = new ProjectDataCriteria { CreatedDate = CriteriaHelper.ToDateRangeCriteria(createdDate), IsActive = CriteriaHelper.ToBoolean(isActive), IsArchived = CriteriaHelper.ToBoolean(isArchived), Name = projectName, ModifiedDate = CriteriaHelper.ToDateRangeCriteria(modifiedDate) }; var projects = ProjectRepository.ProjectFetchInfoList(criteria); model.Projects = projects; var stories = StoryRepository.StoryFetchInfoList(projects.ToArray(), false); model.Stories = stories; var timelines = TimelineRepository.TimelineFetchInfoList( projects.Select(row => row.ProjectId).Distinct().ToArray(), SourceType.Project); model.Timelines = timelines; var sprints = SprintRepository.SprintFetchInfoList(projects.ToArray(), false); model.Sprints = sprints; model.Actions.Add("Add a project", Url.Action("Create"), "primary"); return(this.View(model)); }
public ActionResult List( string createdDate, string description, string isArchived, string isCompleted, string isOpened, string modifiedDate, int?projectId, string projectName, int?statusId, string statusName, int?storyId, int?userId, string userName) { var model = new StoryListModel(); var criteria = new StoryDataCriteria { AssignedTo = userId, AssignedToName = userName, CreatedDate = CriteriaHelper.ToDateRangeCriteria(createdDate), Description = description, IsArchived = CriteriaHelper.ToBoolean(isArchived), IsCompleted = CriteriaHelper.ToBoolean(isCompleted), IsOpened = CriteriaHelper.ToBoolean(isOpened), ModifiedDate = CriteriaHelper.ToDateRangeCriteria(modifiedDate), ProjectId = CriteriaHelper.ToArray(projectId), ProjectName = projectName, StoryId = storyId, StatusId = statusId, StatusName = statusName }; var stories = StoryRepository.StoryFetchInfoList(criteria); model.Stories = stories; return(this.View(model)); }
static void Main(string[] args) { var validSledPasswords = 0; var validTobogganPasswords = 0; foreach (var pw in Passwords.PasswordList) { var pwSplit = pw.Split(":"); var criteria = CriteriaHelper.GetCriteria(pwSplit[0]); var isSledValid = CriteriaHelper.IsSledPasswordValid(criteria, pwSplit[1].Trim()); if (isSledValid) { validSledPasswords++; } var isTobogganValid = CriteriaHelper.IsTobogganPasswordValid(criteria, pwSplit[1].Trim()); if (isTobogganValid) { validTobogganPasswords++; } } Console.WriteLine($"Number of valid sled passwords: {validSledPasswords}"); Console.WriteLine($"Number of valid Toboggan passwords: {validTobogganPasswords}"); }
protected override void SetCriteria() { DetachedCriteria selectCriteria = DetachedCriteria.For(typeof(LocationTransactionView)); #region Select Parameters CriteriaHelper.SetStartDateCriteria(selectCriteria, "EffDate", this._criteriaParam); CriteriaHelper.SetEndDateCriteria(selectCriteria, "EffDate", this._criteriaParam); CriteriaHelper.SetLocationCriteria(selectCriteria, "Loc", this._criteriaParam); //目标库位 djin 2012-08-02 if (_criteriaParam.RefLoc != null) { CriteriaHelper.SetRefLocationCriteria(selectCriteria, "RefLoc", this._criteriaParam); } //end //CriteriaHelper.SetLocationCriteria(selectCriteria, "Location.Code", this._criteriaParam); CriteriaHelper.SetItemCriteria(selectCriteria, "Item", this._criteriaParam); CriteriaHelper.SetTransactionTypeCriteria(selectCriteria, "TransType", this._criteriaParam); #endregion //Party权限 SecurityHelper.SetPartySearchCriteria(selectCriteria, "PartyFrom", this.CurrentUser.Code); SecurityHelper.SetPartySearchCriteria(selectCriteria, "PartyTo", this.CurrentUser.Code); #region Projections 默认按item,uom和location来group ProjectionList projectionList = Projections.ProjectionList() .Add(Projections.Sum("Qty").As("Qty")) .Add(Projections.GroupProperty("Id").As("Id")) .Add(Projections.GroupProperty("Item").As("Item")) .Add(Projections.GroupProperty("Uom").As("Uom")) //.Add(Projections.GroupProperty("RefOrderNo").As("RefOrderNo")) //.Add(Projections.GroupProperty("PartyFromName").As("PartyFromName")) //.Add(Projections.GroupProperty("PartyToName").As("PartyToName")) .Add(Projections.GroupProperty("Loc").As("Loc")) .Add(Projections.GroupProperty("LocName").As("LocName")) .Add(Projections.GroupProperty("ItemDescription").As("ItemDescription")) .Add(Projections.GroupProperty("TransType").As("TransType")) .Add(Projections.GroupProperty("OrderNo").As("OrderNo")) .Add(Projections.GroupProperty("IpNo").As("IpNo")) .Add(Projections.GroupProperty("RecNo").As("RecNo")) .Add(Projections.GroupProperty("LotNo").As("LotNo")); //.Add(Projections.GroupProperty("CreateUser").As("CreateUser")); if (_criteriaParam.RefLoc != null) { projectionList.Add(Projections.GroupProperty("RefLoc").As("RefLoc")); } //if (!this._criteriaParam.ClassifiedTransType) //{ // projectionList.Add(Projections.GroupProperty("TransType").As("TransType")); //} if (!this._criteriaParam.ClassifiedDate) { projectionList.Add(Projections.GroupProperty("EffDate").As("EffDate")); } if (!this._criteriaParam.ClassifiedUser) { projectionList.Add(Projections.GroupProperty("CreateUser").As("CreateUser")); } if (!this._criteriaParam.ClassifiedUser && !this._criteriaParam.ClassifiedDate) { projectionList.Add(Projections.GroupProperty("RefOrderNo").As("RefOrderNo")); projectionList.Add(Projections.GroupProperty("PartyFromName").As("PartyFromName")); projectionList.Add(Projections.GroupProperty("PartyToName").As("PartyToName")); } selectCriteria.SetProjection(projectionList); selectCriteria.SetResultTransformer(Transformers.AliasToBean(typeof(LocationTransactionView))); #endregion DetachedCriteria selectCountCriteria = CloneHelper.DeepClone <DetachedCriteria>(selectCriteria); selectCriteria.AddOrder(Order.Desc("Id")); selectCountCriteria.SetProjection(Projections.RowCount()); SetSearchCriteria(selectCriteria, selectCountCriteria); }
private void GetCriteriaList() { criteriaService.PopulateCriteriaStore(); CriteriasListBox.DataSource = CriteriaHelper.GetCriteriasDataSource(); }