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