J'ai une méthode update qui doit updaté 8 lignes si c'est le cas. Par contre, il se peut qu'elle n'est pas besoins d'updaté toutes les lignes.

Voici à quoi cela ressemble

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + iqt.Darkness + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='DARKNESS_TEST'");
 
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + iqt.Skew + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='SKEW_TEST'");
 
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + iqt.Size + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='SIZE_TEST'");
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + iqt.PiggyBack + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='PIGGY_BACK_TEST'");
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + iqt.FlawedEdge + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='FLAWED_EDGE_TEST'");
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + iqt.Corner + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='CORNER_TEST'");
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + ut.MicrLine + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='MICR_LINE'");
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + ut.Date + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='DATE'");
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + ut.Payee + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='PAYEE'");
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + ut.Signature + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='SIGNATURE'");
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + ut.Courtesy + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='COURTESY_AMOUNT'");
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + ut.Legal + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='LEGAL_AMOUT'");
            db.ExecuteNonQuery("UPDATE APPLICATION_PARAMETER_EXT SET VAL1='" + ut.Endorsement + "' WHERE DOMAIN_ID='IQA' AND SUB_DOMAIN_ID='ENDORSEMENT'");
Il y a un moyen d'optimiser le tout car c'est très lent...

Merci