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