// Define connection string databaseServerInstance = @"vma-200"; string companyDatabase = @"SBODemoCH"; // Get connection to designer based on configuration file var conf = CoresuiteServiceAPI.Designer.ConnectionManager.Instance.GetConnection(databaseServerInstance, companyDatabase); // Get the print api for the connection var api = new CoresuiteServiceAPI.Designer.PrintAPI(conf); // Create a query to get open/not printed sales orders var query = new CoresuiteServiceAPI.SqlQuery(companyDatabase); string printQuery = @" SELECT TOP 10 ""DocEntry"", ""DocNum"" FROM ""ORDR"" WHERE ""DocStatus"" = 'O' AND ""Printed"" = 'N'"; using (var rdr = query.ExecuteReader(printQuery)) { while (rdr.Read()) { string docEntry = rdr["DocEntry"].ToString(); string docNum = rdr["DocNum"].ToString(); // ProcessedSalesOrders is a list defined in the extended code. It is used to ensure that each document is only processed once. if (!ProcessedSalesOrders.Contains(docEntry)) { ProcessedSalesOrders.Add(docEntry); api.ExecutePrintDef("DocSalesOrder", CoresuiteServiceAPI.Designer.PrintAPI.OpenLayoutModes.PDF, "DocEntry", docEntry); CoresuiteServiceAPI.DebugLog.Info(companyDatabase, "Processed Sales Order Document No: " + docNum + " (DocEntry " + docEntry + ")" ); } } } CoresuiteServiceAPI.DebugLog.Info(companyDatabase, "Rule successfully executed: SAMPLE: Print Open Sales Orders"); 2022-11-30T00:00:00009999-12-31T00:00:0020000000CS// This rule demonstrates how to use load balancing for printing. // Prerequisites: Multiple designer instances must have been set up in the service configuration file. // This sample assumes that 3 instances have been configured to run concurrently. // The relevant configuration element would look as follows: // <designer instancecount="3"/> // Define connection string databaseServerInstance = @"vma-200"; string companyDatabase = @"SBODemoCH"; // Get connection to designer based on configuration file var conf = CoresuiteServiceAPI.Designer.ConnectionManager.Instance.GetConnection(databaseServerInstance, companyDatabase); // Get the print apis for the connection var apis = new System.Collections.Generic.Dictionary<int, CoresuiteServiceAPI.Designer.PrintAPI>(); apis.Add(0, new CoresuiteServiceAPI.Designer.PrintAPI(conf, 0)); apis.Add(1, new CoresuiteServiceAPI.Designer.PrintAPI(conf, 1)); apis.Add(2, new CoresuiteServiceAPI.Designer.PrintAPI(conf, 2)); // Create a query to get open/not printed sales orders var query = new CoresuiteServiceAPI.SqlQuery(companyDatabase); string printQuery = @" SELECT TOP 9 ""DocEntry"", ""DocNum"" FROM ""ORDR"" WHERE ""DocStatus"" = 'O' AND ""Printed"" = 'N'"; // Start with print api #0 int counter = 0; using (var rdr = query.ExecuteReader(printQuery)) { while (rdr.Read()) { string docEntry = rdr["DocEntry"].ToString(); string docNum = rdr["DocNum"].ToString(); // ProcessedSalesOrders is a list defined in the extended code. It is used to ensure that each document is only processed once. if (!ProcessedSalesOrders.Contains(docEntry)) { ProcessedSalesOrders.Add(docEntry); apis[counter].ExecutePrintDef("DocSalesOrder", CoresuiteServiceAPI.Designer.PrintAPI.OpenLayoutModes.PDF, "DocEntry", docEntry); CoresuiteServiceAPI.DebugLog.Info(companyDatabase, "Processed Sales Order Document No: " + docNum + " (DocEntry " + docEntry + ")" ); // Next loop, use another print api counter++; if (counter > 2) { counter = 0; } } } } CoresuiteServiceAPI.DebugLog.Info(companyDatabase, "Rule successfully executed: SAMPLE: Print Open Sales Orders Load Balancing"); 2022-11-30T00:00:00009999-12-31T00:00:0020000000CS