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/
相关文档:
Product.xml
<?xml version="1.0" encoding="utf-8"?>
<?xml-stylesheet type="text/css" href="product.css" ?>
<productata>
<product prodid="p001" category="toy">
<productname>Mini Bus</productname>
<description>This is a toy for childern aged 4 and above&l ......
这是一篇讲解如何使用XML实现Flash与通信的入门级实例教程。通过本例的学习,我们将了解使用XML开发Flash RIAs的基本流程。
从Flash Player 5开始,就可以使用XML对象来实现Flash与后台通信。Flash浏览器与XML数据之间的直接进行数据交换,并且同LoadVars函数一样,都是以字符串形式传递的。后台语言作为XML数据和数据库 ......
什么是XML?
XML 代表Extensible Markup Language(eXtensible Markup Language的缩写,意为可扩展的标
记语言)。XML是一套定义语义标记的规则,这些标记将文档分成许多部件并对这些部件加以标识。
它也是元标记语言,即定义了用于定义其他与特定领域有关的、语义的、结构化的标记语言的句法语言。
&n ......
最近工作内容需要对Java对象做XML输出,公司里常用的两种框架是XStream和XML Beans。两种都我都用了,对于普通的,schema不是很复杂的XML文件来说选择XStream更方便。这篇文章先介绍一下XStream的用法,XML Beans的用法另外再介绍。
1. 先给个要输出的xml文档的例子:
<students>
<student>
&l ......
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Microsoft.SharePoint;
using Microsoft.SharePoint.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
using System.Xml;
using System.IO;
using System.Data;
using System.Dat ......