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