static public bool Delete(EGH01DB.IDBContext dbcontext, SoilPollutionCategories soil_pollution_categories)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteSoilPollutionCategories", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодКатегорииЗагрязненияГрунта", SqlDbType.Int);
parm.Value = soil_pollution_categories.code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
rc = ((int)cmd.Parameters["@exitrc"].Value > 0);
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool GetByVolume_Cadastre(EGH01DB.IDBContext dbcontext, float volume, int cadatsre_type_code, out SoilPollutionCategories soil_pollution_categories)
{
bool rc = false;
soil_pollution_categories = SoilPollutionCategories.defaulttype;
using (SqlCommand cmd = new SqlCommand("EGH.GetSoilPollutionCategoriesByVolume_Cadastre", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@Объем", SqlDbType.Float);
parm.Value = volume;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КодНазначенияЗемель", SqlDbType.Int);
parm.Value = cadatsre_type_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
int re_code = (int)reader["КодКатегорииЗагрязненияГрунта"];
string name = (string)reader["НаименованиеКатегорииЗагрязненияГрунта"];
float min = (float)reader["МинДиапазон"];
float max = (float)reader["МаксДиапазон"];
int cadastre_type_code = (int)reader["КодНазначенияЗемель"];
string cadastre_type_name = (string)reader["НаименованиеНазначенияЗемель"];
float pdk_coef = (float)reader["ПДК"];
float water_pdk_coef = (float)reader["ПДКводы"];
string ground_doc_name = (string)reader["НормДокументЗемля"];
string water_doc_name = (string)reader["НормДокументВода"];
CadastreType cadastre_type = new CadastreType(cadastre_type_code, cadastre_type_name,
pdk_coef, water_pdk_coef,
ground_doc_name, water_doc_name);
if (rc = (int)cmd.Parameters["@exitrc"].Value > 0)
{
soil_pollution_categories = new SoilPollutionCategories(re_code, name, min, max, cadastre_type);
}
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool Create(EGH01DB.IDBContext dbcontext, SoilPollutionCategories soil_pollution_categories)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.CreateSoilPollutionCategories", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
int new_type_code = 0;
if (GetNextCode(dbcontext, out new_type_code))
{
soil_pollution_categories.code = new_type_code;
}
SqlParameter parm = new SqlParameter("@КодКатегорииЗагрязненияГрунта", SqlDbType.Int);
parm.Value = soil_pollution_categories.code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@НаименованиеКатегорииЗагрязненияГрунта", SqlDbType.NVarChar);
parm.Value = soil_pollution_categories.name;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@МинДиапазон", SqlDbType.Real);
parm.Value = soil_pollution_categories.min;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@МаксДиапазон", SqlDbType.Real);
parm.Value = soil_pollution_categories.max;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КодНазначенияЗемель", SqlDbType.Int);
parm.Value = soil_pollution_categories.cadastretype.type_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
rc = (int)cmd.Parameters["@exitrc"].Value > 0;
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
public RehabilitationMethod(int type_code, RiskObjectType riskobjecttype,
CadastreType cadastretype, PetrochemicalCategories petrochemicalcategory,
EmergencyClass emergencyclass, PenetrationDepth penetrationdepth,
SoilPollutionCategories soilpollutioncategories, bool waterachieved,
WaterPollutionCategories waterpollutioncategories, WaterProtectionArea waterprotectionarea,
SoilCleaningMethod soilcleaningmethod, WaterCleaningMethod watercleaningmethod)
{
this.type_code = type_code;
this.riskobjecttype = riskobjecttype;
this.cadastretype = cadastretype;
this.petrochemicalcategory = petrochemicalcategory;
this.emergencyclass = emergencyclass;
this.penetrationdepth = penetrationdepth;
this.soilpollutioncategories = soilpollutioncategories;
this.waterachieved = waterachieved;
this.waterpollutioncategories = waterpollutioncategories;
this.waterprotectionarea = waterprotectionarea;
this.soilcleaningmethod = soilcleaningmethod;
this.watercleaningmethod = watercleaningmethod;
}
static public bool GetByParm(EGH01DB.IDBContext dbcontext,
int riskobjecttypecode,
int cadastretypecode,
int petrochemicalcategorytypecode,
int emergencyclasstypecode,
int penetrationdepthtypecode,
int soilpollutioncategoriestypecode,
bool waterachieved,
int waterpollutioncategoriestypecode,
int waterprotectionareatypecode,
out RehabilitationMethod rehabilitation_method)
{
bool rc = false;
rehabilitation_method = new RehabilitationMethod();
using (SqlCommand cmd = new SqlCommand("EGH.GetListRehabilitationMethodOnParam", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@ТипТехногенногоОбъекта", SqlDbType.Int);
parm.Value = riskobjecttypecode;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@НазначениеЗемель", SqlDbType.Int);
parm.Value = cadastretypecode;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КатегорияНефтепродукта", SqlDbType.Int);
parm.Value = petrochemicalcategorytypecode;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КлассификацияАварий", SqlDbType.Int);
parm.Value = emergencyclasstypecode;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КатегорияПроникновенияНефтепродукта", SqlDbType.Int);
parm.Value = penetrationdepthtypecode;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КатегорияЗагрязненияГрунта", SqlDbType.Int);
parm.Value = soilpollutioncategoriestypecode;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ДостижениеГоризонтаГрунтовыхВод", SqlDbType.Bit);
parm.Value = waterachieved;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КатегорияЗагрязненияГрунтовыхВод", SqlDbType.Int);
parm.Value = waterpollutioncategoriestypecode;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КатегорияВодоохраннойТерритории", SqlDbType.Int);
parm.Value = waterprotectionareatypecode;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
int code = (int)reader["КодКлассификатора"];
int risk_object_type_code = (int)reader["ТипТехногенногоОбъекта"];
string risk_object_type_name = (string)reader["НаименованиеТипаТехногенногоОбъекта"];
RiskObjectType risk_object_type = new RiskObjectType(risk_object_type_code, risk_object_type_name);
int cadastre_type_code = (int)reader["НазначениеЗемель"];
string cadastre_type_name = (string)reader["НаименованиеНазначенияЗемель"];
float cadastre_type_pdk_coef = (float)reader["ПДК"];
float cadastre_type_water_pdk_coef = (float)reader["ПДКводы"];
string cadastre_type_ground_doc_name = (string)reader["НормДокументЗемля"];
string cadastre_type_water_doc_name = (string)reader["НормДокументВода"];
CadastreType cadastre_type = new CadastreType(cadastre_type_code, cadastre_type_name, cadastre_type_pdk_coef,
cadastre_type_water_pdk_coef, cadastre_type_ground_doc_name, cadastre_type_water_doc_name);
int petrochemical_category_type_code = (int)reader["КатегорияНефтепродукта"];
string petrochemical_category_name = (string)reader["KN_НаименованиеКатегорииНефтепродукта"];
PetrochemicalCategories petrochemical_category = new PetrochemicalCategories(petrochemical_category_type_code, petrochemical_category_name);
int emergency_class_type_code = (int)reader["КлассификацияАварий"];
string emergency_class_name = (string)reader["KA_НаименованиеТипаАварии"];
float emergency_class_min = (float)reader["KA_МинМасса"];
float emergency_class_max = (float)reader["KA_МаксМасса"];
EmergencyClass emergency_class = new EmergencyClass(emergency_class_type_code, emergency_class_name, emergency_class_min, emergency_class_max);
int penetration_depth_type_code = (int)reader["КатегорияПроникновенияНефтепродукта"];
string penetration_depth_name = (string)reader["PN_НаименованиеТипаКатегории"];
float penetration_depth_min = (float)reader["PN_МинДиапазон"];
float penetration_depth_max = (float)reader["PN_МаксДиапазон"];
PenetrationDepth penetration_depth = new PenetrationDepth(penetration_depth_type_code, penetration_depth_name, penetration_depth_min, penetration_depth_max);
int soil_pollution_categories_type_code = (int)reader["КатегорияЗагрязненияГрунта"];
string soil_pollution_categories_name = (string)reader["GP_НаименованиеКатегорииЗагрязненияГрунта"];
float soil_pollution_categories_min = (float)reader["GP_МинДиапазон"];
float soil_pollution_categories_max = (float)reader["GP_МаксДиапазон"];
int soil_pollution_categories_cadastre_type_code = (int)reader["GP_КодНазначенияЗемель"];
CadastreType soil_pollution_categories_cadastre_type = new CadastreType(soil_pollution_categories_cadastre_type_code);
SoilPollutionCategories soilpollution_categories = new SoilPollutionCategories(soil_pollution_categories_type_code,
soil_pollution_categories_name,
soil_pollution_categories_min,
soil_pollution_categories_max,
soil_pollution_categories_cadastre_type);
bool water_achieved = (bool)reader["ДостижениеГоризонтаГрунтовыхВод"];
int water_pollution_categories_type_code = (int)reader["КатегорияЗагрязненияГрунтовыхВод"];
string water_pollution_categories_name = (string)reader["WG_НаименованиеКатегорииЗагрязненияГВ"];
float water_pollution_categories_min = (float)reader["WG_МинДиапазон"];
float water_pollution_categories_max = (float)reader["WG_МаксДиапазон"];
int water_pollution_categories_cadastre_type_code = (int)reader["WG_КодНазначенияЗемель"];
CadastreType water_pollution_categories_cadastre_type = new CadastreType(water_pollution_categories_cadastre_type_code);
WaterPollutionCategories water_pollution_categories = new WaterPollutionCategories(water_pollution_categories_type_code,
water_pollution_categories_name,
water_pollution_categories_min,
water_pollution_categories_max,
water_pollution_categories_cadastre_type);
int water_protection_area_type_code = (int)reader["КатегорияВодоохраннойТерритории"];
string water_protection_area_name = (string)reader["WT_НаименованиеКатегории"];
WaterProtectionArea water_protection_area = new WaterProtectionArea(water_protection_area_type_code, water_protection_area_name);
int soil_cleaning_method_type_code = (int)reader["КатегорияМЛЗагрязненияПГ"];
string soil_cleaning_method_name = (string)reader["PG_ОписаниеМетода"];
SoilCleaningMethod soil_cleaning_method = new SoilCleaningMethod(soil_cleaning_method_type_code, soil_cleaning_method_name);
int water_cleaning_method_type_code = (int)reader["КатегорияМЛЗагрязненияГВ"];
string water_cleaning_method_name = (string)reader["PW_ОписаниеМетода"];
WaterCleaningMethod water_cleaning_method = new WaterCleaningMethod(water_cleaning_method_type_code, water_cleaning_method_name);
if (rc = (int)cmd.Parameters["@exitrc"].Value > 0)
{
rehabilitation_method = new RehabilitationMethod(code,
risk_object_type,
cadastre_type,
petrochemical_category,
emergency_class,
penetration_depth,
soilpollution_categories,
water_achieved,
water_pollution_categories,
water_protection_area,
soil_cleaning_method,
water_cleaning_method);
}
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(true);
}
