static public bool GetByCode(EGH01DB.IDBContext dbcontext, int type_code, out IncidentType type)
{
bool rc = false;
type = new IncidentType();
using (SqlCommand cmd = new SqlCommand("EGH.GetIncidentTypeByCode", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипа", SqlDbType.Int);
parm.Value = type_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@Наименование", SqlDbType.NVarChar);
parm.Size = 50;
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();
string name = (string)cmd.Parameters["@Наименование"].Value;
if (rc = (int)cmd.Parameters["@exitrc"].Value > 0)
{
type = new IncidentType(type_code, name);
}
}
catch (Exception e)
{
rc = false;
};
}
return(rc);
}
static public bool Update(EGH01DB.IDBContext dbcontext, IncidentType incident_type)
{
bool rc = false;
using (SqlCommand cmd = new SqlCommand("EGH.UpdateIncidentType", dbcontext.connection))
{
cmd.CommandType = CommandType.StoredProcedure;
{
SqlParameter parm = new SqlParameter("@КодТипа", SqlDbType.Int);
parm.Value = incident_type.type_code;
cmd.Parameters.Add(parm);
}
{
SqlParameter parm = new SqlParameter("@НовоеНаименование", SqlDbType.VarChar); // smw60
parm.Value = incident_type.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 ActionResult Forecast( )
{
RGEContext context = null;
ActionResult view = View("Index");
ViewBag.EGHLayout = "RGE.Forecast";
try
{
context = new RGEContext(this);
view = View(context);
if (!ForecastViewConext.Handler(context, this.HttpContext.Request.Params))
{
if (ChoiceRiskObjectContext.Handler(context, this.HttpContext.Request.Params))
{
}
}
else
{
string menuitem = this.HttpContext.Request.Params["menuitem"];
if (menuitem.Equals("Forecast.Forecast"))
{
ForecastViewConext viewcontext = context.GetViewContext("Forecast") as ForecastViewConext;
if (viewcontext != null)
{
RiskObject riskobject = new RiskObject();
if (RiskObject.GetById(context, (int)viewcontext.RiskObjectId, ref riskobject))
{
PetrochemicalType petrochemicaltype = new PetrochemicalType();
if (PetrochemicalType.GetByCode(context, (int)viewcontext.Petrochemical_type_code, ref petrochemicaltype))
{
SpreadPoint spreadpoint = new SpreadPoint(riskobject, petrochemicaltype, (float)viewcontext.Volume);
EGH01DB.Types.IncidentType incidenttype = new EGH01DB.Types.IncidentType();
if (EGH01DB.Types.IncidentType.GetByCode(context, (int)viewcontext.Incident_type_code, out incidenttype))
{
Incident incident = new Incident(
(DateTime)viewcontext.Incident_date,
(DateTime)viewcontext.Incident_date_message,
incidenttype,
spreadpoint
);
viewcontext.ecoforecast = new RGEContext.ECOForecast(incident);
viewcontext.Regim = ForecastViewConext.REGIM.REPORT;
}
else
{
viewcontext.Regim = ForecastViewConext.REGIM.RUNERROR;
}
}
else
{
viewcontext.Regim = ForecastViewConext.REGIM.RUNERROR;
}
}
else
{
viewcontext.Regim = ForecastViewConext.REGIM.RUNERROR;
}
}
else
{
viewcontext.Regim = ForecastViewConext.REGIM.RUNERROR;
}
}
else if (menuitem.Equals("Forecast.Cancel"))
{
view = View("Index", context); //view = Redirect("Index");
}
else if (menuitem.Equals("Forecast.Save"))
{
ForecastViewConext viewcontext = context.GetViewContext("Forecast") as ForecastViewConext;
EGH01DB.RGEContext.ECOForecast forecast = viewcontext.ecoforecast;
//XmlNode node = forecast.toXmlNode("Отладка");
//XmlDocument doc = new XmlDocument();
//doc.AppendChild(doc.ImportNode(node, true));
//doc.Save(@"C:\Report.xml");
if (RGEContext.ECOForecast.Create(context, forecast, "отладка"))
{
}
}
}
}
catch (RGEContext.Exception e)
{
ViewBag.msg = e.message;
}
catch (Exception e)
{
ViewBag.msg = e.Message;
}
return(view);
}
