Skip to content

Instantly share code, notes, and snippets.

Sergey Marenich smarenich

Block or report user

Report or block smarenich

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
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)
You can’t perform that action at this time.