private string _GetUnboundValue <T>(ItemPickerMapping im) where T : class, IBqlField { IIProductLineFilter filter = PXSelect <IIProductLineFilter, Where <IIProductLineFilter.productLineID, Equal <Current <IIProductLine.productLineID> >, And <IIProductLineFilter.filterID, Equal <Current <T> > > >, OrderBy <Asc <IIProductLineFilter.sortOrder> > > .Select(this, im.ProductLineID).RowCast <IIProductLineFilter>()?.FirstOrDefault(); switch (filter?.MappingColumnNbr) { case 1: return(im.Column1); case 2: return(im.Column2); case 3: return(im.Column3); case 4: return(im.Column4); case 5: return(im.Column5); case 6: return(im.Column6); case 7: return(im.Column7); case 8: return(im.Column8); case 9: return(im.Column9); } return(""); }
private void _SetUnboundValue <T>(ItemPickerMapping im, string value) where T : class, IBqlField { IIProductLineFilter filter = PXSelect <IIProductLineFilter, Where <IIProductLineFilter.productLineID, Equal <Current <IIProductLine.productLineID> >, And <IIProductLineFilter.filterID, Equal <Current <T> > > >, OrderBy <Asc <IIProductLineFilter.sortOrder> > > .Select(this, im.ProductLineID).RowCast <IIProductLineFilter>()?.FirstOrDefault(); switch (filter?.MappingColumnNbr) { case 1: im.Column1 = value; return; case 2: im.Column2 = value; return; case 3: im.Column3 = value; return; case 4: im.Column4 = value; return; case 5: im.Column5 = value; return; case 6: im.Column6 = value; return; case 7: im.Column7 = value; return; case 8: im.Column8 = value; return; case 9: im.Column9 = value; return; } }
protected virtual void ItemPickerMapping_RowUpdated(PXCache sender, PXRowUpdatedEventArgs e) { ItemPickerMapping im = e.Row as ItemPickerMapping; if ((im == null) || (im.ProductLineID == null)) { return; } sender.SetDefaultExt <ItemPickerMapping.description>(e.Row); }
protected virtual void ItemPickerMapping_RowSelecting(PXCache sender, PXRowSelectingEventArgs e) { ItemPickerMapping im = e.Row as ItemPickerMapping; if ((im == null) || (im.ProductLineID == null)) { return; } _GetUnboundValues(im); }
private void _SetUnboundValues(ItemPickerMapping im) { _SetUnboundValue <IIProductLine.unboundColumn1>(im, im.UnboundValueColumn1); _SetUnboundValue <IIProductLine.unboundColumn2>(im, im.UnboundValueColumn2); _SetUnboundValue <IIProductLine.unboundColumn3>(im, im.UnboundValueColumn3); _SetUnboundValue <IIProductLine.unboundColumn4>(im, im.UnboundValueColumn4); _SetUnboundValue <IIProductLine.unboundColumn5>(im, im.UnboundValueColumn5); _SetUnboundValue <IIProductLine.unboundColumn6>(im, im.UnboundValueColumn6); _SetUnboundValue <IIProductLine.unboundColumn7>(im, im.UnboundValueColumn7); _SetUnboundValue <IIProductLine.unboundColumn8>(im, im.UnboundValueColumn8); _SetUnboundValue <IIProductLine.unboundColumn9>(im, im.UnboundValueColumn9); }
private void _GetUnboundValues(ItemPickerMapping im) { im.UnboundValueColumn1 = _GetUnboundValue <IIProductLine.unboundColumn1>(im); im.UnboundValueColumn2 = _GetUnboundValue <IIProductLine.unboundColumn2>(im); im.UnboundValueColumn3 = _GetUnboundValue <IIProductLine.unboundColumn3>(im); im.UnboundValueColumn4 = _GetUnboundValue <IIProductLine.unboundColumn4>(im); im.UnboundValueColumn5 = _GetUnboundValue <IIProductLine.unboundColumn5>(im); im.UnboundValueColumn6 = _GetUnboundValue <IIProductLine.unboundColumn6>(im); im.UnboundValueColumn7 = _GetUnboundValue <IIProductLine.unboundColumn7>(im); im.UnboundValueColumn8 = _GetUnboundValue <IIProductLine.unboundColumn8>(im); im.UnboundValueColumn9 = _GetUnboundValue <IIProductLine.unboundColumn9>(im); }
private bool _CheckUniqueness(ItemPickerMapping im) { var mappingsSet = new HashSet <MappingsForSet>(); foreach (ItemPickerMapping im1 in ItemPickerMappings.Select()) { if (im1 != im) { mappingsSet.Add(new MappingsForSet(im1.Column1, im1.Column2, im1.Column3, im1.Column4, im1.Column5, im1.Column6, im1.Column7, im1.Column8, im1.Column9, im1.InventoryID)); } } return(mappingsSet.Add(new MappingsForSet(im.Column1, im.Column2, im.Column3, im.Column4, im.Column5, im.Column6, im.Column7, im.Column8, im.Column9, im.InventoryID))); }
protected virtual void ItemPickerMapping_RowUpdating(PXCache sender, PXRowUpdatingEventArgs e) { ItemPickerMapping im = e.NewRow as ItemPickerMapping; if ((im == null) || (im.ProductLineID == null)) { return; } _SetUnboundValues(im); if (!_CheckUniqueness(im)) { sender.RaiseExceptionHandling <ItemPickerMapping.unboundValueColumn1>(im, im.UnboundValueColumn1, new PXSetPropertyException("A combination of mapping values and inventory ID must be unique. Make the combination of values unique and save.")); e.Cancel = true; } }