//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); }
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); }
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); }
//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); } }
//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); }
//****************************************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); }