private const string PARM_EMAIL = "@BuyerEmail"; //买家邮箱 public tbBuyerInfo Select(string OrdersNumber) { tbBuyerInfo Buyer = null; IDbDataParameter[] parm = GetSelectNumberParam(); parm[0].Value = OrdersNumber; using (IDataReader MyReader = DBHelper.ExecuteReader(CommandType.StoredProcedure, SQL_SELECT, parm)) { if (MyReader.Read()) { Buyer = new tbBuyerInfo() { BuyerId = MyReader.GetInt32(0), OrdersNumber = MyReader.GetString(1), NickName = MyReader.GetString(2), BuyerName = MyReader.GetString(3), Mobile = MyReader.GetString(4), Phone = MyReader.GetString(5), BuyerEmail = MyReader.GetString(6) }; } } return(Buyer == null ? new tbBuyerInfo() : Buyer); }
public bool Insert(tbBuyerInfo Buyer) { bool IsOk = false; IDbDataParameter[] parm = GetInsertParam(); parm[0].Value = Buyer.OrdersNumber; parm[1].Value = Buyer.NickName; parm[2].Value = Buyer.BuyerName; parm[3].Value = Buyer.Mobile; parm[4].Value = Buyer.Phone; parm[5].Value = Buyer.BuyerEmail; try { DBHelper.ExecuteNonQuery(CommandType.StoredProcedure, SQL_INSERT, parm); IsOk = true; } catch { } return(IsOk); }
/// <summary> /// 添加买家信息 /// </summary> /// <param name="Buyer">买家信息</param> /// <returns></returns> public static bool Insert(tbBuyerInfo Buyer) { return(BuyerInfoDal.Insert(Buyer)); }
/// <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; } }