smarenich

SELECT

	  db_name(s2.dbid),
      ( SELECT TOP 1 SUBSTRING(s2.text,  r.statement_start_offset / 2, 
      ( (CASE WHEN r.statement_end_offset = -1 THEN (LEN(CONVERT(nvarchar(max),s2.text)) * 2) 
      ELSE r.statement_end_offset END)  - r.statement_start_offset) / 2)  )  AS sql_statement,
      r.logical_reads
FROM 
      sys.dm_exec_requests r 
      CROSS APPLY sys.dm_exec_sql_text(sql_handle) AS s2

smarenich

SELECT top 30 total_worker_time/execution_count AS AvgCPU  
, total_worker_time AS TotalCPU
, total_elapsed_time/execution_count AS AvgDuration  
, total_elapsed_time AS TotalDuration  
, (total_logical_reads+total_physical_reads)/execution_count AS AvgReads 
, (total_logical_reads+total_physical_reads) AS TotalReads
, execution_count   
, SUBSTRING(st.TEXT, (qs.statement_start_offset/2)+1  
, ((CASE qs.statement_end_offset  WHEN -1 THEN datalength(st.TEXT)  
ELSE qs.statement_end_offset  

smarenich

select 
  CompanyID, 
  BatchID, 
  ChangeID, 
  ScreenID,
  (Select top 1 username from Users u where PKID = UserID), 
  ChangeDate, 
  Operation,
  REPLACE(CAST(CAST(CombinedKey AS VARCHAR(max)) AS VARBINARY(max)),   0x0, ','),
  REPLACE(CAST(CAST(ModifiedFields AS VARCHAR(max)) AS VARBINARY(max)),   0x0, ',')

smarenich

//PXSearchable for GL Batch
[PXSearchable(
  SM.SearchCategory.GL, 
  "{0} {1} - {2}", 
  new Type[] { typeof(Batch.module), typeof(Batch.batchNbr), typeof(Batch.branchID) },
  new Type[] { typeof(Batch.ledgerID), typeof(Batch.description), typeof(BatchExt.usrExternarLeference) },
  NumberFields = new Type[] { typeof(Batch.batchNbr) },
  Line1Format = "{0}{1}{2:d}", 
  Line1Fields = new Type[] { typeof(Batch.ledgerID), typeof(Batch.finPeriodID), typeof(Batch.dateEntered) },
  Line2Format = "{0}", Line2Fields = new Type[] { typeof(Batch.description) }

smarenich

	public class SomeMaint : PXGraph<SomeMaint>
	{
		public PXSelect<UnionTable> UnionSelect;

		protected IEnumerable unionSelect()
		{
			List<UnionTable> result = new List<UnionTable>();

			foreach (SomeTable1 row in PXSelect<SomeTable1>.Select(this))
			{

smarenich

		//Defining action DataView
		public PXAction<MyDAC> MyButton;
		//Defining Button Attribute with tooltip
		[PXButton(Tooltip = PX.Data.Update.Messages.MyTooltip)]
		//Providing title and mapping action access rights
		[PXUIField(DisplayName = "MyTitle", MapEnableRights = PXCacheRights.Delete, MapViewRights = PXCacheRights.Delete)]
		protected void myButton()
		{
			WebDialogResult result = Companies.Ask(ActionsMessages.Warning, PXMessages.LocalizeFormatNoPrefix("My Message"), 
				MessageButtons.OKCancel, MessageIcon.Warning, true);

smarenich

		public PXAction<MyDAC> MyButton;
		[PXButton(Tooltip = PX.Data.Update.Messages.MyTooltip)]
		[PXUIField(DisplayName = "MyTitle", MapEnableRights = PXCacheRights.Delete, MapViewRights = PXCacheRights.Delete)]
		protected void myButton()
		{
			if (MyPanel.AskExt(true) != WebDialogResult.OK) return;
			
			//Do some useful Stuff
		}
		

smarenich

	<px:PXSmartPanel ID="pnlCopyCompany" runat="server" CaptionVisible="True" Caption="My Command"
		Style="position: static" LoadOnDemand="True" Key="MyPanel" AutoCallBack-Target="frmMyCommand"
		AutoCallBack-Command="Refresh" DesignView="Content">
		<px:PXFormView ID="frmMyCommand" runat="server" SkinID="Transparent" DataMember="MyPanel"	DataSourceID="ds" EmailingGraph="">
			<Template>
				<px:PXLayoutRule runat="server" ControlSize="M" LabelsWidth="M" StartColumn="True" />
				<px:PXLabel ID="lblWarning" runat="server" Encode="True">
					WARNING: Some Action.
				</px:PXLabel>
				<px:PXSelector ID="edMyField" runat="server" AutoRefresh="True" DataField="MyField" DataSourceID="ds" />

smarenich

static void Main(string[] args)
{
	using (DefaultSoapClient client = new DefaultSoapClient())
	{
		client.Endpoint.Address = new System.ServiceModel.EndpointAddress("https://localhost/demo/entity/Default/5.30.001");
		client.Login("admin", "123", "Demo", null, null);

		Console.WriteLine("Get all Stock Items");
		//retrieveAllEntities force system to retrive details and linked entities
		Entity[] items = client.GetList(new StockItem(), false);

smarenich

public const string SessionKey = "MyFileImportSessionKey";
		
public PXAction<GLTran> UploadFileBatch;
[PXUIField(DisplayName = "Upload File as Batches", MapEnableRights = PXCacheRights.Select, MapViewRights = PXCacheRights.Select, Visible = true)]
[PXButton()]
public virtual IEnumerable uploadFileBatch(PXAdapter adapter)
{
	//Ask user to upload file, continue if it is OK
	if (this.NewFilePanel.AskExt() == WebDialogResult.OK)
	{