material_quantity_report

Code Template

var groupHandle = "SAMPLE_LINE_GROUP_HANDLE";
var materialListGuid = "MATERIAL_LIST_GUID";
var startStation = double.NaN;
var endStation = double.NaN;
var limit = 200;
var isHandle = new Func<string, bool>(value =>
    !string.IsNullOrWhiteSpace(value)
    && System.Text.RegularExpressions.Regex.IsMatch(value, "^[0-9A-Fa-f]{1,16}$")
    && long.TryParse(value, System.Globalization.NumberStyles.HexNumber,
        System.Globalization.CultureInfo.InvariantCulture, out var parsed) && parsed > 0);
if (!isHandle(groupHandle) || !Guid.TryParse(materialListGuid, out var listGuid) || listGuid == Guid.Empty)
    return new { success = false, error = "Configure an existing groupHandle and nonempty materialListGuid." };
if (!Double.IsFinite(startStation) || !Double.IsFinite(endStation) || endStation < startStation || limit < 1 || limit > 1000)
    return new { success = false, error = "Station range must be finite/ordered and limit must be 1..1000." };

// Host access starts here.
ObjectId groupId;
try { groupId = Database.GetObjectId(false, new Handle(Convert.ToInt64(groupHandle, 16)), 0); }
catch { return new { success = false, error = "groupHandle does not resolve in this drawing." }; }
var group = Transaction.GetObject(groupId, OpenMode.ForRead) as SampleLineGroup;
if (group == null || group.IsErased)
    return new { success = false, error = "groupHandle must identify an existing SampleLineGroup." };
if (group.GetSampleLineIds().Count > 5000)
    return new { success = false, error = "The group exceeds this recipe's 5000-sample scan bound." };
QTOMaterialList selected = null;
foreach (QTOMaterialList list in group.MaterialLists)
    if (list.Guid == listGuid) { selected = list; break; }
if (selected == null) return new { success = false, error = "The selected material-list GUID is not in this group." };
var alignment = Transaction.GetObject(group.ParentAlignmentId, OpenMode.ForRead) as Alignment;
if (alignment == null || alignment.StationEquations.Count != 0)
    return new { success = false, error = "The parent alignment must exist and have no station equations in this first scope." };
var rows = new List<object>();
var total = 0;
var invalid = 0;
var sumCut = 0.0;
var sumFill = 0.0;
var sumUsable = 0.0;
using (var takeoff = group.GetTotalVolumeResultDataForMaterialList(listGuid))
{
    var sections = takeoff.GetResultsAlongSampleLines();
    if (sections.Length > 5000)
        return new { success = false, error = "The QTO result exceeds this recipe's 5000-record scan bound." };
    foreach (var section in sections.OrderBy(s => s.Station))
    {
        if (!Double.IsFinite(section.Station)) { invalid++; continue; }
        if (section.Station < startStation || section.Station > endStation) continue;
        total++;
        var volume = section.VolumeResult;
        var numbers = new[] {
            volume.CumulativeCutVolume, volume.CumulativeFillVolume, volume.CumulativeUsableVolume,
            volume.IncrementalCutVolume, volume.IncrementalFillVolume, volume.IncrementalUsableVolume
        };
        if (numbers.Any(v => !Double.IsFinite(v))) { invalid++; continue; }
        sumCut += volume.IncrementalCutVolume;
        sumFill += volume.IncrementalFillVolume;
        sumUsable += volume.IncrementalUsableVolume;
        if (rows.Count < limit)
            rows.Add(new {
                station = section.Station, sampleLineName = section.SampleLineName,
                sampleLineHandle = section.SampleLineId.IsNull ? null : section.SampleLineId.Handle.ToString(),
                cumulativeCut = volume.CumulativeCutVolume, cumulativeFill = volume.CumulativeFillVolume,
                cumulativeUsable = volume.CumulativeUsableVolume,
                incrementalCut = volume.IncrementalCutVolume, incrementalFill = volume.IncrementalFillVolume,
                incrementalUsable = volume.IncrementalUsableVolume
            });
    }
}
if (!Double.IsFinite(sumCut) || !Double.IsFinite(sumFill) || !Double.IsFinite(sumUsable))
    throw new InvalidOperationException("Quantity totals overflowed; no misleading result is returned.");
return new {
    success = true, groupHandle = group.Handle.ToString(), groupName = group.Name,
    alignmentName = alignment.Name, materialListName = selected.Name, materialListGuid = selected.Guid.ToString(),
    calculationMethod = group.MaterialLists.VolumeCalculationMethodType.ToString(),
    drawingLengthUnits = CivilDoc.Settings.DrawingSettings.UnitZoneSettings.DrawingUnits.ToString(),
    volumeUnits = "cubic drawing units", startStation, endStation,
    total, returned = rows.Count, truncated = total > rows.Count, limit, invalid,
    incrementalTotalsForSelectedEndingStations = new { cut = sumCut, fill = sumFill, usable = sumUsable },
    totalsComplete = invalid == 0, rows
};