public object Get(string showCode, string entityId)
        {
            PreviewDTO    pDTO  = new PreviewDTO();
            SQLDataHelper SQLDA = new SQLDataHelper();

            eventBitEntities entities = new eventBitEntities();

            var entityState = entities.EntityStates.FirstOrDefault(x => x.ShowCode == showCode && x.EntityID == entityId);

            DataTable dt = new DataTable();

            if (entityState != null)
            {
                dt = SQLDA.GetEntityDataTable(entityId, (entityState.sysEventId ?? 0));

                pDTO.Columns = dt.Columns.Cast <DataColumn>().Where(x => !x.ColumnName.StartsWith("sys"))
                               .Select(x => Char.ToLowerInvariant(x.ColumnName[0]) + x.ColumnName.Substring(1))
                               .ToArray();

                pDTO.SysRowStampNumMax = entityState.sysRowStampNumMax.ToString();

                pDTO.RowCount = SQLDA.GetRowCountForEntity(entityId, (entityState.sysEventId ?? 0));
            }

            pDTO.Data = dt;

            return(pDTO);
        }