public static DPoleSection AccessSelectByProductCodeProductType(Guid ProductCode, int ProductType) { OleDbConnection connection = new OleDbConnection(Atend.Control.ConnectionString.AccessCnString); OleDbCommand command = new OleDbCommand("D_PoleSection_SelectByProductCodeProductType", connection); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add(new OleDbParameter("iProductCode", ProductCode)); command.Parameters.Add(new OleDbParameter("iProductType", ProductType)); //command.Parameters.Add(new OleDbParameter("iDesignCode", DesignCode)); DPoleSection dPoleSection = new DPoleSection(); try { connection.Open(); OleDbDataReader reader = command.ExecuteReader(); if (reader.Read()) { dPoleSection.Code = Convert.ToInt32(reader["Code"]); //dPoleSection.DesignCode = Convert.ToInt32(reader["DesignCode"]); dPoleSection.ProductCode = new Guid(reader["ProductCode"].ToString()); dPoleSection.ProductType = Convert.ToInt32(reader["ProductType"]); dPoleSection.SectionCode = new Guid(reader["SectionCode"].ToString()); } else { dPoleSection.SectionCode = Guid.Empty; } reader.Close(); connection.Close(); } catch (System.Exception ex1) { Editor ed = Application.DocumentManager.MdiActiveDocument.Editor; ed.WriteMessage(string.Format(" ERROR D_PoleSection_SelectByDesignCodeProductCodeProductType {0}\n", ex1.Message)); connection.Close(); } return(dPoleSection); //SqlConnection connection = new SqlConnection(Atend.Control.ConnectionString.cnString); //SqlDataAdapter adapter = new SqlDataAdapter("D_PoleSection_SelectByDesignCodeProductCodeProductType", connection); //adapter.SelectCommand.CommandType = CommandType.StoredProcedure; //adapter.SelectCommand.Parameters.Add(new SqlParameter("iProductType", ProductType)); //adapter.SelectCommand.Parameters.Add(new SqlParameter("iDesignCode", DesignCode)); //adapter.SelectCommand.Parameters.Add(new SqlParameter("iProductCode", ProductType)); //DataSet dsPoleSection = new DataSet(); //adapter.Fill(dsPoleSection); //return dsPoleSection.Tables[0]; }
//*******************Access To Memory For Calc public static DPoleSection AccessSelectByProductCodeProductType(DataTable dtPoleSection, Guid ProductCode, int ProductType) { DataRow[] dr = dtPoleSection.Select(string.Format("ProductCode='{0}' AND ProductType={1}", ProductCode, ProductType)); DPoleSection dPoleSection = new DPoleSection(); if (dr.Length != 0) { dPoleSection.Code = Convert.ToInt32(dr[0]["Code"]); //dPoleSection.DesignCode = Convert.ToInt32(reader["DesignCode"]); dPoleSection.ProductCode = new Guid(dr[0]["ProductCode"].ToString()); dPoleSection.ProductType = Convert.ToInt32(dr[0]["ProductType"]); dPoleSection.SectionCode = new Guid(dr[0]["SectionCode"].ToString()); } else { dPoleSection.SectionCode = Guid.Empty; } return(dPoleSection); }