public object SearchStateByOId(int Oid) { b_order_state_Entity O = new b_order_state_Entity(); O.B_o_id = Oid; return(Date.orderSearchStateById(O)); }
/// <summary> /// AddOrderState函数的功能:向买家订单状态表中添加一条新的记录 /// </summary> /// <param name="Bid">订单编号</param> /// <param name="state">订单状态</param> /// <param name="time">提交时间</param> public void AddOrderState(int Bid, string state) { b_order_state_Entity State = new b_order_state_Entity(); State.B_o_id = Bid; State.B_o_state = state; Date.InsertToOrderState(State); }
/// <summary> /// 订单支付 /// </summary> /// <param name="Bid">买家ID</param> /// <param name="state">订单状态</param> public void PayForOrder(int Bid, string state, DateTime time) { b_order_state_Entity S = new b_order_state_Entity(); S.B_o_id = Bid; S.B_o_state = state; S.B_o_subTime = time; Date.InsertToOrderState(S); }
/// <summary> /// InsertToOrderState函数的功能:访问数据库的买家订单状态表并向表中添加一条新的记录(增) /// </summary> /// <param name="orderstate">买家订单状态对象</param> public void InsertToOrderState(b_order_state_Entity orderstate) { b_order_state_T state = new b_order_state_T(); state.b_o_Id = orderstate.B_o_id; state.b_o_state = orderstate.B_o_state; state.b_o_subTime = DateTime.Now; buyerDB.b_order_state_T.InsertOnSubmit(state); buyerDB.SubmitChanges(); }
/// <summary> /// orderSearchStateById函数的功能:访问数据库按订单编号查询订单状态(查) /// </summary> /// <param name="orderstate">买家订单表对象</param> /// <returns>LINQ查询结果的集合</returns> public object orderSearchStateById(b_order_state_Entity orderstate) { var dataSet = buyerDB.b_order_state_T.Where(d => d.b_o_Id == orderstate.B_o_id).Select(d => d); return((object)dataSet); }
protected void btnSubmit_Click1(object sender, EventArgs e) { string account = Session["UserAccount"].ToString().Trim(); double balance = (double)buyer.SearchBalance(account); int totalPrice = int.Parse(lblTotalPrice.Text); if (totalPrice <= 0) { Response.Write(MessagesBox.showMessages("请点击重新计算或选择所要购买的商品!")); } else { if (balance >= totalPrice)//判断买家余额是否足够 { if (chkIsOnline.Checked == true) { buyer.AddMoney(account, -1.0 * totalPrice);//扣除买家余额 } for (int i = 0; i < gv.Rows.Count; i++) { CheckBox chkProduct = (CheckBox)gv.Rows[i].FindControl("chkProducts"); if (chkProduct.Checked == true) { //向买家订单表插数据 b_order = new b_order_Entity(); b_order.B_account = gv.Rows[i].Cells[1].Text; b_order.S_account = gv.Rows[i].Cells[2].Text; b_order.S_storeName = gv.Rows[i].Cells[3].Text; b_order.B_o_totalprice = double.Parse(lblTotalPrice.Text); if (chkIsOnline.Checked == true) { b_order.B_order_state = "已付款"; } else { b_order.B_order_state = "未支付"; } //记录上一次的卖家和买家账号用于判断所选的是否属性同一个订单 string b_account = ""; //买家账号 string s_account = ""; //卖家账号 if (i > 0) { b_account = gv.Rows[i - 1].Cells[1].Text; s_account = gv.Rows[i - 1].Cells[2].Text; } //如果是第一个商品的话,增加一条订单记录 if (i == 0) { buyer.AddOrder(b_order.B_account, b_order.S_account, b_order.S_storeName, b_order.B_order_state, b_order.B_o_totalprice); } else { //根据买家、卖家账号判断所选商品是否属性同一个订单 if (b_account == gv.Rows[i].Cells[1].Text && s_account == gv.Rows[i].Cells[2].Text) { } else { buyer.AddOrder(b_order.B_account, b_order.S_account, b_order.S_storeName, b_order.B_order_state, b_order.B_o_totalprice); } } //向买家订单项目表插数据 int id = buyer.searchLatestBOrderId();//获取最新的订单编号 b_order_item = new b_order_item_Entity(); b_order_item.B_o_id = id; b_order_item.P_id = int.Parse(gv.Rows[i].Cells[4].Text); b_order_item.P_price = double.Parse(gv.Rows[i].Cells[6].Text); TextBox txtNum = (TextBox)gv.Rows[i].FindControl("txtNum"); b_order_item.P_num = int.Parse(txtNum.Text); //buyer.AddOrderItem(b_order_item.B_o_id, b_order_item.P_id, b_order_item.P_price, b_order_item.P_num); //向买家订单状态表插数据 b_order_state = new b_order_state_Entity(); b_order_state.B_o_id = id; b_order_state.B_o_subTime = DateTime.Now; if (chkIsOnline.Checked == true) { b_order_state.B_o_state = "已付款"; } else { b_order_state.B_o_state = "未支付"; } //buyer.AddOrderState(b_order_state.B_o_id, b_order_state.B_o_state); buyer.DeleteFromCart(Session["UserAccount"].ToString().Trim(), int.Parse(gv.Rows[i].Cells[4].Text)); } } Response.Write(MessagesBox.showMessages("提交结算成功!")); Response.Redirect("../Default.aspx"); } else { Response.Write(MessagesBox.showMessages("您的余额不足,请充值!")); Response.Redirect("../buyer/SearchBalance.aspx"); } } }