public ECOClassification(CEQContext.ECOEvalution ecoevalution) : base(ecoevalution) { GEAContext db = new GEAContext(); this.id = 0; this.date = DateTime.Now; { SoilPollutionCategories spc = this.soilpollutioncategories = null; SoilPollutionCategories.GetByVolume_Cadastre(db, this.excessgroundconcentration, this.groundblur.spreadpoint.cadastretype.type_code, out spc); this.soilpollutioncategories = spc; } { WaterPollutionCategories wpc = this.waterpollutioncategories = null; WaterPollutionCategories.GetByExcess_Cadastre(db, this.exesswaterconcentration, this.groundblur.spreadpoint.cadastretype.type_code, out wpc); this.waterpollutioncategories = wpc; } foreach (WaterPollution wp in this.waterpolutionlist) { WaterPollutionCategories x = null; WaterPollutionCategories.GetByExcess_Cadastre(db, wp.excessconcentration, wp.cadastretype.type_code, out x); wp.waterpollutioncategories = x; } }
public static ECOEvalution GetById(IDBContext db, int id) { ECOEvalution rc = null; using (SqlCommand cmd = new SqlCommand("EGH.GetECOEvalutionById", db.connection)) { cmd.CommandType = CommandType.StoredProcedure; { SqlParameter parm = new SqlParameter("@IdОтчета", SqlDbType.Int); parm.Value = id; cmd.Parameters.Add(parm); } try { SqlDataReader reader = cmd.ExecuteReader(); if (reader.Read()) { string xmlContent = (string)reader["ТекстОтчета"]; if (!xmlContent.Trim().Equals("")) { XmlDocument doc = new XmlDocument(); doc.LoadXml(xmlContent); rc = new CEQContext.ECOEvalution(doc.DocumentElement); } } reader.Close(); } catch (Exception e) { rc = null; }; } return(rc); }