protected void Page_Init(object sender, EventArgs e)
{
// 宣告WHERE子句的IN條件
// string Converted_string = HttpUtility.UrlEncode("商品編號");
// string where = "WHERE [Converted_string] IN (";
string where = "WHERE [商品編號] IN (";
bool isFirst = true;
// 取出所有Cookie
foreach (string ProductItem in Request.Cookies)
{
// 是否是購物車的Cookie
if (ProductItem.StartsWith("CUST E-Commerce"))
{
if (isFirst) // 第1次
{
where += "'" + Request.Cookies[ProductItem]["ID"] + "'";
Order_List = "CUST E-Commerce";
isFirst = false;
}
else
{
where += ", '" + Request.Cookies[ProductItem]["ID"] + "'";
}
hasItem = true;
}
}
where += ")"; // 完成WHERE子句
// 更改資料來源控制項的SELECT指令
if (hasItem)
{
SqlDataSource1.SelectCommand += where;
}
else
{
SqlDataSource1.SelectCommand += "WHERE [商品編號] IN ('0000')";
}
}
