Skip to content

Instantly share code, notes, and snippets.


Sergey Marenich smarenich

View GitHub Profile
View GLBatch.xml
<?xml version="1.0" encoding="UTF-8"?>
<sm:SiteMap xmlns:sm="" xmlns:xsi="">
<sm:Screen Id="GL301000" Type="SimpleScreen" DisplayName="Journal Transactions" Visible="true" Icon="system://NewsPaper" IsDefaultFavorite="true">
<sm:Container Name="BatchSummary" FieldsToShow="3">
<sm:Attachments Disabled="true" />
<sm:Field Name="BatchNumber" />
<sm:Field Name="TransactionDate" />
<sm:Field Name="Description" />
View DatabaseSlot.cs
public class DatabaseSlotsExample : IPrefetchable
protected List<string> values = new List<string>(); // store your values here
public static List<string> Values
//Get the values from the slot dynamically. By providing table name, you inform system when it should reset the slot.
return PXDatabase.GetSlot<DatabaseSlotsExample>("SlotSuperKey", typeof(YourTable)).values;
View SessionLogger.cs
using System;
using System.Collections.Generic;
using System.Collections.Specialized;
using System.Data.SqlClient;
using System.Diagnostics;
using System.Runtime.ExceptionServices;
using System.Runtime.Serialization;
using System.Text;
using System.Threading;
using System.Web;
View Logger.cs
public static class Logger
private const uint HRFileLocked = 0x80070020;
private const uint HRPortionOfFileLocked = 0x80070021;
private static bool IsRecursive;
public static void Initialise()
smarenich / TableValuedSQL.sql
Last active Sep 18, 2015
Table-Valued Function SQL
View TableValuedSQL.sql
if exists(select * from sys.objects where object_id = object_id('sp_GetBalanceSheet'))
drop function sp_GetBalanceSheet
CREATE FUNCTION dbo.sp_GetBalanceSheet(@period char(6))
RETURNS @statistics TABLE (
CompanyID int not null default(0),
Code int not null Identity(1,1),
BranchID int not null,
Description nvarchar(255) not null,
Balance decimal(19,4) not Null
smarenich / TableValuedDAC.cs
Created Sep 18, 2015
Table-Valued Function DAC
View TableValuedDAC.cs
namespace PX.Objects.GL
using System;
using PX.Data;
public class StatisticsView : PX.Data.IBqlTable
#region Code
public abstract class code : PX.Data.IBqlField
View VirtualDACs.cs
#region Filter
public class YearFilter : IBqlTable
#region Year
public abstract class year : PX.Data.IBqlField { }
[PXUIField(DisplayName = "Year")]
[PXIntList(new Int32[] { 2013, 2014, 2015}, new String[] { "2013", "2014", "2015"})]
View VirtualMaint.cs
public class YearGroupMaint : PXGraph<YearGroupMaint>
public PXFilter<YearFilter> Filter;
public PXSelect<VirtualComparasion> Comparasions;
public PXSelect<YearGroup, Where<YearGroup.year, Equal<Required<YearGroup.year>>, Or<YearGroup.year, Equal<Required<YearGroup.year>>>>> YearGroups;
public PXCancel<YearFilter> Cancel;
public IEnumerable comparasions()
View SelectorColumn.cs
public class SOOrderExtension : PXCacheExtension<PX.Objects.SO.SOOrder>
#region CustomerLocationID
public abstract class customerLocationID : PX.Data.IBqlField
[PXMergeAttributesAttribute(Method = MergeMethod.Merge)]
View TableSpace.sql
create table #space
tn varchar(128),
rows varchar(128),
reserved varchar(128),
data varchar(128),
indexp varchar(128),
unused varchar(128)