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
| public DataSet searchParameter(Parameter par)
{
int nbParam = 0;
String sRequete;
sRequete = "SELECT DOMAIN_ID, SUB_DOMAIN_ID,CODE,VAL1,VAL2,VAL3,VAL4,VAL5,VAL6 FROM APPLICATION_PARAMETER_EXT";
if (par.DomainID != "Select an item" )
{
sRequete += " WHERE DOMAIN_ID like '" + par.DomainID + "'";
nbParam++;
}
if (par.SubDomainID != "Select an item")
{
if (nbParam == 0)
sRequete += " WHERE";
else
sRequete += " AND";
sRequete += " SUB_DOMAIN_ID like '" + par.SubDomainID + "'";
nbParam++;
}
if (par.Code != "Select an item")
{
if (nbParam == 0)
sRequete += " WHERE";
else
sRequete += " AND";
sRequete += " CODE like '" + par.Code + "'";
}
if (par.Description != "")
{
if (nbParam == 0)
sRequete += " WHERE";
else
sRequete += " AND";
sRequete += " upper(DESCRIPTION) like upper('%" + par.Description + "%')";
}
ds = db.ExecuteReader(sRequete);
return ds;
}
public DataSet searchParameter2(Parameter par)
{
int nbParam = 0;
String sRequete;
sRequete = "SELECT description FROM APPLICATION_PARAMETER_EXT";
if (par.DomainID != "Select an item")
{
sRequete += " WHERE DOMAIN_ID like '" + par.DomainID + "'";
nbParam++;
}
if (par.SubDomainID != "Select an item")
{
if (nbParam == 0)
sRequete += " WHERE";
else
sRequete += " AND";
sRequete += " SUB_DOMAIN_ID like '" + par.SubDomainID + "'";
nbParam++;
}
if (par.Code != "Select an item")
{
if (nbParam == 0)
sRequete += " WHERE";
else
sRequete += " AND";
sRequete += " CODE like '" + par.Code + "'";
}
if (par.Description != "")
{
if (nbParam == 0)
sRequete += " WHERE";
else
sRequete += " AND";
sRequete += " upper(DESCRIPTION) like upper('%" + par.Description + "%')";
}
ds = db.ExecuteReader(sRequete);
return ds;
} |