1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82
| using System;
using System.Collections.Generic;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using Oracle.DataAccess.Client;
public partial class _Default : System.Web.UI.Page
{
protected string MaVariable;
protected void Page_Load(object sender, EventArgs e)
{
string oradb = "Data Source=***;User Id=***;Password=***;";
OracleConnection conn = new OracleConnection();
conn.ConnectionString = oradb;
try
{
conn.Open();
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select * from MONITORING.T_MONITORING_VALUES ORDER BY MONORDER ASC";
cmd.CommandType = CommandType.Text;
OracleDataReader dr = cmd.ExecuteReader();
Color coulBg = Color.Black;
do
{
while (dr.Read())
{
switch (dr["monhier"].ToString())
{
case "1":
lbl_tickerLow.ForeColor = Color.Green;
lbl_tickerLow.BackColor = coulBg;
lbl_tickerLow.Text += " Nom: " + dr["monname"] + ", Context: " + dr["moncontext"] + ", Valeur: " + dr["monvalue"] + ", Hierarchie: " + dr["monhier"] + ", ";
MaVariable= "TICKERLOW";
break;
case "2":
lbl_tickerMedium.ForeColor = Color.Orange;
lbl_tickerMedium.BackColor = coulBg;
lbl_tickerMedium.Text += " Nom: " + dr["monname"] + ", Context: " + dr["moncontext"] + ", Valeur: " + dr["monvalue"] + ", Hierarchie: " + dr["monhier"] + ", ";
MaVariable= "TICKERMEDIUM";
break;
case "3":
lbl_tickerHigh.ForeColor = Color.Red;
lbl_tickerHigh.BackColor = coulBg;
lbl_tickerHigh.Text += " Nom: " + dr["monname"] + ", Context: " + dr["moncontext"] + ", Valeur: " + dr["monvalue"] + ", Hierarchie: " + dr["monhier"] + ", ";
MaVariable= "TICKERHIGH";
break;
default:
break;
}
}
} while (dr.NextResult());
dr.Close();
conn.Close();
}
catch (Exception ex) // intercepte toutes les erreurs
{
throw ex;
}
finally
{
conn.Dispose();
C_PH_ScriptJS.databind();
}
}
} |
Partager