public List <beControlSenalSupCaidasFalloTestControlCierre> ListarControlCierre(SqlConnection con, string DstbCode, string AbndCode, string Dpto, int TipoAbnd) { List <beControlSenalSupCaidasFalloTestControlCierre> lbeControlCierre = null; SqlCommand cmd = new SqlCommand("sp_web_Control_de_Cierres", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter param1 = cmd.Parameters.Add("@cDstbCode", SqlDbType.VarChar, 10); param1.Direction = ParameterDirection.Input; param1.Value = DstbCode.ToUpper(); SqlParameter param2 = cmd.Parameters.Add("@cAbndCode", SqlDbType.VarChar, 10); param2.Direction = ParameterDirection.Input; param2.Value = AbndCode; SqlParameter param3 = cmd.Parameters.Add("@Ubigeo", SqlDbType.VarChar, 3); param3.Direction = ParameterDirection.Input; param3.Value = Dpto; SqlParameter param4 = cmd.Parameters.Add("@TipoAbnd", SqlDbType.Int); param4.Direction = ParameterDirection.Input; param4.Value = TipoAbnd; SqlDataReader drd = cmd.ExecuteReader(); if (drd != null) { int dAlmDate = drd.GetOrdinal("Fecha_Ocurrencia"); int dAlmHour = drd.GetOrdinal("dteDateTimeOccurred"); int csid = drd.GetOrdinal("AbonadoCode"); int Oficina = drd.GetOrdinal("Oficina"); int IDSenal = drd.GetOrdinal("IDSenal"); int AdminOEmergencia = drd.GetOrdinal("AdminOEmergencia"); int ConComentario = drd.GetOrdinal("nInciNumb"); int Condicion = drd.GetOrdinal("Condicion"); int ZonaPhys_ZonaDescri = drd.GetOrdinal("ZonaPhys_ZonaDescri"); lbeControlCierre = new List <beControlSenalSupCaidasFalloTestControlCierre>(); beControlSenalSupCaidasFalloTestControlCierre obeControlCierre; while (drd.Read()) { obeControlCierre = new beControlSenalSupCaidasFalloTestControlCierre(); obeControlCierre.Fecha = drd.GetString(dAlmDate); obeControlCierre.Hora = drd.GetString(dAlmHour); obeControlCierre.AbndCode = drd.GetString(csid); obeControlCierre.Oficina = drd.GetString(Oficina); obeControlCierre.IDSenal = drd.GetString(IDSenal); obeControlCierre.Zonaphys_Zonadescri = drd.GetString(ZonaPhys_ZonaDescri); obeControlCierre.ImagenRuta = NombreDeIcono(drd.GetString(AdminOEmergencia), drd.GetString(ConComentario)); obeControlCierre.Condicion = drd.GetString(Condicion); lbeControlCierre.Add(obeControlCierre); } drd.Close(); } return(lbeControlCierre); }
public List <beControlSenalSupCaidasFalloTestControlCierre> ListarSupervisionCaidas(SqlConnection con, string DstbCode, string AbndCode, string AlrCode, string Estado, string Time, string Dpto, int TipoAbnd, string Localid, int TipoParticionid) { List <beControlSenalSupCaidasFalloTestControlCierre> lbeSupervisionCaidas = null; SqlCommand cmd = new SqlCommand("ma_SpCR", con); cmd.CommandType = CommandType.StoredProcedure; SqlParameter param1 = cmd.Parameters.Add("@pDstbCode", SqlDbType.VarChar, 10); param1.Direction = ParameterDirection.Input; param1.Value = DstbCode.ToUpper(); SqlParameter param2 = cmd.Parameters.Add("@pAbndCode", SqlDbType.VarChar, 10); param2.Direction = ParameterDirection.Input; param2.Value = AbndCode; SqlParameter param3 = cmd.Parameters.Add("@pAlr1Code", SqlDbType.VarChar, 3); param3.Direction = ParameterDirection.Input; param3.Value = AlrCode.Split('|')[0]; SqlParameter param4 = cmd.Parameters.Add("@pAlr2Code", SqlDbType.VarChar, 3); param4.Direction = ParameterDirection.Input; param4.Value = AlrCode.Split('|')[1]; SqlParameter param5 = cmd.Parameters.Add("@pCondCode", SqlDbType.VarChar, 1); param5.Direction = ParameterDirection.Input; param5.Value = Estado; SqlParameter param6 = cmd.Parameters.Add("@pExcsNumb", SqlDbType.VarChar, 10); param6.Direction = ParameterDirection.Input; param6.Value = Time; SqlParameter param7 = cmd.Parameters.Add("@Ubigeo", SqlDbType.VarChar, 3); param7.Direction = ParameterDirection.Input; param7.Value = Dpto; SqlParameter param8 = cmd.Parameters.Add("@TipoAbnd", SqlDbType.Int); param8.Direction = ParameterDirection.Input; param8.Value = TipoAbnd; SqlParameter param9 = cmd.Parameters.Add("@Localid", SqlDbType.VarChar, 15); param9.Direction = ParameterDirection.Input; param9.Value = Localid; SqlParameter param10 = cmd.Parameters.Add("@TipoParticionid", SqlDbType.Int); param10.Direction = ParameterDirection.Input; param10.Value = TipoParticionid; SqlDataReader drd = cmd.ExecuteReader(); if (drd != null) { int dAlmDate = drd.GetOrdinal("Fecha_Ocurrencia"); int dAlmHour = drd.GetOrdinal("DateTimeOccurred"); int csid = drd.GetOrdinal("CSID"); int Oficina = drd.GetOrdinal("Oficina"); int IDSenal = drd.GetOrdinal("SignalIdentifier"); int AdminOEmergencia = drd.GetOrdinal("AdminOEmergencia"); int ConComentario = drd.GetOrdinal("nInciNumb"); int PhysicalZone = drd.GetOrdinal("PhysicalZone"); int ZonaDescri = drd.GetOrdinal("ZonaDescri"); int Condicion = drd.GetOrdinal("Condicion"); lbeSupervisionCaidas = new List <beControlSenalSupCaidasFalloTestControlCierre>(); beControlSenalSupCaidasFalloTestControlCierre obeSupervisionCaidas; while (drd.Read()) { obeSupervisionCaidas = new beControlSenalSupCaidasFalloTestControlCierre(); obeSupervisionCaidas.Fecha = drd.GetString(dAlmDate); obeSupervisionCaidas.Hora = drd.GetString(dAlmHour); obeSupervisionCaidas.AbndCode = drd.GetString(csid); obeSupervisionCaidas.Oficina = drd.GetString(Oficina); obeSupervisionCaidas.IDSenal = drd.GetString(IDSenal); obeSupervisionCaidas.PhysicalZone = drd.GetString(PhysicalZone); obeSupervisionCaidas.ZonaDescri = drd.GetString(ZonaDescri); obeSupervisionCaidas.ImagenRuta = NombreDeIcono(drd.GetString(AdminOEmergencia), drd.GetString(ConComentario)); obeSupervisionCaidas.Zonaphys_Zonadescri = obeSupervisionCaidas.PhysicalZone + " - " + obeSupervisionCaidas.ZonaDescri; obeSupervisionCaidas.Condicion = drd.GetString(Condicion); lbeSupervisionCaidas.Add(obeSupervisionCaidas); } drd.Close(); } return(lbeSupervisionCaidas); }