Line 39: name = cnn.ExecuteScalar("select MainCategoryName from M_CategoryMaster where MainCategoryid=" + Request.QueryString["MainCategoryid"] + "").ToString();
Line 40: if (Request.QueryString["SubCategoryid"] != null)
Line 41: subname = cnn.ExecuteScalar("select SubCategoryName from subcategory where id=" + Request.QueryString["SubCategoryid"] + "").ToString();
Line 42: string s= "select productid,productname,image,sale,(select top 1 coalesce(urate,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID) as price,(select top 1 coalesce(udiscount,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID) as discount,(select top 1 coalesce(urate,0)-coalesce(udiscount,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID)as price1,Case When Cast(rts as Date)>=Cast(GetDate()-10 as Date) Then 1 Else 0 End as NewStatus,sale from product where active=1 " + cond + " " + cond1 + " ";
Line 43: DataTable Dtt = cnn.FillTable("select productid,productname,image,sale,(select top 1 coalesce(urate,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID) as price,(select top 1 coalesce(udiscount,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID) as discount,(select top 1 coalesce(urate,0)-coalesce(udiscount,0) from ProductSizeQuantity where ProductSizeQuantity.ProductID=product.ProductID)as price1,Case When Cast(rts as Date)>=Cast(GetDate()-10 as Date) Then 1 Else 0 End as NewStatus,sale from product where active=1 " + cond + " " + cond1 + " ", "Detail");
|