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