public void AddExpressAndUpdatePackage(DPCreateOrderResponse response, Entity.PackageInfo package)
{
string sql = string.Format(@"INSERT INTO dbo.WMS_ExpressDelivery
(
CustomerID,CustomerName,WarehouseID,WarehouseName,OID,OrderNumber,ExternOrderNumber,
ExpressNumber,ExpressCompany,PackageNumber,
Status,
success,code,mailNo,txLogisticID,arrivedOrgSimpleName,reason,uniquerRequestNumber,parentMailNo,
Creator,CreateTime
)
SELECT
CustomerID,CustomerName,3,Warehouse,OID,OrderNumber,ExternOrderNumber,
'{0}','德邦',PackageNumber,
0,
'{1}','{2}','{0}','{3}','{4}','{5}','{6}','{7}',
'德邦',GETDATE()
FROM dbo.WMS_Package WHERE PackageNumber='{8}';
--更新包装快递信息
UPDATE dbo.WMS_Package SET ExpressCompany='德邦',ExpressNumber='{0}' WHERE PackageNumber='{8}';
--更新订单主表快递
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='{8}')) p
WHERE o.ID=p.OID;
SELECT TOP 1000 * FROM dbo.WMS_ExpressDelivery WHERE ID=@@IDENTITY;",
package.ExpressNumber, response.result, response.resultCode, response.logisticID, response.arrivedOrgSimpleName,
response.reason, response.uniquerRequestNumber, response.parentMailNo, package.PackageNumber);
base.ExecuteNoQueryBySqlString(sql);
}
public void AddExpressAndUpdatePackage(DPCreateOrderResponse response, IEnumerable <Entity.PackageInfo> packages)
{
try
{
ExpressAccessor accessor = new ExpressAccessor();
packages.ForEach(item => accessor.AddExpressAndUpdatePackage(response, item));
}
catch (Exception ex)
{
}
}
