XSD文件格式

一、水晶报表可以直接使用这个文件作为数据源

 

 

<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="XMLSchema"
    targetNamespace="http://tempuri.org/XMLSchema.xsd"
    elementFormDefault="qualified"
    xmlns="http://tempuri.org/XMLSchema.xsd"
    xmlns:mstns="http://tempuri.org/XMLSchema.xsd"
    xmlns:xs="http://www.w3.org/2001/XMLSchema"
>

  <xs:element name="ReportDataFields" >
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="ProfileDonation">
          <xs:complexType>
            <xs:sequence>             
              <xs:element name="DonationNo"  type="xs:string" minOccurs="0" />
              <xs:element name="DonationDate"  type="xs:dateTime" minOccurs="0" />
              <xs:element name="CardholderName" type="xs:string" minOccurs="0" />
              <xs:element name="CreditCardNo"  type="xs:string" minOccurs="0" />
              <xs:element name="SumAmount" type="xs:double" minOccurs="0" />
              <xs:element name="TotalRecord"  type="xs:int" minOccurs="0" />
              <xs:element name="BankinDate"  type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="EventAttend">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="EventCode"  type="xs:string" minOccurs="0" />
              <xs:element name="ProfileNo"  type="xs:string" minOccurs="0" />
              <xs:element name="NameCN"  type="xs:string" minOccurs="0" />
              <xs:element name="NameEN"  type="xs:string" minOccurs="0" />
              <xs:element name="Address" type="xs:string" minOccurs="0" />
              <xs:element name="Position" type="xs:string" minOccurs="0" />
              <xs:element name="Department" type="xs:string" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>

      </xs:choice>
    </xs:complexType>
  </xs:element>
 
</xs:schema>

 

二、后台aspx调用代码

