protected void btnOrderOk_Click(object sender, EventArgs e)
{
SqlDataReader dr = (SqlDataReader)SqlDataSource_ShoppingCar.Select(DataSourceSelectArguments.Empty);
if (!dr.Read())
{
lblMsg.Text = "未選購產品，所以無法傳送訂單!";
return;
}
dr.Close();
SqlDataSource_Order.InsertParameters["帳號"].DefaultValue = txtUid.Text;
SqlDataSource_Order.InsertParameters["收貨人"].DefaultValue = txtReceiverName.Text;
SqlDataSource_Order.InsertParameters["收貨人電話"].DefaultValue = txtReceiverTel.Text;
SqlDataSource_Order.InsertParameters["收貨人住址"].DefaultValue = txtReceiverAdd.Text;
SqlDataSource_Order.InsertParameters["下單日期"].DefaultValue = DateTime.Now.ToShortDateString();
SqlDataSource_Order.InsertParameters["訂單狀態"].DefaultValue = "未處理";
SqlDataSource_Order.Insert();
int orderId = 1;
SqlDataReader drOrder = (SqlDataReader)SqlDataSource_Order.Select(DataSourceSelectArguments.Empty);
if (drOrder.Read())
{
orderId = int.Parse(drOrder["訂單編號"].ToString());
}
try
{
SqlDataReader drShopping = (SqlDataReader)SqlDataSource_ShoppingCar.Select(DataSourceSelectArguments.Empty);
while (drShopping.Read())
{
SqlDataSource_OrderDetail.InsertParameters["訂單編號"].DefaultValue = orderId.ToString();
SqlDataSource_OrderDetail.InsertParameters["產品編號"].DefaultValue = drShopping["產品編號"].ToString();
SqlDataSource_OrderDetail.InsertParameters["單價"].DefaultValue = drShopping["單價"].ToString();
SqlDataSource_OrderDetail.InsertParameters["數量"].DefaultValue = drShopping["數量"].ToString();
SqlDataSource_OrderDetail.Insert();
}
SqlDataSource_ShoppingDelAll.DeleteParameters["帳號"].DefaultValue = txtUid.Text;
SqlDataSource_ShoppingDelAll.Delete();
Response.Redirect("Member_ShoppingOk.htm");
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
protected void DataList_Product_ItemCommand(object source, DataListCommandEventArgs e)
{
if (e.CommandName == "Buy")
{
if (Session["IsMemberLogin"] == null)
{
Response.Redirect("Member_Login_suggestion.htm");
}
else
{
try
{
Label lblProductId = (Label)e.Item.FindControl("產品編號Label");
Label lblProductName = (Label)e.Item.FindControl("品名Label");
Label lblProductPrice = (Label)e.Item.FindControl("單價Label");
SqlDataSource_ShoppingCar.SelectParameters["帳號"].DefaultValue = Session["MemberUid"].ToString();
SqlDataSource_ShoppingCar.SelectParameters["產品編號"].DefaultValue = lblProductId.Text;
SqlDataReader dr = (SqlDataReader)SqlDataSource_ShoppingCar.Select(DataSourceSelectArguments.Empty);
if (dr.Read())
{
SqlDataSource_ShoppingCar.UpdateParameters["帳號"].DefaultValue = Session["MemberUid"].ToString();
SqlDataSource_ShoppingCar.UpdateParameters["產品編號"].DefaultValue = lblProductId.Text;
SqlDataSource_ShoppingCar.Update();
}
else
{
SqlDataSource_ShoppingCar.InsertParameters["帳號"].DefaultValue = Session["MemberUid"].ToString();
SqlDataSource_ShoppingCar.InsertParameters["產品編號"].DefaultValue = lblProductId.Text;
SqlDataSource_ShoppingCar.InsertParameters["品名"].DefaultValue = lblProductName.Text;
SqlDataSource_ShoppingCar.InsertParameters["單價"].DefaultValue = lblProductPrice.Text;
SqlDataSource_ShoppingCar.InsertParameters["數量"].DefaultValue = "1";
SqlDataSource_ShoppingCar.Insert();
}
dr.Close();
lblMsg.Text = "產品" + lblProductName.Text + "已放入購物清單";
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
}
}
