public static void ProcessSample(SAMPLERow row, StringBuilder resultCollection) { RESULTTableAdapter result = new RESULTTableAdapter(); result.Fill(lims.RESULT, row.SAMPNO); LIMSSampleAnalysisResult res = null; int i = 1; foreach (RESULTRow r in lims.RESULT.Rows) { res = new LIMSSampleAnalysisResult(r, row, i); resultCollection.Append(res.FetchSampleXML()); i++; } }
public LIMSSampleAnalysisResult(RESULTRow row, SAMPLERow sampleRow, int recordID) { InitSampleNode(); 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 = "40201"; this.LabAccreditationAuthorityName = "STATE"; this.AnalyteCode = row.ANALYTENUM; this.DetectionLimitTypeCode = "MRL"; this.MeasurementQualifier = "Y"; this.MeasurementValue = row.MDL; this.MeasurementUnit = row.RLTUNIT.Trim().ToUpper(); this.MeasurementSignificantDigit = "6"; this.DataQualityCode = "A"; }
public LIMSSample(SAMPLERow 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]; } }