DTSSAT.cs

using sage.ew.db;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace sage.addons.services.Negocio.DTS
{
    public class DTSSAT
         : BaseDTS
    {
        public override string _NombreProceso()
        {
            return "SAT";
        }

        protected override List<string> _Tables
        {
            get
            {
                return new List<String>() { "SERATTEC" };
            }
        }

        protected override bool _Import(String tcTable, Dictionary<String, Object> toParams)
        {
            String lcSql;
            List<TraspasColumn> loColumns = new List<TraspasColumn>();

            loColumns.Add(new TraspasColumn("CODIGO"));
            loColumns.Add(new TraspasColumn("CODPOS"));
            loColumns.Add(new TraspasColumn("DIRECCION"));
            loColumns.Add(new TraspasColumn("EMAIL"));
            loColumns.Add(new TraspasColumn("NOMBRE"));
            loColumns.Add(new TraspasColumn("POBLACION"));
            loColumns.Add(new TraspasColumn("PROVINCIA"));
            loColumns.Add(new TraspasColumn("TELEFONO"));
            loColumns.Add(new TraspasColumn("TELEFONO2"));
            loColumns.Add(new TraspasColumn("TELEFONO3"));

            lcSql = String.Format("INSERT INTO {0} ({2}) SELECT {3} FROM  {1};", DB.SQLDatabase("SERVICES", tcTable), DB.SQLDatabase("SERVEIS", tcTable), String.Join(",", loColumns.Select(f => f._ColumnNameDest)), String.Join(",", loColumns.Select(f => f._ColumnNameOri)));

            return _SQLExec(lcSql);
        }
    }
}