00fe0114-98ae-4c3c-9439-0820d27035b7
AERP - 836 - Sales Order Processing UI
Adds an "Order No" filter to the Batch Sales Order Processing Screen. If the stored procedure for the selected "Batch Process Filter" contains the string \AERP\, then a custom population function is called which adds an extra parameter \@OrderNo\ to the stored procedure call. Otherwise, JIWA standard behaviour is followed.
true
false
836
Advanced ERP
20.02.21.1625
Option Explicit On
Option Infer On
Option Strict On
Option Compare Text
Imports System
Imports System.Data.SqlClient
Imports System.Drawing
Imports System.Windows.Forms
Imports Infragistics.Win.UltraWinEditors
Imports JiwaFinancials.Jiwa
Imports JiwaFinancials.Jiwa.JiwaApplication
Imports JiwaFinancials.Jiwa.JiwaApplication.Exceptions
Imports JiwaFinancials.Jiwa.JiwaODBC
Imports JiwaFinancials.Jiwa.JiwaSales.BatchProcessing
Imports JiwaFinancials.Jiwa.JiwaSalesUI.BatchProcessing
Namespace AERP.SalesOrderFormCustomisations
Public Class FormPlugin
Inherits MarshalByRefObject
Implements IJiwaFormPlugin
Public Overrides Function InitializeLifetimeService() As Object
' returning null here will prevent the lease manager
' from deleting the Object.
Return Nothing
End Function
Public Sub SetupBeforeHandlers(ByVal JiwaForm As IJiwaForm, ByVal Plugin As Plugin.Plugin) Implements IJiwaFormPlugin.SetupBeforeHandlers
' Add handler for button click which we want to intercept
Dim batchProcessForm = TryCast(JiwaForm, JiwaSalesUI.BatchProcessing.BatchProcess)
AddHandler batchProcessForm.GetCandidatesUltraButton.Click, AddressOf GetCandidatesUltraButton_Click
End Sub
Public Sub Setup(ByVal JiwaForm As IJiwaForm, ByVal Plugin As Plugin.Plugin) Implements IJiwaFormPlugin.Setup
' Add our new editors to the filter panel
Dim batchProcessForm = TryCast(JiwaForm, JiwaSalesUI.BatchProcessing.BatchProcess)
If batchProcessForm Is Nothing Then
Return ' panic
End If
Dim orderNoLabel = New UltraCheckEditor() With {.Text = "Filter by Order No", .Checked = False, .Name = "orderNoLabel",
.Location = New Point(batchProcessForm.FilterByDebtorNameUltraCheckEditor.Left, batchProcessForm.SpecificWarehouseLookup.Top)}
Dim orderNoEditor = New UltraTextEditor() With {.[ReadOnly] = True, .Text = "MSP", .Name = "orderNoEditor",
.Location = New Point(batchProcessForm.SalesOrderPrintingUltraComboEditor.Left, batchProcessForm.SpecificWarehouseLookup.Top)}
batchProcessForm.UltraExpandableGroupBoxPanel4.Controls.AddRange({orderNoLabel, orderNoEditor})
' batchProcessForm.InvoiceTypeUltraLabel.Enabled = False
' batchProcessForm.BillingTypeUltraLabel.Enabled = False
' batchProcessForm.OrderTypeUltraLabel.Enabled = False
'
' batchProcessForm.InvoiceTypeUltraComboEditor.Enabled = False
' batchProcessForm.BillingTypeUltraComboEditor.Enabled = False
' batchProcessForm.OrderTypeUltraComboEditor.Enabled = False
AddHandler orderNoLabel.CheckedChanged, Sub() orderNoEditor.ReadOnly = Not orderNoLabel.Checked
End Sub
Private Sub GetCandidatesUltraButton_Click(sender As Object, e As EventArgs)
Dim batchProcessForm = TryCast(TryCast(sender, Control).FindForm(), JiwaSalesUI.BatchProcessing.BatchProcess)
If batchProcessForm Is Nothing Then
Return ' panic
End If
Dim procName As String = batchProcessForm.BatchProcess.Ranges.SelectedBatchProcessFilter.GetListOfSalesOrdersStoredProcedure
If Not procName.Contains("AERP") Then
Return ' let JIWA carry on as normal
End If
Dim oldCursor As Cursor = batchProcessForm.Cursor
Try
batchProcessForm.Cursor = Cursors.WaitCursor
AddRange(batchProcessForm)
batchProcessForm.CheckEditStatus()
Finally
batchProcessForm.Cursor = oldCursor
End Try
batchProcessForm.DisplayCandidates()
Throw New ClientCancelledException()
End Sub
Public Sub AddRange(batchProcessForm As JiwaSalesUI.BatchProcessing.BatchProcess)
Dim orderNoEditor = TryCast(batchProcessForm.Controls.Find("orderNoEditor", True)(0), UltraTextEditor)
Dim orderNoFilter As String = If(orderNoEditor Is Nothing OrElse String.IsNullOrWhiteSpace(orderNoEditor.Text), Nothing, orderNoEditor.Text)
Dim batchProcess = batchProcessForm.BatchProcess
Dim mgr As Manager = batchProcessForm.Manager
Dim db As database = mgr.Database
Dim procName As String = batchProcess.Ranges.SelectedBatchProcessFilter.GetListOfSalesOrdersStoredProcedure
Using sqlCommand = New SqlCommand(procName, db.SQLConnection, db.SQLTransaction)
sqlCommand.CommandType = System.Data.CommandType.StoredProcedure
sqlCommand.Parameters.AddWithValue("@FromInvoiceNo", batchProcess.Ranges.InvoiceNo.From.InvoiceNo)
sqlCommand.Parameters.AddWithValue("@ToInvoiceNo", batchProcess.Ranges.InvoiceNo.[To].InvoiceNo)
If batchProcess.Options.FilterDebtorsByName Then
sqlCommand.Parameters.AddWithValue("@FromDebtor", batchProcess.Ranges.DebtorName.From.Name)
sqlCommand.Parameters.AddWithValue("@ToDebtor", batchProcess.Ranges.DebtorName.[To].Name)
sqlCommand.Parameters.AddWithValue("@DebtorRangeIsAccountNo", False)
Else
sqlCommand.Parameters.AddWithValue("@FromDebtor", batchProcess.Ranges.DebtorAccountNo.From.AccountNo)
sqlCommand.Parameters.AddWithValue("@ToDebtor", batchProcess.Ranges.DebtorAccountNo.[To].AccountNo)
sqlCommand.Parameters.AddWithValue("@DebtorRangeIsAccountNo", True)
End If
sqlCommand.Parameters.AddWithValue("@FromRecordDate", batchProcess.Ranges.[Date].From)
sqlCommand.Parameters.AddWithValue("@ToRecordDate", batchProcess.Ranges.Date.To)
sqlCommand.Parameters.AddWithValue("@FromStaffSurname", batchProcess.Ranges.Staff.From.Surname)
sqlCommand.Parameters.AddWithValue("@ToStaffSurname", batchProcess.Ranges.Staff.[To].Surname)
sqlCommand.Parameters.AddWithValue("@FromBranchDescription", batchProcess.Ranges.Branch.From.Description)
sqlCommand.Parameters.AddWithValue("@ToBranchDescription", batchProcess.Ranges.Branch.[To].Description)
If (batchProcessForm.BatchProcess.Options.UseSpecificWarehouse) Then
sqlCommand.Parameters.AddWithValue("@SpecificWarehouseID", batchProcess.Options.Warehouse.IN_LogicalID)
Else
sqlCommand.Parameters.AddWithValue("@SpecificWarehouseID", DBNull.Value)
End If
sqlCommand.Parameters.AddWithValue("@SpecificWarehouseIDIsPhysical", False)
sqlCommand.Parameters.AddWithValue("@SpecificB2BType", CShort(batchProcess.Options.OrderTypeSelection))
sqlCommand.Parameters.AddWithValue("@SpecificBOMode", CShort(batchProcess.Options.BackOrderModeSelection))
sqlCommand.Parameters.AddWithValue("@SpecificBillingType", CShort(batchProcess.Options.BillingTypeSelection))
sqlCommand.Parameters.AddWithValue("@SpecificWholesaleInvoiceType", CShort(batchProcess.Options.InvoiceTypeSelection))
If orderNoFilter IsNot Nothing Then
sqlCommand.Parameters.AddWithValue("@OrderNumberFilter", orderNoFilter)
Else
sqlCommand.Parameters.AddWithValue("@OrderNumberFilter", DBNull.Value)
End If
Using sqlDataReader As SqlDataReader = db.ExecuteReader(sqlCommand)
Dim haveOrderno As Boolean = procName.Contains("AERP")
While sqlDataReader.Read()
Dim candidate As ProcessCandidate = mgr.CollectionItemFactory.CreateCollectionItem(Of ProcessCandidate)()
candidate.InvoiceID = CStr(db.Sanitise(sqlDataReader, "InvoiceID"))
candidate.InvoiceNo = CStr(db.Sanitise(sqlDataReader, "InvoiceNo"))
candidate.CurrentHistoryNo = CInt(db.Sanitise(sqlDataReader, "CurrentHistoryNo"))
candidate.InvoiceInitDate = CDate(db.Sanitise(sqlDataReader, "InvoiceInitDate"))
candidate.DebtorID = CStr(db.Sanitise(sqlDataReader, "DebtorID"))
candidate.AccountNo = CStr(db.Sanitise(sqlDataReader, "AccountNo"))
candidate.Name = CStr(db.Sanitise(sqlDataReader, "Name"))
If haveOrderno Then
candidate.Remark = CStr(db.Sanitise(sqlDataReader, "OrderNo"))
End If
candidate.Process = True
If (batchProcessForm.BatchProcess.ProcessCandidates.Contains(candidate.RecID)) Then
Continue While
End If
batchProcessForm.BatchProcess.ProcessCandidates.Add(candidate)
End While
sqlDataReader.Close()
End Using
End Using
End Sub
End Class
End Namespace
Report
VisualBasic
428efe2e-f05d-4890-b2ed-e69814336177
Process Sales Orders
JiwaFinancials.Jiwa.JiwaSalesUI.BatchProcessing.BatchProcess
44493aa5-179d-40a0-bc71-f9607c82d05e
JiwaApplication, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaApplication.dll
C:\Jiwa\Jiwa 7\JiwaApplication.dll
766d2024-8541-455a-a17c-37fd199b857c
mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
mscorlib.dll
C:\Windows\Microsoft.NET\Framework\v4.0.30319\mscorlib.dll
882bb575-c3f4-49b8-a48e-85e0f9410a99
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
72e4208b-cdbe-4396-a0f3-24da4424ec6a
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
65ee9a79-e64a-46a1-9c1e-da8897468b9e
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
54281ec7-81af-4663-a285-7a1ec604522c
JiwaODBC, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaODBC.dll
C:\Jiwa\Jiwa 7\JiwaODBC.dll
fd76d383-777f-44e4-92a0-e0af2c6e8bd1
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
c3e72381-1f55-4896-985b-641e60225128
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
adc6ad26-63fd-4889-b854-93a99c15e7d8
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
33dbd8e3-221c-404a-8756-50c593c29aa4
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
53a9a9aa-3068-4ea3-b76e-8e5f306cbf05
JiwaServiceModel, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaServiceModel.dll
C:\Jiwa\Jiwa 7\JiwaServiceModel.dll
31a58fe1-168c-4685-9dfd-a076b99f044d
Infragistics4.Win.Misc.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.Misc.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.Misc.v13.1.dll
d1183140-ddef-471c-8d57-09ca93b4d040
Infragistics4.Win.UltraWinEditors.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.UltraWinEditors.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinEditors.v13.1.dll
97c9e606-7de7-4eb7-b91b-910184bd432c
Infragistics4.Win.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.v13.1.dll
407e4c0e-beb9-475a-8ed9-b1b044051217
Microsoft.SqlServer.Smo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
Microsoft.SqlServer.Smo.dll
C:\Jiwa\Jiwa 7\Microsoft.SqlServer.Smo.dll
133b8091-f376-493b-b8aa-ee3be32e4e5d
Microsoft.SqlServer.ConnectionInfo, Version=14.100.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91
Microsoft.SqlServer.ConnectionInfo.dll
C:\Jiwa\Jiwa 7\Microsoft.SqlServer.ConnectionInfo.dll
88a35b70-aba1-44d3-bc57-bb3dc3216312
Infragistics4.Win.UltraWinExplorerBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.UltraWinExplorerBar.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinExplorerBar.v13.1.dll
a852a894-1bbd-4bda-83e1-028abf07605c
Infragistics4.Win.UltraWinTree.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.UltraWinTree.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinTree.v13.1.dll
a70bb89c-aa7b-4f7e-b059-1b03478c57a7
FarPoint.Win.Spread, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457
FarPoint.Win.Spread.dll
C:\Jiwa\Jiwa 7\FarPoint.Win.Spread.dll
a279f7ef-116a-4241-9a11-2d0b7cf9c89e
Infragistics4.Win.UltraWinTabControl.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.UltraWinTabControl.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinTabControl.v13.1.dll
42048655-db5f-4b6c-93fb-f961c6602db8
Infragistics4.Shared.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Shared.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Shared.v13.1.dll
751cfc1f-93d5-414b-84ca-b30700781d3c
Infragistics4.Win.UltraWinToolbars.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.UltraWinToolbars.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinToolbars.v13.1.dll
53edae4c-5d04-4c74-b660-1881dacd7f02
Infragistics4.Win.UltraWinStatusBar.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.UltraWinStatusBar.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinStatusBar.v13.1.dll
081d816c-2bda-44c7-be51-d54afadddb19
Infragistics4.Win.UltraWinSchedule.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.UltraWinSchedule.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinSchedule.v13.1.dll
ebc2f8fc-0ebc-4198-ad25-380027c71622
Infragistics4.Win.UltraWinListView.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.UltraWinListView.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinListView.v13.1.dll
0b7070d2-f9ea-440a-8aeb-ff54a1ca0773
ServiceStack, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587
ServiceStack.dll
C:\Jiwa\Jiwa 7\ServiceStack.dll
549bd4c1-1730-4847-855f-05d1bd7282de
EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
EntityFramework.dll
C:\Jiwa\Jiwa 7\EntityFramework.dll
9e97cf01-ea71-45d4-9076-0b8659e6e839
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
a1b7a409-15f3-41db-a36c-dd688813588d
ActiproSoftware.SyntaxEditor.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763
ActiproSoftware.SyntaxEditor.WinForms.dll
C:\Jiwa\Jiwa 7\ActiproSoftware.SyntaxEditor.WinForms.dll
7ebbc16e-58f4-48c0-935e-4c2ae6da5b0c
ZetaHtmlEditControl, Version=1.1.0.3, Culture=neutral, PublicKeyToken=2e2e5ba5da72b6c0
ZetaHtmlEditControl.dll
C:\Jiwa\Jiwa 7\ZetaHtmlEditControl.dll
c3825f63-56cf-4641-b832-98c166b56766
ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763
ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll
C:\Jiwa\Jiwa 7\ActiproSoftware.SyntaxEditor.Addons.DotNet.WinForms.dll
33d86dd0-7fa6-4999-b1ef-c324249763ca
JiwaEncryption, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaEncryption.dll
C:\Jiwa\Jiwa 7\JiwaEncryption.dll
744a925a-8d41-46ae-bd33-b0b879e53b70
Infragistics4.Win.UltraWinGrid.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.UltraWinGrid.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.UltraWinGrid.v13.1.dll
4e0f57ce-8b74-4bfd-a292-f8161ed8c379
Microsoft.SqlServer.Dac, Version=14.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a
Microsoft.SqlServer.Dac.dll
C:\Jiwa\Jiwa 7\Microsoft.SqlServer.Dac.dll
5a97f1bc-d105-46ef-83bd-cf30ea72ad7b
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
a6519a80-3238-4216-ba7c-48561e7c2111
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
b93b2d3d-eabe-43ec-92f7-ee172ee65d24
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
f9ef52e0-79c0-49b7-8279-d4e8cd61493b
Infragistics4.Win.AppStylistSupport.v13.1, Version=13.1.20131.2060, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb
Infragistics4.Win.AppStylistSupport.v13.1.dll
C:\Jiwa\Jiwa 7\Infragistics4.Win.AppStylistSupport.v13.1.dll
01128913-8ccf-4758-ad0e-67455d8287ce
JiwaLib, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaLib.dll
C:\Jiwa\Jiwa 7\JiwaLib.dll
7fd1ac15-44aa-4d92-94e9-6e60f76798ed
Microsoft.ApplicationInsights, Version=2.4.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35
Microsoft.ApplicationInsights.dll
C:\Jiwa\Jiwa 7\Microsoft.ApplicationInsights.dll
4a7a86c6-7750-4817-a6b9-c580ba7abe22
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
8ac7df85-2c76-4a30-ba9d-53c5a175d969
EntityFramework.SqlServer, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
EntityFramework.SqlServer.dll
C:\Jiwa\Jiwa 7\EntityFramework.SqlServer.dll
9af5514d-8ba6-4ecf-bce8-84b23000eb9a
ServiceStack.Text, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587
ServiceStack.Text.dll
C:\Jiwa\Jiwa 7\ServiceStack.Text.dll
cae75bd6-3326-4b9d-97b5-a6449aaa2bea
ActiproSoftware.Shared.WinForms, Version=16.1.330.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763
ActiproSoftware.Shared.WinForms.dll
C:\Jiwa\Jiwa 7\ActiproSoftware.Shared.WinForms.dll
8b6db487-7825-4b51-be1c-e88097b5127e
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
1a5e77e4-8af9-4e1e-bc9b-25193ac946f0
FarPoint.Win, Version=8.35.20151.0, Culture=neutral, PublicKeyToken=327c3516b1b18457
FarPoint.Win.dll
C:\Jiwa\Jiwa 7\FarPoint.Win.dll
be446e7a-fa5f-4e64-96bc-139048e17916
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
ebdab702-ce2b-4159-b15d-efb4009664d4
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
948cebc0-7203-4707-9355-76b2c3c8730e
ServiceStack.Interfaces, Version=5.0.0.0, Culture=neutral, PublicKeyToken=02c12cbda47e6587
ServiceStack.Interfaces.dll
C:\Jiwa\Jiwa 7\ServiceStack.Interfaces.dll
a12e3f37-141d-4917-8609-995dbe6f9160
ServiceStack.Server, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587
ServiceStack.Server.dll
C:\Jiwa\Jiwa 7\ServiceStack.Server.dll
05095de4-ee6d-4f67-9619-c5756ba9ce37
ServiceStack.OrmLite, Version = 5.0.0.0, Culture = neutral, PublicKeyToken = 02c12cbda47e6587
ServiceStack.OrmLite.dll
C:\Jiwa\Jiwa 7\ServiceStack.OrmLite.dll
876a7cad-05ef-44fd-ab79-bc170f519813
JiwaSalesUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaSalesUI.dll
C:\Jiwa\Jiwa 7\JiwaSalesUI.dll
134e6ffb-f343-4eea-9d95-788398ae036c
JiwaSales, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaSales.dll
C:\Jiwa\Jiwa 7\JiwaSales.dll
c53f2794-cdcb-4dd5-81ef-2dc32387e4d1
JiwaPriceSchemes, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaPriceSchemes.dll
C:\Jiwa\Jiwa 7\JiwaPriceSchemes.dll
7ee6bd4e-e498-4d9b-9655-8f8b7ee09525
JiwaJobCosting, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaJobCosting.dll
C:\Jiwa\Jiwa 7\JiwaJobCosting.dll
2a94625c-3766-4e93-86fe-2146470217e1
JiwaSerialNumbersUI, Version=7.2.1.0, Culture=neutral, PublicKeyToken=e30ce81e37f29c8c
JiwaSerialNumbersUI.dll
C:\Jiwa\Jiwa 7\JiwaSerialNumbersUI.dll
8551c071-d386-438c-924d-ae3ca6eb18f2
054EC564-5AF3-4734-B410-83166B1A2380
2
Default Plugin Document Type
true
AERP_GetSalesOrdersToProcess.sql
SQL Script to create stored procedure to get orders to process
2020-02-21T16:17:03.957
ZZZZZZZZZZ0000000000
ZZZZZZZZZZ0000000000
Admin
Admin
Admin
F3B31802CD55EE16C52A55D41560EBB1
true
true
SUYgTk9UIEVYSVNUUyAoDQoJCVNFTEVDVCAxDQoJCUZST00gU09fQmF0Y2hQcm9jZXNzVHlwZXMNCgkJV0hFUkUgUmVjSUQgPSAnQUVSUF81MTM3Y2UyNjMxNTY0OWE4OTcyMScNCgkJKQ0KCUlOU0VSVCBJTlRPIFNPX0JhdGNoUHJvY2Vzc1R5cGVzICgNCgkJUmVjSUQNCgkJLCBEZXNjcmlwdGlvbg0KCQksIExpc3RPZlNhbGVzT3JkZXJzVG9Qcm9jZXNzU3RvcmVkUHJvY2VkdXJlDQoJCSwgUG9zdFByb2Nlc3NpbmdTdG9yZWRQcm9jZWR1cmUNCgkJKQ0KCVZBTFVFUyAoDQoJCSdBRVJQXzUxMzdjZTI2MzE1NjQ5YTg5NzIxJw0KCQksICdBRVJQIEVuaGFuY2VkIEZpbHRlcicNCgkJLCAnQUVSUF9HZXRTYWxlc09yZGVyc1RvUHJvY2VzcycNCgkJLCAndXNwX0pJV0FfUG9zdFNhbGVzT3JkZXJQcm9jZXNzaW5nJw0KCQkpOw0KR08NCg0KQ1JFQVRFDQoJT1INCg0KQUxURVIgUFJPQ0VEVVJFIFtkYm9dLltBRVJQX0dldFNhbGVzT3JkZXJzVG9Qcm9jZXNzXSBARnJvbUludm9pY2VObyBWQVJDSEFSKDIwKSA9ICcnDQoJLCBAVG9JbnZvaWNlTm8gVkFSQ0hBUigyMCkgPSAnJw0KCSwgQEZyb21EZWJ0b3IgVkFSQ0hBUigyMDApID0gJycNCgksIEBUb0RlYnRvciBWQVJDSEFSKDIwMCkgPSAnJw0KCSwgQERlYnRvclJhbmdlSXNBY2NvdW50Tm8gQklUID0gMA0KCSwgQEZyb21SZWNvcmREYXRlIERBVEVUSU1FID0gTlVMTA0KCSwgQFRvUmVjb3JkRGF0ZSBEQVRFVElNRSA9IE5VTEwNCgksIEBGcm9tU3RhZmZTdXJuYW1lIFZBUkNIQVIoNTApID0gJycNCgksIEBUb1N0YWZmU3VybmFtZSBWQVJDSEFSKDUwKSA9ICcnDQoJLCBARnJvbUJyYW5jaERlc2NyaXB0aW9uIFZBUkNIQVIoNTApID0gJycNCgksIEBUb0JyYW5jaERlc2NyaXB0aW9uIFZBUkNIQVIoNTApID0gJycNCgksIEBTcGVjaWZpY1dhcmVob3VzZUlEIFZBUkNIQVIoMjApID0gJycNCgksIEBTcGVjaWZpY1dhcmVob3VzZUlESXNQaHlzaWNhbCBCSVQgPSAwDQoJLCBAU3BlY2lmaWNCMkJUeXBlIFNNQUxMSU5UID0gLSAxDQoJLCBAU3BlY2lmaWNCT01vZGUgU01BTExJTlQgPSAtIDENCgksIEBTcGVjaWZpY0JpbGxpbmdUeXBlIFNNQUxMSU5UID0gLSAxDQoJLCBAU3BlY2lmaWNXaG9sZXNhbGVJbnZvaWNlVHlwZSBTTUFMTElOVCA9IC0gMQ0KCSwgQE9yZGVyTnVtYmVyRmlsdGVyIFZBUkNIQVIoMTAwKSA9IE5VTEwNCkFTDQpTRVQgTk9DT1VOVCBPTg0KDQpERUNMQVJFIEBGcm9tRGVidG9yTmFtZSBWQVJDSEFSKDIwMCkNCkRFQ0xBUkUgQFRvRGVidG9yTmFtZSBWQVJDSEFSKDIwMCkNCg0KSUYgQERlYnRvclJhbmdlSXNBY2NvdW50Tm8gPSAwDQpCRUdJTg0KCVNFTEVDVCBARnJvbURlYnRvck5hbWUgPSBARnJvbURlYnRvcg0KCQksIEBUb0RlYnRvck5hbWUgPSBAVG9EZWJ0b3INCg0KCVNFTEVDVCBARnJvbURlYnRvciA9IE5VTEwNCgkJLCBAVG9EZWJ0b3IgPSBOVUxMDQpFTkQNCg0KREVDTEFSRSBATG9naWNhbElEIFZBUkNIQVIoMzYpDQpERUNMQVJFIEBQaHlzaWNhbElEIFZBUkNIQVIoMzYpDQoNCklGIEBTcGVjaWZpY1dhcmVob3VzZUlESXNQaHlzaWNhbCA9IDENCkJFR0lODQoJU0VMRUNUIEBQaHlzaWNhbElEID0gQ09BTEVTQ0UoQFNwZWNpZmljV2FyZWhvdXNlSUQsICcnKQ0KCQksIEBMb2dpY2FsSUQgPSAnJw0KRU5EDQpFTFNFDQpCRUdJTg0KCVNFTEVDVCBATG9naWNhbElEID0gQ09BTEVTQ0UoQFNwZWNpZmljV2FyZWhvdXNlSUQsICcnKQ0KCQksIEBQaHlzaWNhbElEID0gJycNCkVORA0KDQpTRUxFQ1QgU09fTWFpbi5JbnZvaWNlSUQNCgksIFNPX01haW4uSW52b2ljZU5vDQoJLCBTT19NYWluLkN1cnJlbnRIaXN0b3J5Tm8NCgksIFNPX01haW4uSW52b2ljZUluaXREYXRlDQoJLCBEQl9NYWluLkRlYnRvcklEDQoJLCBEQl9NYWluLkFjY291bnRObw0KCSwgREJfTWFpbi5OYW1lDQoJLCBTT19NYWluLk9yZGVyTm8NCkZST00gU09fTWFpbg0KSU5ORVIgSk9JTiBEQl9NYWluDQoJT04gKERCX01haW4uRGVidG9ySUQgPSBTT19NYWluLkRlYnRvcklEKQ0KSU5ORVIgSk9JTiBIUl9TdGFmZg0KCU9OIChIUl9TdGFmZi5TdGFmZklEID0gU09fTWFpbi5TdGFmZklEKQ0KSU5ORVIgSk9JTiBTWV9CcmFuY2gNCglPTiAoU1lfQnJhbmNoLkJyYW5jaElEID0gU09fTWFpbi5CcmFuY2hJRCkNCklOTkVSIEpPSU4gSU5fTG9naWNhbA0KCU9OIChJTl9Mb2dpY2FsLklOX0xvZ2ljYWxJRCA9IFNPX01haW4uSU5fTG9naWNhbElEKQ0KSU5ORVIgSk9JTiBJTl9QaHlzaWNhbA0KCU9OIChJTl9QaHlzaWNhbC5JTl9QaHlzaWNhbElEID0gSU5fTG9naWNhbC5JTl9QaHlzaWNhbElEKQ0KSU5ORVIgSk9JTiBTT19IaXN0b3J5DQoJT04gKA0KCQkJU09fTWFpbi5JbnZvaWNlSUQgPSBTT19IaXN0b3J5Lkludm9pY2VJRA0KCQkJQU5EIFNPX0hpc3RvcnkuSGlzdG9yeU5vID0gU09fTWFpbi5DdXJyZW50SGlzdG9yeU5vDQoJCQkpDQpXSEVSRSAxID0gMQ0KCUFORCBTT19NYWluLlNUQVRVUyA9IDANCglBTkQgKFNPX01haW4uRG9jVHlwZSBJTiAoMSwzKSkNCglBTkQgKFNPX01haW4uQ3JlZGl0Tm90ZSA9IDApDQoJQU5EICgNCgkJQE9yZGVyTnVtYmVyRmlsdGVyIElTIE5VTEwNCgkJT1IgQE9yZGVyTnVtYmVyRmlsdGVyID0gJycNCgkJT1IgKENIQVJJTkRFWChAT3JkZXJOdW1iZXJGaWx0ZXIsIFNPX01haW4uT3JkZXJObywgMSkgPiAwKQ0KCQkpDQoJQU5EIChEQl9NYWluLkFjY291bnRPbkhvbGQgPSAwKQ0KCS0tQU5EIChEQl9NYWluLkNyZWRpdExpbWl0ID4gMCkNCglBTkQgKA0KCQlARnJvbUludm9pY2VObyBJUyBOVUxMDQoJCU9SIEBGcm9tSW52b2ljZU5vID0gJycNCgkJT1IgU09fTWFpbi5JbnZvaWNlTm8gPj0gQEZyb21JbnZvaWNlTm8NCgkJKQ0KCUFORCAoDQoJCUBUb0ludm9pY2VObyBJUyBOVUxMDQoJCU9SIEBUb0ludm9pY2VObyA9ICcnDQoJCU9SIFNPX01haW4uSW52b2ljZU5vIDw9IEBUb0ludm9pY2VObw0KCQkpDQoJQU5EICgNCgkJQEZyb21EZWJ0b3IgSVMgTlVMTA0KCQlPUiBARnJvbURlYnRvciA9ICcnDQoJCU9SIERCX01haW4uQWNjb3VudE5vID49IEBGcm9tRGVidG9yDQoJCSkNCglBTkQgKA0KCQlAVG9EZWJ0b3IgSVMgTlVMTA0KCQlPUiBAVG9EZWJ0b3IgPSAnJw0KCQlPUiBEQl9NYWluLkFjY291bnRObyA8PSBAVG9EZWJ0b3INCgkJKQ0KCUFORCAoDQoJCUBGcm9tRGVidG9yTmFtZSBJUyBOVUxMDQoJCU9SIEBGcm9tRGVidG9yTmFtZSA9ICcnDQoJCU9SIERCX01haW4uTmFtZSA+PSBARnJvbURlYnRvck5hbWUNCgkJKQ0KCUFORCAoDQoJCUBUb0RlYnRvck5hbWUgSVMgTlVMTA0KCQlPUiBAVG9EZWJ0b3JOYW1lID0gJycNCgkJT1IgREJfTWFpbi5OYW1lIDw9IEBUb0RlYnRvck5hbWUNCgkJKQ0KCUFORCAoDQoJCUBGcm9tUmVjb3JkRGF0ZSBJUyBOVUxMDQoJCU9SIFNPX0hpc3RvcnkuUmVjb3JkRGF0ZSA+PSBARnJvbVJlY29yZERhdGUNCgkJKQ0KCUFORCAoDQoJCUBUb1JlY29yZERhdGUgSVMgTlVMTA0KCQlPUiBjb252ZXJ0KERBVEUsIFNPX0hpc3RvcnkuUmVjb3JkRGF0ZSkgPD0gY29udmVydChEQVRFLCBAVG9SZWNvcmREYXRlKQ0KCQkpDQoJQU5EICgNCgkJQEZyb21TdGFmZlN1cm5hbWUgSVMgTlVMTA0KCQlPUiBARnJvbVN0YWZmU3VybmFtZSA9ICcnDQoJCU9SIEhSX1N0YWZmLlNOYW1lID49IEBGcm9tU3RhZmZTdXJuYW1lDQoJCSkNCglBTkQgKA0KCQlAVG9TdGFmZlN1cm5hbWUgSVMgTlVMTA0KCQlPUiBAVG9TdGFmZlN1cm5hbWUgPSAnJw0KCQlPUiBIUl9TdGFmZi5TTmFtZSA8PSBAVG9TdGFmZlN1cm5hbWUNCgkJKQ0KCUFORCAoDQoJCUBGcm9tQnJhbmNoRGVzY3JpcHRpb24gSVMgTlVMTA0KCQlPUiBARnJvbUJyYW5jaERlc2NyaXB0aW9uID0gJycNCgkJT1IgU1lfQnJhbmNoLkRlc2NyaXB0aW9uID49IEBGcm9tQnJhbmNoRGVzY3JpcHRpb24NCgkJKQ0KCUFORCAoDQoJCUBUb0JyYW5jaERlc2NyaXB0aW9uIElTIE5VTEwNCgkJT1IgQFRvQnJhbmNoRGVzY3JpcHRpb24gPSAnJw0KCQlPUiBTWV9CcmFuY2guRGVzY3JpcHRpb24gPD0gQFRvQnJhbmNoRGVzY3JpcHRpb24NCgkJKQ0KCUFORCAoDQoJCUBGcm9tQnJhbmNoRGVzY3JpcHRpb24gSVMgTlVMTA0KCQlPUiBARnJvbUJyYW5jaERlc2NyaXB0aW9uID0gJycNCgkJT1IgU1lfQnJhbmNoLkRlc2NyaXB0aW9uID49IEBGcm9tQnJhbmNoRGVzY3JpcHRpb24NCgkJKQ0KCUFORCAoDQoJCUBUb0JyYW5jaERlc2NyaXB0aW9uIElTIE5VTEwNCgkJT1IgQFRvQnJhbmNoRGVzY3JpcHRpb24gPSAnJw0KCQlPUiBTWV9CcmFuY2guRGVzY3JpcHRpb24gPD0gQFRvQnJhbmNoRGVzY3JpcHRpb24NCgkJKQ0KCUFORCAoDQoJCUBMb2dpY2FsSUQgPSAnJw0KCQlPUiBJTl9Mb2dpY2FsLklOX0xvZ2ljYWxJRCA9IEBTcGVjaWZpY1dhcmVob3VzZUlEDQoJCSkNCglBTkQgKA0KCQlAUGh5c2ljYWxJRCA9ICcnDQoJCU9SIElOX1BoeXNpY2FsLklOX1BoeXNpY2FsSUQgPSBAU3BlY2lmaWNXYXJlaG91c2VJRA0KCQkpDQoJQU5EICgNCgkJQFNwZWNpZmljQjJCVHlwZSA9IC0gMQ0KCQlPUiBTT19NYWluLkludm9pY2VUeXBlIDw9IEBTcGVjaWZpY0IyQlR5cGUNCgkJKQ0KCUFORCAoDQoJCUBTcGVjaWZpY0JPTW9kZSA9IC0gMQ0KCQlPUiBTT19NYWluLkJhY2tPcmRlck1vZGUgPD0gQFNwZWNpZmljQk9Nb2RlDQoJCSkNCglBTkQgKA0KCQlAU3BlY2lmaWNCaWxsaW5nVHlwZSA9IC0gMQ0KCQlPUiBTT19NYWluLkJpbGxXaGVuQ29tcGxldGUgPD0gQFNwZWNpZmljQmlsbGluZ1R5cGUNCgkJKQ0KCUFORCAoDQoJCUBTcGVjaWZpY1dob2xlc2FsZUludm9pY2VUeXBlID0gLSAxDQoJCU9SIFNPX01haW4uV2hvbGVTYWxlSW52b2ljZSA8PSBAU3BlY2lmaWNXaG9sZXNhbGVJbnZvaWNlVHlwZQ0KCQkpDQpPUkRFUiBCWSBTT19NYWluLkludm9pY2VObw0KR08NCg0KRVhFQyBBRVJQX0dldFNhbGVzT3JkZXJzVG9Qcm9jZXNzIEBGcm9tSW52b2ljZU5vID0gTicwMDAwMDAnDQoJLCBAVG9JbnZvaWNlTm8gPSBOJzk5OTk5OScNCgksIEBGcm9tRGVidG9yID0gTicwMDAwMDAnDQoJLCBAVG9EZWJ0b3IgPSBOJzk5OTk5OScNCgksIEBEZWJ0b3JSYW5nZUlzQWNjb3VudE5vID0gMQ0KCSwgQEZyb21SZWNvcmREYXRlID0gJzIwMDUtMTAtMDIgMDA6MDA6MDAnDQoJLCBAVG9SZWNvcmREYXRlID0gJzIwMTktMDktMjQgMTc6MDk6MjknDQoJLCBARnJvbVN0YWZmU3VybmFtZSA9IE5VTEwNCgksIEBUb1N0YWZmU3VybmFtZSA9IE5VTEwNCgksIEBGcm9tQnJhbmNoRGVzY3JpcHRpb24gPSBOVUxMDQoJLCBAVG9CcmFuY2hEZXNjcmlwdGlvbiA9IE5VTEwNCgksIEBTcGVjaWZpY1dhcmVob3VzZUlEID0gTlVMTA0KCSwgQFNwZWNpZmljV2FyZWhvdXNlSURJc1BoeXNpY2FsID0gMA0KCSwgQFNwZWNpZmljQjJCVHlwZSA9IC0gMQ0KCSwgQFNwZWNpZmljQk9Nb2RlID0gLSAxDQoJLCBAU3BlY2lmaWNCaWxsaW5nVHlwZSA9IC0gMQ0KCSwgQFNwZWNpZmljV2hvbGVzYWxlSW52b2ljZVR5cGUgPSAtIDENCgksIEBPcmRlck51bWJlckZpbHRlciA9IE4nS0VZJw0KDQo=
1
1f8bac2d-83a1-406e-9267-cd6bc51ec0d6
2afbe9b3-f019-4cb7-bf33-dfa43b689362
AERP - 000 - Shared Library
Library of general-purpose shared utility helper functions
Advanced ERP
false
0