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文件由于其扩展性与兼容性的优点,被广泛用作软件和系统的配置文件。这里简要介绍一下QT下如何来解析XML文件。
源代码:
xml_reader.h
#ifndef XML_READER_H
#define XML_READER_H
#include <QtCore>
//#include <QtGui>
class xml_reader : public QXmlStreamReader
{
//Q_OBJECT
public:
......
XmlDocument xmlDoc = new XmlDocument();
xmlDoc.Load(@"E:\大二下\xml\province.xml");
会提示出现以下错误
http://hi.csdn.net/attachment/201005/24/0_1274703276Ld6I.gif
麻烦各位帮忙看看,谢谢了 ......
private void CreateNewXmlNode()
{
String strFileName = string.Empty;
strFileName = this.strCurrentPath + "System.xml";
XmlDocument xmlDoc = new XmlDocument();
try
{
xmlDoc.Load(strFileName);
......
红色字体为主要代码
jsp页面中
<script language="javascript">
function updateDB(operate){
var objDom=new ActiveXObject("msxml.DomDocument");
var objRoot=objDom.createElement("All");
objDom.appendChild(objRoot);
var k=document.ge ......