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