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