Ejemplo n.º 1
0
        //AcDrawGround   //AcDrawKhazan
        public static DPackage AccessSelectByNodeCode(Guid NodeCode, OleDbTransaction _transaction, OleDbConnection _connection)
        {
            Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;

            OleDbConnection Connection = _connection;
            OleDbCommand    sqlCommand = new OleDbCommand("D_Package_SelectByNodeCode", Connection);

            sqlCommand.CommandType = CommandType.StoredProcedure;
            sqlCommand.Parameters.Add(new OleDbParameter("iNodeCode", NodeCode));
            sqlCommand.Transaction = _transaction;

            OleDbDataReader reader  = sqlCommand.ExecuteReader();
            DPackage        package = new DPackage();

            if (reader.Read())
            {
                package.Code        = new Guid(reader["Code"].ToString());
                package.Count       = Convert.ToInt32(reader["Count"]);
                package.NodeCode    = new Guid(reader["NodeCode"].ToString());
                package.ParentCode  = new Guid(reader["ParentCode"].ToString());
                package.ProductCode = Convert.ToInt32(reader["ProductCode"]);
                package.ProjectCode = Convert.ToInt32(reader["ProjectCode"]);
                package.Type        = Convert.ToInt32(reader["Type"]);
                package.IsExistance = Convert.ToInt32(reader["IsExistance"]);
                package.Number      = reader["Number"].ToString();
                package.LoadCode    = Convert.ToInt32(reader["LoadCode"].ToString());
            }
            else
            {
                package.code = Guid.Empty;
            }
            reader.Close();
            return(package);
        }
Ejemplo n.º 2
0
        public static DPackage AccessSelectByProductCodeType(int ProductCode, int Type)
        {
            Editor          ed         = Application.DocumentManager.MdiActiveDocument.Editor;
            OleDbConnection Connection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
            OleDbCommand    sqlCommand = new OleDbCommand("D_Package_SelectByProductCodeAndType", Connection);

            sqlCommand.CommandType = CommandType.StoredProcedure;

            sqlCommand.Parameters.Add(new OleDbParameter("iProductCode", ProductCode));
            sqlCommand.Parameters.Add(new OleDbParameter("iType", Type));

            Connection.Open();
            OleDbDataReader reader  = sqlCommand.ExecuteReader();
            DPackage        package = new DPackage();

            if (reader.Read())
            {
                package.Code        = new Guid(reader["Code"].ToString());
                package.Count       = Convert.ToInt32(reader["Count"]);
                package.NodeCode    = new Guid(reader["NodeCode"].ToString());
                package.ParentCode  = new Guid(reader["ParentCode"].ToString());
                package.ProductCode = Convert.ToInt32(reader["ProductCode"]);
                package.IsExistance = Convert.ToInt32(reader["IsExistance"]);
                package.Type        = Convert.ToInt32(reader["Type"]);
                package.Number      = reader["Number"].ToString();
                package.LoadCode    = Convert.ToInt32(reader["LoadCode"].ToString());
            }
            else
            {
                package.ProductCode = -1;
            }
            Connection.Close();
            reader.Close();
            return(package);
        }
Ejemplo n.º 3
0
        public static DPackage AccessSelectByNodeCode(DataTable dtPack, Guid NodeCode)
        {
            Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;

            DataRow[] dr      = dtPack.Select(string.Format("NodeCode='{0}'", NodeCode.ToString()));
            DPackage  package = new DPackage();

            if (dr.Length != 0)
            {
                package.Code        = new Guid(dr[0]["Code"].ToString());
                package.Count       = Convert.ToInt32(dr[0]["Count"]);
                package.NodeCode    = new Guid(dr[0]["NodeCode"].ToString());
                package.ParentCode  = new Guid(dr[0]["ParentCode"].ToString());
                package.ProductCode = Convert.ToInt32(dr[0]["ProductCode"]);
                package.ProjectCode = Convert.ToInt32(dr[0]["ProjectCode"]);
                package.Type        = Convert.ToInt32(dr[0]["Type"]);
                package.IsExistance = Convert.ToInt32(dr[0]["IsExistance"]);
                package.Number      = dr[0]["Number"].ToString();
                package.LoadCode    = Convert.ToInt32(dr[0]["LoadCode"].ToString());
            }
            else
            {
                package.code = Guid.Empty;
            }
            //ed.WriteMessage("ProjectCode={0}\n", package.ProjectCode);
            return(package);
        }
