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);
}
