/// <summary>
/// 更新配送方式
/// </summary>
/// <param name="model">配送方式实体，根据SysNo</param>
/// <returns>受影响的行数</returns>
/// <remarks>
/// 2013-06-13 郑荣华 创建
/// </remarks>
public override int Update(LgDeliveryType model)
{
return(Context.Update("LgDeliveryType", model)
.AutoMap(x => x.SysNo, x => x.CreatedBy, x => x.CreatedDate)
.Where(x => x.SysNo)
.Execute());
}
/// <summary>
/// 获取运单号
/// </summary>
/// <param name="orderId"></param>
/// <returns></returns>
/// <remarks>2016-07-19 陈海裕 创建</remarks>
public override Result GetOrderExpressno(string orderId)
{
Result <string> result = new Result <string>();
result.Status = false;
result.StatusCode = 0;
result.Message = "接口调用失败";
string url = RequestUrl + "express/create";
try
{
SoOrder order = BLL.Order.SoOrderBo.Instance.GetEntity(TConvert.ToInt32(orderId));
if (order == null)
{
result.Message = "该订单不存在";
return(result);
}
LgDeliveryType deliveryType = BLL.Logistics.DeliveryTypeBo.Instance.GetDeliveryType(order.DeliveryTypeSysNo);
ParaOnlinePaymentFilter filter = new ParaOnlinePaymentFilter();
filter.OrderSysNo = TConvert.ToInt32(orderId);
var onlinePayment = BLL.Finance.FinanceBo.Instance.GetOnlinePayments(filter).Rows.Where(o => o.Status == 1).FirstOrDefault();
CBWhWarehouse warehouse = BLL.Warehouse.WhWarehouseBo.Instance.GetWarehouse(order.DefaultWarehouseSysNo);
string _deliveryType = "";
if (deliveryType.DeliveryTypeName.Contains("顺丰"))
{
_deliveryType = "SF";
//CustomerCode = SFCustomerCode;
//Key = SFKey;
Token = SFToken;
}
else if (deliveryType.DeliveryTypeName.Contains("中通"))
{
_deliveryType = "ZTO";
}
if (_deliveryType == "")
{
result.Message = "友信达物流目前只有支持顺丰和中通两种快递方式";
return(result);
}
Dictionary <string, string> paramsData = new Dictionary <string, string>();
paramsData.Add("reference_no", onlinePayment.BusinessOrderSysNo);
paramsData.Add("warehouse_id", warehouse.LogisWarehouseCode);
paramsData.Add("sm_code", _deliveryType);
string responseStr = GetResponse(url, InitParams(paramsData));
result = GetResult(JObject.Parse(responseStr), result);
if (result.Status == true)
{
// 生成出库单
}
return(result);
}
catch (Exception ex)
{
result.Message = "查询订单运单号报错：" + ex.StackTrace;
return(result);
}
}
/// <summary>
/// 创建配送方式
/// </summary>
/// <param name="model">配送方式实体</param>
/// <returns>创建的配送方式sysNo</returns>
/// <remarks>
/// 2013-06-13 郑荣华 创建
/// </remarks>
public int Create(LgDeliveryType model)
{
if (IsExistDeliveryType(model.DeliveryTypeName))
{
return(0);
}
var r = ILgDeliveryTypeDao.Instance.Create(model);
Log.SysLog.Instance.Info(LogStatus.系统日志来源.后台, "创建配送方式", LogStatus.系统日志目标类型.配送方式, r);
return(r);
}
/// <summary>
/// 更新配送方式
/// </summary>
/// <param name="model">配送方式实体，根据sysno</param>
/// <returns>受影响的行数</returns>
/// <remarks>
/// 2013-06-13 郑荣华 创建
/// 2014-5-13 杨文兵 增加删除配送方式缓存代码
/// </remarks>
public bool Update(LgDeliveryType model)
{
var r = ILgDeliveryTypeDao.Instance.Update(model) > 0;
if (r)
{
Log.SysLog.Instance.Info(LogStatus.系统日志来源.后台, "修改配送方式", LogStatus.系统日志目标类型.配送方式, model.SysNo);
var chackeKey = string.Format("CACHE_DELIVERYTYPE_{0}", model.SysNo);
MemoryProvider.Default.Remove(chackeKey);
}
return(r);
}
private void AddBaseTaskObjectToList(List <BaseTask> listObject)
{
BaseTask bsAT = new BsArea();
BaseTask bsDP = new BsDeliveryPayment();
BaseTask bsPT = new BsPaymentType();
BaseTask bsCode = new BsCode();
BaseTask bsOrganization = new BsOrganization();
BaseTask bsOrganizationWarehouse = new BsOrganizationWarehouse();
BaseTask crCustomer = new CrCustomer();
BaseTask crCL = new CrCustomerLevel();
BaseTask crCQ = new CrCustomerQuestion();
BaseTask crRA = new CrReceiveAddress();
BaseTask dsMallType = new DsMallType();
BaseTask dsDealerLevel = new DsDealerLevel();
BaseTask feArticle = new FeArticle();
BaseTask feAC = new FeArticleCategory();
BaseTask feCS = new FeCommentSupport();
BaseTask fepc = new FeProductComment();
BaseTask fePCI = new FeProductCommentImage();
BaseTask fePCR = new FeProductCommentReply();
BaseTask feSearchKeyword = new FeSearchKeyword();
BaseTask feadvertgroup = new FeAdvertGroup();
BaseTask feadvertitem = new FeAdvertItem();
BaseTask feproductgroup = new FeProductGroup();
BaseTask feproductitem = new FeProductItem();
BaseTask fnIT = new FnInvoiceType();
BaseTask fninvoice = new FnInvoice();
BaseTask fnpv = new FnReceiptVoucher();
BaseTask fnReceiptVoucherItem = new FnReceiptVoucherItem();
BaseTask fnop = new FnOnlinePayment();
BaseTask fnPaymentVoucher = new FnPaymentVoucher();
BaseTask fnPaymentVoucherItem = new FnPaymentVoucherItem();
BaseTask lgDelivery = new LgDelivery();
BaseTask lgDI = new LgDeliveryItem();
BaseTask lgDS = new LgDeliveryScope();
BaseTask lgDT = new LgDeliveryType();
BaseTask lgDUC = new LgDeliveryUserCredit();
BaseTask lgPT = new LgPickupType();
BaseTask lgsettlement = new LgSettlement();
BaseTask lgSI = new LgSettlementItem();
BaseTask lgDeliveryPrintTemplate = new LgDeliveryPrintTemplate();
BaseTask pdAttribute = new PdAttribute();
BaseTask pdAG = new PdAttributeGroup();
BaseTask pdAGA = new PdAttributeGroupAssociation();
BaseTask pdAO = new PdAttributeOption();
BaseTask pdBrand = new PdBrand();
BaseTask pdCGA = new PdCatAttributeGroupAso();
BaseTask pdCategory = new PdCategory();
BaseTask pdCA = new PdCategoryAssociation();
BaseTask pdPrice = new PdPrice();
BaseTask pdProduct = new PdProduct();
BaseTask pdPA = new PdProductAssociation();
BaseTask pdProductAttribute = new PdProductAttribute();
BaseTask pdPI = new PdProductImage();
BaseTask pdTemplate = new PdTemplate();
BaseTask pdProductStatistics = new PdProductStatistics();
BaseTask soOrder = new SoOrder();
BaseTask soOrderItem = new SoOrderItem();
BaseTask soRA = new SoReceiveAddress();
BaseTask SyUG = new SyUserGroup();
BaseTask syGU = new SyGroupUser();
BaseTask syMenu = new SyMenu();
BaseTask syMenuPrivilege = new SyMenuPrivilege();
BaseTask syPrivilege = new SyPrivilege();
BaseTask syRole = new SyRole();
BaseTask syRoleMenu = new SyRoleMenu();
BaseTask syRolePrivilege = new SyRolePrivilege();
BaseTask syPermission = new SyPermission();
BaseTask syUser = new SyUser();
BaseTask syUW = new SyUserWarehouse();
BaseTask syMyMenu = new SyMyMenu();
BaseTask spcombo = new SpCombo();
BaseTask spComboItem = new SpComboItem();
BaseTask spcopon = new spcoupon();
BaseTask sqpromotion = new SPpromotion();
BaseTask spromotiongift = new SPpromotiongift();
BaseTask sppromotionoverlay = new SPpromotionoverlay();
BaseTask sppromotionrule = new SPpromotionrule();
BaseTask sppromotionrulecondition = new SPpromotionrulecondition();
BaseTask sppromotionrulekeyvalue = new SPpromotionrulekeyvalue();
BaseTask syTaskConfig = new SyTaskConfig();
BaseTask whStockOut = new WhStockOut();
BaseTask whStockOutItem = new WhstockOutItem();
BaseTask whwarehouse = new WhWarehouse();
BaseTask whwa = new WHwarehousearea();
BaseTask whwdy = new WHwarehouseDeliveryType();
BaseTask whWPT = new WhWarehousePickupType();
BaseTask whstockin = new WhStockIn();
BaseTask whstockinItem = new WHStockinItem();
BaseTask rcReturn = new RCReturn();
BaseTask rcReturnItem = new RcReturnItem();
listObject.Add(bsAT);
listObject.Add(bsDP);
listObject.Add(bsPT);
listObject.Add(bsCode);
listObject.Add(bsOrganization);
listObject.Add(bsOrganizationWarehouse);
listObject.Add(crCustomer);
listObject.Add(crCL);
listObject.Add(crCQ);
listObject.Add(crRA);
listObject.Add(dsMallType);
listObject.Add(dsDealerLevel);
listObject.Add(feArticle);
listObject.Add(feAC);
listObject.Add(feCS);
listObject.Add(fePCI);
listObject.Add(fePCR);
listObject.Add(fepc);
listObject.Add(feSearchKeyword);
listObject.Add(feadvertgroup);
listObject.Add(feadvertitem);
listObject.Add(feproductgroup);
listObject.Add(feproductitem);
listObject.Add(fnIT);
listObject.Add(fnpv);
listObject.Add(fnReceiptVoucherItem);
listObject.Add(fnop);
listObject.Add(fninvoice);
listObject.Add(fnPaymentVoucher);
listObject.Add(fnPaymentVoucherItem);
listObject.Add(lgDelivery);
listObject.Add(lgDI);
listObject.Add(lgDS);
listObject.Add(lgDT);
listObject.Add(lgPT);
listObject.Add(lgsettlement);
listObject.Add(lgSI);
listObject.Add(lgDeliveryPrintTemplate);
listObject.Add(pdAttribute);
listObject.Add(pdAG);
listObject.Add(pdAGA);
listObject.Add(pdAO);
listObject.Add(pdBrand);
listObject.Add(pdCGA);
listObject.Add(pdCategory);
listObject.Add(pdCA);
listObject.Add(pdPrice);
listObject.Add(pdProduct);
listObject.Add(pdPA);
listObject.Add(pdProductAttribute);
listObject.Add(pdTemplate);
listObject.Add(pdProductStatistics);
listObject.Add(soOrder);
listObject.Add(soOrderItem);
listObject.Add(spcombo);
listObject.Add(spComboItem);
listObject.Add(spcopon);
listObject.Add(sqpromotion);
listObject.Add(spromotiongift);
//listObject.Add(sppromotionoverlay);
listObject.Add(sppromotionrule);
listObject.Add(sppromotionrulecondition);
listObject.Add(sppromotionrulekeyvalue);
listObject.Add(syGU);
listObject.Add(syUW);
listObject.Add(SyUG);
listObject.Add(syMenu);
listObject.Add(syUser);
listObject.Add(syPermission);
listObject.Add(syMenuPrivilege);
listObject.Add(syPrivilege);
listObject.Add(syRole);
listObject.Add(syRoleMenu);
listObject.Add(syRolePrivilege);
listObject.Add(syMyMenu);
listObject.Add(syTaskConfig);
listObject.Add(whStockOut);
listObject.Add(whStockOutItem);
listObject.Add(whwarehouse);
listObject.Add(whwa);
listObject.Add(whwdy);
listObject.Add(whWPT);
listObject.Add(whstockin);
listObject.Add(whstockinItem);
listObject.Add(rcReturn);
listObject.Add(rcReturnItem);
listObject.Add(lgDUC);
listObject.Add(pdPI);
listObject.Add(soRA);
}
public override Model.Result AddOrderTrade(int orderSysno)
{
Result result = new Result();
try
{
var order = BLL.Order.SoOrderBo.Instance.GetEntity(orderSysno);
var config = Hyt.BLL.Config.Config.Instance.GetAnnaConfig();
CrCustomer customer = Hyt.BLL.CRM.CrCustomerBo.Instance.GetModel(order.CustomerSysNo);
WhWarehouse warehouseMod = Hyt.BLL.Warehouse.WhWarehouseBo.Instance.GetWarehouse(order.DefaultWarehouseSysNo);
BsArea wareDistrictEntity = Hyt.BLL.Basic.BasicAreaBo.Instance.GetArea(warehouseMod.AreaSysNo);
BsArea wareCityEntity = Hyt.BLL.Basic.BasicAreaBo.Instance.GetArea(wareDistrictEntity.ParentSysNo);
BsArea wareProvinceEntity = Hyt.BLL.Basic.BasicAreaBo.Instance.GetArea(wareDistrictEntity.ParentSysNo);
SoReceiveAddress srenity = Hyt.BLL.Order.OutboundReturnBo.Instance.GetSoReceiveAddressBysoOrderSysNo(order.SysNo);
string buyer_idcard = "";
if (!string.IsNullOrEmpty(srenity.IDCardNo))
{
buyer_idcard = srenity.IDCardNo.Trim().ToUpper();
}
BsArea DistrictEntity = Hyt.BLL.Basic.BasicAreaBo.Instance.GetArea(srenity.AreaSysNo);
string District = DistrictEntity.AreaName.Trim();
BsArea CityEntity = Hyt.BLL.Basic.BasicAreaBo.Instance.GetArea(DistrictEntity.ParentSysNo);
string City = CityEntity.AreaName.Trim();
BsArea ProvinceEntity = Hyt.BLL.Basic.BasicAreaBo.Instance.GetArea(CityEntity.ParentSysNo);
string Province = ProvinceEntity.AreaName.Trim();
CBFnOnlinePayment payment = FinanceBo.Instance.GetOnPaymentBySourceSysNo(order.SysNo);
payment.CusPaymentCode = config.PaymentCode;
IList <CBSoOrderItem> datao = SoOrderBo.Instance.GetCBOrderItemsByOrderId(order.SysNo);
LgDeliveryType deliveryType = Hyt.BLL.Logistics.DeliveryTypeBo.Instance.GetDeliveryType(order.DeliveryTypeSysNo);
order.OrderItemList = new List <SoOrderItem>();
List <int> ProSysNo = new List <int>();
foreach (CBSoOrderItem item in datao)
{
ProSysNo.Add(item.ProductSysNo);
order.OrderItemList.Add(item);
}
IList <CBPdProduct> productList = Hyt.BLL.Product.PdProductBo.Instance.GetProductInfoList(ProSysNo);
foreach (var mod in productList)
{
var tempitem = datao.First(p => p.ProductSysNo == mod.SysNo);
if (tempitem != null)
{
tempitem.OrginCountry = Hyt.BLL.Basic.OriginBo.Instance.GetEntity(mod.OriginSysNo).Origin_Name;
}
}
Order pushOrder = new Order();
pushOrder.OrderHead = new OrderHead();
pushOrder.OrderPaymentLogistics = new OrderPaymentLogistics();
pushOrder.itemList = new List <OrderList>();
BindOrderHeadData(order, pushOrder.OrderHead, payment, srenity, buyer_idcard, District, City, Province,
warehouseMod, wareDistrictEntity, wareCityEntity, wareProvinceEntity);
BindOrderItemListData(datao, pushOrder.itemList);
OrderPaymentLogistic(pushOrder.OrderPaymentLogistics, payment, deliveryType);
string str = Hyt.Util.Serialization.SerializationUtil.XmlSerialize <Order>(pushOrder);
str = str.Replace("encoding=\"utf-16\"", "encoding=\"utf-8\"");
str = str.Replace("Root", "ROOT");
str = str.Replace("<itemList>", "");
str = str.Replace("</itemList>", "");
FtpUtil ftp = new FtpUtil(config2.RequestUrl, config2.Account, config2.Password);
string msg = "";
string fileName = DateTime.Now.ToString("yyyyMMddhhmmssffff") + ".xml";
try
{
ftp.UploadFile(config2.RequestUrl, fileName, Encoding.UTF8.GetBytes(str), out msg);
}
catch (Exception ex)
{
result.Status = false;
result.Message = ex.Message;
}
result.Message = str;
}
catch (Exception e)
{
result.Status = false;
result.Message = e.Message;
}
return(result);
}
public void OrderPaymentLogistic(OrderPaymentLogistics logistic, CBFnOnlinePayment payment, LgDeliveryType deliveryType)
{
logistic.logisticsName = deliveryType.DeliveryTypeName;
logistic.paymentName = payment.PaymentName;
logistic.paymentNo = payment.VoucherNo;
logistic.paymentType = "A";
}
/// <summary>
/// 添加交易订单
/// </summary>
/// <param name="orderId">销售订单系统编号</param>
/// <returns></returns>
/// <remarks>
/// 2016-3-21 杨浩 创建
/// 2016-4-19 陈海裕 重构
/// </remarks>
public override Result AddOrderTrade(int orderId)
{
var result = new Result()
{
Status = false,
StatusCode = 0,
Message = "向" + this.Code + "物流推送订单失败"
};
try
{
var order = Hyt.BLL.Order.SoOrderBo.Instance.GetEntity(orderId);
if (order == null)
{
result.Status = false;
result.Message = string.Format("订单号{0}不存在！", orderId);
result.StatusCode = -100;
}
#region 旧参数
//var receiveAddress = BLL.Order.SoOrderBo.Instance.GetOrderReceiveAddress(order.ReceiveAddressSysNo);
//if (receiveAddress == null)
//{
// result.Status = false;
// result.Message = string.Format("订单中的收货地址编号{0}不存在！", order.ReceiveAddressSysNo);
// result.StatusCode = -101;
//}
//var area = BLL.Basic.BasicAreaBo.Instance.GetArea(receiveAddress.AreaSysNo);
//if (area == null)
//{
// result.Status = false;
// result.Message = string.Format("地区({0})不存在！", receiveAddress.AreaSysNo);
// result.StatusCode = -103;
//}
//var city = BLL.Basic.BasicAreaBo.Instance.GetArea(area.ParentSysNo);
//if (city == null)
//{
// result.Status = false;
// result.Message = string.Format("城市({0})不存在！", area.ParentSysNo);
// result.StatusCode = -104;
//}
//var province = BLL.Basic.BasicAreaBo.Instance.GetArea(city.ParentSysNo);
//if (province == null)
//{
// result.Status = false;
// result.Message = string.Format("省份({0})不存在！", city.ParentSysNo);
// result.StatusCode = -105;
//}
//if (!result.Status)
// return result;
//var param = "{\"orderId\":\"" + order.OrderNo + "\",";
//param += "\"addr\":\"" + receiveAddress.StreetAddress + "\",";
//param += "\"phone\":\"" + receiveAddress.MobilePhoneNumber + "\",";
//param += "\"freight\":" + order.FreightAmount + ",";//运费
//param += "\"orderDate\":\"" + order.CreateDate.ToString("yyyy-MM-dd") + "\",";
//param += "\"province\":\"" + JsonStrEscape(province.AreaName) + "\",";
//param += "\"city\":\"" + JsonStrEscape(city.AreaName) + "\",";
//param += "\"area\":\"" + JsonStrEscape(area.AreaName) + "\",";
//param += "\"total\":" + order.ProductAmount + ",";//订单总金额
//param += "\"insuredFee\":0,"; //保价费用
//param += "\"cardType\":\"0\","; //证件类型 (默认身份证则填0)
//param += "\"expressCode\":\"SF\","; //物流公司编码
//param += "\"busiMode\":\"BBC\","; //所属业务模式 (BBC/备货BC/直邮BC/个人物品)
//param += "\"whCode\":\"FLC\","; //发货仓库代号
//param += "\"portCode\":\"5141\","; //口岸编码
//param += "\"platformCode\":\"IE150604146855\",";//海关企业备案号
//param += "\"cardNo\":\"" + receiveAddress.IDCardNo + "\",";//顾客身份证
//param += "\"name\":\"" + JsonStrEscape(receiveAddress.Name) + "\",";
////param += "\"senderContact\":\"测试公司\",";
////param += "\"senderPhone\":\"13500000000\",";
////param += "\"tax\":\"" + orderInfo.TaxFee + "\",";
//param += "\"orderItemList\":{";
//param += "\"orderItems\":[";
//var orderItemList = Hyt.BLL.Web.SoOrderBo.Instance.GetOrderItemListByOrderSysNo(orderId);
//string orderItem = "";
//foreach (var item in orderItemList)
//{
// if (orderItem != "")
// orderItem += ",";
// orderItem += "{";
// //8712400110037
// //orderItem += "\"qty\":" + item.Quantity + ",\"price\":" + item.SalesUnitPrice + ",\"total\":" + item.SalesAmount + ",\"productId\":\""+item.ErpCode+"\",\"productName\":\"" + JsonStrEscape(item.ProductName) + "\"";
// orderItem += "\"qty\":" + item.Quantity + ",\"price\":" + item.SalesUnitPrice + ",\"total\":" + item.SalesAmount + ",\"productId\":\"8712400110136\",\"productName\":\"" + JsonStrEscape(item.ProductName) + "\"";
// orderItem += "}";
//}
//param += orderItem;
//param += "]}}";
#endregion
string method = "wtdex.trade.order.add";
order.ReceiveAddress = BLL.Order.SoOrderBo.Instance.GetOrderReceiveAddress(order.ReceiveAddressSysNo);
order.OrderItemList = DataAccess.Order.ISoOrderItemDao.Instance.GetOrderItemsByOrderSysNo(order.SysNo);
//ParaVoucherFilter voucherFilter = new ParaVoucherFilter();
//voucherFilter.SourceSysNo = order.SysNo;
//CBFnReceiptVoucher recVoucher = BLL.Finance.FinanceBo.Instance.GetReceiptVouchers(voucherFilter).Rows.FirstOrDefault();
//recVoucher.VoucherItems = BLL.Finance.FnReceiptVoucherBo.Instance.GetReceiptVoucherItem(recVoucher.SysNo);
var filter = new ParaOnlinePaymentFilter();
filter.OrderSysNo = orderId;
var onlinePayment = BLL.Finance.FinanceBo.Instance.GetOnlinePayments(filter).Rows.Where(o => o.Status == 1).FirstOrDefault();
if (onlinePayment == null)
{
result.Message = "订单不存在在线支付记录";
return(result);
}
// 收货人 区 市 省
BsArea receiverDistrict = BLL.Basic.BasicAreaBo.Instance.GetArea(order.ReceiveAddress.AreaSysNo);
BsArea receiverCity = BLL.Basic.BasicAreaBo.Instance.GetArea(receiverDistrict.ParentSysNo);
BsArea receiverProvince = BLL.Basic.BasicAreaBo.Instance.GetArea(receiverCity.ParentSysNo);
// 发货人 市
CBWhWarehouse warehouse = BLL.Warehouse.WhWarehouseBo.Instance.GetWarehouse(order.DefaultWarehouseSysNo);
BsArea shipperCity = BLL.Basic.BasicAreaBo.Instance.GetArea(warehouse.CitySysNo);
DsDealer dealer = BLL.Distribution.DsDealerBo.Instance.GetDsDealer(order.DealerSysNo);
LgDeliveryType deliveryType = BLL.Logistics.DeliveryTypeBo.Instance.GetDeliveryType(order.DeliveryTypeSysNo);
var newOrder = new WTDOrder();
newOrder.addr = TConvert.ToString(order.ReceiveAddress.StreetAddress).Trim();
newOrder.area = TConvert.ToString(receiverDistrict.AreaName).Trim();
newOrder.busiMode = "BC";
newOrder.cardNo = TConvert.ToString(order.ReceiveAddress.IDCardNo);
newOrder.cardType = "0";
newOrder.city = TConvert.ToString(receiverCity.AreaName).Trim();
newOrder.consumerAddr = TConvert.ToString(order.ReceiveAddress.StreetAddress).Trim();
newOrder.consumerArea = TConvert.ToString(receiverDistrict.AreaName).Trim();
newOrder.consumerCity = TConvert.ToString(receiverCity.AreaName).Trim();
newOrder.consumerName = TConvert.ToString(order.ReceiveAddress.Name);
newOrder.consumerPhone = !string.IsNullOrWhiteSpace(order.ReceiveAddress.MobilePhoneNumber) ? order.ReceiveAddress.MobilePhoneNumber : order.ReceiveAddress.PhoneNumber;
newOrder.consumerProvince = TConvert.ToString(receiverProvince.AreaName).Trim();
newOrder.destCity = null;
newOrder.expressCode = "YT";// "SF";
newOrder.expressNo = null;
newOrder.freight = (double)order.FreightAmount;
newOrder.ieFlag = null;
newOrder.insuredFee = 0d;
newOrder.invoice = null;
newOrder.invoiceHead = null;
newOrder.invoiceType = null;
newOrder.isgac = 1;
newOrder.isactpay = "0";
newOrder.isactlogistics = "1";
newOrder.mobile = null;
newOrder.name = TConvert.ToString(order.ReceiveAddress.Name);
newOrder.notes = TConvert.ToString(order.Remarks).Trim();
newOrder.orderDate = order.CreateDate.ToString("yyyy-MM-dd");
newOrder.orderId = onlinePayment.BusinessOrderSysNo;
newOrder.paymentCode = null;
newOrder.phone = !string.IsNullOrWhiteSpace(order.ReceiveAddress.MobilePhoneNumber) ? order.ReceiveAddress.MobilePhoneNumber : order.ReceiveAddress.PhoneNumber;
newOrder.pickMode = "0";//BC、PS情况下必填0:散货/包裹1:大货/备货,有货物在我们仓库
newOrder.platformCode = config.PlatformCode;
newOrder.portCode = config.PortCode;
newOrder.prodFlag = null;
newOrder.province = TConvert.ToString(receiverProvince.AreaName).Trim();
newOrder.seller = null;
newOrder.senderContact = TConvert.ToString(dealer.ErpName);
newOrder.senderPhone = !string.IsNullOrWhiteSpace(dealer.MobilePhoneNumber) ? dealer.MobilePhoneNumber : dealer.PhoneNumber;
newOrder.tax = (double)order.TaxFee;
newOrder.total = (double)order.ProductAmount;
//newOrder.total = 100d;
newOrder.whCode = TConvert.ToString(warehouse.LogisWarehouseCode);
newOrder.zipCode = null;
newOrder.orderItemList = new WTDOrderItemList();
newOrder.orderItemList.orderItems = new List <WTDOrderItem>();
WTDOrderItem orderItem = new WTDOrderItem();
foreach (var item in order.OrderItemList)
{
var product = BLL.Product.PdProductBo.Instance.GetProductNoCache(item.ProductSysNo);
orderItem.groupBarcode = null;
orderItem.isGroup = null;
orderItem.postTax = null;
orderItem.price = (double)item.SalesUnitPrice;
orderItem.productId = product.ErpCode;
orderItem.productName = TConvert.ToString(item.ProductName);
orderItem.qty = item.Quantity;
orderItem.total = (double)item.SalesAmount;
newOrder.orderItemList.orderItems.Add(orderItem);
//orderItem.groupBarcode = null;
//orderItem.isGroup = null;
//orderItem.postTax = null;
//orderItem.price = 50d;
//orderItem.productId = "8712400110136";
//orderItem.productName = TConvert.ToString(item.ProductName);
//orderItem.qty = 2;
//orderItem.total = 100d;
//newOrder.orderItemList.orderItems.Add(orderItem);
//break;
}
string postData = Util.Serialization.JsonUtil.ToJson2(newOrder);
postData = InitParams(method, postData);
var _result = Hyt.Util.WebUtil.PostForm(apiUrl, postData);
result = GetResponseResult(_result);
if (result.Status == true)
{
var soOrderSyncLogisticsLog = new SoOrderSyncLogisticsLog();
soOrderSyncLogisticsLog.OrderSysNo = orderId;
soOrderSyncLogisticsLog.Code = (int)this.Code;
soOrderSyncLogisticsLog.LastUpdateDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
soOrderSyncLogisticsLog.StatusCode = "";
soOrderSyncLogisticsLog.StatusMsg = "";
soOrderSyncLogisticsLog.Packets = postData;
soOrderSyncLogisticsLog.ReceiptContent = _result;
soOrderSyncLogisticsLog.LastUpdateBy = 0;
soOrderSyncLogisticsLog.LogisticsOrderId = "";
soOrderSyncLogisticsLog.CreateDate = DateTime.Now;
soOrderSyncLogisticsLog.CreatedBy = BLL.Authentication.AdminAuthenticationBo.Instance.Current.Base.SysNo;
SoOrderSyncLogisticsLogBo.Instance.Insert(soOrderSyncLogisticsLog);
BLL.Order.SoOrderBo.Instance.UpdateOrderApiStatus(1, 3, orderId);
}
}
catch (Exception ex)
{
result.Message = "向" + this.Code + "物流推送订单报错：" + ex.StackTrace;
return(result);
}
return(result);
}
/// <summary>
/// 添加三期基础任务对象
/// </summary>
/// <param name="listObject"></param>
private void AddBaseTaskObject3ToList(List <BaseTask> listObject)
{
BaseTask bsDP = new BsDeliveryPayment();
BaseTask bsPT = new BsPaymentType();
BaseTask bsCode = new BsCode();
BaseTask bsOrganization = new BsOrganization();
BaseTask bsOrganizationWarehouse = new BsOrganizationWarehouse();
BaseTask dsMallType = new DsMallType();
BaseTask dsDealerLevel = new DsDealerLevel();
BaseTask feSearchKeyword = new FeSearchKeyword();
BaseTask feadvertgroup = new FeAdvertGroup();
BaseTask feadvertitem = new FeAdvertItem();
BaseTask feproductgroup = new FeProductGroup();
BaseTask feproductitem = new FeProductItem();
BaseTask fnIT = new FnInvoiceType();
BaseTask lgDT = new LgDeliveryType();
BaseTask lgPT = new LgPickupType();
BaseTask lgDeliveryPrintTemplate = new LgDeliveryPrintTemplate();
BaseTask pdProductStatistics = new PdProductStatistics();
BaseTask SyUG = new SyUserGroup();
BaseTask syGU = new SyGroupUser();
BaseTask syMenu = new SyMenu();
BaseTask syMenuPrivilege = new SyMenuPrivilege();
BaseTask syPrivilege = new SyPrivilege();
BaseTask syRole = new SyRole();
BaseTask syRoleMenu = new SyRoleMenu();
BaseTask syRolePrivilege = new SyRolePrivilege();
BaseTask syPermission = new SyPermission();
BaseTask syMyMenu = new SyMyMenu();
BaseTask syTaskConfig = new SyTaskConfig();
BaseTask spcombo = new SpCombo();
BaseTask spComboItem = new SpComboItem();
BaseTask spcopon = new spcoupon();
BaseTask sqpromotion = new SPpromotion();
BaseTask spromotiongift = new SPpromotiongift();
BaseTask sppromotionoverlay = new SPpromotionoverlay();
BaseTask sppromotionrule = new SPpromotionrule();
BaseTask sppromotionrulecondition = new SPpromotionrulecondition();
BaseTask sppromotionrulekeyvalue = new SPpromotionrulekeyvalue();
BaseTask whwdy = new WHwarehouseDeliveryType();
BaseTask whWPT = new WhWarehousePickupType();
listObject.Add(bsDP);
listObject.Add(bsPT);
listObject.Add(bsCode);
listObject.Add(bsOrganization);
listObject.Add(bsOrganizationWarehouse);
listObject.Add(dsMallType);
listObject.Add(dsDealerLevel);
listObject.Add(feSearchKeyword);
listObject.Add(feadvertgroup);
listObject.Add(feadvertitem);
listObject.Add(feproductgroup);
listObject.Add(feproductitem);
listObject.Add(fnIT);
listObject.Add(lgDT);
listObject.Add(lgPT);
listObject.Add(lgDeliveryPrintTemplate);
listObject.Add(pdProductStatistics);
listObject.Add(spcombo);
listObject.Add(spComboItem);
listObject.Add(spcopon);
listObject.Add(sqpromotion);
listObject.Add(spromotiongift);
//listObject.Add(sppromotionoverlay);
listObject.Add(sppromotionrule);
listObject.Add(sppromotionrulecondition);
listObject.Add(sppromotionrulekeyvalue);
listObject.Add(syGU);
listObject.Add(SyUG);
listObject.Add(syMenu);
listObject.Add(syPermission);
listObject.Add(syMenuPrivilege);
listObject.Add(syPrivilege);
listObject.Add(syRole);
listObject.Add(syRoleMenu);
listObject.Add(syRolePrivilege);
listObject.Add(syMyMenu);
listObject.Add(syTaskConfig);
listObject.Add(whwdy);
listObject.Add(whWPT);
}
public override Result AddOrderTrade(int orderSysno)
{
Result result = new Result();
try
{
SoOrder order = BLL.Order.SoOrderBo.Instance.GetEntity(orderSysno);
if (order == null)
{
result.Message = "该订单不存在";
return(result);
}
order.ReceiveAddress = BLL.Order.SoOrderBo.Instance.GetOrderReceiveAddress(order.ReceiveAddressSysNo);
order.OrderItemList = DataAccess.Order.ISoOrderItemDao.Instance.GetOrderItemsByOrderSysNo(order.SysNo);
ParaVoucherFilter voucherFilter = new ParaVoucherFilter();
voucherFilter.SourceSysNo = order.SysNo;
CBFnReceiptVoucher recVoucher = BLL.Finance.FinanceBo.Instance.GetReceiptVouchers(voucherFilter).Rows.FirstOrDefault();
recVoucher.VoucherItems = BLL.Finance.FnReceiptVoucherBo.Instance.GetReceiptVoucherItem(recVoucher.SysNo);
// 收货人 区 市 省
BsArea receiverDistrict = BLL.Basic.BasicAreaBo.Instance.GetArea(order.ReceiveAddress.AreaSysNo);
BsArea receiverCity = BLL.Basic.BasicAreaBo.Instance.GetArea(receiverDistrict.ParentSysNo);
BsArea receiverProvince = BLL.Basic.BasicAreaBo.Instance.GetArea(receiverCity.ParentSysNo);
// 发货人 市
CBWhWarehouse warehouse = BLL.Warehouse.WhWarehouseBo.Instance.GetWarehouse(order.DefaultWarehouseSysNo);
BsArea shipperCity = BLL.Basic.BasicAreaBo.Instance.GetArea(warehouse.CitySysNo);
DsDealer dealer = BLL.Distribution.DsDealerBo.Instance.GetDsDealer(order.DealerSysNo);
LgDeliveryType deliveryType = BLL.Logistics.DeliveryTypeBo.Instance.GetDeliveryType(order.DeliveryTypeSysNo);
EasycrossOrder newOrder = new EasycrossOrder();
newOrder.OrderHead = new OrderHead();
newOrder.OrderList = new List <OrderList>();
newOrder.OrderPaymentLogistics = new OrderPaymentLogistics();
newOrder.OrderHead.accessType = "1";
newOrder.OrderHead.agentCode = "4404580006";
newOrder.OrderHead.agentName = "珠海易跨境电子商务服务有限公司";
newOrder.OrderHead.appStatus = "2";
newOrder.OrderHead.appTime = DateTime.Now.ToString("yyyyMMddHHmmss");
newOrder.OrderHead.appUid = "1105910159";
newOrder.OrderHead.appUname = "东方口岸";
newOrder.OrderHead.batchNumbers = "";
newOrder.OrderHead.cbeCode = "D00236";
newOrder.OrderHead.cbeName = "珠海爱勤电子科技有限公司";
newOrder.OrderHead.charge = order.OrderAmount.ToString();
newOrder.OrderHead.consignee = order.ReceiveAddress.Name;
newOrder.OrderHead.consigneeAddress = order.ReceiveAddress.StreetAddress;
newOrder.OrderHead.consigneeCountry = "";
newOrder.OrderHead.consigneeTelephone = !string.IsNullOrWhiteSpace(order.ReceiveAddress.MobilePhoneNumber)
? order.ReceiveAddress.MobilePhoneNumber : order.ReceiveAddress.PhoneNumber;
newOrder.OrderHead.currency = "142";
newOrder.OrderHead.customer = order.ReceiveAddress.Name;
newOrder.OrderHead.customerId = order.ReceiveAddress.IDCardNo;
newOrder.OrderHead.ecpCode = "W0098";
newOrder.OrderHead.ecpName = "珠海爱勤电子科技有限公司";
newOrder.OrderHead.freight = order.FreightAmount.ToString();
newOrder.OrderHead.goodsValue = order.ProductAmount.ToString();
newOrder.OrderHead.idType = "1";
newOrder.OrderHead.ieType = "I";
newOrder.OrderHead.modifyMark = "1";
newOrder.OrderHead.note = "";
newOrder.OrderHead.orderNo = order.SysNo.ToString();
newOrder.OrderHead.other = "";
newOrder.OrderHead.shipper = BLL.Stores.StoresBo.Instance.GetStoreById(0).ErpName;
newOrder.OrderHead.shipperAddress = "";
newOrder.OrderHead.shipperCountry = "142";
newOrder.OrderHead.shipperTelephone = "";
newOrder.OrderHead.tax = order.TaxFee.ToString();
newOrder.OrderHead.totalLogisticsNo = "";
newOrder.OrderHead.tradeCountry = "";
newOrder.OrderHead.wrapType = "";
foreach (SoOrderItem item in order.OrderItemList)
{
PdProduct product = BLL.Product.PdProductBo.Instance.GetProduct(item.SysNo);
PdProductStock productStock = BLL.Warehouse.PdProductStockBo.Instance.GetEntityByWP(order.DefaultWarehouseSysNo, item.ProductSysNo);
string brandName = "无";
PdBrand brand = BLL.Product.PdBrandBo.Instance.GetEntity(product.BrandSysNo);
if (brand != null)
{
brandName = brand.Name;
}
OrderList orderList = new OrderList();
orderList.barCode = "";
orderList.brand = brandName;
orderList.codeTs = "";
orderList.country = "";
orderList.currency = "142";
orderList.describe = "";
orderList.discount = "";
orderList.giftFlag = "";
orderList.goodsModel = "";
orderList.goodsName = item.ProductName;
orderList.goodsNo = productStock.ProductSku;
orderList.itemNo = "";
orderList.note = "";
orderList.packNum = "";
orderList.price = item.SalesUnitPrice.ToString();
orderList.priceTotal = item.SalesAmount.ToString();
orderList.purposeCode = "";
orderList.quantity = item.Quantity.ToString();
orderList.shelfGoodsName = item.ProductName;
orderList.taxCode = "";
orderList.unit = "007";
orderList.wasteMaterials = "1";
orderList.wrapType = "";
newOrder.OrderList.Add(orderList);
}
//newOrder.OrderPaymentLogistics.logisticsCode = "";
newOrder.OrderPaymentLogistics.logisticsName = deliveryType.DeliveryTypeName;
//newOrder.OrderPaymentLogistics.logisticsNo = "";
//newOrder.OrderPaymentLogistics.paymentCode = "";
//newOrder.OrderPaymentLogistics.paymentName = "";
//newOrder.OrderPaymentLogistics.paymentNo = "";
//newOrder.OrderPaymentLogistics.paymentType = "";
//newOrder.OrderPaymentLogistics.trackNo = "";
XmlSerializerNamespaces xmlNs = new XmlSerializerNamespaces();
xmlNs.Add("nousexmlns", "http://www.chinaport.gov.cn/ecss");
string xmlData = this.XmlSerialize <EasycrossOrder>(newOrder, xmlNs);
xmlData = xmlData.Replace(":nousexmlns", "");
xmlData = xmlData.Replace("encoding=\"utf-16\"", "encoding=\"utf-8\"");
// 上传文件
FtpUtil ftp = new FtpUtil(FTPUri, FTPName, FTPPassword);
string ftpResponse = "";
ftp.UploadFile(FTPUri, "Testfilename.xml", Encoding.UTF8.GetBytes(xmlData), out ftpResponse);
}
catch (Exception ex)
{
result.Message = "向" + this.Code + "物流推送订单报错：" + ex.StackTrace;
return(result);
}
return(result);
}
/// <summary>
/// 添加交易订单
/// </summary>
/// <param name="orderSysno"></param>
/// <returns>2016-04-09 陈海裕 创建</returns>
public override Result AddOrderTrade(int orderSysno)
{
// 订单id，用于日志记录
_orderSysNo = orderSysno;
Result result = new Result();
result.Status = false;
result.StatusCode = 0;
result.Message = "接口调用失败";
if (orderSysno <= 0)
{
return(result);
}
lock (lockHelper)
{
try
{
SoOrder order = BLL.Order.SoOrderBo.Instance.GetEntity(orderSysno);
if (order == null)
{
result.Message = "该订单不存在";
return(result);
}
if (order.CBLogisticsSendStatus == 1)
{
result.Message = "该订单已推送，不能重复操作";
return(result);
}
order.ReceiveAddress = BLL.Order.SoOrderBo.Instance.GetOrderReceiveAddress(order.ReceiveAddressSysNo);
order.OrderItemList = DataAccess.Order.ISoOrderItemDao.Instance.GetOrderItemsByOrderSysNo(order.SysNo);
ParaVoucherFilter voucherFilter = new ParaVoucherFilter();
voucherFilter.SourceSysNo = order.SysNo;
CBFnReceiptVoucher recVoucher = BLL.Finance.FinanceBo.Instance.GetReceiptVouchers(voucherFilter).Rows.FirstOrDefault();
recVoucher.VoucherItems = BLL.Finance.FnReceiptVoucherBo.Instance.GetReceiptVoucherItem(recVoucher.SysNo);
// 收货人 区 市 省
BsArea receiverDistrict = BLL.Basic.BasicAreaBo.Instance.GetArea(order.ReceiveAddress.AreaSysNo);
BsArea receiverCity = BLL.Basic.BasicAreaBo.Instance.GetArea(receiverDistrict.ParentSysNo);
BsArea receiverProvince = BLL.Basic.BasicAreaBo.Instance.GetArea(receiverCity.ParentSysNo);
// 发货人 市
CBWhWarehouse warehouse = BLL.Warehouse.WhWarehouseBo.Instance.GetWarehouse(order.DefaultWarehouseSysNo);
BsArea shipperCity = BLL.Basic.BasicAreaBo.Instance.GetArea(warehouse.CitySysNo);
DsDealer dealer = BLL.Distribution.DsDealerBo.Instance.GetDsDealer(order.DealerSysNo);
LgDeliveryType deliveryType = BLL.Logistics.DeliveryTypeBo.Instance.GetDeliveryType(order.DeliveryTypeSysNo);
EDTOrder newOrder = new EDTOrder();
newOrder.Address1 = order.ReceiveAddress.StreetAddress;
//newOrder.Base_ChannelInfoID = "1";
newOrder.Base_ChannelInfoID = "HKKJ";
newOrder.City = receiverCity.AreaName;
newOrder.ConsigneeName = order.ReceiveAddress.Name;
newOrder.Contact = !string.IsNullOrWhiteSpace(order.ReceiveAddress.MobilePhoneNumber) ? order.ReceiveAddress.MobilePhoneNumber : order.ReceiveAddress.PhoneNumber;
newOrder.Country = "CN";
newOrder.CusRemark = order.Remarks;
newOrder.GFF_CustomerID = CoustomerID;
newOrder.OrderStatus = "3";
newOrder.State = receiverProvince.AreaName;
newOrder.Style = "1";
//newOrder.ShippingService = "GZBC";
List <EDTOrderProduct> productList = new List <EDTOrderProduct>();
EDTOrderProduct product = null;
foreach (var item in order.OrderItemList)
{
PdProductStock productStock = BLL.Warehouse.PdProductStockBo.Instance.GetEntityByWP(order.DefaultWarehouseSysNo, item.ProductSysNo);
product = new EDTOrderProduct();
product.CnName = item.ProductName;
product.EnName = "";
product.MaterialRefNo = TConvert.ToString(productStock.ProductSku);
product.Price = item.SalesUnitPrice.ToString();
product.Quantity = item.Quantity.ToString();
product.Weight = "";
product.WarehouseID = warehouse.LogisWarehouseCode;
productList.Add(product);
}
if (product == null)
{
result.Message = "订单明细不存在";
return(result);
}
StringBuilder strorderinfo = new StringBuilder();
strorderinfo.Append("Style:" + newOrder.Style + ";");
strorderinfo.Append("GFF_CustomerID:" + newOrder.GFF_CustomerID + ";");
strorderinfo.Append("GFF_ReceiveSendAddressID:;");
strorderinfo.Append("ConsigneeName:" + newOrder.ConsigneeName + ";");
strorderinfo.Append("Country:" + newOrder.Country + ";");
strorderinfo.Append("Base_ChannelInfoID:" + newOrder.Base_ChannelInfoID + ";");
strorderinfo.Append("State:" + newOrder.State + ";");
strorderinfo.Append("City:" + newOrder.City + ";");
strorderinfo.Append("OrderStatus:" + newOrder.OrderStatus + ";");
strorderinfo.Append("Address1:" + newOrder.Address1 + ";");
strorderinfo.Append("Address2:;");
strorderinfo.Append("CsRefNo:;");
strorderinfo.Append("Zipcode:;");
strorderinfo.Append("Contact:" + newOrder.Contact + ";");
strorderinfo.Append("CusRemark:" + newOrder.CusRemark + ";");
strorderinfo.Append("TrackingNo:;");
//strorderinfo.Append("ShippingService:" + newOrder.ShippingService + ";");
StringBuilder strorderproduct = new StringBuilder();
for (int i = 0; i < productList.Count; i++)
{
strorderproduct.Append("MaterialRefNo:" + productList[i].MaterialRefNo + ",");
//strorderproduct.Append("MaterialRefNo:123456,");
strorderproduct.Append("Quantity:" + productList[i].Quantity + ",");
strorderproduct.Append("Price:" + productList[i].Price + ",");
strorderproduct.Append("Weight:" + productList[i].Weight + ",");
strorderproduct.Append("EnName:" + productList[i].EnName + ",");
strorderproduct.Append("WarehouseID:" + productList[i].WarehouseID + ",");
strorderproduct.Append("ProducingArea:,");
productList[i].CnName = Regex.Replace(productList[i].CnName, @"[/\(\)（）,]", "");
strorderproduct.Append("CnName:" + productList[i].CnName + ",;");
}
ServiceRefEightDT.APIWebServiceSoapClient newService = new ServiceRefEightDT.APIWebServiceSoapClient();
string strResult = newService.InsertUpdateOrder(strorderinfo.ToString(), strorderproduct.ToString(), "", Secretkey);
if (strResult.Contains("成功"))
{
try
{
CrossBorderLogisticsOrder cbOrder = BLL.CrossBorderLogistics.CrossBorderLogisticsOrderBo.Instance.GetEntityByOrderSysNo(orderSysno);
if (cbOrder == null)
{
Model.CrossBorderLogisticsOrder logisticsOrder = new Model.CrossBorderLogisticsOrder();
logisticsOrder.SoOrderSysNo = orderSysno;
logisticsOrder.LogisticsOrderId = Regex.Match(strResult, "[a-zA-Z0-9]+").ToString();
logisticsOrder.LogisticsCode = (int)this.Code;
BLL.CrossBorderLogistics.CrossBorderLogisticsOrderBo.Instance.InsertEntity(logisticsOrder);
}
// 更新订单状态
BLL.Order.SoOrderBo.Instance.UpdateOrderApiStatus(1, 3, orderSysno);
}
catch (Exception ex)
{
BLL.Log.SysLog.Instance.Error(LogStatus.系统日志来源.后台, "订单" + orderSysno + "保存跨境物流返回的单号失败。", ex);
}
result.Status = true;
}
result.Message = strResult;
}
catch (Exception ex)
{
result.Message = "向" + this.Code + "物流推送订单报错：" + ex.StackTrace;
return(result);
}
}
return(result);
}
/// <summary>
/// 添加交易订单
/// </summary>
/// <param name="orderId">销售订单系统编号</param>
/// <returns></returns>
/// <remarks></remarks>
/// <remarks>2016-3-8 杨浩 创建</remarks>
/// <remarks>2016-09-22 周 重构</remarks>
public override Result AddOrderTrade(int orderId)
{
var result = new Result()
{
Status = false,
StatusCode = 0,
Message = "向" + this.Code + "物流推送订单失败"
};
#region
try
{
var order = Hyt.BLL.Order.SoOrderBo.Instance.GetEntity(orderId);
if (order == null)
{
result.Status = false;
result.Message = string.Format("订单号{0}不存在！", orderId);
result.StatusCode = -100;
}
order.ReceiveAddress = BLL.Order.SoOrderBo.Instance.GetOrderReceiveAddress(order.ReceiveAddressSysNo);
order.OrderItemList = DataAccess.Order.ISoOrderItemDao.Instance.GetOrderItemsByOrderSysNo(order.SysNo);
var filter = new ParaOnlinePaymentFilter();
filter.OrderSysNo = orderId;
var onlinePayment = BLL.Finance.FinanceBo.Instance.GetOnlinePayments(filter).Rows.Where(o => o.Status == 1).FirstOrDefault();
if (onlinePayment == null)
{
result.Message = "订单不存在在线支付记录";
return(result);
}
// 收货人 区 市 省
BsArea receiverDistrict = BLL.Basic.BasicAreaBo.Instance.GetArea(order.ReceiveAddress.AreaSysNo);
BsArea receiverCity = BLL.Basic.BasicAreaBo.Instance.GetArea(receiverDistrict.ParentSysNo);
BsArea receiverProvince = BLL.Basic.BasicAreaBo.Instance.GetArea(receiverCity.ParentSysNo);
// 发货人 市
CBWhWarehouse warehouse = BLL.Warehouse.WhWarehouseBo.Instance.GetWarehouse(order.DefaultWarehouseSysNo);
BsArea shipperCity = BLL.Basic.BasicAreaBo.Instance.GetArea(warehouse.CitySysNo);
DsDealer dealer = BLL.Distribution.DsDealerBo.Instance.GetDsDealer(order.DealerSysNo);
LgDeliveryType deliveryType = BLL.Logistics.DeliveryTypeBo.Instance.GetDeliveryType(order.DeliveryTypeSysNo);
var newOrder = new CreatedOrderApiRequest();
newOrder.OutOrderNo = order.SysNo.ToString();
newOrder.DeliveryCode = "3";//暂时默认1（后期此参数作废）
newOrder.ReceiverName = TConvert.ToString(order.ReceiveAddress.Name);
newOrder.ReceiverMobile = !string.IsNullOrWhiteSpace(order.ReceiveAddress.MobilePhoneNumber) ? order.ReceiveAddress.MobilePhoneNumber : order.ReceiveAddress.PhoneNumber;
newOrder.ReceiverProvince = TConvert.ToString(receiverProvince.AreaName).Trim();
newOrder.ReceiverCity = TConvert.ToString(receiverCity.AreaName).Trim();
newOrder.ReceiverDistrict = TConvert.ToString(receiverDistrict.AreaName).Trim();
newOrder.ReceiverAddress = TConvert.ToString(order.ReceiveAddress.StreetAddress).Trim();
newOrder.ReceiverIdCard = TConvert.ToString(order.ReceiveAddress.IDCardNo);
newOrder.ReceiverFrontIdCardImageUrl = HttpContext.Current.Request.Url.Host + TConvert.ToString(order.ReceiveAddress.IDCardImgs);
newOrder.ReceiverOppositeIdCardImageUrl = HttpContext.Current.Request.Url.Host + TConvert.ToString(order.ReceiveAddress.IDCardImgs);
newOrder.UserRemark = order.Remarks;
newOrder.ThirdPlatformPaymentName = Enum.GetName(typeof(Hyt.Model.CommonEnum.PayCode), order.PayTypeSysNo);
var payment = Hyt.BLL.Finance.FinanceBo.Instance.GetOnlinePaymentBySourceSysNo(orderId);
string PaymentNumber = "";
if (payment != null)
{
PaymentNumber = payment.VoucherNo;
}
newOrder.ThirdPlatformPaymentNumber = PaymentNumber;
newOrder.Items = new List <CreatedOrderItemRequest>();
CreatedOrderItemRequest orderItem = new CreatedOrderItemRequest();
foreach (var item in order.OrderItemList)
{
var product = BLL.Product.PdProductBo.Instance.GetProductNoCache(item.ProductSysNo);
orderItem.SkuId = product.ErpCode;
orderItem.Quantity = item.Quantity;
newOrder.Items.Add(orderItem);
}
var json = Newtonsoft.Json.JsonConvert.SerializeObject(newOrder);
//推送订单
var _result = CreatedOrder(newOrder);
if (_result.ResultCode == 200)
{
var soOrderSyncLogisticsLog = new SoOrderSyncLogisticsLog();
soOrderSyncLogisticsLog.OrderSysNo = orderId;
soOrderSyncLogisticsLog.Code = (int)this.Code;
soOrderSyncLogisticsLog.LastUpdateDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
soOrderSyncLogisticsLog.StatusCode = "";
soOrderSyncLogisticsLog.StatusMsg = "";
soOrderSyncLogisticsLog.Packets = json;
soOrderSyncLogisticsLog.ReceiptContent = _result.Tag.ToString();
soOrderSyncLogisticsLog.LastUpdateBy = 0;
soOrderSyncLogisticsLog.LogisticsOrderId = "";
soOrderSyncLogisticsLog.CreateDate = DateTime.Now;
soOrderSyncLogisticsLog.CreatedBy = BLL.Authentication.AdminAuthenticationBo.Instance.Current.Base.SysNo;
SoOrderSyncLogisticsLogBo.Instance.Insert(soOrderSyncLogisticsLog);
BLL.Order.SoOrderBo.Instance.UpdateOrderApiStatus(1, 3, orderId);
result.Message = "向" + this.Code + "物流推送订单成功：回执单号：" + _result.Tag.ToString();
}
else
{
result.Message = _result.Message;
}
}
catch (Exception ex)
{
result.Message = "向" + this.Code + "物流推送订单报错：" + ex.StackTrace;
return(result);
}
#endregion
return(result);
}
/// <summary>
/// 创建配送方式
/// </summary>
/// <param name="model">配送方式实体</param>
/// <returns>创建的配送方式SysNo</returns>
/// <remarks>
/// 2013-06-13 郑荣华 创建
/// </remarks>
public override int Create(LgDeliveryType model)
{
return(Context.Insert("LgDeliveryType", model)
.AutoMap(x => x.SysNo)
.ExecuteReturnLastId <int>("SysNo"));
}
/// <summary>
/// 添加交易订单
/// </summary>
/// <param name="orderSysno"></param>
/// <returns>
/// 2016-04-09 陈海裕 创建
/// 2016-08-20 杨浩 重构
/// </returns>
public override Result AddOrderTrade(int orderSysno)
{
LogisticsLogin();
var result = new Result <string>();
result.Status = false;
result.StatusCode = 0;
result.Message = "接口调用失败";
string url = RequestUrl + "Express/uploadOrders";
if (orderSysno <= 0)
{
return(result);
}
try
{
var order = BLL.Order.SoOrderBo.Instance.GetEntity(orderSysno);
if (order == null)
{
result.Message = "该订单不存在";
return(result);
}
order.ReceiveAddress = BLL.Order.SoOrderBo.Instance.GetOrderReceiveAddress(order.ReceiveAddressSysNo);
order.OrderItemList = DataAccess.Order.ISoOrderItemDao.Instance.GetOrderItemsByOrderSysNo(order.SysNo);
var voucherFilter = new ParaVoucherFilter();
voucherFilter.SourceSysNo = order.SysNo;
var recVoucher = BLL.Finance.FinanceBo.Instance.GetReceiptVouchers(voucherFilter).Rows.FirstOrDefault();
recVoucher.VoucherItems = BLL.Finance.FnReceiptVoucherBo.Instance.GetReceiptVoucherItem(recVoucher.SysNo);
// 收货人 区 市 省
BsArea receiverDistrict = BLL.Basic.BasicAreaBo.Instance.GetArea(order.ReceiveAddress.AreaSysNo);
BsArea receiverCity = BLL.Basic.BasicAreaBo.Instance.GetArea(receiverDistrict.ParentSysNo);
BsArea receiverProvince = BLL.Basic.BasicAreaBo.Instance.GetArea(receiverCity.ParentSysNo);
// 发货人 市
CBWhWarehouse warehouse = BLL.Warehouse.WhWarehouseBo.Instance.GetWarehouse(order.DefaultWarehouseSysNo);
BsArea shipperDistrict = BLL.Basic.BasicAreaBo.Instance.GetAreaList(warehouse.CitySysNo).FirstOrDefault();
BsArea shipperCity = BLL.Basic.BasicAreaBo.Instance.GetArea(warehouse.CitySysNo);
BsArea shipperProvince = BLL.Basic.BasicAreaBo.Instance.GetArea(warehouse.ProvinceSysNo);
DsDealer dealer = BLL.Distribution.DsDealerBo.Instance.GetDsDealer(order.DealerSysNo);
LgDeliveryType deliveryType = BLL.Logistics.DeliveryTypeBo.Instance.GetDeliveryType(order.DeliveryTypeSysNo);
ParaOnlinePaymentFilter filter = new ParaOnlinePaymentFilter();
filter.OrderSysNo = orderSysno;
var onlinePayment = BLL.Finance.FinanceBo.Instance.GetOnlinePayments(filter).Rows.Where(o => o.Status == 1).FirstOrDefault();
Regex regex = new Regex("\t|\n|\r");
OrderList newOrderList = new OrderList();
newOrderList.PrintType = "@1,@2";
newOrderList.list = new List <LGOrder>();
LGOrder newOrder = new LGOrder();
newOrder.Addr = "中国," + receiverProvince.AreaName + "," + receiverCity.AreaName + "," + receiverDistrict.AreaName + "," + order.ReceiveAddress.StreetAddress;
newOrder.Addr = regex.Replace(newOrder.Addr, "");
newOrder.CardNo = order.ReceiveAddress.IDCardNo;
newOrder.Create_Addr = "中国," + shipperProvince.AreaName + "," + shipperCity.AreaName + "," + shipperDistrict.AreaName + ",";
newOrder.Create_Addr = regex.Replace(newOrder.Create_Addr, "");
newOrder.Create_CardNo = "";
newOrder.Create_Name = "澳门爱勤";
newOrder.Create_Phone = !string.IsNullOrWhiteSpace(dealer.MobilePhoneNumber) ? dealer.MobilePhoneNumber : dealer.PhoneNumber;
newOrder.id = order.SysNo.ToString();
newOrder.Name = order.ReceiveAddress.Name;
newOrder.OrderType = "A";
newOrder.PayCardNo = order.ReceiveAddress.IDCardNo;
newOrder.PayCurrency = "CNY";
newOrder.PayName = order.ReceiveAddress.Name;
newOrder.PayNo = recVoucher.VoucherItems[0].VoucherNo;
newOrder.PayPhone = !string.IsNullOrWhiteSpace(order.ReceiveAddress.MobilePhoneNumber) ? order.ReceiveAddress.MobilePhoneNumber : order.ReceiveAddress.PhoneNumber;
newOrder.PayRemark = "";
newOrder.PayTime = order.CreateDate.ToString();
newOrder.PayType = GetPayType(order.PayTypeSysNo);// "alipay";
newOrder.PayUser = order.CustomerSysNo.ToString();
newOrder.Phone = newOrder.PayPhone;
newOrder.Price = order.OrderAmount;
newOrder.Remark = order.DeliveryRemarks;
newOrder.TaxFee = order.TaxFee;
newOrder.TranFee = order.FreightAmount;
newOrder.Content = "";
foreach (var item in order.OrderItemList)
{
var productStock = BLL.Warehouse.PdProductStockBo.Instance.GetEntityByWP(order.DefaultWarehouseSysNo, item.ProductSysNo);
newOrder.Content += productStock.Barcode + "," + item.Quantity + "," + item.SalesUnitPrice + "|";
}
if (!string.IsNullOrWhiteSpace(newOrder.Content))
{
newOrder.Content = newOrder.Content.Substring(0, newOrder.Content.Length - 1);
}
newOrderList.list.Add(newOrder);
Dictionary <string, string> paramsData = new Dictionary <string, string>();
paramsData.Add("token", IdentifyPass);
paramsData.Add("postdata", Util.Serialization.JsonUtil.ToJson(newOrderList));
string postData = InitParams(paramsData);
string responseStr = GetResponse(url, postData);
var jObject = JObject.Parse(responseStr);
var soOrderSyncLogisticsLog = new SoOrderSyncLogisticsLog();
soOrderSyncLogisticsLog.OrderSysNo = orderSysno;
soOrderSyncLogisticsLog.Code = (int)this.Code;
soOrderSyncLogisticsLog.LastUpdateDate = (DateTime)System.Data.SqlTypes.SqlDateTime.MinValue;
soOrderSyncLogisticsLog.StatusCode = "";
soOrderSyncLogisticsLog.StatusMsg = "";
soOrderSyncLogisticsLog.Packets = postData;
soOrderSyncLogisticsLog.ReceiptContent = responseStr;
string status = jObject["status"].ToString();
if (status == "-1")
{
result.Status = false;
result.Message = "未登录，请重试！";
IdentifyPass = string.Empty;//清空身份凭证
}
else if (status == "1")
{
for (int i = 0; i < jObject["data"].Count(); i++)
{
if (jObject["data"][i]["status"].ToString() == "1")
{
soOrderSyncLogisticsLog.LastUpdateBy = 0;
soOrderSyncLogisticsLog.LogisticsOrderId = jObject["data"][i]["id"].ToString();
soOrderSyncLogisticsLog.CreateDate = DateTime.Now;
soOrderSyncLogisticsLog.CreatedBy = BLL.Authentication.AdminAuthenticationBo.Instance.Current.Base.SysNo;
SoOrderSyncLogisticsLogBo.Instance.Insert(soOrderSyncLogisticsLog);
BLL.Order.SoOrderBo.Instance.UpdateOrderApiStatus((int)Hyt.Model.WorkflowStatus.OrderStatus.跨境物流推送状态.已推送, 3, orderSysno);
result.Status = true;
result.Message = "推单成功";
}
else
{
soOrderSyncLogisticsLog.CreateDate = DateTime.Now;
SoOrderSyncLogisticsLogBo.Instance.Insert(soOrderSyncLogisticsLog);
result.Status = false;
result.Message = jObject["data"][i]["message"].ToString();
}
}
}
else
{
try
{
SoOrderSyncLogisticsLogBo.Instance.Insert(soOrderSyncLogisticsLog);
}
catch { }
result.Status = false;
result.Message = jObject["message"].ToString();
}
}
catch (Exception ex)
{
result.Message = "向" + this.Code + "物流推送订单报错：" + ex.StackTrace;
return(result);
}
return(result);
}
/// <summary> /// 更新配送方式 /// </summary> /// <param name="model">配送方式实体，根据sysno</param> /// <returns>受影响的行数</returns> /// <remarks> /// 2013-06-13 郑荣华 创建 /// </remarks> public abstract int Update(LgDeliveryType model);
/// <summary> /// 创建配送方式 /// </summary> /// <param name="model">配送方式实体</param> /// <returns>创建的配送方式sysNo</returns> /// <remarks> /// 2013-06-13 郑荣华 创建 /// </remarks> public abstract int Create(LgDeliveryType model);
