ETWeb Technical Training презентация

ETWeb System Components

ETWeb Architecture

ETWeb Frontend - Web Server
ASP
ASP Include files
ASP.NET
Components
ETWebAspLib VB6 library
ETWeb .NET Libraries
(Core.dll, Web.dll)

ASP Pages / ASP.NET Pages
Mostly ASP
Page & List Forms
ASP.NET for i-GRasp data & HR Analytics
Each form has own SPs (_List, _Get & _Save SPs)
ASP Include files

App Pools / Folder changes
v10: 32bit App Pool
64bit App Pool
32bit App Pool
v11: 2x different App Pools: 64bit/32bit
64bit App Pool

Database
SQL Server 2005 & 2008
ERWIN used to create DB Tables, triggers etc.
ALL access through SPs
Each forms has dedicated SPs (_List, _Get & _Save SPs)
Select SPs for the drop down lists (Code Tables)
Get SPs for Components

Database Naming Conventions
Form SPs: pfrm*_Get
pzfrm*_Get
pfrm*_Save
pzfrm*_Save
pfrm*_List
pfrm*_List
pfrm*_Del
pfrm*_Del
Select SPs: psel*_Get
pzsel*_Get
Filter SPs: pFilter*_List,
pzFilter*_List
Find SPs: pFind*_Search
Report SPs: pdsrpt*
Excel Rpt SPs: pdsxls*
Metric SPs: pmet*_List
Dashboard SPs: pds*
Workflow Role SPs: pzUserRole*_Get
Load SPs: *_Load
Functions: f*
Trigger: q*
Views: v*, vz*
Filter Builder Views: vds*

ETWebAspLib (EWAL)
VB6 Library
Form Controls & Centralized functionality for ASP Pages
Link to .NET Components via ETWebAspLibAdapter
One version per Server (Found in C:\Program Files\Common Files\ExecuTRACK Software AG\ETWeb 10.x\EWAL)
Registered with regsvr32
ETWebAspLibAdapter .NET library registered with COMs (regasm)

.NET Components
Found in the bin folder
ETWeb dlls:
StepStone.ETWeb.Core.dll
StepStone.ETWeb.Web.dll
StepStone.Solutions.Security.SingleSignOn.dll
StepStone.ETWeb.Services.IgraspIntegration.dll
StepStone.Igrasp.Services.Shared.dll