static public bool Delete(EGH01DB.IDBContext dbcontext, SoilCleaningMethod method)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteSoilCleaningMethods", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипаКатегории", SqlDbType.Int);
parm.Value = method.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);
}
static public bool GetNextCode(EGH01DB.IDBContext dbcontext, out int code)
{
bool rc = false;
code = -1;
using (SqlCommand cmd = new SqlCommand("EGH.GetNextWaterPollutionCategoriesCode", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодКатегорииЗагрязненияГВ", SqlDbType.Int);
parm.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
code = (int)cmd.Parameters["@КодКатегорииЗагрязненияГВ"].Value;
rc = (int)cmd.Parameters["@exitrc"].Value > 0;
}
catch (Exception e)
{
rc = false;
};
return(rc);
}
}
static public bool Create(EGH01DB.IDBContext dbcontext, CadastreType land_type)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.CreateLandRegistryType", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодНазначенияЗемель", SqlDbType.Int);
int new_land_type_code = 0;
if (GetNextCode(dbcontext, out new_land_type_code))
{
land_type.type_code = new_land_type_code;
}
parm.Value = land_type.type_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@НаименованиеНазначенияЗемель", SqlDbType.NVarChar);
parm.Value = land_type.name;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ПДК", SqlDbType.Real);
parm.Value = land_type.pdk_coef;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ПДКводы", SqlDbType.Real);
parm.Value = land_type.water_pdk_coef;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@НормДокументЗемля", SqlDbType.NVarChar);
parm.Value = land_type.ground_doc_name;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@НормДокументВода", SqlDbType.NVarChar);
parm.Value = land_type.water_doc_name;
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 == land_type.type_code;
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool Delete(EGH01DB.IDBContext dbcontext, CadastreType land_type)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteLandRegistryType", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодНазначенияЗемель", SqlDbType.Int);
parm.Value = land_type.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);
}
// #16 Получение карты самоочищения почв
static public bool GetSelfCleaningZone(EGH01DB.IDBContext dbcontext, Coordinates coordinates, out string self_cleaning_zone) // Способность к самоочищению почв
{
bool rc = false;
self_cleaning_zone = "";
using (SqlCommand cmd = new SqlCommand("MAP.InGroundSelfCleaningMap", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@point", SqlDbType.VarChar);
parm.Value = coordinates.GetMapPoint();
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (rc = reader.Read())
{
int region_name_code = (int)reader["Obj_Id"];
self_cleaning_zone = (string)reader["self_clean_zone"];
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
public static bool Delete(EGH01DB.IDBContext dbcontext, SpreadingCoefficient spreading_coefficient)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteSpreadingCoefficient", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодКоэффициентаРазлива", SqlDbType.Int);
parm.Value = spreading_coefficient.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 Delete(EGH01DB.IDBContext dbcontext, EcoObject ecoobject)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteEcoObject", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@IdПриродоохранногоОбъекта", SqlDbType.Int);
parm.Value = ecoobject.id;
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 Delete(EGH01DB.IDBContext dbcontext, PetrochemicalCategories petrochemical_categories)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeletePetrochemicalCategories", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодКатегорииНефтепродукта", SqlDbType.Int);
parm.Value = petrochemical_categories.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);
}
// #5 Получение карты времени миграции нефтепродуктов
static public bool GetTimeMigration(EGH01DB.IDBContext dbcontext, Coordinates coordinates, out float time_migration) // время миграции до грунтовых вод
{
bool rc = false;
time_migration = 0.0f;
using (SqlCommand cmd = new SqlCommand("MAP.InTimeMigrationMap", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@point", SqlDbType.VarChar);
parm.Value = coordinates.GetMapPoint();
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (rc = reader.Read())
{
time_migration = (float)reader["migration_time"];
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool GetNextCode(EGH01DB.IDBContext dbcontext, out int code)
{
bool rc = false;
code = -1;
using (SqlCommand cmd = new SqlCommand("EGH.GetNextRiskObjectTypeCode", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипаТехногенногоОбъекта", SqlDbType.Int);
parm.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
code = (int)cmd.Parameters["@КодТипаТехногенногоОбъекта"].Value;
rc = (int)cmd.Parameters["@exitrc"].Value > 0;
}
catch (Exception e)
{
rc = false;
};
return(rc);
}
}
static public bool Delete(EGH01DB.IDBContext dbcontext, District district)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteDistrict", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодРайона", SqlDbType.Int);
parm.Value = district.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 GetNextId(EGH01DB.IDBContext dbcontext, out int next_id)
{
bool rc = false;
next_id = -1;
using (SqlCommand cmd = new SqlCommand("EGH.GetNextEcoObjectId", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@IdПриродоохранногоОбъекта", SqlDbType.Int);
parm.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
next_id = (int)cmd.Parameters["@IdПриродоохранногоОбъекта"].Value;
rc = (int)cmd.Parameters["@exitrc"].Value > 0;
}
catch (Exception e)
{
rc = false;
};
return(rc);
}
}
static public bool Delete(EGH01DB.IDBContext dbcontext, AnchorPoint anchor_point)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteAnchorPoint", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@IdОпорнойГеологическойТочки", SqlDbType.Int);
parm.Value = anchor_point.id;
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 Delete(EGH01DB.IDBContext dbcontext, RiskObjectType risk_object_type)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteRiskObjectType", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипаТехногенногоОбъекта", SqlDbType.Int);
parm.Value = risk_object_type.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);
}
static public bool Create(EGH01DB.IDBContext dbcontext, Region region)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.CreateRegion", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@Область", SqlDbType.VarChar);
parm.Value = region.name;
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 bool IsHome(EGH01DB.IDBContext dbcontext)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("MAP.InBelarus", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@point", SqlDbType.VarChar);
parm.Value = this.GetMapPoint();
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (rc = reader.Read())
{
int region_name_code = (int)reader["Obj_Id"];
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
// #14 Получение карты рельефа
static public bool GetHeight(EGH01DB.IDBContext dbcontext, Coordinates coordinates, out float height) // Высота над уровнем моря
{
bool rc = false;
height = 0.0f;
using (SqlCommand cmd = new SqlCommand("MAP.InTopographyMap", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@point", SqlDbType.VarChar);
parm.Value = coordinates.GetMapPoint();
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (rc = reader.Read())
{
height = (float)reader["height"];
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool Delete(EGH01DB.IDBContext dbcontext, RehabilitationMethod rehabilitation_method)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteRehabilitationMethod", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодКлассификатора", SqlDbType.Int);
parm.Value = rehabilitation_method.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 static bool Create(EGH01DB.IDBContext dbcontext, SpreadingCoefficient spreading_coefficient)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.CreateSpreadingCoefficient", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@ТипГрунта", SqlDbType.Int);
parm.Value = spreading_coefficient.ground_type.type_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КодТипаНефтепродукта", SqlDbType.Int);
parm.Value = spreading_coefficient.petrochemical_type.code_type;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@МинПролива", SqlDbType.Real);
parm.Value = spreading_coefficient.min_volume;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@МаксПролива", SqlDbType.Real);
parm.Value = spreading_coefficient.max_volume;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@МинУклона", SqlDbType.Real);
parm.Value = spreading_coefficient.min_angle;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@МаксУклона", SqlDbType.Real);
parm.Value = spreading_coefficient.max_angle;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэффициентРазлива", SqlDbType.Float);
parm.Value = spreading_coefficient.koef;
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 == 1);
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool Delete(EGH01DB.IDBContext dbcontext, WaterPollutionCategories water_pollution_categories)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.DeleteWaterPollutionCategories", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодКатегорииЗагрязненияГВ", SqlDbType.Int);
parm.Value = water_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 Update(EGH01DB.IDBContext dbcontext, AnchorPoint anchor_point)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.UpdateAnchorPoint", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@IdОпорнойГеологическойТочки", SqlDbType.Int);
parm.Value = anchor_point.id;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ШиротаГрад", SqlDbType.Real);
parm.Value = anchor_point.coordinates.latitude;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ДолготаГрад", SqlDbType.Real);
parm.Value = anchor_point.coordinates.lngitude;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ТипГрунта", SqlDbType.Int);
parm.Value = anchor_point.groundtype.type_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ГлубинаГрунтовыхВод", SqlDbType.Real);
parm.Value = anchor_point.waterdeep;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@ВысотаУровнемМоря", SqlDbType.Real);
parm.Value = anchor_point.height;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КодНазначенияЗемель", SqlDbType.Int);
parm.Value = anchor_point.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);
}
static public bool GetByCoordinates(EGH01DB.IDBContext dbcontext, float x, float y, ref AnchorPoint anchor_point, out int Map)
{
bool rc = true;
Map = 0;
anchor_point = new AnchorPoint(1);
return(rc);
}
static public bool GetByExcess_Cadastre(EGH01DB.IDBContext dbcontext, float excess, int cadatsre_type_code, out WaterPollutionCategories waterpollutioncategories)
{
bool rc = false;
waterpollutioncategories = WaterPollutionCategories.defaulttype;
using (SqlCommand cmd = new SqlCommand("EGH.GetWaterPollutionCategoriesByVolume_Cadastre", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@Объем", SqlDbType.Float);
parm.Value = excess;
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 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)
{
waterpollutioncategories = new WaterPollutionCategories(code, name, min, max, cadastre_type);
}
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool FindAtDistance(EGH01DB.IDBContext dbcontext, Coordinates coordinates, int buffer, out EcoObjectsList ecolist)
{
bool rc = false;
ecolist = new EcoObjectsList();
//List<EcoObject> ecolist = new List<EcoObject>();
using (SqlCommand cmd = new SqlCommand("MAP.EcoObjectInBuffer", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@point", SqlDbType.VarChar);
parm.Value = coordinates.GetMapPoint();;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@buffer", SqlDbType.Int);
parm.Value = buffer;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
SqlDataReader reader = cmd.ExecuteReader();
rc = true;
//EcoObject(int id, Point point, EcoObjectType ecoobjecttype, CadastreType cadastretype, string name, bool iswaterobject)
while (reader.Read())
{
int id = (int)reader["Obj_Id"];
string name = (string)reader["name"];
string type = (string)reader["type"];
float dist = (float)reader["distance"];
float x = (float)reader["yPoint"];
float y = (float)reader["xPoint"];
Coordinates nearbypoint = new Coordinates(x, y);
Point point = new Point(nearbypoint);
EcoObjectType eco_object_type = new EcoObjectType(type);
CadastreType cadastre_type = new CadastreType("Не определено на карте");
EcoObject ecoobject = new EcoObject(id, point, eco_object_type, cadastre_type, name, true); // уточнить насчет iswaterobject! blinova
ecolist.Add(ecoobject);
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
return(rc);
}
}
static public bool GetByCode(EGH01DB.IDBContext dbcontext, int type_code, ref PetrochemicalType petrochemical_type)
{
bool rc = false;
petrochemical_type = new PetrochemicalType(type_code);
using (SqlCommand cmd = new SqlCommand("EGH.GetPetrochemicalTypeByCode", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипаНефтепродукта", SqlDbType.Int);
parm.Value = 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())
{
string name = (string)reader["НаименованиеТипаНефтепродукта"];
float boilingtemp = (float)reader["ТемператураКипения"];
float density = (float)reader["Плотность"];
float viscosity = (float)reader["КинематическаяВязкость"];
float solubility = (float)reader["Растворимость"];
float tension = (float)reader["КоэфНатяжения"];
float dynamicviscosity = (float)reader["ДинамическаяВязкость"];
float diffusion = (float)reader["КоэфДиффузии"];
int petrochemicalcategories = (int)reader["КодКатегорииНефтепродукта"];
string petrochemicalcategoriesname = (string)reader["НаименованиеКатегорииНефтепродукта"];
PetrochemicalCategories petro_cat = new PetrochemicalCategories(petrochemicalcategories, petrochemicalcategoriesname);
if (rc = (int)cmd.Parameters["@exitrc"].Value > 0)
{
petrochemical_type = new PetrochemicalType(type_code, name,
(float)boilingtemp,
(float)density,
(float)viscosity,
(float)solubility,
(float)tension,
(float)dynamicviscosity,
(float)diffusion,
petro_cat);
}
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
public static bool Create(EGH01DB.IDBContext dbcontext, WaterProperties waterproperties)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.CreateWaterProperties", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодПоказателяВоды", SqlDbType.Int);
int new_water_property_code = 0;
if (GetNextCode(dbcontext, out new_water_property_code))
{
waterproperties.water_code = new_water_property_code;
}
parm.Value = waterproperties.water_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@Температура", SqlDbType.Float);
parm.Value = waterproperties.temperature;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@Вязкость", SqlDbType.Float);
parm.Value = waterproperties.viscocity;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@Плотность", SqlDbType.Float);
parm.Value = waterproperties.density;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэфПовНат", SqlDbType.Float);
parm.Value = waterproperties.tension;
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 static bool GetById(EGH01DB.IDBContext dbcontext, int id, out Report report, out string comment)
{
bool rc = false;
report = new Report();
comment = "";
using (SqlCommand cmd = new SqlCommand("EGH.GetReportbyId", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@IdОтчета", SqlDbType.Int);
parm.Value = id;
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())
{
DateTime date = (DateTime)reader["ДатаОтчета"];
string stage = (string)reader["Стадия"];
int parent = (int)reader["Родитель"];
Report parent_report = new Report(parent);
comment = (string)reader["Комментарий"];
string xmlContent = (string)reader["ТекстОтчета"];
XmlDocument doc = new XmlDocument();
doc.LoadXml(xmlContent);
XmlNode xml_content = doc.DocumentElement;
string xsl_htm_lstyle = (string)reader["СтильОтчета"];
XmlDocument doc_xslt = new XmlDocument();
doc.LoadXml(xsl_htm_lstyle);
XmlNode xsl_content = doc.DocumentElement;
if (rc = (int)cmd.Parameters["@exitrc"].Value > 0)
{
report = new Report(id, stage, date, xml_content, xsl_content, comment);
}
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool Create(EGH01DB.IDBContext dbcontext, WaterPollutionCategories water_pollution_categories)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.CreateWaterPollutionCategories", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
int new_type_code = 0;
if (GetNextCode(dbcontext, out new_type_code))
{
water_pollution_categories.code = new_type_code;
}
SqlParameter parm = new SqlParameter("@КодКатегорииЗагрязненияГВ", SqlDbType.Int);
parm.Value = water_pollution_categories.code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@НаименованиеКатегорииЗагрязненияГВ", SqlDbType.NVarChar);
parm.Value = water_pollution_categories.name;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@МинДиапазон", SqlDbType.Real);
parm.Value = water_pollution_categories.min;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@МаксДиапазон", SqlDbType.Real);
parm.Value = water_pollution_categories.max;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КодНазначенияЗемель", SqlDbType.Int);
parm.Value = water_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);
}
// #13 Получение карты растительности
static public bool GetVegetation(EGH01DB.IDBContext dbcontext, Coordinates coordinates, out string assoc_gr_1,
out string shtrih_cod, out string code_legen, out string class_form,
out string associatio, out string code_rgb, out string type_rasty, out string krap_code, out string dop_code)
{
bool rc = false;
assoc_gr_1 = "";
shtrih_cod = "";
code_legen = "";
class_form = "";
associatio = "";
code_rgb = "";
type_rasty = "";
krap_code = "";
dop_code = "";
using (SqlCommand cmd = new SqlCommand("MAP.InVegetationMap", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@point", SqlDbType.VarChar);
parm.Value = coordinates.GetMapPoint();
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
SqlDataReader reader = cmd.ExecuteReader();
if (rc = reader.Read())
{
assoc_gr_1 = (string)reader["assoc_gr_1"];
shtrih_cod = (string)reader["shtrih_cod"];
code_legen = (string)reader["code_legen"];
class_form = (string)reader["class_form"];
associatio = (string)reader["associatio"];
code_rgb = (string)reader["code_rgb"];
type_rasty = (string)reader["type_rasty"];
krap_code = (string)reader["krap_code"];
dop_code = (string)reader["dop_code"];
}
reader.Close();
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
public static float GetByData(EGH01DB.IDBContext dbcontext, GroundType type, PetrochemicalType petrochemical_type, float volume, float angle)
{
float rc = -1.0f;
float koefficient = -1.0f;
using (SqlCommand cmd = new SqlCommand("EGH.GetSpreadingCoefficientByData", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@ТипГрунта", SqlDbType.Int);
parm.Value = type.type_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КодТипаНефтепродукта", SqlDbType.Int);
parm.Value = petrochemical_type.code_type;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@Объем", SqlDbType.Real);
parm.Value = volume;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@УголНаклона", SqlDbType.Real);
parm.Value = angle;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@КоэффициентРазлива", SqlDbType.Float);
parm.Direction = ParameterDirection.Output;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@exitrc", SqlDbType.Int);
parm.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(parm);
}
try
{
cmd.ExecuteNonQuery();
double k = (double)cmd.Parameters["@КоэффициентРазлива"].Value;
koefficient = (float)k;
}
catch (Exception e)
{
rc = -1;
};
}
return(koefficient);
}
