41180c08-31e0-4d55-822e-3cb65a39d311 Clearable Custom Field Demonstrates how a custom field can be cleared by adding a context menu which appears when the custom field is right-clicked.&#13;&#10;&#13;&#10;This example adds a custom field "Preferred Split Warehouse" to the logical warehouses grid of the Warehouse Maintenance form. true false 0 Jiwa Financials 7.2.1.0 using System; using System.Collections; using System.Collections.Generic; using System.Data; using System.Diagnostics; using JiwaFinancials.Jiwa; using System.Windows.Forms; using System.Data.SqlClient; using System.Drawing; #region "LineCustomFieldPlugin" public class LineCustomFieldPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void FormatCell(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { if (CustomField.PluginCustomField.Name == "Preferred Split Warehouse" && FormObject is JiwaFinancials.Jiwa.JiwaWarehousesUI.frmMain) { JiwaFinancials.Jiwa.JiwaWarehousesUI.frmMain warehouseMaintenanceForm = (JiwaFinancials.Jiwa.JiwaWarehousesUI.frmMain)FormObject; System.Windows.Forms.ContextMenuStrip contextMenuStrip = warehouseMaintenanceForm.GenericObjectCollection.GetValue<System.Windows.Forms.ContextMenuStrip>("Preferred Split Warehouse Context Menu"); if (contextMenuStrip == null) { contextMenuStrip = new System.Windows.Forms.ContextMenuStrip(); contextMenuStrip.Name = "contextMenuStrip"; System.Windows.Forms.ToolStripMenuItem clearToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem(); clearToolStripMenuItem.Name = "ClearToolStripMenuItem"; clearToolStripMenuItem.Size = new System.Drawing.Size(185, 22); clearToolStripMenuItem.Text = "Clear"; clearToolStripMenuItem.Click += delegate(object sender, System.EventArgs e) { clearToolStripMenuItem_Click(sender, e, CustomField, warehouseMaintenanceForm); }; contextMenuStrip.Items.Add(clearToolStripMenuItem); warehouseMaintenanceForm.GenericObjectCollection.SetOrAdd<System.Windows.Forms.ContextMenuStrip>("Preferred Split Warehouse Context Menu", contextMenuStrip); warehouseMaintenanceForm.grdLogicalWarehouses.CellClick += delegate(object sender, FarPoint.Win.Spread.CellClickEventArgs e) { grdLogicalWarehouses_CellClick(sender, e, contextMenuStrip, CustomField, warehouseMaintenanceForm); }; } } } public void grdLogicalWarehouses_CellClick(object sender, FarPoint.Win.Spread.CellClickEventArgs e, System.Windows.Forms.ContextMenuStrip contextMenuStrip, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaWarehousesUI.frmMain warehouseMaintenanceForm) { if (e.Button == System.Windows.Forms.MouseButtons.Right) { if (e.ColumnHeader == false && e.Column == warehouseMaintenanceForm.grdLogicalWarehouses.ActiveSheet.Columns[CustomField.PluginCustomField.GridColumnName].Index) { contextMenuStrip.Show(System.Windows.Forms.Cursor.Position); } } } public void clearToolStripMenuItem_Click(object sender, System.EventArgs e, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaWarehousesUI.frmMain warehouseMaintenanceForm) { string key = warehouseMaintenanceForm.grdLogicalWarehouses.ActiveSheet.ActiveCell.Value.ToString(); JiwaFinancials.Jiwa.JiwaWarehouses.LogicalWarehouse logicalWarehouse = warehouseMaintenanceForm.PhysicalWarehouse.LogicalWarehouses[key]; logicalWarehouse.CustomFieldValues.SetValue<string>(CustomField.PluginCustomField.Name, ""); } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { if (CustomField.PluginCustomField.Name == "Preferred Split Warehouse") { if (string.IsNullOrWhiteSpace(CustomFieldValue.Contents) == false) { JiwaFinancials.Jiwa.JiwaApplication.Entities.LogicalWarehouse logicalWarehouse = BusinessLogicHost.Manager.EntityFactory.CreateEntity<JiwaFinancials.Jiwa.JiwaApplication.Entities.LogicalWarehouse>(); try { logicalWarehouse.ReadRecord(CustomFieldValue.Contents); CustomFieldValue.DisplayContents = logicalWarehouse.ToString(); } catch(JiwaFinancials.Jiwa.JiwaApplication.Exceptions.RecordNotFoundException notFoundException) { CustomFieldValue.DisplayContents = "-select-"; } } else { CustomFieldValue.DisplayContents = "-select-"; } } } public void ButtonClicked(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Col, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaLineCustomFieldValues HostItem, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { if (CustomField.PluginCustomField.Name == "Preferred Split Warehouse") { JiwaFinancials.Jiwa.JiwaApplication.Entities.LogicalWarehouse logicalWarehouse = BusinessLogicHost.Manager.EntityFactory.CreateEntity<JiwaFinancials.Jiwa.JiwaApplication.Entities.LogicalWarehouse>(); logicalWarehouse.Search(FormObject.Form); if (string.IsNullOrWhiteSpace(logicalWarehouse.RecID) == false) { CustomFieldValue.DisplayContents = logicalWarehouse.ToString(); CustomFieldValue.Contents = logicalWarehouse.RecID; } } } } #endregion Report CSharp ebaf535f-7936-4489-b1ff-2e4ca24fe99a Warehouse Maintenance JiwaFinancials.Jiwa.JiwaWarehousesUI.frmMain c9849a2d-0ca8-49e3-a5e0-d8524ad44266 JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaApplication.dll 586b4aff-cd76-4886-8b9d-2b8860496bfb mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 9a064f81-2ca2-442e-ac41-7a228c12ca15 System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System\v4.0_4.0.0.0__b77a5c561934e089\System.dll 3d351245-2fa0-4982-ad74-0dc8a0b39ef0 System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Drawing.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Drawing\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Drawing.dll f30eae31-aaa3-460f-a8d8-df85e446a5c1 JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaODBC.dll 2265fe51-2229-4b71-992c-dfe1cd728ec9 System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Data.dll C:\Windows\Microsoft.Net\assembly\GAC_32\System.Data\v4.0_4.0.0.0__b77a5c561934e089\System.Data.dll aa9ae034-5ffb-446d-9e71-6b634b052306 System.Xml, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Xml.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Xml\v4.0_4.0.0.0__b77a5c561934e089\System.Xml.dll 7b3152b6-7d57-4812-8981-809e4cd74781 System.Runtime.Serialization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Runtime.Serialization.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Runtime.Serialization\v4.0_4.0.0.0__b77a5c561934e089\System.Runtime.Serialization.dll bd5c77a9-52cc-4035-8647-cab0393964db System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Windows.Forms.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Windows.Forms\v4.0_4.0.0.0__b77a5c561934e089\System.Windows.Forms.dll 262d43f3-a830-4f82-9b68-6e353a50feac JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaServiceModel.dll 532f7f46-f4d8-49e5-9249-0e3f0facaedf Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.Misc.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.Misc.v13.1.dll 177e289a-388c-475d-815e-72196c385019 Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinEditors.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinEditors.v13.1.dll 0606dc56-ced7-45dd-aae2-40b4e7fafbb7 Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.v13.1.dll 4c49eb39-b4b8-451d-bba0-018afeb4c7f4 Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinExplorerBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll 6c3a082d-0da7-4286-a5e1-4fdcecec8422 Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTree.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinTree.v13.1.dll 8b7a3f87-238f-4f6f-8389-8893c730c598 FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\Windows\assembly\GAC_MSIL\FarPoint.Win.Spread\8.35.20151.0__327c3516b1b18457\FarPoint.Win.Spread.dll e2ca30ff-f535-4e2a-a4f5-9978776dc226 Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinTabControl.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinTabControl.v13.1.dll ce3f771a-593e-4f55-ace6-2e5060867cb4 Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Shared.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Shared.v13.1.dll bea30ab3-cb54-46d2-9b94-caf012739209 Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinToolbars.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinToolbars.v13.1.dll b6851e18-fb87-4fd6-ad7a-f170e6994aa7 Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinStatusBar.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinStatusBar.v13.1.dll cfeb7b8b-07e9-47ae-aa01-83ce5de24474 Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinSchedule.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinSchedule.v13.1.dll 7b46587c-898e-4f77-9058-7e9bc58f1e3f Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinListView.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinListView.v13.1.dll bf935d48-3df3-46a3-829e-7068ba90f4f8 System.Core, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Core.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Core\v4.0_4.0.0.0__b77a5c561934e089\System.Core.dll 59752b66-6ad5-4dbd-953e-2e720687564b JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaEncryption.dll c019bcce-ad94-42e5-8789-a25cf1377d37 System.Security, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a System.Security.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Security\v4.0_4.0.0.0__b03f5f7f11d50a3a\System.Security.dll 7e378339-1da7-4514-8625-687d4f530291 Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.UltraWinGrid.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.UltraWinGrid.v13.1.dll ce9ca60a-661d-42ac-ae1f-83a8f05ec572 Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Infragistics4.Win.AppStylistSupport.v13.1\v4.0_13.1.20131.2060__7dd5c3163f2cd0cb\Infragistics4.Win.AppStylistSupport.v13.1.dll 0bb8c054-f4ff-4744-9555-35d546717e08 JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaLib.dll 9fc7e9a6-6927-4a09-876c-bc5a5c1cdb93 FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\Windows\assembly\GAC_MSIL\FarPoint.Win\8.35.20151.0__327c3516b1b18457\FarPoint.Win.dll 733cdaec-eb0c-4f3b-abcf-f5bd89afa128 ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\ServiceStack.Interfaces.dll 6acb2cc8-8eb3-46f7-9362-b8f74c2ad4db JiwaWarehousesUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaWarehousesUI.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaWarehousesUI.dll 36a4e1b2-fd70-4e8e-8b4b-d056a5fa318f Microsoft.VisualBasic, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.VisualBasic.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\Microsoft.VisualBasic\v4.0_10.0.0.0__b03f5f7f11d50a3a\Microsoft.VisualBasic.dll 3c708db0-ab5b-4aa2-bc56-893e1dd26b4c JiwaWarehouses, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaWarehouses.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaWarehouses.dll 3ba2623c-8a0c-4e02-8751-b1718ddeef73 JiwaBillOfMaterials, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaBillOfMaterials.dll C:\VSTS\Jiwa 7\07.02.00\Built Files\JiwaBillOfMaterials.dll 00eee20a-7c22-47d6-af31-f4f795b13286 Preferred Split Warehouse First preference of warehouse to split orders to 1 Lookup Logical Warehouse