COBOL TO SQL

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace SIC_SQL
{
    public class Champ
    {

        public ILigne parentline;
        public List<Champ> childline;
        public table tble;
    
        public Champ(ILigne line)
        {
            parentline = line;
            childline = new List<Champ>();
        }

        public Champ(ILigne line, List<Champ> lines)
        {
            parentline = line;
            childline = new List<Champ>();
            lines.ForEach(l => childline.Add(l));
        }
       

        public Champ()
        {
            // TODO: Complete member initialization

            childline = new List<Champ>();
        }
        public string Nom
        {
            get
            {
               return this.parentline.Nom.Contains('.') ? this.parentline.Nom.Remove(this.parentline.Nom.Length - 1, 1) : this.parentline.Nom;
            }
        }

        public int TailleTotal { get; set; }

        public int Valeur
        {
            get
            {
                
                return childline.Sum(c => c.parentline.Valeur) + this.parentline.SQLType.getTotal();

            }

        }

        public string SQLType()
        {
            if (childline.Count == 0)
            {
                return parentline.lineToSQL();
            }
            else
            {
                return string.Format(" [{0}]    Varchar({1}), ", this.Nom, this.Valeur);
            }
        }

        public string SQLBaseView()
        {
            return string.Format("SUBSTRING(DATA,{0},{1})  [{2}],", this.TailleTotal, this.Valeur, this.Nom);
        }

      

        public List <string> SQLView()
        {
            //convert(smallint, substring([ABOF-INCIDCHQ],1,2))  [ABOF-NBINCHQ] , 
            //  substring([ABOF-EXOTAXE],1,3)  [ABOF-EXOTIMB] , 
            List<string> lst = new List<string>();
            lst.Add(string.Format(" [{0}] , ", this.Nom));
            if (childline.Count != 0)
            {
                 int total=1;             
               // childline.ForEach(e => lst.Add(this.parentline.SQLView(e.parentline,total++)));

                 foreach (var e in childline)
                 {
                     lst.Add(this.parentline.SQLView(e.parentline, total));
                     total += e.parentline.SQLType.getTotal();
                 }
                
            }
           
           
            return lst;
        }


        public List<Champ> Duppliquer()
        {
            List<Champ> result = new List<Champ>();
            if (parentline.isOccurs)
            {
                int total = parentline.Occurs;
                int i = 1;
                while (i <= total)
                {
                    OccursLigne line = new OccursLigne(parentline, i);
                    List<Champ> oclines = new List<Champ>();
                 
                    foreach (var tmpline in childline )
                    {
                        ILigne ll = new OccursLigne(tmpline.parentline, i);
                        oclines.Add (new Champ (ll) );
                    }

                    Champ tmpchamp = new Champ(line, oclines);
                    result.Add(tmpchamp);
                    i++;
                }
            }
            return result;
        }
    }
}