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
}