Ejemplo n.º 4
0
        //public bool Insert()
        //{
        //    SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.cnString);
        //    SqlTransaction Transaction;
        //    SqlCommand command = new SqlCommand("D_Post_Insert", connection);
        //    command.CommandType = CommandType.StoredProcedure;


        //    Code = Guid.NewGuid();
        //    command.Parameters.Add(new SqlParameter("iCode", Code));
        //    command.Parameters.Add(new SqlParameter("iDesignCode", DesignCode));
        //    command.Parameters.Add(new SqlParameter("iNumber", Number));
        //    command.Parameters.Add(new SqlParameter("iProductCode", ProductCode));

        //    try
        //    {
        //        connection.Open();
        //        Transaction = connection.BeginTransaction();
        //        command.Transaction = Transaction;

        //        try
        //        {
        //            //Code = new Guid(command.ExecuteScalar().ToString());
        //            command.ExecuteNonQuery();
        //            DPackage package = new DPackage();
        //            package.NodeCode = Code;
        //            package.Count = 1;
        //            package.Type = Convert.ToInt32(Atend.Control.Enum.ProductType.GroundPost);
        //            package.ProductCode = ProductCode;

        //            if (!package.AccessInsert(Transaction, connection))
        //            {
        //                //ed.writeMessage("ËÈÊ ÓÊ ÇãÇä ÐíÑ äãíÈÇÔÏ\n");
        //                return false;
        //            }

        //            Transaction.Commit();
        //            return true;
        //        }
        //        catch(System.Exception ex)
        //        {
        //            ed.WriteMessage(string.Format("Error Occured During Post Insertion 01 : {0} \n", ex.Message));
        //            Transaction.Rollback();
        //            connection.Close();
        //            return false;

        //        }
        //    }
        //    catch (System.Exception ex1)
        //    {
        //        ed.WriteMessage(string.Format("Error DPost.Insert : {0} \n", ex1.Message));
        //        connection.Close();
        //        return false;
        //    }


        //}


        //public bool Insert(SqlTransaction _transaction , SqlConnection _connection)
        //{
        //    SqlConnection connection = _connection;

        //    SqlCommand command = new SqlCommand("D_Post_Insert", connection);
        //    command.CommandType = CommandType.StoredProcedure;
        //    command.Transaction = _transaction;


        //    Code = Guid.NewGuid();
        //    command.Parameters.Add(new SqlParameter("iCode", Code));
        //    command.Parameters.Add(new SqlParameter("iDesignCode", DesignCode));
        //    command.Parameters.Add(new SqlParameter("iNumber", Number));
        //    command.Parameters.Add(new SqlParameter("iProductCode", ProductCode));

        //    try
        //    {
        //        try
        //        {
        //            //Code = new Guid(command.ExecuteScalar().ToString());
        //            command.ExecuteNonQuery();

        //            //DPackage package = new DPackage();
        //            //package.NodeCode = Code;
        //            //package.Count = 1;
        //            //package.Type = Convert.ToInt32(Atend.Control.Enum.ProductType.GroundPost);
        //            //package.ProductCode = ProductCode;

        //            //SqlTransaction Tr = _transaction;

        //            //if (!package.Insert(Tr, connection))
        //            //{
        //            //    ed.WriteMessage("ËÈÊ ÓÊ ÇãÇä ÐíÑ äãíÈÇÔÏ\n");
        //            //    return false;
        //            //}

        //            return true;
        //        }
        //        catch (System.Exception ex)
        //        {
        //            ed.WriteMessage(string.Format("Error Occured During Post Insertion 01 : {0} \n", ex.Message));
        //            //connection.Close();
        //            return false;

        //        }
        //    }
        //    catch (System.Exception ex1)
        //    {
        //        ed.WriteMessage(string.Format("Error DPost.Insert : {0} \n", ex1.Message));
        //        //connection.Close();
        //        return false;
        //    }


        //}


        /*public bool Update()
         * {
         *  SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.cnString);
         *  SqlCommand command = new SqlCommand("D_Post_Update", connection);
         *
         *  command.CommandType = CommandType.StoredProcedure;
         *  command.Parameters.Add(new SqlParameter("iCode", Code));
         *  command.Parameters.Add(new SqlParameter("iNumber", Number));
         *  try
         *  {
         *      connection.Open();
         *      command.ExecuteNonQuery();
         *      connection.Close();
         *  }
         *  catch (System.Exception ex1)
         *  {
         *      ed.WriteMessage(string.Format("Error DPost.Update : {0} \n", ex1.Message));
         *      connection.Close();
         *      return false;
         *  }
         *  return true;
         * }
         *
         * public static bool Delete(Guid Code)
         * {
         *  Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
         *  SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.cnString);
         *  SqlCommand command = new SqlCommand("D_Post_Delete", connection);
         *
         *  command.CommandType = CommandType.StoredProcedure;
         *  command.Parameters.Add(new SqlParameter("iCode", Code));
         *  try
         *  {
         *      connection.Open();
         *      command.ExecuteNonQuery();
         *      connection.Close();
         *  }
         *  catch (System.Exception ex1)
         *  {
         *      ed.WriteMessage(string.Format("Error DPost.Delete : {0} \n", ex1.Message));
         *      connection.Close();
         *      return false;
         *  }
         *  return true;
         * }
         *
         * public static DPost SelectByCode(Guid Code, int DesignCode)
         * {
         *  Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
         *
         *  SqlConnection Connection = new SqlConnection(Atend.Control.ConnectionString.cnString);
         *  SqlCommand sqlCommand = new SqlCommand("D_Post_SelectByCode", Connection);
         *  sqlCommand.CommandType = CommandType.StoredProcedure;
         *  sqlCommand.Parameters.Add(new SqlParameter("iCode", Code));
         *  sqlCommand.Parameters.Add(new SqlParameter("iDesignCode", DesignCode));
         *
         *  Connection.Open();
         *  SqlDataReader reader = sqlCommand.ExecuteReader();
         *  DPost post = new DPost();
         *  if (reader.Read())
         *  {
         *      post.Code = new Guid(reader["Code"].ToString());
         *      post.Number = reader["Number"].ToString();
         *      post.ProductCode = Convert.ToInt32(reader["ProductCode"]);
         *
         *  }
         *  Connection.Close();
         *  reader.Close();
         *  return post;
         * }
         */
        //~~~~~~~~~~~AccessPart~~~~~~~~~~~~~~~~~
        public bool AccessInsert()
        {
            OleDbConnection  connection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
            OleDbTransaction Transaction;
            OleDbCommand     command = new OleDbCommand("D_Post_Insert", connection);

            command.CommandType = CommandType.StoredProcedure;


            Code = Guid.NewGuid();
            command.Parameters.Add(new OleDbParameter("iCode", Code));
            command.Parameters.Add(new OleDbParameter("iNumber", Number));
            command.Parameters.Add(new OleDbParameter("iProductCode", ProductCode));

            try
            {
                connection.Open();
                Transaction         = connection.BeginTransaction();
                command.Transaction = Transaction;

                try
                {
                    //Code = new Guid(command.ExecuteScalar().ToString());
                    command.ExecuteNonQuery();
                    DPackage package = new DPackage();
                    package.NodeCode    = Code;
                    package.Count       = 1;
                    package.Type        = Convert.ToInt32(Atend.Control.Enum.ProductType.GroundPost);
                    package.ProductCode = ProductCode;

                    if (!package.AccessInsert(Transaction, connection))
                    {
                        //ed.writeMessage("ËÈÊ ÓÊ ÇãÇä ÐíÑ äãíÈÇÔÏ\n");
                        return(false);
                    }

                    Transaction.Commit();
                    return(true);
                }
                catch (System.Exception ex)
                {
                    ed.WriteMessage(string.Format("Error Occured During Post Insertion 01 : {0} \n", ex.Message));
                    Transaction.Rollback();
                    connection.Close();
                    return(false);
                }
            }
            catch (System.Exception ex1)
            {
                ed.WriteMessage(string.Format("Error DPost.Insert : {0} \n", ex1.Message));
                connection.Close();
                return(false);
            }
        }
