public YtoRequest GetExpressNumYto(string PackageNumber) { YtoRequest ytoRequest = new YtoRequest(); try { StringBuilder sb = new StringBuilder(); //先获取订单信息 sb.Append(@" select top 1 *,(select top 1 ID from WMS_Warehouse where WMS_Warehouse.WarehouseName=WMS_Order.Warehouse ) WarehouseID from WMS_Package left join WMS_Order on WMS_Package.OID=WMS_Order.ID where WMS_Package.PackageNumber='" + PackageNumber + "'"); //获取订单明细 sb.Append(@" select * from WMS_PackageDetail where PackageNumber='" + PackageNumber + "'"); //获取发货地址 sb.Append(@" select top 1 * from WMS_Warehouse where WarehouseName =( select top 1 Warehouse from WMS_Package where PackageNumber='" + PackageNumber + @"') "); var data = this.ScanDataSet(sb.ToString()); ytoRequest.orderInfo = data.Tables[0].ConvertToEntity <OrderInfo>(); ytoRequest.orderDetailInfos = data.Tables[1].ConvertToEntityCollection <OrderDetailInfo>().ToList(); ytoRequest.warehouseInfo = data.Tables[2].ConvertToEntity <WarehouseInfo>(); } catch (Exception) { } return(ytoRequest); }
public Response <int> InsExpressNumYto(YtoRequest ytoRequest) { Response <int> response = new Response <int>() { Result = 0 }; try { response.Result = new ExpressAccessor().InsExpressNumYto(ytoRequest); response.IsSuccess = true; } catch (Exception ex) { LogError(ex); response.IsSuccess = false; response.ErrorCode = ErrorCode.Technical; } return(response); }
public int InsExpressNumYto(YtoRequest ytoRequest) { //YtoRequest ytoRequest = new YtoRequest(); try { StringBuilder sb = new StringBuilder(); //先获取订单信息 sb.Append(@" insert into WMS_ExpressDelivery ( [CustomerID],[CustomerName],[WarehouseID],[WarehouseName] ,[OID],[OrderNumber],[ExternOrderNumber],[ExpressNumber],[ExpressCompany],[PackageNumber] ,[Status],[success],[code],[logisticProviderID],[mailNo] ,[txLogisticID],[clientID],[shortAddress],[consigneeBranchCode],[packageCenterCode] ,[packageCenterName],[arrivedOrgSimpleName],[uniquerRequestNumber],[parentMailNo],[reason],originateOrgCode,printKeyWord ,[mn],[pcn],[rbc],[sbc],[ssc],[tsc],[Remark],[Creator],[CreateTime] ) values ( '" + ytoRequest.expressDelivery.CustomerID + @"', '" + ytoRequest.expressDelivery.CustomerName + @"', '" + ytoRequest.expressDelivery.WarehouseID + @"', '" + ytoRequest.expressDelivery.WarehouseName + @"', '" + ytoRequest.expressDelivery.OID + @"', '" + ytoRequest.expressDelivery.OrderNumber + @"', '" + ytoRequest.expressDelivery.ExternOrderNumber + @"', '" + ytoRequest.expressDelivery.ExpressNumber + @"', '" + ytoRequest.expressDelivery.ExpressCompany + @"', '" + ytoRequest.expressDelivery.PackageNumber + @"', '" + ytoRequest.expressDelivery.Status + @"', '" + ytoRequest.expressDelivery.success + @"', '" + ytoRequest.expressDelivery.code + @"', '" + ytoRequest.expressDelivery.logisticProviderID + @"', '" + ytoRequest.expressDelivery.mailNo + @"', '" + ytoRequest.expressDelivery.txLogisticID + @"', '" + ytoRequest.expressDelivery.clientID + @"', '" + ytoRequest.expressDelivery.shortAddress + @"', '" + ytoRequest.expressDelivery.consigneeBranchCode + @"', '" + ytoRequest.expressDelivery.packageCenterCode + @"', '" + ytoRequest.expressDelivery.packageCenterName + @"', '" + ytoRequest.expressDelivery.arrivedOrgSimpleName + @"', '" + ytoRequest.expressDelivery.uniquerRequestNumber + @"', '" + ytoRequest.expressDelivery.parentMailNo + @"', '" + ytoRequest.expressDelivery.reason + @"', '" + ytoRequest.expressDelivery.originateOrgCode + @"', '" + ytoRequest.expressDelivery.printKeyWord + @"', '" + ytoRequest.expressDelivery.mn + @"','" + ytoRequest.expressDelivery.pcn + @"','" + ytoRequest.expressDelivery.rbc + @"','" + ytoRequest.expressDelivery.sbc + @"','" + ytoRequest.expressDelivery.ssc + @"','" + ytoRequest.expressDelivery.tsc + @"','" + ytoRequest.expressDelivery.Remark + @"','" + ytoRequest.expressDelivery.Creator + @"','" + ytoRequest.expressDelivery.CreateTime + @"'); --更新包装快递信息 UPDATE dbo.WMS_Package SET ExpressCompany='" + ytoRequest.expressDelivery.ExpressCompany + @"',ExpressNumber='" + ytoRequest.expressDelivery.ExpressNumber + @"' WHERE PackageNumber='" + ytoRequest.expressDelivery.PackageNumber + @"'; --更新订单主表快递 UPDATE o SET o.ExpressCompany=p.ExpressCompany,o.ExpressNumber=p.ExpressNumber FROM dbo.WMS_Order o, (SELECT TOP 1 * FROM dbo.WMS_Package WHERE OrderNumber =(SELECT TOP 1 OrderNumber FROM dbo.WMS_Package WHERE PackageNumber='" + ytoRequest.expressDelivery.PackageNumber + @"')) p WHERE o.ID=p.OID; SELECT TOP 1000 * FROM dbo.WMS_ExpressDelivery WHERE ID=@@IDENTITY;"); var data = this.ScanExecuteNonQuery(sb.ToString()); if (data > 0) { return(1); } else { return(0); } } catch (Exception) { } return(0); }