/// <summary>
/// 新增订单并且新增订单详情
/// </summary>
/// <returns></returns>
public void Order_Add(Orders_Model obj, List <OrdersDetail_Model> cartItems)
{
//采用数组存储参数
SqlParameter[] ter = new SqlParameter[] {
new SqlParameter("@UName", obj.UName), //用户ID
new SqlParameter("@ConsigneeName", obj.ConsigneeName), //收货人姓名
new SqlParameter("@Phone", obj.Phone), //手机号码
new SqlParameter("@Address", obj.Address), //收货地址
new SqlParameter("@AddressDetail", obj.AddressDetail), //收货地址详情
new SqlParameter("@YouZhengBianMa", obj.YouZhengBianMa), //邮政编码
new SqlParameter("@Amount", obj.Amount), //总金额
};
//通过sql @@identity 全局变量 --得到刚刚上面订单表添加数据成功后的自增ID
object OrderID = SqlHelper.ExecuteScalar("Order_Add", ter);//添加订单，获取订单ID
//如果对象不为空的话
if (OrderID != null)
{
//遍历购物车中每一件商品
foreach (var item in cartItems)
{
SqlParameter[] ter2 = new SqlParameter[] {
new SqlParameter("@OrderId", Convert.ToInt32(OrderID)), //订单自增ID
new SqlParameter("@ShoppID", item.ShoppID), //商品ID
new SqlParameter("@Price", item.Price), //商品价格
new SqlParameter("@Quantity", item.Quantity), //商品数量
};
//添加订单详细
SqlHelper.ExecuteNonQuery("OrderDetail_Add", ter2);
}
}
}
/// <summary>
/// 查询全部订单信息
/// </summary>
/// <param name="UserName"></param>
/// <returns></returns>
public List <Orders_Model> Order_GetList_ByUserId(string UserName)
{
// 采用 list 集合存储数据
List <Orders_Model> list = new List <Orders_Model>();
// 采用数组存储参数
SqlParameter[] param = new SqlParameter[] {
new SqlParameter("@UserName", UserName)
};
using (SqlDataReader dr = SqlHelper.ExecuteReader("Order_GetList_ByUserId", param))
{
while (dr.Read())
{
Orders_Model model = new Orders_Model();
model.OrderId = Convert.ToInt32(dr["OrderId"]);
model.OrderNo = Convert.ToString(dr["OrderNo"]);
model.Amount = Convert.ToDecimal(dr["Amount"]);
model.IsPayment = Convert.ToBoolean(dr["IsPayment"]);
model.OrderTime = Convert.ToDateTime(dr["OrderTime"]).ToString("yyyy-MM-dd");
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 新增订单并且新增订单详情
/// </summary>
/// <returns></returns>
public void Order_Add(Orders_Model obj, List <OrdersDetail_Model> cartItems)
{
dal.Order_Add(obj, cartItems);
}