using System;using System.Collections.Generic;using System.Linq;using System.Text;using System.Web;using System.Web.UI;using System.Web.UI.WebControls;using CrystalDecisions.Shared;using CrystalDecisions.CrystalReports.Engine;using System.Data;using HOHCSCRM.Data;using HOHCSCRM.Data.ORM;using HOHCSCRM.Data.EDM;using HOHCSCRM.BUL;using HOHCSCRM.WebApp.Common;using HOHCSCRM.WebApp.Common.DataExtensions;using GlacierCLI.Extensions;namespace HOHCSCRM.WebApp.Pages.Report.CrystalReport{    public partial class ShowReport : System.Web.UI.Page    {        ReportDocument rptDocument = new ReportDocument();        private void Page_UnLoad(object sender, EventArgs e)        {            rptDocument.Dispose();        }        protected void Page_Load(object sender, EventArgs e)        {            string ReportType = Request["ReportType"].ToString();            string SelectIds = Request["SelectIds"] == null ? string.Empty : Request["SelectIds"].ToString();            string reportPath = string.Empty;            int PrintID = 0;            ReportDonationFilter filter = new ReportDonationFilter();            DataTable table = null;            switch (ReportType)            {                case "Diners":                    filter.ReportType = "Diners";                    filter.SelectIds = SelectIds;                    table = ReportSRV.BankProfile(filter);                    for (int i = 0; i < table.Rows.Count; i++)                    {                        table.Rows[i]["CreditCardNo"] = CommonMethod.GetCreditCardFormat(int.Parse(table.Rows[i]["PaymentMethodID"].ToString()), table.Rows[i]["CreditCardNo"].ToString());                    }                    reportPath = Server.MapPath("~/Pages/Report/CrystalReport/Diners.rpt");                    rptDocument.Load(reportPath);                    rptDocument.SetDataSource(table);                    rptView.ReportSource = rptDocument;                    break;                case "DonationCheque":                    #region  打印一次性捐款收據                    bool IsCopy = Request["IsCopy"].ToString() == "1" ? true : false;                    PrintID = int.Parse(Request["PrintID"].ToString());                    string ReceiptDate = Request["ReceiptDate"].ToString();                    List<ProfileDonationORM> profileDonaton = ReportSRV.GetDonationChequeList(SelectIds, IsCopy, ReceiptDate);                    var donationCheque = profileDonaton.Select(t =>                    {                        return new                        {                            t.ID,                            t.ProfileID,                            ProfileNo = t.GetProfileProfileNo(),                            ProfileNameCN = (t.Status == 3 ? t.ReceiptNameCN : GetProfileName(t.ReceiptOtherName, t.ProfileID, true)),                            ProfileNameEN = (t.Status == 3 ? t.ReceiptNameEN : GetProfileName(t.ReceiptOtherName, t.ProfileID, false)),                            Address = t.GetProfileAddress(),                            DonationNo = "(" + t.DonationNo + ")",                            t.ReceiptNo,                            ReceiptDate = t.ReceiptDate.ToDateString(),                            ThankyouLetter = string.IsNullOrWhiteSpace(t.GetThankyouLetterNameCN()) ? "" : "(" + t.GetThankyouLetterNameCN() + ")",                            Information = (t.Status == 3 ? t.ReceiptAddress : GetAddress(t.ProfileID, "", t.ReceiptOtherName, "1")),                            t.DonationAmount                        };                    });                    reportPath = Server.MapPath("~/Pages/Report/CrystalReport/DonationCheque.rpt");                    rptDocument.Load(reportPath);                    rptDocument.SetDataSource(donationCheque);                    if (!Page.IsPostBack)                    {                        foreach (var item in profileDonaton)                        {                            DataActionLogORM ActionLog = new DataActionLogORM();                            ActionLog.ObjectID = AppORMType.ProfileDonation;                            ActionLog.DataItemID = item.ID;                            ActionLog.ActionBy = HttpContextUtility.GetCurrentLoginUserID();                            ActionLog.ActionDescription = "列印收據";                            ActionLog.Remarks = (IsCopy ? "列印一次性捐款收據 (複印本)" : "列印一次性捐款收據 (正本)");                            CommonSRV.CreateActionLog(ActionLog);                        }                    }                    List<ProfileDonationDetailsEDM> profileDonatonDetails = ReportSRV.GetDonationChequeDetailsList(SelectIds);                    var DonationChequeDetails = profileDonatonDetails.Select(t =>                    {                        return new                        {                            t.ProfileDonationID,                            DonationDate = t.DonationDate,                            Event = t.EventNameCN,                            ServiceNature = t.ServiceNatureNameCN,                            DonationItem = t.DonationItemNameCN,                            PaymentMethod = t.GetPaymentNatureNameCN(),                            DonationAmount = t.Amount                        };                    });                    //明细                    IsCopy = !IsCopy;                    (rptDocument.ReportDefinition.ReportObjects["DetailsCopy"] as PictureObject).ObjectFormat.EnableSuppress = IsCopy;                    ReportDocument rtpDetails = (rptDocument.ReportDefinition.ReportObjects["ChequeDetails"] as SubreportObject).OpenSubreport((rptDocument.ReportDefinition.ReportObjects["ChequeDetails"] as SubreportObject).SubreportName);                    rtpDetails.SetDataSource(DonationChequeDetails);                    //第二页                    ReportDocument PageTwp = (rptDocument.ReportDefinition.ReportObjects["PageTwp"] as SubreportObject).OpenSubreport((rptDocument.ReportDefinition.ReportObjects["PageTwp"] as SubreportObject).SubreportName);                    (PageTwp.ReportDefinition.ReportObjects["txt_Content"] as TextObject).ObjectFormat.HorizontalAlignment = CrystalDecisions.Shared.Alignment.Justified;                    //rptDocument.Refresh();                    rptView.ReportSource = rptDocument;                    rptDocument.SetParameterValue("PrivacyText", "dd");                    break;                    #endregion            }        }    }}