public static EOperation AccessSelectByCode(int Code, OleDbConnection _Connection)
{
OleDbConnection connection = _Connection;
OleDbDataAdapter adapter = new OleDbDataAdapter((string.Format("Select * From E_Operation Where Code={0}", Code)), connection);
adapter.SelectCommand.CommandType = CommandType.Text;
//adapter.SelectCommand.Parameters.Add(new SqlParameter("iCode", Code));
DataSet ds = new DataSet();
adapter.Fill(ds);
//return ds.Tables[0];
EOperation Operation = new EOperation();
if (ds.Tables[0].Rows.Count > 0)
{
Operation.Code = new Guid(ds.Tables[0].Rows[0]["Code"].ToString());
Operation.ProductCode = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductCode"].ToString());
Operation.ProductID = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductID"].ToString());
Operation.Type = Convert.ToInt32(ds.Tables[0].Rows[0]["Type"].ToString());
Operation.Count = Convert.ToDouble(ds.Tables[0].Rows[0]["Count"].ToString());
}
//SqlCommand command = new SqlCommand("E_Operation_SelectByCode", connection);
//command.CommandType = CommandType.StoredProcedure;
//command.Parameters.Add(new SqlParameter("iCode", Code));
//command.ExecuteNonQuery();
return(Operation);
}
//MEDHAT
public static EOperation SelectByCodeForServer(Guid Code, SqlConnection ServerConnection, SqlTransaction ServerTransaction)
{
Editor ed = Autodesk.AutoCAD.ApplicationServices.Application.DocumentManager.MdiActiveDocument.Editor;
SqlConnection connection = ServerConnection; //new SqlConnection(Atend.Control.ConnectionString.LocalcnString);
ed.WriteMessage(" >> EOperation.SelectByCodeForServer - Database Name : {0} \n", connection.Database);
SqlDataAdapter adapter = new SqlDataAdapter("E_Operation_SelectByCode", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Transaction = ServerTransaction;
adapter.SelectCommand.Parameters.Add(new SqlParameter("iCode", Code));
DataSet ds = new DataSet();
adapter.Fill(ds);
EOperation Operation = new EOperation();
ed.WriteMessage("Code={0}\n", Code);
ed.WriteMessage("***Operation.Count={0}\n", ds.Tables[0].Rows.Count);
if (ds.Tables[0].Rows.Count == 1)
{
Operation.Code = new Guid(ds.Tables[0].Rows[0]["Code"].ToString());
Operation.ProductID = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductID"].ToString());
Operation.Type = Convert.ToInt32(ds.Tables[0].Rows[0]["Type"].ToString());
//Operation.XCode = new Guid(ds.Tables[0].Rows[0]["XCode"].ToString());
Operation.Count = Convert.ToDouble(ds.Tables[0].Rows[0]["Count"].ToString());
}
ed.WriteMessage("****\n");
return(Operation);
}
public static EOperation SelectByCodeForLocal(Guid Code, SqlTransaction _transaction, SqlConnection _connection)
{
SqlConnection connection = _connection;
SqlDataAdapter adapter = new SqlDataAdapter("E_Operation_SelectByCode", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Transaction = _transaction;
adapter.SelectCommand.Parameters.Add(new SqlParameter("iCode", Code));
DataSet ds = new DataSet();
adapter.Fill(ds);
EOperation Operation = new EOperation();
if (ds.Tables[0].Rows.Count == 1)
{
Operation.Code = new Guid(ds.Tables[0].Rows[0]["Code"].ToString());
Operation.ProductID = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductID"].ToString());
Operation.Type = Convert.ToInt32(ds.Tables[0].Rows[0]["Type"].ToString());
Operation.XCode = new Guid(ds.Tables[0].Rows[0]["XCode"].ToString());
Operation.Count = Convert.ToDouble(ds.Tables[0].Rows[0]["Count"].ToString());
}
return(Operation);
}
public static EOperation SelectByCode(Guid Code)
{
SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.ServercnString);
SqlDataAdapter adapter = new SqlDataAdapter("E_Operation_SelectByCode", connection);
adapter.SelectCommand.CommandType = CommandType.StoredProcedure;
adapter.SelectCommand.Parameters.Add(new SqlParameter("iCode", Code));
DataSet ds = new DataSet();
adapter.Fill(ds);
//return ds.Tables[0];
EOperation Operation = new EOperation();
if (ds.Tables[0].Rows.Count > 0)
{
Operation.Code = new Guid(ds.Tables[0].Rows[0]["Code"].ToString());
Operation.ProductCode = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductCode"].ToString());
Operation.ProductID = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductID"].ToString());
Operation.Type = Convert.ToInt32(ds.Tables[0].Rows[0]["Type"].ToString());
Operation.Count = Convert.ToDouble(ds.Tables[0].Rows[0]["Count"].ToString());
}
//SqlCommand command = new SqlCommand("E_Operation_SelectByCode", connection);
//command.CommandType = CommandType.StoredProcedure;
//command.Parameters.Add(new SqlParameter("iCode", Code));
//command.ExecuteNonQuery();
return(Operation);
}
