xml ÐÎʽµÄ´æ´¢¹ý³Ì

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
create procedure [dbo].[MachiningPayedGetListByCondition]
@CustomerName varchar(50),
@CustomerPhone varchar(50),
@PactNumber varchar(50),
@Ispay bit
as
begin
 set nocount on;
 SELECT
 dp.ID as 'MachiningPayed/@ID',
        Orders.ID AS 'MachiningPayed/Order/@ID',
  -- Task --
  Orders.Task AS 'MachiningPayed/Order/Task/@ID',
  Tasks.OrderState as 'MachiningPayed/Order/Task/OrderState',
  Tasks.UpdateDate as 'MachiningPayed/Order/Task/UpdateDate',
  Tasks.CustomerName as 'MachiningPayed/Order/Task/CustomerName',
  Tasks.CustomerPhone as 'MachiningPayed/Order/Task/CustomerPhone',
  Tasks.CellPhone as 'MachiningPayed/Order/Task/CellPhone',
  Tasks.CustomerAddress as 'MachiningPayed/Order/Task/CustomerAddress',
  Tasks.ForemanName as 'MachiningPayed/Order/Task/ForemanName',
  Tasks.MonitorName as 'MachiningPayed/Order/Task/MonitorName',
  Tasks.DesignerName as 'MachiningPayed/Order/Task/DesignerName',
  Tasks.Store as 'MachiningPayed/Order/Task/Store',
  Tasks.PactNumber as 'MachiningPayed/Order/Task/PactNumber',
  Tasks.CreateDate as 'MachiningPayed/Order/Task/CreateDate',
  Tasks.PlanDisclosureDate as 'MachiningPayed/Order/Task/PlanDisclosureDate',
  Tasks.PlanHiddenCheckDate as 'MachiningPayed/Order/Task/PlanHiddenCheckDate',
  Tasks.PlanMidCheckDate as 'MachiningPayed/Order/Task/PlanMidCheckDate',
  Tasks.PlanEndCheckDate as 'MachiningPayed/Order/Task/PlanEndCheckDate',
  -- Task End--
  Orders.PactNumber AS 'MachiningPayed/Order/PactNumber',
  Orders.CustomerName AS 'MachiningPayed/Order/CustomerName',
  Orders.CustomerPhone AS 'MachiningPayed/Order/CustomerPhone',
  Orders.CellPhone AS 'MachiningPayed/