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