COBOL TO SQL

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

namespace SIC_SQL
{
    public class Child : IChildItem<Field>
    {
        public ILigne line;

        public Field ParentObject { get; internal set; }

        #region IChildItem<Parent> Members

        Field IChildItem<Field>.Parent
        {
            get
            {
                return this.ParentObject;
            }
            set
            {
                this.ParentObject = value;
            }
        }

        #endregion

       
    }
    public class Field
    {
        public Field()
        {
            this.childline = new ChildItemCollection<Field, Child>(this);
        }

        public ILigne parentline;

        public ChildItemCollection<Field, Child> childline { get; private set; }

        #region mes champs
        public string Nom
        {
            get
            {
                if (childline.Count == 0)
                {
                    return this.parentline.Nom;
                }
                else
                {
                    return this.parentline.Nom.Remove(this.parentline.Nom.Length - 1, 1);
                }
            }
        }

        public int TailleTotal { get; set; }

        public int Valeur
        {
            get
            {
                
                var valeur = childline.Sum(c => c.line.Valeur); 
                return 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()
        {
            List<string> lst = new List<string>();
            if (childline.Count == 0)
            {
                lst.Add(string.Format(" [{0}] , ", this.Nom));


            }
            else
            {
                

                foreach (var e in childline)
                {
                    lst.Add(e.line.SQLLoadView());
                }
            }
            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.line, i);
                        oclines.Add(new Champ(ll));
                    }

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


}