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