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; } } } }