/// <summary>
/// 获取订单状态
/// </summary>
/// <param name="id">订单id</param>
/// <param name="userId">用户id</param>
/// <param name="isSeller">是否为卖家</param>
/// <returns></returns>
public OrderStatus OrderStatusGet(string id, int userId, bool isSeller)
{
return(Try(nameof(OrderStatusGet), () =>
{
var cmd = SqlBuilder
.Select("Status")
.From("orderinfo")
.Where("Id=@Id", new { id })
.Where(isSeller ? "SellerId=@userId" : "BuyerId=@userId", new { userId })
.ToCommand(0);
return TradeConn.ExecuteScalar <OrderStatus>(cmd);
}));
}
///<summary>
/// 订单Note创建
///</summary>
///<param name="o">订单Note</param>
///<returns></returns>
public int OrderNoteCreate(OrderNote o)
{
return(Try(nameof(OrderNoteCreate), () =>
{
var cmd = SqlBuilder.Insert("OrderNote")
.Column("Type", o.Type)
.Column("UserId", o.UserId)
.Column("OrderId", o.OrderId)
.Column("Subject", o.Subject)
.Column("Message", o.Message)
.Column("Extra", o.Extra)
.Column("CreatedBy", o.CreatedBy)
.Column("CreatedOn", o.CreatedOn)
.ToCommand(true);
return TradeConn.ExecuteScalar <int>(cmd);
}));
}