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); }
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 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 GetByCode(EGH01DB.IDBContext dbcontext, int code, out PetrochemicalCategories petrochemical_categories) { bool rc = false; petrochemical_categories = new PetrochemicalCategories(); using (SqlCommand cmd = new SqlCommand("EGH.GetPetrochemicalCategoriesByCode", dbcontext.connection)) { cmd.CommandType = CommandType.StoredProcedure; { SqlParameter parm = new SqlParameter("@КодКатегорииНефтепродукта", SqlDbType.Int); parm.Value = 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["НаименованиеКатегорииНефтепродукта"]; if (rc = (int)cmd.Parameters["@exitrc"].Value > 0) { petrochemical_categories = new PetrochemicalCategories(code, name); } } reader.Close(); } catch (Exception e) { rc = false; }; } return(rc); }
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); }
public PetrochemicalType(int code_type, String name, float boilingtemp, float density, float viscosity, float solubility, float tension, float dynamicviscosity, float diffusion, PetrochemicalCategories petrochemicalcategories) { this.code_type = code_type; this.name = name; this.boilingtemp = boilingtemp; this.density = density; this.viscosity = viscosity; this.solubility = solubility; this.tension = tension; this.dynamicviscosity = dynamicviscosity; this.diffusion = diffusion; this.petrochemicalcategories = petrochemicalcategories; }