This topic does not exist yet

Standalone Script is used for starting a logic individually from Produmex WMS by the WMS robot tool. It can be scheduled in the Windows Scheduler. This can be for example a very complex replenishment order generation.

Necessary classes:

Class	Reference
TransactionScope	using System.Transactions;
PmxDbConnection	using Produmex.Foundation.Data.Sbo;

Steps:

1. Define the connection string:

Copy your connection string text from any config file of the Produmex WMS tools or Fat Client application.

private static string CONNECTION_STRING = “”;

2. Start a transaction:

using (TransactionScope scope = PmxDbConnection.GetNewTransactionScope())

3. Create the connection:

using (PmxDbConnectionDirect conn = PmxDbConnectionMgr.GetDirectConnection(SboConnectionString.ParseStringToObject(CONNECTION_STRING)))

Example:

using ( TransactionScope scope = 
PmxDbConnection.GetNewTransactionScope())
{
      using (PmxDbConnectionDirect conn = PmxDbConnectionMgr.GetDirectConnection(SboConnectionString.ParseStringToObject(CONNECTION_STRING)))
{
conn.Open();
                    Console.WriteLine("Connection is open");

       	             string query = @"SELECT TOP 1 DocEntry FROM PMX_PLHE WHERE DocStatus = 'O' ORDER BY DocEntry ";

             	       using (ISboRecordset rs1 = SboRecordsetHelper.RunQuery(s_log, query, conn))
                    	{
                        while (!rs1.EoF)
       	                 {
					… Do Something … 
             	               rs1.MoveNext();
                        }
       	             }
      	             }
                    scope.Complete();	//Complete transaction
}

Admin Detach Close

You've followed a link to a topic that doesn't exist yet. If permissions allow, you may create it by clicking on Create this page.

3. Standalone Script

3.1. Database Connection

This topic does not exist yet