public string AccionesAlert(Entidad.AlertaQueryInput Parametros)
{
string Resultado = "";
Resultado = ejecuta.AccionesAlert(Parametros);
return(Resultado);
}
public string AccionesAlert(Entidad.AlertaQueryInput Parametros)
{
var Resultado = DB2Helper.ExecuteDb2Scalar(CommandType.StoredProcedure, "SP_JNTAOPE_ACCIONES_ALERT", Parametros);
if (Resultado == null)
{
Resultado = "OK";
}
return(Resultado.ToString());
}
public JsonResult AlerConfig(string PRECODRY, string PRECOREF, string PRECOSTACK, string POSCODRY, string POSCOREF, string HORASLIMIT, string ACCION)
{
string data = string.Empty;
List <Entidad.AlertaQueryInput> LstAlert = new List <Entidad.AlertaQueryInput>();
Entidad.AlertaQueryInput Alert = new Entidad.AlertaQueryInput();
if (PRECODRY != "")
{
Alert = new Entidad.AlertaQueryInput();
Alert.ACCION = ACCION;
Alert.TIPALERT = "PRE";
Alert.DESCALERT = "DRY";
Alert.SESTRG = "A";
Alert.TEMPALERT = decimal.Parse(PRECODRY);
Alert.USRREG = (string)Session["Usuario"];
Alert.USERMOD = (string)Session["Usuario"];
Alert.FECREG = (DateTime.Now.ToString("yyyyMMdd"));
Alert.FECMOD = (DateTime.Now.ToString("yyyyMMdd"));
Alert.HRSREG = (DateTime.Now.ToString("HHmmss"));
Alert.HRSMOD = (DateTime.Now.ToString("HHmmss"));
Alert.OPEPORT = ConfigurationManager.AppSettings["OPEPORT"];
LstAlert.Add(Alert);
}
if (PRECOREF != "")
{
Alert = new Entidad.AlertaQueryInput();
Alert.ACCION = ACCION;
Alert.TIPALERT = "PRE";
Alert.DESCALERT = "REF";
Alert.SESTRG = "A";
Alert.TEMPALERT = decimal.Parse(PRECOREF);
Alert.USRREG = (string)Session["Usuario"];
Alert.USERMOD = (string)Session["Usuario"];
Alert.FECREG = (DateTime.Now.ToString("yyyyMMdd"));
Alert.FECMOD = (DateTime.Now.ToString("yyyyMMdd"));
Alert.HRSREG = (DateTime.Now.ToString("HHmmss"));
Alert.HRSMOD = (DateTime.Now.ToString("HHmmss"));
Alert.OPEPORT = ConfigurationManager.AppSettings["OPEPORT"];
LstAlert.Add(Alert);
}
if (PRECOSTACK != "")
{
Alert = new Entidad.AlertaQueryInput();
Alert.ACCION = ACCION;
Alert.TIPALERT = "PRE";
Alert.DESCALERT = "STK";
Alert.SESTRG = "A";
Alert.TEMPALERT = decimal.Parse(PRECOSTACK);
Alert.USRREG = (string)Session["Usuario"];
Alert.USERMOD = (string)Session["Usuario"];
Alert.FECREG = (DateTime.Now.ToString("yyyyMMdd"));
Alert.FECMOD = (DateTime.Now.ToString("yyyyMMdd"));
Alert.HRSREG = (DateTime.Now.ToString("HHmmss"));
Alert.HRSMOD = (DateTime.Now.ToString("HHmmss"));
Alert.OPEPORT = ConfigurationManager.AppSettings["OPEPORT"];
LstAlert.Add(Alert);
}
if (POSCODRY != "")
{
Alert = new Entidad.AlertaQueryInput();
Alert.ACCION = ACCION;
Alert.TIPALERT = "POS";
Alert.DESCALERT = "DRY";
Alert.SESTRG = "A";
Alert.TEMPALERT = decimal.Parse(POSCODRY);
Alert.USRREG = (string)Session["Usuario"];
Alert.USERMOD = (string)Session["Usuario"];
Alert.FECREG = (DateTime.Now.ToString("yyyyMMdd"));
Alert.FECMOD = (DateTime.Now.ToString("yyyyMMdd"));
Alert.HRSREG = (DateTime.Now.ToString("HHmmss"));
Alert.HRSMOD = (DateTime.Now.ToString("HHmmss"));
Alert.OPEPORT = ConfigurationManager.AppSettings["OPEPORT"];
LstAlert.Add(Alert);
}
if (POSCOREF != "")
{
Alert = new Entidad.AlertaQueryInput();
Alert.ACCION = ACCION;
Alert.TIPALERT = "POS";
Alert.DESCALERT = "REF";
Alert.SESTRG = "A";
Alert.TEMPALERT = decimal.Parse(POSCOREF);
Alert.USRREG = (string)Session["Usuario"];
Alert.USERMOD = (string)Session["Usuario"];
Alert.FECREG = (DateTime.Now.ToString("yyyyMMdd"));
Alert.FECMOD = (DateTime.Now.ToString("yyyyMMdd"));
Alert.HRSREG = (DateTime.Now.ToString("HHmmss"));
Alert.HRSMOD = (DateTime.Now.ToString("HHmmss"));
Alert.OPEPORT = ConfigurationManager.AppSettings["OPEPORT"];
LstAlert.Add(Alert);
}
if (HORASLIMIT != "")
{
Alert = new Entidad.AlertaQueryInput();
Alert.ACCION = ACCION;
Alert.TIPALERT = "PRE";
Alert.DESCALERT = "LIM";
Alert.SESTRG = "A";
Alert.TEMPALERT = decimal.Parse(HORASLIMIT);
Alert.USRREG = (string)Session["Usuario"];
Alert.USERMOD = (string)Session["Usuario"];
Alert.FECREG = (DateTime.Now.ToString("yyyyMMdd"));
Alert.FECMOD = (DateTime.Now.ToString("yyyyMMdd"));
Alert.HRSREG = (DateTime.Now.ToString("HHmmss"));
Alert.HRSMOD = (DateTime.Now.ToString("HHmmss"));
Alert.OPEPORT = ConfigurationManager.AppSettings["OPEPORT"];
LstAlert.Add(Alert);
}
foreach (var item in LstAlert)
{
data = lgCita.AccionesAlert(item);
if (data == "OK")
{
}
}
return(Json(data));
}
