/// <summary> /// SearchOrderByState函数的功能:订单状态查询 /// </summary> /// <param name="state">订单的状态</param> /// <returns>订单详情</returns> public object SearchOrderByState(string state) { b_order_Entity S = new b_order_Entity(); S.B_order_state = state; return(Date.orderSearchByState(S)); }
//--订单查询模块-- /// <summary> /// SearchOrderById函数的功能:订单编号查询 /// </summary> /// <param name="Oid">订单ID</param> /// <returns>订单详情</returns> public object SearchOrderById(int Oid) { b_order_Entity O = new b_order_Entity(); O.B_o_id = Oid; return(Date.orderSearchAllById(O)); }
/// <summary> /// AddOrder函数的功能:向买家订单表中添加一条新的记录 /// </summary> /// <param name="Bid">订单编号</param> /// <param name="Baccount">买家账号</param> /// <param name="Saccount">卖家账号</param> /// <param name="storeName">商铺名</param> /// <param name="money">总计金额</param> public void AddOrder(string Baccount, string Saccount, string storeName, string state, double money) { b_order_Entity O = new b_order_Entity(); O.B_account = Baccount; O.S_account = Saccount; O.S_storeName = storeName; O.B_order_state = state; O.B_o_totalprice = money; Date.InsertToOrder(O); }
/// <summary> /// InsertToOrder函数的功能:访问数据库的买家订单表向表中添加一条新的记录(增) /// </summary> /// <param name="order">买家订单对象</param> public void InsertToOrder(b_order_Entity order) { b_order_T Order = new b_order_T(); Order.b_account = order.B_account; Order.s_account = order.S_account; Order.s_storeName = order.S_storeName; Order.b_orderState = order.B_order_state; Order.b_o_totalPrice = (decimal)order.B_o_totalprice; Order.b_o_time = DateTime.Now; buyerDB.b_order_T.InsertOnSubmit(Order); buyerDB.SubmitChanges(); }
/// <summary> /// orderSearchByState函数的功能:访问数据库按订单状态查询订单的详情(查) /// </summary> /// <param name="orderstate">买家订单状态表对象</param> /// <returns>LINQ查询结果的集合</returns> public object orderSearchByState(b_order_Entity orderstate) { var dataSet = buyerDB.b_order_T.Where(d => d.b_orderState == orderstate.B_order_state).Select(d => d); return((object)dataSet); }
//--订单查询模块-- /// <summary> /// orderSearchAllById函数的功能:访问数据库按订单编号查询订单详情(查) /// </summary> /// <param name="order">买家订单表对象</param> /// <returns>LINQ查询结果的集合</returns> public object orderSearchAllById(b_order_Entity order) { var dataSet = buyerDB.b_order_item_T.Where(d => d.b_o_Id == order.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"); } } }