74f01dc6-95aa-45a8-8fe0-27f356464389 Inventory Export to CSV Provides a new form and business logic to export inventory items to CSV file. &#13;&#10;&#13;&#10;On the documents tab of this plugin is a SQL Script to create the form entry. &#13;&#10;Once this has been run, log out of Jiwa, log in and add the new form "Export Inventory" to the menu using the Menu Maintenance form. true false 0 Jiwa Financials 7.2.1.0 using Microsoft.VisualBasic; 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; using ServiceStack; using ServiceStack.DataAnnotations; using ServiceStack.Model; using System.Text; using System.Linq; #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) { } } #endregion #region "BusinessLogicPlugin" public class BusinessLogicPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogicPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic JiwaBusinessLogic, JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion #region "ApplicationManagerPlugin" public class ApplicationManagerPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaApplicationManagerPlugin { public override object InitializeLifetimeService() { // returning null here will prevent the lease manager // from deleting the Object. return null; } public void Setup(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion #region "CustomFieldPlugin" public class CustomFieldPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldPlugin { 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.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } 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.IJiwaCustomFieldValues HostObject, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomField CustomField, JiwaFinancials.Jiwa.JiwaApplication.CustomFields.CustomFieldValue CustomFieldValue) { } } #endregion #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) { } 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) { } 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) { } } #endregion #region "SystemSettingPlugin" public class SystemSettingPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaSystemSettingPlugin { 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.SystemSettings.Setting SystemSetting) { } public void ReadData(JiwaFinancials.Jiwa.JiwaApplication.IJiwaBusinessLogic BusinessLogicHost, JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid GridObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaForm FormObject, int Row, JiwaFinancials.Jiwa.JiwaApplication.SystemSettings.Setting SystemSetting) { } 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.SystemSettings.Setting SystemSetting) { } } #endregion #region "ScheduledExecutionPlugin" public class ScheduledExecutionPlugin : System.MarshalByRefObject, JiwaFinancials.Jiwa.JiwaApplication.IJiwaScheduledExecutionPlugin { public void Execute(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin, JiwaFinancials.Jiwa.JiwaApplication.Schedule.Schedule Schedule) { } public void OnServiceStart(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } public void OnServiceStopping(JiwaFinancials.Jiwa.JiwaApplication.Plugin.Plugin Plugin) { } } #endregion namespace JiwaFinancials.Jiwa.ExportInventory { #region "User Interface" public partial class ExportInventoryForm : JiwaFinancials.Jiwa.JiwaApplication.ProcessAction.UserInterface { private ExportInventory exportInventory; public bool Displaying; #region "Properties" public ExportInventory ExportInventory { get { return exportInventory; } } #endregion #region "Setup" public ExportInventoryForm() { InitializeComponent(); this.Text = "Export Inventory"; } public override void SetupBeforeHandlers() { base.SetupBeforeHandlers(); this.MdiParent = Manager.MDIParentForm; SetupObjects(); } public override void Setup() { base.Setup(); SetupForm(); AddHandlers(); } public void SetupForm() { SetupControls(); Display(); DisplayRanges(); } public override void AddHandlers() { rangesJiwaGrid.ButtonClicked += rangesJiwaGrid_ButtonClicked; rangesJiwaGrid.Change += rangesJiwaGrid_Change; PreviewItemsUltraButton.Click += PreviewItemsUltraButton_Click; FileBrowseUltraButton.Click += FileBrowseUltraButton_Click; ExportFileUltraTextEditor.ValueChanged += ExportFileUltraTextEditor_ValueChanged; ExportUltraButton.Click += ExportUltraButton_Click; exportInventory.PropertyChanged += exportInventory_PropertyChanged; exportInventory.Ranges.PropertyChanged += exportInventory_Ranges_PropertyChanged; exportInventory.ProcessEnd += exportInventory_ProcessEnd; base.AddHandlers(); } private void SetupObjects() { exportInventory = Manager.BusinessLogicFactory.CreateBusinessLogic<ExportInventory>(this); } public override void Start() { this.Show(); } private void SetupControls() { UltraToolbarsManager1.Tools["ID_RecordProcess"].SharedProps.Visible = false; SetupRangesGrid(); } private void SetupRangesGrid() { rangesJiwaGrid.AddColumn("PartNo", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), ExportInventory.Ranges.PartNo.Title, 10, false, true, false, false, 50); rangesJiwaGrid.AddColumn("PartNoLookup", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaLookupButtonCellType(Manager), "", 10, false); rangesJiwaGrid.AddColumn("Description", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), ExportInventory.Ranges.Description.Title, 10, false, true, false, false, 50); rangesJiwaGrid.AddColumn("DescriptionLookup", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaLookupButtonCellType(Manager), "", 10, false); rangesJiwaGrid.AddColumn("Classification", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), ExportInventory.Ranges.Classification.Title, 10, false, true, false, false, 50); rangesJiwaGrid.AddColumn("ClassificationLookup", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaLookupButtonCellType(Manager), "", 10, false); rangesJiwaGrid.AddColumn("Category1", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), ExportInventory.Ranges.Category1.Title, 10, false, true, false, false, 50); rangesJiwaGrid.AddColumn("Category1Lookup", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaLookupButtonCellType(Manager), "", 10, false); rangesJiwaGrid.AddColumn("Category2", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), ExportInventory.Ranges.Category2.Title, 10, false, true, false, false, 50); rangesJiwaGrid.AddColumn("Category2Lookup", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaLookupButtonCellType(Manager), "", 10, false); rangesJiwaGrid.AddColumn("Category3", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), ExportInventory.Ranges.Category3.Title, 10, false, true, false, false, 50); rangesJiwaGrid.AddColumn("Category3Lookup", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaLookupButtonCellType(Manager), "", 10, false); rangesJiwaGrid.AddColumn("Category4", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), ExportInventory.Ranges.Category4.Title, 10, false, true, false, false, 50); rangesJiwaGrid.AddColumn("Category4Lookup", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaLookupButtonCellType(Manager), "", 10, false); rangesJiwaGrid.AddColumn("Category5", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), ExportInventory.Ranges.Category5.Title, 10, false, true, false, false, 50); rangesJiwaGrid.AddColumn("Category5Lookup", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaLookupButtonCellType(Manager), "", 10, false); rangesJiwaGrid.AddColumn("Supplier", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaTextCellType(), ExportInventory.Ranges.Supplier.Title, 10, false, true, false, false, 50); rangesJiwaGrid.AddColumn("SupplierLookup", new JiwaFinancials.Jiwa.JiwaApplication.JiwaManageGrid.JiwaLookupButtonCellType(Manager), "", 10, false); rangesJiwaGrid.SetupComplete(); rangesJiwaGrid.ActiveSheet.RowCount = 2; } #endregion #region "Display" public void Display() { bool oldDisplaying = Displaying; try { Displaying = true; ExportFileUltraTextEditor.Text = ExportInventory.ExportFileNameAndPath; } finally { Displaying = oldDisplaying; } } public void DisplayRanges() { rangesJiwaGrid.set_GridText("PartNo", 0, ExportInventory.Ranges.PartNo.From.PartNo); rangesJiwaGrid.set_GridText("PartNo", 1, ExportInventory.Ranges.PartNo.To.PartNo); rangesJiwaGrid.set_GridText("Description", 0, ExportInventory.Ranges.Description.From.Description); rangesJiwaGrid.set_GridText("Description", 1, ExportInventory.Ranges.Description.To.Description); rangesJiwaGrid.set_GridText("Classification", 0, ExportInventory.Ranges.Classification.From.Description); rangesJiwaGrid.set_GridText("Classification", 1, ExportInventory.Ranges.Classification.To.Description); rangesJiwaGrid.set_GridText("Category1", 0, ExportInventory.Ranges.Category1.From.Description); rangesJiwaGrid.set_GridText("Category1", 1, ExportInventory.Ranges.Category1.To.Description); rangesJiwaGrid.set_GridText("Category2", 0, ExportInventory.Ranges.Category2.From.Description); rangesJiwaGrid.set_GridText("Category2", 1, ExportInventory.Ranges.Category2.To.Description); rangesJiwaGrid.set_GridText("Category3", 0, ExportInventory.Ranges.Category3.From.Description); rangesJiwaGrid.set_GridText("Category3", 1, ExportInventory.Ranges.Category3.To.Description); rangesJiwaGrid.set_GridText("Category4", 0, ExportInventory.Ranges.Category4.From.Description); rangesJiwaGrid.set_GridText("Category4", 1, ExportInventory.Ranges.Category4.To.Description); rangesJiwaGrid.set_GridText("Category5", 0, ExportInventory.Ranges.Category5.From.Description); rangesJiwaGrid.set_GridText("Category5", 1, ExportInventory.Ranges.Category5.To.Description); rangesJiwaGrid.set_GridText("Supplier", 0, ExportInventory.Ranges.Supplier.From.CreditorAccountNo); rangesJiwaGrid.set_GridText("Supplier", 1, ExportInventory.Ranges.Supplier.To.CreditorAccountNo); rangesJiwaGrid.ActiveSheet.RowHeader.ColumnCount = 1; rangesJiwaGrid.ActiveSheet.RowHeaderVisible = true; rangesJiwaGrid.ActiveSheet.RowHeader.Cells[0, 0].Value = "From"; rangesJiwaGrid.ActiveSheet.RowHeader.Cells[1, 0].Value = "To"; } #endregion #region "Event Handlers" private void rangesJiwaGrid_ButtonClicked(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e) { FarPoint.Win.Spread.Column column = rangesJiwaGrid.ActiveSheet.Columns[e.Column]; switch (column.Tag.ToString().ToLower()) { case "partnolookup": if (e.Row == 0) { ExportInventory.Ranges.PartNo.From.Search(this, "", ""); } else { ExportInventory.Ranges.PartNo.To.Search(this, "", ""); } break; case "descriptionlookup": if (e.Row == 0) { ExportInventory.Ranges.Description.From.Search(this, "", ""); } else { ExportInventory.Ranges.Description.To.Search(this, "", ""); } break; case "classificationlookup": if (e.Row == 0) { ExportInventory.Ranges.Classification.From.Search(this); } else { ExportInventory.Ranges.Classification.To.Search(this); } break; case "category1lookup": if (e.Row == 0) { ExportInventory.Ranges.Category1.From.Search(this); } else { ExportInventory.Ranges.Category1.To.Search(this); } break; case "category2lookup": if (e.Row == 0) { ExportInventory.Ranges.Category2.From.Search(this); } else { ExportInventory.Ranges.Category2.To.Search(this); } break; case "category3lookup": if (e.Row == 0) { ExportInventory.Ranges.Category3.From.Search(this); } else { ExportInventory.Ranges.Category3.To.Search(this); } break; case "category4lookup": if (e.Row == 0) { ExportInventory.Ranges.Category4.From.Search(this); } else { ExportInventory.Ranges.Category4.To.Search(this); } break; case "category5lookup": if (e.Row == 0) { ExportInventory.Ranges.Category5.From.Search(this); } else { ExportInventory.Ranges.Category5.To.Search(this); } break; case "Supplierlookup": if (e.Row == 0) { ExportInventory.Ranges.Supplier.From.Search(this); } else { ExportInventory.Ranges.Supplier.To.Search(this); } break; } } private void rangesJiwaGrid_Change(object sender, FarPoint.Win.Spread.ChangeEventArgs e) { FarPoint.Win.Spread.Column column = rangesJiwaGrid.ActiveSheet.Columns[e.Column]; switch (column.Tag.ToString().ToLower()) { case "partno": if (e.Row == 0) { ExportInventory.Ranges.PartNo.From.PartNo = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } else { ExportInventory.Ranges.PartNo.To.PartNo = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } break; case "description": if (e.Row == 0) { ExportInventory.Ranges.Description.From.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } else { ExportInventory.Ranges.Description.To.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } break; case "classification": if (e.Row == 0) { ExportInventory.Ranges.Classification.From.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } else { ExportInventory.Ranges.Classification.To.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } break; case "category1": if (e.Row == 0) { ExportInventory.Ranges.Category1.From.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } else { ExportInventory.Ranges.Category1.To.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } break; case "category2": if (e.Row == 0) { ExportInventory.Ranges.Category2.From.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } else { ExportInventory.Ranges.Category2.To.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } break; case "category3": if (e.Row == 0) { ExportInventory.Ranges.Category3.From.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } else { ExportInventory.Ranges.Category3.To.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } break; case "category4": if (e.Row == 0) { ExportInventory.Ranges.Category4.From.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } else { ExportInventory.Ranges.Category4.To.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } break; case "category5": if (e.Row == 0) { ExportInventory.Ranges.Category5.From.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } else { ExportInventory.Ranges.Category5.To.Description = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } break; case "Supplier": if (e.Row == 0) { ExportInventory.Ranges.Supplier.From.CreditorAccountNo = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } else { ExportInventory.Ranges.Supplier.To.CreditorAccountNo = rangesJiwaGrid.get_GridText(e.Column, e.Row).ToString(); } break; } } private void FileBrowseUltraButton_Click(object sender, EventArgs e) { DialogSave.OverwritePrompt = true; DialogSave.Filter = "CSV Files (*.csv)|*.csv|All Files (*.*)|*.*"; if (DialogSave.ShowDialog() == System.Windows.Forms.DialogResult.OK) { if (DialogSave.FileName.Trim().Length > 0) { ExportInventory.ExportFileNameAndPath = DialogSave.FileName; } } } private void ExportFileUltraTextEditor_ValueChanged(object sender, EventArgs e) { if (!Displaying) { ExportInventory.ExportFileNameAndPath = ExportFileUltraTextEditor.Text; } } private void PreviewItemsUltraButton_Click(object sender, EventArgs e) { ExportInventory.PreviewItems(itemsJiwaGrid); itemsJiwaGrid.ActiveSheet.RowHeader.ColumnCount = 1; itemsJiwaGrid.ActiveSheet.RowHeaderVisible = true; itemsJiwaGrid.ActiveSheet.RowHeader.Columns[0].Width = MeasureDisplayStringWidth(itemsJiwaGrid.CreateGraphics(), "1234567", itemsJiwaGrid.Font); } private void ExportUltraButton_Click(object sender, EventArgs e) { if (System.IO.File.Exists(ExportInventory.ExportFileNameAndPath)) { if (Manager.DisplayMessage(this, String.Format("The file '{0}' already exists - do you wish to overwrite?", ExportInventory.ExportFileNameAndPath), MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1) == DialogResult.No) { return; } } ExportInventory.Process(); } private void exportInventory_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e) { Display(); } private void exportInventory_Ranges_PropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e) { DisplayRanges(); } private void exportInventory_ProcessEnd(object sender, System.EventArgs e) { Manager.DisplayMessage(this, String.Format("Export of '{0}' completed.", exportInventory.ExportFileNameAndPath), MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1); } #endregion static public int MeasureDisplayStringWidth(Graphics graphics, string text, Font font) { System.Drawing.StringFormat format = new System.Drawing.StringFormat(); System.Drawing.RectangleF rect = new System.Drawing.RectangleF(0, 0, 1000, 1000); System.Drawing.CharacterRange[] ranges = { new System.Drawing.CharacterRange(0, text.Length) }; System.Drawing.Region[] regions = new System.Drawing.Region[1]; format.SetMeasurableCharacterRanges(ranges); regions = graphics.MeasureCharacterRanges(text, font, rect, format); rect = regions[0].GetBounds(graphics); return (int)(rect.Right + 1.0f); } } #region "Designer Generated Code" partial class ExportInventoryForm { /// <summary> /// Required designer variable. /// </summary> private System.ComponentModel.IContainer components = null; /// <summary> /// Clean up any resources being used. /// </summary> /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param> protected override void Dispose(bool disposing) { if (disposing && (components != null)) { components.Dispose(); } base.Dispose(disposing); } #region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); FarPoint.Win.Spread.EnhancedFocusIndicatorRenderer enhancedFocusIndicatorRenderer1 = new FarPoint.Win.Spread.EnhancedFocusIndicatorRenderer(); FarPoint.Win.Spread.EnhancedScrollBarRenderer enhancedScrollBarRenderer1 = new FarPoint.Win.Spread.EnhancedScrollBarRenderer(); FarPoint.Win.Spread.EnhancedScrollBarRenderer enhancedScrollBarRenderer2 = new FarPoint.Win.Spread.EnhancedScrollBarRenderer(); FarPoint.Win.Spread.InputMap itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal; FarPoint.Win.Spread.EnhancedScrollBarRenderer enhancedScrollBarRenderer3 = new FarPoint.Win.Spread.EnhancedScrollBarRenderer(); FarPoint.Win.Spread.EnhancedScrollBarRenderer enhancedScrollBarRenderer4 = new FarPoint.Win.Spread.EnhancedScrollBarRenderer(); FarPoint.Win.Spread.InputMap rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal; this.ultraToolTipManager1 = new Infragistics.Win.UltraWinToolTip.UltraToolTipManager(this.components); this.ultraPanel1 = new Infragistics.Win.Misc.UltraPanel(); this.ExportUltraButton = new Infragistics.Win.Misc.UltraButton(); this.FileBrowseUltraButton = new Infragistics.Win.Misc.UltraButton(); this.ExportFileUltraTextEditor = new Infragistics.Win.UltraWinEditors.UltraTextEditor(); this.ExportFileUltraLabel = new Infragistics.Win.Misc.UltraLabel(); this.previewItemsUltraGroupBox = new Infragistics.Win.Misc.UltraGroupBox(); this.itemsJiwaGrid = new JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid(); this.rangesUltraGroupBox = new Infragistics.Win.Misc.UltraGroupBox(); this.PreviewItemsUltraButton = new Infragistics.Win.Misc.UltraButton(); this.rangesJiwaGrid = new JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid(); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal = new FarPoint.Win.Spread.InputMap(); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent = new FarPoint.Win.Spread.InputMap(); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal = new FarPoint.Win.Spread.InputMap(); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent = new FarPoint.Win.Spread.InputMap(); ((System.ComponentModel.ISupportInitialize)(this.UltraToolbarsManager1)).BeginInit(); this.UserInterface_Fill_Panel.ClientArea.SuspendLayout(); this.UserInterface_Fill_Panel.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.UltraStatusBar1)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.InboxControlStyler1)).BeginInit(); this.ultraPanel1.ClientArea.SuspendLayout(); this.ultraPanel1.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.ExportFileUltraTextEditor)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.previewItemsUltraGroupBox)).BeginInit(); this.previewItemsUltraGroupBox.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.itemsJiwaGrid)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.rangesUltraGroupBox)).BeginInit(); this.rangesUltraGroupBox.SuspendLayout(); ((System.ComponentModel.ISupportInitialize)(this.rangesJiwaGrid)).BeginInit(); this.SuspendLayout(); // // _UserInterface_Toolbars_Dock_Area_Left // this._UserInterface_Toolbars_Dock_Area_Left.InitialResizeAreaExtent = 4; this._UserInterface_Toolbars_Dock_Area_Left.Size = new System.Drawing.Size(4, 554); // // _UserInterface_Toolbars_Dock_Area_Right // this._UserInterface_Toolbars_Dock_Area_Right.Location = new System.Drawing.Point(1047, 147); this._UserInterface_Toolbars_Dock_Area_Right.Size = new System.Drawing.Size(4, 554); // // _UserInterface_Toolbars_Dock_Area_Top // this._UserInterface_Toolbars_Dock_Area_Top.Size = new System.Drawing.Size(1051, 147); // // _UserInterface_Toolbars_Dock_Area_Bottom // this._UserInterface_Toolbars_Dock_Area_Bottom.InitialResizeAreaExtent = 0; this._UserInterface_Toolbars_Dock_Area_Bottom.Location = new System.Drawing.Point(0, 701); this._UserInterface_Toolbars_Dock_Area_Bottom.Size = new System.Drawing.Size(1051, 0); // // UltraToolbarsManager1 // this.UltraToolbarsManager1.MenuSettings.ForceSerialization = true; this.UltraToolbarsManager1.Ribbon.FileMenuStyle = Infragistics.Win.UltraWinToolbars.FileMenuStyle.None; this.UltraToolbarsManager1.Ribbon.QuickAccessToolbar.Visible = false; this.UltraToolbarsManager1.Ribbon.Visible = true; this.UltraToolbarsManager1.ToolbarSettings.ForceSerialization = true; // // UserInterface_Fill_Panel // // // UserInterface_Fill_Panel.ClientArea // this.UserInterface_Fill_Panel.ClientArea.Controls.Add(this.ultraPanel1); this.UserInterface_Fill_Panel.Location = new System.Drawing.Point(4, 147); this.UserInterface_Fill_Panel.Size = new System.Drawing.Size(1043, 554); // // UltraStatusBar1 // this.UltraStatusBar1.Location = new System.Drawing.Point(0, 701); this.UltraStatusBar1.Size = new System.Drawing.Size(1051, 23); // // ultraToolTipManager1 // this.ultraToolTipManager1.ContainingControl = this; // // ultraPanel1 // // // ultraPanel1.ClientArea // this.ultraPanel1.ClientArea.Controls.Add(this.ExportUltraButton); this.ultraPanel1.ClientArea.Controls.Add(this.FileBrowseUltraButton); this.ultraPanel1.ClientArea.Controls.Add(this.ExportFileUltraTextEditor); this.ultraPanel1.ClientArea.Controls.Add(this.ExportFileUltraLabel); this.ultraPanel1.ClientArea.Controls.Add(this.previewItemsUltraGroupBox); this.ultraPanel1.ClientArea.Controls.Add(this.rangesUltraGroupBox); this.ultraPanel1.Dock = System.Windows.Forms.DockStyle.Fill; this.ultraPanel1.Location = new System.Drawing.Point(0, 0); this.ultraPanel1.Name = "ultraPanel1"; this.ultraPanel1.Size = new System.Drawing.Size(1043, 554); this.ultraPanel1.TabIndex = 0; // // ExportUltraButton // this.ExportUltraButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.ExportUltraButton.Location = new System.Drawing.Point(954, 519); this.ExportUltraButton.Name = "ExportUltraButton"; this.ExportUltraButton.Size = new System.Drawing.Size(75, 23); this.ExportUltraButton.TabIndex = 16; this.ExportUltraButton.Text = "Export"; // // FileBrowseUltraButton // this.FileBrowseUltraButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); this.FileBrowseUltraButton.Location = new System.Drawing.Point(643, 519); this.FileBrowseUltraButton.Name = "FileBrowseUltraButton"; this.FileBrowseUltraButton.Size = new System.Drawing.Size(75, 23); this.FileBrowseUltraButton.TabIndex = 15; this.FileBrowseUltraButton.Text = "Browse..."; // // ExportFileUltraTextEditor // this.ExportFileUltraTextEditor.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); this.ExportFileUltraTextEditor.Location = new System.Drawing.Point(95, 521); this.ExportFileUltraTextEditor.Name = "ExportFileUltraTextEditor"; this.ExportFileUltraTextEditor.Size = new System.Drawing.Size(542, 21); this.ExportFileUltraTextEditor.TabIndex = 14; // // ExportFileUltraLabel // this.ExportFileUltraLabel.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left))); this.ExportFileUltraLabel.Location = new System.Drawing.Point(14, 525); this.ExportFileUltraLabel.Name = "ExportFileUltraLabel"; this.ExportFileUltraLabel.Size = new System.Drawing.Size(75, 23); this.ExportFileUltraLabel.TabIndex = 13; this.ExportFileUltraLabel.Text = "Export File"; this.ExportFileUltraLabel.Appearance.BackColor = System.Drawing.Color.Transparent; // // previewItemsUltraGroupBox // this.previewItemsUltraGroupBox.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.previewItemsUltraGroupBox.Controls.Add(this.itemsJiwaGrid); this.previewItemsUltraGroupBox.Location = new System.Drawing.Point(8, 170); this.previewItemsUltraGroupBox.Name = "previewItemsUltraGroupBox"; this.previewItemsUltraGroupBox.Size = new System.Drawing.Size(1027, 329); this.previewItemsUltraGroupBox.TabIndex = 1; this.previewItemsUltraGroupBox.Text = "Preview Items"; // // itemsJiwaGrid // this.itemsJiwaGrid.AccessibleDescription = ""; this.itemsJiwaGrid.AllowColumnMove = true; this.itemsJiwaGrid.AllowColumnMoveMultiple = true; this.itemsJiwaGrid.AllowGrouping = false; this.itemsJiwaGrid.AllowSorting = true; this.itemsJiwaGrid.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.itemsJiwaGrid.ButtonDrawMode = FarPoint.Win.Spread.ButtonDrawModes.CurrentRow; this.itemsJiwaGrid.ClipboardOptions = FarPoint.Win.Spread.ClipboardOptions.ColumnHeaders; this.itemsJiwaGrid.CustomColumnXML = ""; this.itemsJiwaGrid.EditModePermanent = true; this.itemsJiwaGrid.EditModeReplace = true; this.itemsJiwaGrid.FocusRenderer = enhancedFocusIndicatorRenderer1; this.itemsJiwaGrid.HorizontalScrollBar.Buttons = new FarPoint.Win.Spread.FpScrollBarButtonCollection("BackwardLineButton,ThumbTrack,ForwardLineButton"); this.itemsJiwaGrid.HorizontalScrollBar.Name = ""; this.itemsJiwaGrid.HorizontalScrollBar.Renderer = enhancedScrollBarRenderer1; this.itemsJiwaGrid.HorizontalScrollBar.TabIndex = 2; this.itemsJiwaGrid.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.itemsJiwaGrid.InputMapWhenAncestorOfFocusedNormal = null; this.itemsJiwaGrid.Location = new System.Drawing.Point(6, 19); this.itemsJiwaGrid.Name = "itemsJiwaGrid"; this.itemsJiwaGrid.RetainSelectionBlock = false; this.itemsJiwaGrid.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Both; this.itemsJiwaGrid.selectedCellRanges = null; this.itemsJiwaGrid.ShowCellErrors = true; this.itemsJiwaGrid.ShowingTotals = false; this.itemsJiwaGrid.Size = new System.Drawing.Size(1015, 304); this.itemsJiwaGrid.Skin = FarPoint.Win.Spread.DefaultSpreadSkins.Office2007; this.itemsJiwaGrid.SourceCollection = null; this.InboxControlStyler1.SetStyleSettings(this.itemsJiwaGrid, new Infragistics.Win.AppStyling.Runtime.InboxControlStyleSettings(Infragistics.Win.DefaultableBoolean.Default)); this.itemsJiwaGrid.TabIndex = 0; this.itemsJiwaGrid.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Floating; this.itemsJiwaGrid.TypeCurrencyDecimalPlaces = new decimal(new int[] { 2, 0, 0, 0}); this.itemsJiwaGrid.VerticalScrollBar.Buttons = new FarPoint.Win.Spread.FpScrollBarButtonCollection("BackwardLineButton,ThumbTrack,ForwardLineButton"); this.itemsJiwaGrid.VerticalScrollBar.Name = ""; this.itemsJiwaGrid.VerticalScrollBar.Renderer = enhancedScrollBarRenderer2; this.itemsJiwaGrid.VerticalScrollBar.TabIndex = 3; this.itemsJiwaGrid.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Delete, System.Windows.Forms.Keys.None), "DeleteKey"); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Up, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToPreviousRow); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Down, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextRow); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Left, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToPreviousColumnVisual); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Right, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnVisual); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Up, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousRow); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Down, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextRow); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Left, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousColumnVisual); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Right, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextColumnVisual); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Up, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToPreviousRow); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Down, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToNextRow); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Left, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToPreviousColumnVisual); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Right, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnVisual); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Up, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousRow); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Down, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextRow); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Left, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousColumnVisual); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Right, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextColumnVisual); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.PageUp, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToPreviousPageOfRows); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Next, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextPageOfRows); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.PageUp, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToPreviousPageOfColumns); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Next, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToNextPageOfColumns); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.PageUp, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousPageOfRows); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Next, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextPageOfRows); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.PageUp, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousPageOfColumns); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Next, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextPageOfColumns); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Home, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToFirstColumn); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.End, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToLastColumn); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Home, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToFirstCell); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.End, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToLastCell); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Home, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToFirstColumn); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.End, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToLastColumn); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Home, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToFirstCell); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.End, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToLastCell); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Space, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.SelectColumn); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Space, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.SelectSheet); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Escape, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.CancelEditing); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Return, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.StopEditing); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Tab, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnWrap); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Tab, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToPreviousColumnWrap); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.F2, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.ClearCell); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.F3, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.DateTimeNow); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.F4, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.ShowSubEditor); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Down, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Alt | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ComboShowList); itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Up, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Alt | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ComboShowList); this.itemsJiwaGrid.SetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused, FarPoint.Win.Spread.OperationMode.Normal, itemsJiwaGrid_InputMapWhenAncestorOfFocusedNormal); // // rangesUltraGroupBox // this.rangesUltraGroupBox.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.rangesUltraGroupBox.Controls.Add(this.PreviewItemsUltraButton); this.rangesUltraGroupBox.Controls.Add(this.rangesJiwaGrid); this.rangesUltraGroupBox.Location = new System.Drawing.Point(8, 6); this.rangesUltraGroupBox.Name = "rangesUltraGroupBox"; this.rangesUltraGroupBox.Size = new System.Drawing.Size(1027, 158); this.rangesUltraGroupBox.TabIndex = 0; this.rangesUltraGroupBox.Text = "Ranges"; // // PreviewItemsUltraButton // this.PreviewItemsUltraButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right))); this.PreviewItemsUltraButton.Location = new System.Drawing.Point(936, 129); this.PreviewItemsUltraButton.Name = "PreviewItemsUltraButton"; this.PreviewItemsUltraButton.Size = new System.Drawing.Size(85, 23); this.PreviewItemsUltraButton.TabIndex = 10; this.PreviewItemsUltraButton.Text = "Preview Items"; // // rangesJiwaGrid // this.rangesJiwaGrid.AccessibleDescription = ""; this.rangesJiwaGrid.AllowColumnMove = true; this.rangesJiwaGrid.AllowColumnMoveMultiple = true; this.rangesJiwaGrid.AllowGrouping = false; this.rangesJiwaGrid.AllowSorting = true; this.rangesJiwaGrid.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.rangesJiwaGrid.ButtonDrawMode = FarPoint.Win.Spread.ButtonDrawModes.CurrentRow; this.rangesJiwaGrid.ClipboardOptions = FarPoint.Win.Spread.ClipboardOptions.ColumnHeaders; this.rangesJiwaGrid.CustomColumnXML = ""; this.rangesJiwaGrid.EditModePermanent = true; this.rangesJiwaGrid.EditModeReplace = true; this.rangesJiwaGrid.FocusRenderer = enhancedFocusIndicatorRenderer1; this.rangesJiwaGrid.HorizontalScrollBar.Buttons = new FarPoint.Win.Spread.FpScrollBarButtonCollection("BackwardLineButton,ThumbTrack,ForwardLineButton"); this.rangesJiwaGrid.HorizontalScrollBar.Name = ""; this.rangesJiwaGrid.HorizontalScrollBar.Renderer = enhancedScrollBarRenderer3; this.rangesJiwaGrid.HorizontalScrollBar.TabIndex = 2; this.rangesJiwaGrid.HorizontalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; this.rangesJiwaGrid.InputMapWhenAncestorOfFocusedNormal = null; this.rangesJiwaGrid.Location = new System.Drawing.Point(6, 18); this.rangesJiwaGrid.Name = "rangesJiwaGrid"; this.rangesJiwaGrid.RetainSelectionBlock = false; this.rangesJiwaGrid.ScrollBarTrackPolicy = FarPoint.Win.Spread.ScrollBarTrackPolicy.Both; this.rangesJiwaGrid.selectedCellRanges = null; this.rangesJiwaGrid.ShowCellErrors = true; this.rangesJiwaGrid.ShowingTotals = false; this.rangesJiwaGrid.Size = new System.Drawing.Size(1015, 105); this.rangesJiwaGrid.Skin = FarPoint.Win.Spread.DefaultSpreadSkins.Office2007; this.rangesJiwaGrid.SourceCollection = null; this.InboxControlStyler1.SetStyleSettings(this.rangesJiwaGrid, new Infragistics.Win.AppStyling.Runtime.InboxControlStyleSettings(Infragistics.Win.DefaultableBoolean.Default)); this.rangesJiwaGrid.TabIndex = 0; this.rangesJiwaGrid.TextTipPolicy = FarPoint.Win.Spread.TextTipPolicy.Floating; this.rangesJiwaGrid.TypeCurrencyDecimalPlaces = new decimal(new int[] { 2, 0, 0, 0}); this.rangesJiwaGrid.VerticalScrollBar.Buttons = new FarPoint.Win.Spread.FpScrollBarButtonCollection("BackwardLineButton,ThumbTrack,ForwardLineButton"); this.rangesJiwaGrid.VerticalScrollBar.Name = ""; this.rangesJiwaGrid.VerticalScrollBar.Renderer = enhancedScrollBarRenderer4; this.rangesJiwaGrid.VerticalScrollBar.TabIndex = 3; this.rangesJiwaGrid.VerticalScrollBarPolicy = FarPoint.Win.Spread.ScrollBarPolicy.AsNeeded; rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Delete, System.Windows.Forms.Keys.None), "DeleteKey"); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Up, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToPreviousRow); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Down, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextRow); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Left, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToPreviousColumnVisual); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Right, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnVisual); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Up, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousRow); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Down, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextRow); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Left, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousColumnVisual); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Right, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextColumnVisual); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Up, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToPreviousRow); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Down, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToNextRow); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Left, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToPreviousColumnVisual); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Right, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnVisual); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Up, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousRow); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Down, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextRow); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Left, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousColumnVisual); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Right, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextColumnVisual); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.PageUp, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToPreviousPageOfRows); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Next, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextPageOfRows); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.PageUp, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToPreviousPageOfColumns); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Next, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToNextPageOfColumns); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.PageUp, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousPageOfRows); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Next, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextPageOfRows); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.PageUp, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToPreviousPageOfColumns); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Next, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToNextPageOfColumns); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Home, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToFirstColumn); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.End, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToLastColumn); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Home, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToFirstCell); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.End, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToLastCell); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Home, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToFirstColumn); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.End, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToLastColumn); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Home, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToFirstCell); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.End, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ExtendToLastCell); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Space, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.SelectColumn); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Space, ((System.Windows.Forms.Keys)(((System.Windows.Forms.Keys.Control | System.Windows.Forms.Keys.Shift) | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.SelectSheet); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Escape, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.CancelEditing); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Return, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.StopEditing); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Tab, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.MoveToNextColumnWrap); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Tab, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Shift | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.MoveToPreviousColumnWrap); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.F2, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.ClearCell); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.F3, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.DateTimeNow); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.F4, System.Windows.Forms.Keys.None), FarPoint.Win.Spread.SpreadActions.ShowSubEditor); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Down, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Alt | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ComboShowList); rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal.Parent.Put(new FarPoint.Win.Spread.Keystroke(System.Windows.Forms.Keys.Up, ((System.Windows.Forms.Keys)((System.Windows.Forms.Keys.Alt | System.Windows.Forms.Keys.None)))), FarPoint.Win.Spread.SpreadActions.ComboShowList); this.rangesJiwaGrid.SetInputMap(FarPoint.Win.Spread.InputMapMode.WhenAncestorOfFocused, FarPoint.Win.Spread.OperationMode.Normal, rangesJiwaGrid_InputMapWhenAncestorOfFocusedNormal); // // ExportInventoryForm // this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F); this.ClientSize = new System.Drawing.Size(1051, 724); this.Name = "ExportInventoryForm"; this.InboxControlStyler1.SetStyleSettings(this, new Infragistics.Win.AppStyling.Runtime.InboxControlStyleSettings(Infragistics.Win.DefaultableBoolean.Default)); ((System.ComponentModel.ISupportInitialize)(this.UltraToolbarsManager1)).EndInit(); this.UserInterface_Fill_Panel.ClientArea.ResumeLayout(false); this.UserInterface_Fill_Panel.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.UltraStatusBar1)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.InboxControlStyler1)).EndInit(); this.ultraPanel1.ClientArea.ResumeLayout(false); this.ultraPanel1.ClientArea.PerformLayout(); this.ultraPanel1.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.ExportFileUltraTextEditor)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.previewItemsUltraGroupBox)).EndInit(); this.previewItemsUltraGroupBox.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.itemsJiwaGrid)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.rangesUltraGroupBox)).EndInit(); this.rangesUltraGroupBox.ResumeLayout(false); ((System.ComponentModel.ISupportInitialize)(this.rangesJiwaGrid)).EndInit(); this.ResumeLayout(false); } #endregion private Infragistics.Win.Misc.UltraPanel ultraPanel1; private Infragistics.Win.UltraWinToolTip.UltraToolTipManager ultraToolTipManager1; private Infragistics.Win.Misc.UltraGroupBox rangesUltraGroupBox; private JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid rangesJiwaGrid; private Infragistics.Win.Misc.UltraGroupBox previewItemsUltraGroupBox; public Infragistics.Win.Misc.UltraButton FileBrowseUltraButton; public Infragistics.Win.UltraWinEditors.UltraTextEditor ExportFileUltraTextEditor; public Infragistics.Win.Misc.UltraLabel ExportFileUltraLabel; public Infragistics.Win.Misc.UltraButton ExportUltraButton; public Infragistics.Win.Misc.UltraButton PreviewItemsUltraButton; private JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid itemsJiwaGrid; } #endregion #endregion #region "Business Logic" public class ExportInventory : JiwaFinancials.Jiwa.JiwaApplication.BusinessLogic.ProcessAction { private Ranges ranges; private string exportFileNameAndPath; private string storedProcedureName = "usp_JIWA_Inventory_ItemList"; public Ranges Ranges { get { return ranges; } } public string ExportFileNameAndPath { get { return exportFileNameAndPath; } set { exportFileNameAndPath = value; NotifyPropertyChanged("ExportFileNameAndPath"); Manager.JLib.SetProfileKey(Manager.Database.JiwaLoginUserID, ClientClassName, "ExportFileNameAndPath", ExportFileNameAndPath); } } public string StoredProcedureName { get { return storedProcedureName; } set { storedProcedureName = value; NotifyPropertyChanged("StoredProcedureName"); } } public override void Process() { OnProcessStart(); SqlDataReader SQLReader = null; try { var db = Manager.Database; using (SqlCommand SQLCmd = new SqlCommand(StoredProcedureName, db.SQLConnection, db.SQLTransaction)) { SQLCmd.CommandType = CommandType.StoredProcedure; foreach (SqlParameter SQLParam in Ranges.SQLParams) { SqlParameter newParam = new SqlParameter(SQLParam.ParameterName, SQLParam.DbType) { Value = SQLParam.Value }; SQLCmd.Parameters.Add(newParam); } SQLReader = db.ExecuteReader(SQLCmd); if (SQLReader.HasRows) { // First result set is the column schema, skip that as it's only used by the UI for grid construction SQLReader.NextResult(); } StringBuilder sb = new StringBuilder(); // Append the column header var columnNames = Enumerable.Range(0, SQLReader.FieldCount).Select(SQLReader.GetName).ToList(); sb.AppendLine(string.Join(",", columnNames)); // Now append the data while (SQLReader.Read()) { for (int columnCounter = 0; columnCounter < SQLReader.FieldCount; columnCounter++) { if (columnCounter > 0) { sb.Append(","); } sb.AppendFormat("\"{0}\"", SQLReader.GetValue(columnCounter).ToString().Replace("\"", "\"\"")); } sb.AppendLine(); } SQLReader.Close(); // Write to file System.IO.File.WriteAllText(ExportFileNameAndPath, sb.ToString()); } } finally { if ((SQLReader != null)) { SQLReader.Close(); } } OnProcessEnding(); OnProcessEnd(); } public override void Setup() { base.Setup(); ranges = new Ranges(Manager); ranges.ResetDefaults(); object exportFileNameAndPathValue = null; Manager.JLib.GetProfileKey(Manager.Database.JiwaLoginUserID, ClientClassName, "ExportFileNameAndPath", ref exportFileNameAndPathValue); if (exportFileNameAndPathValue != null) { exportFileNameAndPath = (string)exportFileNameAndPathValue; } } public void PreviewItems(JiwaFinancials.Jiwa.JiwaApplication.Controls.JiwaGrid JiwaGrid) { JiwaGrid.BuildGridFromStoredProc(storedProcedureName, Ranges.SQLParams); } } public class Ranges : System.ComponentModel.INotifyPropertyChanged { private JiwaFinancials.Jiwa.JiwaApplication.Manager _Manager; public JiwaFinancials.Jiwa.JiwaApplication.Manager Manager { get { return _Manager; } set { _Manager = value; } } #region "Enumerations" public enum SortOrder { Ascending, Descending } #endregion #region "Events" public event System.ComponentModel.PropertyChangedEventHandler PropertyChanged; #endregion #region "Properties" public JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Inventory> PartNo { get; set; } public JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Inventory> Description { get; set; } public JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Classification> Classification { get; set; } public JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Category> Category1 { get; set; } public JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Category> Category2 { get; set; } public JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Category> Category3 { get; set; } public JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Category> Category4 { get; set; } public JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Category> Category5 { get; set; } public JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Supplier> Supplier { get; set; } public List<System.Data.SqlClient.SqlParameter> SQLParams { get { var sqlParams = new List<System.Data.SqlClient.SqlParameter>(); sqlParams.Add(new SqlParameter() { ParameterName = "@From_PartNo", Value = PartNo.From.PartNo, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@To_PartNo", Value = PartNo.To.PartNo, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@From_Description", Value = Description.From.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@To_Description", Value = Description.To.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@From_ClassificationDescription", Value = Classification.From.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@To_ClassificationDescription", Value = Classification.To.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@From_Category1Description", Value = Category1.From.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@To_Category1Description", Value = Category1.To.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@From_Category2Description", Value = Category2.From.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@To_Category2Description", Value = Category2.To.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@From_Category3Description", Value = Category3.From.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@To_Category3Description", Value = Category3.To.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@From_Category4Description", Value = Category4.From.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@To_Category4Description", Value = Category4.To.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@From_Category5Description", Value = Category5.From.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@To_Category5Description", Value = Category5.To.Description, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@From_Supplier", Value = Supplier.From.CreditorAccountNo, SqlDbType = SqlDbType.VarChar }); sqlParams.Add(new SqlParameter() { ParameterName = "@To_Supplier", Value = Supplier.To.CreditorAccountNo, SqlDbType = SqlDbType.VarChar }); return sqlParams; } } #endregion #region "Methods" public Ranges(JiwaApplication.Manager Manager) { _Manager = Manager; PartNo = new JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Inventory>() { Title = "Part No." }; PartNo.From.Manager = _Manager; PartNo.From.Setup(); PartNo.To.Manager = _Manager; PartNo.To.Setup(); Description = new JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Inventory>() { Title = "Description" }; Description.From.Manager = _Manager; Description.From.Setup(); Description.To.Manager = _Manager; Description.To.Setup(); Classification = new JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Classification>() { Title = "Classification" }; Classification.From.Manager = _Manager; Classification.From.Setup(); Classification.To.Manager = _Manager; Classification.To.Setup(); Category1 = new JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Category>() { Title = Manager.Database.ReadSysData("InventoryParams", "Category1", "").ToString() }; Category1.From.Manager = _Manager; Category1.From.Setup(); Category1.To.Manager = _Manager; Category1.To.Setup(); Category1.From.CategoryNo = 1; Category1.To.CategoryNo = 1; Category2 = new JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Category>() { Title = Manager.Database.ReadSysData("InventoryParams", "Category2", "").ToString() }; Category2.From.Manager = _Manager; Category2.From.Setup(); Category2.To.Manager = _Manager; Category2.To.Setup(); Category2.From.CategoryNo = 2; Category2.To.CategoryNo = 2; Category3 = new JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Category>() { Title = Manager.Database.ReadSysData("InventoryParams", "Category3", "").ToString() }; Category3.From.Manager = _Manager; Category3.From.Setup(); Category3.To.Manager = _Manager; Category3.To.Setup(); Category3.From.CategoryNo = 3; Category3.To.CategoryNo = 3; Category4 = new JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Category>() { Title = Manager.Database.ReadSysData("InventoryParams", "Category4", "").ToString() }; Category4.From.Manager = _Manager; Category4.From.Setup(); Category4.To.Manager = _Manager; Category4.To.Setup(); Category4.From.CategoryNo = 4; Category4.To.CategoryNo = 4; Category5 = new JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Category>() { Title = Manager.Database.ReadSysData("InventoryParams", "Category5", "").ToString() }; Category5.From.Manager = _Manager; Category5.From.Setup(); Category5.To.Manager = _Manager; Category5.To.Setup(); Category5.From.CategoryNo = 5; Category5.To.CategoryNo = 5; Supplier = new JiwaFinancials.Jiwa.JiwaApplication.Range<JiwaFinancials.Jiwa.JiwaApplication.Entities.Inventory.Supplier>() { Title = "Supplier"}; Supplier.From.Manager = _Manager; Supplier.From.Setup(); Supplier.To.Manager = _Manager; Supplier.To.Setup(); // Supplier.From.CategoryNo = 5; // Supplier.To.CategoryNo = 5; PartNo.From.Read += PartNo_Read; PartNo.To.Read += PartNo_Read; Description.From.Read += Description_Read; Description.To.Read += Description_Read; Classification.From.Read += Classification_Read; Classification.To.Read += Classification_Read; Category1.From.Read += Category1_Read; Category1.To.Read += Category1_Read; Category2.From.Read += Category2_Read; Category2.To.Read += Category2_Read; Category3.From.Read += Category3_Read; Category3.To.Read += Category3_Read; Category4.From.Read += Category4_Read; Category4.To.Read += Category4_Read; Category5.From.Read += Category5_Read; Category5.To.Read += Category5_Read; Supplier.From.Read += Supplier_Read; Supplier.To.Read += Supplier_Read; } protected void OnPropertyChanged(object sender, System.ComponentModel.PropertyChangedEventArgs e) { if (PropertyChanged != null) { PropertyChanged(sender, e); } } public virtual void NotifyPropertyChanged(string propertyName) { OnPropertyChanged(this, new System.ComponentModel.PropertyChangedEventArgs(propertyName)); } public void ResetDefaults() { try { PartNo.From.ReadRecord(ReadSQL<String>("InventoryID", "PartNo", "IN_Main", SortOrder.Ascending)); } catch (System.Exception ex) { PartNo.From.PartNo = ""; PartNo.From.InventoryID = ""; } try { PartNo.To.ReadRecord(ReadSQL<String>("InventoryID", "PartNo", "IN_Main", SortOrder.Descending )); } catch (System.Exception ex) { PartNo.To.PartNo = ""; PartNo.To.InventoryID = ""; } try { Description.From.ReadRecord(ReadSQL<String>("InventoryID", "Description", "IN_Main", SortOrder.Ascending)); } catch (System.Exception ex) { Description.From.PartNo = ""; Description.From.InventoryID = ""; } try { Description.To.ReadRecord(ReadSQL<String>("InventoryID", "Description", "IN_Main", SortOrder.Descending)); } catch (System.Exception ex) { Description.To.PartNo = ""; Description.To.InventoryID = ""; } try { Classification.From.ReadRecord(ReadSQL<String>("InventoryClassificationID", "Description", "IN_Classification", SortOrder.Ascending)); } catch (System.Exception ex) { Classification.From.Description = ""; Classification.From.ClassificationID = ""; } try { Classification.To.ReadRecord(ReadSQL<String>("InventoryClassificationID", "Description", "IN_Classification", SortOrder.Descending)); } catch (System.Exception ex) { Classification.To.Description = ""; Classification.To.ClassificationID = ""; } try { Category1.From.ReadRecord(ReadSQL<String>("Category1ID", "Description", "IN_Category1", SortOrder.Ascending)); } catch (System.Exception ex) { Category1.From.Description = ""; Category1.From.RecID = ""; } try { Category1.To.ReadRecord(ReadSQL<String>("Category1ID", "Description", "IN_Category1", SortOrder.Descending)); } catch (System.Exception ex) { Category1.To.Description = ""; Category1.To.RecID = ""; } try { Category2.From.ReadRecord(ReadSQL<String>("Category2ID", "Description", "IN_Category2", SortOrder.Ascending)); } catch (System.Exception ex) { Category2.From.Description = ""; Category2.From.RecID = ""; } try { Category2.To.ReadRecord(ReadSQL<String>("Category2ID", "Description", "IN_Category2", SortOrder.Descending)); } catch (System.Exception ex) { Category2.To.Description = ""; Category2.To.RecID = ""; } try { Category3.From.ReadRecord(ReadSQL<String>("Category3ID", "Description", "IN_Category3", SortOrder.Ascending)); } catch (System.Exception ex) { Category3.From.Description = ""; Category3.From.RecID = ""; } try { Category3.To.ReadRecord(ReadSQL<String>("Category3ID", "Description", "IN_Category3", SortOrder.Descending)); } catch (System.Exception ex) { Category3.To.Description = ""; Category3.To.RecID = ""; } try { Category4.From.ReadRecord(ReadSQL<String>("Category4ID", "Description", "IN_Category4", SortOrder.Ascending)); } catch (System.Exception ex) { Category4.From.Description = ""; Category4.From.RecID = ""; } try { Category4.To.ReadRecord(ReadSQL<String>("Category4ID", "Description", "IN_Category4", SortOrder.Descending)); } catch (System.Exception ex) { Category4.To.Description = ""; Category4.To.RecID = ""; } try { Category5.From.ReadRecord(ReadSQL<String>("Category5ID", "Description", "IN_Category5", SortOrder.Ascending)); } catch (System.Exception ex) { Category5.From.Description = ""; Category5.From.RecID = ""; } try { Category5.To.ReadRecord(ReadSQL<String>("Category5ID", "Description", "IN_Category5", SortOrder.Descending)); } catch (System.Exception ex) { Category5.To.Description = ""; Category5.To.RecID = ""; } try { Supplier.From.ReadRecord(ReadSQL<String>("CreditorID", "AccountNo", "Cr_main", SortOrder.Ascending)); } catch (System.Exception ex) { Supplier.From.CreditorAccountNo = ""; Supplier.From.CreditorID = ""; } try { Supplier.To.ReadRecord(ReadSQL<String>("CreditorID", "AccountNo", "CR_Main", SortOrder.Descending)); } catch (System.Exception ex) { Supplier.To.CreditorAccountNo = ""; Supplier.To.CreditorID = ""; } } private T ReadSQL<T>(string ReturnField, string OrderField, string TableName, SortOrder SortOrder) { string SQL = ""; SqlDataReader SQLReader = null; T ReturnValue = default(T); SQL = String.Format("SELECT TOP 1 {0} FROM {1} ORDER BY {2} {3}", ReturnField, TableName, OrderField, SortOrder == SortOrder.Ascending ? "ASC" : "DESC"); try { var db = Manager.Database; using (SqlCommand SQLCmd = new SqlCommand(SQL, db.SQLConnection, db.SQLTransaction)) { SQLReader = db.ExecuteReader(SQLCmd); if (SQLReader.Read() == true) { ReturnValue = (T)db.Sanitise(SQLReader, ReturnField); } else { throw new JiwaFinancials.Jiwa.JiwaApplication.Exceptions.RecordNotFoundException("Record Not Found"); } } return ReturnValue; } finally { if (SQLReader != null) { SQLReader.Close(); } } } #endregion #region "Event Handlers" private void PartNo_Read() { NotifyPropertyChanged("PartNo"); } private void Description_Read() { NotifyPropertyChanged("Description"); } private void Classification_Read() { NotifyPropertyChanged("Classification"); } private void Category1_Read() { NotifyPropertyChanged("Category1"); } private void Category2_Read() { NotifyPropertyChanged("Category2"); } private void Category3_Read() { NotifyPropertyChanged("Category3"); } private void Category4_Read() { NotifyPropertyChanged("Category4"); } private void Category5_Read() { NotifyPropertyChanged("Category5"); } private void Supplier_Read() { NotifyPropertyChanged("Supplier"); } #endregion } #endregion } Report CSharp 807f32ce-d952-4527-898d-ba2a49a5bb06 JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaApplication.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaApplication.dll 89bb179d-821a-4098-a4dd-b5963544daab mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 mscorlib.dll C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll 88716b36-c960-4c1a-8465-4a9a38565fd4 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 360cbb24-d493-4af6-93aa-ccb1c55f26f2 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 747b661c-ba9d-4bfc-8c91-d9a3fa6ecff5 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 82366e14-8eaf-4bbd-9b71-227aad6571e4 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 8bb4b25d-78fe-4571-84b4-b3130458a625 JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaODBC.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaODBC.dll fbcfcd29-6c27-4042-ade0-2a5a194f61d0 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 78af0d93-5540-4004-86f8-5d1146c60a26 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 9239c624-a995-460b-a539-83c80be5f2f1 Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.Smo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Smo.dll 7db5a65c-c7a7-46e5-8564-c2ca5eb690a8 Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91 Microsoft.SqlServer.ConnectionInfo.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.ConnectionInfo.dll 2142e5e2-99f6-44a4-a211-aebfbb56ba91 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 06be4c73-6862-4f44-914d-40b983fb179d Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.v13.1.dll 8a0edb7a-4710-4af9-b992-0ad6a16367f8 Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.Misc.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.Misc.v13.1.dll a685f4cb-f4f9-4c3b-85e2-dbda6867c474 Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinEditors.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinEditors.v13.1.dll d13f98c6-7c24-4ab2-aeff-9dcda2d663be Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinExplorerBar.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll 77c7a445-9ac9-4189-8409-091970c735ec Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTree.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinTree.v13.1.dll ad76260e-c1bc-442a-b032-e25cbd991373 FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.Spread.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\FarPoint.Win.Spread.dll 4dfdcd09-8abb-440b-b05b-00ea55c44c1f Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinTabControl.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinTabControl.v13.1.dll a85fd0a6-2c4a-45b2-b6a0-8c09fa3ff8e8 Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinToolbars.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinToolbars.v13.1.dll 5f5a54e5-3955-470e-9746-8f76146b356b Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinStatusBar.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinStatusBar.v13.1.dll 556b1e17-826e-4462-b195-dc49d3d154fd Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinSchedule.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinSchedule.v13.1.dll ac675366-5023-4f70-ad1c-522425a22f46 Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinListView.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinListView.v13.1.dll 4f225d67-9e82-4fc2-82b6-e3d606fb74ac ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.dll d525348d-cc9b-42cf-adf3-b7cbd6da9130 ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.WinForms.dll 7ba634d6-b573-4606-ab1f-f22d1e5e13ad ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0 ZetaHtmlEditControl.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ZetaHtmlEditControl.dll 3361fe43-1316-46f1-9ee2-6c8b46cbebbb ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll eea472a0-530e-4986-b112-8fb0674aed3e JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaEncryption.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaEncryption.dll f01ac11d-4185-45d9-b613-40023e4731e2 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 b780b3ba-fb63-4751-90b8-e11a5ba829c2 Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a Microsoft.SqlServer.Dac.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.SqlServer.Dac.dll daab6d33-1d66-405d-9119-cedcee88f493 CrystalDecisions.CrystalReports.Engine, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.CrystalReports.Engine.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.CrystalReports.Engine\13.0.3500.0__692fbea5521e1304\CrystalDecisions.CrystalReports.Engine.dll 542c95d1-cd16-40ac-a9b9-e3ae373f3770 CrystalDecisions.Shared, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Shared.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.Shared\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Shared.dll 0ddf8498-4abf-46f3-8040-49a8812ee1cb CrystalDecisions.ReportAppServer.ClientDoc, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ClientDoc.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ClientDoc\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ClientDoc.dll a8a6de4e-60d5-42aa-9edb-d2f3b2263724 CrystalDecisions.ReportAppServer.Controllers, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.Controllers.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.Controllers\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.Controllers.dll aec9371c-3f7c-46d6-b775-d11dc010087a 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 b3b423b7-16f4-46dc-8a03-cb8f2a1015ad Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.AppStylistSupport.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.AppStylistSupport.v13.1.dll 4e5536d8-e3a1-47f1-939d-01872842b340 JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaLib.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaLib.dll 546ae698-0c9f-4998-98d6-d830910c348d Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35 Microsoft.ApplicationInsights.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Microsoft.ApplicationInsights.dll 67b91f94-9f7a-4cdb-b4a6-0e50250194cc CrystalDecisions.Windows.Forms, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.Windows.Forms.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.Windows.Forms\13.0.3500.0__692fbea5521e1304\CrystalDecisions.Windows.Forms.dll 73ff5f0f-6e6d-4532-be58-06bad587fcab Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Win.UltraWinGrid.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Win.UltraWinGrid.v13.1.dll f236a955-b5ff-4bec-a754-c44e98ca6bf7 Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb Infragistics4.Shared.v13.1.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\Infragistics4.Shared.v13.1.dll d4325b04-261d-442c-be98-5ffb45bf1338 ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763 ActiproSoftware.Shared.WinForms.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ActiproSoftware.Shared.WinForms.dll 831016e3-b6a9-4d27-8496-a7b178bab6cd FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457 FarPoint.Win.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\FarPoint.Win.dll 0af8ab47-6d72-475e-92b6-fb0756631f86 CrystalDecisions.ReportAppServer.ReportDefModel, Version=13.0.3500.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 CrystalDecisions.ReportAppServer.ReportDefModel.dll C:\Windows\assembly\GAC_MSIL\CrystalDecisions.ReportAppServer.ReportDefModel\13.0.3500.0__692fbea5521e1304\CrystalDecisions.ReportAppServer.ReportDefModel.dll ca084977-f96b-41e5-9e99-5ff46c00ffe0 ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Interfaces.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Interfaces.dll 3c8a5e21-048c-4465-a61f-8f7634049bbe ServiceStack.Server, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.Server.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.Server.dll 63061055-1327-48fa-a60c-0bc5943d26f7 ServiceStack.OrmLite, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587 ServiceStack.OrmLite.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\ServiceStack.OrmLite.dll 99f8ed80-4606-4dae-a630-4a0626e03421 System.Data.Linq, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 System.Data.Linq.dll C:\Windows\Microsoft.Net\assembly\GAC_MSIL\System.Data.Linq\v4.0_4.0.0.0__b77a5c561934e089\System.Data.Linq.dll 40b06a82-a887-4650-b950-f26fd0519090 JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c JiwaServiceModel.dll C:\Program Files (x86)\Jiwa Financials\Jiwa 7\JiwaServiceModel.dll 46D8BFC8-79A5-41BD-BACD-5D00EA73EB2D 2AD8DA32-C654-465C-ABBC-547AB73E6518 1 Default Plugin Document Type true Inventory Export to CSV.sql SQL Script 2016-10-27T16:14:52.553 ZZZZZZZZZZ0000000000 ZZZZZZZZZZ0000000000 Admin <FirstName xmlns="Entities.Staff">Admin</FirstName> <Surname xmlns="Entities.Staff" /> <EmailAddress xmlns="Entities.Staff" /> <EmailDisplayName xmlns="Entities.Staff">Admin </EmailDisplayName> <SMTPUsername xmlns="Entities.Staff" /> <SMTPPassword xmlns="Entities.Staff">6215056190C20CE971A37D120B9E81FAF5D43D4BEDAF1ACBC520D7C6FA5DA4E57F835CAE74765726</SMTPPassword> <IsActive xmlns="Entities.Staff">true</IsActive> <IsEnabled xmlns="Entities.Staff">true</IsEnabled> </LastModifiedByStaffMember> <FileBinary xmlns="JiwaFinancials.Jiwa.JiwaApplication.Plugin.XML">SUYgTk9UIEVYSVNUUyhTRUxFQ1QgVE9QIDEgKiBGUk9NIFNZX0Zvcm1zIFdIRVJFIENsYXNzTmFtZSA9ICdKaXdhRmluYW5jaWFscy5KaXdhLkV4cG9ydEludmVudG9yeS5FeHBvcnRJbnZlbnRvcnlGb3JtJykNCglJTlNFUlQgSU5UTyBTWV9Gb3JtcyhDbGFzc05hbWUsIERlc2NyaXB0aW9uLCBGb3JtVHlwZSwgSGVscEZpbGVOYW1lLCBIZWxwUGFnZU5hbWUsIEFzc2VtYmx5RnVsbE5hbWUpDQoJU0VMRUNUICdKaXdhRmluYW5jaWFscy5KaXdhLkV4cG9ydEludmVudG9yeS5FeHBvcnRJbnZlbnRvcnlGb3JtJywgJ0V4cG9ydCBJbnZlbnRvcnknLCAyLCBOVUxMLCBOVUxMLCAoU0VMRUNUIFRPUCAxIFJlY0lEIEZST00gU1lfUGx1Z2luIFdIRVJFIE5hbWUgPSAnSW52ZW50b3J5IEV4cG9ydCB0byBDU1YnIEFORCBBdXRob3IgPSAnSml3YSBGaW5hbmNpYWxzJykNCkdPDQoNCklGIE5PVCBFWElTVFMoU0VMRUNUIFRPUCAxICogRlJPTSBTWV9Gb3Jtc0Fic3RyYWN0UGVybWlzc2lvbnMgV0hFUkUgU1lfRm9ybXNfQ2xhc3NOYW1lID0gJ0ppd2FGaW5hbmNpYWxzLkppd2EuSml3YVBPU1VJLlBPU0Zvcm0nIEFORCBOYW1lID0gJ0xvYWQnKQ0KCUlOU0VSVCBJTlRPIFNZX0Zvcm1zQWJzdHJhY3RQZXJtaXNzaW9ucyhSZWNJRCwgU1lfRm9ybXNfQ2xhc3NOYW1lLCBOYW1lLCBEZXNjcmlwdGlvbiwgSXRlbU5vKQ0KCVNFTEVDVCBORVdJRCgpLCAnSml3YUZpbmFuY2lhbHMuSml3YS5FeHBvcnRJbnZlbnRvcnkuRXhwb3J0SW52ZW50b3J5Rm9ybScsICdMb2FkJywgJ0xvYWQgb2YgdGhlIGZvcm0nLCAoU0VMRUNUIENPQUxFU0NFKE1BWChJdGVtTm8pLCAwKSArIDEgRlJPTSBTWV9Gb3Jtc0Fic3RyYWN0UGVybWlzc2lvbnMgV0hFUkUgU1lfRm9ybXNfQ2xhc3NOYW1lID0gJ0ppd2FGaW5hbmNpYWxzLkppd2EuRXhwb3J0SW52ZW50b3J5LkV4cG9ydEludmVudG9yeUZvcm0nKQ0KR08NCg0KSUYgIEVYSVNUUyAoU0VMRUNUICogRlJPTSBzeXMub2JqZWN0cyBXSEVSRSBvYmplY3RfaWQgPSBPQkpFQ1RfSUQoTidbZGJvXS5bdXNwX0pJV0FfSW52ZW50b3J5X0l0ZW1MaXN0XScpIEFORCB0eXBlIGluIChOJ1AnLCBOJ1BDJykpDQoJRFJPUCBQUk9DRURVUkUgW2Rib10uW3VzcF9KSVdBX0ludmVudG9yeV9JdGVtTGlzdF0NCkdPDQoNCkNSRUFURSBQUk9DRURVUkUgW2Rib10uW3VzcF9KSVdBX0ludmVudG9yeV9JdGVtTGlzdF0gQEZyb21fUGFydE5vIFZBUkNIQVIoNTApID0gTlVMTCwgQFRvX1BhcnRObyBWQVJDSEFSKDUwKSA9IE5VTEwsDQoJCQkJCQkJCQkJCQkJQEZyb21fRGVzY3JpcHRpb24gVkFSQ0hBUigyNTUpID0gTlVMTCwgQFRvX0Rlc2NyaXB0aW9uIFZBUkNIQVIoMjU1KSA9IE5VTEwsDQoJCQkJCQkJCQkJCQkJQEZyb21fQ2xhc3NpZmljYXRpb25EZXNjcmlwdGlvbiBWQVJDSEFSKDI1NSkgPSBOVUxMLCBAVG9fQ2xhc3NpZmljYXRpb25EZXNjcmlwdGlvbiBWQVJDSEFSKDI1NSkgPSBOVUxMLA0KCQkJCQkJCQkJCQkJCUBGcm9tX0NhdGVnb3J5MURlc2NyaXB0aW9uIFZBUkNIQVIoMjU1KSA9IE5VTEwsIEBUb19DYXRlZ29yeTFEZXNjcmlwdGlvbiBWQVJDSEFSKDI1NSkgPSBOVUxMLA0KCQkJCQkJCQkJCQkJCUBGcm9tX0NhdGVnb3J5MkRlc2NyaXB0aW9uIFZBUkNIQVIoMjU1KSA9IE5VTEwsIEBUb19DYXRlZ29yeTJEZXNjcmlwdGlvbiBWQVJDSEFSKDI1NSkgPSBOVUxMLA0KCQkJCQkJCQkJCQkJCUBGcm9tX0NhdGVnb3J5M0Rlc2NyaXB0aW9uIFZBUkNIQVIoMjU1KSA9IE5VTEwsIEBUb19DYXRlZ29yeTNEZXNjcmlwdGlvbiBWQVJDSEFSKDI1NSkgPSBOVUxMLA0KCQkJCQkJCQkJCQkJCUBGcm9tX0NhdGVnb3J5NERlc2NyaXB0aW9uIFZBUkNIQVIoMjU1KSA9IE5VTEwsIEBUb19DYXRlZ29yeTREZXNjcmlwdGlvbiBWQVJDSEFSKDI1NSkgPSBOVUxMLA0KCQkJCQkJCQkJCQkJCUBGcm9tX0NhdGVnb3J5NURlc2NyaXB0aW9uIFZBUkNIQVIoMjU1KSA9IE5VTEwsIEBUb19DYXRlZ29yeTVEZXNjcmlwdGlvbiBWQVJDSEFSKDI1NSkgPSBOVUxMDQpBUwpTRVQgTk9DT1VOVCBPTgoKREVDTEFSRSBATW9uZXlEZWNpbWFsUGxhY2VzIFRJTllJTlQKU0VMRUNUIFRPUCAxIEBNb25leURlY2ltYWxQbGFjZXMgPSBEZWNpbWFsUGxhY2VzIEZST00gRlhfQ3VycmVuY3kgV0hFUkUgSXNMb2NhbCA9IDEKCkRFQ0xBUkUgQFNjaGVtYSBUQUJMRQooCglpZCBJTlQgSURFTlRJVFkgTk9UIE5VTEwsCglOYW1lIFZBUkNIQVIoNTApIE5PVCBOVUxMLAkKCUNhcHRpb24gVkFSQ0hBUig1MCkgTk9UIE5VTEwsCglJc1Zpc2libGUgQklUIE5PVCBOVUxMLAoJRGVmYXVsdFdpZHRoIElOVCBOT1QgTlVMTCwKCUlzRHJpbGxEb3duIEJJVCBOT1QgTlVMTCwKCURyaWxsRG93blNvdXJjZUlEQ29sdW1uTmFtZSBWQVJDSEFSKDUwKSBOVUxMLAoJRHJpbGxEb3duQ2xhc3NOYW1lQ29sdW1uTmFtZSBWQVJDSEFSKDUwKSBOVUxMLAoJRm9ybWF0U3RyaW5nIFZBUkNIQVIoMjU1KSBOVUxMLAoJRGVjaW1hbFBsYWNlc0NvbHVtbk5hbWUgVkFSQ0hBUig1MCkgTlVMTAopCgoJLS0gRmlyc3QgUmVzdWx0IGRlZmluZXMgdGhlIHNjaGVtYQoJSU5TRVJUIElOVE8gQFNjaGVtYShOYW1lLCBDYXB0aW9uLCBJc1Zpc2libGUsIERlZmF1bHRXaWR0aCwgSXNEcmlsbERvd24sIERyaWxsRG93blNvdXJjZUlEQ29sdW1uTmFtZSwgRHJpbGxEb3duQ2xhc3NOYW1lQ29sdW1uTmFtZSwgRm9ybWF0U3RyaW5nLCBEZWNpbWFsUGxhY2VzQ29sdW1uTmFtZSkKCVNFTEVDVCAnUGFydE5vJywgJ1BhcnQgTm8uJywgMSwgNiwgMCwgTlVMTCwgTlVMTCwgTlVMTCwgTlVMTAoKCUlOU0VSVCBJTlRPIEBTY2hlbWEoTmFtZSwgQ2FwdGlvbiwgSXNWaXNpYmxlLCBEZWZhdWx0V2lkdGgsIElzRHJpbGxEb3duLCBEcmlsbERvd25Tb3VyY2VJRENvbHVtbk5hbWUsIERyaWxsRG93bkNsYXNzTmFtZUNvbHVtbk5hbWUsIEZvcm1hdFN0cmluZywgRGVjaW1hbFBsYWNlc0NvbHVtbk5hbWUpCglTRUxFQ1QgJ0Rlc2NyaXB0aW9uJywgJ0Rlc2NyaXB0aW9uJywgMSwgNiwgMCwgTlVMTCwgTlVMTCwgTlVMTCwgTlVMTAoKCUlOU0VSVCBJTlRPIEBTY2hlbWEoTmFtZSwgQ2FwdGlvbiwgSXNWaXNpYmxlLCBEZWZhdWx0V2lkdGgsIElzRHJpbGxEb3duLCBEcmlsbERvd25Tb3VyY2VJRENvbHVtbk5hbWUsIERyaWxsRG93bkNsYXNzTmFtZUNvbHVtbk5hbWUsIEZvcm1hdFN0cmluZywgRGVjaW1hbFBsYWNlc0NvbHVtbk5hbWUpCglTRUxFQ1QgJ0RlZmF1bHRQcmljZScsICdEZWZhdWx0IFByaWNlJywgMSwgNSwgMCwgTlVMTCwgTlVMTCwgJycsIE5VTEwKCglJTlNFUlQgSU5UTyBAU2NoZW1hKE5hbWUsIENhcHRpb24sIElzVmlzaWJsZSwgRGVmYXVsdFdpZHRoLCBJc0RyaWxsRG93biwgRHJpbGxEb3duU291cmNlSURDb2x1bW5OYW1lLCBEcmlsbERvd25DbGFzc05hbWVDb2x1bW5OYW1lLCBGb3JtYXRTdHJpbmcsIERlY2ltYWxQbGFjZXNDb2x1bW5OYW1lKQoJU0VMRUNUICdSUlBQcmljZScsICdSUlAnLCAxLCA1LCAwLCBOVUxMLCBOVUxMLCAnJywgTlVMTAoKCUlOU0VSVCBJTlRPIEBTY2hlbWEoTmFtZSwgQ2FwdGlvbiwgSXNWaXNpYmxlLCBEZWZhdWx0V2lkdGgsIElzRHJpbGxEb3duLCBEcmlsbERvd25Tb3VyY2VJRENvbHVtbk5hbWUsIERyaWxsRG93bkNsYXNzTmFtZUNvbHVtbk5hbWUsIEZvcm1hdFN0cmluZywgRGVjaW1hbFBsYWNlc0NvbHVtbk5hbWUpCglTRUxFQ1QgJ0NsYXNzaWZpY2F0aW9uJywgJ0NsYXNzaWZpY2F0aW9uJywgMSwgNSwgMCwgTlVMTCwgTlVMTCwgJycsIE5VTEwKCglJTlNFUlQgSU5UTyBAU2NoZW1hKE5hbWUsIENhcHRpb24sIElzVmlzaWJsZSwgRGVmYXVsdFdpZHRoLCBJc0RyaWxsRG93biwgRHJpbGxEb3duU291cmNlSURDb2x1bW5OYW1lLCBEcmlsbERvd25DbGFzc05hbWVDb2x1bW5OYW1lLCBGb3JtYXRTdHJpbmcsIERlY2ltYWxQbGFjZXNDb2x1bW5OYW1lKQoJU0VMRUNUICdDYXRlZ29yeTEnLCAnQ2F0ZWdvcnkxJywgMSwgNSwgMCwgTlVMTCwgTlVMTCwgJycsIE5VTEwKCglJTlNFUlQgSU5UTyBAU2NoZW1hKE5hbWUsIENhcHRpb24sIElzVmlzaWJsZSwgRGVmYXVsdFdpZHRoLCBJc0RyaWxsRG93biwgRHJpbGxEb3duU291cmNlSURDb2x1bW5OYW1lLCBEcmlsbERvd25DbGFzc05hbWVDb2x1bW5OYW1lLCBGb3JtYXRTdHJpbmcsIERlY2ltYWxQbGFjZXNDb2x1bW5OYW1lKQoJU0VMRUNUICdDYXRlZ29yeTInLCAnQ2F0ZWdvcnkyJywgMSwgNSwgMCwgTlVMTCwgTlVMTCwgJycsIE5VTEwKCglJTlNFUlQgSU5UTyBAU2NoZW1hKE5hbWUsIENhcHRpb24sIElzVmlzaWJsZSwgRGVmYXVsdFdpZHRoLCBJc0RyaWxsRG93biwgRHJpbGxEb3duU291cmNlSURDb2x1bW5OYW1lLCBEcmlsbERvd25DbGFzc05hbWVDb2x1bW5OYW1lLCBGb3JtYXRTdHJpbmcsIERlY2ltYWxQbGFjZXNDb2x1bW5OYW1lKQoJU0VMRUNUICdDYXRlZ29yeTMnLCAnQ2F0ZWdvcnkzJywgMSwgNSwgMCwgTlVMTCwgTlVMTCwgJycsIE5VTEwKCglJTlNFUlQgSU5UTyBAU2NoZW1hKE5hbWUsIENhcHRpb24sIElzVmlzaWJsZSwgRGVmYXVsdFdpZHRoLCBJc0RyaWxsRG93biwgRHJpbGxEb3duU291cmNlSURDb2x1bW5OYW1lLCBEcmlsbERvd25DbGFzc05hbWVDb2x1bW5OYW1lLCBGb3JtYXRTdHJpbmcsIERlY2ltYWxQbGFjZXNDb2x1bW5OYW1lKQoJU0VMRUNUICdDYXRlZ29yeTQnLCAnQ2F0ZWdvcnk0JywgMSwgNSwgMCwgTlVMTCwgTlVMTCwgJycsIE5VTEwKCglJTlNFUlQgSU5UTyBAU2NoZW1hKE5hbWUsIENhcHRpb24sIElzVmlzaWJsZSwgRGVmYXVsdFdpZHRoLCBJc0RyaWxsRG93biwgRHJpbGxEb3duU291cmNlSURDb2x1bW5OYW1lLCBEcmlsbERvd25DbGFzc05hbWVDb2x1bW5OYW1lLCBGb3JtYXRTdHJpbmcsIERlY2ltYWxQbGFjZXNDb2x1bW5OYW1lKQoJU0VMRUNUICdDYXRlZ29yeTUnLCAnQ2F0ZWdvcnk1JywgMSwgNSwgMCwgTlVMTCwgTlVMTCwgJycsIE5VTEwKCglTRUxFQ1QgTmFtZSwgQ2FwdGlvbiwgSXNWaXNpYmxlLCBEZWZhdWx0V2lkdGgsIElzRHJpbGxEb3duLCBEcmlsbERvd25Tb3VyY2VJRENvbHVtbk5hbWUsIERyaWxsRG93bkNsYXNzTmFtZUNvbHVtbk5hbWUsIEZvcm1hdFN0cmluZywgRGVjaW1hbFBsYWNlc0NvbHVtbk5hbWUKCUZST00gQFNjaGVtYQoJT1JERVIgQlkgaWQKCgktLSBTZWNvbmQgUmVzdWx0IHJldHVybnMgdGhlIGRhdGEKCVNFTEVDVCBJTl9NYWluLlBhcnRObywgSU5fTWFpbi5EZXNjcmlwdGlvbiwgSU5fTWFpbi5EZWZhdWx0UHJpY2UsIElOX01haW4uUlJQUHJpY2UsCgkJCUlOX0NsYXNzaWZpY2F0aW9uLkRlc2NyaXB0aW9uIFtDbGFzc2lmaWNhdGlvbl0sIElOX0NhdGVnb3J5MS5EZXNjcmlwdGlvbiBbQ2F0ZWdvcnkxXSwKCQkJSU5fQ2F0ZWdvcnkyLkRlc2NyaXB0aW9uIFtDYXRlZ29yeTJdLCBJTl9DYXRlZ29yeTMuRGVzY3JpcHRpb24gW0NhdGVnb3J5M10sCgkJCUlOX0NhdGVnb3J5NC5EZXNjcmlwdGlvbiBbQ2F0ZWdvcnk0XSwgSU5fQ2F0ZWdvcnk1LkRlc2NyaXB0aW9uIFtDYXRlZ29yeTVdCglGUk9NIElOX01haW4KCUpPSU4gSU5fQ2xhc3NpZmljYXRpb24gT04gSU5fQ2xhc3NpZmljYXRpb24uSW52ZW50b3J5Q2xhc3NpZmljYXRpb25JRCA9IElOX01haW4uQ2xhc3NpZmljYXRpb25JRAoJSk9JTiBJTl9DYXRlZ29yeTEgT04gSU5fQ2F0ZWdvcnkxLkNhdGVnb3J5MUlEID0gSU5fTWFpbi5DYXRhZ29yeTFJRAoJSk9JTiBJTl9DYXRlZ29yeTIgT04gSU5fQ2F0ZWdvcnkyLkNhdGVnb3J5MklEID0gSU5fTWFpbi5DYXRhZ29yeTJJRAoJSk9JTiBJTl9DYXRlZ29yeTMgT04gSU5fQ2F0ZWdvcnkzLkNhdGVnb3J5M0lEID0gSU5fTWFpbi5DYXRhZ29yeTNJRAoJSk9JTiBJTl9DYXRlZ29yeTQgT04gSU5fQ2F0ZWdvcnk0LkNhdGVnb3J5NElEID0gSU5fTWFpbi5DYXRhZ29yeTRJRAoJSk9JTiBJTl9DYXRlZ29yeTUgT04gSU5fQ2F0ZWdvcnk1LkNhdGVnb3J5NUlEID0gSU5fTWFpbi5DYXRhZ29yeTVJRAoJV0hFUkUgKChARnJvbV9QYXJ0Tm8gSVMgTlVMTCBPUiAoSU5fTWFpbi5QYXJ0Tm8gPj0gQEZyb21fUGFydE5vKSkgQU5EIChAVG9fUGFydE5vIElTIE5VTEwgT1IgKElOX01haW4uUGFydE5vIDw9IEBUb19QYXJ0Tm8pKSkKCUFORCAgKChARnJvbV9DbGFzc2lmaWNhdGlvbkRlc2NyaXB0aW9uIElTIE5VTEwgT1IgKElOX0NsYXNzaWZpY2F0aW9uLkRlc2NyaXB0aW9uID49IEBGcm9tX0NsYXNzaWZpY2F0aW9uRGVzY3JpcHRpb24pKSBBTkQgKEBUb19DbGFzc2lmaWNhdGlvbkRlc2NyaXB0aW9uIElTIE5VTEwgT1IgKElOX0NsYXNzaWZpY2F0aW9uLkRlc2NyaXB0aW9uIDw9IEBUb19DbGFzc2lmaWNhdGlvbkRlc2NyaXB0aW9uKSkpCglBTkQgICgoQEZyb21fQ2F0ZWdvcnkxRGVzY3JpcHRpb24gSVMgTlVMTCBPUiAoSU5fQ2F0ZWdvcnkxLkRlc2NyaXB0aW9uID49IEBGcm9tX0NhdGVnb3J5MURlc2NyaXB0aW9uKSkgQU5EIChAVG9fQ2F0ZWdvcnkxRGVzY3JpcHRpb24gSVMgTlVMTCBPUiAoSU5fQ2F0ZWdvcnkxLkRlc2NyaXB0aW9uIDw9IEBUb19DYXRlZ29yeTFEZXNjcmlwdGlvbikpKQoJQU5EICAoKEBGcm9tX0NhdGVnb3J5MkRlc2NyaXB0aW9uIElTIE5VTEwgT1IgKElOX0NhdGVnb3J5Mi5EZXNjcmlwdGlvbiA+PSBARnJvbV9DYXRlZ29yeTJEZXNjcmlwdGlvbikpIEFORCAoQFRvX0NhdGVnb3J5MkRlc2NyaXB0aW9uIElTIE5VTEwgT1IgKElOX0NhdGVnb3J5Mi5EZXNjcmlwdGlvbiA8PSBAVG9fQ2F0ZWdvcnkyRGVzY3JpcHRpb24pKSkKCUFORCAgKChARnJvbV9DYXRlZ29yeTNEZXNjcmlwdGlvbiBJUyBOVUxMIE9SIChJTl9DYXRlZ29yeTMuRGVzY3JpcHRpb24gPj0gQEZyb21fQ2F0ZWdvcnkzRGVzY3JpcHRpb24pKSBBTkQgKEBUb19DYXRlZ29yeTNEZXNjcmlwdGlvbiBJUyBOVUxMIE9SIChJTl9DYXRlZ29yeTMuRGVzY3JpcHRpb24gPD0gQFRvX0NhdGVnb3J5M0Rlc2NyaXB0aW9uKSkpCglBTkQgICgoQEZyb21fQ2F0ZWdvcnk0RGVzY3JpcHRpb24gSVMgTlVMTCBPUiAoSU5fQ2F0ZWdvcnk0LkRlc2NyaXB0aW9uID49IEBGcm9tX0NhdGVnb3J5NERlc2NyaXB0aW9uKSkgQU5EIChAVG9fQ2F0ZWdvcnk0RGVzY3JpcHRpb24gSVMgTlVMTCBPUiAoSU5fQ2F0ZWdvcnk0LkRlc2NyaXB0aW9uIDw9IEBUb19DYXRlZ29yeTREZXNjcmlwdGlvbikpKQoJQU5EICAoKEBGcm9tX0NhdGVnb3J5NURlc2NyaXB0aW9uIElTIE5VTEwgT1IgKElOX0NhdGVnb3J5NS5EZXNjcmlwdGlvbiA+PSBARnJvbV9DYXRlZ29yeTVEZXNjcmlwdGlvbikpIEFORCAoQFRvX0NhdGVnb3J5NURlc2NyaXB0aW9uIElTIE5VTEwgT1IgKElOX0NhdGVnb3J5NS5EZXNjcmlwdGlvbiA8PSBAVG9fQ2F0ZWdvcnk1RGVzY3JpcHRpb24pKSkKCU9SREVSIEJZIElOX01haW4uUGFydE5vCgpHTwoKR1JBTlQgRVhFQ1VURSBPTiBbdXNwX0pJV0FfSW52ZW50b3J5X0l0ZW1MaXN0XSBUTyBKaXdhVXNlcgpHTw==</FileBinary> <ItemNo xmlns="JiwaFinancials.Jiwa.JiwaApplication.Plugin.XML">1</ItemNo> </Document> </Documents> </JiwaDocument>