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