易截截图软件、单文件、免安装、纯绿色、仅160KB

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/


相关文档:

XML文档的显示 CSS

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与通信的入门级实例教程。通过本例的学习,我们将了解使用XML开发Flash RIAs的基本流程。
从Flash Player 5开始,就可以使用XML对象来实现Flash与后台通信。Flash浏览器与XML数据之间的直接进行数据交换,并且同LoadVars函数一样,都是以字符串形式传递的。后台语言作为XML数据和数据库 ......

XML技术讲解


 
 什么是XML?
XML 代表Extensible Markup Language(eXtensible Markup Language的缩写,意为可扩展的标
记语言)。XML是一套定义语义标记的规则,这些标记将文档分成许多部件并对这些部件加以标识。
它也是元标记语言,即定义了用于定义其他与特定领域有关的、语义的、结构化的标记语言的句法语言。
&n ......

XStream 非常简单实用的XML读写工具(一)

最近工作内容需要对Java对象做XML输出,公司里常用的两种框架是XStream和XML Beans。两种都我都用了,对于普通的,schema不是很复杂的XML文件来说选择XStream更方便。这篇文章先介绍一下XStream的用法,XML Beans的用法另外再介绍。
1. 先给个要输出的xml文档的例子:
<students>
<student>
&l ......

linq to xml(MOSS GetCurrentUser)

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 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号