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
| public String Pointdinstalation ()
{
Database db = new OracleDatabase(OracleConnectionString);
DbCommand cmd = db.GetSqlStringCommand(" select PDI_LIBRE,PDI_REFERENCE,VOC_RAISONETAT_ID from O2_POINTDINSTALLATION where PDI_ID=:Pdi_id ");
db.AddInParameter(cmd, "Pdi_id", DbType.Int32, "8524");
String Pdilibre = String.Empty;
String PDIREFERENCE = string.Empty;
int VOC_RAISONETAT_ID;
using (IDataReader reader = db.ExecuteReader(cmd))
{
if (reader.Read())
{
Pdilibre = reader.GetString(0);
PDIREFERENCE = reader.GetString(1);
VOC_RAISONETAT_ID = reader.GetInt32(3);
}
return Pdilibre;
}
} |
Partager