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
| [WebMethod]
public DataSet GetProcess(string nfacture, string codeproduit, string at)
{
SqlConnection cn = new SqlConnection("server=serveurdev;uid=***;pwd=***;Trusted_Connection=Yes;database=***");
string QueryProcess = "SELECT action,destinataire,suivi FROM conditions WHERE marque IN (" +
"SELECT marque FROM produits WHERE codeproduit LIKE '%" + codeproduit + "%' )" +
"AND [gm] IN (" +
"SELECT [gm] FROM [Boulanger].[dbo].[produits] WHERE [codeproduit] LIKE '%" + codeproduit + "%' )" +
"AND [at] LIKE '%" + at + "%' " +
"AND (DATEDIFF(day, (" +
"SELECT [date_achat] FROM [Boulanger].[dbo].[factures] WHERE [nfacture] LIKE '%" + nfacture + "%'), GETDATE()) >= [jmin]) " +
"AND (DATEDIFF(day, (" +
"SELECT [date_achat] FROM [Boulanger].[dbo].[factures] WHERE [nfacture] LIKE '%" + nfacture + "%'), GETDATE()) <= [jmax])";
string QueryProcess2 = "SELECT Action FROM conditions WHERE marque = 'AUTRE'";
SqlDataAdapter Process = new SqlDataAdapter(QueryProcess, cn);
SqlDataAdapter Process2 = new SqlDataAdapter(QueryProcess2, cn);
DataSet Ds = new DataSet();
DataSet Ds2 = new DataSet();
cn.Open();
Process.Fill(Ds, "Process");
Process2.Fill(Ds2, "Process");
if (Ds.Tables[0].Rows.Count == 0)
{
cn.Close();
cn = null;
Process = null;
Process2 = null;
return Ds2;
}
else
{
cn.Close();
cn = null;
Process = null;
Process2 = null;
return Ds;
} |
Partager