public static void ProcessSample(RADSampleRow row, StringBuilder resultCollection) { RADResultTableAdapter result = new RADResultTableAdapter(); result.Fill(lims.RADResult, row.SAMPNO); RADSampleAnalysisResult res = null; int i = 1; foreach (RADResultRow r in lims.RADResult.Rows) { res = new RADSampleAnalysisResult(r, row, i); resultCollection.Append(res.FetchSampleXML()); i++; } }
public RADSampleAnalysisResult(RADResultRow row, RADSampleRow sampleRow, int recordID) { InitSampleResultNode(); this.RecordID = recordID.ToString(); this.LabSampleIdentifier = row.SAMPNO; this.PWSIdentifier = string.Format("SC{0}", sampleRow.LOCCODE.Split('-')[0]); this.SampleCollectionEndDate = sampleRow.COLDATE.ToString("yyyy-MM-dd"); this.LabAccreditationIdentifier = "SCRAD"; this.LabAccreditationAuthorityName = "STATE"; this.AnalysisResult = FetchAnalysisResult(row.ANALYTE, row.RESULT); this.AnalyteCode = FetchAnalyteCodeByAnalyte(row.ANALYTE); this.MeasurementQualifier = "Y"; this.MeasurementValue = row.MDL; this.MeasurementUnit = row.RLTUNIT.Trim().ToUpper(); this.MeasurementSignificantDigit = "6"; this.DataQualityCode = "A"; }
public RADSample(RADSampleRow row, int rowNum) { InitSampleNode(); if (row.LOCCODE.Contains("-")) { this.RecordID = rowNum.ToString(); this.LabSampleIdentifier = row.SAMPNO; this.PWSIdentifier = string.Format("SC{0}", row.LOCCODE.Split('-')[0]); this.PWSFacilityIdentifier = row.LOCCODE.Split('-')[1]; this.SampleRuleCode = "GE"; this.SampleMonitoringTypeCode = "RT"; this.ComplianceSampleIndicator = "Y"; this.AdditionalSampleIndicator = "N"; this.SampleCollectionEndDate = row.COLDATE.ToString("yyyy-MM-dd"); this.SampleCollectionEndTime = row.COLDATE.ToString("hh:mm:ss"); this.SampleLocationIdentifier = row.LOCCODE.Split('-')[1]; this.StateClassificationCode = "RAD"; } }