private List <Segment> GetChildren(int seqSegment) { List <Segment> children = new List <Segment>(); using (DataSet1TableAdapters.INTEGRATOR_SEGMENTTableAdapter segmentTableAdapter = new DataSet1TableAdapters.INTEGRATOR_SEGMENTTableAdapter()) { using (DataSet1.INTEGRATOR_SEGMENTDataTable childrenSegmentDataTable = new DataSet1.INTEGRATOR_SEGMENTDataTable()) { try { segmentTableAdapter.FillByParent(childrenSegmentDataTable, seqSegment); foreach (var childrenSegmentRow in childrenSegmentDataTable) { Segment segment = new Segment(); int intTemp; string stringTemp; if (int.TryParse(childrenSegmentRow["SEQ"].ToString(), out intTemp)) { segment.seq = intTemp; if (int.TryParse(childrenSegmentRow["SEQ_PARENT_SEGMENT"].ToString(), out intTemp)) { seqParent = intTemp; } segment.tag = childrenSegmentRow["TAG"].ToString(); segment.dbTable = childrenSegmentRow["DB_TABLE"].ToString(); segment.dbWhere = childrenSegmentRow["DB_WHERE"].ToString(); segment.dateFilter = childrenSegmentRow["DB_COLUMN_DATE_FILTER"].ToString(); stringTemp = childrenSegmentRow["MAIN_SEGMENT"].ToString(); segment.main = (stringTemp == "Y") ? true : false; segment.GetFields(); segment.GenerateSQL(); segment.segments = GetChildren(segment.seq); children.Add(segment); } } } catch (Exception ex) { Logger.AddToFile(ex.ToString()); } } } return(children); }
private void GetSegments() { using (DataSet1TableAdapters.INTEGRATOR_SEGMENTTableAdapter segmentTableAdapter = new DataSet1TableAdapters.INTEGRATOR_SEGMENTTableAdapter()) { using (DataSet1.INTEGRATOR_SEGMENTDataTable rootSegmentDataTable = new DataSet1.INTEGRATOR_SEGMENTDataTable()) { try { segmentTableAdapter.FillRoot(rootSegmentDataTable, seq); segmentList.Clear(); foreach (var rootSegmentRow in rootSegmentDataTable) { Segment segment = new Segment(); int intTemp; string stringTemp; if (int.TryParse(rootSegmentRow["SEQ"].ToString(), out intTemp)) { segment.seq = intTemp; segment.tag = rootSegmentRow["TAG"].ToString(); segment.dbTable = rootSegmentRow["DB_TABLE"].ToString(); segment.dbWhere = rootSegmentRow["DB_WHERE"].ToString(); segment.dateFilter = rootSegmentRow["DB_COLUMN_DATE_FILTER"].ToString(); segment.fileHeader = rootSegmentRow["FILE_HEADER"].ToString(); stringTemp = rootSegmentRow["MAIN_SEGMENT"].ToString(); segment.main = (stringTemp == "Y") ? true : false; segment.GetFields(); segment.GenerateSQL(); segment.segments = GetChildren(segment.seq); segmentList.Add(segment); } } } catch (Exception ex) { Logger.AddToFile(ex.ToString()); } } } }