HYTOS

using System;

using System.Collections.Generic;

using System.Configuration;

using System.Data;

using System.Data.Common;

using System.Data.SqlClient;

using System.IO;

using Autodesk.AutoCAD.ApplicationServices;

using Autodesk.AutoCAD.ApplicationServices.Core;

using Autodesk.AutoCAD.DatabaseServices;

using Autodesk.AutoCAD.EditorInput;

using Autodesk.AutoCAD.Geometry;

using Autodesk.AutoCAD.Interop;

using Autodesk.AutoCAD.Interop.Common;

using Autodesk.AutoCAD.Runtime;

using Autodesk.AutoCAD.Windows;

using AVEVA.PID.CustomizationUtility.DB;

using AVEVA.PID.CustomizationUtility.Model;

using AVEVA.PID.CustomizationUtility.Properties;

namespace AVEVA.PID.CustomizationUtility

{

    public class AutoModeling

    {

        Model.Document document;

        public AutoModeling(Model.Document document)

        {

            this.document = document;

        }

        public void Run()

        {

            if (APIDUtils.CreateDrawingAndOpen(document.AvevaDrawingNumber, document.AvevaSheetNumber, document.AvevaTemplateName, document.AvevaTemplateID))

            {

                test();

            }

        }

        private string ReadDrawingLastLine()

        {

            string sHandle = string.Empty;

            SqlConnection connection = null;

            try

            {

                connection = new SqlConnection();

                connection.ConnectionString = DB.Project_DB.GetAvevaConnectionString();

                connection.Open();

                string strQry = string.Format("Select Handle from Pipe Where id = (SELECT MAX(id) FROM Pipe WHERE DrawingId = '{0}')", "Test");

                SqlCommand cmd = new SqlCommand();

                cmd.Connection = connection;

                cmd.CommandText = strQry;

                cmd.CommandType = CommandType.Text;

                SqlDataAdapter da = new SqlDataAdapter(cmd);

                System.Data.DataTable dt = new System.Data.DataTable();

                da.Fill(dt);

                if (dt.Rows.Count == 1)

                    sHandle = dt.Rows[0][0].ToString();

                dt.Dispose();

                da.Dispose();

            }

            catch (System.Exception)

            { }

            finally

            {

                if (connection != null)

                    connection.Close();

            }

            return sHandle;

        }

        #region Drawing Method

        private string DrawPipe(string style, List<string> coordinates)

        {

            GUIUtils.SetPipeStyle(style);

            string prevHandle = ReadDrawingLastLine();

            Autodesk.AutoCAD.ApplicationServices.Document acDoc = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument;

            Editor editor = acDoc.Editor;

            List<object> commandParam = new List<object>();

            //command name

            commandParam.Add("DRPIPE");

            //coordinate

            foreach (var item in coordinates)

                commandParam.Add(item);

            //enter

            commandParam.Add(null);

            //enter

            commandParam.Add(null);

            editor.Command(commandParam.ToArray());

            string newHandle = ReadDrawingLastLine();

            if (prevHandle == newHandle)

                return string.Empty;

            return newHandle;

        }

        private void DrawPipe(string style, List<string> coordinates, ObjectId objectId)

        {

            GUIUtils.SetPipeStyle(style);

            Autodesk.AutoCAD.ApplicationServices.Document acDoc = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument;

            Editor editor = acDoc.Editor;

            List<object> commandParam = new List<object>();

            //command name

            commandParam.Add("DRPIPE");

            //coordinate

            foreach (var item in coordinates)

                commandParam.Add(item);

            //enter

            commandParam.Add(null);

            //Input Object ID

            commandParam.Add(objectId);

            //enter

            commandParam.Add(null);

            editor.Command(commandParam.ToArray());

        }

        private void InsertSymbol(string insertSymbolName, double x, double y)

        {

            try

            {

                AVEVA.PID.Utilities.DrawingData drawingData = new AVEVA.PID.Utilities.DrawingData();

                drawingData.InsertSymbolName = insertSymbolName;

                Autodesk.AutoCAD.ApplicationServices.Document acDoc = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument;

                Editor editor = acDoc.Editor;

                List<object> commandParam = new List<object>();

                commandParam.Add("INSSYM");

                Point3d point = new Point3d(x, y, 0);

                commandParam.Add(point);

                commandParam.Add(null);

                editor.Command(commandParam.ToArray());

            }

            catch (System.Exception ex)

            {

            }

        }

        #endregion

        #region Test Source

        public void test()

        {

            //InitGUI();

            DrawPipe("Main Pipe", new List<string>() { "2,100", "100,100" });

            DrawPipe("Main Pipe", new List<string>() { "2,200", "100,200" });

            DrawPipe("Sub Pipe", new List<string>() { "50,100", "50,200" });

        }

        public static void TEST()

        {

            AutoModeling auto = new AutoModeling(null);

            auto.test();

        }

        #endregion

    }

}