private IList <SiteInstrumentImportData> GetInDataRow(DataSet ds) { string regionName; string testingArea; string siteName; string instrumentName; int quantity; int percentRun; int rowno = 0; bool haserror; IList <ForlabSite> _referingSites = new List <ForlabSite>(); IList <ForlabSite> _validsites = new List <ForlabSite>(); IList <SiteInstrumentImportData> rdlist = new List <SiteInstrumentImportData>(); foreach (DataRow dr in ds.Tables[0].Rows) { rowno++; haserror = false; regionName = Convert.ToString(dr[0]).Trim(); //region name siteName = Convert.ToString(dr[1]).Trim(); testingArea = Convert.ToString(dr[2]).Trim(); instrumentName = Convert.ToString(dr[3]).Trim(); try { quantity = int.Parse(Convert.ToString(dr[4])); } catch { quantity = 1; } try { percentRun = int.Parse(Convert.ToString(dr[5])); } catch { percentRun = 100; } SiteInstrumentImportData rd = new SiteInstrumentImportData(rowno, regionName, siteName, testingArea, instrumentName, quantity, percentRun); rd.HasError = haserror; rdlist.Add(rd); } return(rdlist); }
private IList<SiteInstrumentImportData> GetInDataRow(DataSet ds) { string regionName; string testingArea; string siteName; string instrumentName; int quantity; int percentRun; int rowno = 0; bool haserror; IList<ForlabSite> _referingSites = new List<ForlabSite>(); IList<ForlabSite> _validsites = new List<ForlabSite>(); IList<SiteInstrumentImportData> rdlist = new List<SiteInstrumentImportData>(); foreach (DataRow dr in ds.Tables[0].Rows) { rowno++; haserror = false; regionName = Convert.ToString(dr[0]).Trim() ; //region name siteName = Convert.ToString(dr[1]).Trim(); testingArea = Convert.ToString(dr[2]).Trim(); instrumentName = Convert.ToString(dr[3]).Trim(); try { quantity = int.Parse(Convert.ToString(dr[4])); } catch { quantity = 1; } try { percentRun = int.Parse(Convert.ToString(dr[5])); } catch { percentRun = 100; } SiteInstrumentImportData rd = new SiteInstrumentImportData(rowno, regionName, siteName, testingArea, instrumentName, quantity, percentRun); rd.HasError = haserror; rdlist.Add(rd); } return rdlist; }