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());
}
}
}
}
