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