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
| private void Imprimer_Click(object sender, System.EventArgs e)
{
// DECLARATIONS
string RequeteSQL;
SqlConnection connection;
SqlCommand command;
SqlDataAdapter _MonDataAdapter;
System.Data.DataTable _MaDataTable;
// CONNEXION
connection = new SqlConnection("Data Source=SNCK96400031;Initial Catalog=DistribInfo;Integrated Security=SSPI");
try
{
connection.Open();
// RECUPERER LA LISTE DES MACHINES QUI ONT POUR NUMERO NUMMACHINE.TEXT
RequeteSQL = "SELECT M_IDMAT FROM MACHINE WHERE M_IDMAT='" + NumMachine.Text + "'";
_MonDataAdapter = new SqlDataAdapter(RequeteSQL, connection);
_MaDataTable = new DataTable();
_MonDataAdapter.Fill(_MaDataTable);
// SI IL N'Y EN A PAS
if (_MaDataTable.Rows.Count == 0)
{
RequeteSQL = "INSERT INTO MACHINE(M_IDMAT, M_NUMCLT, M_NUMCTACT, M_NOMMAT, M_CONFMAT, M_NOMUTIL, M_RAP_RESP, M_RESINTER) VALUES('" + NumMachine.Text + "', '" + NumClt.Text + "', '" + NumContact.Text + "','" + NomMachine.Text + "', '" + ConfigMachine.Text + "', '" + NomUtMachine.Text + "', '" + RespUt.Text + "', '" + RaisonInter.Text + "'";
MessageBox.Show(RequeteSQL);
command = new SqlCommand(RequeteSQL, connection);
command.ExecuteNonQuery();
RequeteSQL = "INSERT INTO INTERVENTION(IN_NUMINTER, C_NUMCLT, IN_M_NUMCLT, IN_IDMAT, IN_RESINTER, IN_DEPOMAT, IN_RECEPMAT, IN_PRICHARG) VALUES('" + NumInter.Text + "', '" + NumClt.Text + "', '" + NumClt.Text + "','" + NumMachine.Text + "', '" + RaisonInter.Text + "', '" + Dépositaire.Text + "', '" + Réceptionneur.Text + "', '" + DatePrisEnCharge.Text + "'";
MessageBox.Show(RequeteSQL);
command = new SqlCommand(RequeteSQL, connection);
command.ExecuteNonQuery();
}
// SI IL Y EN A 1 OU PLUS
else if (_MaDataTable.Rows.Count > 0)
{
RequeteSQL = "INSERT INTO INTERVENTION(IN_NUMINTER, C_NUMCLT, IN_M_NUMCLT, IN_IDMAT, IN_RESINTER, IN_DEPOMAT, IN_RECEPMAT, IN_PRICHARG) VALUES('" + NumInter.Text + "', '" + NumClt.Text + "', '" + NumClt.Text + "','" + NumMachine.Text + "', '" + RaisonInter.Text + "', '" + Dépositaire.Text + "', '" + Réceptionneur.Text + "', '" + DatePrisEnCharge.Text + "'";
MessageBox.Show(RequeteSQL);
command = new SqlCommand(RequeteSQL, connection);
command.ExecuteNonQuery();
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
connection.Close();
} |
Partager