本文整理汇总了C#中OrderInfo.GetProfit方法的典型用法代码示例。如果您正苦于以下问题：C# OrderInfo.GetProfit方法的具体用法？C# OrderInfo.GetProfit怎么用？C# OrderInfo.GetProfit使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类OrderInfo的用法示例。
在下文中一共展示了OrderInfo.GetProfit方法的2个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CreatOrder
public bool CreatOrder(OrderInfo orderInfo, DbTransaction dbTran)
{
DbCommand storedProcCommand = this.database.GetStoredProcCommand("ss_CreateOrder");
this.database.AddInParameter(storedProcCommand, "OrderId", DbType.String, orderInfo.OrderId);
this.database.AddInParameter(storedProcCommand, "OrderDate", DbType.DateTime, orderInfo.OrderDate);
this.database.AddInParameter(storedProcCommand, "UserId", DbType.Int32, orderInfo.UserId);
this.database.AddInParameter(storedProcCommand, "UserName", DbType.String, orderInfo.Username);
this.database.AddInParameter(storedProcCommand, "Wangwang", DbType.String, orderInfo.Wangwang);
this.database.AddInParameter(storedProcCommand, "RealName", DbType.String, orderInfo.RealName);
this.database.AddInParameter(storedProcCommand, "EmailAddress", DbType.String, orderInfo.EmailAddress);
this.database.AddInParameter(storedProcCommand, "Remark", DbType.String, orderInfo.Remark);
this.database.AddInParameter(storedProcCommand, "AdjustedDiscount", DbType.Currency, orderInfo.AdjustedDiscount);
this.database.AddInParameter(storedProcCommand, "OrderStatus", DbType.Int32, (int) orderInfo.OrderStatus);
this.database.AddInParameter(storedProcCommand, "ShippingRegion", DbType.String, orderInfo.ShippingRegion);
this.database.AddInParameter(storedProcCommand, "Address", DbType.String, orderInfo.Address);
this.database.AddInParameter(storedProcCommand, "ZipCode", DbType.String, orderInfo.ZipCode);
this.database.AddInParameter(storedProcCommand, "ShipTo", DbType.String, orderInfo.ShipTo);
this.database.AddInParameter(storedProcCommand, "TelPhone", DbType.String, orderInfo.TelPhone);
this.database.AddInParameter(storedProcCommand, "CellPhone", DbType.String, orderInfo.CellPhone);
this.database.AddInParameter(storedProcCommand, "ShipToDate", DbType.String, orderInfo.ShipToDate);
this.database.AddInParameter(storedProcCommand, "ShippingModeId", DbType.Int32, orderInfo.ShippingModeId);
this.database.AddInParameter(storedProcCommand, "ModeName", DbType.String, orderInfo.ModeName);
this.database.AddInParameter(storedProcCommand, "RegionId", DbType.Int32, orderInfo.RegionId);
this.database.AddInParameter(storedProcCommand, "Freight", DbType.Currency, orderInfo.Freight);
this.database.AddInParameter(storedProcCommand, "AdjustedFreight", DbType.Currency, orderInfo.AdjustedFreight);
this.database.AddInParameter(storedProcCommand, "ShipOrderNumber", DbType.String, orderInfo.ShipOrderNumber);
this.database.AddInParameter(storedProcCommand, "Weight", DbType.Int32, orderInfo.Weight);
this.database.AddInParameter(storedProcCommand, "ExpressCompanyName", DbType.String, orderInfo.ExpressCompanyName);
this.database.AddInParameter(storedProcCommand, "ExpressCompanyAbb", DbType.String, orderInfo.ExpressCompanyAbb);
this.database.AddInParameter(storedProcCommand, "PaymentTypeId", DbType.Int32, orderInfo.PaymentTypeId);
this.database.AddInParameter(storedProcCommand, "PaymentType", DbType.String, orderInfo.PaymentType);
this.database.AddInParameter(storedProcCommand, "PayCharge", DbType.Currency, orderInfo.PayCharge);
this.database.AddInParameter(storedProcCommand, "RefundStatus", DbType.Int32, (int) orderInfo.RefundStatus);
this.database.AddInParameter(storedProcCommand, "Gateway", DbType.String, orderInfo.Gateway);
this.database.AddInParameter(storedProcCommand, "OrderTotal", DbType.Currency, orderInfo.GetTotal());
this.database.AddInParameter(storedProcCommand, "OrderPoint", DbType.Int32, orderInfo.Points);
this.database.AddInParameter(storedProcCommand, "OrderCostPrice", DbType.Currency, orderInfo.GetCostPrice());
this.database.AddInParameter(storedProcCommand, "OrderProfit", DbType.Currency, orderInfo.GetProfit());
this.database.AddInParameter(storedProcCommand, "Amount", DbType.Currency, orderInfo.GetAmount());
this.database.AddInParameter(storedProcCommand, "ReducedPromotionId", DbType.Int32, orderInfo.ReducedPromotionId);
this.database.AddInParameter(storedProcCommand, "ReducedPromotionName", DbType.String, orderInfo.ReducedPromotionName);
this.database.AddInParameter(storedProcCommand, "ReducedPromotionAmount", DbType.Currency, orderInfo.ReducedPromotionAmount);
this.database.AddInParameter(storedProcCommand, "IsReduced", DbType.Boolean, orderInfo.IsReduced);
this.database.AddInParameter(storedProcCommand, "SentTimesPointPromotionId", DbType.Int32, orderInfo.SentTimesPointPromotionId);
this.database.AddInParameter(storedProcCommand, "SentTimesPointPromotionName", DbType.String, orderInfo.SentTimesPointPromotionName);
this.database.AddInParameter(storedProcCommand, "TimesPoint", DbType.Currency, orderInfo.TimesPoint);
this.database.AddInParameter(storedProcCommand, "IsSendTimesPoint", DbType.Boolean, orderInfo.IsSendTimesPoint);
this.database.AddInParameter(storedProcCommand, "FreightFreePromotionId", DbType.Int32, orderInfo.FreightFreePromotionId);
this.database.AddInParameter(storedProcCommand, "FreightFreePromotionName", DbType.String, orderInfo.FreightFreePromotionName);
this.database.AddInParameter(storedProcCommand, "IsFreightFree", DbType.Boolean, orderInfo.IsFreightFree);
this.database.AddInParameter(storedProcCommand, "CouponName", DbType.String, orderInfo.CouponName);
this.database.AddInParameter(storedProcCommand, "CouponCode", DbType.String, orderInfo.CouponCode);
this.database.AddInParameter(storedProcCommand, "CouponAmount", DbType.Currency, orderInfo.CouponAmount);
this.database.AddInParameter(storedProcCommand, "CouponValue", DbType.Currency, orderInfo.CouponValue);
if (orderInfo.GroupBuyId > 0)
{
this.database.AddInParameter(storedProcCommand, "GroupBuyId", DbType.Int32, orderInfo.GroupBuyId);
this.database.AddInParameter(storedProcCommand, "NeedPrice", DbType.Currency, orderInfo.NeedPrice);
this.database.AddInParameter(storedProcCommand, "GroupBuyStatus", DbType.Int32, 1);
}
else
{
this.database.AddInParameter(storedProcCommand, "GroupBuyId", DbType.Int32, DBNull.Value);
this.database.AddInParameter(storedProcCommand, "NeedPrice", DbType.Currency, DBNull.Value);
this.database.AddInParameter(storedProcCommand, "GroupBuyStatus", DbType.Int32, DBNull.Value);
}
if (orderInfo.CountDownBuyId > 0)
{
this.database.AddInParameter(storedProcCommand, "CountDownBuyId ", DbType.Int32, orderInfo.CountDownBuyId);
}
else
{
this.database.AddInParameter(storedProcCommand, "CountDownBuyId ", DbType.Int32, DBNull.Value);
}
if (orderInfo.BundlingID > 0)
{
this.database.AddInParameter(storedProcCommand, "BundlingID ", DbType.Int32, orderInfo.BundlingID);
this.database.AddInParameter(storedProcCommand, "BundlingPrice", DbType.Currency, orderInfo.BundlingPrice);
}
else
{
this.database.AddInParameter(storedProcCommand, "BundlingID ", DbType.Int32, DBNull.Value);
this.database.AddInParameter(storedProcCommand, "BundlingPrice", DbType.Currency, DBNull.Value);
}
this.database.AddInParameter(storedProcCommand, "Tax", DbType.Currency, orderInfo.Tax);
this.database.AddInParameter(storedProcCommand, "InvoiceTitle", DbType.String, orderInfo.InvoiceTitle);
this.database.AddInParameter(storedProcCommand, "ReferralUserId", DbType.Int32, orderInfo.ReferralUserId);
return (this.database.ExecuteNonQuery(storedProcCommand, dbTran) == 1);
}示例2: UpdateOrder
public bool UpdateOrder(OrderInfo order, DbTransaction dbTran = null)
{
DbCommand sqlStringCommand = this.database.GetSqlStringCommand("UPDATE Hishop_Orders SET OrderStatus = @OrderStatus, [email protected], PayDate = @PayDate, [email protected], FinishDate = @FinishDate, RegionId = @RegionId, ShippingRegion = @ShippingRegion, Address = @Address, ZipCode = @ZipCode,ShipTo = @ShipTo, TelPhone = @TelPhone, CellPhone = @CellPhone, [email protected] ,[email protected], RealShippingModeId = @RealShippingModeId, RealModeName = @RealModeName, ShipOrderNumber = @ShipOrderNumber, ExpressCompanyName = @ExpressCompanyName,ExpressCompanyAbb = @ExpressCompanyAbb, [email protected],[email protected], Gateway = @Gateway, [email protected],[email protected],[email protected], OrderTotal = @OrderTotal, [email protected],[email protected],[email protected], AdjustedFreight = @AdjustedFreight, PayCharge = @PayCharge, [email protected],[email protected],[email protected] WHERE OrderId = @OrderId");
this.database.AddInParameter(sqlStringCommand, "OrderStatus", DbType.Int32, (int) order.OrderStatus);
this.database.AddInParameter(sqlStringCommand, "CloseReason", DbType.String, order.CloseReason);
this.database.AddInParameter(sqlStringCommand, "PayDate", DbType.DateTime, order.PayDate);
this.database.AddInParameter(sqlStringCommand, "ShippingDate", DbType.DateTime, order.ShippingDate);
this.database.AddInParameter(sqlStringCommand, "FinishDate", DbType.DateTime, order.FinishDate);
this.database.AddInParameter(sqlStringCommand, "RegionId", DbType.String, order.RegionId);
this.database.AddInParameter(sqlStringCommand, "ShippingRegion", DbType.String, order.ShippingRegion);
this.database.AddInParameter(sqlStringCommand, "Address", DbType.String, order.Address);
this.database.AddInParameter(sqlStringCommand, "ZipCode", DbType.String, order.ZipCode);
this.database.AddInParameter(sqlStringCommand, "ShipTo", DbType.String, order.ShipTo);
this.database.AddInParameter(sqlStringCommand, "TelPhone", DbType.String, order.TelPhone);
this.database.AddInParameter(sqlStringCommand, "CellPhone", DbType.String, order.CellPhone);
this.database.AddInParameter(sqlStringCommand, "ShippingModeId", DbType.Int32, order.ShippingModeId);
this.database.AddInParameter(sqlStringCommand, "ModeName", DbType.String, order.ModeName);
this.database.AddInParameter(sqlStringCommand, "RealShippingModeId", DbType.Int32, order.RealShippingModeId);
this.database.AddInParameter(sqlStringCommand, "RealModeName", DbType.String, order.RealModeName);
this.database.AddInParameter(sqlStringCommand, "ShipOrderNumber", DbType.String, order.ShipOrderNumber);
this.database.AddInParameter(sqlStringCommand, "ExpressCompanyName", DbType.String, order.ExpressCompanyName);
this.database.AddInParameter(sqlStringCommand, "ExpressCompanyAbb", DbType.String, order.ExpressCompanyAbb);
this.database.AddInParameter(sqlStringCommand, "PaymentTypeId", DbType.Int32, order.PaymentTypeId);
this.database.AddInParameter(sqlStringCommand, "PaymentType", DbType.String, order.PaymentType);
this.database.AddInParameter(sqlStringCommand, "Gateway", DbType.String, order.Gateway);
this.database.AddInParameter(sqlStringCommand, "ManagerMark", DbType.Int32, order.ManagerMark);
this.database.AddInParameter(sqlStringCommand, "ManagerRemark", DbType.String, order.ManagerRemark);
this.database.AddInParameter(sqlStringCommand, "IsPrinted", DbType.Boolean, order.IsPrinted);
this.database.AddInParameter(sqlStringCommand, "OrderTotal", DbType.Currency, order.GetTotal());
this.database.AddInParameter(sqlStringCommand, "OrderProfit", DbType.Currency, order.GetProfit());
this.database.AddInParameter(sqlStringCommand, "Amount", DbType.Currency, order.GetAmount());
this.database.AddInParameter(sqlStringCommand, "OrderCostPrice", DbType.Currency, order.GetCostPrice());
this.database.AddInParameter(sqlStringCommand, "AdjustedFreight", DbType.Currency, order.AdjustedFreight);
this.database.AddInParameter(sqlStringCommand, "PayCharge", DbType.Currency, order.PayCharge);
this.database.AddInParameter(sqlStringCommand, "AdjustedDiscount", DbType.Currency, order.AdjustedDiscount);
this.database.AddInParameter(sqlStringCommand, "OrderPoint", DbType.Int32, order.Points);
this.database.AddInParameter(sqlStringCommand, "GatewayOrderId", DbType.String, order.GatewayOrderId);
this.database.AddInParameter(sqlStringCommand, "OrderId", DbType.String, order.OrderId);
if (dbTran != null)
{
return (this.database.ExecuteNonQuery(sqlStringCommand, dbTran) > 0);
}
return (this.database.ExecuteNonQuery(sqlStringCommand) > 0);
}