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); }