e98fc5ad-ded0-4465-9c65-047f32d540fa PO Custom Line Fields Lock Demonstrates how to selectively lock or unlock Purchase Order Line custom fields.&#13;&#10;&#13;&#10;Adds two text custom fields - FieldOne and FieldTwo - FieldOne is locked, FieldTwo is unlocked. true false 0 Jiwa Financials 7.2.1.0 using System; using System.Collections; using System.Collections.Generic; using System.Data; using JiwaFinancials.Jiwa; using System.Windows.Forms; using System.Data.SqlClient; #region "FormPlugin" public class FormPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaFormPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void SetupBeforeHandlers(JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm JiwaForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm JiwaForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { if (JiwaForm is JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm) { JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm poForm = (JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm)JiwaForm; poForm.PurchaseOrder.ReadEnd += delegate(object sender, System.EventArgs e) { PurchaseOrder_ReadEnd(sender, e, Plugin, poForm); }; poForm.PurchaseOrder.CreateEnd += delegate(object sender, System.EventArgs e) { PurchaseOrder_CreateEnd(sender, e, Plugin, poForm); }; poForm.PurchaseOrder.CopyEnd += delegate(object sender, System.EventArgs e) { PurchaseOrder_CopyEnd(sender, e, Plugin, poForm); }; poForm.PurchaseOrder.DeserialiseEnd += delegate(object sender, System.EventArgs e, object poco) { PurchaseOrder_DeserialiseEnd(sender, e, poco, Plugin, poForm); }; poForm.PurchaseOrder.Lines.Added += delegate(JiwaFinancials.Jiwa.JiwaPurchaseOrders.Line line) { PurchaseOrder_Lines_Added(line, Plugin, poForm); }; poForm.PurchaseOrder.Lines.Changed += delegate(JiwaFinancials.Jiwa.JiwaPurchaseOrders.Line line, System.ComponentModel.PropertyChangedEventArgs e) { PurchaseOrder_Lines_Changed(line, e, Plugin, poForm); }; } } private void PurchaseOrder_ReadEnd(object sender, System.EventArgs e, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin plugin, JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm poForm) { SetCustomFieldsLockStatus(poForm, plugin); } private void PurchaseOrder_CreateEnd(object sender, System.EventArgs e, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin plugin, JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm poForm) { } private void PurchaseOrder_CopyEnd(object sender, System.EventArgs e, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin plugin, JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm poForm) { SetCustomFieldsLockStatus(poForm, plugin); } private void PurchaseOrder_DeserialiseEnd(object sender, System.EventArgs e, object poco, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin plugin, JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm poForm) { SetCustomFieldsLockStatus(poForm, plugin); } private void PurchaseOrder_Lines_Added(JiwaFinancials.Jiwa.JiwaPurchaseOrders.Line line, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin plugin, JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm poForm) { SetCustomFieldsLockStatus(poForm, plugin, line); } private void PurchaseOrder_Lines_Changed(JiwaFinancials.Jiwa.JiwaPurchaseOrders.Line line, System.ComponentModel.PropertyChangedEventArgs e, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin plugin, JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm poForm) { SetCustomFieldsLockStatus(poForm, plugin, line); } private void SetCustomFieldsLockStatus(JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm poForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin plugin) { for(int row = 0; row < poForm.LinesJiwaGrid.ActiveSheet.RowCount; row++) { SetCustomFieldsLockStatus(poForm, plugin, row); } } private void SetCustomFieldsLockStatus(JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm poForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin plugin, JiwaFinancials.Jiwa.JiwaPurchaseOrders.Line line) { // find which row of the grid this line is shown on for(int row = 0; row < poForm.LinesJiwaGrid.ActiveSheet.RowCount; row++) { if (poForm.LinesJiwaGrid.get_GridText("RecID", row).ToString() == line.RecID) { SetCustomFieldsLockStatus(poForm, plugin, row); break; } } } private void SetCustomFieldsLockStatus(JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.MainForm poForm, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin plugin, int row) { poForm.LinesJiwaGrid.LockColumn(true, string.Format("{0}.{1}", plugin.Name, "FieldOne"), row); poForm.LinesJiwaGrid.LockColumn(false, string.Format("{0}.{1}", plugin.Name, "FieldTwo"), row); } } #endregion Abort CSharp aab5fbb0-e03e-4bd0-ae43-7420f5e52dc2 Purchase Orders JiwaFinancials.Jiwa.JiwaPurchaseOrdersUI.PurchaseOrders d8dfb8ca-da76-4457-928a-5d048d22fe02 JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll E:\VSTS\Jiwa 7\MikesV7JiwaBranch\Built Files\JiwaApplication.dll 7fb4216f-ac73-4f3d-a963-8cc1ec6797ff mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll d4d498c5-1b00-4758-b5c6-8bf988e59a05 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 964397f7-114b-4af4-8cc3-043f70d6b377 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 3cf98250-ff95-4eb8-b996-be0fac6f502f JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll E:\VSTS\Jiwa 7\MikesV7JiwaBranch\Built Files\JiwaODBC.dll 15d4bc34-3c40-4811-b12b-0b351bbeea00 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 e399f40f-39c7-47ec-97cf-ad600620d9f5 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 4334ebf0-5b85-462c-962c-8387d90e61f5 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 39401dfe-5fba-4924-aa09-066164fcee91 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 68cbd8f7-94e2-43ef-9241-6e43a308dc8b 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 00d19b02-9bcd-49e6-a66e-398fdc2fc6f7 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 15f58433-8a81-47ab-9a03-acc83c918d55 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 a75e5f0d-b8b4-4cba-8f33-274b79197c82 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 5bf203fc-35f6-48bf-ae42-547bd9b88411 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 e68f11d0-7e7d-4c26-9822-328595730d54 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 f9313f46-0baf-445d-82b1-3f4e7114b567 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 cf8a43e5-0006-4bbd-8830-12395bbe7aba 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 15bd6258-3e85-4c39-9dfe-2a40facb69e1 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 9c62d7ea-f8b3-4981-b70d-e55c525ea3db 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 25108f0a-1f8e-4c74-a577-07bc10faae1b 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 9862af8a-c826-4051-b742-536d5991a0f3 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 734a38f3-a80a-48d7-b9a2-72d958463a6f 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 1dc66610-604e-4860-be8b-20f4e049fddc 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 f84a7292-4a19-4c24-9c30-f3aab6a7349f JiwaPurchaseOrdersUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaPurchaseOrdersUI.dll E:\VSTS\Jiwa 7\MikesV7JiwaBranch\Built Files\JiwaPurchaseOrdersUI.dll edba1611-6873-48a5-b63b-31df9cb5d512 JiwaPurchaseOrders, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaPurchaseOrders.dll E:\VSTS\Jiwa 7\MikesV7JiwaBranch\Built Files\JiwaPurchaseOrders.dll bbc3b006-0153-4855-a8e5-98197be556b0 FieldOne 1 Text Purchase Order Lines d531fb3c-d588-430e-9574-af00dd4b732d FieldTwo 2 Text Purchase Order Lines