public bool Insert(tbOrdersDetail OrdersDetail)
{
bool IsOk = false;
IDbDataParameter[] parm = GetInsertParam();
parm[0].Value = OrdersDetail.OrdersNumber;
parm[1].Value = OrdersDetail.ProductId;
parm[2].Value = OrdersDetail.ProductProId;
parm[3].Value = OrdersDetail.SalesCommissionId;
parm[4].Value = OrdersDetail.ProductEncoding;
parm[5].Value = OrdersDetail.ProductImg;
parm[6].Value = OrdersDetail.ProductName;
parm[7].Value = OrdersDetail.ProductNumber;
parm[8].Value = OrdersDetail.ProductPrice;
parm[9].Value = OrdersDetail.ProductSku;
parm[10].Value = OrdersDetail.ProductTotal;
parm[11].Value = OrdersDetail.IsProductReFund;
parm[12].Value = OrdersDetail.IsCanceled;
parm[13].Value = OrdersDetail.ReFundStatusId;
parm[14].Value = OrdersDetail.ReFundStatusName;
parm[15].Value = OrdersDetail.ReFundNumber;
parm[16].Value = OrdersDetail.PackageName;
parm[17].Value = OrdersDetail.Details;
parm[18].Value = OrdersDetail.InputDate;
parm[19].Value = OrdersDetail.SubOrderNumber;
parm[20].Value = OrdersDetail.OutNumberIId;
parm[21].Value = OrdersDetail.ProductCost;
parm[22].Value = OrdersDetail.OrdersDiscount;
parm[23].Value = OrdersDetail.OrdersAdjust;
parm[24].Value = OrdersDetail.OrdersAccounts;
try
{
DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, SQL_INSERT, parm);
IsOk = true;
}
catch { }
return(IsOk);
}
/// <summary>
/// 添加订单详情信息
/// </summary>
/// <param name="OrdersDetail">订单详情表</param>
/// <returns></returns>
public static bool Insert(tbOrdersDetail OrdersDetail)
{
return(OrdersDetailDal.Insert(OrdersDetail));
}
/// <summary>
/// 将淘宝的交易信息转化为本地类型
/// </summary>
/// <param name="trade"></param>
/// <returns></returns>
private tbOrdersInfo ChangeLocationType(Top.Api.Domain.Trade trade, int ShopId)
{
try
{
tbOrdersInfo newtrade = new tbOrdersInfo();
tbConsigneeInfo Consignee = new tbConsigneeInfo();
tbBuyerInfo Buyer = new tbBuyerInfo();
List <tbOrdersDetail> Details = new List <tbOrdersDetail>();
if (!String.IsNullOrEmpty(trade.PayTime))
{
newtrade.PayDate = Convert.ToDateTime(Comm.DataChange(trade.PayTime, TypeChange.DATETIME));//付款时间
}
else
{
newtrade.PayDate = DateTime.Now;
}
newtrade.CustomerServiceId = 1;
newtrade.CashOndelivery = false;
newtrade.Invoice = false;
newtrade.NickName = trade.BuyerNick.Trim(); //会员名
Buyer.NickName = trade.BuyerNick.Trim(); //会员名
newtrade.Commission = Convert.ToDecimal(Comm.DataChange(trade.CommissionFee, TypeChange.DECIMAL));
newtrade.OrdersOutNumber = trade.Tid.ToString().Trim(); //淘宝订单号
newtrade.Logistics = new Logistic();
newtrade.LogisticsStr = trade.ShippingType;//暂存物流
newtrade.OrdersFreight = Convert.ToInt32(Comm.DataChange(trade.PostFee, TypeChange.DECIMAL));
newtrade.OrdersProductTotal = Convert.ToDecimal(Comm.DataChange(trade.TotalFee, TypeChange.DECIMAL)); //商品总金额
newtrade.OrdersDate = Convert.ToDateTime(Comm.DataChange(trade.Created, TypeChange.DATETIME)); //交易创建时间
Consignee.Name = Comm.DataChange(trade.ReceiverName, TypeChange.STRING).ToString(); //收件人姓名
Buyer.BuyerName = Consignee.Name;
Consignee.OrdersNumber = trade.Tid == null ? "" : trade.Tid.ToString();
Consignee.Provice = Comm.DataChange(trade.ReceiverState, TypeChange.STRING).ToString(); //收件人所在省
Consignee.City = Comm.DataChange(trade.ReceiverCity, TypeChange.STRING).ToString(); //收件人所在市
Consignee.District = Comm.DataChange(trade.ReceiverDistrict, TypeChange.STRING).ToString(); //收件人所在区
Consignee.ConsigneeAddress = Comm.DataChange(trade.ReceiverAddress, TypeChange.STRING).ToString(); //收件人地址
Consignee.PostCode = Comm.DataChange(trade.ReceiverZip, TypeChange.STRING).ToString(); //收件人邮编
Consignee.Mobile = Comm.DataChange(trade.ReceiverMobile, TypeChange.STRING).ToString(); //收件人手机
Buyer.Mobile = Consignee.Mobile;
Consignee.Phone = Comm.DataChange(trade.ReceiverPhone, TypeChange.STRING).ToString(); //收件人电话
Buyer.Phone = Consignee.Phone;
newtrade.Status = new tbOrdersStatus()
{
OrdersStatusId = 3
}; //订单状态(默认买家已付款，等待卖家发货状态)
decimal Payment = Convert.ToDecimal(Comm.DataChange(trade.Payment, TypeChange.DECIMAL)); //订单实收金额
newtrade.OrdersAccounts = Payment;
newtrade.OrdersPaid = Payment;
newtrade.IsOrdersReFund = false; //是否有退款
newtrade.OrdersDiscount = newtrade.OrdersPaid - newtrade.OrdersProductTotal - newtrade.OrdersFreight; //订单折扣
newtrade.OrdersWeight = 0;
newtrade.OrdersNotes = "";
newtrade.OrdersFlag = "0";
newtrade.OrdersInputDate = DateTime.Now;
Consignee.InputDate = newtrade.OrdersInputDate;
//买家留言&卖家备注&备注旗帜&邮件地址
newtrade.ServiceNotes = trade.SellerMemo; //客服备注
newtrade.ServiceFlag = trade.SellerFlag.ToString(); //客服备注旗帜样式
newtrade.BuyerMsg = string.IsNullOrEmpty(trade.BuyerMessage) ? "" : trade.BuyerMessage; //买家留言
Buyer.BuyerEmail = trade.BuyerEmail;
newtrade.CodFee = Convert.ToDecimal(Comm.DataChange(trade.CodFee, TypeChange.DECIMAL)); //货到付款服务费
newtrade.BuyerRemark = "";
newtrade.DeliveryDate = "";
newtrade.RemarkFlag = "";
newtrade.Shop = new tbShopInfo()
{
ShopId = ShopId
};
if (trade.Orders != null)
{
foreach (Top.Api.Domain.Order order in trade.Orders)
{
if (Convert.ToInt32(order.Num) <= 0)
{
continue;
}
tbOrdersDetail Detail = new tbOrdersDetail();
Detail.OrdersNumber = trade.Tid.ToString();
Detail.ProductEncoding = !String.IsNullOrEmpty(order.OuterSkuId) ? order.OuterSkuId.Trim() : "";
Detail.ProductName = !String.IsNullOrEmpty(order.Title) ? order.Title.Trim() : "";
Detail.ProductSku = !String.IsNullOrEmpty(order.SkuPropertiesName) ? order.SkuPropertiesName.Trim() : "";
Detail.ProductId = Convert.ToInt32(order.NumIid);
Detail.ProductProId = 0;
Detail.SalesCommissionId = 1;
Detail.ProductImg = String.IsNullOrEmpty(order.PicPath) ? "" : order.PicPath.Trim(); //商品图片
Detail.ProductPrice = Convert.ToDecimal(Comm.DataChange(order.Price, TypeChange.DECIMAL)); //商品价格
Detail.ProductNumber = (int)order.Num; //商品数量
Detail.PackageName = String.IsNullOrEmpty(order.ItemMealName) ? "" : order.ItemMealName; //商品套餐值
Detail.OutNumberIId = order.NumIid == null ? "" : order.NumIid.ToString(); //商品外部编号
Detail.SubOrderNumber = order.Oid.ToString() == null ? "" : order.Oid.ToString(); //子订单编号
Detail.InputDate = newtrade.OrdersInputDate;
Detail.ProductTotal = Convert.ToDecimal(Comm.DataChange(order.TotalFee, TypeChange.DECIMAL)); //商品总价
Detail.Details = "";
Detail.ProductCost = 0;
Detail.OrdersDiscount = Convert.ToDecimal(Comm.DataChange(order.DiscountFee, TypeChange.DECIMAL)); //优惠金额;
Detail.OrdersAdjust = Convert.ToDecimal(Comm.DataChange(order.AdjustFee, TypeChange.DECIMAL)); //手动调整金额;
Detail.OrdersAccounts = Detail.ProductTotal;
//订单被取消
if (order.Status == "TRADE_CLOSED_BY_TAOBAO")
{
Detail.IsCanceled = true;
}
//商品退款
if (order.RefundId == 0)
{
Detail.ReFundNumber = "";
Detail.IsProductReFund = false;
Detail.ReFundStatusId = 0;
Detail.ReFundStatusName = order.RefundStatus;
}
else
{
Detail.ReFundNumber = order.RefundId.ToString();
Detail.IsProductReFund = true;
newtrade.IsOrdersReFund = true;
Detail.ReFundStatusId = 0;
Detail.ReFundStatusName = "";
}
Details.Add(Detail);
}
}
newtrade.Consignee = Consignee;
newtrade.Details = Details;
newtrade.Buyer = Buyer;
return(newtrade);
}
catch (Exception ex)
{
throw;
}
}
