Skip to content

Instantly share code, notes, and snippets.

Avatar

Sergey Marenich smarenich

View GitHub Profile
View GLBatch.xml
<?xml version="1.0" encoding="UTF-8"?>
<sm:SiteMap xmlns:sm="http://acumatica.com/mobilesitemap" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<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
{
//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;
[ThreadStatic]
private static bool IsRecursive;
public static void Initialise()
{
@smarenich
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
go
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
smarenich / TableValuedDAC.cs
Created Sep 18, 2015
Table-Valued Function DAC
View TableValuedDAC.cs
namespace PX.Objects.GL
{
using System;
using PX.Data;
[System.SerializableAttribute()]
public class StatisticsView : PX.Data.IBqlTable
{
#region Code
public abstract class code : PX.Data.IBqlField
View VirtualDACs.cs
#region Filter
[Serializable]
public class YearFilter : IBqlTable
{
#region Year
public abstract class year : PX.Data.IBqlField { }
[PXDBInt()]
[PXDefault(2014)]
[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;
//[PXVirtualDAC]
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)]
[PXCustomizeSelectorColumns(
typeof(PX.Objects.CR.Location.locationCD),
typeof(PX.Objects.CR.Location.descr),
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.