/// <summary>
/// 增加一条数据
/// </summary>
public static void Add(OrderProductsEntity model, Database db, DbTransaction tran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into OrderProducts(");
strSql.Append("OrderCode,Spu,Sku,Quantity,UnitPrice,PayUnitPrice,TaxRate,Commission,PayAmount,TaxAmount,IsBearDuty,RefundQuantity,PayTaxAmountRMB,PayTaxAmonutHKD,VATTaxRate,CBEBTaxRate,PPATaxRate,ConsumerTaxRate,Huoli,Coupon)");
strSql.Append(" values (");
strSql.Append("@OrderCode,@Spu,@Sku,@Quantity,@UnitPrice,@PayUnitPrice,@TaxRate,@Commission,@PayAmount,@TaxAmount,@IsBearDuty,@RefundQuantity,@PayTaxAmountRMB,@PayTaxAmonutHKD,@VATTaxRate,@CBEBTaxRate,@PPATaxRate,@ConsumerTaxRate,@Huoli,@Coupon)");
var parameters = db.CreateParameterCollection();
parameters.Append("@OrderCode", model.OrderCode);
parameters.Append("@Spu", model.Spu);
parameters.Append("@Sku", model.Sku);
parameters.Append("@Quantity", model.Quantity);
parameters.Append("@UnitPrice", model.UnitPrice);
parameters.Append("@PayUnitPrice", model.PayUnitPrice);
parameters.Append("@TaxRate", model.TaxRate);
parameters.Append("@Commission", model.Commission);
parameters.Append("@PayAmount", model.PayAmount);
parameters.Append("@TaxAmount", model.TaxAmount);
parameters.Append("@IsBearDuty", model.IsBearDuty);
parameters.Append("@RefundQuantity", model.RefundQuantity);
parameters.Append("@PayTaxAmountRMB", model.PayTaxAmonutRMB);
parameters.Append("@PayTaxAmonutHKD", model.PayTaxAmonutHKD);
parameters.Append("@VATTaxRate", model.VATTaxRate);
parameters.Append("@CBEBTaxRate", model.CBEBTaxRate);
parameters.Append("@PPATaxRate", model.PPATaxRate);
parameters.Append("@ConsumerTaxRate", model.ConsumerTaxRate);
parameters.Append("@Huoli", model.Huoli);
parameters.Append("@Coupon", model.GiftCard);
db.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters, tran);
}
/// <summary>
/// 更新orderProduct表
/// </summary>
public bool UpdateOrderProduct(OrderProductsEntity model)
{
string strSql = " UPDATE OrderProducts SET SFQty =@SFQty,MQty =@MQty WHERE OrderCode=@OrderCode AND Spu=@Spu AND Sku=@Sku ";
var parameters = DbSFO2ORead.CreateParameterCollection();
parameters.Append("@OrderCode", model.OrderCode);
parameters.Append("@Spu", model.Spu);
parameters.Append("@MQty", model.MQty);
parameters.Append("@SFQty", model.SFQty);
parameters.Append("@Sku", model.Sku);
return(DbSFO2OMain.ExecuteSqlNonQuery(strSql, parameters) > 0);
}
/// <summary>
/// 增加一条数据
/// </summary>
public static void Update(OrderProductsEntity model, Database db, DbTransaction tran)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("UPDATE OrderProducts ");
strSql.Append("SET TaxRate=@TaxRate,TaxAmount=@TaxAmount ");
strSql.Append("WHERE Spu=@Spu AND Sku=@Sku AND OrderCode=@OrderCode ");
var parameters = db.CreateParameterCollection();
parameters.Append("@OrderCode", model.OrderCode);
parameters.Append("@Spu", model.Spu);
parameters.Append("@Sku", model.Sku);
parameters.Append("@TaxRate", model.TaxRate);
parameters.Append("@TaxAmount", model.TaxAmount);
db.ExecuteNonQuery(CommandType.Text, strSql.ToString(), parameters, tran);
}
/// <summary>
/// 增加促销信息
/// </summary>
/// <param name="model"></param>
/// <param name="db"></param>
/// <param name="tran"></param>
/// <returns></returns>
public static bool AddOrderPromotion(OrderProductsEntity model, Database db, DbTransaction tran)
{
if (model.PromotionId > 0)
{
string sql =
@"INSERT INTO [OrderPromotions]([OrderCode],[Spu],[Sku],[PromotionId],[PromotionPrice],[OriginalPrice],[OriginalRMBPrice])
VALUES (@OrderCode,@Spu,@Sku,@PromotionId,@PromotionPrice,@OriginalPrice,@OriginalRMBPrice)";
var parameters = db.CreateParameterCollection();
parameters.Append("@OrderCode", model.OrderCode);
parameters.Append("@Spu", model.Spu);
parameters.Append("@Sku", model.Sku);
parameters.Append("@PromotionId", model.PromotionId);
parameters.Append("@PromotionPrice", model.UnitPrice);
parameters.Append("@OriginalPrice", model.OriginalPrice);
parameters.Append("@OriginalRMBPrice", model.OriginalRMBPrice);
return(db.ExecuteNonQuery(CommandType.Text, sql.ToString(), parameters, tran) > 0);
}
else
{
return(true);
}
}
