Line 184: try
Line 185: {
Line 186: pOconnect.Open();
Line 187: if (tCtype == "I")
Line 188: pOcmd = new SqlCommand("SELECT ecofl.Citem, SUBSTRING(Cimage1, 1, LEN(Cimage1) -4) AS Cshort_cd, SUBSTRING(Citem,1,2) +'-' +RTRIM(SUBSTRING(Citem,3,16)) +'-' +RTRIM(SUBSTRING(Citem,19,8)) AS Cnewitm, Cdesc, Mspec, Mhlight, Mbox, IIF(CONVERT(date, GETDATE()) BETWEEN Ds_start AND Ds_end, Ns_price, ISNULL(Norg_price, Nprice)) AS Nprice, IIF(CONVERT(date, GETDATE()) BETWEEN Ds_start AND Ds_end, Ns_price, 0.00) AS Ns_price, Ds_start, Ds_end, Dend, Cimage1, Cimage2 ,Cimage3, Cimage4, Nweight, Nsize, Ncourier, Ncour_mthd, Csize, Lstock, Ccategory, Nbal_qty, IIF(CONVERT(date, GETDATE()) BETWEEN Ds_start AND Ds_end, ISNULL(Norg_price, Nprice), null) AS Norg_price, Dnew, Lsize, Lcolor, Cbrand, '', IIF(CONVERT(date, GETDATE()) BETWEEN Ds_start AND Ds_end, '/images/system/sale.png', '') AS Coffer FROM pcfair.dbo.ecofl WHERE Citem ='" + tCitem + "'", pOconnect);
|