/// <summary>
/// 取得配送訂單清單
/// </summary>
/// <param name="memberId">會員編號</param>
/// <returns>配送訂單清單</returns>
public List <ShippingOrder> GetShippingOrders(int memberId)
{
ShippingOrderQueryBuilder builder = new ShippingOrderQueryBuilder();
string sql = builder.GetShippingOrdersSql();
return(this.ShippingOrderRepository.Query <ShippingOrder>(sql, new { MemberId = memberId }).ToList());
}
/// <summary>
/// 新增配送訂單
/// </summary>
/// <param name="orderId">訂單編號</param>
public void InsertShippingOrder(string orderId)
{
ShippingOrder model = new ShippingOrder()
{
Id = this.GetShippingOrderSequence(),
OrderId = orderId,
Status = 1,
CteatedAt = DateTime.Now
};
ShippingOrderQueryBuilder builder = new ShippingOrderQueryBuilder();
string sql = builder.GetInsertShippingOrderSql();
this.ShippingOrderRepository.Execute(sql, model);
}