public static ERamp AccessSelectByCodeForConvertor(int Code, OleDbTransaction _transaction, OleDbConnection _connection)
{
OleDbConnection connection = _connection;
OleDbCommand command = new OleDbCommand("E_Ramp_Select", connection);
command.CommandType = CommandType.StoredProcedure;
//connection.Open();
command.Parameters.Add(new OleDbParameter("iCode", Code));
OleDbDataReader reader = command.ExecuteReader();
ERamp _ERamp = new ERamp();
if (reader.Read())
{
_ERamp.Code = Convert.ToInt32(reader["Code"].ToString());
_ERamp.Name = Convert.ToString(reader["Name"].ToString());
_ERamp.ProductCode = Convert.ToInt32(reader["ProductCode"].ToString());
_ERamp.XCode = new Guid(reader["XCode"].ToString());
}
else
{
_ERamp.Code = -1;
}
reader.Close();
//connection.Close();
return(_ERamp);
}
//Ribbon->btnTransferBProduct
public static bool GetFromBProductLocal()
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
DataTable bp = Atend.Base.Base.BProduct.SelectByTypeX(Convert.ToInt32(Atend.Control.Enum.ProductType.Ramp));
ed.WriteMessage("bp.Count={0}\n", bp.Rows.Count);
foreach (DataRow dr in bp.Rows)
{
ERamp ramp = Atend.Base.Equipment.ERamp.SelectByProductCode(Convert.ToInt32(dr["ID"].ToString()));
if (ramp.Code != -1)
{
ed.WriteMessage("ramp.Name={0}\n", ramp.Name);
ramp.Name = dr["Name"].ToString();
ed.WriteMessage("ProductCode={0}\n", dr["ID"].ToString());
ramp.ProductCode = Convert.ToInt32(dr["ID"].ToString());
if (!ramp.UpdateX())
{
return(false);
}
}
else
{
ed.WriteMessage("InsertRamp\n");
ramp.ProductCode = Convert.ToInt32(dr["ID"].ToString());
ramp.Name = dr["Name"].ToString();
if (!ramp.InsertX())
{
return(false);
}
}
}
return(true);
}
public static ERamp SelectByCodeForLocal(int Code, SqlTransaction LocalTransaction, SqlConnection LocalConnection)
{
SqlConnection connection = LocalConnection;
SqlCommand command = new SqlCommand("E_Ramp_Select", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("iCode", Code));
ERamp ramp = new ERamp();
try
{
command.Transaction = LocalTransaction;
SqlDataReader reader = command.ExecuteReader();
if (reader.Read())
{
ramp.Code = Convert.ToInt16(reader["Code"].ToString());
ramp.Name = reader["Name"].ToString();
ramp.ProductCode = Convert.ToInt32(reader["ProductCode"].ToString());
ramp.XCode = new Guid(reader["XCode"].ToString());
ramp.IsDefault = Convert.ToBoolean(reader["IsDefault"].ToString());
}
else
{
ramp.Code = -1;
}
reader.Close();
}
catch (Exception ex)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
ed.WriteMessage("Error ERamp.In SelectByXCode.TransAction:{0}\n", ex.Message);
}
return(ramp);
}
//SentFromLocalToAccess
public static ERamp AccessSelectByXCode(Guid XCode)
{
OleDbConnection Connection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString);
OleDbCommand command = new OleDbCommand("E_Ramp_SelectByXCode", Connection);
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add(new OleDbParameter("iXCode", XCode));
Connection.Open();
OleDbDataReader reader = command.ExecuteReader();
ERamp _ERamp = new ERamp();
if (reader.Read())
{
_ERamp.Code = Convert.ToInt32(reader["Code"].ToString());
_ERamp.Name = reader["Name"].ToString();
_ERamp.ProductCode = Convert.ToInt32(reader["ProductCode"].ToString());
_ERamp.XCode = new Guid(reader["XCode"].ToString());
}
reader.Close();
Connection.Close();
return(_ERamp);
}
//Ribbon->btnTransferBProduct
public static ERamp SelectByProductCode(int ProductCode)
{
SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.LocalcnString);
SqlCommand command = new SqlCommand("E_Ramp_SelectByProductCode", connection);
command.CommandType = CommandType.StoredProcedure;
connection.Open();
command.Parameters.Add(new SqlParameter("iProductCode", ProductCode));
SqlDataReader reader = command.ExecuteReader();
ERamp ramp = new ERamp();
if (reader.Read())
{
ramp.Code = Convert.ToInt16(reader["Code"].ToString());
ramp.Name = reader["Name"].ToString();
ramp.ProductCode = Convert.ToInt32(reader["ProductCode"].ToString());
ramp.XCode = new Guid(reader["XCode"].ToString());
ramp.IsDefault = Convert.ToBoolean(reader["IsDefault"].ToString());
}
else
{
ramp.Code = -1;
}
reader.Close();
connection.Close();
Editor ed = Application.DocumentManager.MdiActiveDocument.Editor;
//ed.WriteMessage(string.Format(" Values: {0} , {1} , {2} \n", bus.ProductCode, bus.Size, bus, bus.Type));
return(ramp);
}