Ejemplo n.º 5
0
        //AcDrawGroundPostForShield
        public static DPackage AccessSelectByCode(Guid NodeCode)
        {
            Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;

            OleDbConnection Connection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
            OleDbCommand    sqlCommand = new OleDbCommand("D_Package_SelectByCode", Connection);

            sqlCommand.CommandType = CommandType.StoredProcedure;
            //ed.WriteMessage("NodeCode={0}\n", NodeCode.ToString());
            sqlCommand.Parameters.Add(new OleDbParameter("iCode", NodeCode));

            Connection.Open();
            OleDbDataReader reader  = sqlCommand.ExecuteReader();
            DPackage        package = new DPackage();

            if (reader.Read())
            {
                //ed.WriteMessage("^^^^\n");
                package.Code        = new Guid(reader["Code"].ToString());
                package.Count       = Convert.ToInt32(reader["Count"]);
                package.NodeCode    = new Guid(reader["NodeCode"].ToString());
                package.ParentCode  = new Guid(reader["ParentCode"].ToString());
                package.ProductCode = Convert.ToInt32(reader["ProductCode"]);
                package.Type        = Convert.ToInt32(reader["Type"]);
                package.IsExistance = Convert.ToInt32(reader["IsExistance"]);
                package.Number      = reader["Number"].ToString();
                package.LoadCode    = Convert.ToInt32(reader["LoadCode"].ToString());
                package.ProjectCode = Convert.ToInt32(reader["ProjectCode"].ToString());
            }
            else
            {
                //ed.WriteMessage("***\n");
                package.code = Guid.Empty;
            }
            reader.Close();

            Connection.Close();
            return(package);
        }
Ejemplo n.º 6
0
        //****************************************Access To MEMORY Fo Calculation********************

        public static DPackage AccessSelectByCode(DataTable dtPackage, Guid Code)
        {
            DPackage package = new DPackage();

            DataRow[] dr = dtPackage.Select(string.Format(" Code='{0}'", Code.ToString()));
            if (dr.Length != 0)
            {
                package.Code        = new Guid(dr[0]["Code"].ToString());
                package.Count       = Convert.ToInt32(dr[0]["Count"]);
                package.NodeCode    = new Guid(dr[0]["NodeCode"].ToString());
                package.ParentCode  = new Guid(dr[0]["ParentCode"].ToString());
                package.ProductCode = Convert.ToInt32(dr[0]["ProductCode"]);
                package.Type        = Convert.ToInt32(dr[0]["Type"]);
                package.IsExistance = Convert.ToInt32(dr[0]["IsExistance"]);
                package.Number      = dr[0]["Number"].ToString();
                package.LoadCode    = Convert.ToInt32(dr[0]["LoadCode"].ToString());
                package.ProjectCode = Convert.ToInt32(dr[0]["ProjectCode"].ToString());
            }
            else
            {
                package.Code = Guid.Empty;
            }
            return(package);
        }