protected virtual void ImportAttributeMappingPropertiesInit(object sender, PXImportAttribute.MappingPropertiesInitEventArgs e) { HashSet <string> hiddenFields = new HashSet <string>(); List <string> forcedFields = new List <string>(); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeBAccountID))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeBAccountIDCopy))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.processed))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.processed))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.createDocument))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.curyID))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.curyTranAmt))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.drCr))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.headerRefNbr))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeLocationID))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeLocationID1))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeLocationIDCopy))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.tranType))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.pMInstanceID))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.pMInstanceIDCopy))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.curyTotalAmt))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeMatched))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.paymentMethodID))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.paymentMethodID1))); hiddenFields.Add(Details.Cache.GetField(typeof(CABankTran.paymentMethodIDCopy))); hiddenFields.Add("CuryRate"); hiddenFields.Add("CuryViewState"); forcedFields.Add(Details.Cache.GetField(typeof(CABankTran.payeeName))); forcedFields.Add(Details.Cache.GetField(typeof(CABankTran.tranCode))); for (int i = 0; i < e.Names.Count; i++) { if (hiddenFields.Contains(e.Names[i])) { e.Names.RemoveAt(i); e.DisplayNames.RemoveAt(i); i--; } } foreach (string field in forcedFields) { if (!e.Names.Contains(field)) { e.Names.Add(field); PXUIFieldAttribute uiAttribute = Details.Cache.GetAttributes(field).FirstOrDefault(a => a is PXUIFieldAttribute) as PXUIFieldAttribute; if (uiAttribute != null) { e.DisplayNames.Add(uiAttribute.DisplayName); } else { e.DisplayNames.Add(field); } } } }
private void MappingPropertiesInit(object sender, PXImportAttribute.MappingPropertiesInitEventArgs e) { string isCostedFieldName = location.Cache.GetField(typeof(INLocation.isCosted)); if (!e.Names.Contains(isCostedFieldName)) { e.Names.Add(isCostedFieldName); e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INLocation.taskID>(location.Cache)); } string projectTaskFieldName = location.Cache.GetField(typeof(INLocation.taskID)); if (!e.Names.Contains(projectTaskFieldName)) { e.Names.Add(projectTaskFieldName); e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INLocation.taskID>(location.Cache)); } }
public void MappingPropertiesInit(object sender, PXImportAttribute.MappingPropertiesInitEventArgs e) { e.Names.Add(typeof(INPIDetail.inventoryID).Name); e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INPIDetail.inventoryID>(PIDetail.Cache)); if (PXAccess.FeatureInstalled <FeaturesSet.subItem>()) { e.Names.Add(typeof(INPIDetail.subItemID).Name); e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INPIDetail.subItemID>(PIDetail.Cache)); } if (PXAccess.FeatureInstalled <FeaturesSet.warehouseLocation>()) { e.Names.Add(typeof(INPIDetail.locationID).Name); e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INPIDetail.locationID>(PIDetail.Cache)); } if (PXAccess.FeatureInstalled <FeaturesSet.lotSerialTracking>()) { e.Names.Add(typeof(INPIDetail.lotSerialNbr).Name); e.DisplayNames.Add(PXUIFieldAttribute.GetDisplayName <INPIDetail.lotSerialNbr>(PIDetail.Cache)); } }
/// <summary> /// Restricts the set of columns in Property Name combo box during Excel Import, /// so as to display only fields that are visible in the UI grid. /// </summary> protected virtual void ImportAttributeMappingPropertiesHandler(object sender, PXImportAttribute.MappingPropertiesInitEventArgs e) { e.Names.Clear(); e.DisplayNames.Clear(); IEnumerable <Type> fields = new Type[] { typeof(PMTran.branchID), typeof(PMTran.inventoryID), typeof(PMTran.description), typeof(PMTran.bAccountID), typeof(PMTran.uOM), typeof(PMTran.billableQty), typeof(PMTran.date), typeof(PMTran.caseID) }; IEnumerable <string> fieldNames = fields.Select(field => field.Name.Capitalize()); IEnumerable <string> displayNames = fields.Select(field => PXUIFieldAttribute.GetDisplayName(UnBilled.Cache, field.Name)); e.Names.Add(fieldNames); e.DisplayNames.Add(displayNames); }