bool IntfDalUSAppareil.updateUSArret(crlUSAppareil appareil)
{
#region declaration
bool isUpdate = false;
int nbUpdate = 0;
#endregion
#region implementation
if (appareil != null)
{
this.strCommande = "UPDATE `usappareil` SET `typeAppareil`='" + appareil.TypeAppareil + "',";
this.strCommande += " `numSerie`='" + appareil.NumSerie + "'";
this.strCommande += " WHERE `numAppareil`='" + appareil.NumAppareil + "'";
this.serviceConnectBase.openConnection();
nbUpdate = this.serviceConnectBase.requete(this.strCommande);
if (nbUpdate == 1)
{
isUpdate = true;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(isUpdate);
}
crlUSAppareil IntfDalUSAppareil.selectUSAppareil(string numAppareil)
{
#region declaration
crlUSAppareil appareil = null;
#endregion
#region implementation
if (numAppareil != "")
{
this.strCommande = "SELECT * FROM `usappareil` WHERE `numAppareil`='" + numAppareil + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
appareil = new crlUSAppareil();
appareil.NumAppareil = this.reader["numAppareil"].ToString();
appareil.NumSerie = this.reader["numSerie"].ToString();
appareil.TypeAppareil = this.reader["typeAppareil"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(appareil);
}
string IntfDalUSAppareil.insertUSAppareil(crlUSAppareil appareil, string sigleAgence)
{
#region declaration
string numAppareil = "";
IntfDalUSAppareil serviceUSAppareil = new ImplDalUSAppareil();
int nbInsert = 0;
#endregion
#region implementation
if (appareil != null && sigleAgence != "")
{
appareil.NumAppareil = serviceUSAppareil.getNumUSAppareil(sigleAgence);
this.strCommande = "INSERT INTO `usappareil` (`numAppareil`,`typeAppareil`,";
this.strCommande += " `numSerie`) VALUES";
this.strCommande += " ('" + appareil.NumAppareil + "','" + appareil.TypeAppareil + "',";
this.strCommande += " '" + appareil.NumSerie + "')";
this.serviceConnectBase.openConnection();
nbInsert = this.serviceConnectBase.requete(this.strCommande);
if (nbInsert == 1)
{
numAppareil = appareil.NumAppareil;
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numAppareil);
}
string IntfDalUSAppareil.isUSAppareil(crlUSAppareil appareil)
{
#region declaration
string numAppareil = "";
#endregion
#region implementation
if (appareil != null)
{
this.strCommande = "SELECT usappareil.numAppareil FROM `usappareil` WHERE";
this.strCommande += " usappareil.numSerie = '" + appareil.NumSerie + "' AND";
this.strCommande += " usappareil.numAppareil <> '" + appareil.NumAppareil + "'";
this.serviceConnectBase.openConnection();
this.reader = this.serviceConnectBase.select(this.strCommande);
if (this.reader != null)
{
if (this.reader.HasRows)
{
if (this.reader.Read())
{
numAppareil = this.reader["numAppareil"].ToString();
}
}
this.reader.Dispose();
}
this.serviceConnectBase.closeConnection();
}
#endregion
return(numAppareil);
}
