//Hatami public static DConsol AccessSelectByCode(Guid _Code) { OleDbConnection connection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString); OleDbCommand command = new OleDbCommand("D_Consol_SelectByCode", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new OleDbParameter("iCode", _Code)); //command.Parameters.Add(new OleDbParameter("iDesignCode", DesignCode)); DConsol dconsol = new DConsol(); try { connection.Open(); OleDbDataReader reader = command.ExecuteReader(); if (reader.Read()) { dconsol.Code = new Guid(reader["Code"].ToString()); dconsol.ParentCode = new Guid(reader["ParentCode"].ToString()); dconsol.ProductCode = Convert.ToInt32(reader["ProductCode"].ToString()); dconsol.LoadCode = Convert.ToInt32(reader["LoadCode"]); } reader.Close(); connection.Close(); } catch (System.Exception ex1) { Editor ed = Application.DocumentManager.MdiActiveDocument.Editor; ed.WriteMessage(string.Format(" ERROR DConsol.SelectByCode {0}\n", ex1.Message)); connection.Close(); } return(dconsol); }
//****************************Access To Memory For Calc //Hatami public static DConsol AccessSelectByCode(DataTable dtDConsol, Guid _Code) { DataRow[] dr = dtDConsol.Select(string.Format("Code='{0}'", _Code.ToString())); Editor ed = Application.DocumentManager.MdiActiveDocument.Editor; DConsol dconsol = new DConsol(); if (dr.Length != 0) { dconsol.Code = new Guid(dr[0]["Code"].ToString()); dconsol.ParentCode = new Guid(dr[0]["ParentCode"].ToString()); dconsol.ProductCode = Convert.ToInt32(dr[0]["ProductCode"].ToString()); dconsol.LoadCode = Convert.ToInt32(dr[0]["LoadCode"]); } return(dconsol); }