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