public void TestUpdateCall(SOOrder order) { PXUpdate < Set <SOOrder.status, Required <SOOrder.status>, Set <SOOrder.orderType, Null> >, SOOrder, Where <SOOrder.orderNbr, Equal <Required <SOOrder.orderNbr> >, And <SOOrder.orderType, IsNotNull, And <SOOrder.orderDate, Equal <Required <SOOrder.orderDate> > > > > > .Update(this, order.Status, order.OrderNbr, order.OrderDate); //No diagnostic here // Acuminator disable once PX1015 IncorrectNumberOfSelectParameters [Justification] PXUpdate < Set <SOOrder.status, Required <SOOrder.status>, Set <SOOrder.orderType, Null> >, SOOrder, Where <SOOrder.orderNbr, Equal <Required <SOOrder.orderNbr> >, And <SOOrder.orderType, IsNotNull, And <SOOrder.orderDate, Equal <Required <SOOrder.orderDate> > > > > > .Update(this, order.Status, order.OrderDate); //diagnostic here // Acuminator disable once PX1015 IncorrectNumberOfSelectParameters [Justification] PXUpdateJoin < Set <SOOrder.status, Required <SOOrder.status>, Set <SOOrder.orderType, Null> >, SOOrder, InnerJoin <SOTran, On <SOOrder.orderNbr, Equal <SOTran.orderNbr> > >, Where <SOOrder.orderNbr, Equal <Required <SOOrder.orderNbr> >, And <SOOrder.orderType, IsNotNull, And <SOOrder.orderDate, Equal <Required <SOOrder.orderDate> > > > > > .Update(this, order.Status, order.OrderDate); //diagnostic here }
public void TestUpdateCall(SOOrder order) { PXUpdate < Set <SOOrder.status, Required <SOOrder.status>, Set <SOOrder.orderType, Null> >, SOOrder, Where <SOOrder.orderNbr, Equal <Required <SOOrder.orderNbr> >, And <SOOrder.orderType, IsNotNull, And <SOOrder.orderDate, Equal <Required <SOOrder.orderDate> > > > > > .Update(this, order.Status, order.OrderNbr, order.OrderDate); //No diagnostic here PXUpdate < Set <SOOrder.status, Required <SOOrder.status>, Set <SOOrder.orderType, Null> >, SOOrder, Where <SOOrder.orderNbr, Equal <Required <SOOrder.orderNbr> >, And <SOOrder.orderType, IsNotNull, And <SOOrder.orderDate, Equal <Required <SOOrder.orderDate> > > > > > .Update(this, order.Status, order.OrderDate); //diagnostic here PXUpdateJoin < Set <SOOrder.status, Required <SOOrder.status>, Set <SOOrder.orderType, Null> >, SOOrder, InnerJoin <SOTran, On <SOOrder.orderNbr, Equal <SOTran.orderNbr> > >, Where <SOOrder.orderNbr, Equal <Required <SOOrder.orderNbr> >, And <SOOrder.orderType, IsNotNull, And <SOOrder.orderDate, Equal <Required <SOOrder.orderDate> > > > > > .Update(this, order.Status, order.OrderDate); //diagnostic here }
public object TestVariableSearchCall(SOOrder order) { var result1 = View1.Search <SOOrder.orderNbr>(order.OrderNbr, order.OrderDate); //diagnostic here var result2 = View1.Search <SOOrder.orderNbr>(order.OrderNbr); //no diagnostic var result3 = View2.Search <SOOrder.orderNbr, SOOrder.status>(order.OrderNbr, order.Status); //diagnostic here return(result1); }
public object TestVariableSearchCall(SOOrder order) { // Acuminator disable once PX1015 IncorrectNumberOfSelectParameters [Justification] var result1 = View1.Search <SOOrder.orderNbr>(order.OrderNbr, order.OrderDate); //diagnostic here var result2 = View1.Search <SOOrder.orderNbr>(order.OrderNbr); //no diagnostic // Acuminator disable once PX1015 IncorrectNumberOfSelectParameters [Justification] var result3 = View2.Search <SOOrder.orderNbr, SOOrder.status>(order.OrderNbr, order.Status); //diagnostic here return(result1); }
public object TestComplexVariableCall(SOOrder order, bool flag) { var p1 = new[] { 1, 2 }; var p2 = new[] { 1 }; PXSelectBase <SOOrder> filtered = new PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Current <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Required <SOOrder.orderDate> > > > >(this); // Acuminator disable once PX1015 IncorrectNumberOfSelectParameters [Justification] var result1 = filtered.Select(p1); //Diagnostic here var result2 = filtered.Select(p2); if (flag) { filtered = new PXSelect <SOOrder>(this); } else { filtered = new PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Required <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Required <SOOrder.orderDate> > > > >(this); } result1 = filtered.Select(); //Should not be diagnostic here due to if statement filtered = new PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Required <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Required <SOOrder.orderDate> > > > >(this); // Acuminator disable once PX1015 IncorrectNumberOfSelectParameters [Justification] if (order.OrderDate.HasValue && filtered.Select(1).Count > 0) //Diagnostic here { EscapeReferenceMethod(filtered); filtered.Select(1); //Should not be diagnostic here due to EscapeReferenceMethod method } filtered = new PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Required <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Required <SOOrder.orderDate> > > > >(this); filtered.WhereAnd <Where <SOOrder.orderType, Equal <Required <SOOrder.orderType> > > >(); filtered.Select(1); //Should not be diagnostic here due to WhereAnd modifying method return(this); }
public virtual IEnumerable odrers() { int startRow = PXView.StartRow; var rows = PXSelect <SOOrder, Where <SOOrder.orderType, Equal <Required <SOOrder.orderType> > > > .Select(this, "INV"); foreach (var row in rows) { SOOrder order = new SOOrder(); order.OrderType = row.GetItem <SOOrder>().OrderType; order.OrderNbr = row.GetItem <SOOrder>().OrderNbr; } return(rows); }
public object TestVariableCallWithOptionalParams(SOOrder order, bool flag) { var p1 = new[] { 1, 2 }; var p2 = new[] { 1 }; PXSelectBase <SOOrder> filtered = new PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Optional <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Required <SOOrder.orderDate> > > > >(this); var result1 = filtered.Select(p1); var result2 = filtered.Select(p2); var result3 = filtered.Select(1, 2, 3); //Diagnostic here return(result1); }
public object TestVariableCallWithOptionalParams(SOOrder order, bool flag) { var p1 = new[] { 1, 2 }; var p2 = new[] { 1 }; PXSelectBase <SOOrder> filtered = new PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Optional <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Required <SOOrder.orderDate> > > > >(this); var result1 = filtered.Select(p1); var result2 = filtered.Select(p2); // Acuminator disable once PX1015 IncorrectNumberOfSelectParameters [Justification] var result3 = filtered.Select(1, 2, 3); //Diagnostic here return(result1); }
public IEnumerable GetFilteredOrders(SOOrder order, bool useSimpeSelect, bool useDate) { PXSelectBase <SOOrder> filtered = new PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Current <SOOrder.orderNbr> >, And <SOOrder.orderType, Greater <Required <SOOrder.orderType> > > > >(this); if (useSimpeSelect) { filtered = new PXSelect <SOOrder>(this); } var queryRes = filtered.Select(new[] { "SO00001" }); // no warning here due to if check if (queryRes.Count > 0) { return(queryRes); } var parametersFirstSet = new[] { "SO00001", "INV" }; var parametersSecondSet = new[] { "SO00001" }; filtered = new PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Required <SOOrder.orderNbr> >, And <SOOrder.orderType, Greater <Required <SOOrder.orderType> > > > >(this); queryRes = filtered.Select(parametersFirstSet); if (queryRes.Count == 0) { return(queryRes); } if (order.OrderDate.HasValue && filtered.Select(parametersSecondSet).Count > 0) { return(null); } AddExtraCondition(filtered); // no alerts after the modifying method return(filtered.Select()); }
private void ChangeDisplayName(PXCache cache, SOOrder row) { if (cache == null) { PXArgumentException e = new PXArgumentException(nameof(cache), "incorrect PXCache value"); throw e; } if (row == null) { throw new PXArgumentException(nameof(row), "incorrect SOOrder value"); } string newDisplayName = null; if (row.OrderNbr.Equals(SOOrderExt.SpecialOrderNbr, StringComparison.Ordinal)) { newDisplayName = PXLocalizer.Localize("Special Text"); } else if (row.OrderNbr.Equals(SOOrderExt.SpecialOrderNbr2, StringComparison.Ordinal)) { newDisplayName = PXLocalizer.Localize(Messages.SpecialText, typeof(Messages).FullName); } else if (row.OrderNbr.Equals(SOOrderExt.SpecialOrderNbr3, StringComparison.Ordinal)) { newDisplayName = PXLocalizer.LocalizeFormat(SOOrderExt.SpecialOrderNbr3, row.OrderNbr); } else if (row.OrderNbr.Equals(SOOrderExt.SpecialOrderNbr4, StringComparison.Ordinal)) { newDisplayName = PXLocalizer.Localize(string.Format(Messages.SpecialTextToFormat, row.OrderNbr)); } if (string.IsNullOrEmpty(newDisplayName)) { return; } PXUIFieldAttribute.SetDisplayName <SOOrderExt.customText>(cache, newDisplayName); }
public object TestStaticSearchCall(SOOrder order) { var result1 = PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Current <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Current <SOOrder.orderDate> > > > > .Search <SOOrder.orderNbr>(this, order.OrderNbr, order.OrderDate); //diagnostic here var result2 = PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Current <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Current <SOOrder.orderDate> > > > > .Search <SOOrder.orderNbr>(this, order.OrderNbr); //no diagnostic var result3 = PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Current <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Required <SOOrder.orderDate> > > > > .Search <SOOrder.orderNbr, SOOrder.status>(this, order.OrderNbr, order.Status); //diagnostic here return(result1); }
public SOOrder StaticFbqlCall_Incorrect() { object[] currents = null; SOOrder result1 = PXSelect <SOOrder, Where <SOOrder.orderType, Equal <@P.AsString>, And <SOOrder.orderNbr, Equal <SOOrder.orderNbr.FromCurrent>, And <SOOrder.status, Equal <SOOrder.status.AsOptional> > > >, OrderBy < Asc <SOOrder.orderNbr> > > .SelectSingleBound(this, currents); var result2 = PXSelect <SOOrder, Where <SOOrder.orderType, Equal <@P.AsString>, And <SOOrder.orderNbr, Equal <SOOrder.orderNbr.FromCurrent>, And <SOOrder.status, Equal <SOOrder.status.AsOptional> > > >, OrderBy < Asc <SOOrder.orderNbr> > > .SelectSingleBound(this, currents, "INV", "000001", "Hold"); return(result1 ?? result2); }
public object TestStaticSearchCall(SOOrder order) { // Acuminator disable once PX1015 IncorrectNumberOfSelectParameters [Justification] var result1 = PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Current <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Current <SOOrder.orderDate> > > > > .Search <SOOrder.orderNbr>(this, order.OrderNbr, order.OrderDate); //diagnostic here var result2 = PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Current <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Current <SOOrder.orderDate> > > > > .Search <SOOrder.orderNbr>(this, order.OrderNbr); //no diagnostic // Acuminator disable once PX1015 IncorrectNumberOfSelectParameters [Justification] var result3 = PXSelect <SOOrder, Where <SOOrder.orderNbr, Equal <Current <SOOrder.orderNbr> >, And <SOOrder.orderDate, Greater <Required <SOOrder.orderDate> > > > > .Search <SOOrder.orderNbr, SOOrder.status>(this, order.OrderNbr, order.Status); //diagnostic here return(result1); }
public void PerformRelease(SOOrder order) { var setup = PXSelect <SOSetup> .SelectSingleBound(new PXGraph(), null); // some release logic }